Checking an AI-generated visualisation against the data

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. An AI tool gives you a bar chart of your sales data. What should you do before using it?

A Trust it because AI tools are always accurate

B Compare each bar's value with the source data

2. The source data shows Term 3 sales of 450, but the AI chart labels that bar as 540. What does this show?

A A harmless rounding difference

B A value error that must be corrected

3. An AI line chart has a y-axis that starts at 90 instead of 0, which makes a small rise look huge. What should you check?

A The axis scale, to see if it exaggerates the change

B Only the chart colours

4. Your data has 5 months, but the AI chart shows 6 columns including a month called 'Aug' that is not in your file. What is this?

A Invented data that should be removed

B Extra detail that improves the chart

5. Which check is part of confirming an AI-generated chart is accurate?

A Check that labels and titles match the source data fields

B Check that the chart looks professional

Match the Pairs

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

Left column		Right column
1Chart bar for Term 3 = 52, source cell C4 = 25		ACompare with source values: a value on the chart does not match the source data, so it must be corrected
2Y-axis starts at 90 instead of 0 on a column chart		BCheck the axis scale: a truncated axis exaggerates small differences between bars
3Look for invented data: the AI chart shows a category that is not in the dataset		CChart has a 'Sept' bar but the CSV only has Jan to Aug
4Compare the total of the chart values with the total of the source data		DThe label does not match the source data, so the chart is misleading and the label must be corrected.
5The chart looks professional, so I will submit it without opening the dataset.		EA polished look does not prove accuracy; the chart was never compared with the source values, labels and axes.
6Source data is in dollars but the AI chart axis label says 'Units sold'		F=SUM(B2:B9) - SUM(chart_values) should equal 0

Definitions

Check against source data

Fill in the Blanks

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

=___(B2:B9)

=_____(B2:B9)

=IF(B2_F2,"Match","Check")

=___(B2:B9)

Spot the Error

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

Question 1

A source = [12, 18, 25, 30]

B chart = [12, 18, 25, 30]

C for i in range(len(source)):

D if source[i] == chart[i]:

E print("Mismatch", i)

Question 2

A src = {"Mon": 5, "Tue": 8}

B ai = {"Mon": 5, "Tue": 8}

C for day in src:

D if ai[days] != src[days]:

E print("Check", day)

Question 3

A values = [40, 55, 90]

B axis_start == 0

C if axis_start > 0:

D print("Axis starts above 0")

Question 4

A src = ["Ava", "Liam", "Mia"]

B chart = ["Ava", "Liam", "Zed"]

C for name in src:

D if name not in src:

E print("Invented:", name)

Question 5

A src_title = "Sales by Month"

B chart_title = "Sales by Month"

C if src_title != chart_title

D print("Label differs")

Answer Key

Checking an AI-generated visualisation against the data

Section A: Quick Questions

B — Compare each bar's value with the source data

B — A value error that must be corrected

A — The axis scale, to see if it exaggerates the change

A — Invented data that should be removed

A — Check that labels and titles match the source data fields

Section B: Match the Pairs

Chart bar for Term 3 = 52, source cell C4 = 25 → Compare with source values: a value on the chart does not match the source data, so it must be corrected

Y-axis starts at 90 instead of 0 on a column chart → Check the axis scale: a truncated axis exaggerates small differences between bars

Look for invented data: the AI chart shows a category that is not in the dataset → Chart has a 'Sept' bar but the CSV only has Jan to Aug

Compare the total of the chart values with the total of the source data → =SUM(B2:B9) - SUM(chart_values) should equal 0

The chart looks professional, so I will submit it without opening the dataset. → A polished look does not prove accuracy; the chart was never compared with the source values, labels and axes.

Source data is in dollars but the AI chart axis label says 'Units sold' → The label does not match the source data, so the chart is misleading and the label must be corrected.

Section C: Definitions

Check against source data — Compare every value, label and axis scale in an AI-generated chart with the original data, and look for invented figures, before you trust or use the chart.

Section D: Fill in the Blanks

=SUM(B2:B9)

=MAX(B2:B9)

=COUNT(B2:B9)

=IF(B2=F2,"Match","Check")

=MIN(B2:B9)

Section E: Spot the Error

D — The check is reversed. Using == flags values that match. To catch chart values that differ from the source data, it should be !=.

D — The loop variable is day, not days, so the check fails with a NameError. It should compare ai[day] with src[day] for each source value.

B — A single = is needed to store the axis start in a variable. Using == only compares and leaves axis_start undefined, so the axis scale check cannot run.

C — To look for invented data, loop over the chart's labels and test each one against the source. Looping over src can never find a name that exists only in the chart.

C — The if statement is missing its colon at the end. It should be if src_title != chart_title: so the label check runs.