Monday, March 5th- 7th Grade- Start Car Lot Project

Archdale-Trinity Middle School Lesson Plan
Date: 03-05-2018

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can research data

Vocabulary Strategies (Word Wall)

Tab, Pie graph, Worksheets http://commons.wikimedia.org/wiki/File:Population_of_Provinces_and_Territories_of_Canada_Pie_Chart.png

Bell-Ringer/Connecting Strategy

1. Go to wclassroom 2. Open the "copy of x1 car lot" file 3. You need a pen or pencil

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

Guided Lesson: @Open the "copy of x1 car lot" file @ Watch Narrative Presentations Car lot exercise-   1*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business. 3*Students will go to http://www.carmax.com and find cars and write the information (year, make(brand), model(name), miles, and price) on their worksheet. 4* Students will write information on their car lot worksheet. @ Watch Narrative Presentations

Higher Order Thinking Questions

Which tab will be used for the different formatting activity and why?

Student Technology/Differentiation

Students will use http://www.carmax.com to research different car statistics.

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

Monday, March 5th- 8th Grade- Begin Franchise Project

Archdale-Trinity Middle School Lesson Plan
Date: 03-05-2018

Teacher:	Witkowski
Lesson/Unit Topic:	Types of Business Organizations- Franchise Research Project
Standards:	NCCTE.BU20.01.02 Understand the types of business organizations.

“I Can…” Statement
I can understand the advantages and disadvantages of a franchise. Test on Wednesday	.

Literacy/Vocabulary Strategies (Word Wall)

An advantage of a Franchise is the parent company provides training and advice. A disadvantage of a Franchise is that they have strict rules and you must pay a royalty ( a percent of your profits) to them. https://tinobusiness.com/wp-content/uploads/2015/09/franchise-concept-chart-keywords-icons-48905302-e1442314550985.jpg

Bell-Ringer/Connecting Strategy

Go to wclassroom.blogspot.com       2.  You need a pencil or pen       3.  1st period- Click on orange link and            Choose which 2 franchises you would like to research      4.  2nd period only- get your franchise sheets

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

Guided Lesson: @ Miss W will review the Franchise Project rubric @ Miss W will show sample of Franchise Project @ Miss W will review PowerPoint skills needed for Franchise Project @ Students will practice Exit Activity  Independent Exercise: PROJECT INSTRUCTIONS  1.Open 1.02 Franchise Research Project 2. Finish the PowerPoint part of the project (answers, pictures, animations, transitions) 3. Finish the script. Why should someone buy your franchise? Use the ongoing support items.  It is NOT a commercial to go to the place, it is a commercial to BUY the franchise 4. Save to presentation folder and help other students @ When you are finished save to My Computer- Student Docs-      Witkowski folder- Exploring Business folder- Business folder -      A Franchise Research Project folder then 1st period or 2nd period      Make sure your name is in file name @ Go to    http://www.entrepreneur.com/franchises/rankings/franchise500-115608/2015,-1.html to get information about your Franchise        k= thousands of dollars    m=  millions of dollars

Exit Activity 2  - Test Review-  http://www.quia.com/rr/974026.html

Friday, March 2nd Short Cut Links

Click here if you are a 8th Grade Student  http://wclassroom.blogspot.com/2018/03/friday-march-2nd-8th-grade-literacy.html?_sm_au_=iVV23RZ1jFQfRrQR

Click here if you are a 7th Grade Student    http://wclassroom.blogspot.com/2018/03/friday-march-2nd-7th-grade-pemdas.html?_sm_au_=iVV23RZ1jFQfRrQR

Friday, March 2nd- 7th Grade- PEMDAS

Archdale-Trinity Middle School Lesson Plan
Date: 02-25-2016

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Cell References and Sorting
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 ON Wednesday	Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)

Range, Cell Reference, Sorting, Ascending- to go up, Descending http://commons.wikimedia.org/wiki/File:Divers_ascending_at_shotline_labeled.png

Bell-Ringer/Connecting Strategy

1. Open 1 Spreadsheet Vocabulary file. 2. Go to wclassroom.blogspot.com 3. Turn in interim reports by Monday

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

Guided Lesson: SS Flash cards file   (border button and percent button) Open 31 Formatting Cells @ Open 19 Hide Worksheet     - right click on tab and choose hide     - right click on tabs before and after the hidden tab and choose unhide. @ Open 16 Hide and Show Rows     -right click on row number and choose unhide. - highlight row before and row after the hidden row     and then right click and choose unhide. Independent Exercise: Open the Spreadsheet Vocabulary file Slides 25 through 30   (PEMDAS)   Do the PEMDAS activity- Slide 26 (order of operations in a spreadsheet formula)

Higher Order Thinking Questions

How do cell references help navigate a spreadsheet?

Student Technology/Differentiation

Students will use Excel to understand cell references.

Closure Strategy

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

Friday, March 2nd- 8th Grade- Literacy Field Trip- Franchise Project and Make up work day

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

Teacher:	Witkowski
Lesson/Unit Topic:	Types of Business Organizations- Franchises
Standards:	NCCTE.BU20.01.02 Understand the types of business organizations.

“I Can…” Statement
I can explain the advantages and disadvantages of franchises Test next Thursday	.

Literacy/Vocabulary Strategies (Word Wall)

A Franchise is an agreement to sell a company’s products or services. https://cdnimg.webstaurantstore.com/uploads/buying_guide/2014/9/adorf-brandz.jpg

Bell-Ringer/Connecting Strategy

Go to wclassroom.blogspot.com      2.   You need a pencil or pen      3.   Finish Sole Proprietorship VS Partnership       Test next Thursday

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

Guided Lesson: @ Miss W will review field trip procedures and pass out bus assignments Independent Exercise: @ Students will choose 2 Franchises  and answer questions @ Students will research 2 franchises at  http://www.entrepreneur.com/franchises/rankings/franchise500-115608/2015,-1.html   k= thousands of dollars    m=  millions of dollars @ Students will decide which franchise they want to research further. IF ABSENT ON TUESDAY @ In pairs (each person needs to complete sheet) complete the Famous Corporations worksheet      www.hoovers.com   Do not use chat feature @ IF ABSENT ON WEDNESDAY @  Complete Sole Proprietorship vs Partnership project IF ABSENT ON THURSDAY @ Complete franchise notes and choose 2 franchises for project.

Exit Activity 1  - Vocabulary Matching Game http://www.quia.com/mc/2521511.html Exit Activity 2  - Test Review-  http://www.quia.com/rr/974026.html

Thursday, March 1st Short Cut Links

Click here if you are a 8th Grade Student      http://wclassroom.blogspot.com/2018/02/thursday-march-1st-8th-grade-begin.html?_sm_au_=iVV48NHT83fr7R85

Click here if you are a 7th Grade Student      http://wclassroom.blogspot.com/2018/02/thursday-march-1st-7th-grade.html?_sm_au_=iVV48NHT83fr7R85