AI Lesson Plan Generator

Designed by Mabbola M.C. - 0977755416

Information and Communication Technology — PRODUCTIVITY TOOLS

Form 2  ·  40 minutes  ·  21 June 2026

SchoolItuna Secondary schools
TeacherMatews Simpasa
Date21 Jun 2026
ClassForm 2
SubjectInformation and Communication Technology
Duration40 min
Time—
Learners50
Term/Week—

Topic

PRODUCTIVITY TOOLS

Sub-Topic

spreadsheet (how to use COUNTA) fuction in a spreadsheet

General Competences

Digital Literacy, Analytical Thinking, Problem Solving

Specific Competences

2.2.2.1 Manage data using spreadsheets

Learning Activities

Using the COUNTA, function in a spreadsheet.

Expected Standard

Data managed using spreadsheets.

References

ICT ordinary level Form 1 to 4 syllabus page 25.

Lesson Goal

By the end of this lesson, learners should be able to correctly apply the COUNTA function in a spreadsheet to count non-empty cells in a given data set and explain its purpose and syntax.

Rationale

This lesson builds on learners' prior knowledge of basic spreadsheet terminology—such as cells, rows, columns, and simple arithmetic functions (SUM, AVERAGE)—to introduce the COUNTA function, a key tool for managing and analysing data by counting entries that contain text, numbers, or other content. Mastering COUNTA enables learners to efficiently track attendance, inventory, or survey responses in their daily lives, promoting values of accuracy, organisation, and data-driven decision-making. Through active, learner-centred methods including guided exploration, paired investigation, and whole-class discussion, this lesson develops the competences of Digital Literacy, Analytical Thinking, and Problem Solving as articulated in the Zambian ICT syllabus.

Prior Knowledge / Prerequisite Knowledge

Learners are expected to know the basic layout of a spreadsheet (cells, rows, columns), how to enter data into cells, and how to use the SUM and AVERAGE functions. They should also be able to distinguish between numeric and text data. This prior knowledge will be activated at the start of the lesson through a quick oral review where learners are asked to name the parts of a spreadsheet and to recall what the SUM function does, thereby creating a bridge to understanding the COUNTA function as a tool for counting entries rather than adding numbers.

Learning Environment

  • Natural Environment: The teacher references the local market in Kasama town centre, where vendors record daily sales of produce such as tomatoes, onions, and cassava in handwritten ledger books. Learners will be asked to imagine how a spreadsheet could help a vendor count how many different types of produce were sold on a given day, linking the COUNTA function to a familiar community context.
  • Artificial Environment: The classroom is arranged in mixed-ability pairs and groups of 4–6 learners, with desks pushed together to form cluster tables. A large pre-printed chart showing a sample spreadsheet with names, marks, and attendance data is displayed on the wall. The chalkboard is divided into two sections: one for key terms and definitions, and one for worked examples. Learner exercise books and worksheets are placed at each cluster before the lesson begins.
  • Technological Environment: A single laptop or desktop computer with a projector (if available at Ituna Secondary School) is used to demonstrate the COUNTA function live using a simple spreadsheet created in LibreOffice Calc or Microsoft Excel. If no projector is available, the teacher uses a large hand-drawn spreadsheet chart on manila paper and writes the function syntax and result directly on the board. A short 2-minute video clip on the COUNTA function (downloaded in advance or accessed via a smartphone hotspot) may be shown to reinforce the concept visually.

Teaching and Learning Materials / Resources

  • Pre-printed chart on manila paper showing a sample spreadsheet (columns: Name, Class, Gender, Marks) with some empty cells
  • Worksheet handouts for each pair of learners containing a small data set with three columns (Item, Quantity, Price) and several blank rows
  • Projector or laptop with LibreOffice Calc / Microsoft Excel installed (if available)
  • Short video clip (2 minutes) on the COUNTA function sourced from YouTube and saved offline
  • Large flashcards showing the syntax: =COUNTA(range)
  • Coloured chalk or markers for board work
  • Learner exercise books and pens

Cross-Cutting Issues

The following cross-cutting issues are integrated into this lesson on "spreadsheet (how to use COUNTA) fuction in a spreadsheet":

  • Digital Literacy: Throughout the lesson, learners actively engage with spreadsheet software (or a simulated chart) to enter data and apply the COUNTA function, thereby strengthening their ability to use digital tools for organising and interpreting information—a core skill for functioning effectively in a technology-driven world.
  • Financial Education: The worked example and elaboration task use a class attendance register and a small business stock sheet (inspired by local shops in Kasama), respectively, to show how counting non-empty cells can help a trader or teacher monitor resources and track records accurately, reinforcing the value of careful record-keeping for financial and administrative decision-making.

Lesson Progression (Model: 5E Model of Instruction)

Phase Teacher Activities Learner Activities Assessment Criteria
INTRODUCTION
ENGAGE
6 min
  • Hook: "Imagine you are the head teacher at Ituna Secondary School and you want to know how many learners are present in Form 2A today. You have a list of all 45 names, and the teacher has marked who is present with a 'P'. How could you quickly count how many learners are present without counting one by one?"
  • Prior Knowledge Questions: "What is the name of the tool we use to organise data in rows and columns on a computer?" "Which function did we learn last term that adds up all the numbers in a range?" "Can a function count cells that contain words instead of numbers?"
  • Lesson Goal: "Today we are going to learn about a special function called COUNTA that counts how many cells in a range actually contain something—text, numbers, or symbols—and we will use it to manage data more easily."
  • Do NOT introduce the COUNTA syntax yet—this phase is purely about igniting curiosity and surfacing prior knowledge.
  • Learners respond to the hook by suggesting ideas such as "count the Ps" or "use a computer function." (Develops: Analytical Thinking)
  • Learners answer prior knowledge questions, recalling spreadsheet terms and the SUM function. (Develops: Communication)
  • Learners listen to and repeat the lesson goal in their own words. (Develops: Communication)
  • Learners raise questions or express curiosity about what COUNTA might do. (Develops: Digital Literacy)
  • Learners accurately suggest a method for counting entries using a spreadsheet function.
  • Learners correctly identify spreadsheet components and the SUM function.
  • Learners confidently restate the lesson goal in simple terms.
  • Learners clearly pose at least one relevant question or prediction about the new function.
DEVELOPMENT
EXPLORE
8 min
  • Investigation Setup: "In your pairs, you will receive a worksheet with a small data set showing different types of school supplies. Your task is to count how many cells in each column contain any data—text or numbers—by manually ticking each cell. Do not use a function yet. Record your count on the worksheet. You have 5 minutes."
  • Facilitation: Walk around among groups without lecturing. Ask: "What do you notice about the cells that are empty? How are you deciding whether a cell has data or not?"
  • Observation: Note which groups are on track and which need a guiding nudge (not answers).
  • Learners read the worksheet instructions and begin manually counting non-empty cells in each column. (Develops: Analytical Thinking)
  • Learners record their counts in the spaces provided on the worksheet. (Develops: Problem Solving)
  • Learners discuss with their partner whether a cell containing a space or a formula result of "" should be counted. (Develops: Collaboration)
  • Learners write a brief summary sentence about what they discovered regarding empty versus non-empty cells. (Develops: Communication)
  • Learners correctly identify which cells in the data set contain data and which are empty.
  • Learners accurately record the count of non-empty cells for each column on the worksheet.
  • Learners logically discuss and reach a consensus on borderline cases (e.g., cells with spaces).
  • Learners clearly describe in writing that non-empty cells include cells with text, numbers, or symbols.
EXPLAIN
8 min
  • Learner Sharing: "What did you discover? Which column had the most non-empty cells? Was there any case where you were unsure whether a cell was empty or not?" Invite 2–3 pairs to share their findings.
  • Formalisation: "The function that counts non-empty cells automatically is called COUNTA. It stands for 'count all' cells that contain any type of data—text, numbers, dates, or even errors. The syntax is: =COUNTA(range)." Write this on the board with an example.
  • Worked Example: Draw a small table on the board showing 5 learners' names and their marks (some cells empty). Write: =COUNTA(B2:B6) and show that the result is 4 (only the cells with marks are counted). Walk through each step aloud.
  • Guided Questions: (1) "What does COUNTA count?" (short answer), (2) "If range A1:A10 has 8 cells with data and 2 empty cells, what will =COUNTA(A1:A10) return?" (short answer), (3) "True or false: COUNTA counts only cells with numbers." (fill-in-the-blank style)
  • Learners share their manual counting results and any uncertainties they encountered. (Develops: Communication)
  • Learners write the definition and syntax of COUNTA in their exercise books. (Develops: Digital Literacy)
  • Learners follow the worked example on the board, copying the table and the function step by step. (Develops: Analytical Thinking)
  • Learners attempt the three guided questions and self-check or peer-check their answers. (Develops: Problem Solving)
  • Learners accurately explain what they discovered about counting non-empty cells.
  • Learners correctly record the syntax =COUNTA(range) and its purpose.
  • Learners precisely copy the worked example and note that COUNTA excludes truly empty cells.
  • Learners correctly answer the guided questions with a clear understanding of the function's purpose.
ELABORATE
12 min
  • New Task: "Imagine you run a small shop in Kasama selling school supplies. You have a stock sheet with columns for Item, Quantity, and Price. Some rows are blank because you haven't stocked those items yet. Use the COUNTA function to find out how many items you have data for. Write the correct formula and the result in your exercise book."
  • Instructions: "Work in your pairs. You have 8 minutes to write the formula, apply it to the data set on your worksheet, and write the answer. Do not ask me for the answer—discuss with your partner and use your notes."
  • Facilitation: Walk around, observe, and offer probing questions only: "Which range will you use? What does COUNTA actually count—does it include the header row?"
  • Extension: "Challenge: If you also wanted to count only the cells that contain numbers greater than zero, could you still use COUNTA? Why or why not? Write your reasoning."
  • Learners read the new task and identify which column(s) they need to count. (Develops: Analytical Thinking)
  • Learners apply the COUNTA function by writing the correct formula in their exercise books and determining the result. (Develops: Problem Solving)
  • Learners record their working and final answer in their exercise books. (Develops: Digital Literacy)
  • Selected learners share their formula and result with the class for peer discussion. (Develops: Communication)
  • Learners accurately identify the relevant data range for the COUNTA function.
  • Learners independently write the correct COUNTA formula and compute the correct result.
  • Learners clearly record the formula, the range used, and the final count in their exercise books.
  • Learners logically justify their choice of range and explain whether the header row was included.
CONCLUSION
EVALUATE
6 min
  • Consolidation Questions: (1) "What does the COUNTA function count?" (2) "Write the syntax of the COUNTA function." (3) "If you have a range C1:C10 and only cells C1, C3, C5, and C7 contain data, what will =COUNTA(C1:C10) return?"
  • Learner-Led Summary: Invite 2–3 learners to summarise the key learning points in their own words. Affirm and correct as needed.
  • Link Forward: "Next lesson, we will learn how to use the COUNTIF function, which counts cells that meet a specific condition—like counting only the learners who scored above 50%."
  • Homework: "Create a small table in your exercise book with 8 rows and 2 columns. Fill in at least 5 cells with data and leave the rest empty. Write the COUNTA formula to count the non-empty cells in column B and write the result. Due tomorrow."
  • Closure: "Well done, everyone. Today you learned how to use COUNTA to manage data in spreadsheets. Keep practicing, and you will become spreadsheet experts!"
  • Learners respond to consolidation questions individually or as a class, demonstrating achievement of the lesson goal. (Develops: Communication)
  • 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 most challenging about COUNTA. (Develops: Analytical Thinking)
  • Learners correctly answer consolidation questions about the purpose, syntax, and result of the COUNTA function.
  • Learners accurately summarise the main idea of the lesson in their own words.
  • Learners clearly note the homework task with all necessary details.
  • Learners appropriately identify one aspect of the lesson they found interesting or challenging, showing metacognitive awareness.

Class Exercise

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

  1. Multiple Choice: What does the COUNTA function in a spreadsheet count?
    A. Cells that contain numbers only
    B. Cells that contain text only
    C. Cells that contain any data (text, numbers, dates, or errors)
    D. Cells that are empty
  2. Fill-in-the-Blank: The correct syntax for the COUNTA function is =COUNTA(________).
  3. Short Answer: If the range D1:D8 contains data in cells D1, D2, D4, D6, and D7, what will =COUNTA(D1:D8) return? Explain your answer.
  4. True or False: The COUNTA function counts a cell as non-empty if it contains a space character. Write 'True' or 'False' and give a reason for your answer.
  5. Application / Analysis: The school librarian at Ituna Secondary School has a spreadsheet of all books in the library. Column A contains the book titles, Column B contains the authors, and Column C contains the year of publication. Some rows in Column C are empty because the year is unknown. The librarian wants to know how many books have a recorded year of publication. Write the correct COUNTA formula the librarian should use, specifying the range. Then explain why COUNTA is a better choice than using the COUNT function in this situation.

Answer Key (For Teacher Use Only)

  1. Question 1 — Multiple Choice
    Answer: C. Cells that contain any data (text, numbers, dates, or errors)
    Marks: 1 mark for selecting the correct option.
  2. Question 2 — Fill-in-the-Blank
    Answer: range
    Marks: 1 mark for writing "range" (or a specific range reference such as A1:A10 is also acceptable if context is provided).
  3. Question 3 — Short Answer
    Answer: The result is 5, because only cells D1, D2, D4, D6, and D7 contain data—these are 5 cells out of the range. The remaining cells (D3, D5, D8) are empty and are not counted.
    Marks: 1 mark for stating 5; 1 mark for explaining which cells are counted and why.
  4. Question 4 — True or False
    Answer: True. The COUNTA function counts a cell as non-empty if it contains any character, including a space. A space is considered text data in a spreadsheet.
    Marks: 1 mark for "True"; 1 mark for a valid reason explaining that a space is treated as data.
  5. Question 5 — Application / Analysis
    Answer: The formula should be =COUNTA(C2:C100) (assuming the data starts in row 2 and ends in row 100). COUNTA is better than COUNT in this situation because COUNT only counts cells containing numeric values, while the year of publication is a number. However, if some cells contain text (e.g., "Unknown") or are blank, COUNTA will count those with any entry, while COUNT would only count numeric entries. For recording years, COUNT would work if all cells have numbers, but COUNTA is more robust if any cell contains text. The best answer explains that COUNTA counts all non-empty cells, ensuring no book with a recorded year—whether numeric or text—is missed.
    Marks: 1 mark for writing a correct COUNTA formula with an appropriate range; 1 mark for explaining that COUNTA counts all non-empty cells; 1 mark for comparing with COUNT (COUNT only counts numbers); 1 mark for justifying why COUNTA is better in this context (it captures all entries regardless of data type).

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