The Life Starter
Sign up
Grade 5 · unit review

Review: Use 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.

Download reviews and answer keys

Bring the unit skills together

Use these 4 new cases to check your reasoning. Choices are temporary and are not saved to an account, sent to staff or recorded as school grades. Download your current review choices before leaving or reloading.

Unit review questions
1. Count for cards at B4. Sheet: A2=tiles,B2=6; A3=pencils,B3=4; A4=cards,B4=8. What is requested?
Need a hint?
  • Find the specified column and row before interpreting its value.
  • Do not treat the header row as a data count.
2. Sheet: B2=12, B3=5. Formula result for =B2+B3?
Need a hint?
  • Substitute the stated cell values into the formula and then calculate.
  • Do not add the row numbers 2 and 3 in place of the cell contents.
3. Original=B5+C5 copied up 1 row. What formula follows the stated copy?
Need a hint?
  • Move each relative row reference by the same number of rows as the formula.
  • Do not keep the old referenced row when the model says the reference is relative.
4. Track hourly temperature observations in time order. Which representation best fits the stated purpose?
Need a hint?
  • Match the data type and question to the stated chart purpose, retaining labels and units.
  • Do not join unrelated category counts as though they form a time sequence.

The download contains your current choices and any checked feedback. Keep the separate transfer-task work in your own document; downloading its instructions does not mark it complete.

Use the skills in a new task

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.

Work on paper or in your own document. Explain the choices you made.

  • Use the pretend details in the task and name the rule you followed.
  • Show the steps or point to the detail that helped you choose.
  • Say one mistake to avoid or one thing this example cannot tell us.
  • Check your answer against the task. Change a part if you can show why it needs fixing.
Compare with a model response

The first result is 10. Copied down, =B3+C3 gives 13. A labeled table supports exact lookup and a labeled bar chart can compare categories. Both must state what the counts represent.

A different response can also meet the criteria. Compare the evidence and reasoning, rather than copying the wording.