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

Thursday, March 1st- 7th Grade- Spreadsheets- Sorting and Cell Ranges

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

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 tell the difference between ascending and descending order. TEST NEXT FRIDAY	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. Go to Applications then click on Microsoft Office 16 folder then click on Excel 2016 then click on blank worksheet

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

Guided Lesson: Open the Spreadsheet Vocabulary file Slides 19 through 24   (Range, Cell Reference, Sorting)   @Practice ascending and descending order 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) Skill 1 ascending order (Home tab) Skill 21- hide gridlines (Page layout tab) Skill 2- color scales (under conditional formatting) Car lot exercise-   1*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder and save to your lunch number 2*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business. Cell Reference and Range Activity Follow instructions to make a picture. Make cell C5 to C8 yellow Make D5 to D8 yellow Make cell F5 to F8 yellow Make cell G5 to G8 yellow Now click on C6 make it black Then click on F6 and make it black Cell E11 green Cell B12 to B13 red Cell I11 to  I12 red Cell C14 red Cell D15 red Cell E16 red Cell F15 red Cell G14 red Cell H13 red

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

Thursday, March 1st- 8th Grade- Begin Franchise Unit

Archdale-Trinity Middle School Lesson Plan
Date: 03-01-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.  Open 1.02 Business Types      3. Pull out your Business Type NOTES  and YELLOW Project papers      4. You need a pencil or pen      5. If you are not finished with 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: @ Students will complete franchise notes starting on slide 66 Independent Exercise: @ Franchise Notes- advantages and disadvantages @ Franchise video https://www.youtube.com/watch?v=EmjA6O2HIus @ 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 time review corporations and franchises by going to :  https://kahoot.it/ 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

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

Wednesday, February 28th Short Cut Links

Click here if you are a 8th Grade Student      http://wclassroom.blogspot.com/2018/02/wednesday-february-28th-8th-grade-sole.html?_sm_au_=iVVk7Sq4lWtRFf5P

Click here if you are a 7th Grade Student    http://wclassroom.blogspot.com/2018/02/wednesday-february-28th-7th-grade.html?_sm_au_=iVVk7Sq4lWtRFf5P

Wednesday, February 28th- 7th Grade- Spreadsheets- Charts and Graphs

Archdale-Trinity Middle School Lesson Plan
Date: 02-28-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. Get out your RIBBON paper if you are not finished 4. Go to the Applications folder 5. Click on the Microsoft 2016 folder 6. Click on the EXCEL 2016 file 7. 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 RIBBON WORKSHEET (6th period) @ 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 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