Course Content
Chapter 1 Review and Advanced ICT Skills
1.1 Recap of Key ICT Concepts from Year 4 and Year 5
1.2 Advanced Computer Operations and System Navigation
1.3 Managing Computer Files and Folders Effectively
1.4 Customizing Computer Settings and Personalization
1.5 Introduction to Productivity Tools (Keyboard Shortcuts, Automation)
-
Chapter 1.1: Recap of Key ICT Concepts from Year 4 and Year 5
-
Chapter 1.2 Advanced Computer Operations and System Navigation
-
Chapter 1.2 Quiz
-
Chapter 1.3 Managing Computer Files and Folders Effectively
-
Chapter 1.3 Quiz
-
Chapter 1.4 Customizing Computer Settings and Personalization
-
Chapter 1.4 Quiz
-
Chapter 1.5 Introduction to Productivity Tools (Keyboard Shortcuts, Automation)
-
Chapter 1.5 Quiz
-
Chapter 1 Exam
Chapter 2: Programming and Computational Thinking
2.1 What is Programming? (Overview of Coding and Its Importance)
2.2 Writing Algorithms and Flowcharts
2.3 Block-Based Programming with Scratch (Building Games and Stories)
2.4 Introduction to Python Programming
Variables and Data Types
Input and Output Functions
Lists and Loops
Simple Conditionals (If-Else)
2.5 Introduction to Computational Thinking (Decomposition, Pattern Recognition, Debugging)
2.6 Mini-Project: Create a Simple Python-Based Quiz or Calculator
-
Chapter 2.1 What is Programming? (Overview of Coding and Its Importance)
-
Chapter 2.1 Quiz
-
Chapter 2.2 Writing Algorithms and Flowcharts
-
Chapter 2.2 Quiz
-
Chapter 2.3: Block-Based Programming with Scratch (Building Games and Stories)
-
Chapter 2.3 Quiz
-
Chapter 2.4 Introduction to Python Programming
-
Chapter 2.4 Quiz
-
Chapter 2.5 Introduction to Computational Thinking (Decomposition, Pattern Recognition, Debugging)
-
Chapter 2.5 Quiz
-
Chapter 2.6 Mini-Project: Create a Simple Python-Based Quiz or Calculator
-
Chapter 2 Exam
Chapter 3: Web Design and Development
3.1 Introduction to HTML and CSS (Creating Simple Web Pages)
3.2 Building Web Pages with Text, Images, and Links
3.3 Understanding Web Design Principles (Layouts, Colors, Fonts)
3.4 Introduction to Web Hosting and Publishing Websites
3.5 Basic JavaScript for Interactivity (Simple Buttons, Alerts)
3.6 Hands-on Project: Build and Publish a Personal Website
-
Chapter 3.1 Introduction to HTML and CSS (Creating Simple Web Pages)
-
Chapter 3.1 Quiz
-
Chapter 3.2 Building Web Pages with Text, Images, and Links
-
Chapter 3.2 Quiz
-
Chapter 3.3 Understanding Web Design Principles (Layouts, Colors, Fonts)
-
Chapter 3.3 Quiz
-
Chapter 3.4 Introduction to Web Hosting and Publishing Websites
-
Chapter 3.4 Quiz
-
3.5 Basic JavaScript for Interactivity (Simple Buttons, Alerts)
-
Chapter 3.5 Quiz
-
Chapter 3.6 Hands-on Project: Build and Publish a Personal Website
-
Chapter 3 Exam
Chapter 4: Advanced Word Processing and Document Management
4.1 Advanced Features in Word Processors (Tables, Columns, Mail Merge)
4.2 Inserting and Formatting Complex Tables and Graphics
4.3 Using Templates and Styles to Enhance Documents
4.4 Collaborative Document Editing and Commenting (Google Docs, Office 365)
4.5 Preparing Documents for Printing (Page Setup, Headers/Footers)
4.6 Mini-Project: Create a Professional Report with Advanced Formatting
-
Chapter 4.1 Advanced Features in Word Processors (Tables, Columns, Mail Merge)
-
Chapter 4.1 Quiz
-
Chapter 4.2 Inserting and Formatting Complex Tables and Graphics
-
Chapter 4.2 Quiz
-
Chapter 4.3 Using Templates and Styles to Enhance Documents
-
Chapter 4.3 Quiz
-
Chapter 4.4 Collaborative Document Editing and Commenting (Google Docs, Office 365)
-
Chapter 4.4 Quiz
-
Chapter 4.5 Preparing Documents for Printing (Page Setup, Headers/Footers)
-
Chapter 4.5 Quiz
-
Chapter 4.6 Mini-Project: Create a Professional Report with Advanced Formatting
-
Chapter 4 Exam
Chapter 5: Advanced Spreadsheet Skills and Data Analysis
5.1 Using Advanced Functions (VLOOKUP, CONCATENATE, COUNTIF)
5.2 Creating and Using Dynamic Charts (Bar, Pie, Line)
5.3 Data Validation and Conditional Formatting
5.4 Introduction to Data Analysis (Sorting, Filtering, Pivot Tables)
5.5 Collaborative Spreadsheets (Google Sheets, Excel Online)
5.6 Mini-Project: Create a Spreadsheet to Track Expenses and Generate Reports
-
Chapter 5.1 Using Advanced Functions (VLOOKUP, CONCATENATE, COUNTIF)
-
Chapter 5.1 Quiz
-
Chapter 5.2 Creating and Using Dynamic Charts (Bar, Pie, Line)
-
Chapter 5.2 Quiz
-
Chapter 5.3 Data Validation and Conditional Formatting
-
Chapter 5.3 Quiz
-
Chapter 5.4 Introduction to Data Analysis (Sorting, Filtering, Pivot Tables)
-
Chapter 5.4 Quiz
-
Chapter 5.5 Collaborative Spreadsheets (Google Sheets, Excel Online)
-
Chapter 5.5 Quiz
-
Chapter 5.6 Mini-Project: Create a Spreadsheet to Track Expenses and Generate Reports
-
Chapter 5 Exam
Chapter 6: Multimedia Creation and Digital Media
6.1 Introduction to Image Editing (Using Software like Paint.NET, Canva)
6.2 Creating and Editing Digital Videos (Using Software like Windows Movie Maker)
6.3 Working with Audio Files and Podcasts (Audacity, Online Tools)
6.4 Introduction to Animation and Digital Art
6.5 Creating Digital Presentations (Advanced Slideshows with Multimedia)
6.6 Hands-on Project: Create a Digital Advertisement or Promotional Video
-
Chapter 6.1 Introduction to Image Editing (Using Software like Paint.NET, Canva)
-
Chapter 6.1 Quiz
-
Chapter 6.2 Creating and Editing Digital Videos (Using Software like Windows Movie Maker)
-
Chapter 6.2 Quiz
-
Chapter 6.3 Working with Audio Files and Podcasts (Audacity, Online Tools)
-
Chapter 6.3 Quiz
-
Chapter 6.4 Introduction to Animation and Digital Art
-
Chapter 6.4 Quiz
-
Chapter 6.5 Creating Digital Presentations (Advanced Slideshows with Multimedia)
-
Chapter 6.5 Quiz
-
Chapter 6.6 Hands-on Project: Create a Digital Advertisement or Promotional Video
-
Chapter 6 Exam
Chapter 7: Introduction to Databases
7.1 Understanding Databases and Their Uses
7.2 Designing a Simple Database (Tables, Fields, Records)
7.3 Using Queries to Search and Organize Data
7.4 Introduction to SQL (Basic SELECT, INSERT, DELETE, UPDATE Commands)
7.5 Generating Reports and Analyzing Data
7.6 Hands-on Project: Build a Simple Student Database with Queries
-
Chapter 7.1 Understanding Databases and Their Uses
-
Chapter 7.1 Quiz
-
Chapter 7.2 Designing a Simple Database (Tables, Fields, Records)
-
Chapter 7.2 Quiz
-
Chapter 7.3 Using Queries to Search and Organize Data
-
Mini-Project: Creating and Using Queries in a Student Database
-
Chapter 7.4 Introduction to SQL (Basic SELECT, INSERT, DELETE, UPDATE Commands)
-
Chapter 7.4 Quiz
-
Chapter 7.5 Generating Reports and Analyzing Data
-
Chapter 7.5 Quiz
-
Chapter 7.6 Hands-on Project: Build a Simple Student Database with Queries
-
Chapter 7 Exam
Chapter 8: Networking and Communication
8.1 Introduction to Computer Networks (LAN, WAN, and Internet)
8.2 Basic Networking Concepts (Routers, Modems, IP Addresses)
8.3 Email Communication and Etiquette
8.4 Introduction to Online Collaboration Tools (Google Meet, Zoom, Microsoft Teams)
8.5 Using Cloud Storage and File Sharing Services (Google Drive, Dropbox)
8.6 Mini-Project: Set Up and Manage a Cloud-Based Shared Folder for a Group
-
Chapter 8.1 Introduction to Computer Networks (LAN, WAN, and Internet)
-
Chapter 8.1 Quiz
-
Chapter 8.2 Basic Networking Concepts (Routers, Modems, IP Addresses)
-
Chapter 8.2 Quiz
-
Chapter 8.3: Email Communication and Etiquette
-
Chapter 8.3 Quiz
-
Chapter 8.4 Introduction to Online Collaboration Tools (Google Meet, Zoom, Microsoft Teams)
-
Chapter 8.4 Quiz
-
Chapter 8.5 Using Cloud Storage and File Sharing Services (Google Drive, Dropbox)
-
Chapter 8.5 Quiz
-
Chapter 8.6 Mini-Project: Set Up and Manage a Cloud-Based Shared Folder for a Group
-
Chapter 8 Exam
Chapter 9: Cybersecurity and Ethical Hacking
9.1 Understanding Cybersecurity (Viruses, Malware, Phishing)
9.2 How to Protect Personal Information Online (Privacy Settings, Secure Websites)
9.3 Safe Online Communication (Avoiding Scams, Recognizing Fake News)
9.4 Introduction to Ethical Hacking (Basic Penetration Testing and Cyber Threats)
9.5 Using Strong Passwords and Two-Factor Authentication
9.6 Reporting Cyberbullying, Abuse, and Harmful Content
9.7 Capture the Flag Cybersecurity Challenge
-
Chapter 9.1 Understanding Cybersecurity (Viruses, Malware, Phishing)
-
Chapter 9.1 Quiz
-
Chapter 9.2 How to Protect Personal Information Online (Privacy Settings, Secure Websites)
-
Chapter 9.2 Quiz
-
Chapter 9.3 Safe Online Communication (Avoiding Scams, Recognizing Fake News)
-
Chapter 9.3 Quiz
-
Chapter 9.4 Introduction to Ethical Hacking (Basic Penetration Testing and Cyber Threats)
-
Chapter 9.4 Quiz
-
Chapter 9.5 Using Strong Passwords and Two-Factor Authentication
-
Chapter 9.5 Quiz
-
Chapter 9.6 Reporting Cyberbullying, Abuse, and Harmful Content
-
Chapter 9.6 Quiz
-
Chapter 9.7 Capture the Flag (CTF) Cybersecurity Challenge
-
Chapter 9 Exam
Chapter 10: Digital Citizenship and Ethical Use of Technology
10.1 Rights and Responsibilities in the Digital World
10.2 Protecting Your Online Reputation and Digital Footprint
10.3 Avoiding Plagiarism and Using Creative Commons Content
10.4 Respecting Others Online (Netiquette, Handling Disagreements)
10.5 Cyberbullying and How to Protect Yourself and Others
10.6 Mini-Project: Create a Digital Citizenship Awareness Campaign
-
Chapter 10.1 Rights and Responsibilities in the Digital World
-
Chapter 10.1 Quiz
-
Chapter 10.2 Protecting Your Online Reputation and Digital Footprint
-
Chapter 10.2 Quiz
-
Chapter 10.3 Avoiding Plagiarism and Using Creative Commons Content
-
Chapter 10.3 Quiz
-
Chapter 10.4 Respecting Others Online (Netiquette, Handling Disagreements)
-
Chapter 10.4 Quiz
-
Chapter 10.5 Cyberbullying and How to Protect Yourself and Others
-
Chapter 10.5 Quiz
-
Chapter 10.6 Mini-Project: Create a Digital Citizenship Awareness Campaign
-
Chapter 10 Exam
Chapter 11: ICT in the Real World
11.1 The Role of ICT in Business and Industry (Automation, Software)
11.2 How ICT is Used in Healthcare and Education
11.3 The Impact of ICT on Government and Public Services
11.4 Exploring the Digital Divide and How Technology Affects Different Regions
11.5 Innovations in ICT (Artificial Intelligence, Robotics, Virtual Reality)
-
Chapter 11.1 The Role of ICT in Business and Industry (Automation, Software)
-
Chapter 11.1 Quiz
-
Chapter 11.2 How ICT is Used in Healthcare and Education
-
Chapter 11.2
-
Chapter 11.3 The Impact of ICT on Government and Public Services
-
Chapter 11.3 Quiz
-
Chapter 11.4 Exploring the Digital Divide and How Technology Affects Different Regions
-
Chapter 11.4 Quiz
-
Chapter 11.5 Innovations in ICT (Artificial Intelligence, Robotics, Virtual Reality)
-
Chapter 11.5 Quiz
Chapter 12: Exploring Emerging Technologies
12.1 Introduction to Artificial Intelligence and Machine Learning
12.2 The Role of Robotics in Modern Technology
12.3 The Future of Virtual Reality and Augmented Reality
12.4 The Internet of Things (IoT) and Smart Devices
12.5 Blockchain Technology and Its Impact on the Future
12.6 Hands-on Project: Experiment with AI Tools (Teachable Machine, Chatbots)
-
Chapter 12.1 Introduction to Artificial Intelligence and Machine Learning
-
Chapter 12.1 Quiz
-
Chapter 12.2 The Role of Robotics in Modern Technology
-
Chapter 12.2 Quiz
-
Chapter 12.3 The Future of Virtual Reality and Augmented Reality
-
Chapter 12.3 Quiz
-
Chapter 12.4 The Internet of Things (IoT) and Smart Devices
-
Chapter 12.4 Quiz
-
Chapter 12.5 Blockchain Technology and Its Impact on the Future
-
Chapter 12.5 Quiz
-
Chapter 12.6 Hands-on Project: Experiment with AI Tools (Teachable Machine, Chatbots)
-
Chapter 12 Exam
Chapter 13: ICT in Problem Solving and Innovation
13.1 Using ICT to Solve Real-World Problems (Design Thinking Process)
13.2 Creating a Simple Tech Solution (App, Website, or Game)
13.3 Using ICT to Contribute to Sustainable Development
13.4 Collaborative Problem Solving Using Online Tools
13.5 Mini Hackathon: Design and Present a Tech Solution for a Social Issue
-
Chapter 13.1 Using ICT to Solve Real-World Problems (Design Thinking Process)
-
Chapter 13.1 Quiz
-
Chapter 13.2 Creating a Simple Tech Solution (App, Website, or Game)
-
Chapter 13.2 Quiz
-
Chapter 13.3 Using ICT to Contribute to Sustainable Development
-
Chapter 13.3 Quiz
-
Chapter 13.4 Collaborative Problem Solving Using Online Tools
-
Chapter 13.4 Quiz
-
Chapter 13.5 Mini Hackathon: Design and Present a Tech Solution for a Social Issue
-
Chapter 13 Exam
Chapter 14: Preparing for Year 7 Computer Science
14.1 Introduction to Computer Science (What to Expect in Year 7)
14.2 Transitioning from ICT to Computer Science (Key Differences)
14.3 Developing Logical Thinking and Problem-Solving Skills
14.4 Review of Programming Concepts and Introduction to Algorithms
14.5 Introduction to Logic Gates and Binary Numbers
14.6 Preparing for Future Technology Careers and Pathways in Computer Science
-
Chapter 14.1 Introduction to Computer Science (What to Expect in Year 7)
-
Chapter 14.2 Transitioning from ICT to Computer Science (Key Differences)
-
Chapter 14.2 Quiz
-
Chapter 14.3 Developing Logical Thinking and Problem-Solving Skills
-
Chapter 14.3 Quiz
-
Chapter 14.4: Review of Programming Concepts and Introduction to Algorithms
-
Chapter 14.4 Quiz
-
Chapter 14.5 Introduction to Logic Gates and Binary Numbers
-
Chapter 14.6 Preparing for Future Technology Careers and Pathways in Computer Science
-
Chapter 14 Exam
Final Exam
Instructions: Choose the best answer for each question.
-
Final Exam
Appendix
-
Appendices
Student Ratings & Reviews
No Review Yet