Lesson Notes By Weeks and Term v3 - Junior Secondary 3
Worksheets
Download the Lessonotes Mobile Nigeria 2025 app for faster lesson access on Android and iPhone.
Worksheets
Download the Lessonotes Mobile Nigeria 2025 app for faster lesson access on Android and iPhone.
Subject: Information Technology (IT)
Class: Junior Secondary 3
Term: 3rd Term
Week: 10
Theme: Computer Application Packages
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.
open, enter, edit and save data in a worksheet; for mat text, cells and columns in a worksheet; perform simple calculations; print data from worksheets.
This section provides a detailed explanation of core concepts and practical steps for working with worksheets. The examples provided are designed to be relatable to the Nigerian context. 2.
1. Introduction to Worksheets (Spreadsheets) A worksheet (also known as a spreadsheet) is an electronic grid used for organizing, analyzing, and storing data in tabular form. It consists of rows and columns, where data can be entered and manipulated using formulas and functions. Popular spreadsheet software includes Microsoft Excel, Google Sheets, LibreOffice Calc, and WPS Spreadsheets. For this lesson, we will generally refer to Microsoft Excel as the primary example, but the concepts apply to most spreadsheet programs.
Workbook: A collection of one or more worksheets. When a spreadsheet program opens, it usually starts a new workbook.
Worksheet/Sheet: A single page within a workbook, identified by tabs at the bottom (e.g., Sheet1, Sheet2).
Column: A vertical series of cells, identified by letters (A, B, C, ...).
Row: A horizontal series of cells, identified by numbers (1, 2, 3, ...).
Cell: The intersection of a row and a column. It is the basic unit for storing data.
Cell Address/Reference: The unique identifier for a cell, formed by combining its column letter and row number (e.g., A1, B5).
Active Cell: The currently selected cell, indicated by a thick border. Data entered appears in the active cell.
Range: A group of selected cells, denoted by the addresses of the first and last cells separated by a colon (e.g., A1:C5 refers to all cells from A1 to C5).
Formula Bar: A bar at the top of the worksheet window that displays the content of the active cell, especially formulas. 2.
2. Opening a Worksheet To begin working with a spreadsheet:
1. Start Button: Click the "Start" button (usually at the bottom-left corner of the screen).
2. Programs/All Apps: Navigate to "All Apps" or "All Programs".
3. Find Program: Locate and click on the desired spreadsheet software (e.g., "Microsoft Excel," "LibreOffice Calc," or "Google Sheets" if online).
4. New Workbook: The program will open, usually presenting a blank new workbook ready for data entry. 2.
3. Entering Data in a Worksheet Data can be text (labels), numbers (values), dates, or formulas.
1. Select Cell: Click on the desired cell (it becomes the active cell).
2. Type Data: Type the data directly into the cell.
3. Confirm Entry: Press `Enter` to move to the cell directly below. Press `Tab` to move to the cell directly to the right. Click on another cell to confirm and move. Use arrow keys to move to adjacent cells.
Example (Nigerian Context): A student creating a list of market prices for common food items. In cell A1, type "Food Item". In cell B1, type "Price (Naira)". In cell A2, type "Yam". In cell B2, type "2500". In cell A3, type "Rice (bag)". In cell B3, type "45000". In cell A4, type "Beans (congo)". In cell B4, type "1200". 2.
4. Editing Data in a Worksheet Sometimes data needs to be corrected or updated.
1. Direct Overwrite: Select the cell. Type the new data. The old data will be replaced. Press `Enter`.
2. Edit in Cell (F2 Key): Select the cell. Press the `F2` key, or double-click the cell. The cursor appears inside the cell, allowing specific character edits. Make changes and press `Enter`.
3. Edit using Formula Bar: Select the cell. Click inside the Formula Bar (at the top of the window). Make changes and press `Enter` or click the checkmark icon in the Formula Bar.
Example: Changing the price of Yam from ₦2500 to ₦
3
0
0
0. Click cell B2 (which contains "2500"). Type "3000". Press `Enter`. 2.
5. Saving Data in a Worksheet Saving ensures that your work is not lost.
1. Save Button: Click the `Save` icon (usually a floppy disk icon) on the Quick Access Toolbar, or go to `File` > `Save`.
2. First-time Save (Save As): If saving for the first time, the "Save As" dialog box will appear.
Choose Location: Select click the checkmark icon in the Formula Bar.
Example: Changing the price of Yam from ₦2500 to ₦
3
0
0
0. Click cell B2 (which contains "2500"). Type "3000". Press `Enter`. 2.
5. Saving Data in a Worksheet Saving ensures that your work is not lost.
1. Save Button: Click the `Save` icon (usually a floppy disk icon) on the Quick Access Toolbar, or go to `File` > `Save`.
2. First-time Save (Save As): If saving for the first time, the "Save As" dialog box will appear.
Choose Location: Select where to save the file (e.g., Documents, Desktop, a specific folder).
File Name: Type a descriptive name for the workbook (e.g., "Market_Prices_Kaduna").
Save as type: Ensure it's saved as an Excel Workbook (`.xlsx`) or compatible format.
Click Save: Click the `Save` button.
3. Subsequent Saves: After the first save, simply clicking the `Save` icon or `File` > `Save` will update the existing file with changes. 2.
6. Formatting Text, Cells, and Columns Formatting enhances readability and presentation.
Formatting Text (Font Group):
1. Select Cells: Select the cell(s) containing the text to format.
2. Font Type: Click the drop-down arrow next to the font name (e.g., "Calibri") and choose a new font (e.g., "Arial").
3. Font Size: Click the drop-down arrow next to the font size (e.g., "11") and choose a new size (e.g., "14").
4. Font Styles: Click `B` (Bold), `I` (Italic), `U` (Underline) to apply or remove styles.
5. Font Color: Click the `A` icon with a color bar beneath it, then choose a color.
6. Alignment (Alignment Group): Horizontal: Click icons for `Align Left`, `Center`, `Align Right`.
Vertical: Click icons for `Top Align`, `Middle Align`, `Bottom Align`.
Wrap Text: Makes text wrap to multiple lines within a cell if it's too long to fit on one line.
Merge & Center: Combines multiple selected cells into one large cell and centers the content.
Formatting Cells (Number & Style Groups):
1. Select Cells: Select the cell(s) to format.
2. Number Format (Home Tab > Number Group): Click the drop-down menu (usually "General"). Choose `Currency` (e.g., to display ₦), `Percentage`, `Date`, etc. Use the `Increase Decimal` or `Decrease Decimal` buttons to adjust decimal places.
3. Cell Borders: Click the `Borders` icon (looks like a square with a grid) and choose a border style (e.g., `All Borders` to put lines around all selected cells).
4. Fill Color: Click the `Fill Color` icon (looks like a paint bucket) and choose a background color for the cell(s).
Formatting Columns and Rows (Cells Group):
1. Resizing Columns/Rows: Manual: Hover the mouse between the column letters (e.g., between A and B) until the cursor changes to a double-headed arrow. Click and drag to resize. Similarly for rows.
AutoFit: Double-click the boundary between column letters/row numbers to automatically adjust to the widest content.
Using Menu: Right-click on the column letter(s) or row number(s), choose `Column Width` or `Row Height`, and enter a specific value.
2. Inserting/Deleting Columns/Rows: Insert: Right-click on a column letter or row number, then select `Insert`. A new column/row will be inserted to the left/above the selected one.
Delete: Right-click on a column letter or row number, then select `Delete`. 2.
7. Performing Simple Calculations (Formulas) Formulas are expressions that perform calculations in a worksheet.
Starting a Formula: All formulas must begin with an equals sign (`=`).
Arithmetic Operators: `+` (Addition) `-` (Subtraction) `` (Multiplication) `/` (Division)
Cell References: Formulas typically use cell references (e.g., A1, B2) instead of actual numbers, so if the data in the referenced cells changes, the formula result updates automatically. * Example 1: Total Sales for a "Mama Put" Vendor A vendor records sales for different food items: | Cell | Item | Price (₦) | Quantity Sold | | :--- | :-------- | :-------- | :------------ | | A1 | Item | B1 | C1 | | A2 | Rice | 500 | 15 | | A3 | Beans | 300 | 10 | | A4 | Amala | 400 | 20 | To calculate actual numbers, so if the data in the referenced cells changes, the formula result updates automatically.
Example 1: Total Sales for a "Mama Put" Vendor A vendor records sales for different food items: | Cell | Item | Price (₦) | Quantity Sold | | :--- | :-------- | :-------- | :------------ | | A1 | Item | B1 | C1 | | A2 | Rice | 500 | 15 | | A3 | Beans | 300 | 10 | | A4 | Amala | 400 | 20 | To calculate the total sales for Rice:
1. Go to cell D2 (for "Total Sales for Rice").
2. Type `=B2C2` (Price Quantity).
3. Press `Enter`. The result (7500) will appear in D
2. To calculate the overall total sales for all items:
1. Go to cell D5 (for "Grand Total").
2. Type `=D2+D3+D4` (summing individual total sales).
3. Press `Enter`. Using Simple Functions (Shortcut to complex formulas): Functions are pre-defined formulas that perform specific calculations. `SUM(range)`: Adds all numbers in a range. `=SUM(D2:D4)` would achieve the same grand total as `=D2+D3+D4`. `AVERAGE(range)`: Calculates the average (mean) of numbers in a range.
Example: `=AVERAGE(B2:B4)` would calculate the average price of the items. `MAX(range)`: Finds the largest number in a range.
Example: `=MAX(C2:C4)` would find the highest quantity sold. `MIN(range)`: Finds the smallest number in a range.
Example: `=MIN(B2:B4)` would find the lowest price. `COUNT(range)`: Counts the number of cells that contain numbers in a range.
Example: `=COUNT(A2:A4)` would count the number of food items listed (returns 3).
Steps to use a function:
1. Select the cell where the result should appear.
2. Type `=` followed by the function name (e.g., `SUM`).
3. Type an opening parenthesis `(`.
4. Select the range of cells to include in the function (e.g., click and drag from D2 to D4). The range will appear in the formula.
5. Type a closing parenthesis `)`.
6. Press `Enter`. 2.
8. Printing Data from Worksheets To get a hard copy of the worksheet:
1. Prepare Data: Ensure all data is entered and formatted correctly.
2. Select Print Area (Optional but Recommended): If only a specific part of the worksheet needs printing, select that range of cells. Go to `Page Layout` tab > `Print Area` > `Set Print Area`.
3. Print Preview: Go to `File` > `Print`. This shows how the worksheet will look on paper.
4. Page Setup (Print Settings): In the Print Preview window, or via `Page Layout` tab > `Page Setup` group: Orientation: Choose `Portrait` (vertical) or `Landscape` (horizontal).
Margins: Adjust the space around the edges of the page.
Scaling: Adjust `Fit Sheet on One Page`, `Fit All Columns on One Page`, or `Fit All Rows on One Page` if data doesn't fit.
Headers/Footers: Add page numbers, date, filename, etc.
5. Print: Printer: Select the desired printer from the drop-down list.
Copies: Specify the number of copies.
Pages: Choose to print all pages or a specific range. Click the `Print` button. 3.
1. Teacher Activities Introduction (5 minutes): Briefly introduce the concept of worksheets and their relevance, using examples like school records or market ledgers. Ask probing questions about how they currently manage lists or calculate totals manually.
Demonstration: Opening, Entering, Editing, Saving (15 minutes): Project the computer screen using a projector or interactive whiteboard. Demonstrate step-by-step how to open Excel, enter sample data (e.g., student names and 3 subject scores), edit a cell, and save the workbook with a relevant filename (e.g., "JSS3_Term3_Scores"). Explain each action clearly, using the correct terminology (cells, rows, columns, active cell, formula bar).
Demonstration: Formatting (15 minutes): Using the previously entered data, demonstrate how to: Make headers (e.g., "Student Name", "Maths", "English") bold, centered, and change their font color. Change the font type and size for student names. Apply borders to the entire data range. Adjust column widths to fit content. Apply currency format to any monetary values if added.
Demonstration: Simple Calculations (20 minutes): Add a "Total Score" column to the student score worksheet. Demonstrate how to write a simple addition formula (e.g., `=B2+C2+D2` assuming scores are in B2, C2, D2). Demonstrate how to use the `SUM` function (e.g., `=SUM(B2:D2)`) and how to `AutoFill` the formula down for other students. Introduce `AVERAGE`, `MAX`, `MIN` functions with relevant examples from the student scores.
Demonstration: Printing (10 minutes): Using the completed worksheet, demonstrate `File > Print`. Show how to use Print Preview, adjust page orientation (portrait/landscape), set print area, and scale the content to fit on one page. Emphasize the importance of checking print preview before printing to save paper.
Guided Practice Session (30 minutes): If computers are available, guide students through practical exercises (see Section 4). Circulate around the classroom, providing assistance and clarifying misconceptions. If no computers, lead a simulated practical on the board, having students dictate steps.
Question and Answer / Recap (5 minutes): Address student questions and briefly recap the key skills learned. 3.
2. Student Activities Observation & Note-taking: Pay close attention during teacher demonstrations, noting down steps and key terms.
Active Participation: Respond to teacher questions, ask clarifying questions. Hands-on Practice (if computers are available): Open a new workbook. Enter provided data (e.g., a list of school expenses, sales figures for a small shop, or student names and scores). Practice editing data. Save their work with a meaningful filename. Apply various formatting options to text, cells, and columns. Create simple formulas for addition, subtraction, multiplication, division. Use `SUM`, `AVERAGE` functions. Practice using Print Preview and adjusting print settings.
Discussion: Participate in classroom discussions about the relevance of worksheets.
Problem-solving: Work individually or in pairs to solve practical problems given by the teacher.
Small Scale Business Management (Economy): Many local traders and entrepreneurs in Nigeria, from market stall owners selling provisions to tailors keeping records of customer orders, can use basic worksheets. They can track inventory (Stock quantity, purchase price, selling price), daily sales, calculate profits, manage expenses, and keep customer contact lists. This replaces traditional paper ledgers, making calculations faster and reducing errors.
Example:* A seamstress records fabric purchases, customer measurements, and payment status for each order in a simple worksheet. She uses formulas to calculate profit per garment. Household Budgeting and Personal Finance (Community/Daily Life): Nigerian families can use worksheets to manage their household finances. This includes tracking monthly income (salaries, business earnings), categorizing expenses (food, transport, school fees, utilities), and setting saving goals. By visualizing where money goes, families can make informed decisions to manage their resources better.
Example:* A family creates a budget where they list monthly income in one column and allocate funds for rent, NEPA bill, foodstuffs, and children's school transport, using a formula to calculate remaining funds. School Administration and Academic Records (Education): Teachers can use worksheets to record student attendance, class test scores, and assignment marks. They can then use functions like `AVERAGE`, `SUM`, `MAX`, and `MIN` to quickly calculate total scores, class averages, identify top performers, and even prepare basic report card data. This simplifies the often tedious manual calculation process.
Example:* A JSS3 teacher inputs continuous assessment scores for all students in various subjects and then uses a worksheet to calculate each student's total score and the class average for each subject.