iti 10 April 2025

ITI Office Assistant cum Computer Operator Trade Syllabus

The ITI "Office Assistant cum Computer Operator" trade is a one-year vocational training program under the Craftsman Training Scheme (CTS), governed by the National Council for Vocational Training (NCVT). This course equips trainees with skills in office management, computer operations, data entry, and clerical duties, preparing them for roles such as office assistants, computer operators, or administrative support staff in various industries. The syllabus integrates theoretical knowledge, practical computer skills, and employability training to meet the demands of modern office environments.

Course Overview

Duration: 1 year (2 semesters, each 6 months)
NSQF Level: Level 4
Eligibility: Minimum 10th grade pass (or equivalent)
Objective: To train individuals in performing office tasks efficiently using computers, managing records, and providing administrative support with a focus on productivity and accuracy.

Detailed Syllabus Breakdown

1. Trade Theory (Theoretical Knowledge)

Covers foundational concepts in office administration and computer operations.

Semester 1
- Introduction to Office Management
  - Role and responsibilities of an office assistant and computer operator.
  - Office environment: structure, functions, and etiquette.
  - Basics of record keeping and filing systems.
- Computer Fundamentals
  - Introduction to computers: hardware components (CPU, monitor, keyboard) and software types.
  - Operating Systems: Windows basics, file management, desktop customization.
  - Computer maintenance: basic troubleshooting, antivirus usage.
- Office Productivity Tools
  - Microsoft Word: document creation, formatting, tables, mail merge.
  - Microsoft Excel: spreadsheets, formulas, charts, data sorting.
  - Microsoft PowerPoint: slide creation, animations, presentations.
- Typing Skills
  - Typing techniques: touch typing, finger placement, speed improvement.
  - Keyboard shortcuts and hotkeys for efficiency.
  - Typing in English and regional languages (e.g., Hindi).
- Internet and Communication
  - Internet basics: browsing, search engines, downloading files.
  - Email management: composing, sending, and organizing emails.
  - Online collaboration tools: Google Drive, cloud storage basics.
Semester 2
- Advanced Office Applications
  - Microsoft Access: creating databases, tables, queries, and forms.
  - Advanced Excel: pivot tables, VLOOKUP, macros.
  - Desktop publishing basics: tools like MS Publisher or Adobe PageMaker.
- Office Procedures
  - Office correspondence: drafting letters, memos, notices.
  - Handling office equipment: printers, scanners, photocopiers.
  - Time management and task prioritization in an office setting.
- Accounting Basics
  - Introduction to computerized accounting (e.g., Tally): ledger creation, voucher entry.
  - Inventory management and GST concepts in accounting software.
  - Generating basic financial reports (balance sheet, profit/loss).
- Data Management
  - Data entry techniques: accuracy, speed, formatting.
  - Data backup and security: protecting office records.
  - Basics of database management systems (DBMS).
- Emerging Trends
  - Overview of office automation tools and software.
  - Introduction to cybersecurity: password management, phishing awareness.

2. Trade Practical (Hands-On Skills)

Focuses on practical office and computer operation skills.

Semester 1
- Computer Operations
  - Booting and shutting down a computer system.
  - File and folder management in Windows.
  - Installing and uninstalling software applications.
- Office Software Practice
  - Creating formatted documents in MS Word (e.g., letters, reports).
  - Preparing spreadsheets in MS Excel with formulas and charts.
  - Designing presentations in MS PowerPoint with animations.
- Typing Practice
  - Typing exercises to improve speed and accuracy (English and regional languages).
  - Using typing software for practice and evaluation.
  - Practicing keyboard shortcuts for efficiency.
- Internet Usage
  - Browsing websites, downloading files, and managing bookmarks.
  - Sending and receiving emails with attachments.
  - Using cloud storage for file sharing and backup.
Semester 2
- Advanced Software Applications
  - Creating simple databases in MS Access (tables, queries, forms).
  - Automating tasks in Excel using macros and advanced functions.
  - Designing layouts in desktop publishing software.
- Office Tasks
  - Drafting and formatting office correspondence (letters, memos).
  - Operating office equipment: scanning, printing, copying documents.
  - Organizing and maintaining physical and digital filing systems.
- Accounting Software
  - Setting up a company in Tally and entering transactions.
  - Generating reports like profit/loss statements and balance sheets.
  - Managing inventory and GST entries in Tally.
- Project Work
  - Preparing a complete office document set (e.g., report, spreadsheet, presentation).
  - Simulating office tasks: data entry, record management, email correspondence.

3. Workshop Calculation and Science

Provides mathematical and scientific support for office tasks.

Semester 1
- Basic arithmetic: addition, subtraction, multiplication, division for calculations.
- Percentages and averages: for data analysis in Excel.
- Units of data storage: bits, bytes, KB, MB, GB.
Semester 2
- Simple calculations for accounting: profit, loss, interest.
- Data organization: sorting, filtering, and summarizing data.
- Basics of ergonomics: posture and setup for computer work.

4. Engineering Drawing

Focuses on basic diagramming relevant to office tasks.

Semester 1: Drawing flowcharts for office processes (e.g., filing system).
Semester 2: Creating simple layouts for office forms or database structures.