Course: Period(s): Unit: Lesson Warmup Mini-Lesson/ Work Period Closing Assessments Components How do you Opening Student-focused work: Period Formative/ Engage What are you to include guided & How will you Summative Students? cover? independent practice wrap up the lesson? Ticket, etc. Monday Excel Review basics 20 minutes for Scavenger What is one Scavenger Scavenger and introduce Excel Hunt and answer formula in Hunt Hunt formulas using that you SMART board 10 minute introduction to learned technology Excel formulas today? 60 minutes to individually complete MOAC Lesson 8 Tuesday Yard Sale Review formulas 10 minute discussion on MOAC Excel – Discussion from Day 1. Yard Sales Lesson 8 Edmodo: Address any 10 minute introduction to do questions. Yard Sale Project, “How you rubric, assign work maximize Introduce Yard Sale partners and track Project, share your profits rubric, assign work Complete MOAC Excel from a yard partners. Lesson 8 (if needed before sale? beginning project) Hand Out Excel “Cheat Sheet” 70 minutes to begin work in partner groups on Yard Sale project. Wednesday Project Day 90 minutes to complete Yard Sale Project Thursday Sale Day! Explain to students 10 minutes to set up for the that they will actual Yard actually the “shop” yard sales. 80 minutes: Each group will display their power Print out hard points showcasing their 25 copies of student items for sale. Student spreadsheets for groups will rotate through them to track sales the sales and make their during the selling purchases. period. Students will track sales Distribute $10 in from their yard sale on the play money to each hard copy of the partner group. spreadsheet. Their goal is to purchase at least 5 items total from the
Course: Period(s): Unit: Lesson Components Warmup How do you Engage Students? Mini-Lesson/ Opening What are you to cover? Work Period Student-focused work: include guided & independent practice Closing Period How will you wrap up the lesson? Ticket, etc. Assessments Formative/ Summative Monday Excel Scavenger Hunt Review basics and introduce Excel formulas using SMART board technology 20 minutes for Scavenger Hunt and answer 10 minute introduction to Excel formulas 60 minutes to individually complete MOAC Lesson 8 What is one formula in that you learned today? Scavenger Hunt Tuesday Yard Sale Discussion Edmodo: “How do you maximize and track your profits from a yard sale? Review formulas from Day 1. Address any questions. Introduce Yard Sale Project, share rubric, assign work partners. 10 minute discussion on Yard Sales 10 minute introduction to Yard Sale Project, rubric, assign work partners Complete MOAC Excel Lesson 8 (if needed before beginning project) Hand Out Excel “Cheat Sheet” 70 minutes to begin work in partner groups on Yard Sale project. MOAC – Excel Lesson 8 Wednesday Project Day 90 minutes to complete Yard Sale Project Thursday Sale Day! Explain to students that they will actually “shop” the yard sales. Print out hard copies of student spreadsheets for them to track sales during the selling period. Distribute $10 in play money to each partner group. Their goal is to purchase at least 5 items total from the 10 minutes to set up for the actual Yard 80 minutes: Each group will display their power points showcasing their 25 items for sale. Student groups will rotate through the sales and make their purchases. Students will track sales from their yard sale on the hard copy of the spreadsheet.
You%20Are%20Having%20a%20Yard%20Sale%20Lesson%20Plan.docx