Government Technical Examination (GTE)

Certificate Course in
Computer on Office Automation

Tamil Nadu Department of Technical Education, Chennai — 600 025
Revised Syllabus w.e.f. June 2025 • CBE Mode
7 Theory Units 38 Practical Exercises English & Tamil Typing CBE Exam Pattern
Course Completion 0 of 15 chapters

Theory Exam — 50 Marks (1 hr)

  • MCQ × 10 questions = 10 marks
  • Logic MCQ × 10 questions = 20 marks
  • Match the following × 10 = 10 marks
  • True or False × 10 = 10 marks
  • Pass mark: 20 out of 50

Practical Exam — 50 Marks (1 hr)

  • MS Office execution task = 50%
  • e-Office Draft submission = 50%
  • Pass mark: 20 out of 50
  • Typing: 30 wpm = Junior Grade
  • Typing: 45 wpm = Senior Grade
Theory Syllabus — 7 Units
U1
Unit 1 — Theory
Basics of Computer
Introduction, History, Generations (1st–5th), Hardware and Software, Memory, CPU, I/O Devices, Ports, Applications
Computer Types RAM & ROM CPU I/O Devices
›
U2
Unit 2 — Theory
Operating Systems: MS-Windows and Linux
OS Types, Windows GUI, Desktop Management, Linux Commands and Utilities (22 commands), Keyboard Shortcuts
Windows GUI Linux Commands File Systems
›
U3
Unit 3 — Theory
Word Processing
MS-Word and OpenOffice Writer, Documents, Formatting, Tables, Mail Merge, Styles, Templates, TOC
MS-Word Formatting Mail Merge Tables
›
U4
Unit 4 — Theory
Calculations and Data Sheets
MS-Excel and OpenOffice Calc, Formulas, Functions (SUM, IF, VLOOKUP), Charts, Pivot Tables, Consolidation
MS-Excel Formulas Charts Pivot Tables
›
U5
Unit 5 — Theory
Presentations
MS-PowerPoint and OpenOffice Impress, Slides, Animations, Transitions, Slide Show Controls, Handouts
PowerPoint Animations Transitions Handouts
›
U6
Unit 6 — Theory
e-Office Applications
e-Office System (NIC/NeGP), File Management, Receipts, Notes (Green/Yellow), Draft, Digital Signature, Dispatch
e-Office Receipts Green Note Draft
›
U7
Unit 7 — Theory
Digital Communication and Applications
Networks (LAN/MAN/WAN), Internet, Web Browsers, Email, Google Apps, Mobile Devices, Scanning
Networks Internet Email Google Apps
›
Practical Exercises — 38 Exercises in 8 Chapters
Ex
1–7
Chapter 8 — OS Practicals
Operating System Exercises
Programs and Switching, Taskbar, Recycle Bin, Folders, File Properties, Mouse Operations, Audio, Printer, Screenshots
7 Exercises Windows OS File Management
›
Ex
8–15
Chapter 9 — Word Processing Practicals
MS-Word Practical Exercises
Official Letters, Newsletter, Styles and Templates, Tables and Calendar, Lists, Mail Merge, Find and Replace, Advertisement, Resume, AGM Circular
8 Exercises Official Letters Mail Merge Resume
›
Ex
16–20
Chapter 10 — Spreadsheet Practicals
MS-Excel Practical Exercises
Sales Worksheet, Nested IF (Distinction/I Class/II Class/Fail), Sheet Operations, Charts, Consolidation, Sort, Filter, Pivot Tables
5 Exercises Nested IF Charts Pivot Table
›
Ex
21–24
Chapter 11 — Presentation Practicals
MS-PowerPoint Practical Exercises
New Presentation (AutoContent, Design Template, Blank), Slide Transitions (Manual and Automatic), Custom Animations, Handouts (3 Slides per Page)
4 Exercises Transitions Animations Handouts
›
Ex
25–31
Chapter 12 — e-Office Practicals
e-Office Application Exercises
Scan Receipt, Create File with Hashtags, Green Note with Reference, Yellow Note, Create Draft, Sign and Approve, Dispatch and Close File
7 Exercises Green Note Draft Digital Sign
›
Ex
32–38
Chapter 13 — Digital Communication Practicals
Internet and Google Apps Exercises
Web Search and Download, Gmail Account and Operations, Google Forms, Google Docs, Google Sheets with IF, Google Slides, Scan and Edit Photo
7 Exercises Gmail Google Forms Google Sheets
›
Eng
Type
Chapter 14 — Typewriting
English Typewriting Practice
QWERTY keyboard layout, Home Row, Top Row, Bottom Row, Number Row, Speed Building, 30 wpm Junior Grade target
8 Lessons QWERTY 30 wpm Junior Grade
›
Tamil
Type
Chapter 15 — Typewriting
Tamil Typewriting Practice
Tamil99 keyboard layout, Vowels, Consonants, Compound Characters, Marutham font, Speed Building Lessons
9 Lessons Tamil99 Marutham Font 30 wpm
›
COA Course Material — Prepared for TNDTE Certificate Course in Computer on Office Automation • Revised Syllabus w.e.f. June 2025 • CBE Mode • Font: Arial 12pt (English), Marutham 12pt (Tamil)
Quick Start:
Start Chapter 1 → Practicals → Typing →