Lesson Notes By Weeks and Term v5 - Grade 12

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

• Demonstrate proficiency in using spreadsheet software like Excel.
• Effectively use formulas and functions like VLOOKUP, IF, SUMIF, and COUNTIF.
• Understand and apply data validation, pivot tables, and chart creation.

Lesson summary

This week is dedicated to consolidating your understanding of core Computer Applications Technology (CAT) concepts, focusing on areas commonly assessed in the final examination. Effective revision is crucial for success. In a world increasingly reliant on technology, understanding and applying CAT principles is vital, regardless of your future career path. Whether you become a software developer, an entrepreneur leveraging digital marketing, or simply a digitally literate citizen, the skills you hone in CAT will be invaluable. Many everyday tasks, from managing your finances online to accessing educational resources, require a solid understanding of computer applications.

Lesson notes

2.1 Spreadsheet Software (Excel/Google Sheets) Spreadsheet software is a powerful tool for data analysis and manipulation. It allows you to organise data into rows and columns, perform calculations using formulas and functions, and create charts and graphs to visualise data.

Formulas and Functions: Formulas are expressions that perform calculations on data. Functions are pre-defined formulas that perform specific tasks. `SUM(range)`: Calculates the sum of the values in a specified range. `AVERAGE(range)`: Calculates the average of the values in a specified range. `MAX(range)`: Returns the largest value in a specified range. `MIN(range)`: Returns the smallest value in a specified range. `COUNT(range)`: Counts the number of cells in a range that contain numbers. `COUNTA(range)`: Counts the number of cells in a range that are not empty. `IF(condition, value_if_true, value_if_false)`: Returns one value if a condition is true and another value if the condition is false. This is especially useful for decision making. `VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`: Searches for a value in the first column of a table and returns a value from the same row in a specified column. This is invaluable for retrieving information from large datasets. `range_lookup` can be `TRUE` (approximate match) or `FALSE` (exact match). Always use `FALSE` if you require exact matches, which is typical. `SUMIF(range, criteria, [sum_range])`: Adds the cells in a range that meet a given criteria. `COUNTIF(range, criteria)`: Counts the number of cells within a range that meet a given criteria.

Data Validation: Data validation allows you to restrict the type of data that can be entered into a cell. This helps to prevent errors and ensure data consistency. For example, you can limit the values in a cell to a specific range of numbers, a list of options, or a specific data type.

Pivot Tables: Pivot tables are powerful tools for summarising and analysing large datasets. They allow you to quickly group and aggregate data based on different criteria. For example, you can use a pivot table to calculate the total sales for each product category.

Charts and Graphs: Charts and graphs are visual representations of data. They can be used to communicate data in a clear and concise way.

Column charts: Useful for comparing values across different categories.

Line charts: Useful for showing trends over time.

Pie charts: Useful for showing the proportion of different categories within a whole.

Scatter plots: Useful for showing the relationship between two variables.

Example: Let's say a small spaza shop in Soweto uses Excel to track their sales. They have columns for `Date`, `Product`, `Quantity`, and `Price per item`. They want to know the total sales for "Coca-Cola" in January. ```excel =SUMIFS(D:D*C:C, B:B, "Coca-Cola", A:A, ">=2024-01-01", A:A, " >, This letter is to inform you about the upcoming Computer Applications Technology exam. The exam will be held on >. Sincerely, The CAT Department ``` Go to the "Mailings" tab in Word and click "Start Mail Merge" -> "Letters". Click "Select Recipients" -> "Use an Existing List...". Choose your Excel spreadsheet data source. In the letter template, select the ` >` placeholder and click "Insert Merge Field" -> "Student Name". Repeat for ` >`. Click "Finish & Merge" -> "Edit Individual Documents..." to generate personalized letters for each student.

Commentary: This solution outlines the steps involved in creating a mail merge document, connecting it to an Excel data source, and inserting the appropriate merge fields. The placeholders act as visual guides for the process.

Question 5: A user is experiencing slow computer performance. Describe three possible causes and how you would troubleshoot them.

Solution: Cause: Too many programs running simultaneously.

Troubleshooting: Close unnecessary programs. Use Task Manager (Windows) or Activity Monitor (Mac) to identify resource-intensive programs.

Cause: Hard drive is full or fragmented.

Troubleshooting: Delete unnecessary files. Run Disk Cleanup (Windows) or use Disk Utility (Mac) to defragment the hard drive.

Cause: Malware infection.

Troubleshooting: Run a full system scan with a reputable antivirus program.

Commentary: These are three common causes of slow computer performance. The troubleshooting steps are practical and can be easily implemented by the user. Independent Practice (Questions Only) A supermarket chain needs to analyse its sales data. They have data for `Product Category`, `Sales Revenue`, and `Number of Units Sold`. Write an Excel formula to calculate the average revenue per unit sold for each product category using `SUMIF` and `SUMIF`. Design a database schema for a library system, including tables for `Books`, `Authors`, and `Borrowers`. Specify the primary and foreign keys and the relationships between the tables. Include fields relevant to a South African library context (e.g., Isbn, DeweyDecimal).