Information and Communication Technology — 1.2 COMPONENTS OF COMPUTER SYSTEMS

Form 1 · 80 minutes · TERM 2. WEEK 10 · 13 July 2026

SchoolST. MARY'S DAY SECONDARY SCHOOL

TeacherMATHEWS MALAMA CHIBULU

Date13 Jul 2026

ClassForm 1

SubjectInformation and Communication Technology

Duration80 min

Time13:40 - 15:00 hrs

Learners—

Term/WeekTERM 2. WEEK 10

Topic

1.2 COMPONENTS OF COMPUTER SYSTEMS

Sub-Topic

1.2.2 SOFTWARE

General Competences

Digital Literacy, Critical Thinking, Communication

Specific Competences

1.2.2.2 Use different types of applications software

Learning Activities

Microsoft excel spreadsheet Charts Creating Charts

Expected Standard

1.2.2.2.1 Different types of applications software used appropriately.

References

—

Lesson Goal

By the end of this lesson, learners should be able to use different types of applications software appropriately by identifying common examples, explaining their purposes, and creating a chart using Microsoft Excel spreadsheet software. The lesson emphasises the correct selection and application of software tools for specific tasks, aligned with the expected standard 1.2.2.2.1.

Rationale

This lesson builds directly on learners' prior understanding of computer hardware and the distinction between hardware and software introduced in earlier lessons, deepening their knowledge of the software component by focusing specifically on applications software and its practical uses. Understanding applications software is essential for learners' everyday lives in Zambia, as it empowers them to use digital tools for school projects, personal organisation, and future employment in an increasingly digital economy; this lesson promotes the values of precision, creativity, and responsible digital citizenship. Through a competence-based approach using guided inquiry, hands-on spreadsheet exploration, collaborative chart creation, and whole-class discussion, the lesson develops Digital Literacy, Critical Thinking, and Communication as learners actively engage with real software tools to solve authentic problems.

Prior Knowledge / Prerequisite Knowledge

Learners have already been introduced to the basic concept of a computer system and can distinguish between hardware (physical parts) and software (programs or instructions). They are familiar with the idea that a computer needs software to function and can name common tasks performed using a computer, such as typing a document or browsing the internet. This prior knowledge will be activated at the start of the lesson through a hook demonstration of a printed chart and a class discussion where learners are asked to name any computer programs they have used or seen, creating a direct bridge to the new content on applications software and spreadsheets.

Learning Environment

Natural Environment: The lesson draws on locally relevant data sets that learners encounter in their everyday lives in Zambia, such as monthly rainfall figures for their district, crop harvest quantities from a nearby farming cooperative, or school attendance records. The teacher can reference these real-world contexts when introducing the purpose of spreadsheets and charts, helping learners see how applications software is used to organise and make sense of information from their own community.
Artificial Environment: The classroom is arranged in mixed-ability groups of 4–6 learners, with desks pushed together to form collaborative workstations. A large display board at the front of the room shows a pre-prepared chart on paper alongside a printed screenshot of the Microsoft Excel interface. The walls display vocabulary cards with key terms such as "spreadsheet," "cell," "chart," and "applications software." Each group has a copy of a simple data set printed on A4 paper for the exploration activity.
Technological Environment: A single computer loaded with Microsoft Excel and connected to a projector is used for teacher demonstration and for rotating group access. Where multiple computers are available, pairs of learners work on separate machines. A short, pre-recorded video clip (no more than 2 minutes) showing a spreadsheet being used to create a chart in a Zambian context (e.g., tracking maize prices at a local market) is played during the ENGAGE phase to spark curiosity. The teacher also uses a smartphone or tablet to display the Excel interface if a projector is unavailable.

Teaching and Learning Materials / Resources

One computer with Microsoft Excel installed (for teacher demonstration and learner exploration)
Data projector or large monitor connected to the demonstration computer
Pre-printed A4 copies of a simple data set (e.g., "Monthly Rainfall in Katete District, 2024" with months and millimetres)
Large printed chart on card paper showing a completed column chart
Vocabulary cards with key terms: applications software, spreadsheet, cell, row, column, chart, column chart, pie chart, line chart
Learner worksheet with guiding questions for the EXPLORE phase (printed copies for each group)
Blank A4 paper and coloured markers for groups to sketch chart designs before creating them digitally
Teacher-prepared sample Excel file with the rainfall data pre-entered (saved on the computer desktop)

Cross-Cutting Issues

The following cross-cutting issues are integrated into this lesson on "1.2.2 SOFTWARE":

Digital Literacy: This lesson is fundamentally grounded in developing learners' ability to use digital tools effectively and responsibly. Throughout the lesson, learners engage directly with Microsoft Excel as an example of applications software, learning to navigate its interface, enter data, and create charts. The teacher explicitly discusses how to evaluate which software tool (word processor, spreadsheet, presentation software) is appropriate for a given task, building learners' capacity to make informed digital choices in their schoolwork and daily lives.
Entrepreneurship Education: The lesson connects the use of spreadsheet software and charts to real-world entrepreneurial activities in Zambia. During the ELABORATE phase, learners apply their skills to a business-related scenario, such as tracking weekly sales of vegetables at a market stall or recording expenses for a small poultry project. This demonstrates how applications software can support financial record-keeping, data analysis, and informed decision-making for small-scale enterprises, encouraging an entrepreneurial mindset among learners.

Lesson Progression (Model: 5E Model of Instruction)

Phase	Teacher Activities	Learner Activities	Assessment Criteria
INTRODUCTION
ENGAGE 12 min	Hook: Hold up a large printed column chart showing "Monthly Maize Sales at Mpika Market, 2024" and ask: "Look at this picture. What do you think it shows? How do you think someone created this? Did they draw it by hand, or did they use a computer program?" Prior Knowledge Questions: Ask the following oral questions: "Can you name any computer programs you have used or seen someone use before?" "What is the difference between the physical parts of a computer and the programs that run on it?" "What do we call the programs that help us do specific tasks like typing letters or doing calculations?" Lesson Goal: Say clearly: "Today we are going to learn about applications software — the programs that help us do useful tasks on a computer. We will focus on one important type of applications software called a spreadsheet, and we will learn how to create charts using Microsoft Excel. By the end of this lesson, you will be able to use different types of applications software appropriately for different tasks." Note: Do NOT introduce the new concept yet — this phase is purely about igniting curiosity and surfacing prior knowledge about software in general.	Learners observe the chart and respond to the hook by sharing what they think the chart shows and how it might have been created. (Develops: Communication) Learners answer prior knowledge questions orally, naming computer programs they know and explaining the difference between hardware and software. (Develops: Critical Thinking) Learners listen to the lesson goal and repeat it in their own words when invited. (Develops: Communication) Learners raise questions or express curiosity about spreadsheets and charts. (Develops: Digital Literacy)	Learners accurately recall prior knowledge about computer programs and the hardware-software distinction. Learners confidently explain what they already know about types of computer programs. Learners clearly restate the lesson goal in their own words. Learners appropriately identify questions or areas of curiosity about spreadsheets and charts.
DEVELOPMENT
EXPLORE 17 min	Investigation Setup: Direct learners' attention to the computer with Microsoft Excel displayed. Say: "In your groups, you will explore a program called Microsoft Excel. This is an example of applications software called a spreadsheet. I want you to look carefully at what you see on the screen. What do you notice? What words or labels can you find? What do you think each part might be used for?" Distribute the learner worksheet with guiding questions. Facilitation: Walk around among the groups as they cluster around the demonstration computer (or their own computers). Ask guiding questions: "What is the name of the bar at the top where you see words like File and Home?" "What do you notice about the grid of boxes on the screen?" "Can you find the area that shows different chart types?" "How many rows and columns can you count?" Observation: Note which groups are actively identifying interface elements and which groups need encouragement to look more carefully. Avoid giving answers — prompt with further questions instead. Transition: After exploration time, say: "Now I will give each group a printed data set. Look at the numbers and the labels. In your group, discuss what kind of chart you could make from this data."	Learners gather around the demonstration computer or their own computer, open Microsoft Excel, and begin exploring the interface. (Develops: Digital Literacy) Learners identify and record on their worksheet the main parts of the Excel interface: the ribbon, the grid of cells, column letters, row numbers, and the chart insertion area. (Develops: Critical Thinking) Learners discuss with group members what each part of the spreadsheet might be used for and share observations. (Develops: Communication) Learners examine the printed data set and discuss in their groups what type of chart could represent the information. (Develops: Critical Thinking)	Learners correctly navigate the Excel interface and identify at least four main parts. Learners accurately record on their worksheet the names and locations of key interface elements. Learners clearly describe the purpose of at least two different parts of the spreadsheet interface during group discussion. Learners appropriately analyse the printed data set and suggest a suitable chart type with reasoning.
EXPLAIN 17 min	Learner Sharing: Invite one learner from each of two different groups to share their exploration findings. Ask: "What did you discover about Microsoft Excel?" "What did you notice about the grid?" "What chart types did you find?" Formalisation: On the board, write and explain the key terms: applications software, spreadsheet, cell, row, column, chart, column chart, pie chart, line chart. Define each term clearly. Say: "Applications software is any program designed to help you perform a specific task. A spreadsheet, like Microsoft Excel, is a type of applications software that organises data in rows and columns. A chart is a visual representation of data that makes patterns easier to see." Correct any misconceptions from the exploration phase. Worked Example: Using the projector and computer, open the pre-prepared Excel file with rainfall data. Say: "Watch carefully as I create a column chart from this data." Narrate each step aloud: "Step 1: Select the data including the headings. Step 2: Click on the Insert tab in the ribbon. Step 3: Click on the Column Chart icon and choose the first option." Point to each screen element as you name it. Guided Questions: Ask these three questions one at a time, building on responses: (1) "What is the difference between a spreadsheet and a word processor like Microsoft Word?" (2) "If you wanted to show how something changed over time, which type of chart would you choose and why?" (3) "What is one example of a task for which you would use a spreadsheet instead of a pen and paper?"	Learners share their exploration findings about the Excel interface and chart types with the class. (Develops: Communication) Learners write the formal definitions of key terms in their exercise books as the teacher explains them. (Develops: Digital Literacy) Learners follow the worked example on the projector, noting the step-by-step process for creating a chart. (Develops: Critical Thinking) Learners volunteer answers to the three guided questions and self-check their understanding. (Develops: Critical Thinking)	Learners accurately describe at least two findings from their exploration using correct terminology. Learners correctly define the terms applications software, spreadsheet, cell, and chart in writing. Learners precisely follow and recall the three main steps for creating a column chart in Excel. Learners correctly answer guided questions, demonstrating understanding of appropriate software use.
ELABORATE 22 min	New Task: Present the following task on the board or on a handout: "Your group runs a small poultry business at your local market. You have recorded the number of eggs sold each day for one week: Monday (24), Tuesday (18), Wednesday (30), Thursday (22), Friday (35), Saturday (28), Sunday (20). Use Microsoft Excel to create a chart that shows this data clearly. Choose the best chart type for this data. Write one sentence explaining why you chose that chart type." Instructions: Direct learners: "Work in your groups. Each group will take turns using the computer to create your chart. If the computer is occupied, use markers and A4 paper to sketch your chart design first. You have 15 minutes for this task. I will not tell you which chart type to use — you must decide as a group." Facilitation: Walk around, observe, and offer probing questions only: "Why did your group choose that chart type? What other chart type could also work? Is your chart labelled clearly? What title will you give your chart?" Extension: For groups that finish early, provide an additional challenge: "Create a second chart showing the same data but using a different chart type. Write a sentence comparing the two charts — which one shows the data more clearly and why?"	Learners read the poultry business task and discuss with their group which chart type is most appropriate. (Develops: Critical Thinking) Learners create the chart using Microsoft Excel, entering the data, selecting the chart type, and adding labels and a title. (Develops: Digital Literacy) Learners write one sentence explaining their choice of chart type in their exercise books. (Develops: Communication) Selected groups present their chart to the class, explaining their choices and answering questions from peers. (Develops: Communication)	Learners accurately interpret the business scenario and logically justify their choice of chart type. Learners independently create a correctly formatted chart in Excel with appropriate data, labels, and title. Learners clearly and logically explain in writing why their chosen chart type is suitable for the data. Learners confidently present their chart and respond to peer questions with reasoned explanations.
CONCLUSION
EVALUATE 12 min	Consolidation Questions: Ask the following three oral questions: (1) "What is applications software? Give two examples." (2) "Why would you use a spreadsheet instead of a word processor to store numerical data?" (3) "If you had data showing the favourite foods of learners in this class, which chart type would you use and why?" Learner-Led Summary: Invite three learners to each share one key thing they learned today. Say: "Tell the class one new thing you learned about applications software or spreadsheets." Affirm correct responses and gently correct any remaining misconceptions. Link Forward: Say: "Next lesson, we will learn about system software — the programs that help the computer run properly, like the operating system. What you learned today about applications software will help you understand how the two types of software work together." Homework: Assign: "Collect any set of data from home or your community — for example, the number of people in your household, or the prices of different items at a shop. Bring this data to our next class. We will use it to create more charts in Excel. Write your data clearly in your exercise book. Due: next lesson." Closure: Say: "You worked very well today, especially with creating your charts. I am proud of how you used Microsoft Excel to turn numbers into clear pictures. Keep practising at home if you have access to a computer. Well done, everyone."	Learners respond to consolidation questions individually or as a class, demonstrating their understanding of applications software and appropriate chart selection. (Develops: Critical Thinking) Learners summarise the key learning points in their own words when invited by the teacher. (Develops: Communication) Learners record the homework task in their exercise books. (Develops: Digital Literacy) Learners reflect briefly on what they found most interesting or challenging about creating charts. (Develops: Critical Thinking)	Learners correctly answer consolidation questions, demonstrating achievement of the lesson goal on applications software. Learners accurately summarise at least two key concepts learned about spreadsheets and charts. Learners independently record the homework task with all necessary details. Learners clearly articulate one specific aspect of the lesson they found interesting or challenging.

Class Exercise

Instructions to learners: Answer all five questions in your exercise book. Show all working where applicable. Time allowed: 10 minutes.

Multiple Choice: Which of the following is an example of applications software?
A) Microsoft Windows
B) Microsoft Excel
C) Computer keyboard
D) Central Processing Unit
Fill-in-the-Blank: In Microsoft Excel, the boxes where you enter data are called ________.
Short Answer: Name three different types of charts you can create in Microsoft Excel and describe the type of data each one is best suited for.
Short Answer: Explain why you would use a spreadsheet like Microsoft Excel rather than a word processor like Microsoft Word to record and analyse numerical data.
Scenario-Based Application: A small-scale farmer in Zambia wants to track the monthly harvest of tomatoes from her garden over six months. She has collected the following data: January (40 kg), February (55 kg), March (70 kg), April (65 kg), May (48 kg), June (30 kg). Which type of chart would you recommend she create? Justify your choice in two sentences, and explain how this chart could help her make better decisions about her farming.

Answer Key (For Teacher Use Only)

Question 1 — Multiple Choice
Answer: B) Microsoft Excel
Marks: 1 mark for selecting the correct option.
Question 2 — Fill-in-the-Blank
Answer: cells
Marks: 1 mark for writing "cells" (accept "cell").
Question 3 — Short Answer
Answer: Learners should name any three of these chart types with suitable descriptions: Column chart (best for comparing values across categories), Pie chart (best for showing parts of a whole), Line chart (best for showing trends over time), Bar chart (best for comparing categories horizontally). Each chart type named with a correct description earns 1 mark. Accept any reasonable, logical pairing of chart type and data purpose.
Marks: 3 marks (1 mark per chart type with correct description).
Question 4 — Short Answer
Answer: Learners should explain that spreadsheets are specifically designed to organise, calculate, and analyse numerical data using rows, columns, formulas, and charts, while word processors are designed primarily for creating text-based documents such as letters and reports. A spreadsheet allows the user to perform calculations, sort data, and create visual charts directly from the numbers, which a word processor cannot do efficiently. Accept any answer that clearly contrasts the two types of applications software in terms of their primary functions.
Marks: 2 marks (1 mark for identifying the primary purpose of each type of software, 1 mark for explaining why the spreadsheet is more suitable for numerical data).
Question 5 — Scenario-Based Application
Answer: Learners should recommend a line chart or a column chart. A line chart is ideal because it clearly shows the trend of tomato harvest quantities over the six months, making it easy to see increases and decreases over time. Alternatively, a column chart also works well for comparing monthly amounts. The chart would help the farmer make better decisions by revealing patterns — for example, she might notice that harvest peaks in March and declines after May, which could inform her planting schedule or marketing plans. Accept any well-justified chart choice with logical reasoning.
Marks: 3 marks (1 mark for recommending an appropriate chart type, 1 mark for justifying why that chart type suits the data, 1 mark for explaining how the chart supports decision-making).

Total Marks: 10 | Suggested Completion Time: 10 minutes

Lesson Evaluation

Instructions to the teacher: Focus on the competences learners were able to demonstrate, use clear evidence from their work and participation, note any difficulties they faced, reflect on what worked or did not work in your teaching, and state what support or next steps are needed.

← Back to Plans 📄 Download as Word

⭐ Lesson Plan Feedback

💡 Add a comment or suggestion