Wednesday, March 26th- 7th Grade- Spreadsheets- Functions (short cuts)

Bellringer:
@ We are NOT using the typing book for several days.
We are learning the number keypad. 
The daily bellringers will now be practicing the number pad
http://www.typeonline.co.uk/number_pad_lesson1.html
Choose exercise 1 and then click on the word "start."
Time will not start until you put your cursor
 in the white rectangle and start typing.
Record you typing speed and accuracy in your typing file.
TEST ON FRIDAY- you can practice exit activity at home.

What are we learning?
4.00 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations

Guided Lesson: 
@ Open up the Spreadsheet Vocabulary PowerPoint file
     slides 37 and 38 Understanding Functions (Shortcuts)
@ Function as a shortcut example
@ What are functions? http://www.gcflearnfree.org/excel2010/10.2
@ Autosum button http://www.gcflearnfree.org/excel2010/10.4
@Depending on time several functions examples will be completed.
     ***Students will open the payroll file and by using functions
         find the following information:
         the maximum hourly rate
         the minimum hourly rate
         the sum of the hourly rates
         the average of the hourly rates
@ Spreadsheet flashcard 32 calculates averages
@ Additional function practice as needed.

Independent Activity:

@ Complete the function practice worksheet.
@Sign into Edmodo and add Miss W's Computer Group.
See board for Edmodo group number.
@Complete Exit Activity by yourself without any help.


Exit Activity:http://www.quia.com/rr/363962.html
We have not covered one question yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars.
http://edu.glogster.com/ 
Do NOT create a new id if you can not log in! We have a list with ids on it.