PAPER NO. 12 COMPUTER APPLICATIONS PRACTICAL II
GENERAL OBJECTIVE
This paper is intended to equip the candidate with knowledge, skills and attitudes that will enable him/her to use computer application tools and systems.
LEARNING OUTCOMES
A candidate who passes this paper should be able to:
- Use a spreadsheet package
- Use a database package
- Use a desktop publishing
CONTENT
Spreadsheet software
- Using features of a spreadsheet window
- Creating , saving and retrieving existing workbook
- Editing and cell navigation
- Freezing and unfreezing panes
- Formatting worksheets
- Manipulating data using different cell referencing methods
- Using formulae and functions
- Sorting, filtering and data validation
- Analysing data using “what if” analysis
- Inserting charts and graphs including pivot tables
- Summarising, consolidating and outlining data
- Automating simple tasks
- Protecting and sharing workbooks
- Printing worksheets
Database software
- Overview of databases
- Using features of a database software window
- Creating, saving and retrieving existing databases
- Identifying tables fields, data types and records
- Establishing relationships between tables
- Creating forms and queries
- Manipulating data
- Searching data
- Sorting and filtering
- Adding charts, diagrams, tables and attachments
- Securing a database
- Automating simple tasks
- Configuring database start up options
- Printing from a database
Using a desktop publishing software
- Overview of desktop publishing software
- Using features of desktop publishing software
- Creating different types of publications
- Creating, saving and retrieving publications
- Setting page layout
- Using frames (textboxes)
- Typing and manipulating text
- Working with toolbars
- Identifying and using various icons in toolbars of the program including toolbox
- Drawing and manipulating various shapes
- Inserting and using colour palette
- Inserting and manipulating images
- Importing and exporting files
- Setting borders
- Using merge tool
- Working with tables
- Linking and embedding objects
- Designing and creating simple websites
- Automating simple tasks
- Printing a publication
Emerging issues and trends