VOCATIONAL COMPUTER TRAINING PROGRAM (VCTP)

Add On courses are types of courses that help a particular person to develop their own skills in their chosen field of study. These are mostly independent for each type of fields. Columbia College offered a Add On course i.e., Vocational Computer Training Program (VCTP) in the year 2022. Our students gain knowledge through an Add On course expertly, which will enable them to cope with different future situations.

Available Course:

S. No.

Name of Course

Total Hours

Highlights

01

Vocational Computer Training Programme (VCTP)

30

–          It will be a Lab-Based Programme which will be conducted during the college hours.

–          This full-time programme will be free of cost and the students will get certificate after the completion of the course.

Purpose
The purpose of the Vocational Computer Training Program (VCTP) course is to give basic competencies for application of a computer to everyday tasks.

Objectives
At the end of the course a student is expected to-

  • Describe the organization and operation of a computer, primary and secondary memory, peripheral devices and to give computer specifications.
  • Explain the representation of data and information in computer system.
  • Use standard MS-Word, MS-Excel & MS-PowerPoint software.

Course Faculty
Subject Expert faculty of Columbia College or from Columbia Group of Institutions.

Eligibility
Course is open for all D.El.Ed./B.Ed. Students.

Examination
Multiple Choice Question (MCQ) Based Examination

Syllabus

Subject

Day

Topics to be covered (Day wise)

Fundamental Concepts of Computer System

1

Computer Characteristics & Capabilities

2

Block Diagram & Components, Data Flow in System, H/W vs. S/W

3

Types of S/W, OS and Its Types, I/O Devices, Storage Devices, Memory and Its Types

4

Computer Network: Types and Topologies, WWW, Internet and Its Working

5

Revision and Doubt Clearing Session

Hands on
Microsoft Excel

6

Parts of MS-Excel Menu: Opening, Creating, Saving, and Printing file

7

Cut, Copy, Paste, Format Painter, Bold, Italicise and Underline Text, Changing Font and Font Sizes, Background and Foreground Colours, Cell Alignment

8

Conditional Formatting, Sort and Filter; Find and Select, Workbook Views, Arranging Windows, Freezing and Unfreezing Cells

9

Inserting Pivot Table, Pictures, Clip Arts, Shapes, Smart Art, Hyperlink, Textbox, WordArt, Symbol etc.

10

Macros, Inserting Charts, Themes, Page Setup, Content Arrangement

11

Function and Formula, Math & Trigonometric function, Date and Time Function, Logical Function, Text Function, Formula Building, Formula Auditing

12

Sorting and Filtering Data, Data Validation, What-if Analysis, Grouping and Ungrouping Data, Subtotalling

13

Data Proofing, Protect Sheet and Workbook

14

Revision and Doubt Clearing Session

Hands on
Microsoft Word

15

Parts of MS-Word Menu, Opening, Creating, Saving, and Printing File

16

Cut, Copy, Paste, Format Painter, Bold, Italicise and Underline Text, Changing Font and Font Sizes, Paragraph Formatting, Finding and Replacing Text

17

Inserting: Pages, Tables, Pictures, Clip Arts, Shapes, SmartArt, Charts

18

Inserting: Links, Header and Footer, Text, Symbols

19

Page Setup, Page Background, Paragraph Setting

20

Mail Merging

21

Spelling Checking, Protecting Document, Document Views, Macros, Zooming, Window Handling

22

Revision and Doubt Clearing Session

Hands on
Microsoft PowerPoint

23

Meaning and Features of a Good Presentation,

24

Parts of MS-PowerPoint Menu, Explanation of Office Button

25

Preparing Power Point Presentation, Applying Themes

26

Inserting Pictures, ClipArt’s, Movie, Sound

27

Custom Animation

28

Slide Transition, Slide Show

 

29

Revision and Doubt Clearing Session

Making Presentation

30

Making Presentation on any topic