Tuesday, February 27th- 7th Grade- What if statements

Archdale-Trinity Middle School Lesson Plan
Date: 02-27-2018

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheet- What are Spreadsheets? Careers?
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can explain what a WHAT IF statement is

Literacy/Vocabulary Strategies (Word Wall)

Engineers use spreadsheet to build items."Isolated foundation are mostly used for columns and frame structure to transfer point load on a larger area depending on the soil bearing capacity. It also includes the ground water level effect on the foundation load and soil pressure." https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWLcM6N3QIewB_xUF9oJnuu52NFPRsvxFaRf56mZRb9M4KDkgYma8sOp1ec4t9PebDplg-T1cSYu0m3KF1phNd-qKA_L1g40V60x-ZQWg4bGJpkbDmS8o7Dt7WVmbpxAEOUXc9Pdfs0mo/s1600/Untitled.png

Bell-Ringer/Connecting Strategy

1. Go to wclassroom 2. Open 1 Spreadsheet Vocabulary PowerPoint 3. Go to the Applications folder 4. Click on the Microsoft 2016 folder 5. Click on the EXCEL 2016 file 6. Click on the first picture that say blank workbook

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

Guided Lesson: Open the 1 Spreadsheet Vocabulary file @ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010          http://www.gcflearnfree.org/excel2010/1.2 “Spreadsheet Vocabulary PowerPoint Presentation” describing uses of worksheets and tabs (slide 10) @ Go to the SS flash card folder and open up 23 change color of tabs This is an example of a workbook with 12 worksheets. Students will complete WHAT IF activity (slides 11-12) RIBBON WORKSHEET Students will learn about bar, line and pie graphs (slides 13-17) Go through Slide 20   Parts of a Spreadsheet  In the Witkowski folder then the Spreadsheet folder @  Open up 22 Pie Chart.      This is an example of the Insert tab and then the Design tab (chart layouts) @ What if you make a mistake choosing the chart? Open up 9 Chart Types and Styles     --click on the chart     --On the Design tab, click on the Change Chart button --Select a column chart    --On the Design tab, click on the Chart Styles arrow and find the orange/black choice.

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 some questions 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