Clarifying data refresh requirements

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which is a clear refresh requirement for a dashboard?

A Data refreshes automatically every day at 6 am from the sales database

B The dashboard should be kept up to date somehow

2. A school canteen dashboard must show today's sales by lunchtime. Which refresh frequency suits it best?

A Refresh every hour during the school day

B Refresh once a year

3. Which statement describes a manual refresh?

A A named staff member clicks Refresh to load the latest data

B A scheduled task loads new data without anyone clicking

4. Which refresh requirement names the data source and connection?

A Refresh from wherever the data is stored

B Refresh from the linked Google Sheet of student survey results

5. Why include a 'Last updated' date and time on a dashboard?

A It makes the data refresh faster

B It shows users how current the data is, so they can trust it

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Refresh: daily at 6:00 am		ARefresh: manual, by the data analyst each Friday
2Last updated: 14/03/2025 6:00 am		BA label that shows users when the dashboard data was last refreshed
3A refresh requirement can state that the update is automatic and linked to a data source connection		CA frequency statement that says how often the data behind the dashboard is updated
4A refresh requirement can state who is responsible for a manual refresh		DThe requirement is vague. It gives no frequency, method or person responsible, so no one knows when the data is updated.
5Refresh: when needed		ERefresh: automatic from the sales database
6Refresh: automatic, by the teacher each week		FThe requirement contradicts itself. An automatic refresh runs without a person, but it says a teacher does it, so the method is unclear.

Definitions

refresh requirements

Fill in the Blanks

Complete each line of code by filling in the missing parts.

="Last updated: "&TEXT(___(),"dd/mm/yyyy")

refreshMode = "_________" # runs by itself

refreshFrequency = "_____" # once per day

dataSource = "sales.csv" chart.connectTo(__________)

refreshMode = "______" # user clicks Refresh

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Dashboard: Daily Sales

B Frequency: every day at 6am

C Method: manual

D Owner: system schedule

Question 2

A Dashboard: Live Bus Times

B Source: transport database

C Frequency: never

D Method: automatic

Question 3

A Dashboard: Weather Station

B Connection: none, typed in

C Frequency: every 10 minutes

D Method: automatic

Question 4

A Method: automatic, by officer

B Frequency: every Monday

C Responsible: data officer

D Display: last updated date

Question 5

A Dashboard: School Attendance

B Source: attendance.xlsx

C Frequency: every Friday

D Display: hide last updated

Answer Key

Clarifying data refresh requirements

Section A: Quick Questions

A — Data refreshes automatically every day at 6 am from the sales database

A — Refresh every hour during the school day

A — A named staff member clicks Refresh to load the latest data

B — Refresh from the linked Google Sheet of student survey results

B — It shows users how current the data is, so they can trust it

Section B: Match the Pairs

Refresh: daily at 6:00 am → A frequency statement that says how often the data behind the dashboard is updated

Last updated: 14/03/2025 6:00 am → A label that shows users when the dashboard data was last refreshed

A refresh requirement can state that the update is automatic and linked to a data source connection → Refresh: automatic from the sales database

A refresh requirement can state who is responsible for a manual refresh → Refresh: manual, by the data analyst each Friday

Refresh: when needed → The requirement is vague. It gives no frequency, method or person responsible, so no one knows when the data is updated.

Refresh: automatic, by the teacher each week → The requirement contradicts itself. An automatic refresh runs without a person, but it says a teacher does it, so the method is unclear.

Section C: Definitions

refresh requirements — Statements of how often, how and by whom the data behind a dynamic visualisation is updated, e.g. a daily automatic refresh from the data source.

Section D: Fill in the Blanks

="Last updated: "&TEXT(NOW(),"dd/mm/yyyy")

refreshMode = "automatic" # runs by itself

refreshFrequency = "daily" # once per day

dataSource = "sales.csv"
chart.connectTo(dataSource)

refreshMode = "manual" # user clicks Refresh

Section E: Spot the Error

C — The refresh is scheduled and owned by the system, so the method must be automatic. A manual method contradicts the schedule. It should be 'Method: automatic'.

C — A live bus times dashboard must be refreshed often. 'never' is not a usable frequency and means the data would go stale. It should be something like 'Frequency: every 1 minute'.

B — An automatic refresh every 10 minutes needs a connection to the data source. Typing data in by hand is not a connection. It should be 'Connection: link to weather API'.

A — If a data officer does the update, the method is manual. 'automatic' and 'by officer' contradict each other. It should be 'Method: manual, by officer'.

D — Refresh requirements should show a 'last updated' date so users know how current the data is. Hiding it removes that. It should be 'Display: last updated date'.