Friday, September 25th- 7th Grade- What is a function?

	Archdale-Trinity Middle School Lesson Plan
Date: 09-25-2015

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. TEST TUESDAY   Signed Interim reports due by NEXT 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

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: Miss W can give you a study guide today or on Monday 1. Miss W will review functions. Open the 1Spreadsheet Vocabulary file 2. Open a new Excel spreadsheet In F2 type 20 In F3 type 30 In F4 type 40 In F5 type 50 In F6 type 60 We will type out a formula =F2+F3+F4+F5+F6 and then we type out function to see how functions are shortcuts. =Sum(F2:F6) It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses). Open the Understanding Functions Word document Open up the "3 Function practice independent activity” . Excel 2010 Tutorial- Functions https://www.youtube.com/watch?v=b3q1ch-CGto 1 min to 3 min Functions 3 mins to 4:30 mins Range 4:30 mins to 8:30 mins Practice Stop at Count function at 8:30 mins Slides 34 (functions- built in calculations) through 40 Answer questions 20 through 23 Independent Exercise: If time: 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. Answer questions 18 and 19 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 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

Lesson Reflections