Bellringer- We are learning the number
keypad.
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
Choose exercise 2 and then click on the word “start.”
To hear bellringer message
Go to Student Docs- Witkowski- Spreadsheets-
SS flash cards- exercise 32 calculates averagehttp://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
Choose exercise 2 and then click on the word “start.”
To hear bellringer message
What are we learning today?
Inserting functions and Vocabulary review
4.3 Know Spreadsheet operations
Guided Lesson:
Daily
spreadsheet skill exercises-
Skill 32- calculates averages,
Skill 08- removes duplicates (on data tab and then sort),
Skill 14- merge cells
Open your hurricane file.
Skill 08- removes duplicates (on data tab and then sort),
Skill 14- merge cells
Open your hurricane file.
Instead of typing formulas we are going to use FUNCTIONS, which are shortcuts that are quicker than typing formulas in by hand.
We are going to practice inserting the following FUNCTIONS or shortcuts:
Sum- adds all of the numbers in a range
Max- finds the largest number in a range
Min- finds the lowest number in a range
Average- calculates the average of a range of numbers
Count- counts the numbers of entries in a range
Excel Home Ribbon Exercise
DO NOT
PRINT UNTIL MISS W SAYS OKSum- adds all of the numbers in a range
Max- finds the largest number in a range
Min- finds the lowest number in a range
Average- calculates the average of a range of numbers
Count- counts the numbers of entries in a range
Exit
Activity- SmartBoard
formative testing
of vocabulary
How much do you remember about Spreadsheets?
By yourself or with a partner take turns and play.
Today it is not a test, but it will be a test at the end of the Spreadsheet unit.
Make sure you click on VIEW RESULTS and stay on that page until Miss W checks it.
Miss W will draw names to see which students will play it on the Smartboard.
How much do you remember about Spreadsheets?
By yourself or with a partner take turns and play.
Today it is not a test, but it will be a test at the end of the Spreadsheet unit.
Make sure you click on VIEW RESULTS and stay on that page until Miss W checks it.
Miss W will draw names to see which students will play it on the Smartboard.
Rules for Wednesday's candy challenge.
1. All class work must be completed.
2. You work alone and quietly.
3. You do not get upset if you do not win.
4. Miss W is the final judge.
1. All class work must be completed.
2. You work alone and quietly.
3. You do not get upset if you do not win.
4. Miss W is the final judge.
No comments:
Post a Comment