Page 12 - TP_IT_V1.0_C10_flipbpookl
P. 12
SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL
Chapter 3: Acquire skills in creating, Table of contents Create a Table of Contents (ToC): Generate
Advanced Features customizing, and managing Hierarchy of headings and customize a Table of Contents in a
of Writer a Table of Contents, using document.
and editing templates, Creating a Table of Content (ToC) Maintain a Table of Contents: Update or
and tracking and reviewing Customization of Table of Contents(ToC) delete the Table of Contents
changes in documents Maintaining a Table of Contents(ToC)
effectively. Updating ToC Use Templates: Create, import, and apply
Deleting ToC templates to a blank document, using in-
built, saved, or online templates.
Using templates Edit a Template: Modify, move, and export
Creating a Template an existing template.
Using In-built/Saved Templates Track Changes: Prepare a document for
Using Online Templates review by recording, accepting, or rejecting
Importing a Template changes, and manage comments by adding
Editing a Template or deleting them.
Moving a Template Compare Documents: Compare two
Exporting a Template versions of a document to identify and
Applying Templates to a Blank Document review differences.
Track Changes Feature
Preparing a Document for Review
Recording Changes
Accepting and Rejecting Changes
Adding Comments
Deleting Comments
Comparing Documents
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL
Chapter 4: Learn skills in consolidating Consolidating Data Use Consolidating Data: Aggregate data from multiple
Analyse data data, using groups and Groups and Subtotals sources into a single summary.
using scenarios subtotals, performing what- What-if Scenarios Create Subtotals: Apply subtotals to data groups to
and goal seek if analysis and scenarios, and summarize and analyze information.
utilizing the Goal Seek tool What-if Analysis Tool
for decision-making. Goal Seek Use “What-If” Scenarios: Create and analyze different
scenarios to forecast outcomes based on varying inputs.
Use “What-If” Tools: Use tools like Scenario Manager for
detailed what-if analyses.
Use Goal Seek and Solver: Use Goal Seek to find specific
input values needed to achieve a desired result, and apply
Solver for more complex problems.
Chapter 5: Develop skills in recording, Recording a Macro Demonstrate the Use of a Macro Recorder: Record a
Using Macros in running, creating, and Running a Macro macro to automate repetitive tasks.
Spreadsheet organizing macros, and Creating and Organising a Create a Simple Macro: Develop a basic macro to
using them as functions for perform a specific function.
document automation. Simple Macro
Macro as a Function Use a Macro: Execute an existing macro to automate
tasks in a document.
Pass Arguments to a Macro: Provide arguments to a
macro to customize its behavior.
Pass the Arguments as Values: Supply values as
arguments to a macro for dynamic operation.
Write Macros as Built-in Functions: Create macros
that function similarly to built-in functions for enhanced
functionality.
Access Cells Directly: Write macros to directly manipulate
cell data in spreadsheets.
Sort Columns Using a Macro: Develop and use a macro
to sort columns in a spreadsheet.
(x)

