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

• Formulate basic formulas using cell references and operators.
• Use common built-in functions like SUM, AVERAGE, MIN, and MAX.
• Create simple charts and graphs to visualize data.
• Apply conditional formatting to highlight important information.
• Develop simple spreadsheet solutions for real-world problems.

Lesson summary

This week, we're diving deeper into spreadsheets, specifically focusing on using them to develop solutions to common problems. Spreadsheets, like Microsoft Excel or Google Sheets, are incredibly powerful tools for organizing, analyzing, and visualizing data. In South Africa, understanding spreadsheets can help with everything from managing household budgets to tracking stock in a spaza shop, or even analyzing agricultural yields on a farm. This week's focus will be on solidifying your foundational skills and applying them to create practical solutions.

Lesson notes

2.1 What is a Spreadsheet Solution? A spreadsheet solution is a specific spreadsheet designed to solve a particular problem or manage a specific type of data. It's not just a blank spreadsheet; it's carefully constructed with appropriate labels, formulas, functions, and formatting to achieve a defined purpose. For example, a spreadsheet to track the sales of airtime vouchers at a local store is a spreadsheet solution. 2.2 Key Components of a Spreadsheet Solution: Data Input Cells: These are the cells where you enter the raw data. Clear labels are crucial so anyone using the spreadsheet knows what data to input. For example, in a stokvel budget spreadsheet, input cells might include "Member Name," "Monthly Contribution," and "Date of Contribution." Formulas and Functions: These are the heart of the solution. Formulas perform calculations on the data, and functions are pre-built formulas that perform specific tasks (like SUM, AVERAGE, etc.).

Output Cells: These cells display the results of the calculations. For example, the "Total Sales" or "Average Contribution" cells.

Formatting: Formatting makes the spreadsheet easier to read and understand. This includes using bold text for headings, appropriate number formats (e.g., currency for financial data), and borders to separate sections.

Charts and Graphs (Optional): Visual representations of the data, making it easier to identify trends and patterns. 2.3 Basic Formulas and Operators: Starting a Formula: All formulas in a spreadsheet must begin with an equals sign (=).

Cell References: Use cell references (e.g., A1, B2, C10) to refer to specific cells in the spreadsheet. This allows the formula to automatically update when the data in those cells changes.

Arithmetic Operators: `+` (Addition) `-` (Subtraction) `` (Multiplication) `/` (Division) `^` (Exponentiation)

Example: If cell A1 contains the value 10 and cell B1 contains the value 5, the formula `=A1+B1` in cell C1 would display

1

5. The formula `=A1*B1` in cell D1 would display 50. 2.4 Common Built-in Functions: SUM(range): Calculates the sum of a range of cells. For example, `SUM(A1:A10)` adds up the values in cells A1 through A

1

0. AVERAGE(range): Calculates the average of a range of cells. For example, `AVERAGE(B1:B5)` calculates the average of the values in cells B1 through B

5. MIN(range): Finds the smallest value in a range of cells. For example, `MIN(C1:C20)` finds the smallest value in cells C1 through C

2

0. MAX(range): Finds the largest value in a range of cells. For example, `MAX(D1:D8)` finds the largest value in cells D1 through D

8. COUNT(range): Counts the number of cells in a range that contain numbers. For example, `COUNT(E1:E12)` counts the number of cells with numbers in E1 through E

1

2. Example: A spaza shop owner wants to calculate the total sales for the day. They have recorded the sales amounts in cells A1 through A

5. They can use the formula `=SUM(A1:A5)` in cell A6 to display the total sales. 2.5 Charts and Graphs: Charts and graphs are visual representations of data.

Common types include: Bar Charts: Used to compare values across different categories. For example, comparing the sales of different types of snacks in the spaza shop.

Pie Charts: Used to show the proportion of different categories within a whole. For example, showing the percentage of each type of expense in a household budget. 2.6 Conditional Formatting: Conditional formatting allows you to automatically format cells based on their values. For example, you could highlight all sales figures above a certain amount in green, or all temperatures below freezing in blue.

Example: In a table of student test scores, you could use conditional formatting to highlight all scores above 70% in green and all scores below 40% in red. Guided Practice (With Solutions)

Question 1: A fruit vendor sells apples, bananas, and oranges. The number of each fruit sold on Monday is: Apples - 25, Bananas - 30, Oranges -

1

5. Create a spreadsheet to calculate the total number of fruits sold on Monday.

Solution: Open a new spreadsheet.

Enter the following labels: A1: Fruit B1: Quantity Sold Enter the fruit names and quantities: A2: Apples B2: 25 A3: Bananas B3: 30 A4: Oranges B4: 15 In cell A5, enter the label: Total Fruits Sold In cell B5, enter the formula: `=SUM(B2:B4)` Cell B5 will now display the total number of fruits sold (70).

Commentary: We used the SUM function to add up the quantities of each fruit sold. This is a simple example, but it demonstrates the basic principle of using spreadsheets for calculations.

Question 2: A group of friends are saving money in a stokvel. The monthly contributions of each friend are: Friend 1 - R150, Friend 2 - R200, Friend 3 - R100, Friend 4 - R180, Friend 5 - R

2

2

0. Calculate the average monthly contribution.

Solution: Open a new spreadsheet.