Page 1 :
GOVERNMENT OF INDIA, MINISTRY OF SKILL DEVELOPMENT & ENTREPRENEURSHIP, DIRECTORATE GENERAL OF TRAINING, , COMPETENCY BASED CURRICULUM, , COMPUTER OPERATOR AND PROGRAMMING, ASSISTANT (COPA), (Duration: One Year), , CRAFTSMEN TRAINING SCHEME (CTS), NSQF LEVEL- 4, , SECTOR – IT & ITeS
Page 2 :
COMPUTER OPERATOR, AND PROGRAMMING ASSISTANT, (Non-Engineering Trade), , (Revised in 2019), Version: 1.2, , CRAFTSMEN TRAINING SCHEME (CTS), NSQF LEVEL - 4, , Developed By, Ministry of Skill Development and Entrepreneurship, Directorate General of Training, , CENTRAL STAFF TRAINING AND RESEARCH INSTITUTE, EN-81, Sector-V, Salt Lake City,, Kolkata – 700 091, www.cstaricalcutta.gov.in
Page 3 :
CONTENTS, S No., , Topics, , Page No., , 1., , Course Information, , 1, , 2., , Training System, , 2, , 3., , Job Role, , 6, , 4., , General Information, , 7, , 5., , Learning Outcome, , 9, , 6., , Assessment Criteria, , 10, , 7., , Trade Syllabus, , 13, , Annexure I (List of Trade Tools & Equipment), , 28, , Annexure II (List of Trade experts), , 31
Page 4 :
Computer Operator and Programming Assistant, , 1. COURSE INFORMATION, During the one-year duration of Computer Operator and Programming Assistant trade a, candidate is trained on professional skill, professional knowledge and Employability skill related, to job role. In addition to this a candidate is entrusted to undertake project work and, extracurricular activities to build up confidence. The Broad components covered professional, skill, subjects are as below:The trainee learns about safety and environment, use of fire extinguishers. He learns, about trade tools, identifies computer peripherals, internal components, basic DOS commands,, Windows and Linux interface and its related software installation process. Trainees will work with, MS Office package to create word document, practice with excel sheet and get idea to create a, good power point presentation, maintain database with MS Access. They will set up and, configure a network system of an organization. They will use internet to search information using, browser along with official/ social communication process. Trainees will create basic static, webpage using HTML. Trainees can go on industrial visit or projects specified in the syllabus. The, trainee learns scripting language i.e. JavaScript and will develop dynamic webpage and hosting, technique in a registered domain. They will use VBA to create & edit various types of macros in, MS Excel and to develop user form using VBA. They can maintain accounts of an organization, using accounting software Tally. Trainees will learn E-commerce system and will be able to, browse, select and transact using different E-commerce websites. They will identify different type, of cyber crimes now days and will be able to secure information from Internet by using cyber, security concept. At the end of the training trainees can go on industrial visit or projects specified, in the syllabus., , 1
Page 5 :
Computer Operator and Programming Assistant, , 2. TRAINING SYSTEM, 2.1 GENERAL, The Directorate General of Training (DGT) under Ministry of Skill Development &, Entrepreneurship offers a range of vocational training courses catering to the need of different, sectors of economy/ Labour market. The vocational training programmes are delivered under the, aegis of Directorate General of Training (DGT). Craftsman Training Scheme (CTS) with variants, and Apprenticeship Training Scheme (ATS) are two pioneer schemes of DGT for strengthening, vocational training., “Computer Operator and Programming Assistant” trade under CTS is one of the most, popular courses delivered nationwide through network of ITIs. The course is of one year duration., It mainly consists of Domain area and Core area. The Domain area (Trade Theory & Practical), imparts professional skills and knowledge, while Core area (Employability Skills) imparts requisite, core skill, knowledge and life skills. After passing out the training program, the trainee is awarded, National Trade Certificate (NTC) by DGT which is recognized worldwide., , Trainee needs to demonstrate broadly that they are able to:, •, •, •, •, •, , Read and interpret technical parameters/ documentation, plan and organize work, processes, identify necessary materials and tools;, Perform task with due consideration to safety rules, accident prevention regulations and, environmental protection stipulations;, Apply professional knowledge & employability skills while performing the job and repair &, maintenance work., Check the job/ assembly as per drawing for functioning identify and rectify errors in job/, assembly., Document the technical parameter related to the task undertaken., , 2.2 PROGRESSION PATHWAYS, •, •, •, •, •, , Can join industry as Craftsman and will progress further as Senior Craftsman, Supervisor, and can rise up to the level of Manager., Can become Entrepreneur in the related field., Can join Apprenticeship programme in different types of industries leading to National, Apprenticeship certificate (NAC)., Can join Crafts Instructor Training Scheme (CITS) in the trade for becoming instructor in, ITIs., Can join Advanced Diploma (Vocational) courses under DGT as applicable., 2
Page 6 :
Computer Operator and Programming Assistant, , 2.3 COURSE STRUCTURE, Table below depicts the distribution of training hours across various course elements, during a period of one year: S No., , Notional Training, Hours, 1200, , Course Element, , 1, , Professional Skill (Trade Practical), , 2, , Professional Knowledge (Trade Theory), , 240, , 3, , Employability Skills, , 160, , Total, , 1600, , 2.4 ASSESSMENT & CERTIFICATION, The trainee will be tested for his skill, knowledge and attitude during the period of course, through formative assessment and at the end of the training programme through summative, assessment as notified by the DGT from time to time., a) The Continuous Assessment (Internal) during the period of training will be done by Formative, assessment method by testing for assessment criteria listed against learning outcomes. The, training institute have to maintain individual trainee portfolio as detailed in assessment guideline., The marks of internal assessment will be as per the formative assessment template provided on, www.bharatskills.gov.in, b) The final assessment will be in the form of summative assessment. The All India Trade Test for, awarding NTC will be conducted by Controller of examinations, DGT as per the guideline. The, pattern and marking structure is being notified by DGT from time to time. The learning outcome, and assessment criteria will be basis for setting question papers for final assessment. The, examiner during final examination will also check individual trainee’s profile as detailed in, assessment guideline before giving marks for practical examination., , 2.4.1 PASS REGULATION, For the purposes of determining the overall result, weightage of 100% is applied for six, months and one year duration courses and 50% weightage is applied to each examination for two, years courses. The minimum pass percent for Trade Practical and Formative assessment is 60% &, for all other subjects is 33%. There will be no Grace marks., , 3
Page 7 :
Computer Operator and Programming Assistant, , 2.4.2 ASSESSMENT GUIDELINE, Appropriate arrangements should be made to ensure that there will be no artificial, barriers to assessment. The nature of special needs should be taken into account while, undertaking assessment. Due consideration should be given while assessing for team work,, avoidance/reduction of scrap/wastage and disposal of scarp/wastage as per procedure,, behavioral attitude, sensitivity to environment and regularity in training. The sensitivity towards, OSHE and self-learning attitude are to be considered while assessing competency., Assessment will be evidence based comprising the following:, • Job carried out in labs/workshop, • Record book/ daily diary, • Answer sheet of assessment, • Viva-voce, • Progress chart, • Attendance and punctuality, • Assignment, • Project work, Evidences and records of internal (Formative) assessments are to be preserved until, forthcoming year examination for audit and verification by examination body. The following, marking pattern to be adopted while assessing:, Performance Level, , Evidence, , (a) Weightage in the range of 60 -75% to be allotted during assessment, • Demonstration of good skills and accuracy in, the field of work/ assignments., • A fairly good level of neatness and, consistency to accomplish job activities., • Occasional support in completing the task/, job., , For performance in this grade, the candidate, with occasional guidance and showing due, regard for safety procedures and practices, has, produced work which demonstrates attainment, of an acceptable standard of craftsmanship., , (b)Weightage in the range of above75% - 90% to be allotted during assessment, • Good skill levels and accuracy in the field of, work/ assignments., • A good level of neatness and consistency to, accomplish job activities., • Little support in completing the task/ job., , For this grade, the candidate, with little guidance, and showing due regard for safety procedures, and practices, has produced work which, demonstrates attainment of a reasonable, standard of craftsmanship., , 4
Page 8 :
Computer Operator and Programming Assistant, (c) Weightage in the range of above 90% to be allotted during assessment, • High skill levels and accuracy in the field of, work/ assignments., • A high level of neatness and consistency to, accomplish job activities., • Minimal or no support in completing the, task/ job., , For performance in this grade, the candidate,, with minimal or no support in organization and, execution and with due regard for safety, procedures and practices, has produced work, which demonstrates attainment of a high, standard of craftsmanship., , 5
Page 9 :
Computer Operator and Programming Assistant, , 3. JOB ROLE, Computer Operator; operates computer and peripheral equipment to process business,, scientific, engineering, or other data, according to operating instructions. Enters commands,, using keyboard of computer terminal, and presses buttons and flips switches on computer and, peripheral equipment, such as tape drive, printer, data communications equipment, and plotter,, to integrate and operate equipment, following operating instructions and schedule. Loads, peripheral equipment with selected materials, such as tapes and printer paper for operating runs,, or oversees loading of peripheral equipment by Peripheral Equipment Operators. Enters, commands to clear computer system and start operation, using keyboard of computer terminal., Observes peripheral equipment and error messages displayed on monitor of terminal to detect, faulty output or machine stoppage. Enters commands to correct error or stoppage and resume, operations. Notifies supervisor of errors or equipment stoppage. Clears equipment at end of, operating run and reviews schedule to determine next assignment. Records problems which, occurred, such as down time, and actions taken. May answer telephone calls to assist computer, users encountering problem. May assist workers in classifying, cataloguing, and maintaining, tapes., Programming Assistant; installs, maintains and updates computer programs by making minor, changes and adjustments to them under the guidance of computing professionals. Maintains and, updates documents of computer programs and installations. Applies knowledge of principles and, practices in the area of programming and computing in order to identify and solve problems, arising in the course of their work. They may receive guidance from managers or professionals., May supervise other workers also., Reference NCO-2015: i), ii), , 4131.0600 – Computer Operator, 3514.0300 – Programming Assistant, , 6
Page 10 :
Computer Operator and Programming Assistant, , 4. GENERAL INFORMATION, Name of the Trade, , COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, , Trade Code, , DGT/1003, , NCO - 2015, , 4131.0600, 3514.0300, , NSQF Level, , Level-4, , Duration of Craftsmen, Training, , One Year (1600 Hours), , Entry Qualification, , Passed 10th class examination, , Minimum Age, , 14 years as on first day of academic session., , Eligibility for PwD, , LD, CP, LC, DW, AA, LV, HH, AUTISM, SLD, , Unit Strength (No. Of, Student), , 24 (There is no separate provision of supernumerary seats), , Space Norms, , 70 Sq. m, , Power Norms, 3.45 KW, Instructors Qualification for, 1. Computer Operator, And Programming, Assistant Trade, , B.Voc/Degree in Computer Science/ IT from AITCE/ UGC Recognized, University with one year expreience in the relevant field., OR, Post Graduate in Computer Science /Computer Application / IT from, UGC Recognized University or NIELIT B Level with one year expreience, in the relevant field., OR, Bachelor in Computer Science / Computer Application / IT OR PGDCA, from UGC recognized University or NIELIT A Level with two year, expreience in the relevant field., OR, 03 years Diploma in Computer Science / IT from recognized Board/, Institute or relevant Advanced Diploma (Vocational) from DGT with, two year expreience in the relevant field., OR, NTC/NAC in COPA trade with three year expreience in the relevant, field., Essential Qualification:, Relevant National Craft Instructor Certificate (NCIC) in any of the, variants under DGT., Note: - Out of two Instructors required for the unit of 2(1+1), one, 7
Page 11 :
Computer Operator and Programming Assistant, , 2. Employability Skill, , must have Degree/Diploma and other must have NTC/NAC, qualifications. However both of them must possess NCIC in any of its, variants., MBA/ BBA / Any Graduate/ Diploma in any discipline with Two years’, experience with short term ToT Course in Employability Skills from, DGT institutes., (Must have studied English/ Communication Skills and Basic Computer, at 12th / Diploma level and above), OR, Existing Social Studies Instructors in ITIs with short term ToT Course in, Employability Skills from DGT institutes., , 3. Minimum Age for, Instructor, List of Tools &, Equipment, , 21 Years, As per Annexure-I, , Distribution of training on Hourly basis: (Indicative only), Total Hrs /week, , Trade Practical, , Trade Theory, , Employability Skills, , 40 Hours, , 30 Hours, , 6 Hours, , 4 Hours, , 8
Page 12 :
Computer Operator and Programming Assistant, , 5. LEARNING OUTCOME, Learning outcomes are a reflection of total competencies of a trainee and assessment will, be carried out as per the assessment criteria., , 5.1 LEARNING OUTCOMES (TRADE SPECIFIC), 1., , Install and setup operating system and related software in a computer following safety, precautions., 2. Create, format and edit document using word processing application software., 3. Create, format, edit and develop a workbook by using spreadsheet application software., 4. Create and customize slides for presentation., 5. Create and manage database file using MS Access., 6. Install, setup/configure, troubleshoot and secure computer network including Internet., 7. Develop static web pages using HTML., 8. Develop web pages using Java Script., 9. Develop simple spread sheets by embedding VBA., 10. Maintain accounts using accounting software., 11. Browse, select and transact using E commerce websites., 12. Secure information from Internet by using cyber security concept., , 9
Page 13 :
Computer Operator and Programming Assistant, , 6. ASSESSMENT CRITERIA, LEARNING OUTCOMES, 1. Install, and, setup, operating system and, related software in a, computer, following, safety precautions., , ASSESSMENT CRITERIA, Assemble computer and configuring the CMOS setup., Install and configure Windows OS and application software., Install the printer and other peripheral devices., Burn CD/DVD., Troubleshoot the PC., Execute DOS and LINUX commands., Customize Windows and LINUX OS., , 2. Create, format and edit Identify Word tools in the Ribbon., document using word Create a resume using various tools., processing application Design and print Magazine covers using various tools., software., Demonstrate the use of shortcut keys autocorrect and macros., Perform Mail merge in MS Word., Typing practice using open source typing tutor tools., 3. Create, format, edit and Create tables, chart and print using various functions and formulas,, develop a workbook by apply Conditional formatting., using, spreadsheet Create a table and Perform Sorting; filtering, Subtotal, validation and, application software., goal seek on a table., Prepare a pivot table and chart on any existing table., 4. Create and customize Edit images with Open Office Applications., slides for presentation., Create Slides and run slideshows., Format objects, add Audio and Video., Use Open Office for creating presentations., 5. Create and manage Create simple application on Relational Database in MS Access using, database file by using data validation, filters, sorting, forms, query, report and macro., MS Access., Import, Export, Link, Backup and Retrieve database in MS Access., 6. Install, setup/configure, Identify different cables and connectors used in networking., troubleshoot and secure Assign Computer Name and workgroup to a computer, computer, network Prepare UTP cross cable & connect computers, including Internet., Share a printer with Network, Share Internet using Windows Tools, 10
Page 14 :
Computer Operator and Programming Assistant, Check Network connectivity, Configure HUB & Switch, Configure DHCP and firewall, Setup Video conferencing, Secure Network with various tools, Practice Web Browsing and create E Mail ID and sending receiving, mails, Perform text chat and video chat using social network sites, Configure Outlook Express, Use Skype and Google+ or any other video conferencing site., 7. Develop static web Create simple static Web Pages using HTML tags., pages using HTML., Create simple static WebPages using internal styles (CSS) and, external style., Design static web pages using Kompozer., 8. Develop web pages Design a dynamic Web Page in JavaScript using various operators., using Java Script., Design a dynamic Web Page in JavaScript using various control, statements and looping structures., Design a dynamic Web Page in JavaScript using strings and functions., Design a dynamic Web Page in JavaScript using Arrays and objects., Design a dynamic Web Page in JavaScript using Web Forms and, images., 9. Develop simple spread Create various types of macros in MS Excel., sheets by embedding Develop and execute a program in VBA using various operators and, VBA., data types., Develop and execute a program in VBA using control statements and, looping structures., Develop and execute a program in VBA using strings and functions., Develop and execute a program in VBA using Arrays., Design a VBA User Form and develop program using various control, buttons and boxes., 10. Maintain accounts using Create a company in Tally., accounting software., Create opening ledgers using an existing Balance Sheet., Post voucher in tally in different modes., Performing Cost Centre & Cost category., Manufacture and transfer materials in Tally., 11
Page 15 :
Computer Operator and Programming Assistant, Show P/L A/c, Balance Sheet and other reports., Apply Budget., Post VAT & Service Tax related entry in Tally, 11. Browse, select and Place order for products from E commerce websites for purchase., transact, using, E- Upload a product in E Commerce site for sale., commerce websites., Identify security issues in E- commerce and payment operations., 12. Secure information from Provide firewall security for Internet connection and Network, Internet by using cyber System., security concept., Make backup copies of important file, data and information., Secure your Wi-Fi networks using wireless security features., , 12
Page 16 :
Computer Operator and Programming Assistant, , 7. TRADE SYLLABUS, SYLLABUS FOR COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, DURATION: ONE YEAR, Duration, , Reference Learning, Outcome, , Professional Install and setup, Skill 150 Hrs; operating system, and related, Professional software in a, Knowledge, computer following, 30 Hrs, safety precautions., , Professional Skills, (Trade Practical), With Indicative Hours, Safe working practices, 1. Visit COPA Lab. of the, institutes and locate the, electrical connections with, computer system setup., (6hrs), 2. Identifying safety symbols, and hazard identification., (4Hrs), 3. Practice safe methods of, fire fighting in case of, electrical fire. (4hrs), 4. Use of fire extinguishers., (4Hrs), Computer components, 5. Identify, computer, peripherals and internal, components, of, a, disassembled, desktop, computer. (6 Hrs), 6. Assemble components of, desktop computer. (6 Hrs), Using Windows Operating, System, 7. Practice, on, Windows, interface and navigating, windows. (7Hrs), 8. Practice on managing files, and folders using removable, drives. (5Hrs), 9. Customize the desktop, 13, , Professional Knowledge, (Trade Theory), 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., (06 hrs), , Introduction, Windows, Operating System, • Introduction to operating, System, • Main, features, of, Windows OS, • Concept, of, various, shortcut commands., (06 hrs)
Page 17 :
Computer Operator and Programming Assistant, settings and manage user, accounts. (5Hrs), 10. View system properties and, control panel details. (5Hrs), 11. Work, with, keyboard, shortcut commands. (5Hrs), 12. Print and scan document, using different commands., (3 Hrs), Computer basics and Software, Installation, 13. View the BIOS settings and, their modifications. (3 Hrs), 14. Install Windows operating, system. (5 Hrs), 15. Format hard disk and create, partition. (3 Hrs), 16. Identify and rectify common, hardware and software, issues, during, OS, installation. (4 Hrs), 17. Install necessary application, software for Windows i.e., Office Package, PDF Reader,, Media Player etc. (5 Hrs), 18. Configure Bluetooth and wifi settings. (3 Hrs), 19. Install Drivers for printer,, scanner, webcam and DVD, etc. (4 Hrs), 20. Burn data, video and audio, files on CD/DVD using, application software. (3 Hrs), DOS Command Line Interface, & Linux Operating Systems, 21. Use basic DOS commands, for directory listing. (10 Hrs), 22. Manage files and folders, using DOS commands. (6, Hrs), 14, , 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., (06 hrs), , Introduction to DOS, Command Line Interface &, Linux Operating Systems, • Introduction to basic DOS, Internal and External, Commands., • Introduction to Open
Page 18 :
Computer Operator and Programming Assistant, , Professional, Skill 90 Hrs;, Professional, Knowledge, 18 Hrs, , Create, format and, edit document, using word, processing, application, software., , 23. Install, Linux, operating, Source Software., system. (6 Hrs), • Introduction to Linux, 24. Install necessary application, Operating, System, software for Linux i.e. Office, features, structure, files, Package,, PDF, Reader,, and processes., Media Player etc. (6 Hrs), • Basic Linux commands., 25. Use Basic Linux commands, (12 hrs), for directory listing, file and, folder, management,, password etc. (10 Hrs), 26. Use the Linux graphical user, interface for file and folder, management, exploring the, system etc. (10 Hrs), 27. Customize desktop settings, and manage user accounts, in Linux. (6 Hrs), 28. View system properties and, manage system setting in, Linux. (6 Hrs), Using, Word, Processing Word Processing Software, Software, • Introduction, to, the, 29. Open MS Word and, various applications in, familiarise with basic word, MS office., components. (3 Hrs), • Introduction to Word, 30. Practice creating, saving, features, Office button,, and renaming of word, toolbars., documents. (3 Hrs), • Creating, saving and, 31. Edit document using basic, formatting and printing, formatting tools. (8 Hrs), documents using Word., 32. Practice, Inserting, and • Working with objects,, formatting tables and other, macro, mail, merge,, objects. (12 Hrs), templates and other, 33. Work with Page layout, tools in Word., settings, and, printing, (18 hrs), documents. (6 Hrs), 34. Use templates, autocorrect, tools, and record and, execute a macro. (6 Hrs), 35. Use Mail merge tool. Use, 15
Page 19 :
Computer Operator and Programming Assistant, , Professional, Skill 90 Hrs;, Professional, Knowledge, 18 Hrs, , Create, format, edit, and develop a, workbook by using, spreadsheet, application, software., , conditional Mail Merge,, External, Data, Source., Practice Letters, Label &, Envelop printing using Mail, Merge. (10 Hrs), 36. Use Table of Context,, Indexing,, Hyperlink,, Bookmark,, Comment,, equation, symbols, citation,, cross-reference, footnote,, translate,, synonyms,, thesaurus,, spell, check, &grammar, compare etc. ( 6, Hrs ), 37. Practice Typing using open, source typing tutor. (24 Hrs), 38. Practice of using shortcut, keys and use Open Office as, word processor. (12 Hrs), Using, Spread, Sheet Spread Sheet Application, Application, • Introduction to Excel, 39. Open MS Excel and, features and Data Types., familiarise, with, basic • Cell referencing and, application components. (4, linking Sheets., Hrs), • Introduction to various, 40. Practice creating, saving, functions in all categories, and formatting excel spread, of Excel., sheets. (9 Hrs), • Concepts of sorting,, 41. Use absolute and relative, filtering and validating, referencing, linking sheets,, data., conditional formatting etc. • Analyzing data using, (9 Hrs), charts, data tables, pivot, 42. Practice Excel functions of, tables, goal seek and, all major categories i.e., scenarios., Financial, Logical, Text, date (18 hrs), & time, Lookup, Math,, Statistical etc. (12 Hrs), 43. Use various data types in, Excel, sorting, filtering and, validating data. (8 Hrs), 16
Page 20 :
Computer Operator and Programming Assistant, , Professional, Skill 60 Hrs;, Professional, Knowledge, 12 Hrs, , Create and, customize slides for, presentation., , 44. Create and format various, static and dynamic charts., (10 Hrs), 45. Practice, Importing, &, exporting excel data. (4 Hrs), 46. Perform data analysis using, “what if” tools and Pivot, Table and record and, execute a macro. (10 Hrs), 47. Modify Excel page setup, and printing and use open, office, as, Spreadsheet, application. (4 Hrs), 48. Execute simple projects, using Excel & Word. (20, Hrs), Image editing and creating Image editing, Presentations, Presentations, • Introduction to Open, 49. Use Windows Paint or, Office., image editing software like • Introduction, to, the, Open Office Draw, GIMP,, properties and editing of, Irfan View or a similar tool., images., (6 Hrs), • Introduction to different, 50. Perform Image editing using, formats of images and, open source applications., their uses., (12 Hrs), • Introduction to Power, 51. Open, power, point, Point and its advantages., presentation and familiarise • Creating Slide Shows., with, basic, application • Fine, tuning, the, components. (6 Hrs), presentation and good, 52. Create Slide shows, Insert, presentation technique., picture and theme. (6 Hrs), (12 hrs), 53. Add new slide, format text,, link with word and excel, documents. (5 Hrs), 54. Practice animating slide, transitions and objects. (4, Hrs), 55. Create slide shows by, inserting audio & video and, 17
Page 21 :
Computer Operator and Programming Assistant, , Professional, Skill 60 Hrs;, , Create and manage, database file by, using MS Access., , Professional, Knowledge, 12 Hrs, , Professional, Skill 90 Hrs;, Professional, , Install, setup/, configure,, troubleshoot and, secure computer, , synchronise, with, presentation. (6 Hrs), 56. Modify slide page setup and, print the slides. (3 Hrs), 57. Create, a, simple, presentation project using, open office. (12 Hrs), Database Management with, MS Access, 58. Create database and design, a simple tables in Access. (6, Hrs), 59. Practice enforcing integrity, constraints and modify, properties of tables and, fields. (6 Hrs), 60. Create relationships and, join tables. (6 Hrs), 61. Create and format Forms. (6, Hrs), 62. Create simple queries with, various, criteria, and, calculations. (12 Hrs), 63. Create Simple update,, append, make table, delete, and crosstab queries. (9, Hrs), 64. Modify form design with, controls,, macros, and, events. (6 Hrs), 65. Import and export data to, and from Access and create, and format various types of, reports. (6 Hrs), 66. Compress and Encrypt, databases. (3 Hrs), Configuring and, using, Network, 67. View Network connections., (3 Hrs), 18, , Database Management, Systems, • Concepts of Data and, Databases., • Overview of popular, databases,, RDBMS,, OODB and NOSQL., • 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., (12 hrs), , Networking Concepts, • Introduction, to, Computer, Networks,, Necessity, and
Page 22 :
Computer Operator and Programming Assistant, Knowledge, 18 Hrs, , network including, Internet., , 68. Connect a computer to a, Advantages., network and share Devices • Client Server and peer to, i.e. Printers, files, folders, Peer, networking, and drives. (6 Hrs), concepts., 69. Work with various Network • Concept of Proxy Server, devices, connectors and, and proxy firewall server., cables. Create straight and • Concept of DHCP Server., cross cable and punch a UTP • Network, topologies., cable in the patch socket, Introduction to LAN,, and test the connectivity. (6, WAN and MAN., Hrs), • Network, components,, 70. Practice IP Addressing and, viz. Modem, Hub, Switch,, Subnet masking for IPV4/, Router, Bridge, Gateway, IPV6 and pinging to test, etc., networks. (6 Hrs), • Network Cables, Wireless, 71. Configure Hub and Switch., networks and Blue Tooth, (6 Hrs), technology., 72. Set up and configure wired • Concept of ISO - OSI 7, and wireless LAN in a, Layer Model., Computer Lab within at • Overview of various, least three computers. Use, Network protocols Viz., patch panel & I/O Box for, TCP/IP, FTP, Telnet etc., wired LAN and installing & • Concept of Logical and, configuring, Internet, Physical, Addresses,, connection in a single PC, Subnetting and Classes of, and in a LAN. (12 Hrs), Networks., 73. Set up a proxy server/ DHCP (12 hrs), Server with firewall. (9 Hrs), 74. Set up video conferencing, using open source software., (6 Hrs), 75. Use various tools (by open, source /free) for network, troubleshooting,, maintenance and security, for both Wired and, Wireless(6 Hrs), Using Internet, Internet Concepts, 76. Browse the Internet for • Introduction to www,, information (use at least 3, Concept of Internet, Web, 19
Page 23 :
Computer Operator and Programming Assistant, , Professional, Skill 90 Hrs;, Professional, Knowledge, 18 Hrs, , popular browsers). (3 Hrs), Browsers,, internet, 77. Create and use e-mail for, servers, and, search, communication, with, engines., attachment, priority setting, • Concepts of Domain, address book. (3 Hrs), naming Systems and E, 78. Communicate with text,, mail communication., video chatting and social • Introduction to video, networking sites. (6 Hrs), chatting tools and Social, 79. Use, online, dictionary,, Networking concepts., translation, software,, (06 hrs), storage space, share files, with e-mail links, download, manager, download &, upload, YouTube, files,, google map & earth etc., Update windows & other, software. (6 Hrs), 80. Configure Outlook, mail, service in mobile phones., Use tools like Skype,, Google+ etc. (6 Hrs), 81. Browser, setting, for, Bookmark,, cookies,, favourites and pop ups,, default website, trusted, site, restricted site, content,, history and advanced setup., (6 Hrs ), Develop static web Designing Static Web Pages, Web Design Concepts, pages using HTML., 82. Practice with basic HTML • Concepts of Static and, elements (e.g. head, title,, Dynamic Web pages., body), tag and attributes. (3 • Introduction to HTML, Hrs), and various tags in, 83. Design simple web page, HTML., with text, paragraph and • Concepts of different, line break using HTML tags., controls used in Web, (5 Hrs), Pages., 84. Format, text,, change • Concepts of CSS and, background colour and, applying CSS to HTML., insert pictures in web page. • Introduction to open, 20
Page 24 :
Computer Operator and Programming Assistant, , Professional, Skill 210 Hrs;, Professional, Knowledge, 42 Hrs, , (6 Hrs), source CMS viz, Joomla,, 85. Design simple web page, Word press etc. and Web, with tables and lists. (6 Hrs), authoring, tools, viz., 86. Use marquees, hyperlinks, Kompozer, Front Page, and mailto link in designing, etc., web pages. (6 Hrs), • Concept of good web, 87. Create frames, add style, page, designing, and design layout. (10 Hrs), techniques., 88. Insert text box, check box, (18 hrs), and combo box in web, page. (6 Hrs), 89. Design web page using, password field, submit, button, reset button and, radio button etc. (6 Hrs), 90. Design a web page adding, flash file, audio and video, files. (10 Hrs), 91. Design web page with forms, and form controls using, HTML tags. (8 Hrs), 92. Create web page using, Cascading Style Sheet (CSS)., (12 Hrs), 93. Use WYSIWYG (Kompozer), web design tools to design, and edit web pages with, various styles. (12 Hrs), Develop web pages JavaScript & creating Web Introduction to JavaScript, using JavaScript., page, • Introduction, to, 94. Practice, with, basic, Programming, and, elements of JavaScript. (12, Scripting Languages., Hrs), • Introduction, to, 95. Embed JavaScript in HTML, JavaScript, and, its, to display information in, application for the web., web pages, documentation • Introduction to Web, and formatting of HTML, Servers, and, their, source code. (18 Hrs), features., 96. Use JavaScript Variables, • JavaScript Basics – Data, Data types, Constants and, types,, Variables,, 21
Page 25 :
Computer Operator and Programming Assistant, , Professional, Skill 210 Hrs;, Professional, Knowledge, 42 Hrs, , Develop simple, spread sheets by, embedding VBA., , Operators. (18 Hrs), Constants, and, 97. Use Control statements and, Conversion between data, Loops in JavaScript. (18 Hrs), types., 98. Practice with switch case, • Arithmetic, Comparison,, loop controls and Errors in, Logical Operators in, JavaScript. (18 Hrs), JavaScript., Operator, 99. Practice with Arrays in, precedence., JavaScript page. (12 Hrs), • Program, Control, 100. Practice with functions in, Statements and loops in, JavaScript web page. (18, JavaScript., Hrs), • Arrays in JavaScript –, 101. Practice with String, Math, concepts, types and, and Date functions in, usage., JavaScript. (24 Hrs), • The String data type in, 102. Use online tool or open, JavaScript. Introduction, source, software, to, to String, Math and Date., develop and edit web • Introduction to Functions, pages containing Titles,, in JavaScript., different font sizes and • Built, in, JavaScript, colours, frames, lists,, functions overview., tables, images, image • Concepts of Pop Up, map, controls, CSS, forms,, boxes in JavaScript., hyperlinks etc., use web • Introduction, to, the, template to create a web, Document Object Model., page of various styles. (36 • Concepts, of, using, Hrs), Animation, and, 103. Develop a simple web, multimedia files in Java, project, using, HTML,, Script., JavaScript and host it in IIS, (42 hrs), and a registered domain., (36 Hrs), Programming with VBA, Introduction, to, VBA,, 104. Practice, with, basic Features and Applications., functions of VBA Editor.(3 • Introduction to VBA, Hrs), features, and, 105. Use form controls like, applications., buttons, Check boxes, • Properties, events and, Labels, Combo Box, Group, methods associated with, Box, List Box, Option, the Button, Check Box,, Button, Scroll Bar and, Label, Combo Box, Group, 22
Page 26 :
Computer Operator and Programming Assistant, 106., 107., , 108., , 109., , 110., , 111., 112., , 113., , 114., , 115., , 116., 117., , 118., , Spin button. (10 Hrs), Modify object properties, in VBA program. (6 Hrs), Write simple programs, involving VBA Data types,, Variables, Operators and, Constants. (16 Hrs), Create Message boxes, and Input boxes in VBA. (6, Hrs), Work with conditional, statements like if, Else-if,, and Select. (10 Hrs), Practice with Loop, Loop, Control, and, Case, statements in VBA. (13, Hrs), Create and Manipulate, Arrays in VBA. (10 Hrs), Practice, with, string, variables, in, VBA, programming. (10 Hrs), Write programs involving, Mathematical,, Conversion, Date and, String Functions in VBA., (16 Hrs), Create, Functions,, Procedures,, Passing, Parameters and Using, Returned Data. (12 Hrs), Practice with built in, functions, in, VBA, programs. (12 Hrs), Create and edit macros., (12 Hrs), Write code to work with, Excel in VBA forms. (12, Hrs), Practice with methods, 23, , •, •, •, •, •, •, , •, •, •, , •, •, , •, •, , Box, Option Button, List, Box, Scroll Bar and Spin, button controls., 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., (42 hrs)
Page 27 :
Computer Operator and Programming Assistant, , Professional, Skill 90 Hrs;, Professional, Knowledge, 18 Hrs, , Maintain accounts, using accounting, software., , and events in VBA, Programming. (20 Hrs), 119. Debug, Step through, code, Breakpoints, find, and fix errors while, debugging. (18 Hrs), 120. Develop a simple project, involving MS excel and, VBA. (26 Hrs), Using Accounting Software, Using Accounting Software, 121. Practice Basic accounting • Basics of Accounting,, with tally interface. (08, Golden, Rules, of, Hrs), Accounting,, Voucher, 122. Create Company, Account, Entry, Ledger Posting,, and Voucher entry in, Final, Accounts, Tally. (08 Hrs), Preparation., 123. Generate reports for • Cash, Book., Ratio, Invoice, Bill, Profit & Loss, Analysis, Depreciation,, account etc. (08 Hrs), Stock Management., 124. Perform Cost Centre & • Analysis of VAT, Cash, Cost, Category, Flow,, Fund, Flow, management. (10 Hrs), Accounting., 125. Create, and, manage • Introduction to Tally,, budgeting systems. (08, features and Advantages., Hrs), • Implementing accounts, 126. Create, Scenario, and, in Tally., Variance Analysis. (6 Hrs), • Double entry system of, 127. Use Tally for Costing,, book keeping., Ratio Analysis, Cash flow • Budgeting, Systems,, and, Funds, flow, Scenario, management, statements. (08 Hrs), and Variance Analysis., 128. Analyze and Manage • Costing, Systems,, Inventory control. (10 Hrs), Concepts, of, Ratios,, 129. Perform Point of Sales and, Analysis of financial, Taxation (VAT, Excise,, statements., Service Tax). (6 Hrs), • Inventory Basics, POS, 130. Perform, System, Invoicing, TDS, TCS, FBT,, Administration and use, VAT & Service Tax., other Utilities. (6 Hrs), • Tally, Interface, in, 131. Create users, take Backup, 24
Page 28 :
Computer Operator and Programming Assistant, , Professional, Skill 30 Hrs;, Professional, Knowledge, 06 Hrs, , Professional, Skill 30 Hrs;, Professional, Knowledge, 06 Hrs, , & Restore of Company. (6, Different Languages., Hrs), (18 hrs), 132. Use, Multilingual, Functionality in Tally. (6, Hrs), Browse, select and, E Commerce, E Commerce Concepts, transact using E133. Browse, E-commerce • Introduction, to, Ecommerce websites, websites, viz., ebay,, Commerce, and, Amazon, flipkart, OLX,, advantages., quikr etc. and prepare • Building business on the, comparative statement of, net., the main features of these • Payment and Order, sites. (8 Hrs), Processing,, 134. Upload, products, for, Authorization,, selling in E-Commerce, Chargeback and other, Sites and make online, payment methods., purchase, from, E • Security, issues, and, Commerce sites.(14 Hrs), payment gateways., 135. Manage security issues in, (06 hrs), E-Commerce, and, payment operations. (8, Hrs), Secure information Cyber Security:, Cyber Security:, from Internet by, 136. Protect, information, • Overview of Information, using cyber security, computers and networks, Security, SSL, HTTPS,, concept., from viruses, spyware and, Security, threats,, other malicious code. (3, information, Security, Hrs), vulnerability and Risk, 137. Provide firewall security, management., for Internet connection • Introduction to Directory, and Network System. (6, Services, Access Control,, Hrs), Security,, Privacy, 138. Protect the computer, protection, Audit and, against various internet, Security., threats. (3 Hrs), • Introduction to IT Act, 139. Make backup copies of, and penalties for cyber, important file, data and, crimes., information. (3 Hrs), (06 hrs), 140. Secure, your, Wi-Fi, networks using password,, 25
Page 29 :
Computer Operator and Programming Assistant, WEP, WPA-PSK, WPA2PSK, SSID, MAC address, filtering. Create individual, user accounts for each, member. (9 Hrs), 141. Limit member access to, data and information, and, restrict authority to install, unnecessary downloads., (6 Hrs), Industrial Visit/Project work, Broad Area:, a) Create and host a web site of at least 6 web pages using JavaScript containing interactive, objects, functions etc., b) Create a project with Excel & VBA on Payroll Systems., c) Create a company in Tally and post vouchers in it for a financial period. Vouchers should, contain purchase, sales with VAT, contra, payment, receipts, cost centre cost category etc., , 26
Page 30 :
Computer Operator and Programming Assistant, , SYLLABUS FOR CORE SKILLS, 1. Employability Skills ( Common for all CTS trades) (160 Hrs), , Learning outcomes, assessment criteria, syllabus and Tool List of Core Skills subjects which is, common for a group of trades, provided separately in www.bharatskills.gov.in, , 27
Page 31 :
Computer Operator and Programming Assistant, , ANNEXURE-I, LIST OF TOOLS & EQUIPMENT, COMPUTER OPERATOR AND PROGRAMMING ASSISTANT (for Batch of 24 Candidates), S No., , Name of the Tools and, Equipment, , Specification, , Quantity, , CPU: 32/64 Bit i3/i5/i7 or latest processor,, Speed: 3 GHz or Higher. RAM:-4 GB DDR-III or, Higher, Wi-Fi Enabled. Network Card:, Integrated Gigabit Ethernet, with USB Mouse,, USB Keyboard and Monitor (Min. 17 Inch., Licensed Operating System and Antivirus, compatible with trade related software., 4th Gen Ci5 or higher Processor, 4GB RAM,, 1TB Hard Disk, Win8/latest Preloaded, Licensed OS, 2GB Graphics Card, DVD Writer,, Standard Ports And Connectors., With Wireless Connectivity, 24 Port, to enable working with Wired Networks for, Practical, Broadband connection with min. 2 mbps, speed, at least 100 MB Web Space, Colour A4 Size, Monochrome A4 Size, Flatbed A4, High Resolution(3.1 mp or higher), 24X or higher external (usb), 3000 lumens or higher, matte(antiglare) screen, , 24 Nos., , A. Trainees Tools/ Equipment, 1., , Desktop Computer, , 2., , Laptop, , 3., 4., 5., , Wi–Fi Router, Switch, Structured cabling in Lab, , 6., , Internet Connectivity, , 7., 8., 9., 10., 11., 12., 13., 14., 15., 16., 17., 18., 19., 20., , Registered Domain, Laser Printer, Network Laser Printer, Optical Scanner, Digital Web Cam, DVD or Blu-Ray Writer, LCD Projector, Projector Screen, Online UPS, Crimping Tool, Network Rack, Digital Multimeters, Screw Driver Set, Mini Dongle for Bluetooth, devices Connection, , RJ-45, 4U for 24 port, 3.5 digit handheld type., Standard, USB, 28, , 01 No., , 01 No., 01 No., As required, As required, As required, 01 No., 01 No., 01 No., 04 Nos., 02 Nos., 01 No., 01 No., As required, 05 Nos., 01 No., 04 Nos., 04 Sets, 04 Nos.
Page 32 :
Computer Operator and Programming Assistant, 21., 22., 23., 24., 25., 26., , Headphone &mic. set, Sound System, External Hard Disk, Patch Panel, LAN Tester, Punching Tool, , Wired, 2:1, 1 TB, 24 Port, UTP cat5 cable tester (RJ 45), for punching RJ 45 socket with cat 5 cable, , 05 Nos., 01 No., 02 Nos., 02 Nos., 05 Nos., 05 Nos., , B. Software, 27., , MS Office, , 28., , Antivirus for – clients /, workstations in profile, Open Office or equivalent, , 29., 30., , 2010 (professional) or the latest version, available at the time of procurement, validity of an year or more which should be, renewed upon expiry, Latest version, Latest version, , 31., , GIMP / IrfanView Image, editor or equivalent, LINUX OS, , 32., , Web Authoring tool, , 33., 34., , Tally, E Commerce Simulation, Software, Web Server, , WYSIWYG Web Authoring toolDreamweaver or Open Source tools like, Kompozer, FrontPage or similar tools along, with FTP tools for ex. Filezilla etc., ERP 9 or Latest, Latest version, , 35., , Latest version, , HTTP Web server / XAMPP or any other, similar server, , 25 Licenses, 25 Licenses, Open source, software, Open source, software, Open source, software, Proprietary, /Open source, software, 13 Licenses, Open source, software, Open source, software, , C. List Of Other Items/Furniture, 36., 37., 38., , Vacuum cleaner, Pigeon hole cabinet, Chair and table for the, instructor, , Hand Held, 20 compartments, with armrest mounted on castor wheels,, adjustable height/Standard, , 39., , Standard, , 40., , Dual Desk or Chair and, Tables for Trainees, Computer table, , 41., , Operators chair, , 42., , Printer table, , laminated top 150X650X750 mm with sliding, tray for key board and one shelf of storage, without arms mounted on castor wheels,, adjustable height, 650X500X750 mm can be varied as per local, 29, , 01 No., 01 No., 01 each(for, class room &, laboratory), 12 / 24 Nos., 12 Nos., 24 Nos., 03 Nos.
Page 33 :
Computer Operator and Programming Assistant, specifications, 43., 44., 45., 46., 47., 48., , Air conditioner, Storage cabinet, White Board, Steel Almirah, Fire Extinguisher CO2, Fire Buckets, , 60X700X450mm, minimum 4X6 feet, 2.5 m x 1.20 m x 0.5 m, 2 KG, Standard size, , As required, 01 No., 01 No., 01 No., 02 Nos., 02 Nos., , D. Raw Materials, 49., 50., 51., 52., 53., 54., , White Board Marker, Duster Cloth, Cleaning Liquid, Photo Copy Paper, Full Scape Paper, Cartridges for printer, , 55., 56., 57., 58., 59., 60., 61., 62., 63., 64., 65., 66., 67., 68., 69., 70., 71., 72., , I/O Box with socket, RJ 45 connector, Optical Mouse, Key Board, SMPS, CMOS Batteries, Power Chord, Cable, Stapler, Stapler, Battery for remote, Battery for clock, Pen drive, CDs, DVDs, Wall Clock, Battery for LAN tester, Power Adapter, , Assorted colour, 2’/2’, 500 ml, A4, White, Colour/monochrome as per model of the, printer, RJ 45, For connecting utp cat 5 cable, USB/PS2, USB/PS2, 12V DC, 3.0 V, 3 Pin, Cat 5/5e, Small, Big, AAA, AA, 8 GB, 52x or higher, 4.7GB or higher, Analog, 9V, For Hub, Switch, Router, , 30, , As required, As required, As required, As required, 02 reams, As required, As required, 200 Pcs., As required, As required, As required, As required, As required, 100 meter, 02 pcs., 01 pc., As required, As required, 02 Nos., 50 Nos., 50 Nos., 01 pc., As required, As required
Page 35 :
Computer Operator and Programming Assistant, MEMBERS OF SECTOR MENTOR COUNCIL, S, No., 1, , 2, , 3, , 4, , 5, 6, 7, , 8, 9, , 10, , 11, 12, , Name of the member with, Post (Shri /Smt/Ms), R Chandrasekaran, Chief, Executive, Technology &, Operations, Srikantan Moorthy, SVP &, Head, Education &, Research, Deepak Jain, Senior VP &, Global Head-Work Force, Planning, K. Ganesan, Vice President -Global Head, Talent Acquisition Group, TCS, TCS House, Raveline street, Fort, Mumbai - 400 001, Avinsh Vashishta, Chairman, & GU Managing Director, Ravi Shankar B., Mr. Umesh Gupta, Network, of ICT Entrepreneurs and, Enterprises, Prof. S.C. De Sarkar,, Dr. Arti Kashyup, Associate, Professor, , Dr. Sanjeev Kumar Gupta,, Head, Technical Wing, , Dr. B. Mahanty, Professor, Dr. Narayanaswamy N S,, , Organisation, Cognizant Technology Solutions India Pvt., Ltd., 12th & 13th Floor, "A" wing,, Kensington Building, Hiranandani Business, Park, Powai, Mumbai - 400 076, Infosys Electronics City, Hosur Road,, Bangalore 560 100, WIPRO, Doddakannelli, Sarjapur Road,, Bangalore - 560 035, , Position in, SMC, , Member, , Member, , Member, , TCS, TCS House, Raveline street, Fort,, Mumbai - 400 001, Member, , Accenture Services Pvt. Ltd., 71,, Cunningham Road, Bangalore – 560052, Mindtree Ltd, Global Village, RCVE Post,, Mysore Road, Bangalore 59, USO House, USO Road, 6 Special, Institutional Area, New Delhi-110067, Indian, Institute, of, Technology, Bhubaneswar, Bhubaneswar-751 013, Academic Block, Indian Institute of, Technology Mandi, PWD Rest House, Near, Bus Stand, Mandi - 175 001, Himachal, Pradesh, National Institute of Electronics and, Information, Technology,, Electronics, Niketan, 6, CGO Complex, New Delhi 110, 003, Indian Institute of Technology Kharagpur,, Kharagpur, India - 721302, D/o Computer Science and Engg, 32, , Member, Member, , Member, , Member, , Member, , Chairman, , Member, Member
Page 38 :
Computer Operator and Programming Assistant, , ABBREVIATIONS, CTS, ATS, CITS, DGT, MSDE, NTC, NAC, NCIC, LD, CP, MD, LV, HH, ID, LC, SLD, DW, MI, AA, PwD, , Craftsmen Training Scheme, Apprenticeship Training Scheme, Craft Instructor Training Scheme, Directorate General of Training, Ministry of Skill Development and Entrepreneurship, National Trade Certificate, National Apprenticeship Certificate, National Craft Instructor Certificate, Locomotor Disability, Cerebral Palsy, Multiple Disabilities, Low Vision, Hard of Hearing, Intellectual Disabilities, Leprosy Cured, Specific Learning Disabilities, Dwarfism, Mental Illness, Acid Attack, Person with disabilities, , 35
Page 39 :
Computer Operator and Programming Assistant, , 36
