← VCE Data Analytics U4O1

Writing a prompt that asks an AI tool to chart or summarise data

Instructions given to an AI tool. A good one states the data (field names), the chart or summary wanted, the audience and the format, using sample or de-identified data.

Understanding Writing a prompt that asks an AI tool to chart or summarise data in VCE Data Analytics U4O1

What it does: Stating the audience lets the AI choose suitable language, detail and layout. Using a small sample with names removed keeps personal information out of the AI tool while still showing the data structure. A good prompt names the fields (Month, Sales), states the chart type, names the audience and says the format wanted. Vague prompts give vague results. Naming the fields tells the AI exactly which data to use. If it has to guess, it may use the wrong columns or invent values. Stating the chart type (line, column, pie, scatter) removes guesswork. A line chart suits change over time.

Common mistakes: The audience is vague. A good prompt names who will read the chart, such as 'Audience: Year 7 students', so the AI can pitch the language and detail. Real names and marks should not be pasted into an AI tool. The prompt should use sample or de-identified data, such as 'Use sample data: Name, Maths'.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

This module's key terms are also in a printable crossword (Modules 3–37) and word search (Modules 3–62).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
Which prompt is better for getting an AI tool to chart data?
Make me a chart of my data.Make a column chart of Month and Sales for a Year 12 class. Output as a table I can paste into a spreadsheet.
Matches
Make a chart of my data.
↓
Too vague: it does not name the fields, the chart type, the audience or the format.
Applying
Meanings
Term
AI prompt
Meaning
Instructions given to an AI tool. A good one states the data (field names), the chart or summary wanted, the audience and the format, using sample or de-identified data.
Practice
Data: de-identified sample with fields StudentID, Maths, English, Science
Testing
Gaps
Chart the temperature for each Day.
Check Answer
Spots
3Chart: line chart of Max by Day
4Audience: whoever

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

The 'Snowy Owl' badge — List Slicer, one of Cloodit's 106 collectible badges
Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy
Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games
Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print
Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Quick Questions

1. Which prompt is better for getting an AI tool to chart data?
A. Make me a chart of my data.
B. Make a column chart of Month and Sales for a Year 12 class. Output as a table I can paste into a spreadsheet. ✓
A good prompt names the fields (Month, Sales), states the chart type, names the audience and says the format wanted. Vague prompts give vague results.
2. A student wants an AI tool to summarise survey results. Which detail should they include in the prompt?
A. The field names, such as Age Group and Satisfaction Score ✓
B. Nothing about the columns; the AI will guess them
Naming the fields tells the AI exactly which data to use. If it has to guess, it may use the wrong columns or invent values.
3. Which prompt clearly states the chart type?
A. Create a line chart showing Temperature by Day. ✓
B. Show Temperature by Day in a good way.
Stating the chart type (line, column, pie, scatter) removes guesswork. A line chart suits change over time.
4. Which prompt states the audience?
A. Summarise the results using some words.
B. Summarise the results for Year 7 students using plain language. ✓
Stating the audience lets the AI match the language, level of detail and tone to the people who will read it.
5. Which data is safer to paste into an AI tool prompt?
A. Sample data with names replaced by IDs (Student 1, Student 2) ✓
B. The full class list with real names and home addresses
Use sample or de-identified data. Personal information should not be shared with an AI tool, because you may not control how it is stored or used.

Match the Pairs

Use the columns Name, Year and Score → Names the fields so the AI knows exactly which data to use
Make a bar chart of average Score by Year → States the chart type and what it should show
A good prompt states who will read the result, so the AI can pitch it correctly → The audience is Year 9 students and their parents.
Only sample or de-identified data should be pasted into a prompt, to protect privacy → Here are 5 sample rows with names removed: Year 9, 72
Make a chart of my data. → Too vague: it does not name the fields, the chart type, the audience or the format.
Here is our full student list with names and addresses: Ava Nguyen, 12 King St, 88 ... → Pastes real personal information into an AI tool instead of sample or de-identified data.

Key Term

AI prompt
Instructions given to an AI tool. A good one states the data (field names), the chart or summary wanted, the audience and the format, using sample or de-identified data.

Fill in the Blanks

1. Fields: Day, Max, Min, Rain Chart the Min temperature for each Day.
Hint: Type the field name that holds the lowest temperature.
2. Create a scatter plot of Hours and Mark to show if the two are correlated.
Hint: Type the chart type that shows the link between two numeric fields.
3. Chart: bar chart of Sales by Month Audience: the school principal Format: one PNG image
Hint: Type the label word that names who the chart is for.
4. Data: de-identified sample, ID not Name
Hint: Type the word for data with personal details removed.
5. Give the result as a table with columns House and Average, then a short summary.
Hint: Type the output format that has rows and columns.

Spot the Error

Question 1
A Task: Chart weather data
B Fields: Day, Max, Rain
C Chart: line chart of Max by Day
D Audience: whoever
E Format: PNG image
Line D — The audience is vague. A good prompt names who will read the chart, such as 'Audience: Year 7 students', so the AI can pitch the language and detail.
Question 2
A Use real data: Ava Nguyen, 88
B Chart: bar chart of Maths
C Audience: parents
D Format: one slide
Line A — Real names and marks should not be pasted into an AI tool. The prompt should use sample or de-identified data, such as 'Use sample data: Name, Maths'.
Question 3
A Data: Item, Price, Qty
B Task: summarise sales
C Summary: total Cost by Item
D Audience: canteen staff
Line C — Cost is not one of the named fields (Item, Price, Qty), so the AI would have to guess. The summary should use a listed field: 'Summary: total Qty by Item'.
Question 4
A Fields: Day, Max, Min, Rain
B Audience: Year 9 class
C Chart: make something nice
D Format: PNG image
Line C — No chart type is stated. The prompt should name the chart and the fields it uses, such as 'Chart: bar of Rain by Day'.
Question 5
A Fields: Name, Maths, Science
B Chart: pie Maths v Science
C Goal: show if marks are linked
D Audience: Year 11 students
Line B — A pie chart shows parts of a whole and cannot show whether two marks are related. The goal needs a scatter plot: 'Chart: scatter Maths v Science'.

Student with a class code? Join your class →