Paper 4

COMPUTING INFORMATION SYSTEMS APPLICATIONS

This paper is intended to equip the candidate with the knowledge, skills and attitude that will enable him/her to competently use common computer system applications.

On completion, a candidate should be able to

Use a word processor to prepare documents and for online collaboration in preparation of common documents
Use a Device Operating System for file management
Competently choose and use free web-based application software such as Google Docs, Sheets, Slides
Install, use and uninstall application software such as Word processors, Spreadsheets, Database applications, Presentation applications
Use any spreadsheet package collaboratively with others
Competently use various packages including database, presentation and publishing packages

Content

1
Basic Computer Operations
1. 1.1
  Installation of an Operating System and other Application Programs
2. 1.2
  Operating systems and their relationship with application programs
3. 1.3
  Managing files and folders for a Device
4. 1.4
  Plugging in, preparing and ejecting storage devices
5. 1.5
  Peripheral devices and their functions in relation to using common application software/programs
2
Word Processing Software
1. 2.1
  Common features of word processors
2. 2.2
  Common toolbars in word processors
3. 2.3
  Using templates
4. 2.4
  Creating, saving and retrieving existing documents
5. 2.5
  Formatting and editing text
6. 2.6
  Page setup features
7. 2.7
  Manipulating a document using shortcut keys
8. 2.8
  Creating and formatting tables
9. 2.9
  Creating and formatting images and drawing
10. 2.10
  Inserting and editing headers and footers
11. 2.11
  Inserting footnote, endnotes, citation and bibliography
12. 2.12
  Proofreading tools
13. 2.13
  Using mail merge tool
14. 2.14
  Tracking changes and comments
15. 2.15
  Inserting and manipulating shapes, clipart, pictures, graphics in word processing
16. 2.16
  Converting documents using different word processors
17. 2.17
  Generating table of content, list of figures and list of tables (8)
18. 2.18
  Automating simple tasks
19. 2.19
  Protecting documents with passwords
20. 2.20
  Printing documents
3
Spreadsheet Software
1. 3.1
  Common features of spreadsheets
2. 3.2
  Concepts of cells, worksheets and workbooks
3. 3.3
  Creating, saving and retrieving workbooks
4. 3.4
  Cell editing and navigation
5. 3.5
  Formatting worksheets
6. 3.6
  Using formulae and functions
7. 3.7
  Manipulating data using different cell referencing methods
8. 3.8
  Sorting, filtering and data validation
9. 3.9
  Analysing data using “what if” analysis
10. 3.10
  Freezing and unfreezing pane
11. 3.11
  Creating and manipulating charts/graphs including pivot tables
12. 3.12
  Summarizing, consolidating and outlining data
13. 3.13
  Automating simple tasks
14. 3.14
  Protecting and sharing workbooks
15. 3.15
  Printing worksheets