Monday, Oct 7: 7th Grade: Spreadsheets- Start Project

Bellringer:
1. Open your PowerPoint project.
2. Open up your Typing document
3. Turn to page 71 of your typing book.
4.  Type Line 2  alphabet review
5.  Turn to page 71 of your typing book.
6   Type Line 3  alphabet review  

Guided Lesson:
@ Open up the Spreadsheet Vocabulary PowerPoint file.
     Slides 21-23 (Range, Cell Reference, Sorting)

@ Ascending and Descending Sorting Activity
 
@ Cell Reference and Range Activity

 

Follow instructions to make a picture.

Make cell C5 to C8 yellow

Make D5 to D8 yellow

Make cell F5 to F8 yellow

Make cell G5 to G8 yellow

Now click on C6 make it black

Then F6 and make it black

Cell E11 green

Cell B12 B13 red

Cell I11 I12 red

Cell C14 red

Cell D15 red

Cell E16 red

Cell F15 red

Cell G14 red

Cell H13 red

Car lot exercise-  
1*Students will create a spreadsheet of dream cars
that they would have in their own car lot business.

2*Open the "car lot" file found in student docs,
Witkowski folder, Spreadsheet folder
and save to your lunch number. 

3*Students will go to http://www.carmax.com and
find 3 cars and type the information
(year, make(brand), model(name), miles, and price)
into their spreadsheets.

Exit Activity:
http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html