Tuesday, April 14- 7th Grade- Spreadsheet Vocabulary Vokis

	Archdale-Trinity Middle School Lesson Plan
Date: 04-14-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Finish Chart Components Voki Project
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can explain different features of Excel charts. Test on Friday.	Students know the correct answers during today's presentations.

Literacy/Vocabulary Strategies (Word Wall)
Relative Cell Referencing- copies formulas and automatically adjusts to correct cell range. . http://www.skyneel.com/2014/03/Excel-Switching-between-Relative-Absolute-Mixed-Cell-References.html
Bell-Ringer/Connecting Strategy
On page 76, type lines 14 and 15. We are using our right MIDDLE finger for the 8 key.
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: @ Complete Chart Title and Axis Titles definitions on worksheet @Students will sign in to Edmodo. Student username = lunch numberPassword = Computer log-on (Birthdate = leading zeroes/forward slash/ four-digit year Please pay attention and follow DIRECTIONS: You MUST NOT put the vocabulary word in your Voki ONLY THE DEFINITION You MUST spell the words correctly or it will not make sense. Have your neighbor check your spelling!!!!!! http://commons.wikimedia.org/wiki/File:CLACL_directions.png @ Students will create a voki about one of the Pink Sheet Vocabulary Words. @ Write your name and period on the back of the paper that you choose. @ Do NOT say the name of your definition in your voki, we are going to guess next week. @ Example http://www.voki.com/pickup.php?scid=9046863&height=267&width=200 @ When you are finished with your Voki you will partner with a person, who is not finished and assist them. Independent Exercise: @ Students will try to guess from the Voki's descriptions which Pink Sheet Vocabulary Word it is. @ Students will study for Friday’s Spreadsheet vocabulary test 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 are the different chart definitions involved with spreadsheets?
Student Technology/Differentiation
Students will use Voki software to understand chart components.
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. http://www.typingweb.com/tutor/games/play/game/23 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