Thursday, November 5th- 7th Grade- Review for Spreadsheet Vocabulary Test

	Archdale-Trinity Middle School Lesson Plan
Date: 11-05-2015

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can explain the different parts of a spreadsheet and chart.	Students are able to explain the different parts of a spreadsheet and chart.

Literacy/Vocabulary Strategies (Word Wall)
Look at how the values (numbers) are aligned to the right margin. Look at how the labels (words) are aligned to the left margin. Look at how they used an AVERAGE function. A function is a built in “short cut” so you don’t have to type so much. http://de.wikipedia.org/wiki/Tabellenkalkulation
Bell-Ringer/Connecting Strategy
Go to wclassroom.blogspot.com Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder- open 4.04 Review for Test Spreadsheet Vocabulary file. .
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: @ Open the Review for Test Spreadsheet Vocabulary file @ Miss W will review vocabulary words that will be on test. 1st period needs to finish yesterday’s review 22. When they make a pie chart, a small box shows that the Red Delight roses have a red pie piece, and the Yellow Button roses have a yellow pie piece. What is the name of the guide for this chart?                     Hint: Paul Bunyan is also called by the same name. 23. If we a piece of paper sideways so it is longer on the top than the sides; what is it called? 24. The horizontal and vertical lines on the chart that can be hidden or shown on the screen or when you print are called what term? 25. What is it called when you copy formulas and they automatically adjust to the correct cell ranges? Independent Exercise: @ Students will go to https://kahoot.it/#/     Top 5 winners will get candy. @ Students will work by themselves to see if they need to study for Friday’s test.  http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1 @ Students will raise their hands when they are finished.
Higher Order Thinking Questions
What are the different chart definitions involved with spreadsheets?
Student Technology/Differentiation
Students will use Excel to understand about cell references.
Closure Strategy
Exit Activity#10: Working in pairs and using the PINK Study Guide answer the questions. These will be the next test questions.   http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1
Lesson Reflections

Wednesday, November 4th Short Cut Links

If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/11/wednesday-november-4th-7th-grade.html

If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/11/wednesday-november-4th-8th-grade-food.html

Wednesday, November 4th- 8th Grade- Food Truck Marketing Trends

	Archdale-Trinity Middle School Lesson Plan
Date: 11-04-2015

Teacher:	Witkowski
Lesson/Unit Topic:	The Entrepreneurial Process- Discovery Phase
Standards:	NCCTE.BU20.03.02 Understand entrepreneurship and the entrepreneurial process

“I Can…” Statement
I can explain the different activities in the Discovery phase of the Entrepreneurial process.	.

Literacy/Vocabulary Strategies (Word Wall)

In the Discovery phase of the Entrepreneurial process you would research market trends about your idea.    http://images.huffingtonpost.com/2012-10-25-foodtruck1.jpg

Bell-Ringer/Connecting Strategy

1.  Go to wclassroom.blogspot.com        2. Go to your lunch number- Open 3.02 Bellringer Discovery Phase and complete          Day 3       3.  Go to  Computer- Student Doc- Witkowski folder- Exploring Business Folder-           Entrepreneur Folder- then open 3.02 Entrepreneurship and the Entrepreneurial Process

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

Guided Lesson:  @ Students will learn about Market Trends. Independent Exercise:  Study food truck market trends "Food Trucks Motor into Mainstream" by Intuit at http://network.intuit.com/wp-content/uploads/2012/12/Intuit-Food-Trucks-Report.pdf @ Complete the Food Truck Marketing Trends worksheet. @ In YOUR OWN WORDS and using the facts from the worksheet, write a paragraph (at least 6 sentences) about your AVERAGE customer.     Previous Work: @ In pairs, read the link below titled "Sneaker Wars" by the Washington Post      and list different facts/trends about sneakers. https://www.washingtonpost.com/news/business/wp/2015/03/17/how-sneaker-kings-are-fighting-to-win-the-war-for-americas-feet/ FOOD TRUCK SURVEY  •You need to create a food truck survey.                   You may look at the 2 examples in the above links                   or go online and google Food Truck Survey for ideas •Use a word document.  ONE page only! •Have 10 questions with correct spelling/grammar.                     The questions may be multiple choice or fill in the blank. •Have clip art or pictures. •Have your name & your food truck’s name on it.    @ Sample food truck survey  https://www.surveymonkey.com/r/?sm=zfr4rcQeHOZ98mkREha3%2BA%3D%3D    Results http://parktran.rutgers.edu/PDF/Mobile%20Food%20Vendor%20Survey%20results%2003072012.pdf @ Students will take notes on the Discovery Phase. http://www.slideshare.net/afzaalali14/chapter-2-entrepreneurship-lecture-3

Exit Activity  - A. Review of 1.03 http://www.quia.com/rr/977291.html B. Matching characteristics http://www.quia.com/mc/2677069.html?AP_rand=1918492033 C. Matching skills http://www.quia.com/mc/2677091.html?AP_rand=1136190610

Wednesday, November 4th- 7th Grade- Spreadsheet Vocabulary Review for Test

	Archdale-Trinity Middle School Lesson Plan
Date: 11-04-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Review for Vocabulary test
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can explain different features of Excel. Test on Friday.	Students know the different features of Excel

Literacy/Vocabulary Strategies (Word Wall)
Landscape- If you turn a sheet of paper sideways it is called landscape, because in days past when painters painted landscapes they turned their canvases sideways. When they painted portraits their canvases were turned the way you are use to seeing a sheet of paper used. http://en.wikipedia.org/wiki/Su%C3%B0ureyri
Bell-Ringer/Connecting Strategy
On page 76, type lines 18 and 19. We are using our right MIDDLE finger for the * asterisk key. We are using our left PINKY finger for the  SHIFT  key
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: @ Review questions. Relative Cell Referencing- copies formulas and automatically adjusts to correct cell range. Absolute cell referencing- formulas do NOT adjust or do NOT change. For example- $C$12- column A does not change and row 2 does not change. Go to My Computer- then Student Docs- then Witkowski folder then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder then- rose variety file. 1. Look at cell  C2 is it a value or a label in it? 2. Are values (numbers) aligned to the left or to the right? 3. Look at cell B3 is it a value of a label in it? 4. Are labels (words) aligned to the left or to the right? 5. What part of the spreadsheet is labeled with numbers? 6. What part of the spreadsheet is labeled with letters? 7. Put your cursor on D3. What does the dark border around it mean? 8. What does the entry bar show when your cursor in on D3? 9. What symbol do all formulas start with? 10. What are the symbols -, +, *, and / called? 11. When typing values (numbers) into a spreadsheet what two things should you not include? 12. What are the rectangular boxes on a spreadsheet called? 13. The fx button means function. What is a function? 14. What function could we use to add the percentages from D3 through D11? 15. When we highlighted cells D3  through D11, we selected them a group of cells and treated them like a unit. What is the name of that vocabulary term? 16. Go to sheet 2. Type in Monday in A1. Click on A1 and drag the cursor down. What did you just do? 17. If we took the rose names and put them in Z to A order, what type of order did we do? 18. If we took the rose names and put them in A to Z order, what type of order did we do? 19. The percentage of total adds up to 100%; what type of chart is best to show parts of a whole? 20. The garden company tracked their stock over time; what type of chart is best? 21. The garden company wants to track how all of their flowers did just not roses; what is the best type of chart to compare things? 22. When they make a pie chart, a small box shows that the Red Delight roses have a red pie piece, and the Yellow Button roses have a yellow pie piece. What is the name of the guide for this chart?                      Hint: Paul Bunyan is also called by the same name. 23. If we a piece of paper sideways so it is longer on the top than the sides; what is it called? 24. The horizontal and vertical lines on the chart that can be hidden or shown on the screen or when you print are called what term? 25. What is it called when you copy formulas and they automatically adjust to the correct cell ranges? Independent Exercise: @ Students will study for Friday’s Spreadsheet vocabulary test
Higher Order Thinking Questions
What are the different definitions involved with spreadsheets?
Student Technology/Differentiation
Students will use software to study for the vocabulary test. .
Closure Strategy
Exit Activity#10: Working in pairs and using the PINK Study Guide answer the questions. These will be the next test questions.   http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1
Lesson Reflections

Tuesday, November 3rd Short Cut Links

If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/11/tuesday-november-3rd-7th-grade.html

If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/11/tuesday-november-3rd-8th-grade.html