Page 14 - TP_IT_V1.0_C10_flipbpookl
P. 14

Chapter 10:    Develop skills in editing and      Editing  and Deleting tables,    Insert Data in the Table: Add new data entries to a table.
               Working with   deleting tables, creating and      Relationships between      Edit Records in the Table:  Modify existing records within
               Multiple Tables  managing table relationships,   tables        the table.
                              and ensuring referential
                              integrity.                Types of Relationships– one     Delete Records from Table:  Remove specific records from
                                                      to one, one to many, many   the table.
                                                      to many                  Sort Data in the Table: Arrange  data  in ascending  or
                                                        Advantages of Relating   descending order within the table.
                                                      Tables in a Database     Create   and   Edit   Relationships:   Establish   and
                                                        Creating Relationships   modify  relationships  between  tables,  including
                                                      between Tables          one-to-one, one-to- many, and many-to-many.
                                                        Referential Integrity     Enter  Various  Field  Properties:  Set  and  adjust  different
                                                                              properties for fields in  the table.

               Chapter 11:    Acquire  skills  in creating             Queries     Prepare a Query for Given  Criteria: Create a query based
               Queries in Base  and editing queries using both      Query creation using wizard  on specified criteria.
                              wizards and design view, and                     Create  a  Query  Using  Wizard  and  Design  View:
                              working  with numerical  data      Creation of query using   Demonstrate  how  to  generate  a query  using  both the
                              in queries.             design view
                                                        Editing a query,      wizard and design view.
                                                        Working with Numerical      Edit  a  Query:  Modify  an  existing  query  to  update  its
                                                      Data                    criteria or structure.
                                                                               Apply Various Criteria in a  Query: Demonstrate applying
                                                                              different criteria in a query, including single field, multiple
                                                                              fields, and wildcard searches.
                                                                               Perform  Calculations  Using  Query  in  Base:  Execute
                                                                              calculations within a query in LibreOffice Base.
               Chapter 12:    Able to create and modify      Forms in BASE.     Create a Form Using Form  Wizard: Generate  a form by
               Forms and      forms and reports in      Creating form using wizard,  following the steps in the Form Wizard.
               Reports        LibreOffice Base, use the                        Enter or Remove Data from  Forms: Input  new  data  or
                              Form Controls  Toolbar, and      Modifying a Form  delete existing data using forms.
                              insert additional controls,      Form Controls Toolbar
                              titles, headings, and date/time     Report in Base     Modify Forms: Demonstrate how to adjust and customize
                              elements in reports.      Inserting other controls in   forms.
                                                      report                   Change Label and Background: Modify the label text and
                                                        Inserting Titles & Headings  background color or design of a form.
                                                        Inserting Date & Time     Search Records Using a Form: Use the form to find specific
                                                                              records based on search criteria.
                                                                               Insert  and  Delete  Records  Using Form View:  Add  new
                                                                              records or remove existing ones through the Form View.
                                                                               Create a Report Using Report  Wizard: Illustrate the steps
                                                                              to generate a report using the Report Wizard.
                                                                               Demonstrate Various Report Examples: Provide examples of
                                                                              different types of reports created using the Report Wizard.

              Unit 4: Maintain Healthy, Safe and Secure Working Environment


                 SUB UNIT     LEARNING OUTCOMES                     THEORY                           PRACTICAL
               Chapter 13.   Understand workplace health,      Introduction to Health, Safety, and Security At      Practice Basic Safety Rules:
               Health, Safety   safety, and security policies,   Workplace                     Implement fire safety  measures,
               and Security at   identify various hazards, and      Policies  and   Procedures  for Healthy, Safety and Security  prevent  falls  and slips, ensure
               Workplace     learn how to manage risks                                         electrical safety, and apply
                             and maintain a safe working      Reasons  for  Health,  Safety, and Security Programs   first aid procedures to protect
                             environment.             or Policies in the Workplace             workers and prevent accidents.
                                                        Workplace Safety Hazards
                                                        Physical Hazards
                                                        Falling Off Heights, Slipping  and Tripping
                                                        Electrical Hazards
                                                        Fire Hazards
                                                        Health Hazards
                                                        Potential  Sources  of  Hazards  in an Organisation
                                                        Hazards using Computers
                                                        Handling Office Equipment
                                                        Handling Objects
                                                        Stress at Work
                                                        Working Environment
                                                        Hazard Control
                                                        Safety Guidelines Checklist
   9   10   11   12   13   14   15   16   17   18   19