What you will build

You will keep a weekly study plan easy to sort, filter, and extend by using one field per column: Day, Subject, Minutes, and Status. Day, Subject, and Status stay as text labels, while Minutes stays numeric.

Learning objectives

Open the practice workbook

HANDS-ON PRACTICE

Practice in your own copy

Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.

Make a Google Sheets copy (access required) ↗View original

Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.

Google Sheets weekly study plan showing the complete A1:D5 sample table with Day, Subject, Minutes, and Status.

Sample data

DaySubjectMinutesStatus
MonMath45Done
TueEnglish30Done
WedScience60Planned
ThuHistory40Planned

Each row is one study session. Minutes is the only numeric field in this sample; the other three columns contain text labels.

Hands-on practice

Step 1: Select A1:D1. Confirm the headers are Day, Subject, Minutes, Status, with no blank or duplicate header.

A1:D1 selected in Google Sheets, showing the four headers Day, Subject, Minutes, and Status.

Step 2: Check the values down each column. C2:C5 must be numeric Minutes values (45, 30, 60, 40). Day, Subject, and Status contain text labels such as Mon, Math, and Done.

The Minutes range C2:C5 selected in Google Sheets, showing numeric values 45, 30, 60, and 40.

Step 3: Select C2 and temporarily replace 45 with 50. Confirm the value is accepted as a number in the Minutes column, then restore C2 to 45.

Cell C2 selected after the temporary numeric test value 50 has been entered in the Minutes column.

Restore check: return C2 to 45 so the workbook matches the original sample before you finish.

Cell C2 restored to 45 in the weekly study plan, matching the original checkpoint data.

Checkpoint

DaySubjectMinutesStatus
MonMath45Done
TueEnglish30Done
WedScience60Planned
ThuHistory40Planned

Final checkpoint: A1:D5 must match this table, including C2 restored to 45.

Common mistakes and fixes

If a header is blank or duplicated, rename it so each column describes one field. If a Minutes value contains extra text, replace it with the numeric value only. After any test, restore the original sample before comparing with the checkpoint.

Independent practice

Add a temporary Friday row using the same four-field schema. Enter a numeric Minutes value, verify the row is consistent with the existing columns, then remove the row to return to the sample.

Key takeaways

  • ✓Use one clear field per column: Day, Subject, Minutes, Status.
  • ✓Keep all four headers present, unique, and in the first row.
  • ✓Keep Minutes numeric so the values can be sorted or calculated correctly.
  • ✓Keep Day, Subject, and Status as text labels in this sample.
  • ✓After testing a value, restore the workbook to the checkpoint data.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. Which header identifies the numeric field in this weekly study plan?
2. What should you verify in A1:D1?
3. What temporary test is used in C2?
4. Why should you avoid entering “45 min” in a Minutes cell?

Next lesson

Continue in the foundations path by learning how to diagnose and fix values that do not match the expected data type.