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

• Apply advanced spreadsheet functions (VLOOKUP, SUMIF, etc.).
• Evaluate and implement cloud computing security measures.
• Understand and apply core database concepts.
• Troubleshoot common hardware and software issues.
• Effectively manage time during examinations.

Lesson summary

This week is dedicated to focused revision and examination preparation for Computer Applications Technology (CAT). Excelling in CAT opens doors to numerous career paths in South Africa, from IT support and data analysis to web development and cybersecurity. More importantly, strong computer skills empower you to participate effectively in the digital economy, access information, and contribute to a connected society. Many businesses, even small local ones in your community, rely heavily on proficient CAT skills for their daily operations. Revising effectively now ensures you are well-prepared for your upcoming assessments and future endeavors.

Lesson notes

2.1 Advanced Spreadsheet Functions: Spreadsheet software (like MS Excel or Google Sheets) is a powerful tool for organizing, analyzing, and presenting data. Mastering advanced functions significantly enhances your ability to extract meaningful insights from raw data.

VLOOKUP (Vertical Lookup): Searches for a value in the first column of a range and returns a value in the same row from a column you specify.

Syntax: `VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])` `lookup_value`: The value to search for. `table_array`: The range of cells to search in. `col_index_num`: The column number in the `table_array` from which to return a matching value. `[range_lookup]`: Optional. TRUE for approximate match (data must be sorted), FALSE for exact match.

HLOOKUP (Horizontal Lookup): Similar to VLOOKUP but searches in the first row of a range.

Syntax: `HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])` IF Function: Performs a logical test and returns one value if the test is TRUE and another value if the test is FALS

E. Syntax: `IF(logical_test, value_if_true, value_if_false)` Nested IF: An IF function within another IF function, allowing for multiple conditions.

Example: `IF(A1>90,"A",IF(A1>80,"B","C"))` COUNTIF: Counts the number of cells within a range that meet a given criteria.

Syntax: `COUNTIF(range, criteria)` SUMIF: Sums the values in a range that meet a given criteria.

Syntax: `SUMIF(range, criteria, [sum_range])` `sum_range`: Optional. The range to sum. If omitted, the `range` is summed.

Example 1 (VLOOKUP): A school has a table of student IDs and corresponding names. Use VLOOKUP to find the name of the student with ID 2024001. | Student ID | Student Name | | ---------- | -------------- | | 2024001 | Thando Nkosi | | 2024002 | Aisha Patel | | 2024003 | Sipho Dlamini | Formula: `=VLOOKUP(2024001, A1:B3, 2, FALSE)` Result: Thando Nkosi.

Explanation: The formula searches for 2024001 in the first column (A1:A3), finds it, and returns the value from the second column (B1:B3) in the same row. FALSE ensures an exact match.

Example 2 (SUMIF): A store tracks sales by product category. Calculate the total sales for the "Electronics" category. | Product Category | Sales (ZAR) | | ---------------- | ----------- | | Clothing | 5000 | | Electronics | 12000 | | Clothing | 3000 | | Electronics | 8000 | Formula: `=SUMIF(A1:A4, "Electronics", B1:B4)` Result:

2

0

0

0

0. Explanation: The formula checks each cell in the range A1:A

4. If the cell contains "Electronics", the corresponding value in B1:B4 is added to the sum. 2.2 Cloud Computing Security: Cloud computing offers benefits like accessibility and scalability, but introduces security concerns.

Strong Passwords: Use a combination of uppercase and lowercase letters, numbers, and symbols. Avoid using personal information.

Two-Factor Authentication (2FA): Requires a second verification method (e.g., SMS code) in addition to your password. This significantly increases security.

Data Privacy Policies: Understand how your data is stored, used, and protected by the cloud provider. Read the terms of service carefully.

Encryption: Ensure that your data is encrypted both in transit (when being transferred) and at rest (when stored on the cloud).

Example: Consider a South African company storing customer data in the cloud. They should implement strong passwords for all employee accounts, enable 2FA, and ensure the cloud provider has robust data encryption and complies with the Protection of Personal Information Act (POPIA). 2.3 Database Concepts: Databases are essential for storing and managing large amounts of structured data.

Normalization: The process of organizing data to reduce redundancy and improve data integrity. It involves dividing a database into tables and defining relationships between them.

Relationships: Connections between tables based on common fields.

Types: One-to-one, One-to-many, Many-to-many.

SQL (Structured Query Language): The standard language for interacting with databases.

Common commands: `SELECT`: Retrieve data. `INSERT`: Add new data. `UPDATE`: Modify existing data. `DELETE`: Remove data. `CREATE TABLE`: Define a new table. `ALTER TABLE`: Modify an existing table.

Example: Design a database for a school to manage student information, grades, and courses. The database should have tables for Students, Courses, and Grades.

Students Table: StudentID (Primary Key), Name, Surname, DateOfBirth, ContactNumber.

Courses Table: CourseID (Primary Key), CourseName, Credits.

Grades Table: StudentID (Foreign Key referencing Students table), CourseID (Foreign Key referencing Courses table), Grade.