ITI Computer Operator and Programming Assistant Syllabus

• Introduction to Computers
• Safe working practices  Scope of the COPA trade.
• Safety rules and safety signs.
• Types and working of fire extinguishers. Introduction to Computer Components
• Introduction to computer system
• Concepts of Hardware and Software.
• Function of motherboard components and various processors.
• Various Input/ Output devices in use and their features Introduction Windows Operating System
• Introduction to operating System  Main features of Windows OS  Concept of various shortcut commands.
• Introduction to the booting process
• Introduction to various types of memories and their features.
• Basic Hardware and software issues and their solutions.
• Usage of Application software and Antivirus.
• Introduction to DOS Command Line Interface & Linux Operating Systems
• Introduction to basic DOS Internal and External Commands.
• Introduction to Open Source Software  Introduction to Linux Operating System features, structure, files, and processes  Basic Linux commands.

• Using Word Processing Software
• Introduction to the various applications in MS Office.
• Introduction to Word features, Office button, toolbars.  Creating, saving formatting, and printing documents using Word.
• Working with objects, macro, mail merge, templates, and other tools in Word.

• Spread Sheet Application
• Introduction to Excel features and Data Types.
• Cell referencing and linking Sheets.
• Introduction to various functions in all categories of Excel.
• Concepts of sorting, filtering, and validating data.
• Analyzing data using charts, data tables, pivot tables, goal seek, and scenarios.

• Powerpoint Presentations
• Image editing, Presentations  Introduction to Open Office.
• Introduction to the properties and editing of images.
• Introduction to different formats of images and their uses.
• Introduction to PowerPoint and its advantages.  Creating Slide Shows.
• Fine-tuning the presentation and good presentation technique.

• Database Concepts
• Concept of DBMS, RDBMS.
• Data Models, Concept of DBA, Database Users.
• Database Schema.
• Designing Database using Normalization Rules.
• Various data types Data integrity, DDL DML, and DCL statements.
• Enforcing Primary key and foreign keyAdding Indices.
• Queries
• Concepts of Transactions ACID Property of Transaction Constraints.
• Joins and Functions
• Joining of tables
• Sub Queries
• Functions used in queries like sum, average, max, min, count, etc.

• Communicating in a Connected World
• Local Networks,  Communicating on a Local Network, Principles of Communications,  How do Ethernet Networks Work?,  How are Networks Built?
• Routing Across Networks Explain how end-user devices and local networks interact with the global Internet.
• Communicating in a Connected World Explain the concept of network communication.
• Local Networks Explain the roles of devices in a network.
• What Does a Home Network Look Like?  How Does Wi-Fi Work?
• Introduction to LAN Devices, Internetworking Devices, Internet Concepts
• Introduction to www, Concept of Internet, Web Browsers, internet servers and search engines.
• Concepts of Domain naming Systems and E-mail communication.
• Introduction to video chatting tools and Social Networking concepts.

• Web Design Concepts Concepts of Static and Dynamic Web Pages.
• Introduction to HTML and various tags in HTML.
• Concepts of different controls used in Web Pages.
• Concepts of CSS and applying CSS to HTML.
• Introduction to open source CMS viz, Joomla, WordPress, etc. and Web authoring tools viz. Kompozer, WordPress, Front Page, etc.

• Introduction to JavaScript
• Introduction to Programming and Scripting Languages.
• Introduction to JavaScript and its application for the web.
• Introduction to Web Servers and their features.
• JavaScript Basics – Data types, Variables, Constants, and Conversion between data types.
• Arithmetic, Comparison, Logical Operators in JavaScript.
• Operator precedence.
• Programme Control Statements and Loops in JavaScript.
• Arrays in JavaScript – concepts, types, and usage.
• The String data type in JavaScript.
• Introduction to String, Math, and Date.
• Introduction to Functions in JavaScript.
• Built in JavaScript functions overview.
• Concepts of Pop-Up boxes in JavaScript.
• Introduction to the Document Object Model.
• Concepts of using Animation and multimedia files in Java Script.

• Advanced Excel Concepts - Theory - MS excel revision (row, columns, basic formatting, insert menu, Print setup, etc. ) and Look up introduction and functions
• Types of references and cell naming  Excel Linkage Custom Format and Excel Protection Tips and tricks  Pivot table and Pivot chart Conditional formatting  Advanced Graphs  Power Queries.

• E-Commerce
• Introduction to E-Commerce and Advantages.
• Building a business on the net.
• Payment and Order Processing, Authorization, Chargeback, and other payment methods.
• Security issues and payment gateways.

• Cyber Security
• Overview of Information Security, SSL, HTTPS, Security threats, information Security vulnerability, and Risk management.
• Introduction to Directory Services, Access Control, Security, Privacy Protection, Audit and Security.
• Introduction to IT Act and penalties for cybercrimes.

• Introduction to Cloud Computing
• Benefits of cloud services, different categories.
• Resources available in the cloud.
• Explain the Application Development Life Cycle.
• Identify Phases of the Application Development Life Cycle.
• Describe Roles in each of the phases of the Application Development Life Cycle.

1.

Professional Skill (Trade Practical)

840

2.

Professional Knowledge (Trade Theory)

240

3.

Employability Skills

120

Total

1200