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 techniques in Word Processing (Mail Merge, Styles, TOC).
• Design and implement effective spreadsheet solutions (Functions, Formulas, Charts).
• Utilize database skills to manage information (Queries, Forms, Reports).
• Demonstrate time management and problem-solving skills under exam conditions.

Lesson summary

This week focuses on consolidating our knowledge and skills across the Computer Applications Technology (CAT) curriculum, preparing you for the final examinations. CAT is essential for success in today's digital world. From managing personal finances online to accessing educational resources and participating in the South African economy, ICT skills are vital. In this revision week, we will reinforce core concepts, practice exam-style questions, and develop effective exam strategies to maximize your performance. This preparation is not just about passing an exam; it's about equipping you with the digital literacy needed to thrive in South Africa's evolving landscape.

Lesson notes

This section will cover key concepts from the entire Grade 12 CAT syllabus. We will address potential challenges and provide strategies for mastering each area. 2.

1. Advanced Word Processing (MS Word): Styles: Styles are pre-defined sets of formatting instructions (font, size, colour, spacing) that can be applied consistently throughout a document. Why? They ensure consistency, save time, and make document-wide formatting changes easy. How?* In Word, access the Styles pane (Home tab > Styles group). Create new styles by modifying existing ones or from scratch (right-click > Modify/Create). Use the "Update to Match Selection" option.

Mail Merge: Mail merge combines a main document (e.g., a letter) with a data source (e.g., a spreadsheet of names and addresses) to create personalized copies. Why? Mass communication with a personal touch is essential for businesses, NGOs, and even community outreach. How?* Mailings tab > Start Mail Merge > Step-by-Step Mail Merge Wizard. Choose the document type, data source, and insert merge fields. Preview and complete the merge.

Table of Contents (TOC): A TOC automatically generates a list of headings and their corresponding page numbers. Why? Essential for navigating long documents like reports or dissertations. Improves readability and professionalism. How?* Use Heading styles (Heading 1, Heading 2, etc.) to format your headings. References tab > Table of Contents > Choose a style. Update the TOC when changes are made to the document (right-click > Update Field).

Example: Imagine you are creating a brochure to inform residents about a new recycling program in your community. You can use styles to ensure consistency in headings and body text. If you need to send personalized letters to each household, mail merge is your tool. A table of contents will help residents quickly find the information they need within the brochure. 2.

2. Spreadsheets (MS Excel): Functions: Pre-built formulas that perform specific calculations (e.g., SUM, AVERAGE, IF, VLOOKUP). Why? They simplify complex calculations and automate data analysis. How?* =FUNCTION_NAME(argument1, argument2, ...). Learn to use the Help function in Excel to understand the purpose and syntax of each function.

Formulas: Equations that perform calculations using cell references and operators. Why? Essential for creating dynamic spreadsheets that automatically update when data changes. How? Start with an equals sign (=). Use cell references (e.g., A1, B2) and operators (+, -, , /). Use absolute cell references ($A$1) to prevent cell references from changing when copying formulas.

Charts: Visual representations of data (e.g., bar charts, pie charts, line graphs). Why? They make it easier to understand trends and patterns in data. How?* Select the data you want to chart. Insert tab > Charts group > Choose a chart type. Customize the chart with titles, labels, and legends.

Example: A small business owner can use Excel to track their monthly sales, calculate profits using formulas, and visualize sales trends with a chart. They can use the IF function to calculate discounts based on purchase amounts. 2.

3. Databases (MS Access): Tables: Structures that store data in rows (records) and columns (fields). Why? The foundation of a relational database, providing an organized way to store information. How?* Create tables in Design View, defining data types for each field (Text, Number, Date/Time, etc.). Set a primary key to uniquely identify each record.

Queries: Requests for specific data from a table or multiple tables. Why? Allow you to extract and analyze specific information from the database. How?* Create queries in Design View. Select the tables and fields you want to include. Set criteria to filter the data. Use calculated fields to perform calculations.

Forms: User-friendly interfaces for entering, viewing, and editing data in a table. Why? Make it easier for users to interact with the database, especially those who are not familiar with tables. How?* Create forms using the Form Wizard or Design View. Add controls (text boxes, labels, buttons) to the form.

Reports: Formatted summaries of data from a table or query. Why? Used to present data in a clear and concise way for printing or distribution. How?* Create reports using the Report Wizard or Design View. Group and sort data. Add calculations and summaries.

Example: A school library can use Access to store information about books, borrowers, and loans. They can use queries to find all books borrowed by a specific student. They can use forms to easily add new books to the database. They can use reports to generate a list of overdue books. 2.

4. Social Implications of ICT: Cyberbullying: Using electronic communication to bully a person.

Digital Divide: The gap between those who have access to ICT and those who do not.

Data Privacy: Protecting personal information from unauthorized access or use.

Plagiarism: Using someone else's work without giving credit.