Sixth graders learn that a spreadsheet is a grid that can do math for you, discovering cells, rows, columns, and formulas, then check what they know.
Students will be able to…
A spreadsheet looks like a plain grid of boxes, but one formula can total a whole column in an instant. How is it organized, and how does it do the math for you?
Project this and answer each question about how a spreadsheet is organized and what it can do — read the explanation after each one.
Tap any phase to open the teacher moves and student actions.
A spreadsheet looks like a plain grid of boxes. But type one formula and it adds a whole column in an instant. How is it organized, and how does it do that?
Students answer questions about spreadsheets.
Students locate cells by address.
Students build a small spreadsheet.
Students reflect on spreadsheets.
Aligned to the CSTA K-12 Computer Science Standards and the ISTE Standards for Students.
Collect data and use a tool to transform it so it is useful for a purpose.
Refine computational models based on the data they generate.
Represent data in tables and charts to communicate meaning.
Computational Thinker: collect data and use digital tools to analyze it.
Preview the three formative checks. Tap “Sample answer” to see what mastery looks like — hide them before you print for students.
Have students set up columns with headings, enter a few rows of data, and add a formula to total a column, so the grid becomes a working tool. A printable spreadsheet-basics worksheet is in the Computer Science library.
Tap a card to flip it, then rate whether you knew it. Built from this lesson’s vocabulary.
A quick self-check with instant feedback, drawn from this lesson’s key terms.
A print-and-go review sheet with a built-in answer key. Tap “Show answer key” to reveal answers, or print the clean version for students.