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)

