Read a Cell Address
Find the specified column and row before interpreting its value.
About 18 minutes, plus any extended practice
Open lesson 1Use Spreadsheet Cells as a Data Model
On a paper sheet put B2=6,C2=4 and B3=8,C3=5. Use =B2+C2, copy the relative formula down one row, and choose a display for exact lookup versus category comparison.
Before you begin
- Read row/column labels and add whole-number values.
Choose by skill rather than age alone. Read with an adult when useful, revisit a lesson, or explore another grade.
Follow the lesson sequence
Calculate a Formula from Referenced Cells
Substitute the stated cell values into the formula and then calculate.
About 18 minutes, plus any extended practice
Open lesson 2Predict a Relative Reference When Copied
Move each relative row reference by the same number of rows as the formula.
About 18 minutes, plus any extended practice
Open lesson 3Choose a Chart that Preserves the Meaning
Match the data type and question to the stated chart purpose, retaining labels and units.
About 18 minutes, plus any extended practice
Open lesson 4Review and transfer
After the lessons, try 4 new review cases and a practical task. Each answer has an explanation and a link back to the related lesson.
Open the unit reviewGuest answers are temporary. Keep your own paper or document; this unit does not certify completion or record a school grade.
Topic references
- 2026 CSTA PK–12 Computer Science Standards: topic reference — Data & Analysis
These references informed the topic selection. They do not certify complete standards alignment.