QCE Digital Solutions Unit 2: Data principles
Students learn how data is organised, named, formatted, typed and represented, and how integrity, redundancy, anomalies and security principles keep data trustworthy.
One content description from the full QCE Digital Solutions Unit 2 — Data and Programming Techniques journey. All 32 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (32)
1
Naming a database and its tables
2
Naming columns, primary keys and foreign keys
3
Dataset file formats: CSV, XLSX, JSON and XML
4
Reasons for using TXT, CSV and XML data sources
5
Data dictionary
6
One-dimensional arrays
7
Records: grouping fields of different data types
8
Two-dimensional arrays
9
Choosing a data structure
10
Same data, different representations
11
Text data: character and string
12
Numeric data: integer
13
Numeric data: floating point
14
Date/time data
15
Boolean data
16
Choosing a data type for a value
17
SQL column data types and sizes
18
Data integrity: authenticity
19
Data integrity: correctness
20
Data integrity: reasonableness
21
Data integrity: timeliness
22
Data quality: accuracy
23
The repeated-data problem in one big table
24
Data completeness
25
Data consistency
26
Insertion anomaly
27
Update anomaly
28
Deletion anomaly
29
Confidentiality
30
Data security: integrity
31
Data security: availability
32
User permissions: read, write and execute
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 →