Computer Applications Practical II – KASNEB DICT Syllabus

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



Leave a Reply

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