Thursday, November 5th- 7th Grade- Review for Spreadsheet Vocabulary Test

	Archdale-Trinity Middle School Lesson Plan
Date: 11-05-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Test Review
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.	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. http://de.wikipedia.org/wiki/Tabellenkalkulation
Bell-Ringer/Connecting Strategy
Go to wclassroom.blogspot.com Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder- open 4.04 Review for Test Spreadsheet Vocabulary file. .
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. 1st period needs to finish yesterday’s review 22. When they make a pie chart, a small box shows that the Red Delight roses have a red pie piece, and the Yellow Button roses have a yellow pie piece. What is the name of the guide for this chart?                     Hint: Paul Bunyan is also called by the same name. 23. If we a piece of paper sideways so it is longer on the top than the sides; what is it called? 24. The horizontal and vertical lines on the chart that can be hidden or shown on the screen or when you print are called what term? 25. What is it called when you copy formulas and they automatically adjust to the correct cell ranges? Independent Exercise: @ Students will go to https://kahoot.it/#/     Top 5 winners will get candy. @ 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#10: Working in pairs 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
Lesson Reflections