Page 13 - TP_IT_V1.0_C10_flipbpookl
P. 13

Chapter 6:      Learn  to  set  up multiple      Setting up multiple sheets.     Setup Multiple Sheets: Insert and  organize  new  sheets
                 Linking         sheets, create references      Creating reference to other   within a workbook.
                 Spreadsheet Data  and hyperlinks within and   sheets by using keyboard      Create References to Other  Sheets:  Use keyboard  and
                                 across documents, and link   and mouse.        mouse  to create references between  different sheets in a
                                 to external and registered                     workbook.
                                 data sources.            Creating reference to another
                                                        document by using keyboard      Create References to Other  Documents: Use  keyboard
                                                        and mouse.              and mouse to link data from one document to another.
                                                          Hyperlinks to the Sheet     Create, Edit, and Remove Hyperlinks:  Add, modify, and
                                                          Relative and Absolute   delete  hyperlinks to sheets within a workbook.
                                                        Hyperlinks                Link  to External  Data:  Connect  and  import  data  from
                                                          Creating Hyperlinks   external sources into your document.
                                                          Editing a Hyperlink     Link  to  Registered Data  Sources:  Establish  links  to
                                                          Linking to External Data  registered data sources for data integration.
                                                          Linking to Registered Data
                                                        Sources
                 Chapter 7:      Develop the ability to share,      Sharing Spreadsheet     Set Up a  Spreadsheet for  Sharing:  Configure  a
                 Share and       open,  and   save shared      Opening and saving a   spreadsheet to enable sharing with others.
                 Review  a       spreadsheets, track  and   shared spreadsheet.     Open and Save a Shared Spreadsheet: Access and save
                 Spreadsheet     review changes, and handle      Recording changes.  changes to a spreadsheet that has been shared with you.
                                 comments and merging for
                                 effective collaboration.     Add, Edit and Format the      Record Changes: Track  modifications  made  to  the
                                                        comments.               spreadsheet.
                                                          Reviewing Changes–View,      Add, Edit, and Format  Comments:  Insert, modify,  and
                                                        Accept or Reject Changes  format  comments  within  the spreadsheet.
                                                          Merging and comparing.     Review Changes:  View, accept,  or  reject changes made
                                                                                by others in the shared spreadsheet.
                                                                                  Merge and  Compare  Sheets:  Combine  and  compare
                                                                                different sheets to integrate data effectively.
                 Unit 3: Database Management System using LibreOffice Base

                    SUB UNIT     LEARNING OUTCOMES            THEORY                          PRACTICAL
                 Chapter 8:     Understand data and       Data and Information     Identify Data  and  Information: Distinguish  between  data
                 Introduction   information concepts, the      Databases and DBMS  and information  within  a  database context.
                 to Database    advantages of databases,                          Identify Fields, Records, and Tables:  Recognize  and
                 Management     various data models and key      Advantages  of database,  describe fields, records, and tables in a database.
                 System         terminology and objects of      Data Models
                                relational database systems.       Hierarchical Data Model     Prepare a Sample Table: Create a sample table with standard
                                                           Network Data Model   fields to illustrate database structure.
                                                           Relational  Data Model     Identify  Different  Types  of Data  Models: Identify
                                                                                and describe  various  data  models such  as hierarchical,
                                                          Relational database Model  network, and relational.
                                                           RDBS Terminology       Different Types  of  Keys:  Recognize  and  explain
                                                           Objects of an RDBMS  different types of keys used in databases, such as primary
                                                                                and foreign keys.
                                                                                  Identify  Different  Objects  of RDBMS:  Identify and
                                                                                describe  different  objects  in  a relational  database
                                                                                management  system (RDBMS),  including  tables, queries,
                                                                                and forms.
                 Chapter 9:     Learn to navigate LibreOffice      ntroduction to LibreOffice      Start LibreOffice Base and Observe the Main Window:
                                                         I
                 Starting with   Base, manage  data types,   Base               Launch LibreOffice Base and  familiarize yourself with the
                 LibreOffice Base  create  and save tables using      Data types  main  window’s components.
                                various methods, set  primary                     Create a Sample Table Using Wizard: Use the wizard to
                                keys, and  perform  data entry,      Starting with LibreOffice  create a sample table in any category.
                                editing, sorting, and record      User Interface Of LibreOffice
                                deletion.                Base                     Create  Different  Tables  from  Available List:  Practice
                                                          Opening a Database    creating  various  tables  by  selecting  fields  from the
                                                          Creating a Table      available options.
                                                            Using a Wizard        Assign Data Types and Set Primary Key: Define data types
                                                                                for fields and set a primary key for the table.
                                                            Using design view,     Edit the  Table  in  Design View: Modify  the  table
                                                          Setting primary key   structure  using the design view.
                                                          Saving a Table          Enter Data  in  the Fields:  Input data into the fields of
                                                          Entering data into table  your table.
                                                          Navigating through the      Delete Records from Table: Remove records from the table
                                                         table                  as needed.
                                                      •  Editing Data             Arrange Data in Ascending or Descending Order: Sort the
                                                      •   Deleting Records from Table  table data in ascending or descending order
                                                      •  Sorting Data in the Table


                                                                   (xi)
   8   9   10   11   12   13   14   15   16   17   18