Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-11-2017
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets-
Relative versus Absolute Cell Reference
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can create and explain the difference between a relative cell reference and an absolute cell reference.
Test Today
|
.Students can create and explain the difference between a relative cell reference and an absolute cell reference.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
The Entry bar or formula bar shows the active cell’s information.
It is sometimes called the formula bar because you can see the formula when you click on the active cell
Look at the black border around the active cell D8.
We are going to use the autofill today and it will allow you to quickly fill days of week or formulas.
Look at how the values (numbers) are aligned to the right margin.
Look at how the labels (words) are aligned to the left margin.
http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm
| |
Bell-Ringer/Connecting Strategy
| |
You need a pencil for test
Go to wclassroom
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
| Review for Test | |
|
Guided Practice:
@ Working With Cell References in Excel 2010 http://www.gcflearnfree.org/excel2010/9.4
stop at 3 minutes
@ Go to the Spreadsheet folder, then the Relative Cell Reference folder, then
Open Blooming Bells Nursery file
@ Right click on Sheet 2 worksheet tab and rename to Autofill
@ Right click and change the color on the tab
Autofill- allows you to quickly fill in days of the week.
@ Type in Monday then drag cursor down.
@ Type in January then drag cursor down.
@ Go to Sheet 1
@ Click on Cell F4
@ Type in = then click on Cell D4
@ Type * then click on Cell E4
@ Press enter and you will see the answer $29.75
Relative Cell Referencing- copies formulas and automatically adjusts to correct cell range.
@ Now click on the cell with $29.75
@ You will see the black border because it is an active cell.
@ Put your cursor in the lower right corner of the border and you will see a plus sign
@ Drag the plus sign down so it calculates the other answers.
Independent Exercise:
@ Students will take Spreadsheet Test
@ Students will participate in Cell Reference Candy Challenge
@ Working With Cell References in Excel 2010 http://www.gcflearnfree.org/excel2010/9.4
start at 3 minutes
Absolute cell referencing- formulas do NOT adjust or do NOT change.
For example- $C$12- column A does not change and row 2 does not change.
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder
then- rose variety file
If time: Introduction to Relative References Video http://www.youtube.com/watch?v=Wli4L_tECPg
@ Go to the Spreadsheet folder, then the Relative Cell Reference folder, then
Open choco nutties file
@ Create the formula making B2 an absolute cell reference, $B$2.
| |
Higher Order Thinking Questions
| |
What is the difference between a relative cell reference and an absolute cell reference?
| |
Student Technology/Differentiation
| |
Students will use Excel software to understand relative and absolute cell references.
| |
Closure Strategy
| |
Exit Activity #10:
You may use the Spreadsheet Vocabulary PowerPoint.
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
Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
| |
