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: 4
Grade code: B9.2.4.1.2
Strand code: 2
Sub-strand code: 4
Content standard code: B9.2.4.1
Indicator code: B9.2.4.1.2
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 today's digital world, being able to present information clearly and professionally is a vital skill. Whether you are running a small business like a provision shop, managing your personal pocket money, or preparing a report for school, you need tools to make your work neat, consistent, and fast. Electronic spreadsheets like Microsoft Excel offer powerful features beyond just calculations. This lesson focuses on four of these features: Styles, Themes, Templates, and Macros. These tools help us format our work quickly and professionally, saving time and making our data easier to understand.
This lesson will focus on four key features that enhance our productivity in spreadsheet applications like MS Excel. a) Templates What is a Template? A template is a pre-designed, pre-formatted spreadsheet file that serves as a starting point for a new document. Think of it like a form you fill out, but on a computer. Instead of creating a document from a blank sheet, you use a template that already has the layout, formulas, and formatting set up for a specific purpose. Why use a Template? Saves Time: You don't have to design the layout from scratch. Ensures Consistency: If everyone in a group uses the same template for a report, all reports will look uniform. Professional Look: Templates are often designed by professionals and look very neat. Ghanaian Context Example: Imagine your headmaster asks all class prefects to submit a weekly report on class attendance. Instead of each prefect creating their own table, the headmaster can provide a template. The template would already have columns for "Day," "Number Present," "Number Absent," and maybe even a formula to calculate the weekly average attendance. All a prefect needs to do is open the template and fill in the numbers. How to Use a Template in MS Excel: Open MS Excel. Instead of clicking on "Blank workbook," look at the options below it. You will see templates like "Personal monthly budget," "Academic calendar," "Sales report," etc. You can also type what you are looking for in the search bar (e.g., "Invoice" or "Timetable"). Click on the template you want to use. A preview window will appear. Click the Create button. A new workbook will open based on that template, ready for you to enter your data. b) Styles What is a Style? A Style is a pre-defined set of formatting options (like font size, font colour, bold, cell border, and cell background colour) that you can apply to a cell or a range of cells with a single click. Why use a Style? It's much faster than applying each formatting option one by one. For example, instead of making a cell bold, changing its font to *Calibri 14pt*, and setting its background to *light blue* every time you create a heading, you can just apply a "Heading 1" style. Ghanaian Context Example: Let's say you are creating a table of your terminal exam scores. You can use styles to make it easy to read. Apply the "Heading 1" style to the main title "JHS 3 First Terminal Report". Apply the "Heading 4" style to the column titles (Subject, Class Score, Exam Score, Total). Apply the "Total" style to the final row that calculates your total score. Apply the "Good" style (often green) to your highest scores and the "Bad" style (often red) to your lowest scores. How to Apply a Cell Style in MS Excel: Select the cell or range of cells you want to format. Go to the Home tab on the ribbon. In the "Styles" group, click on Cell Styles. A gallery of styles will appear (e.g., Good, Bad and Neutral; Data and Model; Titles and Headings). Hover your mouse over a style to see a live preview on your selected cells. Click on the style you want to apply. c) Themes What is a Theme? A Theme is a coordinated set of colours, fonts (for headings and body text), and effects (like lines and fill effects) that are applied to the *entire workbook*. While a style formats a single cell, a theme changes the look of everything at once. Why use a Theme? It gives your entire workbook a consistent, professional, and visually appealing look. Changing the theme is a very quick way to completely change the appearance of your spreadsheet without reformatting every single cell. How Themes and Styles Work Together: When you apply a theme, it changes the appearance of the built-in styles. For example, the "Heading 1" style might be blue in the default "Office" theme, but it might become green if you switch to the "Wisp" theme. How to Apply a Theme in MS Excel: Go to the Page Layout tab on the ribbon. In the "Themes" group, click the Themes button. A gallery of themes will drop down. Hover your mouse over a theme to see a live preview of how your entire worksheet will change. Click on the theme you like to apply it to your workbook. d) Macros What is a Macro? A Macro is a recording of a sequence of commands and actions that you can play back to automate a repetitive task. It's like teaching the computer to do a series of steps for you, so you can do it all with one click next time. Why use a Macro? To save a lot of time and reduce errors on tasks you do over and over again. For example, if every month you have to format a sales report in the exact same way (create a total row, make headings bold, apply a border), you can record a macro to do all those steps instantly. Core Difference: Template vs. Macro This is a common point of confusion, but the difference is simple: A Template is a starting file. It’s a pre-built structure. A Macro is a recorded action. It’s a series of steps that you can run on *any* file (new or existing).
Analogy: A template is like a blank application form for a job (the structure is there). A macro is like a rubber stamp that you can use to automatically sign and date any document (the action is recorded).
Guided Practice (With Solutions)
Scenario Data: Imagine you are the treasurer for your school's 'Readers Club'. You have a small table tracking weekly dues collection.