Certificate IN COMPUTER APPLICATION ( S-CCA-01 )

Fundamental of  Computer

· What is a Computer?     ·  Parts of a Computer 

·  Hardware and Software         · Input Devices

· Out Put Devices             ·  The Keyboard

· CPU, Mother board                ·  Storage Device

·  Memory                                       · Types of Computer

·  Generation of Computer       ·  Operating System

· Security and Antivirus   · Desktop, Icons, Files

·  Drive and Folder                       ·  Screen Saver

· Working with Files         ·  Start Button, All programs

·  Accessories                               ·  Notepad, WordPad, Calculator

·  Paint                               ·  Changing Date and Time of a Computer

·  Address Book                           ·  Windows Media Player

·  Playing Songs & Videos ·   Sound recorder

· Use of Pen drive             · Optical Drive- CD,DVD, Blue Ray

· Recycle Bin                     · Windows Explorer

·  Keyboard Shortcuts                · Application Soft wares

· Run                                  ·  Starting a Program

· Printer                              ·  Playing Games

· What is Internet?

Microsoft Office Word

Starting to use Microsoft Word

The Office Button

Groups

Saving MS Word documents

Bold, Italic, Underline

Case Changing, Highlighting

Selecting text

The Clipboard, Copy, Paste and Cut

Aligning Text, Indenting Paragraphs

Applying Bullets and Numbering list.

Finding and Replacing text

Paper size and Page Orientation

Spell checking a document

The Microsoft Word Screen

Tabs

Creating a new document

Font Type, Font Size

Subscript and Superscript

Font Color, Removing formatting

Inserting, deleting, undo and redo

Paragraph formatting

Applying single or double line spacing

Adding Borders and Shading

Page Formatting

Page Margin, Page number, Headers and Footers.

                                      Microsoft Excel

Starting to use Microsoft Excel 

The Microsoft Excel  Screen

The Office Button

Tabs , Ribbon

Groups

Creating a new document

Saving MS Excel documents

Column, Row, Cell, Cell Address

Text Formatting

Entering, Modifying and Deleting Data

Cell reference

Formulas & Functions

Sum, Subtraction, multiplication and Division Functions

Chart

Min, Max, Average, If & or Functions

Sorting

Conditional Formatting

Percentage Calculation

Data Validation

Group, Ungroup and Sub total

Working with Sheet & Work book

Paste Special

Resize Columns and rows

Protect Sheet and Protect Workbook

Text & Date Functions

Data Entry

Filter

Split

Freeze Panes

Round, Count, Now, Sort, Power Functions

Upper, Lower, Proper Functions

Linking Sheets

Auto Sum

Edit Custom Lists

Absolute Values

Print Titles

Other Functions

View Tabs

Print Preview and Printing Basics

To encrypt your file and set a password to open it.

                                                            Microsoft Power Point

Starting to use Microsoft PowerPoint

The Microsoft PowerPoint Screen

The Office Button

Tabs

Groups

Creating and Saving Presentation

New Slide

Inserting Text, Text Box & Symbols

Formatting Text

Viewing a Presentation

Inserting Clip Art, Shapes and Pictures

Grouping Objects

Flipping and Rotating Objects

Inserting a Chart

Applying a Transaction Effect

Modifying an Animation Effect

Previewing a Transaction or Animation Effect

Inserting Sound and Movie

Designing Slide Show

Working with Slides

Inserting Word Art

Custom Animation

Slide with Multimedia

Setting up a Slide Show

Print Preview and Printing Basics.

Eligibility

7TH PASSOUT