Creating and editing simple MS Excel content for Primary 4

Class: Primary 4
Term: Second Term
Week: 4
Age: 9 years
Duration: 45 minutes
Subject: Basic Digital Literacy
Curriculum Theme: Basic Computer Operations
Focal competence: Creating and editing digital content using MS Office applications
Key competencies/values: ICT and Digital Competencies; Information Literacy
Skills:

• Creating and editing digital content using MS Excel

Previous Lesson: Creating and editing simple MS Word and MS PowerPoint content
Topic: Digital Content Creation: Spreadsheet
Subject Matter: Creating and editing simple MS Excel content

Specific Objectives

By the end of the lesson, pupils should be able to:

Cognitive Domain

• Identify the main components of an MS Excel spreadsheet (cells, rows, columns).
• State the steps to create a new Excel workbook.
• Recall how to enter labels and numbers into cells.

Affective Domain

• Appreciate the importance of spreadsheets for organising data.
• Show willingness to follow instructions for creating and editing Excel content.

Psychomotor Domain

• Demonstrate how to create a new MS Excel workbook.
• Practically enter labels and numbers into spreadsheet cells.
• Edit existing content within Excel cells.
• Create a simple two-column table in MS Excel.

Social Domain

• Collaborate with peers during guided practice sessions.

Reference Materials

The following resources were used in planning this lesson:

• 2025 Revised 9 Years Basic Education Curriculum
• Relevant State Unified Scheme of Work
• Basic Digital Literacy for Primary Schools, Book 4
• The HeadTeacher Scheme of work

Instructional Materials

The teacher will teach this lesson with the aid of:

• Computers
• Tablets
• Smartphones
• Internet Access (if available for online spreadsheet tools)
• Projector (to display screen for demonstration)
• Whiteboard/Chalkboard
• Markers/Chalk

Rationale for the Lesson

This lesson provides pupils with fundamental skills in using spreadsheet software, which is essential for organizing and managing data in various real-world scenarios. Learning to create and edit simple Excel content builds a foundation for more advanced digital literacy and problem-solving. It equips pupils with practical tools for academic tasks and future careers.

Prerequisite/Previous Knowledge

Pupils should have basic knowledge of computer operations, including how to turn on/off a computer or device, open applications, and use a keyboard and mouse/touchscreen.

Lesson Content/Board Summary

Digital Content Creation: Spreadsheet

What is Microsoft Excel?

Microsoft Excel is a popular computer program used to create and manage spreadsheets. A spreadsheet is like a large table made of rows and columns, used for organizing and calculating data. It helps us keep information neat and easy to understand.

Parts of an Excel Spreadsheet

1. Workbook: This is the entire Excel file. It can contain many worksheets.
2. Worksheet: This is a single page within a workbook, like a page in a notebook.
3. Cell: This is a small box where a row and a column meet. Each cell has a unique address (e.g., A1, B5).
4. Row: These are the horizontal lines of cells, numbered 1, 2, 3, and so on.
5. Column: These are the vertical lines of cells, lettered A, B, C, and so on.

Creating a New MS Excel Workbook

To start a new spreadsheet in Excel:

1. Open the Microsoft Excel application on your computer or device.
2. Click on “File” in the menu bar.
3. Select “New” or “New Workbook”.
4. Choose “Blank Workbook” to start with an empty spreadsheet.

Entering Data into Cells

Data can be text (labels) or numbers.

1. Labels (Text): These are words or names used to describe data.

   To enter a label:

   1. Click on the cell where you want to type.
   2. Type the text (e.g., “Name”, “Item”, “Quantity”).
   3. Press the Enter key or click on another cell.
2. Numbers: These are numerical values used for calculations or counting.

   To enter a number:

   1. Click on the cell where you want to type.
   2. Type the number (e.g., “10”, “50”, “2023”).
   3. Press the Enter key or click on another cell.

Editing Cell Content

Editing means changing what is already in a cell.

1. Method 1 (Type over):
   1. Click on the cell you want to edit.
   2. Type the new content directly.
   3. Press Enter. (This replaces the old content).
2. Method 2 (Edit within cell):
   1. Double-click on the cell you want to edit.
   2. Use the Backspace or Delete key to remove mistakes.
   3. Type the corrections.
   4. Press Enter.

Creating a Simple Two-Column Table

A simple two-column table can be created by entering labels in the first row and then filling in data below them.

Example: A list of fruits and their quantities.

1. In cell A1, type “Fruit Name”.
2. In cell B1, type “Quantity”.
3. In cell A2, type “Apple”.
4. In cell B2, type “5”.
5. In cell A3, type “Orange”.
6. In cell B3, type “8”.

Teaching Methods/Instructional Techniques

Discussion, Demonstration, Guided Practice, Question and Answer, Explanation, Practical Activity, Individual Practice

Instructional Procedures

Step 1: Introduction

Time: 3 minutes

Teaching Skill: Engaging/Recalling

Teacher’s Activity: The teacher greets the pupils and asks them if they know any computer programs used for writing or drawing. The teacher then introduces MS Excel as a program for organizing information in tables.

Pupils’ Activity: Pupils respond to the teacher’s questions and listen attentively to the introduction.

Learning Point: Introduction to spreadsheets

Step 2: Explanation of MS Excel

Time: 5 minutes

Teaching Skill: Explanation/Illustration

Teacher’s Activity: The teacher explains what MS Excel is and its purpose, showing a visual example of a spreadsheet on a projector or a computer screen. The teacher also highlights the basic parts: workbook, worksheet, cells, rows, and columns.

Pupils’ Activity: Pupils observe the demonstration and listen to the explanation, identifying the parts of a spreadsheet.

Learning Point: Understanding MS Excel basics

Step 3: Demonstration of Creating a New Workbook

Time: 5 minutes

Teaching Skill: Demonstration

Teacher’s Activity: The teacher demonstrates step-by-step how to open MS Excel and create a new blank workbook on a computer or tablet, explaining each click and menu option clearly.

Pupils’ Activity: Pupils watch the teacher’s demonstration carefully, mentally noting the steps.

Learning Point: Creating new workbooks

Step 4: Demonstration of Entering Data (Labels and Numbers)

Time: 7 minutes

Teaching Skill: Demonstration/Modelling

Teacher’s Activity: The teacher demonstrates how to click on a cell, type text (labels) like “Name” and “Age”, and numbers like “10” and “9”, then press Enter. The teacher ensures pupils understand the difference between labels and numbers.

Pupils’ Activity: Pupils observe the teacher entering different types of data into cells.

Learning Point: Entering data into cells

Step 5: Demonstration of Editing Cell Content

Time: 7 minutes

Teaching Skill: Demonstration/Practical Guidance

Teacher’s Activity: The teacher demonstrates two ways to edit cell content: typing over existing content and double-clicking to edit within the cell. The teacher shows how to correct a mistake in a cell.

Pupils’ Activity: Pupils pay attention to the editing techniques demonstrated by the teacher.

Learning Point: Editing cell content

Step 6: Guided Practice: Creating and Editing a Simple Table

Time: 9 minutes

Teaching Skill: Guided Practice/Supervision

Teacher’s Activity: The teacher guides pupils to open Excel on their devices. The teacher then instructs them to create a simple two-column table (e.g., “Item” and “Price”) by entering labels and numbers into cells. The teacher walks around to assist pupils and correct errors, encouraging them to try editing some of their entries.

Pupils’ Activity: Pupils actively create and edit their own simple two-column tables in Excel with teacher guidance.

Learning Point: Creating simple tables

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

1. What is MS Excel used for?
2. How do you create a new blank workbook?
3. How do you enter text or numbers into a cell?
4. Give two ways to edit content in an Excel cell.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Understanding Excel operations

Step 8: Note-Taking

Time: 4 minutes

Teaching Skill: Guided Writing

Teacher’s Activity: The teacher guides pupils to copy the essential Board Summary notes about creating and editing simple MS Excel content into their notebooks.

Pupils’ Activity: Pupils copy the notes carefully into their notebooks.

Learning Point: Recording lesson notes

Step 9: Conclusion

Time: 2 minutes

Teaching Skill: Summarising

Teacher’s Activity: The teacher briefly reminds pupils that MS Excel is a powerful tool for organizing data and encourages them to practice creating and editing spreadsheets at home if they have access to a computer or device.

Pupils’ Activity: Pupils listen to the teacher’s concluding remarks.

Learning Point: Reinforcing spreadsheet importance

Continuous Assessment/Further Study

Type: Homework

Instruction: Using a computer or tablet with MS Excel (or a similar spreadsheet app), create a simple two-column table with the following information:

1. Column 1: “School Supplies”
2. Column 2: “Quantity Needed”
3. Enter at least 5 different school supplies (e.g., “Pencil”, “Eraser”, “Notebook”) and their quantities.
4. Edit one of the quantities you entered to a new number.

Lesson Keywords

• Excel – A computer program for making spreadsheets.
• Spreadsheet – A digital table with rows and columns for organizing data.
• Cell – A single box in a spreadsheet where a row and column meet.
• Row – A horizontal line of cells in a spreadsheet.
• Column – A vertical line of cells in a spreadsheet.
• Workbook – An entire Excel file.
• Worksheet – A single page within an Excel workbook.
• Data – Information, facts, or numbers stored in a spreadsheet.
• Label – Text or words used to describe data in a cell.
• Number – Numerical values used in a cell.
• Edit – To change or correct existing content in a cell.

Differentiation

Support for Weaker Learners: Provide one-on-one guidance during practical sessions. Allow them to work in pairs with a more capable peer. Provide pre-filled templates with some data for them to simply edit.

Extension for Faster Learners: Challenge them to add a third column to their table (e.g., “Colour”) or try to change the font colour or size of the text in their table. Introduce them to simple formulas like adding two numbers.

Suggested Lesson Videos

For visual demonstrations, search on YouTube for: MS Excel for kids Primary 4 tutorial

Teacher Guide for Using This Lesson Plan

Before the lesson, ensure all computers, tablets, or smartphones are charged and have MS Excel or a compatible spreadsheet application installed and ready. Test the projector if you plan to use one for demonstrations. Begin by engaging pupils with questions about organizing information to link to the concept of spreadsheets. Follow the step-by-step demonstration process, ensuring each pupil clearly sees how to create a new workbook, enter data, and edit cells. During the guided practice, circulate actively to provide immediate feedback and support. Encourage pupils to help each other while monitoring for misconceptions. Pupils should copy the Board Summary notes after the practical activities and evaluation to consolidate their learning. Emphasise the importance of careful handling of devices and following instructions for safety and effective learning.