Friday, December 9th- 7th Grade- Formatting the Car Lot and Freezing Panes

Archdale-Trinity Middle School Lesson Plan
Date: 12-09-2016

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets - What is a function?
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. I can freeze panes. Signed Interim reports due by NEXT TUESDAY	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

1. Go to Computer- then your LUNCH number- then open Copy of Car Lot 2. Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder- open 1 Spreadsheet Vocabulary file. 3. Go to wclassroom.blogspot.com

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

Guided Lesson: Students will learn about freezing panes. http://www.gcflearnfree.org/excel2013/freezing-panes-and-view-options/1/7QgyfFXvReo?version=3&autoplay=1&iv_load_policy=3&fs=1&hl=en_US&rel=0 Students will open 4 Excel2013 Freezing Practice file Students will add a header and practice freezing panes Students will open their Car Lot file and continue to format it. . 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. Adding Functions Add the words Sum, Average, Max, and Min to the left of the Price Column Calculate the Sum, Average, Max, and Min of the different prices Save your work and show Miss W the finished assignment.

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 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html Exit Activity #2: 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