Monday, April 28th- 7th Grade- Spreadsheets- Autofill and Relative Cell Referencing

Bellringer:
1. Get out of the crate your Chart Component Notes.
2. On page 382, type the paragraph that starts "Another simple formula..."

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:
@ Test this Thursday! You can practice the questions online at home or take home a pink study guide and/or the Review for Test Spreadsheet Vocabulary PowerPoint.
@ Working With Cell References in Excel 2010 http://www.gcflearnfree.org/excel2010/9.4
@ Open the 4.02 Chart Components PowerPoint

Independent Exercise:
@ Students will use
the Autofill feature (allows you to quickly fill in days of week or formulas) and
Relative Cell Referencing (copy formulas and automatically adjusts to correct cell range)
with the Blooming Bells Nursery file.  

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

@ Students will look at the Chart Components PowerPoint to Label the Chart Parts. http://compappssh.wikispaces.com/file/view/Notes.pdf

Exit Activity#1:
Click on the link Characteristics related to chart options   http://www.quia.com/mc/2016566.html
We have not discussed 1 term:
Chart Wizard: An on-screen guide that helps you prepare a chart

Exit Activity2:
Working by yourself and using the PINK Study Guide answer the questions.
These will be the next test questions.  
http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1

Exit Activity#3:
You need to get at least 70% correct. http://www.quia.com/quiz/2055803.html?AP_rand=106361813

Exit Activity#4:
http://www.purposegames.com/game/excel-chart-elements-quiz