Wed, Oct 23- 7th Grade- Spreadsheets- Relative Cell References

Bellringer:
1. Open your typing book to page 398 
    and type the paragraph "Create a Bar Chart"
2. Make up any number pad exercises 1-8 you are missing  
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html

What are we learning?
4.0 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: 
Vocabulary test is on MONDAY

Introduction to Relative References Video http://www.youtube.com/watch?v=Wli4L_tECPg

Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- choco nutties file

Examples of Relative and Absolute References http://www.youtube.com/watch?v=PFOe0TKnAuE

Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- blooming bells nursery file

Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder
then- rose variety file

Independent Activity:
Students will work individually to complete the Spreadsheet Ribbon worksheet

Exit Activity:
Work in groups of 2 or 3
http://www.quia.com/hm/174125.html
all words have been covered.