 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-21-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Functions and Vocabulary
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain the difference between a relative cell reference and an absolute cell reference.
|
Students use functions to get answers.
|
Literacy/Vocabulary Strategies (Word Wall)
|
What if we wanted to find the AVERAGE of a group of numbers?
What would the function look like?
https://www.flickr.com/photos/schoschie/2959139599/
|
Bell-Ringer/Connecting Strategy
|
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
@ Finish Hurricane spreadsheet
@ Slides 41 - 43
@ 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:
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
@@@ Students work in pairs on Exit Activity #11
@@@ Students critique PowerPoints
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
|
When and how should you use a function?
|
Student Technology/Differentiation
|
Students will use Excel to understand functions.
|
Closure Strategy
|
Exit Activity #10:
Work with partners.
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.
These will be the next test questions.
|
Lesson Reflections
|
No comments:
Post a Comment