SYLLABUS – CERTIFICATE COURSE IN OFFICE AUTOMATION    (CCOA)
Duration – 26 weeks
Week- 1
·        COMPUTER FUNDAMENTALS
1.       Knowing  computer
2.       Components of computer
3.       Computer Memory
4.       Concepts of Hardware and Software
5.       Data Processing and Number System
·        WINDOWS
1.       Introduction to operating system and its types
2.       Functions of Operating System
3.       Introduction to multiprocessor & processing modes
4.       Working with windows
5.       Managing files and folders
6.       Control Panel
7.       Personalizing your window
8.       Window Accessories
Practical Assignment  
Week -2 to 5
·        WORD PROCESSING
1.       Introduction to Word processor
2.       Word processing Basics
3.       Text creation and Editing
4.       Formatting text and Paragraph
5.       Inserting graphics
6.       Header and footer
7.       Working with table
8.       Mail merge
9.       Page setup and Print
·        LEARNING TYPING  
1.       Introduction
2.       Correct posture while working on computer
3.       Digit Placement and Positioning
4.       Typing with Various keys
5.       Touch typing
6.       Speed typing
Practical Assignment  
Week- 6 to 8
·        SPREAD SHEET
1.       Introduction to spread sheet
2.       Elements of spread sheet
3.       Manipulation of cells
4.       Formula and Functions
5.       Managing Data
6.       Inserting charts and Graphs
7.       Page Setup and Print
Practical Assignment  
Week -9
·        DIGITAL PRESENTATION
1.       Introduction to digital Presentation
2.       Basics of Presentation
3.       Preparation of Slides
4.       Inserting Objects
5.       Templates and color scheme
6.       Presentation of slides
7.       Creating multimedia slides
8.       Printing Handouts
Practical Assignment
Week-10
·        INTERNET AND E-MAIL
1.       Introduction
2.       Basics of Computer network
3.       WWW and Web browsers
4.       Navigating through web
5.       Services on web - E-mail, Chat etc
6.       Security and privacy issues
Practical Assignment
Week-11
·        INTRODUCTION TO E- GOVERNANCE AND DIGITAL FINANCIAL SERVICES 
1.       Introduction
2.       Scope of e- governance
3.       Digital Financial services
·        BASIC  TROUBLE SHOOTING
1.       Introduction
2.       Checking PC connections
3.       Checking I/O device
4.       Basic network problems
Practical Assignment
Week- 12
TYPING/ PRACTICE/ REVISION SESSION
Week- 13
·        INTRODUCTION TO PROGRAMMING TECHNIQUES
1.       Introduction to programming history
2.       Objective of program design
3.       Various programming techniques
§  Unstructured Programming
§  Procedural Programming
§  Modular Programming
§  Object-oriented Programming.


Week-14 to 16
·        INTRODUCTION TO DATABASE MANAGEMENT SYSTEM WITH MS-ACCESS.
1.       Introduction to Database and RDBMS
2.       Limitations of manual  system
3.       Introduction to MS- Access
4.       Creating a New Database
5.       Creating and  modifying table
6.       Relationships
7.       Query
8.       Forms and Reports
9.       Import / Export tables etc.

Practical Assignment
Week-17 to 19
·        OVERVIEW OF SQL SERVER
1.       Introduction
2.       Creating database and tables
3.       Data types
4.       Querying and modifying data
5.       Subqueries  & Joins
6.       Views and Derived tables
7.       Introduction to programming with transact-SQL
8.       Introduction to Stored Procedures and Triggers
Week-20 & 21
·        HTML
1.       Introduction to HTML elements
2.       HTML tags and Attributes
3.       Creating HTML Page
4.       HTML links, List types
5.       Creating HTML tables
6.       Adding pictures & images
7.       Adding video and Graphics
8.       Page accessibility
9.       Frames and Forms
10.   New elements in HTML
Week- 22 & 23
·        INTRODUCTION TO CSS
1.       What  is CSS
2.       Types of CSS
3.       Colors and Backgrounds(single and multiple)
4.       Fonts and text
5.       Links
6.       Class and id selectors
7.       Div and span tag
8.       Margins and padding
9.       Borders
10.   Positioning, floats and z-index
11.   2D and 3D Transforms, transitions and animation



Week- 24 & 25
·        JAVA SCRIPT
1.       Introduction to JavaScript
2.       Basic structure
3.       Control Structure
4.       Arrays and Strings
5.       Functions
6.       Document Object Model
7.       Events and Methods
8.       Validation

Practical Assignment
Week- 26
TYPING /PRACTICE/ REVISION SESSION

*NOTE : Typing practice to be inclusive part throughout the course