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 | 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 | 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 | 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 |