COPA SYLLABUS (COMPUTER OPERATOR AND PROGRAMMING ASSISTANT)

 COPA SYLLABUS (COMPUTER OPERATOR AND PROGRAMMING ASSISTANT)

         WEEK NO.                                                                TRADE THEORY

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

       2.    Introduction Windows Operating System

              Introduction to operating system

             Main features of windows OS

             Concept of various shortcut commands.

       3.    Computer Basics and software installation.

              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.

     4-5.  Introduction to DOS Command Line

              Interface and 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.

       6-8    Word processing Software

             Introduction to the various applications in MS Office.

             Introduction to Word features, Office button, toolbars.

             Creating, saving and formatting and printing documents using Word.

             Working with objects, macro, mail merge, templates and other tools in Word.

       9-11    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.

       12-13   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 Power Point and its advantages.

                Creating slide Shows.

                Fine tuning the presentation and good presentation technique.

14-15 Database Management systems

            Concepts of data and database

            Overview of popular databases, RDBMS,OODB and constraints in a table.

            rules for designing good tables. Integrity rules and constraints in a table.

            Relationships in tables.

            Introduction to various types of Queries and their uses.

            Designing Access Reports and Forms.

            Introduction to macros, designer objects controls their properties and Behaviour.

  16- 17 Networking Concepts 

            Introduction to Computer Networks, Necessity and Advantages,

            Client Server and peer to peer networking concepts. 

            concept of proxy Server and proxy firewall server.

            Concept of DHCP server.

            Network topologies. Introduction to LAN, WAN and MAN.

            Network components,viz. Modem, Hub, Switch, Router, Bridge, Gateway etc.

            Network Cables, Wireless networks and Bluetooth technology.

            Concept of ISO-OSI  7 Layer Modal.

            Overview of various Network protocols viz TCP/IP FTP, Telnet etc.

            Concept of Logical and physical Addresses, subnetting and classes of networks.

  18.     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, Word press etc. and Web authoring tools viz Kompozer, Front Page etc.

            Concept of good web page designing techniques.

   22-28  Introduction to JavaScript

            Introduction to Programming and  Scripting Languages.

            Introduction to JavaScript and its application for the web.

            Introduction to Web Services and their features.

            JavaScript Basics - Data types,Variables, Constants and Conversion between data types.

            Arithmetic, Comparison, Logical Operators in JavaScript Operator precedence.

            Program Control Statements and loops in JavaScript.

            Arrays in JavaScript- concepts types and usage.

            The String data type in JavaScript. Introduction ti 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.

29-36   Introduction to VBA, Features and Applications

            Introduction to VBA features and applications.

            Properties events and methods associated with the button, Check Box, Label, Combo Box,Group Box, Option Button, List Box ,Scroll Bar, and Spin button Control.

            VBA data types Variables and Constants.

            Operators in VBA and operator precedence.

            Mathematical Expressions in VBA.

            Introduction to Arrays in VBA.

            Introduction to Strings in VBA.

            Conditional processing in VBA, using the If,Else-if,Select Case Statements.

            Introduction to Loops in VBA.

            VBA message Boxes and input boxes.

            Introduction to Creating functions and Procedures in VBA.

            Using the built in functions.

            Introduction to Object Oriented Programming Concepts.Concepts of Classes, Objects, Properties and Methods.

            The user forms and control in Excel VBA.

            introduction to Debugging Techniques.

37-40   Using Accounting Software

            Basics of Accounting Golden Rules of Accounting.Voucher entry, Ledger Posting,Final Accounts Preparation.

            Cash books,ratio Analysis. Depreciation,Stock Management.

             Analysis to VAT, Cash Flow, Fund Flow Accounting. 

            Introduction to Tally, Features and Advantages.

            Implementing Accounts in Tally.

            Double entry systems of book keeping.

            Budgeting System, Scenario Management and Variance Analysis.

            Costing Systems,Concepts of Ratios, Analysis of financial Statements.

            Inventory Basics, POS Invoicing, TDS, TCS,FBT,VAT and Service Tax.

            Tally Interface in Different Languages.

          E-Commerce Concepts.

           Introduction to E-Commerce and advantages.

            Building business on the net.

            Payment and Order Processing,Authorization, Charge back 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 cyber crimes.