← VCE Data Analytics U3O1

Artificial intelligence features in software tools

Smart tools inside everyday software, like Copilot in Excel, that suggest formulas and charts, answer plain-English questions and find insights automatically.

Part of: VCE Data Analytics - U3O1 - Data Analytics — Module 130

Understanding Artificial intelligence features in software tools in VCE Data Analytics U3O1

What it does: The student types an ordinary English question and the AI feature works out the formula or answer from the data. Recommended Charts looks at the selected cells and proposes suitable chart types, which is a chart suggestion AI feature. Copilot is built into Excel. It works inside the spreadsheet you already use, so you don't need extra hardware. AI assistants can suggest formulas from your description. You should still check that the formula is correct before you rely on it. Automated insights are patterns, trends or outliers that the software finds without you searching for them. Built-in AI features let you describe tasks in everyday language. They make tools easier to use, but understanding the results still matters.

Common mistakes: AVG is not a spreadsheet function. The AI suggestion should use =AVERAGE(B2:B9) to find the mean. A trend over days is best shown with a line chart. A pie chart shows parts of a whole, so it is the wrong pick.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

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

🖨 Print worksheet + answer key Add Artificial intelligence features in software tools to a class →

This module's key terms are also in a printable crossword (Modules 130–148) and word search (Modules 94–148).

Take this worksheet further — free with Cloodit

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

Learning
Duo
Copilot in Excel is an example of which kind of feature?
An AI feature built into a software toolA separate hardware device you plug in
Matches
Copilot's suggested formula was pasted in and used without checking the result.
↓
AI suggestions can be wrong, so the output must be checked against the data, for example with a hand-calculated answer, before it is trusted.
Applying
Meanings
Term
built-in AI features
Meaning
Smart tools inside everyday software, like Copilot in Excel, that suggest formulas and charts, answer plain-English questions and find insights automatically.
Practice
=COUNTIF(B2:B9,">=80")
Testing
Gaps
=(B2:B9)
Check Answer
Spots
1Prompt: Average Maths mark
2Suggest: =AVG(B2:B9)

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

The 'Butterfly' badge — Branch Hopper, 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.

Add to class →

Quick Questions

1. Copilot in Excel is an example of which kind of feature?
A. An AI feature built into a software tool ✓
B. A separate hardware device you plug in
Copilot is built into Excel. It works inside the spreadsheet you already use, so you don't need extra hardware.
2. You type 'Which subject has the highest average mark?' into a spreadsheet assistant. What is this called?
A. A natural-language question ✓
B. A formula error
Natural-language questions are written in plain English instead of formula syntax. The AI then works out the formula or result for you.
3. A spreadsheet assistant suggests =AVERAGE(B2:B9) after you describe what you want. What is it doing?
A. Suggesting a formula ✓
B. Deleting your data
AI assistants can suggest formulas from your description. You should still check that the formula is correct before you rely on it.
4. After you select your data, the software suggests a column chart and a line chart. This is called:
A. Data validation
B. Chart suggestions ✓
Chart suggestions are an AI feature that recommends chart types based on the data you select. You choose the one that best fits your purpose.
5. A tool scans your sales data and tells you 'Sales peak every December'. This is an example of:
A. Manual sorting
B. Automated insights ✓
Automated insights are patterns, trends or outliers that the software finds without you searching for them.

Match the Pairs

Copilot in Excel → A built-in AI assistant that can suggest formulas, build charts and answer questions about the data in your spreadsheet.
Analyze Data / Ideas → An automated insights feature that scans a table and suggests charts, trends and patterns without you writing any formulas.
A natural-language question lets you ask about your data in plain English instead of writing a formula. → Which student scored the highest Maths mark?
A chart suggestion feature recommends a chart type that suits the selected data. → Recommended Charts
Copilot's suggested formula was pasted in and used without checking the result. → AI suggestions can be wrong, so the output must be checked against the data, for example with a hand-calculated answer, before it is trusted.
Built-in AI features only work in Excel and cannot suggest anything in other software. → AI features are built into many everyday tools, such as spreadsheets, word processors and presentation or search software, not just Excel.

Key Term

built-in AI features
Smart tools inside everyday software, like Copilot in Excel, that suggest formulas and charts, answer plain-English questions and find insights automatically.

Fill in the Blanks

1. Prompt: add up all the Maths marks =SUM(B2:B9)
Hint: Type the function name Copilot would suggest to add up a range of values.
2. Prompt: what is the average English mark? =AVERAGE(C2:C9)
Hint: Type the cell range holding the English marks (column C, data rows only).
3. Prompt: how many Maths marks are 80+? =COUNTIF(B2:B9,">=80")
Hint: Type the function name that counts only the cells meeting a condition.
4. Insight: highest Science mark =MAX(D2:D9)
Hint: Type the function name that returns the largest value in a range.
5. Prompt: mark each Maths result pass or fail =IF(B2>=50,"Pass","Fail")
Hint: Type the comparison operator that means 'greater than or equal to'.

Spot the Error

Question 1
A Prompt: Average Maths mark
B Suggest: =AVG(B2:B9)
C Review the result
D Accept if it matches the data
Line B — AVG is not a spreadsheet function. The AI suggestion should use =AVERAGE(B2:B9) to find the mean.
Question 2
A Select data A1:B8
B Open Recommended Charts
C Choose pie chart for trend
D Add title and axis labels
Line C — A trend over days is best shown with a line chart. A pie chart shows parts of a whole, so it is the wrong pick.
Question 3
A Ask in binary code only
B Q: Who has the top Maths?
C Answer: Mia (95)
D Verify against the sheet
Line A — Natural-language questions let you ask in plain English. You do not need binary code or any special syntax.
Question 4
A Select the Rain column
B Click Analyze Data
C Insight: Fri is driest
D Check insight in the data
Line C — Friday has 22 mm of rain, the highest value, so it is the wettest day. The insight should say Fri is wettest.
Question 5
A Prompt: Count marks over 80
B Suggest: =COUNTIF(B2:B9,>80)
C Result: 3
D Compare with a manual count
Line B — The condition in COUNTIF must be in quotes. It should be ">80".

Student with a class code? Join your class →