Ghana curriculum lesson note

Basic 6 Computing Term 2 Week 9 Lesson Plan

Need the editable version?

Generate, personalize and download the complete lesson plan on Sirbus.

Create Lesson Plan
Week 9: Lesson Plan
Subject: Computing
Class: Basic 6
Topic: Introduction to Electronic Spreadsheet
Strand: Programming and DatabasesSub-strand: Introduction to Electronic Spreadsheet
Indicator (code): B6.5.3.1.6Content Std (code): B6.5.3.1
Performance Indicator: Learners can identify and correct common errors in an MS-Excel worksheet.Core Competencies: Digital Literacy, Critical Thinking
T.L.R.(s): Laptops with Excel, screenshots of error messagesKeywords: Error, #VALUE!, #DIV/0!, Correction, Data Validation
Phase 1: Starterpreparing the brain for learning
Recap previous knowledge about and correct common errors in a. Quick brainstorm: What do you already know about and correct common errors in a? Introduction to today's objectives regarding and correct common errors in a. Mental drill or quick quiz related to and correct common errors in a.
Phase 2: Mainnew learning including assessment
1. Introduce common error codes like #NAME? (wrong formula name) and #VALUE! (adding text to numbers). 2. Demonstrate how to resize columns to see hidden data. 3. Show how to check the 'Formula Bar' to see what is actually written in a cell. 4. Practical: Learners are given a 'broken' spreadsheet and must find and fix three errors.
Phase 3plenary / reflections
Summarize what we learned today about and correct common errors in a. Oral assessment: Answer key questions on and correct common errors in a. Learners share one new thing they found out about and correct common errors in a. Check for understanding and wrap up the week on and correct common errors in a.

Need the editable version?

Generate, personalize and download the complete lesson plan on Sirbus.

Create Lesson Plan

More Basic 6 Computing Term 2 Lessons

Week 1Sub-strand: Introduction to MS-PowerPointWeek 2Sub-strand: Introduction to DatabasesWeek 3Sub-strand: Introduction to DatabasesWeek 4Sub-strand: Introduction to DatabasesWeek 5Sub-strand: Introduction to Electronic SpreadsheetWeek 6Sub-strand: Introduction to Electronic SpreadsheetWeek 7Sub-strand: Introduction to Electronic SpreadsheetWeek 8Sub-strand: Introduction to Electronic SpreadsheetWeek 9 (current)Week 10Sub-strand: Introduction to Electronic SpreadsheetWeek 11Sub-strand: Introduction to Electronic SpreadsheetWeek 12Sub-strand: Spreadsheet Final Review