oncet for faculty: 2012 - - get a free blog here

Maharashtra Knowledge Corporation Limited

(MKCL)

OnCeT For Faculty: 2012

(Including details of new examination pattern)

ONCET : ON LINE CERTIFICATION FOR TEACHERS :

1 About OnCeT

Online Certification Test (OnCeT) is the certification examination mandatory for the Learning

Facilitators of all the Authorized Learning Centers (ALCs) applying for New Centers for MS-CIT

(Maharashtra State Certificate in Information Technology) course.

Exam is designed to examine the integral skills and competencies of the faculties for using

various application software tools effectively and efficiently, these integral skills are required to

be taught and practiced during MS-CIT course.

Objective of the OnCeT is to offer intellectually exciting and challenging e7erience to the

Learning Facilitator to apply their integral skills and knowledge of the software tools through a

set of integral assignments and thereby ensure their mastery on the subject matter so as to bring

about overall improvement in quality of academic delivery of the course.

2 Syllabus

The learning Facilitators applying for the OnCeT Examination are e7ected to have mastery on the

following skills

2.1 Theoretical Skills

MS-CIT Curriculum for Theory Topics

Sr. No Chapter Name Topics Concepts

1 Information Technology,

The Internet, and you

Information System , Wireless

revolution, Connectivity

Information Systems, people,

Software, System software,

Application Software, Hardware,

Types of computer, Microcomputer

hardware, Data, Connectivity, the

wireless revolution, and the internet,

A look to the future,

Discuss : Multiple choice , Matching,

and Open ended questions

2 The Internet, the web, and

electronic commerce

The Internet and the web,

Internet Access,

Communication, Search tools,

Electronic Commerce, Web

utilities

Web storefronts, web auctions,

security, Telnet, FTP, Plug-ins, filters,:

Blocking spam, A Look to the Future :

Internet , Search Engines, Met search

tools, Specialized search engines



3 Basic application software Application Software, Word

Processors, Spreadsheets,

Database Management

Systems, Presentation

Graphics ,Integrated

Packages, Software suites

,sharing data between

application

Common features, web-based

applications, Overview of various

application software, Features and

case studies

4 Specialized Application

software

Specialized Applications,

Graphics, Audio and Video,

Multimedia, Web authoring,

Emerging applications

Desktop Publishing, Image editors,

Illustration programs, Image galleries,

Graphics suites, Video editing

software, Audio editing software,

What is Multimedia?, Links and

buttons, Developing Multimedia

presentations, Multimedia authoring

programs, Web site design, web

authoring programs, Virtual Reality,

Knowledge based (e7ert) systems,

Robotics, Digital Video Editing, A

Look to the future : Emotions and

Robots,


and Open ended question

5 System software System software, Operating

systems, Operating systems,

Device Drivers,

Types of System software, Operating

system functions, features,

categories, Windows, Mac OS, Unix

and Linux, Windows utilities, Utility

suites, Device drivers, Add printer

wizard, Windows update, Virus

protection and Internet security, A

look to the future : IBM's new

supercomputer,


and Open ended questions

6 The System Unit System Unit, System board,

Microprocessor, Memory,

System clock, E7ansion cards

and slots, Ports,

System Unit, Electronic data and

instructions, Binary, Microprocessor,

Microprocessor chips, Specialty

processors, Memory, RAM, ROM,

CMOS, System clock, E7ansion slots

and cards, Plug and play cards, Bus

lines, E7ansion buses, ISA, PCI, AGP,

USB, HPSB, Ports, Standard Ports,

cables, Power Supply, Making IT work

for you : TV tuner cards and video

clips, A look to the future :

7 Input and Output Input devices, Output devices, What is input?, Keyboard entry, types

of keyboards, Pointing devices,

Mouse, Types of Mouse, Joystick,

Touch screen, light pen, Styles,

Scanning Devices, Optical scanners,

Bar code scanners, Character and

Mark recognition devices, Image



capturing devices, What is output?,

Monitors, Features of Monitors, types

of monitors, CRT monitors, Flat panel

monitors, other monitors, e-books,

data projectors, HDTV, Printers,

Features of printers, types of printers,

Inkjet printer, Laser printer, thermal

printer, other

8 Secondary Storage Storage, Hard disks, Hard

disks, Optical disk,

storage type, Floppy disks, traditional

floppy disk High capacity disks, Hard

disk, Internal hard disk, Hard disk

cartridges, hard disk packs, Hard disk

performance enhancement, Optical

disks, Compact disc, Digital versatile

disc, Solid state storage, Internet

hard drives, magnetic tape, mass

storage devices, Making IT work for

you : Music from the internet, A look

to the future : Blue Ray Techno

9 Communications and

networks

Communication,

Communication channels,

Connection Device,

Bandwidth, Networks,

Network Architecture,

Strategies, Organization

internets

Connectivity, The Connectivity, The

wireless revolution, Communication

systems, Communication Channels,

Physical connections, wireless

connections, Infrared, Broadcast

radio, Microwave, Satellite, GPS,

Connection Devices, Modem,

Connection service, types of

connections, Data Transmission,

Bandwidth and its categories,

Protocols, Networks, Specialized

terms in computer network, Network

types, LAN, MAN, WAN, Home

Network, Network Architecture,

topology, star topology, ring

topology, bus topology, hybrid

network, network strategies, terminal

network system, Client server

network systems, Peer to peer

network systems, Organizational

internets : Intranets and Extranets

2.2 Practical Skills

MS-CIT Curriculum for Practical Skills

Sr No Chapter Name Topic Skills

1 All About Computers Introduction to Computers,

Getting Started With

Computers,

The Keyboard

What is a Computer?

Generations of Computers

Types of Computer Systems

Components of a Computer System

Hardware

Software

Memory

Starting Up

Logging In

Graphical User Interface

What is a Mouse

Using a Mouse

Types of Mice

Other Pointing Devices

What is a Keyboard

Complex Script keyboard layouts

Entering Data

Keyboard Shortcuts

How the Keyboard works

2 Windows 7 Windows 7 Basic Skills

Organizing Your Work

Using Applications

Turning on the computer

Using the mouse

E7loring the Desktop

Using Windows 7

Working with Windows

Using Help

Working with Multiple Windows

Using My Computer

Shutting down Windows7

Working with Folders

Working with files

Using Notepad

Using Shortcuts

Using WordPad

Creating a graphic using Paint

Copying between Applications

Previewing, Printing and Saving

documents

Cleaning up the desktop

Windows Vista Windows Basics

Organizing Your Work

Using Applications

What is an Operating System ?

Microsoft Windows

Other Operating Systems

Introduction to Windows Vista

Using Windows Vista

Date and Time Settings

Working with Windows

Using Help

Working with Multiple Windows

Shutting down Windows Vista

Files and Folders



Using Computer

Working with Folders

Working with Files

Using Shortcuts

Using Notepad

Using WordPad

Creating a graphic using Paint

Copying between Applications

Previewing, Printing and Saving

Documents

Cleaning up the desktop

Using Calculator

3 Word Processing

Overview of Word Processing

Creating and Editing a

Document

Revising and Refining a

Document

Creating Reports and Tables

Changing the Display of the

Document

Using Mail Merge

Using Standard Templates

Overview of Word Processing


Document

Revising and Refining

Document

Creating Reports and Tables

Changing the Display of the

Document

Using Mail Merge

Using Standard Templates

What is Word Processing?

Introduction to Microsoft Word

Creating New Documents

Entering Text

Moving through Text

Auto Correct

Saving, Closing and Opening files

Navigating a Document

Editing a Document

Formatting a Document

Working with graphics

Previewing and Printing a Document

Revising a Document

Moving and Copying Selections

Working with Multiple Documents

Controlling Document Paging

Finding and Replacing text

Inserting the Current Date

Modifying Page Layout

Paragraph Formatting in detail

Character Formatting in detail

Creating Lists

Using Hyperlinks

Adding an AutoText entry

Using AutoShapes

Editing while previewing

Inserting Objects

Creating and Modifying an Outline

Saving to a new folder

Hiding Spelling and Grammar errors

Formatting Documents automatically

Creating a Table of Contents

Formatting a Document Section

Footnoting a document section

Footnoting a document

Adding Bookmarks

Formatting picture layout

Referencing figures

Creating a Simple Table

Sorting a List

Creating Headers and Footers



Checking the document

Updating the Table of Contents

Printing Selected Pages

Creating Newsletter Style Columns

Using Word Art

Inserting Symbols

Adding a Drop Cap

Using Mail Merge

Printing Mailing Labels

Preparing and Printing envelopes

Merging for sending emails using

Outlook

Using a Template from Word

Selecting the Template type

Adding details and saving as .doc file

What is Word Processing

Introduction to OpenOffice.org

Writer

Creating New Documents

Entering Text

Moving through Text

Auto Correct

Saving, Closing and Opening files

Navigating a Document

Editing a Document

Formatting a Document

Working with graphics

Previewing and Printing a Document

Revising a Document

Moving and Copying Selections

Working with Multiple Documents

Controlling Document Paging

Finding and Replacing text

Inserting the Current Date

Modifying Page Layout

Paragraph Formatting in detail

Character Formatting in detail

Creating Lists

Using Hyperlinks

Adding an AutoText entry

Using AutoShapes

Creating and Modifying an Outline

Saving to a new folder

Hiding Spelling and Grammar errors

Formatting Documents automatically

Creating a Table of Contents

Formatting a Document Section

Footnoting a document section

Footnoting a document

Adding Bookmarks

Formatting picture layout

Referencing figures

Creating a Simple Table

Creating Headers and Footers



Checking the document

Updating the Table of Contents

Printing Selected Pages

Creating Newsletter Style Columns

Inserting Symbols

Adding Drop Caps

Using Mail Merge

Preview the Merged Letter

Printing Mailing Labels

Preparing and Printing envelopes

Using a Template from Word

Selecting the Template type

Adding details and saving as .doc file

Language setting in Windows 7

Using Marathi language in Word or

Writer

4 Spreadsheet Overview

Creating and Editing

Using Charts

Using Charts

Managing a workbook

Overview of Spreadsheets


Worksheet

Using Charts

Managing a workbook

Brief Introduction

Features of Microsoft Excel 2003

Parts of a worksheet

Navigating the Excel worksheet

Creating a new workbook

Entering and editing data

Changing Column Width

Saving , closing and opening a

workbook

Moving cells

Centering and Merging cells

Using formulae

Duplicating cell contents

Using functions

Formatting the worksheet

Working with Graphics

Entering the date

Previewing and printing

Learning about charts

Creating a chart

Correcting errors

Working with sheets

Managing large sheets

Forecasting values

Customizing print settings

What is an electronic spreadsheet?

Introduction to OpenOffice.org Calc

Creating a new spreadsheet


Changing column widths

Merging and Splitting Cells

Saving, closing and opening

workbooks

Duplicating cell contents

Working with Formulae

Inserting Rows and Columns

Formatting the Worksheet



Working with Graphics

Entering the Date

Previewing and Printing a

Spreadsheet

Learning about Charts

Creating a single data series chart

Correcting worksheet errors

Working with sheets

Managing large sheets

Forecasting Values

Customizing Print Settings

Database Overview

Creating a database

Modifying a table

Creating Forms

Queries and reports

Overview of Database

Management System

Creating a Database

Modifying a Table

Queries and Reports

Brief Introduction

Introduction to Access

Creating a new database

Creating a Table


Changing column width

Preview and print a table

Close and open a table and database

Customizing and inserting fields

Finding and replacing data

Sorting records

Using form wizard

Adding records in a form

Using queries

Creating reports

Modifying report design

Printing a report

Creating report from query

What is a database?

Introduction to DBMS

Creating a new database

Creating a table

Entering and editing table data

Changing column width

Close, open a table and database

Inserting fields

Sorting records

Using queries

Using Reports

5 Internet Internet Basics

Navigating the Web

Finding Information on the

Web

Communication Using E-Mail

Internet Basics

Navigating the Web


Web


Web

Communication Using E-Mail

What is Internet?

What is WWW?

Information Flow over the Internet

How do we connect?

Browsers

Using URL's

Creating and using favorites

Using forms

Print and save web pages

Using search services

Google

Using Web e-mail Services



Using news groups

Using messengers for instant

messaging

What is Internet?

What is WWW?

Information Flow over the Internet

How do we connect?

Browsers

Using URLs

Creating and using favorites

Using forms

Print and save web pages

Using search services

Google

Using Web e-mail Services

Using news groups

6 Presentation Graphics Overview of Presentation

Graphics

Creating a Presentation

Modifying and Refining

Presentation

Using Advanced Presentation

Features

Overview of Presentation

Graphics

Creating a Presentation

Modifying and Refining a

Presentation

Using Advanced Presentation

Features

Introduction to Presentation Graphics

Using the AutoContent Wizard

View and edit a presentation

Save and open a presentation

Check spellings

Delete, Move, and Insert slides

Size and move placeholders

Run a slide show

Change Fonts and Formatting

Inserting clips and clip art

Preview And Print A Presentation

Find and Replace Text

Create and Enhance a Table

Modify graphics objects and create a

text box

Changing the Presentation Design

and Color Scheme

Change slide and title masters

Hide the Slide Footer

Duplicate and hide slides

Create and Enhance AutoShapes

Adding animation, sound, transition

and effects

Control and annotate a slide show

Create speaker notes

Check style consistency

Document a file

Print scaled and framed handouts

Creating a new presentation from

existing slides

Delivering Presentations

Adding Action Buttons

Introduction to Presentation Graphics

Using the AutoContent Wizard

View and edit a presentation

Save and open a presentation

Check spellings



Delete, Move, and Insert slides

Size and move place holders

Run a slide show

Change Fonts and Formatting

Inserting clips and clip art

Preview And Print A Presentation

Find and Replace Text

Create and Enhance a Table

Modify graphics objects and create a

text box

Changing the Presentation Design

and Color Scheme

Change slide and title masters

Hide the Slide Footer

Duplicate and hide slides

Create and Enhance AutoShapes

Adding animation, sound, transition

& build effect

Control and annotate a slide show

Create speaker notes

Check style consistency

Document a file

Print scaled and framed handouts

Creating a new presentation from

existing slides

Delivering Presentations

7 Personal Information

Manager

Getting started

Using the Address Book

Overview of Personal

Information Managers

Getting Started with Mozilla

Calendar

Using the Address Book

Introduction to Microsoft Calendar

Using Calendar

Creating an Appointment

Creating a recurring appointment

Creating an event

Changing the calendar view

Creating a task list

Categorizing tasks

Sorting tasks

Using a task timeline

Updating the task status

Printing tasks and calendar items

Creating Notes

What is an Address Book in Outlook

Adding Contacts

Removing Contacts

Importing & E7orting Contacts

Searching Address Books

Creating and editing mailing lists

What is a Personal Information

Manager?

Introduction to the Mozilla Calendar

Using a Calendar

Creating an Event/ Appointment

Creating a Recurring Appointment

Changing the Calendar View

Creating a Task List



Categorizing Tasks

Sorting Tasks

Using a Task Timeline

Updating the Task List

Printing Tasks and Appointments

Introduction to the Mozilla Address

Book

Entering Contacts

Creating Notes

Importing and E7orting Contacts

Deleting Contacts

Searching Address Book and

Directories

Creating and Editing a Mailing List

9 Making IT Work for You CD Writing

Virus Protection

Listening to Music

TV Tuner Card

PC to Mobile- Sending SMS

Active Desktop

What is CD Writing

Burning a CD using Windows 7

Erasing a CD

Other CD Burning Software

What is a Computer Virus?

Virus Protection

System Requirements

Downloading Music

Prevent Online Piracy

Listening to Music Online

What is a TV Tuner Card?

What is SMS?

What is an Active Desktop?

Enabling the Active Desktop

Adding a New Active Desktop Item

3 eContent for Practice and Training.

The Learning Facilitators would be provided with personalized Logins to access MKCL’s ERA :

eLearning evolution For All Framework to offer excellent study material in the form of interactive

multimedia eContent with rich voice over in English containing both inform and perform types of

content and rich presentation with focus on integral skills.

Practice Tests

Practice tests would be provided in the candidate’s login to have Mock Test on the examination

pattern and also to have hands on e7erience on the Test pattern.

4 Medium of Learning

The content will be provided in English language.

5 Examination & Evaluation

On the scheduled date and time of examination the Learning Facilitators would be required to visit the

exam center as allocated to them

Login details to access the examination will be given on the admit card as provided to the candidates

few days before the examination.

The candidate has to give timed examination based on the same pattern as given in the mock test

The examination will focus on multiple integral skills, the candidate has to perform the assignment,

the marks will be awarded for every correct step and marks will be deducted for every incorrect step.

The overall marks obtained at the end of the examination will be displayed.

6 Examination and Evaluation Pattern for OnCeT 2012

Final Exam Details

o Exam Syllabus

1. Practical Questions on MS-Office Word, Excel and PowerPoint

o Exam Type

1. Simulation based: -

The questions are simulated in the flash with in-build

interactivity.

User has to follow the steps required to accomplish the

task mentioned in the question.

User will get 3 attempts (3 Clicks) for every sub step (click)

to accomplish the task.

If the task, Sub Task is not accomplished in given 3

attempts then Hint will be provided and 90% Marks for

the Question will get deducted.

Please refer the Sample Question in your online ERA Login

and OnCeT 2011 Practical Exam Guidelines document for

more details.

o Question Details

1. Question will be based on some case study for example

In Word Processing “Flyer”, “Notice”, “Meeting”, “Agenda”

is given to you in learning content format.

In same matter similar task will be asked in the question.

The Question is called as Case Study and it will have some

Sub-Questions.

User will have to click on Sub-Question to solve it.

2. Total No. of Question (Case Studies): 10

3. Total No. of Sub-Questions Per Case Study: 5

4. Total No. of Sub-Questions in Final Exam : 50

o Marking Scheme

1. Maximum Marks per Sub-Question : 10

2. Maximum Marks per Question (Case Study) : 50

3. Total Marks for the Final Examination : 500 (50 * 10)

Marks Deduction

4. 90% marks will be deducted for using HINT: -9

Passing Criteria

5. Minimum Passing Marks: 300 (60%)

o Duration : 30 Min.

o Number of Attempts : 1

Note:-

o To Pass the Examination

1. Minimum Question to be solved without using HINT : 28 (28* 10=280)

2. Minimum Question to be solved using HINT : 22 (22 * 1 =22)

3. Total 50 Question and Marks = 280 +22 = 302 > 300 passing marks

o The Marks and other details mentioned above are subject to change. If changed will be

communicated prior to exam.