ACARA 9-10 Digital Technologies: Storing data in spreadsheets and databases
Students organise data in well-structured spreadsheets and model it in single-table and relational databases using keys, relationships and basic SQL.
One content description (AC9TDI10P01, AC9TDI10P03) from the full ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data journey. All 12 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (12)
1
Spreadsheet rows, columns and cells
2
Entering data into cells
3
Header labels for rows and columns
4
Organising data in a table with headings
5
Keeping an untouched copy of the raw data
6
What a single-table database is
7
Database field data types
8
Primary key
9
What is a relational database?
10
Foreign key and table relationships
11
CREATE TABLE and INSERT INTO
12
Importing a CSV file into a database table
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →