Information and Communication Technology — Components of a computer system

Form 1 · 80 minutes · Term 2 week 8 · 02 July 2026

SchoolNanduba Secondary

TeacherTimi Isaax Kawina

Date02 Jul 2026

ClassForm 1

SubjectInformation and Communication Technology

Duration80 min

TimePeriod 6&7

Learners42

Term/WeekTerm 2 week 8

Topic

Components of a computer system

Sub-Topic

Software

General Competences

AI Selected

Specific Competences

Use different types of application software . Entering data into a spreadsheet and apply basic formatting.

Learning Activities

Entering data into spreadsheet Apply basic formatting

Expected Standard

Using different types of application software

References

MOE Form 1 module Other related materials relevant

Lesson Goal

By the end of this lesson, learners should be able to enter data into a spreadsheet and apply basic formatting while correctly identifying and using different types of application software relevant to everyday tasks.

Rationale

This lesson builds on learners' prior understanding of computer hardware by introducing software as the set of instructions that make the hardware functional, specifically focusing on application software such as spreadsheets. Understanding how to use spreadsheet software to enter and format data is essential for managing information in school, at home, and in future workplaces, promoting values of accuracy and organisation. Through hands-on paired and group activities guided by the 5E instructional model, this lesson develops critical thinking, digital literacy, and problem-solving as learners actively explore, apply, and evaluate their use of spreadsheet tools.

Prior Knowledge / Prerequisite Knowledge

Learners in Form 1 have already been introduced to the concept of a computer system and its main components, including hardware devices such as the monitor, keyboard, and mouse. They can identify input, output, and processing devices and understand that a computer follows instructions. This prior knowledge will be activated at the start of the lesson through oral questions about what makes a computer "work" and a brief discussion about the difference between a physical device and the instructions it follows, creating a bridge to the new concept of software as the non-physical component that directs hardware operations.

Learning Environment

Natural Environment: The teacher will reference local examples such as how a small business in a peri‑urban market in Lusaka uses a simple spreadsheet to record daily sales of vegetables or how a community cooperative uses a printed table to track member contributions. This connects the concept of organising data digitally to familiar real‑world record‑keeping practices.
Artificial Environment: The classroom is arranged in mixed groups of 4–6 learners with desks pushed together to form workstations, allowing pairs within each group to share one computer or tablet if available. A large chart paper displayed at the front shows the main types of application software (word processor, spreadsheet, presentation software) with simple icons. Two smaller posters near the computer area list common spreadsheet terms (cell, row, column) and basic formatting icons (bold, italic, fill colour).
Technological Environment: The school computer lab or a single classroom computer with a projector will be used to demonstrate a live spreadsheet (e.g., LibreOffice Calc or Microsoft Excel). If only one computer is available, the teacher will model the activity on the projected screen while learners record data on paper spreadsheets first; where multiple machines are available, pairs of learners will take turns entering data. A short two‑minute video clip showing how a farmer uses a spreadsheet to track harvest yields will be shown during the Engage phase if projector access is possible.

Teaching and Learning Materials / Resources

Pre‑printed paper spreadsheets (grid with column headings: Name, Age, Village, Crop) – one per pair
Chart showing labelled screenshot of a spreadsheet window with arrows pointing to cell, row, column, and formula bar
Set of task cards printed on A5 paper with different data entry scenarios (e.g., class attendance, market prices, sports scores)
Large envelope containing printed "formatting cards" (each card shows one formatting instruction: "Make the heading bold", "Fill the first row with blue colour", "Make all numbers centre‑aligned")
Whiteboard markers in four colours for group recording on chart paper
Two pre‑prepared sample spreadsheet printouts – one neatly formatted, one messy and unformatted – for comparison during the Explain phase
Worksheet with a partially completed spreadsheet grid plus five questions (mixed types) for the Evaluate phase

Cross-Cutting Issues

Digital Literacy: Throughout the lesson, learners develop foundational digital literacy skills by identifying, entering, and formatting data using spreadsheet software. They learn to navigate a digital environment, recognise interface elements, and apply basic digital tools to organise information – skills essential for effective and responsible use of technology in academic and everyday contexts.
Entrepreneurship Education: The data entry scenarios used in the Explore and Elaborate phases are drawn from small‑business contexts relevant to peri‑urban Zambian communities, such as recording daily market sales, tracking inventory of goods, or maintaining a simple customer contact list. Learners see how spreadsheet skills directly support business planning, record‑keeping, and informed decision‑making, fostering an entrepreneurial mindset from an early stage.

Lesson Progression (Model: 5E Model of Instruction)

Phase	Teacher Activities	Learner Activities	Assessment Criteria
INTRODUCTION
ENGAGE 12 min	Hook: Hold up a printed page of a messy handwritten list of names and numbers. Say: "Imagine your mother runs a small stall in the market and needs to know how many tomatoes she sold each day. She writes everything on scraps of paper like this. By Friday the paper is torn and numbers are missing. Is there a better way to keep this information safe and organised?" Let learners respond for 2 minutes. Prior Knowledge Questions: Ask: "What do we call the physical parts of a computer that you can touch?" (Hardware). Then ask: "If hardware is the body of the computer, what gives it instructions on what to do?" (Software). Finally ask: "Can you name any program you have used on a computer or phone that helped you do something – like write a letter or play a game?" (Activates prior knowledge of application software). Lesson Goal: State: "Today we are going to learn about application software – programs that help us do tasks – and we will practise using one very useful type: spreadsheet software. By the end of this lesson, you will be able to enter data into a spreadsheet and apply basic formatting to make it neat and professional." Ask learners to turn to a partner and predict one way a spreadsheet could help someone in their community. Give 2 minutes for paired discussion, then invite two pairs to share their prediction.	Learners respond to the market stall scenario by suggesting ideas such as "write it in a book" or "use a computer". (Develops: Critical Thinking) Learners recall and define hardware and software, and name familiar programs (e.g., WhatsApp, Microsoft Word, calculator app). (Develops: Digital Literacy) Learners listen to the lesson goal and restate it in their own words to a partner. (Develops: Communication) Learners discuss predictions with a partner and share one example with the class. (Develops: Collaboration, Communication)	Learners accurately recall the definition of hardware and software. Learners confidently name at least one application program they have used before. Learners appropriately restate the lesson goal in their own words. Learners logically predict a real‑life use for spreadsheet software.
DEVELOPMENT
EXPLORE 17 min	Learning Activity – Entering data into a spreadsheet: Distribute printed paper spreadsheets (grid with column headings: Name, Age, Village, Crop) to each pair. If computers are available, direct pairs to open LibreOffice Calc or Microsoft Excel and recreate the same grid. Say: "In your pair, you will enter five rows of data about your classmates or family members. Use the column headings given: Name, Age, Village, Crop. Type or write one person per row. You have 10 minutes to complete this task." Investigation Setup: Display a blank spreadsheet on the projector (or draw a grid on the board) and point to a cell, saying: "This is a cell. Each cell holds one piece of data. Click inside a cell and type. When you press Enter, the data stays there. Go ahead and try it now." Facilitation: Walk around the room, stopping at each group. Ask guiding questions: "Which cell did you click first?", "What happens when you press the Tab key instead of Enter?", "How many columns does your table have?" Do not give direct answers – prompt learners to experiment. Observation: Note on a clipboard which pairs successfully enter data into all five rows and which pairs struggle with navigation or typing into the correct cell. Offer a brief physical demonstration to any group that is stuck for more than 2 minutes.	Learners read the column headings and begin entering data into the spreadsheet (or paper grid), typing or writing one row for each person. (Develops: Digital Literacy, Problem Solving) Learners experiment with clicking different cells and pressing Tab, Enter, and arrow keys to observe navigation behaviour. (Develops: Critical Thinking) Learners discuss with their partner to decide which data belongs in which column, correcting any misplaced entries. (Develops: Collaboration) Learners count and record how many rows and columns they have completed. (Develops: Analytical Thinking)	Learners correctly enter at least five rows of data into the correct cells. Learners accurately describe what happens when they press Tab or Enter in a spreadsheet. Learners appropriately correct misplaced data entries through paired discussion. Learners independently count and state the number of rows and columns used.
EXPLAIN 17 min	Learner Sharing: Invite two pairs to share what they discovered about entering data. Ask: "What did you notice about moving from cell to cell? Did anyone find a faster way?" Affirm correct observations and gently correct any misconceptions (e.g., "No, you cannot type in two cells at once – you must click each cell individually."). Formalisation: Draw a simple labelled diagram on the board showing: cell (intersection of row and column), row (horizontal), column (vertical), and active cell (highlighted with thick border). Define each term clearly. Then write: "Application software: a program that helps the user perform a specific task. Examples: word processor, spreadsheet, presentation software." Erase any incorrect ideas learners may have expressed and reinforce the correct terminology. Worked Example: On the projected spreadsheet, demonstrate entering a new table: "School Fees Record" with columns: Learner Name, Amount Paid, Date. Type three rows of sample data while thinking aloud: "I click cell A1 and type 'Learner Name'. Then I press Tab to move to B1 and type 'Amount Paid'. When I reach the end of row 1, I press Enter to go to the next row." Learners watch and copy the steps on their own spreadsheets. Guided Questions: Ask three mixed‑type questions one by one, pausing for responses: (1) Fill‑in‑the‑blank: "The intersection of a row and a column in a spreadsheet is called a ________." (2) Short answer: "Name two examples of application software other than a spreadsheet." (3) True or False: "A row in a spreadsheet runs vertically from top to bottom." – and ask learners to justify their answer.	Learners share their data‑entry strategies and observations with the class. (Develops: Communication) Learners copy the labelled diagram and definitions of cell, row, column, and active cell into their exercise books. (Develops: Digital Literacy) Learners follow the worked example on the projector, replicating the School Fees Record on their own spreadsheet or paper grid. (Develops: Critical Thinking) Learners answer the three guided questions orally and write the fill‑in‑the‑blank answer in their books. (Develops: Analytical Thinking)	Learners clearly explain one strategy for moving between cells efficiently. Learners accurately define cell, row, column, and active cell using correct terminology. Learners correctly replicate the worked example with the same column headings and three rows. Learners confidently provide correct answers to all three guided questions.
ELABORATE 22 min	Learning Activity – Apply basic formatting: Hold up the envelope of "formatting cards" and explain: "Now that you have entered data, we will make it look professional. Each group will draw two formatting cards from this envelope. Your task is to apply those formatting instructions to the spreadsheet you created earlier. For example, if you draw 'Make the heading bold', you will select the heading row and click the Bold button." Display each formatting option on the projected spreadsheet before groups start. Instructions: Say: "Work with your group of 4. One person operates the computer while the others read the card and check the result. Then swap roles so everyone gets a turn. You have 12 minutes to apply both formatting instructions. If you finish early, try to apply the extra formatting card at the front table." Facilitation: Walk around and ask probing questions: "How did you select multiple cells at once?", "What happens when you click the paint bucket icon?", "Why might someone want to colour the heading row differently?" Encourage groups to help each other rather than calling for teacher help immediately. Extension: For groups that finish all tasks quickly, provide an additional challenge card: "Add a new column at the end called 'Total Amount' and write a formula that adds the first two amounts in that row. Use + or the SUM function if you know it."	Learners draw two formatting cards from the envelope and read the instructions aloud to their group. (Develops: Collaboration, Communication) Learners take turns operating the computer and applying the formatting (bold, fill colour, centre alignment, etc.) under the guidance of group members. (Develops: Digital Literacy, Problem Solving) Learners discuss which formatting options make the spreadsheet easier to read and justify their choices. (Develops: Critical Thinking) Learners who finish early attempt the extension task by adding a new column and experimenting with a simple formula. (Develops: Creativity and Innovation)	Learners correctly apply two different formatting options to the spreadsheet as per the drawn cards. Learners accurately operate the computer to select cells and use formatting tools with minimal assistance. Learners logically justify at least one formatting choice by explaining how it improves readability. Learners independently apply a formula or add a new column in the extension task.
CONCLUSION
EVALUATE 12 min	Consolidation Questions: Ask three oral questions focusing on the lesson goal: (1) "What is the difference between a row and a column in a spreadsheet?" (2) "Give me one example of an application software and one task it can do." (3) "Why would you make a heading bold instead of leaving it plain? What difference does it make to the reader?" Learner-Led Summary: Invite three different learners (one from each of three groups) to stand and summarise in one sentence what they learned about entering data and formatting a spreadsheet. Affirm each contribution and correct any lingering errors. Link Forward: Say: "Today you learned how to enter data and apply basic formatting. Next week we will learn how to sort data alphabetically and use simple formulas to add numbers automatically – skills that will help you create a proper budget or mark sheet." Homework: Assign: "In your exercise book, draw a table with four columns: Item, Quantity, Price, Total. Enter five items you would buy at the market (e.g., tomatoes, onions, cooking oil). Then write one sentence explaining how formatting would make this table clearer. Due next ICT lesson." Closure: Say: "Well done everyone – you have taken your first steps in using spreadsheet software. You should be proud of the neat tables you created today. Pack away your materials quietly."	Learners respond to consolidation questions by defining rows/columns, naming application software, and explaining the purpose of formatting. (Develops: Digital Literacy, Critical Thinking) Learners volunteer to summarise key learning points in their own words, reflecting on data entry and formatting. (Develops: Communication) Learners record the homework task in their exercise books and ask clarifying questions if needed. (Develops: Problem Solving) Learners share one thing they found most useful or most challenging about the lesson with a partner before packing up. (Develops: Emotional Intelligence)	Learners correctly differentiate between a row and a column and give a valid example of application software. Learners accurately summarise at least two key learning points from the lesson. Learners appropriately record the homework task with all required elements. Learners reflectively identify one personal takeaway or challenge from the lesson.

Class Exercise

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

Multiple Choice Question: Which of the following is an example of application software?
A. Central Processing Unit
B. Microsoft Excel
C. Keyboard
D. Power supply unit
Fill-in-the-Blank: In a spreadsheet, information is organised into rows and ________.
Short Answer Question: List two basic formatting options you can apply to text in a spreadsheet and briefly explain what each one does.
True or False: A column in a spreadsheet runs horizontally from left to right. Write 'True' or 'False'. If false, rewrite the sentence correctly.
Application / Analysis (Structured Question): Mwila runs a small poultry business in Chipata. She wants to use a spreadsheet to record how many eggs her chickens produce each day for one week. (a) Suggest appropriate column headings for her spreadsheet (at least three). (b) Describe two formatting changes she could make to the spreadsheet to help her read the data more easily. (c) Explain why using a spreadsheet instead of a paper notebook would be more helpful for Mwila as her business grows.

Answer Key (For Teacher Use Only)

Question 1 — Multiple Choice Question
Answer: B. Microsoft Excel
Marks: 1 mark for correct letter.
Question 2 — Fill-in-the-Blank
Answer: columns
Marks: 1 mark for correct word.
Question 3 — Short Answer Question
Answer: Accept any two of the following (1 mark each): Bold – makes text thicker and darker; Italic – slants text; Underline – draws a line under text; Fill colour – adds a background colour to a cell; Centre alignment – places text in the middle of a cell. Each formatting option must include a brief explanation of what it does.
Marks: 2 marks (1 per correct formatting option with explanation).
Question 4 — True or False
Answer: False. Correct sentence: "A column in a spreadsheet runs vertically from top to bottom." (Or: "A row in a spreadsheet runs horizontally from left to right.")
Marks: 1 mark for 'False' + 1 mark for correct rewritten sentence = 2 marks total.
Question 5 — Application / Analysis (Structured Question)
Answer: (a) Accept any three reasonable headings such as: Day, Number of Eggs, Date, Number of Chickens, Eggs Collected, Time of Collection, etc. (1 mark for three sensible headings). (b) Accept any two formatting changes: e.g., make the headings bold so they stand out; add fill colour to the heading row; centre-align the numbers; add borders around the table. (1 mark each, max 2). (c) A spreadsheet allows Mwila to add more data easily without running out of space, use formulas to calculate totals automatically, sort data by day or quantity, make copies for different months, and apply formatting to keep the record neat. Unlike paper, a digital file does not tear or get lost easily, and she can search or filter data quickly as the business grows. (2 marks for a clear explanation with at least two advantages).
Marks: 1 (headings) + 2 (formatting changes) + 2 (advantages) = 5 marks total.

Total Marks: 11 | 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