Wednesday, March 11th- 7th Grade- Spreadsheet Test, Charts, Formulas

	Archdale-Trinity Middle School Lesson Plan
Date: 03-11-20145

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Test 1 AND Formatting a chart
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can find and use different features of Excel. TEST TODAY Signed Interim reports due by Thursday	Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)

Descending Order- the people on the right are going down. They are descending. Ascending Order- the people on the left are going up. They are ascending. http://commons.wikimedia.org/wiki/File:Ascending_-_descending,_Foyleside_-_geograph.org.uk_-_1187513.jpg

Bell-Ringer/Connecting Strategy

On page 32, type lines 09 and 10. Remember to use your thumb for the space bar. We are using our left INDEX finger for the U key.

Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson: 1. Miss W will give test directions. After test, students will work on cell reference candy challenge. Independent Exercise: 2. Students will take test then work on cell reference candy challenge. 3. Chart creation and formatting hide the "miles" column highlight your car lot data- model and price Insert a column chart click on the chart and the Chart Tools Tab will appear We are going to look at the Design Tab. Choose a chart style color. We are going to  look at the Layout tab. insert the chart title "My Car Lot". It will explain the chart's purpose. insert horizontal axis title "model" insert vertical axis title "price" click on data labels and click on show click on data table and click on show change chart wall, go to more options and pick a fill color change chart floor, go to more options and pick a different color make sure you have gridlines they will make the plot area easier to read. Open the Spreadsheet Vocabulary file Slides 26 (order of operations) through 34 (formatting and formulas) Homework: Students need to decide for which ACADEMIC topic (Typing Posture/Technique, Language Arts, Science, Social Studies, or Math) they will create a PowerPoint presentation soon. We will be using the PowerPoint you create to learn different old and new features of PowerPoint 2010.

Higher Order Thinking Questions

How do I format a spreadsheet?

Student Technology/Differentiation

Students will use Excel to format a spreadsheet.

Closure Strategy

Exit Activity #7: Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html Exit Activity #8: Choose home row and easy. Turn off sound. http://www.typingweb.com/tutor/games/play/game/23 Exit Activity #9:  Ribbon Vocabulary words review words and definitions here http://quizlet.com/3089570/flashcards then play activity here http://quizlet.com/3089570/scatter Exit Activity #10: http://www.quia.com/rr/363962.html We have not covered one question yet. Built in calculations are called functions. Horizontal is like laying down flat on the ground. Vertical is up and down You may use the Spreadsheet Vocabulary PowerPoint. Play until you have won a million dollars