FREE • FORM 2 • 18 LESSONS • 3 MODULES
Form 2 ICT
Spreadsheets, video creation, communicating online with email, blogs and shared documents, and making sprites draw and act in Scratch. Work through the modules in order, or jump straight to the topic you are doing in class.
On this page: Module 3 · Module 4 · Module 5 · Other forms
Form 2 modules
Each card lists its lessons in order. The number in bold is the objective number in the curriculum.
MODULE 3 • FORM 2 • 8 LESSONS
Module 3: Software Applications
Word processing, spreadsheets and video creation
Polish a document, build spreadsheets with formulas, functions and charts, then plan, film and edit a video.
- 3.8 – Paragraph Formatting: Design an Invitation
- 3.9 – Proofing Your Work: Spelling, Grammar, Thesaurus and Find and Replace
- 3.10 – Your First Spreadsheet: Cells, Rows and Columns
- 3.11 – Spreadsheet Formulas and Functions: SUM, AVERAGE, MIN and MAX
- 3.12 – Sorting Data and Absolute Cell References
- 3.13 – Making Charts from Spreadsheet Data
- 3.14 – Planning and Capturing a Video
- 3.15 – Editing Your Video: Cuts, Sound, Transitions and Titles
More notes and exercises (21)
- 3.9 · Notes: Reviewing Documents – Word Processing
- 3.9 · Video: Document Review Tutorial – Track Changes, Comments
- 3.10 · Notes: Spreadsheets: Introduction, definition & terminology
- 3.10 · Notes: Create a simple Spreadsheet
- 3.12 · Video: Sorting information and formatting values
- 3.12 · Exercise: Simple Sorting, Subsorting Tutorial.
- 3.12 · Video: Absolute Addressing and Chart Creation, Revision – Spreadsheets Tutorial
- 3.13 · Exercise: Simple Chart Exercise / Tutorial (With Solution)
- 3.13 · Project: Spreadsheet Assignment 1
- 3.13 · Solution: Spreadsheet Course Work Solution
- 3.14 · Video: Video Creation using Source files – Tutorial
- 3.14 · Notes: Storyboards – Professional Video Creation (Part 1)
- 3.14 · Notes: The Video Brief – Professional Video Creation (Part 2)
- 3.14 · Notes: The Video Rationale Document – Professional Video Creation (Part 3)
- 3.14 · Notes: The Video Script – Professional Video Creation (Part 4)
- 3.14 · Notes: Complex example: Video Brief, Rationale & Script – Professional Video Creation (Part 5)
- 3.14 · Notes: Video Brief Template With inline Instructions – Professional Video Creation (Part 6)
- 3.14 · Notes: Video Script Template With inline Instructions – Professional Video Creation (Part 7)
- 3.14 · Project: Project – Create a Video Using a Storyboard.
- 3.15 · Notes: Retrospective – The video production pipeline.
- 3.15 · Project: Contingency project: Assignment – Creating a 4 Scene Scratch Animation Using A Storyboard
Class recordings – oldest first (16)
- 3.8 · Video: Invitation Tutorial Demonstration (live class) (class of 11 Sep 2026)
- 3.9 · Video: Tracking Changes Class Demo – The Foolish Donkey (class of 18 Sep 2023)
- 3.9 · Video: Tracking Changes – Live Class Demo (Minimal) (class of 18 Sep 2023)
- 3.10 · Video: Introduction to Spreadsheets – Live Excel Demo (class of 13 Jan 2021)
- 3.10 · Video: Spreadsheet Introduction – Form 2 (live class) (class of 13 May 2025)
- 3.11 · Video: Inserting rows and Columns, Formatting Cells and Formula Revision (class video) (class of 21 Jan 2021)
- 3.11 · Video: Reviewing Functions – Max, Min, Sum and Introducing average (class video) (class of 27 Jan 2021)
- 3.11 · Video: Form 2, Excel Formulas and functions with formatting, inserting (class video) (class of 12 Jan 2022)
- 3.11 · Video: Form 2 S Live class Instruction on Excel Formulas (class of 20 Jan 2022)
- 3.11 · Video: Spreadsheet Tutorial 3 (live class) – up to and including Average (class of 20 May 2025)
- 3.11 · Video: Tutorial 3 – The IF Function (live class) (class of 21 May 2025)
- 3.12 · Video: Sorting, Sub sorting – Spreadsheets (live class) (class of 30 Oct 2023)
- 3.13 · Video: Form 2 Spreadsheet Assignment preparation, demonstration, closure (class video) (class of 3 Feb 2022)
- 3.13 · Video: Insert a chart in Excel (live class, 2A) (class of 12 Oct 2023)
- 3.13 · Video: Sorting, Charts (Spreadsheets live class) (class of 3 Jun 2025)
- 3.15 · Video: Professional Video Editing – Class Instruction (class of 12 Oct 2021)
Class handouts: C30 (3.8).
MODULE 4 • FORM 2 • 6 LESSONS
Module 4: Internet and Web 2.0 Tools
Use information responsibly and communicate online: texting, email, blogs, VoIP and working together on shared documents.
- 4.4 – Using Information Responsibly
- 4.5 – Texting and Instant Messaging
- 4.6 – Setting Up and Using Email
- 4.7 – Blogs in School and Everyday Life
- 4.8 – VoIP vs Landline
- 4.9 – Working Together Online: Wikis and Google Drive
More notes and exercises (7)
- 4.4 · Notes: INFORMATION PROTECTION AND MISUSE
- 4.5 · Notes: SMS vs IM on mobile phones
- 4.6 · Notes: Email Introduction
- 4.7 · Notes: Blogs (Weblog)
- 4.8 · Notes: VOIP
- 4.9 · Notes: Wikis for online collaboration
- 4.9 · Notes: Collaborating with each other
MODULE 5 • FORM 2 • 4 LESSONS
Module 5: Programming Concepts and Computational Thinking
Plan towards a goal, think like a computer scientist, and make sprites draw and act in Scratch.
- 5.3 – Planning to Reach a Goal: What, When and Why
- 5.4 – Thinking Like a Computer Scientist
- 5.5 – Scratch: Paint a Sprite and Draw an Image
- 5.6, 5.7 – Scratch: Plan and Act Out a Two-Character Scene
More notes and exercises (13)
- 5.3 · Notes: Introduction to Computational Thinking
- 5.3 · Exercise: Basic Computational Thinking Exercise
- 5.4 · Notes: Using Computational Thinking to solve a Math problem
- 5.4 · Solution: Algorithm Solution: Using Computational Thinking to solve a Math problem
- 5.4 · Notes: Computational thinking
- 5.4 · Exercise: Difference of 2 Consecutive Squares (Exercise)
- 5.5 · Notes: Scratch: Creating a New Sprite [External Resource]
- 5.5 · Exercise: What do these scratch programs draw?
- 5.5 · Solution: What do these scratch programs draw? – Solutions
- 5.5 · Exercise: A Slanted Rectangle – Revision Exercise
- 5.5 · Solution: A Slanted Rectangle – Solution
- 5.6 · Exercise: Cat Crossing the Street! (Activities involving 2 persons)
- 5.7 · Exercise: Cat Crossing the Street! (continues from 5.6)
Class recordings – oldest first (2)
- 5.4 · Video: C45 – Difference of 2 Squares Exercise – 3NA (recorded class) (class of 5 Jun 2026)
- 5.5 · Video: Scratch Introduction – Form 2A (class video) (class of 12 May 2021)
Other forms
FORM 1
Form 1 ICT
Start here. Health and safety, how computers work, your first documents and slide shows, the Web, first steps in Scratch, and being a good digital citizen.
FORM 3
Form 3 ICT
Spec sheets and ICT careers, malware and computer crime, then algorithms, flowcharts, Scratch games and debugging.
FORMS 4–5
CSEC Information Technology
Finished Form 3? Carry on with the CSEC® Information Technology notes.
← Back to Lower School ICT Notes
© 2026 Vedesh Kungebeharry. All rights reserved.