Paper 4

COMPUTER INFORMATION SYSTEMS APPLICATIONS

This unit covers competencies required to apply basic computer operation skills, perform word processing, use spreadsheet, perform database management, apply desktop publishing and use presentation software.

On completion, a candidate should be able to

Apply basic computer operation skills
Perform word processing
Use spread sheet
Perform database management
Apply Desktop publishing
Use presentation software

Content

1
Apply basic computer operation skills
Apply basic computer operation skills
1. Installing application program
2. Creating files and folders
3. Using storage devices
  1. Cloud drive
  2. Flash disc
  3. DVD
  4. CD
4. Connecting printer to a computer
5. Use network resources
  1. Files
  2. Folders
  3. Printers
6. Protect files with password
2
Perform word processing
Perform word processing
1. Common features of word processors
2. Common toolbars in word processors
3. Using templates
4. Creating, saving and retrieving existing documents
5. Formatting and editing text
3
Use spread sheet
Use spread sheet
1. Common features of spreadsheets
2. Concepts of cells, worksheets and workbooks
3. Creating, saving and retrieving workbooks
4. Cell editing and navigation
5. Formatting worksheets
6. Using formulae and functions
7. Manipulating data using different cell referencing methods
4
Apply database management
Apply database management
1. Overview of database concepts
2. Common features of a database
3. Creating, saving and retrieving databases
4. Identifying tables, fields, data types and records
5. Establishing relationships between tables
6. Creating forms and queries
7. Data manipulation in database applications
8. Data sorting and filtering
9. Adding charts, diagrams, tables and attachments
10. Securing a database
11. Automating simple tasks
12. Configuring database start-up
  1. ptions
13. Printing from a database
5
Apply Desktop publishing
Apply Desktop publishing
1. Overview of desktop publishing software
2. Common features of desktop publishing software
6
Use presentation software
Use presentation software
1. Common features of presentation applications
2. Working with master slides and templates
3. Creating presentations from scratch
4. Inserting a slide, typing and formatting text in a slide
5. Importing and exporting content
6. Editing slide content
7. Drawing and formatting various
  1. bjects
8. Working with graphics and charts
9. Inserting and formatting images
10. Animation effects