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

• Analyze past CAT examination papers.
• Apply advanced word processing skills (mail merge, styles, sections).
• Implement effective spreadsheet solutions (formulas, functions, charts).
• Demonstrate proficiency in database management skills (tables, relationships, queries).
• Evaluate ethical and societal implications of IT in South Africa.

Lesson summary

This week is dedicated to focused revision and exam preparation for Computer Applications Technology (CAT). The Grade 12 CAT exam assesses your ability to apply theoretical knowledge to practical scenarios using software applications like word processors, spreadsheets, databases, and the internet. Mastering these skills is crucial, not just for the exam, but for success in higher education and the modern workplace in South Africa. Almost every job today requires some level of computer literacy, from creating reports and managing data to communicating with clients and colleagues online.

Lesson notes

This section revisits core concepts tested in the CAT examination.

A. Word Processing (Microsoft Word or equivalent)

Styles: Styles are pre-defined formatting options that ensure consistency and efficiency in document creation. Instead of manually formatting each heading, paragraph, or table, you can apply a style. Think of Styles as templates for different document elements.

Why: Styles ensure consistency in fonts, sizes, spacing, and colours. They allow for easy modification of the entire document’s appearance by changing the style definitions.

How: To create a style, format a paragraph as desired. Then, in the Styles pane (usually found under the 'Home' tab), click 'Create a Style' and name it. To modify, right-click the style name and select 'Modify'.

Sections: Sections allow you to apply different formatting to different parts of the document. For instance, you might want different headers/footers, margins, or column layouts.

Why: Sections are crucial for creating complex documents like research papers or reports where different sections require different formatting.

How: Insert a section break (Layout/Breaks tab). You can choose between 'Next Page', 'Continuous', 'Even Page', or 'Odd Page' depending on your needs. Ensure "Link to Previous" is disabled in the Header & Footer design tab if you want each section to have different headers/footers.

Mail Merge: Mail merge is a powerful feature that allows you to create personalized documents (letters, emails, labels) for multiple recipients using a data source (e.g., a spreadsheet or database).

Why: Mail merge saves time and effort when sending similar documents to multiple people.

How: Start with a main document (e.g., a letter). Go to the 'Mailings' tab and click 'Start Mail Merge'. Select the document type (e.g., 'Letters'). Select the recipients (e.g., from an existing Excel spreadsheet). Insert merge fields into the main document (e.g., First Name, Last Name, Address). Preview the results and finish the merge.

Table of Contents: Automatically generated table of contents.

Why: Provides easy navigation in long documents and creates a professional look.

How: Use pre-defined heading styles in the text, then under the references tab select "Table of Contents" and select the appropriate table style.

B. Spreadsheets (Microsoft Excel or equivalent)

Formulas and Functions: Formulas are expressions that perform calculations on data in cells. Functions are pre-built formulas that perform specific tasks.

Why: Formulas and functions allow for efficient data analysis and manipulation.

How: Formulas start with an equals sign (=). Use cell references (e.g., A1, B2) to refer to cells. Common functions include SUM, AVERAGE, COUNT, MAX, MIN, I

F. For example, `=SUM(A1:A10)` calculates the sum of cells A1 to A

1

0. Charts: Charts visually represent data, making it easier to understand trends and patterns.

Why: Charts enhance communication and make data more accessible.

How: Select the data you want to chart. Go to the 'Insert' tab and choose a chart type (e.g., column chart, pie chart, line chart). Customize the chart with titles, labels, and legends.

PivotTables: PivotTables allow you to summarize and analyze large amounts of data quickly.

Why: PivotTables provide a flexible way to explore data and identify key insights.

How: Select the data you want to analyze. Go to the 'Insert' tab and click 'PivotTable'. Drag and drop fields into the 'Rows', 'Columns', 'Values', and 'Filters' areas to create different summaries.

Data Validation: Controls the type of data that can be entered into a cell.

Why: Prevents errors and maintains data integrity.

How: Select the cell or range of cells. Go to the Data tab and select Data Validation. Choose the criteria (e.g., whole number, list, date) and set the restrictions.

C. Databases (Microsoft Access or equivalent)

Tables: Tables store data in rows (records) and columns (fields).

Why: Tables are the foundation of a database, providing a structured way to organize information.

How: Define the fields (e.g., ID, Name, Address) and their data types (e.g., AutoNumber, Text, Date). Set a primary key to uniquely identify each record.

Relationships: Relationships define how tables are related to each other. Common types include one-to-one, one-to-many, and many-to-many.

Why: Relationships allow you to combine data from multiple tables to answer complex queries.

How: Use the Relationships window to link tables based on common fields. Enforce referential integrity to prevent orphaned records.

Queries: Queries retrieve data from one or more tables based on specified criteria.

Why: Queries allow you to extract specific information from the database.

How: Use the Query Design view to select tables, fields, and criteria. Use operators (e.g., =, >, Select Recipients > Use Existing List and select the Excel spreadsheet.

Insert merge fields: In the letter, click where you want to insert the title, then go to Mailings > Insert Merge Field > Title.