 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-07-2016
|
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.
|
.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
| |
Go to wclassroom
Refresh your typing skills, complete exit activity 9 | |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Working With Cell References in Excel 2010 http://www.gcflearnfree.org/excel2010/9.4
start at 2 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.
Independent Exercise:
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder
then- rose variety file
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.
If time: Open 4 Practice Hiding Columns and Charts | |
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 #9:
Choose home row and easy. Turn off sound.
Exit Activity#10:
Working in pairs and using the PINK Study Guide answer the questions.
| |
No comments:
Post a Comment