Computer Applications – Practical – KASNEB Syllabus

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



Leave a Reply

Your email address will not be published. Required fields are marked *