SOFTWARE
1. Word Processors
Word Processors
Hardware
Applications
Overview
Creating a Document
Inputting Text
Selecting a Text Block
Editing Text
Find and Replace
Formatting Text
Fonts
Page Layout - Orientation
Page Layout - Margins
Page Layout - Justify
Page Layout - Spacing
Page Layout - Indents
Page Layout - Paragraphs
Page Layout - Columns
Page Layout - Show Codes
Page Layout - Final Touches
Advanced Tools
Advanced Tools - Mail Merging
Advanced Tools - Importing Objects
Saving Your Work
Returning to Your Work
Printing Your Work
Word Processers Exercises
2. Spreadsheets
Spreadsheets
Origins
Applications
Applications Example (1 of 2)
Applications Example (2 of 2)
What they do
Calculate Data
Analysing Data
Presenting Data
Worksheet
Rows & Columns (1 of 2)
Rows & Columns (2 of 2)
Cells
Moving about the worksheet
Ranges
Rows & Columns (1 of 2)
Rows & Columns (2 of 2)
Graphs
Macros
Example
Example - Layout
Example - Enter Data
Example - Formulas
Example - The Result
Speadsheets Exercises
3. Databases
Databases (1 of 3)
Databases (2 of 3)
Databases (3 of 3)
Example Applications (1 of 2)
Example Applications (2 of 2)
Key Terms
Entities
Tables
Fields (1 of 2)
Fields (2 of 2)
Records
Forms
Reports
Primary Key (1 of 2)
Primary Key (2 of 2)
Foreign Key
Queries
Example - Setting up tables
Example - Creating forms
Example - Creating a query (1 of 3)
Example - Creating a query (2 of 3)
Example - Creating a query (3 of 3)
Example - Creating a report
Database Development
Data Investigation (1 of 2)
Data Investigation (2 of 2)
Data Modelling
Data Modelling - Relationships
Relationships - One to One
Relationships - One to Many
Relationships - Many to Many
Data Modelling - Entities
Data Modelling - Attributes and Fields
Data Modelling - Library Model Example
Databases Exercises
4. Desk Top Publishing
Desk Top Publishing
Features of DTP - Frames (1 of 2)
Features of DTP - Frames (2 of 2)
Features of DTP - Columns and Snaking
Features of DTP - Kerning
Advantages of DTP
5. Systems Software
Systems Software (1 of 2)
Systems Software (2 of 2)
Operating Systems
Types of Operating Systems - PC's
Types of Operating Systems - Mini & Mainframe
Mini & Mainframe - Batch Processing
Mini & Mainframe - Single Workstation Multitasking
Mini & Mainframe - Time-share Processing
Mini & Mainframe - Real-time Processing
Operating Systems Services
Operating Systems Services - Initial Loading
MS-DOS - config.sys
MS-DOS - command.com
MS-DOS - autoexec.bat
Operating Systems Services - Loading Applications
Operating Systems Services - I/O Supervision
Operating System Services - File Management
Operating System Services - Protection Facilities
Systems Services - Utilities
Systems Services - Languages
Systems Services - Database Management Systems (DBMS)
GUI Operating Environment (1 of 2)
GUI Operating Environment (2 of 2)
Systems Software Exercises