Friday, May 12, 2017

Monday, May 15- 7th Grade- Freezing Panes

Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-15-2017


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.
File:Ascending - descending
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 5 Freeze pane and split 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

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

No comments:

Post a Comment