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
6. Page setup features
7. Manipulating a document using shortcut keys
8. Creating and formatting tables
9. Creating and formatting images and drawing
3
Use spread sheet
Use spread sheet
1. Common features of spreadsheets
2. Concepts of cell, 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
8. Sorting, filtering and data validation
9. Analysing data using “what if” analysis
10. Freezing and unfreezing pane
11. Creating and manipulating charts/graphs including pivot tables
12. Summarizing, consolidating and
  1. utlining data
13. Automating simple tasks
14. Protecting and sharing workbooks
15. Printing worksheets
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
3. Creating different types of publications
4. Creating, saving and retrieving publications
5. Setting page layout
6. Using frames
7. Typing and manipulating text
8. Identifying and using various icons in toolbars of the program including toolbox
9. Drawing and manipulating various shapes
10. Inserting and using the colour palette
11. Inserting and manipulating graphics
12. Importing and exporting files
13. Setting borders
14. Using merge tool
15. Working with tables
16. Linking and embedding
17. Automating simple tasks
18. Printing a publication
6
Use presentation software
Use presentation software
1. Common feature 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
11. Reviewing presentation
12. Saving, copying and deleting slides
13. Presentation views
14. Automating simple tasks
15. Collaboration in creating presentations
16. Printing handouts and slides