Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide cover

Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide | 21st Century Technology Skills | Grades 9–12

$3.50
Skip to product information

Resource preview

Select an image to preview. Open it to zoom.

Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide cover
  • Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide cover
  • Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide sample page
  • Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide sample page
Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide | 21st Century Technology Skills | Grades 9–12

Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide | 21st Century Technology Skills | Grades 9–12

$3.50

This is the teacher discussion guide, with lesson flow, facilitation questions, anticipated student ideas and model explanations for leading the class discussion for the Scaffolded Phenomena-Based Lesson in the 21st Century Technology Skills (grades 9–12) chapter Spreadsheet Formulas & Functions, built around the phenomenon The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap. This scaffolded version adds sentence frames and extra supports for students who need them. It is sold separately from the other two parts of the set.

  • What's inside: SCAFFOLDED Teacher Discussion Guide (editable .docx + PDF, about 1,961 words, 8 pages); answer key / model answers for the teacher.
  • Resource type: Phenomena-Based Lesson – Teacher Discussion Guide. Format: editable Microsoft Word file plus a ready-to-print PDF.

Classroom use: 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.

Complete the set: Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation; Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet.

Standards

Aligned to national Business, Computer & Information Technology standards (NBEA) for 21st Century Technology Skills, with embedded academic literacy and career-readiness skills.

Opening the files

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.

At a glance

Resource type
Phenomena Lesson
Grade
9–12
Course
21st Century Technology Skills
Delivery
Digital download
More 21st Century Technology Skills resourcesFree resources