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

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

$5.00
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 Presentation cover
  • Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation cover
  • Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation sample page
  • Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation sample page
Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation | 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 Presentation | 21st Century Technology Skills | Grades 9–12

$5.00

This is the student-facing slide presentation that introduces the phenomenon, walks the class through observations and driving questions, and frames the evidence students will use 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 Student Slide Show (editable .pptx + PDF, 16 slides).
  • Resource type: Phenomena-Based Lesson – Presentation. Format: editable Microsoft PowerPoint 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 Teacher Discussion Guide; 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