Lesson Notes By Weeks and Term v5 - Grade 10

Lesson Video

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.

Performance objectives

• Create a spreadsheet and input data (text, numbers, dates).
• Apply basic formatting (fonts, colours, number formats).
• Use basic formulas and functions (SUM, AVERAGE, MIN, MAX).
• Create and interpret simple charts.
• Understand and apply relative and absolute cell referencing.

Lesson summary

Spreadsheets are powerful tools used to organise, analyse, and present data. In today’s world, data is everywhere, and being able to work with it effectively is a crucial skill. From managing personal budgets to analysing business trends, spreadsheets provide a user-friendly interface for handling information. In South Africa, understanding spreadsheets can empower individuals to manage their finances, track agricultural data for small-scale farmers, and contribute to data-driven decision-making in various industries. This week, we focus on basic spreadsheet skills, including creating, formatting, and manipulating data to solve simple problems.

Lesson notes

2. 1. What is a Spreadsheet? A spreadsheet is an electronic document in which data is arranged in rows and columns. These rows and columns form cells, and each cell can contain data (text, numbers, dates), formulas, or functions. Spreadsheets are primarily used for organizing data, performing calculations, and creating visual representations of data through charts and graphs. Common spreadsheet applications include Microsoft Excel, Google Sheets, and LibreOffice Calc. 2.

2. Key Spreadsheet Components: Workbook: A spreadsheet file is referred to as a workbook. It can contain multiple worksheets.

Worksheet: A single page within a workbook, consisting of rows and columns.

Rows: Horizontal lines identified by numbers (e.g., 1, 2, 3...).

Columns: Vertical lines identified by letters (e.g., A, B, C...).

Cell: The intersection of a row and a column. Each cell has a unique address (e.g., A1, B2, C3).

Cell Address: The location of a cell, defined by its column letter and row number (e.g., A1).

Active Cell: The cell that is currently selected and ready for data input or editing. 2.

3. Entering Data: You can enter different types of data into a spreadsheet cell: Text: Labels, names, or descriptions (e.g., "Name", "Grade", "Product").

Numbers: Numerical values (e.g., 10, 3.14, -5).

Dates: Dates in various formats (e.g., 2024-10-27, 27/10/2024). The spreadsheet program typically recognizes these as date values for calculations.

Formulas: Equations that perform calculations. Formulas always start with an equals sign (=).

Functions: Predefined formulas that perform specific tasks (e.g., SUM, AVERAGE, MIN, MAX).

Example: Consider a small business in Soweto selling vetkoek. | Day | Vetkoek Sold | Price per Vetkoek | |----------|--------------|---------------------| | Monday | 50 | R 5.00 | | Tuesday | 60 | R 5.00 | | Wednesday| 75 | R 5.00 | | Thursday | 80 | R 5.00 | | Friday | 100 | R 5.00 | 2.

4. Basic Formatting: Spreadsheet applications offer various formatting options to enhance readability and presentation.

Some common formatting techniques include: Font: Changing the font type, size, and colour.

Alignment: Aligning text within cells (left, center, right).

Number Formatting: Formatting numbers as currency, percentages, decimals, etc. (e.g., R 5.00).

Borders: Adding borders to cells or ranges of cells.

Fill Colour: Adding background colour to cells.

Example: In the vetkoek spreadsheet above, you could format the "Price per Vetkoek" column as currency (Rands). Select the column, then apply currency formatting. 2.

5. Basic Formulas and Functions: Formulas and functions are essential for performing calculations in spreadsheets.

Formulas: Formulas start with an equals sign (=) followed by the calculation you want to perform. You can use cell references (e.g., =A1+B1) to refer to data in other cells.

Functions: Functions are predefined formulas that perform specific tasks.

Some common functions include: SUM(range): Calculates the sum of a range of cells (e.g., =SUM(B2:B6) calculates the sum of cells B2 to B6).

AVERAGE(range): Calculates the average of a range of cells (e.g., =AVERAGE(B2:B6)).

MIN(range): Finds the smallest value in a range of cells (e.g., =MIN(B2:B6)).

MAX(range): Finds the largest value in a range of cells (e.g., =MAX(B2:B6)).

Example: To calculate the total vetkoek sold for the week, use the following formula in a new cell (e.g.

B7): `=SUM(B2:B6)`. To find the average number of vetkoek sold per day, use: `=AVERAGE(B2:B6)`. 2.

6. Relative and Absolute Cell Referencing: Relative Cell Referencing: When you copy a formula, relative cell references change relative to the new location. For example, if cell C2 contains the formula `=A2+B2`, and you copy this formula to cell C3, the formula in C3 will become `=A3+B3`.

Absolute Cell Referencing: To prevent a cell reference from changing when you copy a formula, use absolute cell referencing. You indicate an absolute cell reference by placing a dollar sign ($) before the column letter and/or row number (e.g., $A$1, A$1, $A1). `$A$1`: Absolute reference. Both column and row remain fixed. `A$1`: Row remains fixed, column can change. `$A1`: Column remains fixed, row can change.

Example: In the vetkoek spreadsheet, let’s say you want to calculate the total revenue for each day. Create a new column called "Total Revenue" (Column D). In cell D2, enter the formula `=B2C2` (Vetkoek Sold Price per Vetkoek). Now, you can copy this formula down to cells D3, D4, D5, and D

6. The cell references will automatically adjust because they are relative. If you had a fixed commission rate (e.g., 10%) stored in cell A8, and wanted to calculate the commission earned each day by multiplying Total Revenue by this fixed rate, the formula in cell E2 (assuming column E is titled "Commission") would be: `=D2$A$8`. Copying this formula down will calculate the commission for the remaining days, always referencing the commission rate in cell A8. 2.7.