1
Health and Safety
Ergonomics – Accessing Content on 21st Century ICT
Computer Principles
Computer System Components and Characteristics
Main Components of a Computer System
Physical Care for Computer Systems
Categories of Computers – Introduction Discussion
Comparison of computer systems
Comparison of computer types (updated image)
Videos: Categories of Computers (Created for csec syllabus, but also applies to NCSE ICT)
Software
Keyboarding and Keyboarding Techniques
Keyboards and Keyboard Layout
Typing using a QWERTY Keyboard
Offline Application Practical: Typing – Practical Exercise
Online Application Practical: Introduction to typing (Live class)
Computer maintenance
Word Processing
Justification – Word Processing
Formatting a letter – Text, Tables, Layout – Tutorial
Text And Graphics, Page breaks and Columns – Document Layout
Presentation Software
Presentation Software – Classroom Instructions
Video Series: Using Powerpoint presentation Software
Internet And Web 2.0 Tools
Introduction to the Internet, WWW and Hyperlinks
Reliability of information sources
Creating and managing Passwords online.
Computational Thinking
Computational Thinking – A simple task! (Optional Class Activity)
Introduction to Scratch Programing (Copied from below)
Installing Scratch 2 for a Better Help and Tutorial Experience (Copied from below)
How to share a Scratch Project (Copied from below)
Drawing using sequence and looping
Scratch: Drawing a Square, Square Variable exercise
Additional Scratch Drawing Exercises
What do these scratch programs draw?
What do these scratch programs draw? – Solutions
Cat Crossing the Street! (Activities involving 2 persons)
Ethics
INFORMATION PROTECTION AND MISUSE (Copied from level 3 below)
2
Word Processing
Reviewing Documents – Word Processing
Document Review Tutorial – Track Changes, Comments
Video: Word processing revision.
Spreadsheets
Spreadsheets: Introduction, definition & terminology
Introduction to Spreadsheets – Live Excel Demo
Inserting rows and Columns, Formatting Cells and Formula Revision
Reviewing Functions – Max,Min,Sum and Introducing average
Sorting information and formatting values
Absolute Addressing and Chart Creation, Revision – Spreadsheets Tutorial
Spreadsheet Course Work Solution
Video Creation
Video Creation using Source files – Tutorial
Storyboards – Professional Video Creation (Part 1)
The Video Brief – Professional Video Creation (Part 2)
The Video Rationale Document – Professional Video Creation (Part 3)
The Video Script – Professional Video Creation (Part 4)
Complex example: Video Brief, Rationale & Script – Professional Video Creation (Part 5)
Video Brief Template With inline Instructions – Professional Video Creation (Part 6)
Video Script Template With inline Instructions – Professional Video Creation (Part 7)
Project – Create a Video Using a Storyboard.
Retrospective – The video production pipeline.
Internet and Communication
INFORMATION PROTECTION AND MISUSE
Use Of Web tools and Team Collaboration
Wikis for online collaboration
Computational Thinking
Introduction to Computational Thinking
Using Computational Thinking to solve a Math problem
3
Hardware Specifications
Hardware Specifications – Computer Ports
Computer Suitability by Specification
ICT Social and Ethical Impacts
Threats to Computer and Data Security
Problem solving using algorithms
WHAT IS AN ALGORITHM? – DEFINITION
Solution: Narrative Algorithm for Snakes and ladders
Selection Statements: Practise Exercise(s)
Using multiple selection statements (By Example)
Repetition (Iteration) Constructs
Finding the Average of 5 numbers using Looping
Selection and Iteration exercise
Scratch Programming
Soft introduction to scratch
Introduction to Scratch Programming
Making a Sprite Jump In Scratch
Installing Scratch 2 for a Better Help and Tutorial Experience
How to share a Scratch Project
Intermediate Scratch Programming
NCSE ICT – Scratch Programming – Manipulating sprites
NCSE ICT – Scratch Programming – Animating Sprites using loops and the Broadcast system
Scratch – Selection, Sensing, Repetition, Outputting Results.
NCSE ICT – Scratch Programming – Creating interactive sprites
Tutorial Project
Assignment Projects
Catch by Coordinate – Scratch Game Assignment
Catch by Coordinate – Scratch Game Assignment (Solution)
Group Project – Create a Game in Scratch!