Click-through visual lessons covering CAPE IT Unit 2, mapped to the official CXC syllabus objectives. Each lesson opens as a self-contained, step-through explainer — no login, no install.
← Back to EduTech STEM AcademyCovers Specific Objectives 1–13: from basic data terminology through to normalisation and building a working database.
Field → Record → Table → File → Database → DBMS, the data hierarchy from the ground up.
Column/field, row/record/tuple, plus the five reasons organisations use files and databases — including redundancy, mining, warehousing and data marts.
Formats, volume, compression, access method and speed — plus a scrubbable timeline of storage devices from papyrus to holographic storage.
How websites interface with databases behind the scenes, and the seven ways poor data quality hurts an organisation.
Database vs. traditional files, master/transaction files, file organisation methods, and hierarchical / relational / network / object-oriented databases.
Entity, process, data store, data flow — context-level vs. Level 1 diagrams, with two fully worked examples.
Why normalise, attribute redundancy and anomalies, and 1NF/2NF/3NF applied to worked before-and-after tables.
Primary/foreign/composite keys, relationship types, entity-relationship diagrams, and turning an ERD into tables, forms, queries and reports.
A full CAPE-style lesson plan for teaching the data-hierarchy terms, with a guided-practice worksheet and exit-ticket question.
Specific Objectives 1–12: reasons for using IT tools, productivity software, information sources, web page construction, and emerging technology.
The core reasons organisations and individuals adopt IT tools — speed, accuracy, storage, communication and more.
Software types, word-processor/spreadsheet/presentation/DBMS features, operating system types, and criteria for choosing the right tool.
Choosing the right format, weighing information sources, and criteria for accepting or rejecting information.
Remote IT tools, your first HTML page, formatting/colour/links/images, and authoring tools vs. frameworks.
Alternative input/output/displays, intelligent appliances, wearables, IoT, AI, blockchain, cloud and robotics.
Specific Objectives 1–13: IT's impact on society, computer crime, security/health/environmental risks and mitigation, licensing, and plagiarism.
Automation, knowledge management, jobs, e-learning, economy, commerce, governance, culture, health, politics, bias and diversity.
Identity, hardware and property crimes; cyberterrorism, hacking and fraud; malware types; and phishing schemes.
System components as targets, disaster and security risks, and the mitigation strategies for each — plus health, safety and environmental risks.
Legal/ethical considerations in handling information, plus internet, email and security policies.
Copyright, patents, trademarks, proprietary data/software, licensing arrangements, product activation and DRM.
Forms and implications of plagiarism, and the consequences of software piracy for both owner and user.
Social implications of life online, machine interactions with customers, and categories of wearable computing.
Looking for the full paid course? CAPE IT Unit 2, Module 1 is also available as a 30-lesson guided platform with videos, teacher slides and the Bayview Market project — built from the same syllabus objectives as this free library.
Visit the CAPE Learning Platform →