Data Modelling

DASKEREL wrote this teaching and practice using Oak's sequence as a source. View the source lesson at Oak National Academy. Oak has not endorsed this material. Check Oak's terms and separate rights for third-party works.

Learning outcomes

Assign one variable and unit to each column
Use formatting to reveal rather than distort values

Vocabulary: cell · row · column · header · data type · unit

Retrieve previous learning

Why is a table's missing value different from zero?

Check: Missing means the value was not recorded; zero is a recorded numeric result.

Learn the concept

A spreadsheet stores values in cells addressed by column letter and row number. A useful data table begins with headers: Item, Quantity, Unit price (£). Each row then describes one fictional item, and each column has one meaning. Units belong in headers or a clear note so a later reader does not confuse pounds with pence.

Format values according to their meaning. Currency formatting can display 2 as £2.00 without changing the underlying value, while entering '£2' as text can make calculations harder in some tools. A highlighted header and consistent number of decimal places aid reading, but colour alone should not distinguish essential categories.

Keep raw observations separate from notes and totals. Do not merge cells in the middle of a sortable data table, and do not replace a missing quantity with 0 without evidence. Use fictional purchase data and a teacher-approved file location. A teacher should inspect the actual table and its accessibility, not only a screenshot.

Worked model

Create headers in A1:C1 for Item, Quantity and Unit price (£).
Enter three fictional item rows with numeric quantities and prices.
Apply currency display to price cells and consistent header emphasis.
Check sorting and formula-readiness without merging data cells or changing missing entries to zero.

Guided practice

A price column contains '£2' as text and 3 as a number. What would make calculations more consistent?

Hint: Separate stored number from display format.

Check the guided answer

Store numeric prices such as 2 and 3 in the cells, apply currency formatting, and label the column £. This keeps arithmetic possible while displaying £2.00 and £3.00.

Independent practice

Write your own response to every question before viewing the model answers. Your writing stays in this page session; this activity does not submit, store or grade it. Avoid including private information.

Teacher observed practical evidence

A teacher must apply the school's risk assessment, allergy policy and any individual healthcare plan before the practical. Observe and record the criteria during supervised work. Written answers cannot certify practical safety or skill.

Teacher observes the learner create, inspect and revise an original spreadsheet using fictional or appropriately aggregated data.
Saved file shows labelled columns, functioning formulas, a chart or search result where relevant, and a recorded correction.
Learner explains units, missing values and the limits of the model; no private pupil record is required for the task.

Find and correct a misconception

“Formatting a number as currency changes its underlying numeric value.”

Correction: Formatting usually changes display; the stored value remains numeric if entered as a number.

Extend and reflect

Plan a data-entry rule for nonnegative quantities.

Guidance: Explain why validation should prevent a negative count while leaving a genuinely missing value distinct.

Where this lesson could lead · Computer Science GCSE → Daskerel Computing and AI

This lesson practises: Assign one variable and unit to each column. Algorithms, digital systems and safe practice support later software and technology work.

Next school subject: Computer Science GCSE. Check the subject and examination board that fit your school.
Later DASKEREL learning: Daskerel Computing and AI. Explore further study and build evidence from practical work.
Later credential exploration: AWS Certified Developer - Associate is an example in this later specialism. Check current awarding-body requirements before planning an exam.
Example career direction: Software Engineer. Explore organisations and local support.

This is an exploratory route, not a promise of admission, a qualification, certification eligibility or employment. Years 7–9 learning is an early foundation; any later credential may require substantial study, experience or local approval.

Year 7 · Data representation · original lesson pack

DASKEREL beta · internal AI review pending

Calculate a line cost and total with formulas

DASKEREL wrote this teaching and practice using Oak's sequence as a source. View the source lesson at Oak National Academy. Oak has not endorsed this material. Check Oak's terms and separate rights for third-party works.

Learning outcomes

Use relative cell references in a line formula
Check a SUM result against a manual calculation

Vocabulary: formula · cell reference · relative reference · SUM · recalculation

Retrieve previous learning

Why should quantity and unit price be stored as numbers?

Check: Formulas can multiply them and update when the inputs change.

Learn the concept

A spreadsheet formula begins with =. If B2 is quantity 3 and C2 is unit price 2.50, D2 =B2*C2 calculates 7.50. Copying that relative formula to D3 normally changes references to B3 and C3, so each row uses its own data. Write a header such as Line cost (£) above the results.

A total formula =SUM(D2:D4) adds the line costs in that range. For fictional costs £7.50, £4.00 and £1.25, the total is £12.75. Manually check a small sample and inspect the formula range; excluding the last row can produce a plausible but wrong total.

Formulas recalculate when input numbers change, which is useful for modelling. They can also propagate errors, so record assumptions and inspect units. Do not include a total row inside its own SUM range or mix pence and pounds. Use an approved spreadsheet tool and save the editable file for teacher review.

Worked model

Enter B2=3 and C2=2.50, then use D2 =B2*C2 for £7.50.
Copy to D3 and verify the formula now references B3*C3.
Enter three known fictional costs and use =SUM(D2:D4) to obtain £12.75.
Change one input, predict the new total and compare with the sheet.

Guided practice

B3=2 and C3=4.00. What should a copied =B2*C2 formula calculate in D3?

Hint: Relative references move with the formula.

Check the guided answer

In D3 it becomes =B3*C3 and calculates 2×4.00 = £8.00, assuming normal relative copying.

Independent practice

Write your own response to every question before viewing the model answers. Your writing stays in this page session; this activity does not submit, store or grade it. Avoid including private information.

Teacher observed practical evidence

A teacher must apply the school's risk assessment, allergy policy and any individual healthcare plan before the practical. Observe and record the criteria during supervised work. Written answers cannot certify practical safety or skill.

Teacher observes the learner create, inspect and revise an original spreadsheet using fictional or appropriately aggregated data.
Saved file shows labelled columns, functioning formulas, a chart or search result where relevant, and a recorded correction.
Learner explains units, missing values and the limits of the model; no private pupil record is required for the task.

Find and correct a misconception

“A formula result is trustworthy if it looks realistic.”

Correction: Check cell references, range, units and inputs; plausible outputs can still be wrong.

Extend and reflect

Explain when an absolute reference would be useful for a shared rate cell.

Guidance: A fixed rate such as $F$1 can remain anchored when a formula is copied; test the actual tool's syntax.

Where this lesson could lead · Computer Science GCSE → Daskerel Computing and AI

This lesson practises: Use relative cell references in a line formula. Algorithms, digital systems and safe practice support later software and technology work.

Next school subject: Computer Science GCSE. Check the subject and examination board that fit your school.
Later DASKEREL learning: Daskerel Computing and AI. Explore further study and build evidence from practical work.
Later credential exploration: AWS Certified Developer - Associate is an example in this later specialism. Check current awarding-body requirements before planning an exam.
Example career direction: Software Engineer. Explore organisations and local support.

This is an exploratory route, not a promise of admission, a qualification, certification eligibility or employment. Years 7–9 learning is an early foundation; any later credential may require substantial study, experience or local approval.

Year 7 · Data representation · original lesson pack

DASKEREL beta · internal AI review pending

Collect only data needed for a clear question

DASKEREL wrote this teaching and practice using Oak's sequence as a source. View the source lesson at Oak National Academy. Oak has not endorsed this material. Check Oak's terms and separate rights for third-party works.

Learning outcomes

Define a bounded question and matching fields
Explain sampling, missing data and privacy

Vocabulary: field · record · sample · missing value · data minimisation

Retrieve previous learning

What does =SUM(D2:D4) do?

Check: It adds numeric values in that cell range, provided the entries and range are correct.

Learn the concept

A spreadsheet should answer a question. For an invented school library project, 'How many books were borrowed in three sampled lunch periods?' requires date, period and count, not pupils' names or home addresses. Define one record per period and record the units and collection method.

Choose comparable times and explain the sample. Counts from Monday lunch and a whole Friday day are not directly comparable without adjustment. A missing count should be left marked missing until checked, not entered as zero. Record who collected data and when without publishing unnecessary personal identifiers.

Before collecting real information, follow school rules and obtain appropriate permission; a fictional dataset is enough to learn the method. A teacher should inspect the spreadsheet and whether the fields actually support the question. The table cannot answer broader questions about every school library from three periods.

Worked model

Write the limited lunch-period borrowing question.
Choose fields Date, Lunch period, Borrowed count and Collection note.
Record three comparable fictional periods and mark one unavailable count as missing.
State which decision this small table can support and which it cannot.

Guided practice

Why is 'pupil surname' unnecessary for counting books borrowed per lunch period?

Hint: Focus on the aggregate question.

Check the guided answer

The question needs a period count, not an individual's identity. Collecting surnames adds privacy risk without improving that count.

Independent practice

Write your own response to every question before viewing the model answers. Your writing stays in this page session; this activity does not submit, store or grade it. Avoid including private information.

Teacher observed practical evidence

A teacher must apply the school's risk assessment, allergy policy and any individual healthcare plan before the practical. Observe and record the criteria during supervised work. Written answers cannot certify practical safety or skill.

Teacher observes the learner create, inspect and revise an original spreadsheet using fictional or appropriately aggregated data.
Saved file shows labelled columns, functioning formulas, a chart or search result where relevant, and a recorded correction.
Learner explains units, missing values and the limits of the model; no private pupil record is required for the task.

Find and correct a misconception

“Collecting extra personal details makes every dataset better.”

Correction: Only fields needed for the stated purpose should be collected under appropriate school rules.

Extend and reflect

Plan a repeated sample across two weeks.

Guidance: Keep periods and methods comparable, and state how holidays or closures would affect interpretation.

Where this lesson could lead · Computer Science GCSE → Daskerel Computing and AI

This lesson practises: Define a bounded question and matching fields. Algorithms, digital systems and safe practice support later software and technology work.

Next school subject: Computer Science GCSE. Check the subject and examination board that fit your school.
Later DASKEREL learning: Daskerel Computing and AI. Explore further study and build evidence from practical work.
Later credential exploration: AWS Certified Developer - Associate is an example in this later specialism. Check current awarding-body requirements before planning an exam.
Example career direction: Software Engineer. Explore organisations and local support.

This is an exploratory route, not a promise of admission, a qualification, certification eligibility or employment. Years 7–9 learning is an early foundation; any later credential may require substantial study, experience or local approval.

Year 7 · Data representation · original lesson pack

DASKEREL beta · internal AI review pending

Choose a chart that answers the data question

DASKEREL wrote this teaching and practice using Oak's sequence as a source. View the source lesson at Oak National Academy. Oak has not endorsed this material. Check Oak's terms and separate rights for third-party works.

Learning outcomes

Calculate a simple summary from comparable data
Create a labelled chart with a bounded conclusion

Vocabulary: mean · bar chart · axis · scale · outlier

Retrieve previous learning

Why should an unavailable count not be entered as zero?

Check: It would present an unmeasured value as a genuine observation and distort summaries.

Learn the concept

Analysis checks the table before making a chart. With fictional lunch counts 8, 10 and 12, total is 30 and mean is 10 per observed lunch period. If one count is missing, do not divide by three as if it were zero; report the number of valid observations and the missing value.

A bar chart can compare distinct periods. Label its horizontal categories and vertical unit 'books borrowed', use a readable scale and include title and source. A truncated bar axis can exaggerate small differences, so consider a zero baseline for magnitude comparisons. The chart should remain understandable without colour alone.

Conclude only what the data shows: among the three fictional periods, Wednesday's count was highest. It does not prove the same pattern every week or why it occurred. A teacher should inspect the actual chart, formula range and source data for errors.

Worked model

Check fictional values 8,10,12 for comparable units and no missing entries.
Calculate total 30 and mean 10 across three observed periods.
Build a bar chart with period categories, zero baseline and labelled count axis.
Write one bounded comparison and one sampling limit.

Guided practice

Values are 6, 9 and missing. What denominator should a mean of observed counts use?

Hint: Count recorded numeric observations, not all intended rows.

Check the guided answer

Use two recorded counts, giving (6+9)/2 = 7.5 for the observed periods, while clearly stating one period is missing. Do not claim this is a three-period mean.

Independent practice

Write your own response to every question before viewing the model answers. Your writing stays in this page session; this activity does not submit, store or grade it. Avoid including private information.

Teacher observed practical evidence

A teacher must apply the school's risk assessment, allergy policy and any individual healthcare plan before the practical. Observe and record the criteria during supervised work. Written answers cannot certify practical safety or skill.

Teacher observes the learner create, inspect and revise an original spreadsheet using fictional or appropriately aggregated data.
Saved file shows labelled columns, functioning formulas, a chart or search result where relevant, and a recorded correction.
Learner explains units, missing values and the limits of the model; no private pupil record is required for the task.

Find and correct a misconception

“A chart explains why one value is high.”

Correction: It displays an observation; a cause requires additional relevant evidence.

Extend and reflect

Compare a mean with a median when one day is unusually high.

Guidance: Show the sorted values and explain which summary better answers the named question.

Where this lesson could lead · Computer Science GCSE → Daskerel Computing and AI

This lesson practises: Calculate a simple summary from comparable data. Algorithms, digital systems and safe practice support later software and technology work.

Next school subject: Computer Science GCSE. Check the subject and examination board that fit your school.
Later DASKEREL learning: Daskerel Computing and AI. Explore further study and build evidence from practical work.
Later credential exploration: AWS Certified Developer - Associate is an example in this later specialism. Check current awarding-body requirements before planning an exam.
Example career direction: Software Engineer. Explore organisations and local support.

This is an exploratory route, not a promise of admission, a qualification, certification eligibility or employment. Years 7–9 learning is an early foundation; any later credential may require substantial study, experience or local approval.

Year 7 · Data representation · original lesson pack

DASKEREL beta · internal AI review pending

Sort and filter spreadsheet records without losing meaning

DASKEREL wrote this teaching and practice using Oak's sequence as a source. View the source lesson at Oak National Academy. Oak has not endorsed this material. Check Oak's terms and separate rights for third-party works.

Learning outcomes

Sort whole records by a named field
Use a filter to answer a bounded question

Vocabulary: sort · filter · record · ascending · search

Retrieve previous learning

Why should a chart retain a title and labelled axes?

Check: Readers need to know what was measured, in which units and over what categories or period.

Learn the concept

Sorting changes record order by a chosen field; filtering temporarily displays only records meeting a condition. For a fictional book table, sorting by Borrowed count descending shows high counts first. Filtering Month='April' displays April rows without deleting other months from the source file.

Select the entire table when sorting. Sorting only the count column can detach numbers from their dates and titles, corrupting relationships while the spreadsheet still looks tidy. Preserve headers and check the top and bottom rows after a sort. Save an unmodified copy or version when learning the operation.

A search or filter result is limited by spelling, missing values and the chosen condition. If a label appears as 'Sci-Fi' and 'Science fiction', a literal filter may split one category. Standardise categories with a documented rule rather than silently changing source meaning.

Worked model

Create a fictional four-row book table with title, month and borrow count.
Select the whole range and sort borrow count descending.
Filter to April and record the number of visible records without deleting others.
Clear the filter, verify row relationships and note category inconsistencies.

Guided practice

After sorting only column C, dates no longer match counts. What happened?

Hint: A record spans several columns.

Check the guided answer

Only one field moved, so the rows became inconsistent. Restore the original version and sort the full table range including the related date and count columns.

Independent practice

Write your own response to every question before viewing the model answers. Your writing stays in this page session; this activity does not submit, store or grade it. Avoid including private information.

Teacher observed practical evidence

A teacher must apply the school's risk assessment, allergy policy and any individual healthcare plan before the practical. Observe and record the criteria during supervised work. Written answers cannot certify practical safety or skill.

Teacher observes the learner create, inspect and revise an original spreadsheet using fictional or appropriately aggregated data.
Saved file shows labelled columns, functioning formulas, a chart or search result where relevant, and a recorded correction.
Learner explains units, missing values and the limits of the model; no private pupil record is required for the task.

Find and correct a misconception

“Filtering deletes all hidden rows.”

Correction: A filter changes the view; rows remain in the data unless separately deleted.

Extend and reflect

Combine a month filter with descending counts.

Guidance: Explain the order of operations and verify the full table after clearing both settings.

Where this lesson could lead · Computer Science GCSE → Daskerel Computing and AI

This lesson practises: Sort whole records by a named field. Algorithms, digital systems and safe practice support later software and technology work.

Next school subject: Computer Science GCSE. Check the subject and examination board that fit your school.
Later DASKEREL learning: Daskerel Computing and AI. Explore further study and build evidence from practical work.
Later credential exploration: AWS Certified Developer - Associate is an example in this later specialism. Check current awarding-body requirements before planning an exam.
Example career direction: Software Engineer. Explore organisations and local support.

This is an exploratory route, not a promise of admission, a qualification, certification eligibility or employment. Years 7–9 learning is an early foundation; any later credential may require substantial study, experience or local approval.

Year 7 · Data representation · original lesson pack

DASKEREL beta · internal AI review pending

Use conditional formatting to reveal a checked rule

DASKEREL wrote this teaching and practice using Oak's sequence as a source. View the source lesson at Oak National Academy. Oak has not endorsed this material. Check Oak's terms and separate rights for third-party works.

Learning outcomes

Specify a threshold before styling cells
Check boundary and non-colour access to the result

Vocabulary: conditional formatting · threshold · rule · boundary · legend

Retrieve previous learning

What is the difference between a sort and a filter?

Check: Sort changes order; filter changes which records are temporarily visible.

Learn the concept

Conditional formatting changes how a cell looks when a rule is true. In a fictional stock table, a rule may highlight quantities below 5. The number remains unchanged; the style helps a reader notice a condition. Define whether exactly 5 should be highlighted before choosing the comparison.

Test below, at and above the threshold: 4 should meet quantity<5, while 5 and 6 should not. If the rule accidentally uses ≤5, the boundary is wrong. Document the range to which the rule applies; a new row outside that range may receive no formatting.

Colour alone cannot carry meaning. Add a text Status column such as 'Reorder' or 'Enough' from a checked formula or manual rule and supply a legend. A teacher should inspect both the formatting rule and the actual table, including a monochrome or accessible view.

Worked model

Define a fictional low-stock rule quantity<5.
Apply it to the intended numeric range and test 4,5,6.
Add a non-colour status label and a short legend.
Insert a new row, verify whether the rule extends, and record any correction.

Guided practice

A quantity of 5 is highlighted under a supposed 'below 5' rule. What is likely wrong?

Hint: Equality may be included.

Check the guided answer

The rule may use ≤5 rather than <5. Inspect the rule and range, correct it, then retest 4, 5 and 6.

Independent practice

Write your own response to every question before viewing the model answers. Your writing stays in this page session; this activity does not submit, store or grade it. Avoid including private information.

Teacher observed practical evidence

A teacher must apply the school's risk assessment, allergy policy and any individual healthcare plan before the practical. Observe and record the criteria during supervised work. Written answers cannot certify practical safety or skill.

Teacher observes the learner create, inspect and revise an original spreadsheet using fictional or appropriately aggregated data.
Saved file shows labelled columns, functioning formulas, a chart or search result where relevant, and a recorded correction.
Learner explains units, missing values and the limits of the model; no private pupil record is required for the task.

Find and correct a misconception

“A red cell means the stored number has changed.”

Correction: Conditional formatting changes display according to a rule; the underlying value remains unless separately edited.

Extend and reflect

Plan two ranges with different units without conflating their thresholds.

Guidance: Give each a named rule and legend, then test boundary values separately.