Ghana curriculum lesson note

Basic 6 Computing Term 2 Week 11 Lesson Plan

Need the editable version?

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

Create Lesson Plan
Week 11: 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.2 - B6.5.3.1.6Content Std (code): B6.5.3.1
Performance Indicator: Learners can complete a comprehensive spreadsheet project incorporating formatting and formulas.Core Competencies: Digital Literacy, Critical Thinking
T.L.R.(s): Laptops, data for 'Class Library Project'Keywords: Project, Formatting, AutoSum, Average, Charts
Phase 1: Starterpreparing the brain for learning
Recap previous knowledge about Introduction to Electronic Spreadsheet. Quick brainstorm: What do you already know about Introduction to Electronic Spreadsheet? Introduction to today's objectives regarding Introduction to Electronic Spreadsheet. Mental drill or quick quiz related to Introduction to Electronic Spreadsheet.
Phase 2: Mainnew learning including assessment
1. Final Project: Learners create a 'Class Library Database'. 2. Tasks: Enter book titles and costs -> Format headers in Bold and colors -> Use AutoSum to find total value -> Use Average to find mean cost. 3. Visualization: Create a Bar Chart showing the number of books in different categories (Fiction, Science, History). 4. Saving: Demonstrate how to save the file with a specific name in a folder.
Phase 3plenary / reflections
Summarize what we learned today about Introduction to Electronic Spreadsheet. Oral assessment: Answer key questions on Introduction to Electronic Spreadsheet. Learners share one new thing they found out about Introduction to Electronic Spreadsheet. Check for understanding and wrap up the week on Introduction to Electronic Spreadsheet.

Need the editable version?

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

Create Lesson Plan

More Basic 6 Computing Term 2 Lessons