PAPER NO. 2 COMPUTER APPLICATIONS – PRACTICAL
GENERAL OBJECTIVE
This paper is intended to equip the candidate with the knowledge, skills and attitudes that will enable him/her to use computer applications.
LEARNING OUTCOMES
A candidate who passes this paper should be able to:
- Install and uninstall appropriate software
- Use an operating system for file management
- Use a word processor
- Make a presentation using presentation packages
- Use a spreadsheet
- Use a database package
- Use a desktop publishing package
- Use application packages to create business
CONTENT
Basic computer operations
- Introduction to operating systems and application programs
- Starting up the computer
- Managing files and folders
- Plugging in, preparing and ejecting storage devices
- Loading applications
Peripheral devices
- Types of keyboards
- Keyboard layouts
- Keyboard ergonomics
- Touch screen
- Adding / removing printer
- Setting up default printer
- Projectors
Word processing software
- Using features of a word processor window
- Creating and retrieving existing documents
- Setting page setup features
- Using toolbars
- Formatting and editing text
- Manipulating a document using shortcut keys
- Creating and formatting tables
- Creating and formatting images and drawing
- Inserting and editing headers and footers
- Inserting footnote, endnotes, citation and bibliography
- Proofreading tools
- Using mail merge tool
- Tracking changes and comments
- Converting documents
- Linking and embedding
- Creating table of content, list of figures and list of tables
- Saving a document
- Using templates
- Automating simple tasks
- Printing a document
Spreadsheet software
- Using features of a spreadsheet window
- Creating , saving and retrieving existing workbook
- Cell editing and navigation
- Freezing and unfreezing pane
- 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
Presentation software
- Using features of a presentation program window
- Inserting a slide, typing and formatting text in a slide
- Importing and exporting content
- Working with master slides and templates
- Editing slide content
- Drawing and formatting various objects
- Working with graphics and charts
- Inserting and formatting images
- Animation effects
- Reviewing presentation
- Saving, copying and deleting slides
- Presentation views
- Automating simple tasks
- Printing handouts and slides
Database software
- Overview of databases
- Using features of a database window
- Creating, saving and retrieving existing database
- 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 (textbox)
- 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 the colour palette
- Inserting and manipulating images
- Importing and exporting files
- Setting borders
- Using merge tool
- Working with tables
- Linking and embedding
- Designing and creating simple websites
- Automating simple tasks
- Printing a publication
Emerging issues and trends
Share through