Information Technology (Subject Code 402) - Comprehensive Revision Notes

Vocabulary practice flashcards covering Unit 1 (Digital Documentation), Unit 2 (Electronic Spreadsheet), Unit 3 (Database Management System), and Unit 4 (Workplace Safety, Health, and Security) for Information Technology (Code 402).

Style (LibreOffice Writer)

A saved collection of all formatting information that can be applied to an entire document or selected text to ensure consistency and reduce formatting time.

Fill Format Mode

A feature in LibreOffice Writer used to apply a selected style quickly to multiple scattered pages, paragraphs, frames, characters, or tables without repeatedly reopening the Styles window.

Custom Style

A user-created style in LibreOffice Writer created either from a selected piece of formatted text or by using drag and drop into the Styles and Formatting window.

Template

A preset layout saved with the .ott file extension in LibreOffice Writer that contains predefined styles, headings, text, or graphics to easily create formal and professional documents.

Track Changes

A reviewing tool in LibreOffice Writer and Calc that records, marks in colors, and tracks modifications made by multiple users, allowing changes to be accepted or rejected.

Table of Contents (TOC)

An automated, hyperlinked list of headings and subheadings based on document heading styles ($\text{H1}$ to $\text{H10}$) that allows direct navigation to topics via Ctrl+Click.

Protected Against Manual Changes

A default checkbox option in the Table of Contents dialog box that prevents the generated table of contents from accidental direct manual edits.

Raster Image

A bit-mapped image composed of pixels that suffers adverse resolution effects and becomes distorted or blurred when resized.

Cropping

The process of cutting off or trimming away an undesirable outer section of an image without altering its original resolution scale.

Arrangement (Writer)

A positioning setting that controls the stacking order of graphics or images along an imaginary vertical axis relative to other objects or text.

Anchoring

The reference point to which a graphic or drawing object is tied in a document, such as a page, frame, paragraph, or character.

Text Wrapping

The setting that determines the relation and spatial flow of text around, beside, or through a graphic or drawing object.

Consolidate

A function in LibreOffice Calc used to combine, summarize, and aggregate data from multiple sheets or sources into a single worksheet.

Link to Source Data

A checkbox setting in Calc's Consolidate dialog box that automatically propagates changes made in source worksheets into the destination consolidated sheet.

Subtotal Tool

A feature in Calc that automatically groups rows by categories and applies mathematical functions like sum or average without requiring manual filters.

Multiple Operations Tool

A planning tool for what-if analysis in Calc that uses a formula array across input cells to generate a list of alternative results.

Goal Seek

An analysis tool in LibreOffice Calc used to determine the exact input value needed in a variable cell to reach a specific, desired target result in a formula cell.

What-If Scenario

A named set of input values that can be substituted into spreadsheet calculations to predict outcomes and compare different alternatives under varying conditions.

Relative Hyperlink

A hyperlink that references a target file path with respect to the active document's directory and only stops working if both starting and target locations change.

Absolute Hyperlink

A hyperlink that specifies the complete, full system path to a target file and stops working if the target file is moved.

Macro

A single named instruction that executes a saved sequence of commands or keystrokes to automate repetitive tasks.

Macro Library

A top-level container in LibreOffice that organizes modules, which in turn store individual macros.

Shared Spreadsheet

A workbook hosted in a shared network location that allows multiple users to view, access, and input data simultaneously.

Database Management System (DBMS)

A software application used to store, manage, organize, update, and retrieve data efficiently within an electronic database.

Relational Database Model

A database model proposed by E. F. Codd in 1970 where data elements are stored in tables of rows and columns linked by common fields.

Network Data Model

A database model represented as an inverted tree where multiple records can link to the same master record at the bottom.

Hierarchical Data Model

A database structure where records are arranged in a hierarchical, top-down tree-like arrangement of parent and child links.

Primary Key

A unique field or identifier in a table that uniquely identifies each row and cannot contain null or duplicate values.

Foreign Key

A field in a transaction table that references the primary key of a master table to establish and maintain a relationship.

Referential Integrity

A database concept that maintains consistency across relationships by ensuring no unmatched foreign key values exist in transaction tables.

Update Cascade

A referential integrity setting that automatically updates or deletes all matching foreign key records in related tables whenever the referenced master record is modified or deleted.

Query

A database object used to retrieve, filter, and display specific information matching defined search criteria from one or more tables.

Alias

An alternate, user-friendly column heading specified in a query design to replace technical field names in query results.

Form (LibreOffice Base)

A user-friendly visual front-end database object containing field controls used for entering, viewing, and modifying table data.

Report (LibreOffice Base)

A database object used to present, summarize, and layout retrieved data from tables or queries in an attractive, printable format.

Dynamic Report

The default report type in LibreOffice Base that automatically reflects changes whenever data values in the underlying tables or queries are updated.

MEMO Data Type (LONGVARCHAR)

A text data type in LibreOffice Base capable of storing descriptive text up to $64{,}000$ characters, exceeding the 255-character limit of standard text.

Occupational Health and Safety (OSH)

A government organization and set of national policies aimed at protecting employee health and preventing workplace accidents, illness, and injury.

Ergonomics

The science concerned with designing and arranging workspaces and equipment so people can work safely, comfortably, and productively.

Occupational Overuse Syndrome (RSI)

A condition characterized by persistent pain and discomfort in muscles, tendons, and soft tissues resulting from repetitive motions or prolonged poor posture.

Carpal Tunnel Syndrome

A repetitive strain injury affecting the wrists and fingers that is commonly caused by prolonged or improper typing and mouse use.

Emergency Action Plan

A written workplace document detailing evacuation routes, safety procedures, employee responsibilities, and emergency contact details for various crisis situations.

Class A Fire

A fire classification involving ordinary solid combustible materials such as wood, cloth, and paper.

Class B Fire

A fire classification involving flammable liquids, greases, and gases.

Class C Fire

A fire classification involving energized electrical materials and equipment.

Class D Fire

A fire classification involving combustible metals such as potassium, magnesium, and sodium.

Fire Extinguisher

A portable cylindrical pressure vessel containing an agent that can be discharged to extinguish or control small fires.