Lesson Notes By Weeks and Term v4 - JHS 3
INTRODUCTION TO ELECTRONIC SPREADSHEET
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
INTRODUCTION TO ELECTRONIC SPREADSHEET
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
Subject: Computing
Class: JHS 3
Term: 2nd Term
Week: 2
Grade code: B9.2.4.1.1
Strand code: 2
Sub-strand code: 4
Content standard code: B9.2.4.1
Indicator code: B9.2.4.1.1
Theme: PRODUCTIVITY SOFTWARE
Subtheme: INTRODUCTION TO ELECTRONIC SPREADSHEET
This page supports the lesson note with a companion video and a short classroom-ready summary.
For class groups and homework, share this lesson page so learners also get the summary, objectives, and full lesson context.
In our daily lives, we are surrounded by information: the names of students in our class, the prices of items at Auntie Araba's provision store, or the results from the Inter-Colo sports competition. An electronic spreadsheet is a powerful computer program that helps us organise, manage, and make sense of this information easily. Today, we will learn the basic building blocks of data in a spreadsheet and master three essential skills: Data Validation (to keep our data clean and accurate), Sorting (to arrange our data), and Filtering (to find exactly what we are looking for).
Part A: The Building Blocks of Data - Fields, Records, and Tables
Imagine your school ID card. It has specific pieces of information on it: your name, your student ID number, your class, and your date of birth. Let's use this to understand our key terms. Field: A field is a single piece of information about an item. In a spreadsheet, a field is represented by a column. Each column has a header that tells us what kind of information is in it. *Example:* On your ID card, 'Name' is a field, 'Student ID' is a field, and 'Class' is a field. In a spreadsheet, these would be our column headers. Record: A record is a complete set of fields for a single item. In a spreadsheet, a record is represented by a row. It contains all the information about one person or one thing. *Example:* All the information on *your* ID card (your name, your ID, your class) together forms one complete record. In a class list, all the information about one student in a single row is a record. Table: A table is a collection of related records. It's the entire set of data, organised into rows and columns. *Example:* A stack of ID cards for every student in JHS 3 is a table. In a spreadsheet, the entire class list with all students (records) and all categories of information (fields) is the table.
Visual Example: Consider this simple table of students:
| Student ID | Surname | First Name | House | | :--- | :--- | :--- | :--- | | B9001 | Adom | Kofi | Aggrey | <-- This is one RECORD (Row) | B9002 | Botwe | Ama | Sarbah | | B9003 | Mensah | Yaw | Guggisberg | The column "Surname" is a FIELD. The entire row for Kofi Adom (B9001, Adom, Kofi, Aggrey) is a RECORD. The entire collection of data is a TABLE. Part B: Structured vs. Unstructured Data Tables Structured Table: This is data that is highly organised in a fixed format, like the table above. Every record has the same fields, and the information in each field is of a consistent type (e.g., the 'Student ID' field always contains IDs, not names). This makes it very easy for a computer to search, sort, and analyse. Ghanaian Example: The BECE candidates register. Every student must provide their name, date of birth, school name, index number, etc. The format is the same for everyone. Unstructured Table/Data: This is information that does not have a predefined structure. It's often text-heavy and is not organised into neat rows and columns. Ghanaian Example: Imagine a teacher's end-of-term report comment written in a paragraph: "Kofi Adom is a brilliant student from Aggrey house, but he needs to work on his punctuality. His classmate, Ama Botwe from Sarbah house, is very hardworking." To find all students in Aggrey house from this text would be very difficult for a computer. It is unstructured. Part C: Practical Skills in Microsoft Excel