Wed, Oct 16- 7th Grade- Spreadsheets- Using functions

Bellringer:
1.  The daily bellringers will now be practicing the number pad
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
Choose exercise 7 and then click on the word "start."
Record you typing speed and accuracy on the form.
You must have 98% or higher accuracy.
Short schedule today because of pep rally.
See board to left for schedule
2. Students, who went on the field trip
    see Miss W for your missing work

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

Guided Lesson: 
@Daily spreadsheet skill exercises
Open Spreadsheet Flashcard Exercise: 
9 Chart types and styles
on the Design tab click Change Chart Type
On your car lot spreadsheet complete the following functions:
UNHIDE the model column if necessary
 
To find the car with the most or maximum miles
=Max(D2:D16)
 
To find the car with the smallest or minimum miles
=Min(D2:D16)
 
To find the sum of all of the car prices 
=Sum(E2:E16)
 
To find the average year 
=Average(A2:A16)

Independent Activity:
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. 

Exit Activity:http://www.quia.com/rr/363962.html
Horizontal is like laying down flat on the ground.
Vertical is up and down
Play until you have won a million dollars.