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

• Identify key components of a spreadsheet interface.
• Enter and edit data like text, numbers, and dates.
• Use basic formulas like SUM, AVERAGE, and MAX.
• Format cells to make your data clear and readable.
• Create simple charts to visualize data.

Lesson summary

Spreadsheets are powerful tools for organizing, analyzing, and presenting data. In today's world, from managing personal budgets to tracking business finances, understanding spreadsheets is a crucial skill. This week, we'll focus on the basic principles of solution development using spreadsheets. This skill is particularly important in South Africa, where many businesses, organizations, and individuals rely on spreadsheets for managing finances, stock control, agricultural data, and much more. Think about a small spaza shop owner tracking their inventory or a farmer managing crop yields – spreadsheets can significantly improve their efficiency.

Lesson notes

2.1 Understanding the Spreadsheet Interface A spreadsheet is essentially a grid of rows and columns, forming cells where data is entered. Think of it like a digital ledger. Each cell has a unique address, like `A1` (column A, row 1) or `B5` (column B, row 5).

Ribbon: The ribbon is the toolbar at the top of the spreadsheet application (e.g., Microsoft Excel, Google Sheets, LibreOffice Calc). It contains various commands organized into tabs like "Home," "Insert," "Formulas," and "Data." These commands are used for formatting, data manipulation, and more.

Cells: The basic building blocks of a spreadsheet. Each cell can contain text, numbers, dates, or formulas.

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

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

Name Box: Displays the address of the currently selected cell. Located usually above column

A. Formula Bar: Displays the contents of the active cell. When a formula is entered, it appears here. Located next to the name box.

Worksheet Tabs: Allows you to switch between different worksheets within the same spreadsheet file (workbook). 2.2 Data Entry and Editing Entering data is straightforward: click on a cell and start typing.

Text: Words, labels, and descriptions.

Numbers: Numerical values used in calculations.

Dates: Dates can be formatted in various ways (e.g., 2024-10-26, 26/10/2024, October 26, 2024). Ensure the spreadsheet recognizes the data as a date and not just text.

Editing: Double-click a cell to edit its contents directly or use the formula bar. Use `Delete` or `Backspace` to remove data. `Ctrl+Z` (or Cmd+Z on macOS) undoes the last action.

Example 1: Stock List for a Spaza Shop Let's say Thandi owns a spaza shop. She wants to create a stock list. In cell A1, type "Item". In cell B1, type "Quantity". In cell C1, type "Price per Item (ZAR)". In cell A2, type "Bread". In cell B2, type "20". In cell C2, type "12.50". Repeat for other items (e.g., Milk, Sugar, Maize Meal). 2.3 Basic Formulas Formulas are the heart of spreadsheets. They perform calculations on data. All formulas start with an `=` sign.

SUM: Adds up a range of numbers. `=SUM(A1:A10)` adds the numbers in cells A1 through A

1

0. AVERAGE: Calculates the average of a range of numbers. `=AVERAGE(B1:B5)` calculates the average of the numbers in cells B1 through B

5. MIN: Finds the smallest number in a range. `=MIN(C1:C8)` finds the smallest number in cells C1 through C

8. MAX: Finds the largest number in a range. `=MAX(D1:D12)` finds the largest number in cells D1 through D

1

2. COUNT: Counts the number of cells in a range that contain numbers. `=COUNT(E1:E6)` counts the number of cells with numeric data in cells E1 through E

6. Example 2: Calculating Total Stock Value for Thandi's Spaza Shop Thandi wants to know the total value of her bread stock. In cell D1, type "Total Value (ZAR)". In cell D2, type the formula `=B2*C2` (quantity multiplied by price per item). This will calculate the total value of bread. You can then copy this formula down to other rows to calculate the total value of other items.

Example 3: Calculating Average Rainfall Let's say you have rainfall data for different months: | Month | Rainfall (mm) | | :------ | :------------ | | January | 50 | | February| 35 | | March | 20 | | April | 15 | | May | 10 | To calculate the average rainfall, enter the data into a spreadsheet. In a separate cell (e.g., B7), enter the formula `=AVERAGE(B2:B6)`. This will calculate the average rainfall over the 5 months. 2.4 Cell Formatting Formatting makes your spreadsheet easier to read and understand.

Font Styles: Change the font, size, color, and apply bold, italics, or underline.

Alignment: Align text to the left, right, or center of a cell.

Number Formats: Format numbers as currency (ZAR), percentages, dates, or decimals. Crucial for working with financial data.

Example 4: Formatting Thandi's Spaza Shop Data Select the cells containing currency values (Price per Item and Total Value). Apply the currency format (ZAR) using the formatting tools (usually a currency symbol icon on the ribbon). Change the font to Arial and font size to

1

2. Bold the column headings (Item, Quantity, Price per Item, Total Value). 2.5 Simple Charts Charts visually represent data, making it easier to identify trends and patterns.

Column Chart: Compares values across categories (e.g., sales figures for different products).

Bar Chart: Similar to a column chart but displays data horizontally. Useful for long labels.

Pie Chart: Shows the proportion of each category relative to the whole (e.g., market share of different companies).

Example 5: Creating a Column Chart of Rainfall Data Select the rainfall data (including the month labels). Go to the "Insert" tab and choose a "Column Chart" type. The chart will automatically be created, showing the rainfall amount for each month. You can customize the chart by adding titles, labels, and changing the colors.