KLiC Certificate in Computer Applications - Class 9 CBSE (165)

Safely Browsing the Web and Using Social Networks

• Identity protection
• Proper usage of passwords
• Privacy
• Confidentiality of information
• Cyber stalking
• Reporting cybercrimes

Malware

• Viruses
• Adware

Introduction to a Word Processor

• Create and save a document

Edit and Format Text

• Text style (B, I, U)
• Font type
• Font size
• Text colour
• Alignment of text
• Format paragraphs with line and/or paragraph spacing
• Add headers and footers
• Numbering pages
• Grammar and spell check utilities
• Subscript and superscript
• Insert symbols
• Use print preview
• Print a document

Insert Tab

• Insert pictures
• Change the page setting
• Bullets and numbering
• Borders and shading
• Insert tables

Formatting and Review

• Use auto-format
• Track changes
• Review comments
• Use of drawing tools
• Shapes and mathematical symbols

Presentation Tool

• Understand the concept of slide shows
• Basic elements of a slide
• Different types of slide layouts
• Create and save a presentation
• Learn about the different views of a slide set

Edit and Format a Slide

• Add titles, subtitles
• Text
• Background
• Watermark
• Headers and footers
• Slide numbers

Insert Tabs

• Insert pictures from files
• Create animations
• Sound effects
• Rehearse timings

Spreadsheets

• Concept of a worksheet and a workbook
• Create and save a worksheet

Working with a Spreadsheet

• Enter numbers
• Text
• Date/time
• Series using auto fill

Edit and Format a Worksheet

• Changing the colour
• Size
• Font

Alignment of Text

• Insert and delete cells
• Rows and columns
• Enter a formula using the operators (+, -, *, /)
• Refer to cells
• Print a worksheet

Use Simple Statistical Functions

• SUM()
• AVERAGE()
• MAX()
• MIN()
• IF()

Embed Charts of Various Types

• Line
• Pie
• Scatter
• Bar
• Area in a worksheet

Lab Exercises

• Browser settings for a secure connection
• Working with the operating system
• Navigation of the file system using a mouse and keyboard

Word Processing

• Create a text document

  • Create a letter
  • Report
  • Greeting card
  • Create a text document with figures in it
  • It should describe a concept taught in another course

• Text document about the basic organisation of a computer

  • CPU
  • Memory
  • Input/output devices
  • Hard disk

• Create a text document in an Indian language other than English

• Create a presentation
• Create a presentation with animation
• Include existing images/pictures in a presentation

• Animate pictures and text with sound effects in a presentation

• Create a simple spreadsheet and perform the following operations

  • min
  • max
  • sum
  • average
• Create different types of charts using a spreadsheet
  • Line
  • Bar
  • Area
  • Pie