Page 1 :
GOVERNMENT OF INDIA, MINISTRY OF SKILL DEVELOPMENT & ENTREPRENEURSHIP, DIRECTORATE GENERAL OF TRAINING, , COMPETENCY BASED CURRICULUM, , COMPUTER OPERATOR AND PROGRAMMING, ASSISTANT, (Revised in 2017), , CRAFTSMEN TRAINING SCHEME (CTS), NSQF LEVEL - 4, , SECTOR – IT & ITES, , 1
Page 5 :
CONTENTS, Sl., No., 1., , Topics, , Page No., , Course Information, , 6-8, , 2., 3., , Job Role, NSQF Level Compliance, , 9, 10, , 4., , General Information, , 5., , Learning/ Assessable Outcome, , 6., 7., 8., 9., 10., , Learning Outcome with Assessment Criteria, Syllabus - Professional Skill, Professional Knowledge, Syllabus - Employability Skill, Annexure I - List of Trade Tools & Equipment, Annexure II - Format for Internal Assessment, , 11- 12, 13, , 5, , 14 - 18, 19 - 29, 20 - 32, 33 - 35, 36
Page 6 :
1. COURSE INFORMATION, 1.1 GENERAL, Directorate General of Training (DGT) under Ministry of Skill Development &, Entrepreneurship offers range of vocational training courses catering to the need of different, sectors of Labour market. The vocational training programmes are running under aegis of, National Council of Vocational Training (NCVT). Craftsman Training Scheme (CTS) and, Apprenticeship Training Scheme (ATS) are two pioneer programmes under NCVT for propagating, vocational training., Computer Operator and Programming Assistant trade, ade under CTS is one of the popular, courses running through ITIs pan India. The course is of one year (02 semester) duration. It mainly, consists of trade (skills and knowledge)., knowledge) After passing out the training programme, the trainee is, being awarded National Trade Certificate (NTC) by NCVT having worldwide recognition., Trainee needs to demonstrate, trate 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., , 1.2 CARRIER PROGRESSION PATHWAYS, Can join Apprenticeship programme in different types of industries leading to National, Apprenticeship certificate (NAC)., Can join Crafts Instructor Training Scheme (CITS), (CITS) in the trade for becoming instructor in, ITIs., , 6
Page 7 :
1.3 COURSE STRUCTURE, The training duration of course in hours during a period of one year (02 semesters) is as, followsSl. No., Course Element, Notional Training Hours, 1, Professional Skill (Trade Practical), 1260, 2, Professional Knowledge (Trade Theory), 252, 3, Employability Skills, 110, 4, Library & Extracurricular activities, 58, 5, Project work, 160, 6, Revision & Examination, 240, Total, 2080, , 1.4 ASSESSMENT & CERTIFICATION, The trainee will be tested for his skill, knowledge and attitude during the period of course and, at the end of the training programme as notified by Govt of India from time to time., a) The Internal assessment 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 template (Annexure – II)., b) The final assessment will be in the form of summative assessment method. The All India trade, Test for awarding NTC will be conducted by NCVT as per guideline of Govt of India. The pattern, and marking structure is being notified by govt of India 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., 1.4.1 PASS REGULATION, For the purposes of determining the overall result, weighting of 25 percent is applied to, each semester examination. The minimum pass percent for Practical is 60% & minimum pass, percent for Theory subjects 40%., 1.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 to be given while assessing for team work,, avoidance/reduction of scrap/wastage and disposal of scarp/wastage as per procedure,, behavioral attitude, sensitive to environment and regularity in training. The sensitivity towards, OSHE and self-learning attitude to be considered while assessing competency., , 7
Page 8 :
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, , Evidence of internal assessment to be preserved until forthcoming semester 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, 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., , Demonstration of good skill in the use of hand tools,, machine tools and workshop equipment, Below 70% tolerance dimension achieved while, undertaking different work with those demanded by, the component/job., A fairly good level of neatness and consistency in the, finish, Occasional support in completing the project/job., , (b) Weightage in the range of above 75% - 90% to be allotted during assessment, 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., , Good skill levels in the use of hand tools, machine, tools and workshop equipment, 70-80% tolerance dimension achieved while, undertaking different work with those demanded by, the component/job., A good level of neatness and consistency in the finish, Little support in completing the project/job, (c) Weightage in the range of above 90% to be allotted during assessment, , 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., , High skill levels in the use of hand tools, machine, tools and workshop equipment, Above 80% tolerance dimension achieved while, undertaking different work with those demanded by, the component/job., A high level of neatness and consistency in the finish., Minimal or no support in completing the project., , 8
Page 9 :
2. JOB ROLE, Computer Operator:, 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, c, 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 rev, 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., tap, , Programming Assistant:, 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 iinstallations., nstallations. 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), , 9
Page 10 :
3. NSQF LEVEL COMPLIANCE, NSQF level for COMPUTER OPERATOR AND PROGRAMMING ASSISTANT trade under CTS: Level 4, As per notification issued by Govt. of India dated, dated- 27.12.2013 on National Skill Qualification, Framework total 10 (Ten) Levels are defined., Each level of the NSQF is associated with a set of descriptors made up of five outcome statements,, which describe in general terms, the minimum knowledge, skills and attributes that a learner needs to, acquire in order to be certified for that level., Each level of the NSQF is described by a statement of learning outcomes in five domains, known as, level descriptors. These five domains are:, a., Process, b. professional knowledge,, c., professional skill,, d. core skill and, e., Responsibility., The Broad Learning outcome of COPA trade under CTS mostly matches with the Level descriptor at, Level- 4., The NSQF level-4, 4 descriptor is given below:, below, LEVEL, Level 4, , Process, required, Work in familiar,, predictable,, routine,, situation, of clear choice, , Professional, knowledge, Factual, knowledge, of field of, knowledge, or study, , Professional skill, Recall and, demonstrate, practical skill,, routine and, repetitive in, narrow range of, application, using, appropriate rule, and, tool, using quality, concepts, , 10, , Core skill, , Responsibility, , Language to, Responsibility for, communicate, own work and, written or oral,, learning., with required, clarity, skill to, basic Arithmetic, and algebraic, principles, basic, understanding of, social political, and natural, environment
Page 11 :
4.. GENERAL INFORMATION, Name of the Trade, , COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, , NCO - 2015, , 4131.0600, 3514.0300, , NSQF Level, , Level 4, , Duration of Craftsmen, Training, , 1 Years (2 Semesters), , Entry Qualification, , Passed 10th class examination, , Unit Strength (No. Of, Student), , 20, , Space Norms, , 70 Sq. metres, , Power Norms, 3.45 KW, Instructors Qualification for, 1. Computer Operator, And Programming, Assistant Trade, , Technical –, (i), B.E./B. Tech in Computer Science / IT from Recognized, University with one year expreience in the relevant field., OR, (ii)), Post Graduate in Computer Science /Computer, /Comput Application / IT, or NIELIT B Level with one year expreience in the relevant field., OR, (iii, iii) 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, (iv) Three year Diploma from, om recognized Board/ Institute in, Computer Science / IT with two year expreience, preience in the relevant field., OR, (v), National Apprenticeship Certificate or National Trade, Certificate, ertificate in the trade of Computer Operator and Programming, Assistant and National Craft Instructor Training Certificate in the, trade if available with three year expreience in the relevant field., Desirable Qualification, Q, Preference will be given to a candidate with CITS, CITS(Craft Instructor, Training Scheme), Scheme in COPA Trade., , 2. Employability Skill, , NOTE:, NOTE, Out of two Instructors required for the unit of 2(1+1), one must, have Degree/Diploma and other must have NTC/NAC qualifications., MBA OR BBA with two years experience OR Graduate in Sociology/, , 11
Page 12 :
Social Welfare/ Economics with Two years experience OR Graduate/, Diploma with Two years experience and trained in Employability Skills, from DGT institutes., AND, Must have studied English/ Communication Skills and Basic Computer, at 12th / Diploma level and above., OR, Existing Social Studies Instructors duly trained in Employability Skills, from DGT institutes., List of Tools &, Equipment, , As per Annexure-I, , Distribution of training on Hourly basis: (Indicative only), Total Hrs, /week, , Trade Practical, , Trade Theory, , Employability Skills, , Extra-Curricular, Activity, , 40 Hours, , 30 Hours, , 6 Hours, , 2 Hours, , 2 Hours, , 12
Page 13 :
5.. LEARNING/ ASSESSABLE OUTCOME, Learning outcomes are reflection of total competencies of a trainee and assessment will be, carried out as per assessment criteria., 5.1 GENERIC LEARNING OUTCOME, 1., 2., 3., 4., 5., 6., , Apply safe working practices., practices, Comply environment regulation and housekeeping., Work in a team, understand and practice soft skills, technical English to communicate with, required clarity., Understand and explain the concept in productivity, quality tools, and labour welfare, legislation and apply such in day to day work to improve productivity & quality., Explain energy conservation, global warming and pollut, pollution, ion and contribute in day to day, work by optimally using available resources., Explain personnel finance, entrepreneurship and manage/organize related task in day to, day work for personal & societal growth., , 5.2 SPECIFIC LEARNING OUTCOME, 7., 8., 9., 10., 11., 12., 13., 14., 15., 16., 17., 18., , Install and setup operating system and related software in a computer., Create, format and edit document using word processing application software., Create, format, edit and develop a workbook by using spreadsheet application software., Create and customize slides for presentation., Create and manage database file using MS Access., Install, setup/configure, troubleshoot and secure computer network including Internet., Develop static web, eb pages using HTML., HTML, Develop web pages using Java Script., Develop simple spread sheets by embedding VBA., Maintain accounts using accounting software., Browse, select and transact using E commerce websites., Secure information from Internet by using cyber security concept., , 13
Page 14 :
6.. LEARNING OUTCOME WITH ASSESSMENT CRITERIA, GENERIC LEARNING/ ASSESSABLE OUTCOME, LEARNING / ASSESSABLE, ASSESSMENT CRITERIA, OUTCOME, 1. Apply safe working 1.1 Follow and maintain procedures to achieve a safe working, practices., environment in line with occupational health and safety, regulations and requirements and according to site policy., 1.2 Recognize and report all unsafe situations according to site, policy., 1.3 Identify and take necessary precautions on fire and safety, hazards and report according to site policy and procedures., 1.4 Identify, handle and store / dispose off dangerous goods and, substances according to site policy and procedures following, safety regulations and requirements., 1.5 Identify and observe site policies and procedures in regard to, illness or accident., 1.6 Identify safety alarms accurately., 1.7 Report supervisor/ Competent of authority in the event of, accident or sickness of any staff and record accident details correctly, according to site accident/injury procedures., 1.8 Identify and observe site evacuation procedures according to, site policy., 1.9 Identify Personal Productive Equipment (PPE) and use the same, as per related working environment., 1.10 Identify basic first aid and use them under different, circumstances., 1.11 Identify different fire extinguisher and use the same as per, requirement., 2. Comply environment 2.1 Identify environmental pollution & contribute to the avoidance, regulation, and of instances of environmental pollution., housekeeping., 2.2 Deploy environmental protection legislation & regulations, 2.3 Take opportunities to use energy and materials in an, environmentally friendly manner, 2.4 Avoid waste and dispose waste as per procedure, 2.5 Recognize different components of 5S and apply the same in the, working environment., 3. Work in a team, 3, 3.1, .1 Obtain sources of information and recognize information., understand and practice 3.2Use, 3.2Use and draw up technical drawings and documents., soft skills, technical English 3.3, 3.3 Use documents and technical regulations and occupationally, , 14
Page 15 :
to, communicate, required clarity., , with related provisions., 3.4 Conduct appropriate and target oriented discussions with higher, authority and within the team., 3.5 Present facts and circumstances, possible solutions &use English, special terminology., 3.6 Resolve disputes within the team, 3.7 Conduct written communication., , 4. Understand and explain, the concept in productivity,, quality tools, and labour, welfare legislation and, apply such in day to day, work, to, improve, productivity & quality., , 4.1 Semester examination to test the concept in productivity, quality, tools and labour welfare legislation., , 5., Explain, energy, conservation,, global, warming and pollution and, contribute in day to day, work by optimally using, available resources., , 5.1 Semester examination to test knowledge, conservation, global warming and pollution., , 4.2 Their applications, assessable outcome., , 5.2 Their applications, assessable outcome., , will also be assessed during execution of, , on, , energy, , will also be assessed during execution of, , 6. Explain entrepreneurship 6.1 Semester examination to test knowledge on entrepreneurship., and, manage/organize, related task in day to day 6.2 It’s applications will also be assessed during execution of, work for personal & societal assessable outcome., growth., , 15
Page 16 :
SPECIFIC LEARNING/ ASSESSABLE OUTCOME, SEMESTER-I, LEARNING / ASSESSABLE, OUTCOME, 7. Install and setup, operating, system, and, related software in a, computer., , 8. Create, format and edit, document using word, processing, application, software., , ASSESSMENT CRITERIA, 7.1, 7.2, 7.3, 7.4, 7.5, 7.6, 7.7, , 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., , 8.1, 8.2, 8.3, 8.4, 8.5, 8.6, , Identify Word tools in the Ribbon., Create a resume using various tools., Design and print Magazine covers using various tools., Demonstrate the use of shortcut keys , autocorrect and macros., Perform Mail merge in MS Word., Typing practice using open source typing tutor tools., , 9. Create, format, edit and 9.1 Create tables, chart and print using various functions and, develop a workbook by, formulas, apply Conditional formatting., using, spreadsheet 9.2 Create a table and Perform Sorting; filtering, Subtotal, validation, application software., and goal seek on a table., 9.3 Prepare a pivot table and chart on any existing table., 10. Create and customize 10.1 Edit images with Open Office Applications., slides for presentation., 10.2 Create Slides and run slideshows., 10.3 Format objects, add Audio and Video., 10.4 Use Open Office for creating presentations., 11. Create and manage 11.1 Create simple application on Relational Database in MS Access, database file by using MS, using data validation, filters, sorting, forms, query, report and, Access., macro., 11.2 Import , Export, Link, Backup and Retrieve database in MS, Access., 12. Install, setup/configure,, troubleshoot and secure, computer, network, including Internet., , 12.1, 12.2, 12.3, 12.4, 12.5, 12.6, 12.7, , Identify different cables and connectors used in networking., Assign Computer Name and workgroup to a computer, Prepare UTP cross cable & connect computers, Share a printer with Network, Share Internet using Windows Tools, Check Network connectivity, Configure HUB & Switch, 16
Page 17 :
12.8 Configure DHCP and firewall, 12.9 Setup Video conferencing, 12.10 Secure Network with various tools, 12.11 Practice Web Browsing and create E Mail ID and sending, receiving mails, 12.12 Perform text chat and video chat using social network sites, 12.13 Configure Outlook Express, 12.14 Use Skype and Google+ or any other video conferencing site., 13. Develop static web 13.1 Create simple static Web Pages using HTML tags., pages using HTML., 13.2 Create simple static WebPages using internal styles (CSS) and, external style., 13.3 Design static web pages using Kompozer., SEMESTER-II, 14. Develop web pages 14.1 Design a dynamic Web Page in JavaScript using various, using Java Script., operators., 14.2 Design a dynamic Web Page in JavaScript using various control, statements and looping structures., 14.3 Design a dynamic Web Page in JavaScript using strings and, functions., 14.4 Design a dynamic Web Page in JavaScript using Arrays and, objects., 14.5 Design a dynamic Web Page in JavaScript using Web Forms and, images., 15. Develop simple spread 15.1 Create various types of macros in MS Excel., sheets by embedding VBA., 15.2 Develop and execute a program in VBA using various operators, and data types., 15.3 Develop and execute a program in VBA using control, statements and looping structures., 15.4 Develop and execute a program in VBA using strings and, functions., 15.5 Develop and execute a program in VBA using Arrays., 15.6 Design a VBA User Form and develop program using various, control buttons and boxes., 16. Maintain accounts using 16.1 Create a company in Tally., accounting software., 16.2 Create opening ledgers using an existing Balance Sheet., 16.3 Post voucher in tally in different modes., 16.4 Performing Cost Centre & Cost category., 16.5 Manufacture and transfer materials in Tally., 16.6 Show P/L A/c, Balance Sheet and other reports., 16.7 Apply Budget., 16.8 Post VAT & Service Tax related entry in Tally, , 17
Page 18 :
17. Browse, select and 17.1 Place order for products from E commerce websites for, transact using E-commerce, purchase., websites., 17.2 Upload a product in E Commerce site for sale., 17.3 Identify security issues in E- commerce and payment, operations., 18. Secure information 18.1 Provide firewall security for Internet connection and Network, from Internet by using, System., cyber security concept., 18.2 Make backup copies of important file, data and information., 18.3 Secure your Wi-Fi networks using wireless security features., , 18
Page 19 :
7. SYLLABUS, SYLLABUS FOR COMPUTER, COMPUTE OPERATOR AND PROGRAMMING, AMMING ASSISTANT, FIRST SEMESTER – 06 Months, Learning Objectives:, 1. Install and setup operating system and related software in a computer., 2. Create and edit document using word processing application software., 3. Create,, ate, edit and develop a workbook by using spreadsheet, preadsheet application software., software, 4. Create and customize slides for presentation., 5. Create and, d manage database file by using MS Access., A, 6. Install, setup/configure, troubleshoot and, and secure computer network including Internet., 7. Develop static web pages using HTML and Kompozer., Professional Skills, Week, Learning, Professional Knowledge, (Trade Practical), No., Outcome, (Trade Theory), With indicative hours, 1, Safe working practices, Safe working practices, Apply safe, 1. Visit COPA Lab. of the institutes, working, Scope of the COPA trade., and locate the electrical, practices, Safety rules and safety signs., connections with computer, Types and working of fire, system setup. (6 hrs), extinguishers., 2. Identifying safety symbols and, hazard identification. (4 Hrs), 3. Practice safe methods of fire, fighting in case of electrical fire. (4 Introduction to Computer, hrs), compon, nents, 4. Use of fire extinguishers. (4 Hrs), Introduction, ntroduction to computer, system. Concepts of, Install and, Com, mputer components, Hardware and Software., setup, 5. Identify computer peripherals and, operating, Function of motherboard, internal components of a, system and, components and various, disassembled desktop computer., related, processors., (6, Hrs), software in a, Various Input/ Output, 6. Assemble components of desktop, computer., devices in use and their, computer. (6 Hrs), features., 2, Install and, Using Windows Operating System, Introduction Windows Operating, setup operating 7. Practice on Windows, Win, interface, System, system and, and navigating windows. (9 Hrs), Introduction to operating, related, 8. Practice on managing files and, System, software in a, folders using removable drives. (6, Main features of Windows, computer., Hrs), OS, 9. Customize the desktop settings, settin, Concept of various shortcut, and manage user accounts. (6 Hrs), commands., 10. View system properties, properti and, control panel details. (6 Hrs), 19
Page 20 :
3, , 4-5, , 11. Work with keyboard shortcut, commands. (6 Hrs), 12. Print and scan document using, different commands. (3 Hrs), Install and, Computer basics and Software, setup operating Installation, system and, 13. View the BIOS settings and their, related, modifications. (3 Hrs), software in a, 14. Install Windows operating system., computer., (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 wi-fi, 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), Install and, DOS Command Line Interface & Linux, setup operating Operating Systems, system and, 21. Use basic DOS commands for, related, directory listing. (10 Hrs), software in a, 22. Manage files and folders using, computer., DOS commands. (6 Hrs), 23. Install Linux operating system. (6, Hrs), 24. Install, necessary, application, software for Linux i.e. Office, Package, PDF Reader, Media, Player etc. (6 Hrs), 25. Use Basic Linux commands 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, , 20, , 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., , 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.
Page 21 :
6-8, , 9 - 11, , 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), Create, format, Using Word Processing Software, Word Processing Software, and edit, 29. Open MS Word and familiarise, Introduction to the various, document using, with basic word components. (3, applications in MS office., word, Hrs), Introduction to Word, processing, 30. Practice creating, saving and, features, Office button,, application, renaming of word documents. (3, toolbars., software., Hrs), Creating, saving and, 31. Edit document using basic, formatting and printing, formatting tools. (8 Hrs), documents using Word., 32. Practice Inserting and formatting, Working with objects,, tables and other objects. (12 Hrs), macro, mail merge,, 33. Work with Page layout settings, templates and other tools in, and printing documents. (6 Hrs), Word., 34. Use templates, autocorrect tools,, and record and execute a macro., (6 Hrs), 35. Use Mail merge tool. Use, 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, crossreference, footnote, translate,, synonyms, thesaurus, spell check, & grammer, 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), Create, format, Using Spread Sheet Application, Spread Sheet Application, edit and, 39. Open MS Excel and familiarise, Introduction to Excel, develop a, with, basic, application, features and Data Types., workbook by, components. (4 Hrs), Cell referencing and linking, using, 40. Practice creating, saving and, Sheets., spreadsheet, formatting excel spread sheets. (9, Introduction to various, , 21
Page 22 :
application, software., , 12-13, , Create and, customize, slides for, presentation., , Hrs), functions in all categories of, 41. Use absolute and relative, Excel., referencing, linking sheets,, Concepts of sorting, filtering, conditional formatting etc. (9 Hrs), and validating data., 42. Practice Excel functions of all, Analyzing data using charts,, major categories i.e. Financial,, data tables, pivot tables,, Logical, Text, date & time, Lookup,, goal seek and scenarios., Math, Statistical etc. (12 Hrs), 43. Use various data types in Excel,, sorting, filtering and validating, data. (8 Hrs), 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 Office., 49. Use Windows Paint or image, Introduction to the, editing software like Open Office, properties and editing of, Draw, GIMP, IrfanView or a similar, images., tool. (6 Hrs), Introduction to different, 50. Perform Image editing using open, formats of images and their, source applications. (12 Hrs), uses., 51. Open power point presentation, Introduction to Power Point, and, familiarise, with, basic, and its advantages., application components. (6 Hrs), Creating Slide Shows., 52. Create Slide shows, Insert picture, Fine tuning the, and theme. (6 Hrs), presentation and good, 53. Add new slide, format text, link, presentation technique., 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 synchronise, with presentation. (6 Hrs), , 22
Page 23 :
14 - 15 Create and, manage, database file by, using MS, Access., , 16 - 17 Install, setup/, configure,, troubleshoot, and secure, computer, network, including, Internet., , 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, Database Management Systems, Access, Concepts of Data and, 58. Create database and design a, Databases., simple tables in Access. (6 Hrs), Overview of popular, 59. Practice, enforcing, integrity, databases, RDBMS, OODB, constraints and modify properties, and NOSQL., of tables and fields. (6 Hrs), Rules for designing good, 60. Create relationships and join, tables. Integrity rules and, tables. (6 Hrs), constraints in a table., 61. Create and format Forms. (6 Hrs), Relationships in tables., 62. Create simple queries with various, Introduction to various, criteria and calculations. (12 Hrs), types of Queries and their, 63. Create Simple update, append,, uses., make table, delete and crosstab, Designing Access Reports, queries. (9 Hrs), and Forms., 64. Modify form design with controls,, Introduction to macros,, macros and events. (6 Hrs), designer objects controls,, 65. Import and export data to and, their properties and, from Access and create and, behaviour., format various types of reports. (6, Hrs), 66. Compress and Encrypt databases., (3 Hrs), Configuring and using Network, Networking Concepts, 67. View Network connections. (3 Hrs), Introduction to Computer, 68. Connect a computer to a network, Networks, Necessity and, and share Devices i.e. Printers,, Advantages., files, folders and drives. (6 Hrs), Client Server and peer to, 69. Work with various Network, Peer networking concepts., devices, connectors and cables., Concept of Proxy Server and, Create straight and cross cable, proxy firewall server., and punch a UTP cable in the, Concept of DHCP Server., patch socket and test the, Network topologies., connectivity. (6 Hrs), Introduction to LAN, WAN, 70. Practice IP Addressing and Subnet, and MAN., masking for IPV4/ IPV6 and, Network components, viz., pinging to test networks. (6 Hrs), Modem, Hub, Switch,, 71. Configure Hub and Switch. (6 Hrs), Router, Bridge, Gateway, 72. Set up and configure wired and, etc., wireless LAN in a Computer Lab, Network Cables, Wireless, within at least three computers., networks and Blue Tooth, , 23
Page 24 :
Use patch panel & I/O Box for, technology., wired LAN and installing &, Concept of ISO - OSI 7 Layer, configuring Internet connection in, Model., a single PC and in a LAN. (12 Hrs), Overview of various, 73. Set up a proxy server/ DHCP, Network protocols Viz., Server with firewall. (9 Hrs), TCP/IP, FTP, Telnet etc., 74. Set up video conferencing using, Concept of Logical and, open source software. (6 Hrs), Physical Addresses,, 75. Use various tools (by open source, Subnetting and Classes of, /free), for, network, Networks., troubleshooting, maintenance and, security for both Wired and, Wireless(6 Hrs), 18, Install, setup/, Using Internet, Internet Concepts, configure,, 76. Browse, the, Internet, for, Introduction to www,, troubleshoot, information (use at least 3 popular, Concept of Internet, Web, and secure, browsers). (3 Hrs), Browsers, internet servers, computer, 77. Create and use e-mail for, and search engines., network, communication with attachment,, Concepts of Domain naming, including, priority setting, address book. (3, Systems and E mail, Internet., Hrs), communication., 78. Communicate with text, video, Introduction to video, chatting and social networking, chatting tools and Social, sites. (6 Hrs), Networking concepts., 79. Use online dictionary, translation, software, 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 ), 19 - 21 Develop static Designing Static Web Pages, Web Design Concepts, web, pages 82. Practice with basic HTML elements, Concepts of Static and, using HTML., (e.g. head, title, body), tag and, Dynamic Web pages., attributes. (3 Hrs), Introduction to HTML and, 83. Design simple web page with text,, various tags in HTML., paragraph and line break using, Concepts of different, , 24
Page 25 :
24-25, , HTML tags. (5 Hrs), controls used in Web Pages., 84. Format text, change background, Concepts of CSS and, colour and insert pictures in web, applying CSS to HTML., page. (6 Hrs), Introduction to open source, 85. Design simple web page with, CMS viz, Joomla, Word, tables and lists. (6 Hrs), press etc. and Web, 86. Use marquees, hyperlinks and, authoring tools viz., mailto link in designing web pages., Kompozer, Front Page etc., (6 Hrs), Concept of good web page, 87. Create frames, add style and, designing techniques., design layout. (10 Hrs), 88. Insert text box, check box 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), Industrial Visit/Project work (1. Create a simple web site of at least 5 web pages which will, include Images, tables, charts, lists and hyperlink on any topic like Student Information, System, Book Store, and Organisations etc. OR, 2. Setup and configure a LAN using at least 3 computers connected with wire and 3, computers connected with wireless and secure it.), Revision, , 26, , Examination, , 22-23, , 25
Page 26 :
SYLLABUS FOR COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, SECOND SEMESTER – 06 Months, Learning Objectives, 1. Understand and develop basic programs using JavaScript., 2. Develop dynamic web pages using JavaScript., 3. Create and edit macros using VBA in MS Excel., 4. Develop basic programs using VBA., 5. Create the User Forms and develop programs for the User Forms using VBA., 6. Maintain accounts by creating a company using accounting software., 7. Browse, select and transact using E commerce websites., 8. Secure information from Internet by using cyber security concept., Professional Skills, Week, Learning, Professional Knowledge, (Trade Practical), No., Outcome, (Trade Theory), With indicative hours, 27 - 33 Develop web JavaScript & creating Web page, Introduction to JavaScript, pages using, 94. Practice with basic elements of, Introduction to, JavaScript., JavaScript. (12 Hrs), Programming and Scripting, 95. Embed JavaScript in HTML to, Languages., display information in web pages,, Introduction to JavaScript, documentation and formatting of, and its application for the, HTML source code. (18 Hrs), web., 96. Use JavaScript Variables, Data, Introduction to Web, types, Constants and Operators., Servers and their features., (18 Hrs), JavaScript Basics – Data, 97. Use Control statements and Loops, types, Variables, Constants, in JavaScript. (18 Hrs), and Conversion between, 98. Practice with switch case, loop, data types., controls and Errors in JavaScript., Arithmetic, Comparison,, (18 Hrs), Logical Operators in, 99. Practice with Arrays in JavaScript, JavaScript. Operator, page. (12 Hrs), precedence., 100. Practice with functions in, Program Control, JavaScript web page. (18 Hrs), Statements and loops in, 101. Practice with String, Math and, JavaScript., Date functions in JavaScript. (24, Arrays in JavaScript –, Hrs), concepts, types and usage., 102. Use online tool or open source, The String data type in, software to develop and edit web, JavaScript. Introduction to, pages containing Titles, different, String, Math and Date., font sizes and colours, frames, lists,, Introduction to Functions, tables, images, image map,, in JavaScript., controls, CSS, forms, hyperlinks, Built in JavaScript functions, etc., use web template to create a, overview., web page of various styles. (36 Hrs), Concepts of Pop Up boxes, 103. Develop a simple web project, , 26
Page 27 :
using HTML, JavaScript and host, it in IIS and a registered domain., (36 Hrs), , 34 - 41, , Develop, simple spread, sheets by, embedding, VBA., , Programming with VBA, 104. Practice with basic functions of, VBA Editor. (3 Hrs), 105. Use form controls like buttons,, Check boxes, Labels, Combo Box,, Group Box, List Box, Option, Button, Scroll Bar and Spin, button. (12 Hrs), 106. Modify object properties in VBA, program. (6 Hrs), 107. Write simple programs involving, VBA Data types, Variables,, Operators and Constants. (18, Hrs), 108. Create Message boxes and Input, boxes in VBA. (6 Hrs), 109. Work, with, conditional, statements like if, Else-if, and, Select. (12 Hrs), 110. Practice with Loop, Loop Control, and Case statements in VBA. (15, Hrs), 111. Create and Manipulate Arrays in, VBA. (12 Hrs), 112. Practice with string variables in, VBA programming. (12 Hrs), 113. Write, programs, involving, Mathematical, Conversion, Date, and String Functions in VBA. (18, Hrs), 114. Create Functions, Procedures,, Passing Parameters and Using, Returned Data. (12 Hrs), 115. Practice with built in functions in, VBA programs. (12 Hrs), 116. Create and edit macros. (12 Hrs), 117. Write code to work with Excel in, VBA forms. (12 Hrs), 118. Practice with methods and events, , 27, , in JavaScript., Introduction to the, Document Object Model., Concepts of using, Animation and multimedia, files in Java Script., 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 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
Page 28 :
42 - 45 Maintain, accounts using, accounting, software., , 46, , Browse, select, and transact, using Ecommerce, websites, , in VBA Programming. (24 Hrs), control in Excel VBA., 119. Debug, Step through code,, Introduction to Debugging, Breakpoints, find and fix errors, Techniques., while debugging. (18 Hrs), 120. Develop a simple project, involving MS excel and VBA. (36, Hrs), Using Accounting Software, Using Accounting Software, 121. Practice Basic accounting with, Basics of Accounting,, tally interface. (12 Hrs), Golden Rules of, 122. Create Company, Account and, Accounting, Voucher, Voucher entry in Tally. (12 Hrs), Entry, Ledger Posting,, 123. Generate reports for Invoice, Bill,, Final Accounts, Profit & Loss account etc. (10 Hrs), Preparation., 124. Perform Cost Centre & Cost, Cash Book. Ratio Analysis,, Category management. (12 Hrs), Depreciation, Stock, 125. Create and manage budgeting, Management., systems. (12 Hrs), Analysis of VAT, Cash, 126. Create Scenario and Variance, Flow, Fund Flow, Analysis. (8 Hrs), Accounting., 127. Use Tally for Costing, Ratio, Introduction to Tally,, Analysis, Cash flow and Funds, features and Advantages., flow statements. (12 Hrs), Implementing accounts in, 128. Analyze and Manage Inventory, Tally., control. (10 Hrs), Double entry system of, 129. Perform Point of Sales and, book keeping., Taxation (VAT, Excise, Service, Budgeting Systems,, Tax). (8 Hrs), Scenario management, 130. Perform System Administration, and Variance Analysis., and use other Utilities. (8 Hrs), Costing Systems,, 131. Create users, take Backup &, Concepts of Ratios,, Restore of Company. (8 Hrs), Analysis of financial, 132. Use Multilingual Functionality in, statements., Tally. (8 Hrs), Inventory Basics, POS, Invoicing, TDS, TCS, FBT,, VAT & Service Tax., Tally Interface in Different, Languages., E Commerce, E Commerce Concepts, 133. Browse E-commerce websites viz., Introduction to Eebay, Amazon, flipkart, OLX, quikr, Commerce and, etc. and prepare comparative, advantages., statement of the main features of, Building business on, these sites. (8 Hrs), the net., 134. Upload products for selling in E-, , 28
Page 29 :
Commerce Sites and make online, purchase from E Commerce, sites.(14 Hrs), 135. Manage security issues in ECommerce, and, payment, operations. (8 Hrs), , 47, , 48-49, , 50-51, 52, , Secure, information, from Internet, by using cyber, security, concept., , 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 cyber, crimes., , , Cyber Security:, 136. Protect information, computers, and networks from viruses,, spyware and other malicious, code. (3 Hrs), 137. Provide firewall security for, Internet connection and Network, System. (6 Hrs), 138. Protect the computer against, various internet threats. (3 Hrs), 139. Make backup copies of important, file, data and information. (3 Hrs), 140. Secure your Wi-Fi networks using, password,, WEP,, WPA-PSK,, WPA2-PSK, 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 (1. Create and host a web site of atleast 6 web pages using, JavaScript containing interactive objects, functions etc. OR, 2. Create a project with Excel & VBA on Payroll Systems. OR, 3. 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.), Revision, Examination, , 29
Page 30 :
8. SYLLABUS - EMPLOYABILITY SKILL, Employability Skill - 1st Semester, 1. English Literacy, , Duration : 20 Hrs., Marks : 09, Accentuation, (mode, of, pronunciation), on, simple, words,, Diction (use, Pronunciation, of word and speech), Transformation of sentences, Voice change, Change of tense, Spellings., Functional Grammar, Reading and understanding simple sentences about self, work and, Reading, environment, Construction of simple sentences Writing, Writing, simple English, Speaking / Spoken English Speaking with preparation on self, on family, on friends/ classmates, on, know, picture reading gain confidence through role-playing, role, and discussions, on current happening job description, asking about someone's job habitual, actions. Cardinal (fundamental), (fundamental) numbers ordinal numbers. Taking, messages, passing messages on and filling in message forms Greeting and, introductions office hospitality, Resumes or curriculum vita essential parts,, letters of application reference to previous communication., 2. I.T. Literacy, Duration : 20 Hrs., Marks : 09, Introduction, Computer and its applications, Hardware and peripherals,, Basics of Computer, Switching on-Starting, on Starting and shutting down of computer., Basics, of, Operating, System, WINDOWS, The user interface of Windows OS,, Computer Operating, Create, Copy, Move and delete Files and Folders, Use of External memory, System, like pen drive, CD, DVD etc, Use of Common applications., Basic operating of Word Processing, Creating, opening and closing, Word processing and, Documents, use of shortcuts, Creating and Editing of Text, Formatting the, Worksheet, Text, Insertion & creation of Tables. Printing document., Basics of Excel worksheet, understanding basic commands, creating simple, worksheets, understanding sample worksheets,, worksheets, use of simple formulas and, functions, Printing of simple excel sheets., Basic of computer Networks (using real life examples), Definitions of Local, Computer Networking, Area Network (LAN), Wide Area Network (WAN), Internet, Concept of, and Internet, Internet, ernet (Network of Networks),, Meaning of World Wide Web (WWW), Web Browser, Web Site, Web page, and Search Engines. Accessing the Internet using Web Browser,, Downloading and Printing Web Pages, Opening an email account and use of, email. Social media sites and, an its implication., Information Security and antivirus tools, Do's and Don'ts in Information, Security, Awareness of IT - ACT, types of cyber crimes., 3. Communication Skills, Duration : 15 Hrs., Marks, : 07, Introduction to, Communication and its importance, Communication Skills, Principles of Effective communication, Types of communication - verbal, non verbal, written, email, talking on, , 30
Page 31 :
phone., Non verbal communication -characteristics, components-Para-language, Body language, Barriers to communication and dealing with barriers., Handling nervousness/ discomfort., Listening-hearing and listening, effective listening, barriers to effective, Listening Skills, listening guidelines for effective listening., Triple- A Listening - Attitude, Attention & Adjustment., Active Listening Skills., Motivational Training, Characteristics Essential to Achieving Success., The Power of Positive Attitude., Self awareness, Importance of Commitment, Ethics and Values, Ways to Motivate Oneself, Personal Goal setting and Employability Planning., Facing Interviews, Manners, Etiquettes, Dress code for an interview, Do's & Don'ts for an interview., Behavioral Skills, Problem Solving, Confidence Building, Attitude, nd, Employability Skill - 2 Semester, 4. Entrepreneurship Skills, , Duration : 15 Hrs., Marks, : 06, Entrepreneur - Entrepreneurship - Enterprises:-Conceptual issue, Concept of, Entrepreneurship vs. management, Entrepreneurial motivation., Entrepreneurship, Performance & Record, Role & Function of entrepreneurs in relation to the, enterprise & relation to the economy, Source of business ideas,, Entrepreneurial opportunities, The process of setting up a business., Qualities of a good Entrepreneur, SWOT and Risk Analysis. Concept &, Project Preparation &, application of PLC, Sales & distribution Management. Different Between, Marketing analysis, Small Scale & Large Scale Business, Market Survey, Method of marketing,, Publicity and advertisement, Marketing Mix., Preparation of Project. Role of Various Schemes and Institutes for selfInstitutions Support, employment i.e. DIC, SIDA, SISI, NSIC, SIDO, Idea for financing/ non, financing support agencies to familiarizes with the Policies /Programmes &, procedure & the available scheme., Project, formation, Feasibility, Legal formalities i.e., Shop Act, Estimation &, Investment Procurement, Costing, Investment procedure - Loan procurement - Banking Processes., 5. Productivity, Duration : 10 Hrs., Marks, : 05, Personal / Workman - Incentive, Production linked Bonus,, Benefits, Improvement in living standard., Skills, Working Aids, Automation, Environment, Motivation - How, Affecting Factors, improves or slows down., , 31
Page 32 :
Comparative productivity in developed countries (viz. Germany, Japan, and Australia) in selected industries e.g. Manufacturing, Steel, Mining,, Construction etc. Living standards of those countries, wages., Banking processes, Handling ATM, KYC registration, safe cash handling,, Personal Finance, Personal risk and Insurance., Management, 6. Occupational Safety, Health and Environment Education, Duration : 15 Hrs., Marks : 06, Introduction to Occupational Safety and Health importance of safety and, Safety & Health, health at workplace., Basic Hazards, Chemical Hazards, Vibroacoustic Hazards, Mechanical, Occupational Hazards, Hazards, Electrical Hazards, Thermal Hazards. Occupational health,, Occupational hygienic, Occupational Diseases/ Disorders & its prevention., Basic principles for protective equipment., Accident & safety, Accident Prevention techniques - control of accidents and safety measures., Care of injured & Sick at the workplaces, First-Aid & Transportation of sick, First Aid, person., Idea of basic provision legislation of India., Basic Provisions, safety, health, welfare under legislative of India., Introduction to Environment. Relationship between Society and, Ecosystem, Environment, Ecosystem and Factors causing imbalance., Pollution and pollutants including liquid, gaseous, solid and hazardous, Pollution, waste., Energy Conservation, Conservation of Energy, re-use and recycle., Global warming, Global warming, climate change and Ozone layer depletion., Ground Water, Hydrological cycle, ground and surface water, Conservation and Harvesting, of water., Environment, Right attitude towards environment, Maintenance of in -house, environment., 7. Labour Welfare Legislation, Duration : 05 Hrs., Marks, : 03, Welfare Acts, Benefits guaranteed under various acts- Factories Act, Apprenticeship Act,, Employees State Insurance Act (ESI), Payment Wages Act, Employees, Provident Fund Act, The Workmen's compensation Act., 8. Quality Tools, Duration : 10 Hrs., Marks : 05, Quality Consciousness, Meaning of quality, Quality characteristic., Quality Circles, Definition, Advantage of small group activity, objectives of quality Circle,, Roles and function of Quality Circles in Organization, Operation of Quality, circle. Approaches to starting Quality Circles, Steps for continuation Quality, Circles., Quality Management, Idea of ISO 9000 and BIS systems and its importance in maintaining, System, qualities., House Keeping, Purpose of House-keeping, Practice of good Housekeeping., Quality Tools, Basic quality tools with a few examples., Comparison with, developed countries, , 32
Page 33 :
ANNEXURE-I, LIST OF TOOLS & EQUIPMENT, COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, Sl. No., , Equipment/Tool, , Specification, , A. Trainees Tools/ Equipment, 1., Desktop Computer CPU: 32/64 Bit i3/i5, i3/i5/i7 or latest processor,, Speed: 3 GHz, or Higher. Cache Memory: - Minimum 3 MB or better., RAM: GB DDR-III, RAM:-8, III or Higher. Hard Disk Drive: 500GB or, Higher, 7200 rpm(minimum) or Higher, Wi-Fi, Wi Fi Enabled., Network Card: Integrated Gigabit, Ethernet(10/100/1000) - Wi-Fi,, Fi, USB Mouse, USB, U, Keyboard and Monitor (Min. 17 Inch), Standard Ports, and connectors., connectors. DVD Writer, Speakers And Mic., Licensed Windows Operating System / OEM, Pack(Preloaded), Antivirus / Total Security, 2., Laptop, 4th Gen Ci5 or higher Processor, 4GB RAM, 1TB Hard, Disk, Win8/latest, Win8, Preloaded Licensed OS, 2GB Graphics, Card, DVD, DVD Writer, Standard Ports And Connectors., 3., Wi–Fi Router, With Wireless Connectivity, 4., Switch, 24 Port, 5., Structured cabling, to enable working with Wired Networks for Practical, in Lab, 6., Internet, Broadband connection with min. 2 mbps speed, Connectivity, 7., Registered Domain at least 100, 10 MB Web Space, 8., Laser Printer, Colour A4 Size, 9., Network Laser, Monochrome A4 Size, Printer, 10. Optical Scanner, Flatbed A4, 11. Digital Web Cam, High Resolution(3.1 mp or higher), 12. DVD or Blu-Ray, 24X or higher external (usb), Writer, 13. LCD Projector, 3000 lumens or higher, , Quantity, , 10 Nos., , 01 No., , 01 No., 01 No., As required, As required, As required, 01 No., 01 No., 01 No., 04 Nos., 02 Nos., 01 No., , 14., , Projector Screen, , matte(antiglare) screen, , 01 No., , 15., , Online UPS, , 3KVA, KVA, , 02 Nos., , 16., , Crimping Tool, , RJ, RJ-45, , 05 Nos., , 17., , Network Rack, , 4U for 24 port, , 01 No., , 18., , Digital Multimeters, , 3.5 digit handheld type., , 04 Nos., , 19., , Screw Driver Set, , Standard, , 04 Sets, , 20., , Mini Dongle for, Bluetooth devices, Connection, , USB, , 04 Nos., , 33
Page 34 :
21., , Wired, , 05 Nos, , 22., , Headphone & mic., set, Sound System, , 2:1, , 01 No., , 23., , External Hard Disk, , 1 TB, , 02 Nos., , 24., , Patch Panel, , 24 Port, , 02 Nos., , 25., , LAN Tester, , UTP cat5 cable tester (RJ 45), , 05 Nos., , 26., , Punching Tool, , for punching RJ 45 socket with cat 5 cable, , 05 Nos., , B. Software, 27. MS Office, 28., , 29., 30., , 31., , Antivirus for –, clients /, workstations in, profile, Open Office or, equivalent, GIMP / IrfanView, Image editor or, equivalent, LINUX OS, , 2010 (professional) or the latest version available at the, time of procurement, validity of an year or more which should be renewed, upon expiry, , 11 Licenses, , Latest version, , Open source, software, Open source, software, , Latest version, , Latest version, , 32., , Web Authoring tool WYSIWYG Web Authoring tool- Dreamweaver or Open, Source tools like Kompozer, FrontPage or similar tools, along with FTP tools for ex. Filezilla etc., , 33., 34., , Tally, E Commerce, Simulation, Software, Web Server, , 35., , Open source, software, Proprietary, /Open source, software, , ERP 9 or Latest, Latest version, , 11 Licenses, Open source, software, , HTTP Web server / XAMPP or any other similar server, , Open source, software, , C. List Of Other Items/ Furniture, 36. Vacuum cleaner, Hand Held, , 01 No., , 37., , Pigeon hole cabinet 20 compartments, , 38., , Chair and table for, the instructor, , with armrest mounted on castor wheels, adjustable, , Dual Desk or Chair, and Tables for, Trainees, , Standard, , 39., , 11 Licenses, , 01 No., , height/Standard, , 34, , 01 each(for, class room &, laboratory), 10 / 20 Nos
Page 35 :
40., , Computer table, , 41., , Operators chair, , 42., , Printer table, , 43., , laminated top 150X650X750 mm with sliding tray for, key board and one shelf of storage, without arms mounted on castor wheels, adjustable, height, , 10 Nos., , 03 Nos., , Air conditioner, , 650X500X750 mm can be varied as per local, specifications, Split type 1.5 tons, , 44., , Storage cabinet, , 60X700X450mm, , 01Nos., , 45., , White Board, , minimum 4X6 feet, , 01 No., , 46., , Steel Almirah, , 2.5 m x 1.20 m x 0.5 m, , 01 No., , 47., , Fire Extinguisher, CO2, 48. Fire Buckets, D. Raw Materials, 49. White Board, Marker, 50. Duster Cloth, 51. Cleaning Liquid, 52. Photo Copy Paper, 53. Full Scape Paper, 54. Cartridges for, printer, 55. I/O Box with socket, 56. RJ 45 connector, 57. Optical Mouse, 58. Key Board, 59. SMPS, 60. CMOS Batteries, 61. Power Chord, 62. Cable, 63. Stapler, 64. Stapler, 65. Battery for remote, 66. Battery for clock, 67. Pen drive, 68. CDs, 69. DVDs, 70. Wall Clock, 71. Battery for LAN, tester, 72. Power Adapter, , 2 KG, , 20 Nos., , 03 Nos., , 02 Nos., , Standard size, , 02 Nos., , Assorted colour, , As required, , 2’/2’, 500 ml, A4, White, Colour/monochrome as per model of the printer, , As required, As required, As required, 02 reams, As required, , 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, , As required, 200 Pcs., As required, As required, As required, As required, As required, 100 meter, 02 pcs., 01 pcs., As required, As required, 02 Nos., 50 Nos, 50 Nos., 01 pcs., As required, , For Hub, Switch, Router, , As required, , 35
Page 36 :
ANNEXURE-II, FORMAT FOR INTERNAL ASSESSMENT, , Name & Address of the Assessor :, , Year of Enrollment :, , Name & Address of ITI (Govt./Pvt.) :, , Date of Assessment :, , Name & Address of the Industry :, , Assessment location: Industry / ITI, , Trade Name :, , Semester:, , Duration of the Trade/course:, , 1, 2, , 36, , Economical use of, materials, , 15, , 15, , Result (Y/N), , Skills to handle tools &, equipment, , 10, , Total internal assessment, Marks, , 5, , VIVA, , 10, , Quality in workmanship, , 10, , Speed in doing work, , 5, , Application of, Knowledge, , 10, Attendance/ Punctuality, , Father's/Mother’s, Name, , 5, Workplace hygiene, , Candidate Name, , 15, Safety consciousness, , Sl. No, , Maximum Marks (Total 100 Marks), , Ability to follow, Manuals/ Written, instructions, , Learning Outcome:
