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)
   7   8   9   10   11   12   13   14   15   16   17