 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 4-16-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Test
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain the different parts of a spreadsheet and chart.
Test on Friday! |
Students are able to explain the different parts of a spreadsheet and chart.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
Look at how the values (numbers) are aligned to the right margin.
Look at how the labels (words) are aligned to the left margin.
Look at how they used an AVERAGE function.
A function is a built in “short cut” so you don’t have to type so much.
 | |
Bell-Ringer/Connecting Strategy
| |
On page 79, type lines 6 and 7.
We are using our LEFT RING finger for the 2 key.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Open the Review for Test Spreadsheet Vocabulary file
@ Miss W will review vocabulary words that will be on test.
@ Work on Chart Components Notes Worksheet
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.
Independent Exercise:
@ Students will work by themselves to see if they need to study for Friday’s test. http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1
@ Students will raise their hands when they are finished.
| |
Higher Order Thinking Questions
| |
What are the different chart definitions involved with spreadsheets?
| |
Student Technology/Differentiation
| |
Students will use Excel to understand about cell references.
| |
Closure Strategy
| |
Exit Activity #8:
Simple Matching http://www.quia.com/mc/1799176.html
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.
These will be the next test questions.
| |
No comments:
Post a Comment