Dynamic data visualisations

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which best describes a dynamic data visualisation?

A It is connected to live data and updates when the data changes

B It is a fixed image that never changes once it is saved

2. A weather dashboard is linked to a sensor feed. When a new reading arrives, the chart changes. What is this showing?

A A live data connection

B A static image

3. A student changes a value in the source table. What should happen in a dynamic chart linked to that table?

A The chart stays exactly the same forever

B The chart updates after a refresh (or automatically)

4. What does clicking Refresh do in a dynamic visualisation?

A It reloads the latest data from the source into the visual

B It deletes the data source and starts again

5. Which is an example of a user control in a dynamic visualisation?

A A screenshot of the chart pasted into a report

B A slicer that lets the user pick one year level

Match the Pairs

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

Left column		Right column
1Refresh All		AThe fixed range ignores new rows, so the chart does not show new data and is not fully dynamic.
2Slicer: House = Red		BA pasted picture is static. It has no link to the data, so it never updates when the data changes.
3A live data connection links a chart to its source, so new data appears in the chart		C=IMPORTDATA("https://data.gov.au/sales.csv")
4A dynamic visualisation is built on a table that grows, so charts include new rows automatically		DReloads the data connection so charts show the latest values from the source
5Chart pasted as a picture (PNG) from the data		EInsert > Table (Sales_Table)
6Chart built on fixed range A1:B10 only		FA user control that filters the visualisation to show only Red house data

Definitions

dynamic data visualisation

Fill in the Blanks

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

=___(B2:B9)

SELECT house, SUM(points) FROM students ________ house;

IF data changes THEN _______ chart

SELECT firstName, points FROM students _____ house = 'Red';

="Average mark: "_ROUND(AVERAGE(B2:B9),1)

Spot the Error

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

Question 1

A SET source TO live_feed

B CONNECT chart TO source

C ON refresh: DELETE chart

D SHOW chart

Question 2

A source = connect('sales_db')

B chart = bar_chart(snapshot)

C chart.auto_refresh(60)

Question 3

A CREATE dropdown year_filter

B SET chart.data TO live_data

C ON chart CHANGE: REDRAW

Question 4

A PASTE values INTO chart

B EVERY 30 SECONDS: REFRESH

C DISPLAY chart

Question 5

A live_db = connect('weather')

B chart = line_chart(live_db)

C def update():

D chart.redraw(old_data)

Answer Key

Dynamic data visualisations

Section A: Quick Questions

A — It is connected to live data and updates when the data changes

A — A live data connection

B — The chart updates after a refresh (or automatically)

A — It reloads the latest data from the source into the visual

B — A slicer that lets the user pick one year level

Section B: Match the Pairs

Refresh All → Reloads the data connection so charts show the latest values from the source

Slicer: House = Red → A user control that filters the visualisation to show only Red house data

A live data connection links a chart to its source, so new data appears in the chart → =IMPORTDATA("https://data.gov.au/sales.csv")

A dynamic visualisation is built on a table that grows, so charts include new rows automatically → Insert > Table (Sales_Table)

Chart pasted as a picture (PNG) from the data → A pasted picture is static. It has no link to the data, so it never updates when the data changes.

Chart built on fixed range A1:B10 only → The fixed range ignores new rows, so the chart does not show new data and is not fully dynamic.

Section C: Definitions

dynamic data visualisation — An interactive visual linked to live data, so charts update when the data changes or the user refreshes it or uses controls like filters.

Section D: Fill in the Blanks

=SUM(B2:B9)

SELECT house, SUM(points)
FROM students
GROUP BY house;

IF data changes THEN refresh chart

SELECT firstName, points FROM students
WHERE house = 'Red';

="Average mark: "&ROUND(AVERAGE(B2:B9),1)

Section E: Spot the Error

C — A dynamic visualisation redraws when the data is refreshed. Deleting the chart removes it. The line should be ON refresh: UPDATE chart.

B — The chart must be built from the live connection (source). A fixed snapshot never changes, so the chart would not update. It should be bar_chart(source).

C — The user control (year_filter) should trigger the redraw. Listening to the chart means that choosing a year does nothing. It should be ON year_filter CHANGE: REDRAW.

A — Pasting values makes a static copy that cannot update. A dynamic chart needs a live connection: CONNECT chart TO live_data.

D — The update function must redraw using the live data connection. Using old_data redraws stale values. It should be chart.redraw(live_db).