{"product_id":"hs-21st-century-tech-skills-spreadsheet-formulas-and-functions-phenomena-based-lesson-discussion-guide","title":"Spreadsheet Formulas \u0026 Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert \u0026 The PEMDAS Trap Teacher Discussion Guide | 21st Century Technology Skills | Grades 9–12","description":"\u003cp\u003eThis is the teacher discussion guide, with lesson flow, facilitation questions, anticipated student ideas and model explanations for leading the class discussion for the \u003cstrong\u003ePhenomena-Based Lesson\u003c\/strong\u003e in the 21st Century Technology Skills (grades 9–12) chapter \u003cstrong\u003eSpreadsheet Formulas \u0026amp; Functions\u003c\/strong\u003e, built around the phenomenon \u003cstrong\u003eThe $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert \u0026amp; The PEMDAS Trap\u003c\/strong\u003e. It is sold separately from the other two parts of the set.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eComplete the set:\u003c\/strong\u003e \u003ca href=\"\/products\/hs-21st-century-tech-skills-spreadsheet-formulas-and-functions-phenomena-based-lesson-presentation\"\u003eSpreadsheet Formulas \u0026amp; Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert \u0026amp; The PEMDAS Trap Presentation\u003c\/a\u003e; \u003ca href=\"\/products\/hs-21st-century-tech-skills-spreadsheet-formulas-and-functions-phenomena-based-lesson-student-response-sheet\"\u003eSpreadsheet Formulas \u0026amp; Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert \u0026amp; The PEMDAS Trap Student Response Sheet\u003c\/a\u003e.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eSections:\u003c\/strong\u003e Dimension \/ Standard; Performance Expectation \u0026amp; Practices Alignment; Slides; Segment; Focus Activity \u0026amp; Instructional Goal; Anchoring Driving Question (student Sensemaking):; Teacher Script (read Aloud To Introduce Phenomenon):; Talk Move Category. \u003cstrong\u003eSample item:\u003c\/strong\u003e “• Tier 2 Mechanism: How do Relative (A1), Absolute (A1), and Mixed (A1 vs. A1) references behave when copied Right (across columns) versus Down (down rows), and when should an analyst use MEDIAN inste”\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat's inside:\u003c\/strong\u003e Teacher Discussion Guide (editable .docx + PDF, about 2,116 words, 8 pages); answer key \/ model answers for the teacher.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eStandards:\u003c\/strong\u003e Aligned to national Business, Computer \u0026amp; Information Technology standards (NBEA) for 21st Century Technology Skills, with embedded academic literacy and career-readiness skills.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eResource type:\u003c\/strong\u003e Phenomena-Based Lesson – Teacher Discussion Guide. \u003cstrong\u003eFormat:\u003c\/strong\u003e editable Microsoft Word file plus a ready-to-print PDF.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eClassroom use:\u003c\/strong\u003e Open with the phenomenon slide show, let students record ideas on the response sheet, and lead the discussion with the teacher guide. Built for 21st Century Technology Skills, grades 9–12.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eFormat note:\u003c\/strong\u003e These files are delivered in Microsoft Office formats (Word and\/or PowerPoint). If you open a worksheet that includes tables in Apple Pages or another non-Microsoft app, table formatting may not display correctly. For best results, use Microsoft Word or PowerPoint (or upload the file to Google Docs). If you run into any formatting issues, contact us and we can send a PDF version.\u003c\/p\u003e","brand":"ConnectEd Market","offers":[{"title":"Default Title","offer_id":67959195205931,"sku":null,"price":3.5,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1020\/4836\/6891\/files\/hs-21st-century-tech-skills-spreadsheet-formulas-and-functions-phenomena-based-lesson-discussion-guide-cover-v2.jpg?v=1793443687","url":"https:\/\/connectedmarket.net\/products\/hs-21st-century-tech-skills-spreadsheet-formulas-and-functions-phenomena-based-lesson-discussion-guide","provider":"ConnectEd Market","version":"1.0","type":"link"}