Wednesday, April 29th- 7th Grade- Spreadsheet Chart Components- Tick Marks and Review

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

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can identify different chart components.	Students can identify different chart components

		Literacy/Vocabulary Strategies (Word Wall)
		The Y axis is vertical and on the left side of the graph. The X axis is horizontal and on the bottom of the graph. http://resumbrae.com/ub/dms423_f07/08/
		Bell-Ringer/Connecting Strategy
		On page 91, type lines 6 and 7. We are using our LEFT INDEX finger for the 5  key
		Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
		Guided Lesson: @ Students will finish watching Persuasive PowerPoints @ Students will open the Chart Components PowerPoint @ Students will start take notes on any missing information @ Excel tick marks and gridlines 2010   http://www.youtube.com/watch?v=m9fbZ0DEDbY      until 1:08 Independent Exercise: @Students will complete the first page of the  CHART COMPONENTS NOTES worksheet               http://compappssh.wikispaces.com/file/view/Notes.pdf @ Open the Tick Marks file @ Highlight the data and choose a "format as table" option @ Highlight the data and create a line chart (choose the first choice) @ We will be right clicking on certain items @ Make minor tick marks on the vertical and horizontal axes @ Change the color of the tick marks to red @ Change gridlines to green @ Change the plot area to light aqua @ Change the chart area to any color other than light aqua @ Go to the Chart Tools Tab and then the Layout tab and add the title "ATMS" @ On the Layout Tab add data labels @ In the Tick Marks file what is one of the data series? @ If time complete the crossword puzzle @ Complete the chart sheet.
		Higher Order Thinking Questions
		What are the different chart components?
		Student Technology/Differentiation
		Students will use Excel 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 review the following questions. http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1