COPA - TT (NSQF 2022) Book PDF

COMPUTER OPERATOR AND PROGRAMMING ASSISTANT NSQF LEVEL - 3 D E H...

COMPUTER OPERATOR AND PROGRAMMING ASSISTANT NSQF LEVEL - 3 D E H S TRADE THEORY LI B E I SECTOR: IT & ITES R IM U (As per revised syllabus July 2022 - 1200 hrs) P B ©N E O T DIRECTORATE GENERAL OF TRAINING MINISTRY OF SKILL DEVELOPMENT & ENTREPRENEURSHIP T GOVERNMENT OF INDIA O N NATIONAL INSTRUCTIONAL MEDIA INSTITUTE, CHENNAI Post Box No. 3142, CTI Campus, Guindy, Chennai - 600 032 (i) Sector : IT & ITES Duration : 1 Year Trade : COPA - Trade Theory - NSQF Level - 3 (Revised 2022) Developed & Published by D National Instructional Media Institute Post Box No.3142 Guindy, Chennai - 600 032 E INDIA Email: [email protected] H Website: www.nimi.gov.in S LI Copyright © 2022 National Instructional Media Institute, Chennai B E I First Edition : January 2023 Copies : 2,000 R IM U P B ©N Rs. 285/- E All rights reserved. O No part of this publication can be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording or any information storage and retrieval system, without permission in writing from the National Instructional Media Institute, Chennai. T T O N (ii)  FOREWORD The Government of India has set an ambitious target of imparting skills to 30 crores people, one out of every four Indians, by 2020 to help them secure jobs as part of the National Skills Development Policy. Industrial Training Institutes (ITIs) play a vital role in this process especially in terms of providing skilled manpower. Keeping this in mind, and for providing the current industry relevant skill training to Trainees, ITI syllabus has been recently updated with the help of Mentor Councils comprising various stakeholder's viz. Industries, D Entrepreneurs, Academicians and representatives from ITIs. E The National Instructional Media Institute (NIMI), Chennai has now come up with instructional material to suit the revised curriculum for COPA Trade Theory NSQF Level - 3 (Revised 2022) in H IT & ITES Sector. The NSQF Level - 3 Trade Practical will help the trainees to get an international equivalency standard where their skill proficiency and competency will be duly recognized across the globe and this will S also increase the scope of recognition of prior learning. NSQF Level - 3 trainees will also get the opportunities to promote life long learning and skill development. I have no doubt that with LI NSQF Level - 3 the trainers and trainees of ITIs, and all stakeholders will derive maximum benefits from these IMPs and that NIMI's effort will go a long way in improving the quality of Vocational training in the B E I country. R IM U The Executive Director & Staff of NIMI and members of Media Development Committee deserve appreciation for their contribution in bringing out this publication. P B ©N Jai Hind E O T Addl. Secretary/Director General (Training) Ministry of Skill Development & Entrepreneurship, Government of India. T O New Delhi - 110 001 N (iii)  PREFACE The National Instructional Media Institute (NIMI) was established in 1986 at Chennai by then Directorate General of Employment and Training (D.G.E & T), Ministry of Labour and Employment, (now under Ministry of Skill Development and Entrepreneurship) Government of India, with technical assistance from the Govt. of the Federal Republic of Germany. The prime objective of this institute is to develop and provide instructional materials for various trades as per the prescribed syllabi (NSQF LEVEL - 3) under the Craftsman and Apprenticeship Training Schemes. The instructional materials are created keeping in mind, the main objective of Vocational Training under D NCVT/NAC in India, which is to help an individual to master skills to do a job. The instructional materials are E generated in the form of Instructional Media Packages (IMPs). An IMP consists of Theory book, Practical book, Test and Assignment book, Instructor Guide, Audio Visual Aid (Wall charts and Transparencies) and H other support materials. S The trade practical book consists of series of exercises to be completed by the trainees in the workshop. These exercises are designed to ensure that all the skills in the prescribed syllabus are covered. The trade LI theory book provides related theoretical knowledge required to enable the trainee to do a job. The test and assignments will enable the instructor to give assignments for the evaluation of the performance of a trainee. B E I The wall charts and transparencies are unique, as they not only help the instructor to effectively present a R IM topic but also help him to assess the trainee's understanding. The instructor guide enables the instructor to U plan his schedule of instruction, plan the raw material requirements, day to day lessons and demonstrations. P B ©N In order to perform the skills in a productive manner instructional videos are embedded in QR code of the exercise in this instructional material so as to integrate the skill learning with the procedural practical steps given in the exercise. The instructional videos will improve the quality of standard on practical training and will motivate the trainees to focus and perform the skill seamlessly. IMPs also deals with the complex skills required to be developed for effective team work. Necessary care E has also been taken to include important skill areas of allied trades as prescribed in the syllabus. The availability of a complete Instructional Media Package in an institute helps both the trainer and management to impart effective training. O The IMPs are the outcome of collective efforts of the staff members of NIMI and the members of the Media Development Committees specially drawn from Public and Private sector industries, various training institutes T under the Directorate General of Training (DGT), Government and Private ITIs. T NIMI would like to take this opportunity to convey sincere thanks to the Directors of Employment & Training of various State Governments, Training Departments of Industries both in the Public and Private sectors, O Officers of DGT and DGT field institutes, proof readers, individual media developers and coordinators, but for whose active support NIMI would not have been able to bring out this materials. N Chennai - 600 032 EXECUTIVE DIRECTOR (iv)  ACKNOWLEDGEMENT National Instructional Media Institute (NIMI) sincerely acknowledges with thanks for the co-operation and contribution extended by the following Media Developers and their sponsoring organisations to bring out this Instructional Material (Trade Theory) for the trade of COPA (NSQF LEVEL - 3) (Revised 2022) under IT & ITES Sector for ITIs. MEDIA DEVELOPMENT COMMITTEE MEMBERS D Smt. M. Banumathy _ Assistant Training Officer, E Govt ITI, Ambattur. H Smt. V. Revathi _ Assistant Training Officer, Govt ITI, Coimbatore. S NIMI CO-ORDINATORS LI Shri.Nirmalya Nath - Deputy Director, NIMI- Chennai - 32. B E I R IM Shri.G. Michael Johny U _ Manager, NIMI, Chennai - 32 P B ©N NIMI records its appreciation for the Data Entry, CAD, DTP operators for their excellent and devoted services in the process of development of this Instructional Material. NIMI also acknowledges with thanks the invaluable efforts rendered by all other NIMI staff who have contributed towards the development of this Instructional Material. E NIMI is also grateful to everyone who has directly or indirectly helped in developing this Instructional Material. O T T O N (v)  INTRODUCTION TRADE PRACTICAL The trade practical manual is intented to be used in workshop. It consists of a series of practical exercises to be completed by the trainees during the course of the COPA Trade supplemented and supported by instructions/ informations to assist in performing the exercises. These exercises are designed to ensure that all the skills in compliance with NSQF LEVEL - 3 Module 1 - Safe Working Practices Module 22 - Manage Tables and Bulleted Text Module 2 - Assemble a Desktop PC Module 23 - Manage Graphic Elements Module 3 - Using Windows Operating System Module 24 - Manage Audio & Video Elements Module 4 - Computer Basics & Software Module 25 - Manage Transitions and Animations D Installation Module 26 - Manage Collaboration Module 5 - DOS Command Line Interface Module 27 - Demonstrate on MySQL E Module 6 - Install Ubuntu Linux operating system Module 28 - Demonstrate on Queries and execute basic Linux commands Module 29 - Demonstrate on Functions H Module 7 - Using Word Processing Software Module 30 - Set-up & Configure a Computer Module 8 - Format documents Network S Modfule 9 - Manage Tables and Lists Module 31 - Create Simple Static Web Pages using Module 10 - Create and Manage References HTML Tags LI Module 11 - Manage Graphic Elements Module 32 - JavaScript Embed JavaScript in Module 12 - Manage Document Collaboration HTML Pages B E I Module 13 - Manage Mailings Module 33 - Data Visualization or Analysis R IM using Excel Module 14 - Spread Sheet Application, Manage U Worksheets and Workbooks Module 34 - Browse E-Commerce Sites to Identify Products & Services Module 15 - Manage Data Cells and Ranges P Module 35 - Protect Information, Computers and B ©N Module 16 - Manage Tables and Table Data Networks from Viruses, Spyware and Module 17 - Perform Operations using Formulas other Malicious Code and Functions Module 36 - Cloud Computing Module 18 - Manage Charts Module 37 - Develop an application and perform the Module 19 - Manage Pivot Tables Application Development Life Cycle Module 20 - Power Point Presentations Module 38 to 42 - Elective Module I - Programming E Module 21 - Format Presentations in Python Module 38 to 42 - Elective Module II - Programming in JAVA The skill training in the shop floor is planned through a series of practical exercises centred around some practical O project. However, there are few instances where the individual exercise does not form a part of project. While developing the practical manual a sincere effort was made to prepare each exercise which will be easy to T understand and carry out even by below average trainee. However the development team accept that there is a scope for further improvement. NIMI, looks forward to the suggestions from the experienced training faculty for improving the manual. T TRADE THEORY O The manual of trade theory consists of theoretical information for the course of the COPA Trade. The contents are sequenced according to the practical exercise contained in the manual on Trade practical. Attempt has been N made to relate the theortical aspects with the skill covered in each exercise to the extent possible. This co-relation is maintained to help the trainees to develop the perceptional capabilities for performing the skills. The Trade theory has to be taught and learnt along with the corresponding exercise contained in the manual on trade practical. The indicating about the corresponding practical exercise are given in every sheet of this manual. It will be preferable to teach/learn the trade theory connected to each exercise atleast one class before performing the related skills in the shop floor. The trade theory is to be treated as an integrated part of each exercise. The material is not the purpose of self learning and should be considered as supplementary to class room instruction. (vi)  CONTENTS Lesson No. Title of the Lesson Learning Page No. Outcome Module 1 : Safe Working Practices 1 1.1.01&02 Electrical safety 1 1.1.03&04 Safety practice - fire extinguishers 2 Module 2 : Assemble a Desktop PC 1 1.2.05&06 Introduction to computers 7 Module 3 : Using Windows Operating System 1 D 1.3.07-13 Introduction to CPU architecture and motherboard 16 E Module 4 : Computer Basics & Software Installation 1.4.14 View the BIOS settings and their modifications 21 H 1.4.15 Install Windows operating system 29 1.4.16 Format hard disk and create partition 31 S 1 1.4.17 Identify and rectify common hardware and software issues during LI OS installation 35 1.4.18 Install necessary application software for Windows i.e. Office Package, PDF Reader, Media Player etc 39 B E I 1.4.19 Configure Bluetooth and Wi-Fi settings 40 R IM 1.4.20&21 U DVDs, CDs and burning DVDs Module 5 : DOS Command Line Interface 42 P B ©N 1.5.22 Use basic DOS commands for directory listing 1 44 1.5.23 Manage files and folders using DOS commands 47 Module 6 : Install Ubuntu Linux operating system and execute basic Linux commands 1 1.6.24&25 Introduction to Linux operating system 51 E 1.6.26-29 Handling commands and various editors 55 Module 7 : Using Word Processing Software 2 1.7.30-33 MS WORD 2010 THEORY 79 Module 8 : Format documents O 2 1.8.34-36 Insert, format text and paragraphs, Create and configure document T sections 88 Module 9 : Manage Tables and Lists 2 T 1.9.37-39 Create, modify tables 90 Module 10 : Create and Manage References O 2 1.10.40&41 Create and manage reference elements and tables 92 N Module 11 : Manage Graphic Elements 2 1.11.42-45 Insert, format illustrations and text boxes 93 Module 12 : Manage Document Collaboration 1.12.46&47 Manage comments change tracking and mailings 2 94 (vii) Lesson No. Title of the Lesson Learning Page No. Outcome Module 13 : Manage Mailings 2 1.13.48 Perform mail merge 98 Module 14 : Spread Sheet Application, Manage Worksheets and Workbooks 3 1.14.49-54 Open files in MS Excel 101 Module 15: Manage Data Cells and Ranges 3 1.15.55-57 Manipulate data 102 Module 16: Manage Tables and Table Data D 3 1.16.58-60 Create and format tables 104 E Module 17: Perform Operations using Formulas and Functions 3 H 1.17.61-63 Functions and formulas in MS-Excel 2010 105 Module 18: Manage Mailings S 3 1.18.64-66 Manage Charts 110 LI Module 19: Manage Pivot Tables 3 1.19.67 Create Pivot Tables 112 B E I Module 20: Power Point Presentations 4 R IM 1.20.68-74 Open files in MS PowerPoint Presentations U 113 Module 21: Format Presentations 4 P 1.21.75-77 IInsert, Format text and paragraphs 114 B ©N Module 22: Manage Tables and Bulleted Text 4 1.22.78-80 Create tables, modify tables, modify bulleted text 115 Module 23: Manage Graphic Elements 4 1.23.81-83 Insert illustrations, Format illustrations and text boxes 116 E Module 24: Manage Audio & Video Elements 4 1.24.84&85 Audio & Video Elements 118 Module 25: Manage Transitions and Animations 4 O 1.25.86&87 Add slide transitions & animations 119 Module 26: Manage Collaboration 4 T 1.26.88 Add and manage comments 120 Module 27: Demonstrate on MySQL T 1.27.89-91 Install, Troubleshoot, Create and Use of database in MySQL 5 121 O 1.27.92-96 Designing database using normalization rules,various datatypes, data integrity,DDL,DML&DCL Statements Enforcing Primary key and Foreign key 123 N Module 28: Demonstrate on Queries 5 1.28.97&98 Insert and delete queries Update queries 125 Module 29: Demonstrate on Functions 5 1.29.99&100 Using the Number, Date and Character functions, group by having, sub query 126 (viii) Lesson No. Title of the Lesson Learning Page No. Outcome Module 30: Set-up & Configure a Computer Network 6 1.30.101-112 Connect a computer to a network and share Devices i.e. Printers, files, folders and drives 128 Module 31: Create Simple Static Web Pages using HTML Tags 1.31.113 Web designing 7 137 1.31.114 Introduction to CMS and web authoring tools 156 Module 32: JavaScript Embed JavaScript in HTML Pages 1.32.115 Understanding JavaScript 158 D 1.32.116&117 Using JavaScript Variable and data types 162 8 1.32.118 Control statements, Loops and Popup boxes in JavaScript 169 E 1.32.119 Arrays in JavaScript 175 H 1.32.120 Develop dynamic HTML pages using JavaScript 182 1.32.121 Deploy web project using IIS 198 S Module 33: Data Visualization or Analysis using Excel 9 LI 1.33.122-129 Create advanced formulas and macros 205 Module 34: Browse E-Commerce Sites to Identify Products & Services B E I 1.34.130-132 E-Commerce scope and benefits 211 R IM U 10 1.34.133 Undertake transactions on an e-commerce site 213 1.34.134-137 E-Commerce Security issues and Payment Gateways 214 P B ©N Module 35: Protect Information, Computers and Networks from Viruses, Spyware and other Malicious Code 11 1.35.138 Overview of information security and threats 216 1.35.139 Privacy Protection and IT Act 245 Module 36: Cloud Computing 12 E 1.36.140-143 Working with Cloud Services 250 Module 37: Develop an application and perform the Application Development Life Cycle 12 1.37.144&145 Identify Phases of the Application Development Life Cycle 254 O Module 38 to 42 : Elective Module I - Programming in Python 1.38.01&02 Programming language (Python) Use Python from command line 258 T 1.39.03-05 Perform Operations using Data Types and Operators 13 260 1.40.06&07 Control Flow with Decisions and Loops 264 T 1.41.08&09 Document and Structure Code 267 O 1.42.10&11 Perform Operations Using Modules and Tools 283 Module 38 to 42: Elective Module II Programming in JAVA N 1.38.01-03 Object Oriented Programming and JAVA Language 287 1.39.04-07 Demonstrate writing JAVA programs 14 291 1.40.08-16 JAVA Program Flow Control 304 1.41.17-23 JAVA Classes, Overloading and Inheritance 309 1.42.24-30 Abstract Classes and Interfaces in JAVA 316 (ix)  LEARNING / ASSESSABLE OUTCOME On completion of this book you shall be able to S.No. Learning Outcome Ref. Ex.No. 1 Install and setup operating system and related software in a computer following safety precautions. (Mapped NOS: SSC/N3022) 1.1.01 - 1.6.29 2 Create, format, and edit document using word processing application software.(Mapped NOS: SSC/N3022) 1.7.30 - 1.13.48 3 Create, format, edit and develop a workbook by using spreadsheet application software. (Mapped NOS: SSC/N3022) 1.14.49 - 1.19.67 4 Create and customize slides for presentation. (Mapped NOS: SSC/N3022) 1.20.68 - 1.26.88 D 5 Create and manage database file by using MySQL. (NOS: SSC/N9401) 1.27.89 - 1.29.100 6 Install, setup/configure, troubleshoot, and secure computer network E including Internet. (Mapped NOS: SSC/N3022) 1.30.101 - 1.30.112 7 Develop web pages using HTML and CSS. (Mapped NOS: SSC/N0503, H SSC/N0501) 1.31.113 - 1.31.114 8 Develop web pages using JavaScript. (Mapped NOS: SSC/N0503, S SSC/N0501) 1.32.115 - 1.32.121 9 Create workbooks with advanced formulas, macros, charts, pivot tables LI and demonstrate ability to use Power tools. (NOS: SSC/N9402) 1.33.122 - 1.33.129 10 Browse, select, and transact using E- commerce websites (NOS: SSC/N9403) 1.34.130 - 1.34.137 B E I 11 Secure information from Internet by using cyber security concept. R IM (NOS: SSC/N9404) U 1.35.138 - 1.35.139 12 Explain Cloud concepts &services and Describe Application Development Life Cycle. (NOS: SSC/N9405) 1.36.140 - 1.37.145 P B ©N 13 Write programs using Python language. ( NOS: SSC/N9406) 1.38.01 - 1.42.11 14 Writing programs using JAVA. (SSC/N9407) 1.38.01 - 1.42.30 SYLLABUS Duration Reference Learning Professional Skills Professional Knowledge E Outcome (Trade Practical) (Trade Theory) with Indicative hours Professional Install and setup Safe working practices (10 Hrs) Introduction to Computers (3 Hrs) Skill- 94 Hrs; operating system and 1. Visit COPA Lab. of the institutes Safe working practices related software in a and locate the electrical O Professional Scope of the COPA trade. computer following safety connections with computer Safety rules and safety Knowledge - precautions. (Mapped system setup. (3 Hrs) signs. T 32 Hrs NOS: SSC/N3022) 2. Identifying safety symbols and Types and working of fire hazard identification. (3 Hrs) extinguishers. Introduction to 3. Practice safe methods of fire T Computer components fighting in case of electrical fire. (2 Hrs) Introduction to computer O 4. Use of fire extinguishers. (2Hrs) system (4 Hrs) Assemble a Desktop PC (8 hrs) Concepts of Hardware N 5. Identify computer peripherals and and Software. internal components of a Function of mother desktop computer. (4 Hrs) board components and various 6. Assemble components of processors. desktop computer. (4 Hrs) Various Input/ Output Using Windows Operating devices in use and their features Systems (20 hrs) Introduction Windows Operating 7. Practice on Windows interface System (9 Hrs) and navigating windows. (3 Hrs) (x)  8. Practice on managing files and Introduction to operating System folders using removable drives. (4 Main features of Windows OS Hrs) Concept of various shortcut 9. Customize the desktop (2 hrs) commands. 10.Settings and manage Introduction to the booting user accounts. (1 Hr) process (6 Hrs) 11. View system properties and Introduction to various types of control panel details. (3 Hrs) memories and their features. 12.Work with keyboard shortcut Basic Hardware and software commands. (4 Hrs) issues and their solutions. 13.Print and scan document using Usage of Application different commands. (3 Hrs) software and Antivirus. Computer basics a n d Software Installation (20 Hrs) Introduction to DOS Command D 14.View the BIOS settings and their Line Interface & Linux Operating modifications. (3 Hrs) Systems (10 Hrs) E 15.Install Windows operating system. Introduction to basic DOS Internal (4 Hrs) and External Commands. H 16.Format hard disk and create Introduction to Open S o u r c e partition. (3 Hrs) Software S 17.Identify and rectify common Introduction to Linux Operating hardware and software issues System features, structure, files LI during OS installation. (3 Hrs) and processes 18.Install necessary application Basic Linux commands. software for Windows i.e. Office B E I Package, PDF Reader, Media Player etc. (2 Hrs) R IM 19.Configure Bluetooth and Wi-Fi Usettings. (1 Hr) 20.Install Drivers for printer, scanner, P B ©N webcam and DVD etc. (2 Hrs) 21.Burn data, video and audio files on CD/DVD using application software. (2 Hrs) DOS Command Line Interface (9Hrs) 22.Use basic DOS commands for E directory listing. (5 Hrs) 23.Manage files and folders using DOS commands. (4 Hrs) Install Ubuntu Linux operating system and execute basic Linux O commands (27 Hrs) 24.Installation of Ubuntu Linux T operating system (6 Hrs) 25.Install necessary application software for Linux i.e. Office T Package, PDF Reader, Media Player etc. (4 Hrs) O 26.Use Basic Linux commands for directory listing, file and folder management, password etc. (6 N Hrs) 27.Use the Linux graphical user interface for file and folder management, exploring the system etc. (6 Hrs) 28.Customize desktop settings and manage user accounts in Linux. (3 Hrs) (xi)  29. View system properties and manage system setting in Linux. (2 Hrs) Professional Create, format, Using Word Processing Software (47 Using Word Processing Software (14 Skill - and edit document hrs) Hrs) 47 Hrs.; using word Manage documents (11 Hrs.) Introduction to the various applications processing 30.Navigate within documents (2 Hrs) in MS office. Professional application Search for text Introduction to Word features, Knowledge - software. (Mapped Link to locations within Office button, toolbars. 14 Hrs NOS: SSC/N3022) documents Creating, saving and formatting and Move to specific locations and objects printing documents using Word. in documents Working with objects, macro, mail Show and hide formatting symbols merge, templates and other tools in and hidden text D Word. 31.Format documents (4.6 Hrs) Set up document pages E Apply style sets Insert and modify headers and footers H Configure page background elements 32.Save and share documents (2 Hrs) S Savedocuments in alternative file formats LI Modify basic d o c u m e n t properties Modify print settings B E I Share d o c u m e n t s R IM electronically U 33.Inspect documents for issues (2.4 Hrs) P Locate and remove hidden properties B ©N and personal information Locate and c o r r e c t accessibility issues Locate and c o r r e c t compatibility issues Format documents (8 Hrs.) 34.Insert text and paragraphs (2 Hrs) E Find and replace text Insert symbols and special characters 35.Format text and paragraphs (3 Hrs) Apply text effects Apply formatting by using Format O Painter Set line and paragraph T spacing and indentation Apply built-in styles to text Clear formatting T 36.Create and configure document sections (3 Hrs) O Format text in multiple columns N Insert page, section, a n d column breaks Change page setup options for a section Manage tables and lists (9.5 Hrs) 37.Create tables (3 Hrs) Convert text to tables Convert tables to text (xii)  Create tables by specifying rows and columns 38.Modify tables (3 Hrs) Sort table data Configure cell margins and spacing Merge and split cells Resize tables, rows, a n d columns Split tables Configure a repeating row header 39.Create and modify lists (3.5 Hrs) Format paragraphs as numbered and bulleted lists Change bullet characters and number D formats Define custom bullet characters and E number formats Increase and decrease list levels H Restart and continue list numbering Set starting number values Create and manage references (3 Hrs.) S 40.Create and manage reference elements (1.4 Hrs) LI Insert footnotes a n d endnotes Modify footnote and endnote B E I properties R IM Create U and m o d i f y bibliography citation sources Insert citations f o r P B ©N bibliographies 41.Create and manage reference tables (1.6 Hrs) Insert tables of contents Customize tables of contents Insert bibliographies Manage graphic elements (8.5 Hrs.) E 42.Insert illustrations and text boxes (3 Hrs) Insert shapes Insert pictures Insert 3D models O Insert Smart Art graphics Insert screenshots and screen clippings T Insert text boxes 43.Format illustrations and text boxes T (3 Hrs) Apply artistic effects O Apply picture effects a n d picture styles Remove picture backgrounds N Format graphic elements Format SmartArt graphics Format 3D models 44.Add text to graphic elements (1 Hr) Add and modify text in text boxes Add and modify text in shapes " Add and modify SmartArt graphic content (xiii)  45.Modify graphic elements (1.5 Hrs) Position objects Wrap text around objects Add alternative text t o objects for accessibility Manage document collaboration (3.5 Hrs.) 46.Add and manage comments (1 Hrs) Add comments Review and reply t o comments Resolve comments Delete comments 47.Manage change tracking (2.5 Hrs) D Track changes Review tracked changes E Accept and reject tracked changes Lockand unlock c h a n g e H tracking Manage Mailings (3.5 Hrs) S 48.Perform mail merge (3.5 Hrs) Create envelopes LI Create labels Create a new mailing list Perform mail merge using an existing B E I list R IM Professional Create, format, edit Spread Sheet Application (72 Hrs) U Spread Sheet Application (18 Hrs) Skill - 72 and develop a Manage Worksheets and Workbooks Introduction to Excel features and Data Hrs.; workbook by using (12 Hrs.) Types. P spreadsheet 49.Open files in MS Excel (1.5 Hrs) Cell referencing and linking Sheets. B ©N Professional application Open MS Excel Introduction to various functions in all Knowledge - software. (Mapped Create a new Excel file categories of Excel. 18 Hrs NOS: SSC/N3022) Create a new Excel file from a Concepts of sorting, filtering a n d template validating data. Open an existing Excel file Analyzing data using charts, data 50.Import data (1.5 Hrs) tables, pivot tables, goal seek and E Import data from txt files scenarios Import data from csv files 51.Navigate within workbooks (2 Hrs) Search data Navigate to named cells, ranges or workbook elements O Insert and remove hyperlinks 52.Format worksheets and T workbooks (2 Hrs) Modify page setup Adjust row height and column width T Customize headers and footers 53.Customize options and views O (3 Hrs) Display and modify content in N different views Freeze rows and columns Change window views Modify basic w o r k b o o k properties Display formulas (xiv)  54.Configure contentf o r collaboration (2 Hrs) Set a print area Save workbooks in alternative file formats Configure print settings Manage data cells and ranges (12 Hrs.) 55.Manipulate data (3 Hrs) Paste data by using special paste options Fill cells by using Auto Fill Insert and delete multiple columns or rows Insert and delete cells D 56.Format cells and ranges (5 Hrs) Merge and Unmerge cells E Modify cell alignment, orientation and indentation H Format cells using Format Painter Wrap text within cells S Apply number formats Apply cell formats from the Format LI cells dialog box Apply cell styles Clear cell formatting B E I 57.Define and reference named ranges (4 Hrs) R IM U Define a named range Name a table Summarize data visually Insert P B ©N spark lines Apply built in conditional formatting Remove conditional formatting Manage tables and table data (12 Hrs.) 58.Create and format tables (4 hrs) Create excel tables from cell ranges E Apply table styles Convert tables to cell ranges 59.Manage tables and table data (5 Hrs) Add or remove table rows and columns Configure table style options O Insert and configure total rows 60.Filter and sort table data (3 Hrs) T Filter records Sort data by multiple columns Perform operations using formulas and T functions (12 Hrs.) 61. Insert references (3 Hrs) O Insert relative, absolute and mixed references Reference named ranges and named N tables in formulas 62.Calculate and transform data (5 Hrs) Perform calculations using AVERAGE(), MIN(), MAX() and SUM() Count cells by using COUNT(), COUNTIF() and COUNTBLANK() Perform conditional operations by (xv)  using the IF() function 63.Format and modify text(4 Hrs) Format text u s i n g RIGHT(),LEFT() and MID() functions Format text using UPPER(), LOWER() and LEN() functions Format text using CONCAT() and TEXTJOIN() functions Manage Charts (12 Hrs.) 64.Create Charts (3 Hrs) Create charts Create chart sheets 65.Modify charts (4 Hrs) Add data series to charts D Switch between rows and columns in source data E Add and modify chart elements Add trend lines to chart H 66.Format charts (5 Hrs) Apply chart layouts S Apply chart styles Add alternative text to charts for LI accessibility Manage Pivot Tables (12 Hrs.) 67.Create Pivot Tables(12 Hrs) B E I Create Pivot tables from cell ranges R IM Manipulate fields (columns) to get U desired analysis Use Filters for pivot tables Represent data as Count, Sum, P B ©N Average & % of row / column Group data in Columns & rows for aggregate reports Professional Create and Power point Presentations (9.5 Hrs.) Power point Presentations (13 Hrs.) Skill - 53 customize slides for 68. Open files in MS PowerPoint Image editing, Presentations Hrs; presentation. (1 Hr) Introduction to Open Office. E (Mapped NOS: Open MS PowerPoint Introduction to the properties a n d Professional SSC/N3022) Create a new PowerPoint file editing of images. Knowledge - Create a new PowerPoint file from a 13 Hrs Introduction to different formats of template images and their uses. Open an existing PowerPoint file Introduction to Power Point and its 69.Format P o w e r P o i n t O advantages. Presentations (1.5 Hrs) Add slides Creating Slide Shows. T Add titles and text Fine tuning the presentation and good Select slide layouts presentation technique Add PowerPoint templates T Duplicate slides 70.Modify slide masters, handout O masters, and note masters (2 Hrs) Change the slide N master theme or background Modify slide master content Modify slide layouts 71.Change presentation options and views (1.5 Hrs) Change slide size Display presentations i n different views (xvi)  72.Save and share PowerPoint Presentations (1.5 Hrs) Savepresentations in alternative file formats Configure different Print settings Share presentations electronically 73.Configure and present slide shows (1 Hr) Hide unwanted slides while presenting Configure slide show options Present slide shows by using Presenter View D 74.Prepare presentations f o r collaboration (1 Hrs) E Protect presentations b y using passwords H Export presentations to other formats Format presentations (6.5 Hrs.) S 75.Insert text and paragraphs (2 Hrs) Find and replace text LI Insert symbols and special characters 76.Format text and paragraphs (2 B E I Hrs) R IM Apply text effects U Apply formatting by using Format Painter Set line and paragraph P B ©N spacing and indentation Apply built-in styles to text 77.Create and configure sections (2.5 Hrs) Format text in multiple columns Text and image presentation styles E Clear formatting Manage tables and bulleted text (8 Hrs) 78.Create tables (3 Hrs) Insert tables in PowerPoint O Apply built-in table styles Create tables by specifying rows and T columns 79.Modify tables (3 Hrs) Insert and delete table rows and T columns Configure cell margins and spacing O Merge and split cells Resize tables, rows, a n d N columns 80.Create and modify bulleted text (2 Hrs) Format paragraphs a s numbered and bulleted lists Change bullet characters and number formats Increase and decrease list indents (xvii)  Set starting number values Restart and continue list numbering on different slides Create and manage reference elements (hyperlinks) (1.25 Hrs) Create hyperlinks within presentations Create hyperlinks in presentations for files and other sources Manage graphic elements (11.5 Hrs) 81.Insert illustrations and text boxes (3.5 Hrs) Insert shapes Insert pictures D Insert SmartArt graphics Insert screenshots and screen E clippings 82.Format illustrations and text H boxes (4 Hrs) Apply artistic effects S Apply picture effects a n d picture styles LI Remove picture backgrounds Crop images Format graphic elements B E I Format SmartArt graphics 83.Add and modify text in graphic R IM elements (4 Hrs) U Add and modify text in text boxes Add and modify text in shapes P B ©N Add and modify SmartArt graphic text Create, insert and modify charts Manage Audio & Video elements (6.5 Hrs) 84.Add Audio elements (2 Hrs) Import audio files i n presentations E Configure audio p l a y b a c k options 85.Add Video elements (4.5 Hrs) Import video files i n presentations O Resize video to fit slide Configure video p l a y b a c k T options Manage transitions and animations (9 Hrs) T 86.Add slide transitions (5 Hrs) Add same slide transition for all slides O Set transition effect duration Configure transition start and finish options N Customise select s l i d e transitions 87.Add animations (4 Hrs) Animate text and graphic elements Order shapes, images, and text boxes Group shapes, images, and text boxes (xviii)  Configure animation effects Configure animation paths Reorder animations on a slide Manage collaboration (0.75 Hrs) 88.Add and manage comments (0.75 Hrs) Add comments Review and reply t o comments Professional Create and manage Demonstrate on (15 Hrs.) Database Concepts (4 Hrs.) Skill - 53 89.Installation of MySQL. (1 Hr) Concept of DBMS, RDBMS. database file Hrs.; 90.Troubleshooting basic installation Data Models, Concept of DBA, Database by using MySQL. issues. (1 Hr) Users. Professional (NOS: SSC/N9401) Knowledge - 91.Creation and use of database. (3 Hr) Database Schema. 92.Designing of tables. (3 Hr) D 13 Hrs Designing Database using Normalization 93.Applying data integrity rules. (2 Hr) Rules. 94.Using the DDL, DCL and DML E Various data types Data integrity, DDL statements. (2 Hrs) DML and DCL statements. 95. Enforcing constraints, H Enforcing Primary key and foreign key. primary key and foreign key. (2 Hrs) 96. Adding indices to Tables. (1 Hr) Adding Indices. S Demonstrate on (15 Hrs) Queries (4 Hrs) 97.Simple select queries. (5 Hrs) Concepts of Transactions LI 98.Insert and delete queries Update ACID Property of Transaction queries. (10 Hrs) Constraints. Demonstrate on (23 Hrs) Joins and Functions (5 Hrs) B E I 99. Using the Number, Date and Joining of tables R IM U Character functions. Joins Sub Queries " Functions used in and Functions (11.5 Hrs) query like sum, average, max, min, 100. Joins, Group by, Having, Sub count etc. P query. (11.5 Hrs) B ©N Professional Install, setup/ Computer Network (68 Hrs.) Set-up & Communicating in a Connected World Skill - 68 c o n f i g u r e , configure a Computer Network (12 Hrs.) Hrs; troubleshoot, and (48 Hrs.) Local Networks, secure computer 101. View Network connections. (2 Communicating on a Local Network, Professional network including Hrs) Principles of Communications, Knowledge - Internet. (Mapped 102. Connect a computer to a network How do Ethernet Networks Work?, 16 Hrs E NOS: SSC/N3022) and share Devices i.e. Printers, files, How are Networks Built?, folders and drives. (4 Hrs) Routing Across Networks 103. Work with various Network devices, connectors and cables. Explain how end- user devices and local Create straight and cross cable and networks interact with the global Internet. punch a UTP cable in the patch Communicating in a Connected World O socket and test the connectivity. Explain the concept of network (4 Hrs) communication. T 104. Practice IP Addressing and Local Networks Explain the roles of Subnet masking for IPV4/ IPV6 and devices in a network. pinging to test networks. (4 Hrs) What Does a Home Network Look Like? T 105. Configure Hub and Switch. (4 Hrs) How Does Wi-Fi Work? 106. Set up and configure wired and Introduction to LAN Devices, O wireless LAN in a Computer Lab Internetworking Devices, within at least three computers. (6 Internet Concepts (4 Hrs) N Hrs) Introduction to www, Concept of Internet, 107. Use patch panel & I/O Box for Web Browsers, internet servers and wired LAN and installing & configuring search engines. Internet connection in a single PC and in a LAN. (6 Hrs) Concepts of Domain naming Systems 108. Set up a proxy server/ DHCP and E mail communication. Server with firewall. (8 Hrs) Introduction to video chatting tools and 109. Set up video conferencing using Social Networking concepts. open-source software. (4 Hrs) (xix)  110. Use various tools (by open source /free) for network troubleshooting, maintenance and security for both Wired and Wireless (6 Hrs) 111. Set up Internet access & communication (10 Hrs) Set-up internet connectivity Set-up digital communication 112. Use the Internet (10 Hrs) Browse the Internet Use e-mail Use Social Media Use the phone for online activities Professional Develop web pages Create simple static web pages using Web Design Concepts (17 Hrs) D Skill - 67 using HTML and HTML tags (67 Hrs.) Concepts of Static and Dynamic Web Hrs; CSS. (Mapped 113. Practice HTML (46 Hrs) pages. E NOS: SSC/N0503, Practice with basic HTML elements Introduction to HTML and various tags Professional SSC/N0501) (e.g. head, title, body), tag and in HTML. H Knowledge - attributes. Concepts of different controls used 17 Hrs Design simple web page with text, in Web Pages. S paragraph and line break using HTML Concepts of CSS and applying CSS to tags HTML. LI Format text, change background Introduction to open source CMS viz, colour and insert pictures in web page Joomla, Word press etc. and Web Design simple web page with tables authoring tools viz. Kompozer, B E I and lists. WordPress, Front Page etc. R IM Use marquees, hyperlinks and mail U to link in designing web pages Create frames, add style and design layout. P B ©N Display a web page within a web page using iframes. Insert text, check and combo box in web page. Design web page using password field, submit button Reset button and radio button etc. E Design a web page adding flash file, audio and video files. Design web page with forms and form controls using HTML tags 114. Create simple static web pages O using CSS (21 Hrs ) CSS syntax, Adding colors, fonts, T backgrounds, images borders, text alignment, text transformation, Lists etc. T 3 types of CSS Adding a Navigation Bars(vertical/ O horizontal bars) CSS drop downs & Forms CSS counters and website layout, N Multiple backgrounds & Putting the stylesheet in a separate file CSS Animations & CSS Buttons Professional Develop web pages JavaScript (173 Hrs) Introduction to JavaScript (35 Hrs) Skill - 173 using JavaScript. Embed JavaScript in HTML Pages Introduction to Programming Hrs; (Mapped NOS: (127 Hrs) and Scripting Languages. (xx) Professional SSC/N0503, SSC/ 115. Practicing the JavaScript in Introduction to JavaScript and its Knowledge N0501) creating dynamic HTML pages. (53 application for the web. - 35 Hrs Hrs) Introduction to Web Servers and their 116. Embed JavaScript in HTML to features. Display Information in Web pages. JavaScript Basics - Data types, (31 Hrs) Variables, Constants 117. Use error handling techniques in and Conversion between JavaScript. (11 Hrs) data types. 118. Use objects and classes in Arithmetic, Comparison, Logical JavaScript. (31 Hrs) Operators in JavaScript. Operator 119. Describe Animation and precedence. Multimedia using JavaScript. (1 Hr) Program Control Statements and loops Create a dynamic website using an open- in JavaScript. source tool (40 Hrs) Arrays in JavaScript - concepts, types D 120. Develop dynamic HTML pages and usage. using JavaScript. The String data type in E Deploy a simple web project (6 Hrs) JavaScript. Introduction to String, Math 121. Deploy web project using IIS. and Date. H Introduction to Functions i n JavaScript. S Built in JavaScript functions overview. Concepts of Pop Up boxes in LI JavaScript. Introduction to the Document Object Model. B Concepts of using Animation a n d E I multimedia files in Java Script. R IM Skill - 73 with U Professional Create workbooks Data Visualization or analysis using advanced Excel - (73 Hrs) Advanced Excel Concepts - Theory- (17 Hrs) P Hrs formulas, macros, Create advanced formulas and MS excel revision (row, columns, basic B ©N charts, pivot tables macros (24 Hrs) formatting, insert menu, Print setup, etc. Professional and demonstrate 122. Create and modify simple macros ) and Look up introduction and functions Knowledge - ability to use Power (6 Hrs) Types of references and cell naming 17 Hrs tools. (NOS: SSC/ 123. Perform form controls and create Excel Linkage Custom Format and N9402) simple data entry form with macros. Excel Protection (6 Hrs) Tips and tricks E 124. Look up data by using functions. Pivot table and Pivot chart (6 Hrs) Conditional formatting 125. Use advanced date functions.(6 Hrs) Advanced Graphs Manage advanced charts and tables Power Queries (21 hrs) O 126. Create and modify advanced charts. (10 Hrs) T 127. Create and m o d i f y PivotTables. (11 Hrs) Use Power Query and Power BI T (24 Hrs) 128. Create a Power Query, Power O Query Function. Invoking the Power Query function and combining queries. N Organize the workbook queries (12 Hrs) 129. Use Power BI for simple data visualizations. (12 Hrs) Make a dashboard in Excel (4 Hrs) (xxi) Professional Browse, select, and Browse e-Commerce sites to identify e-Commerce (10 Hrs) Skill - transact using E- products & services (6.5 Hrs) Introduction to E Commerce and 25hrs; c o m m e r c e 130. Demonstrate e-Commerce advantages. websites(NOS: sites. (1.5 Hrs) Building business on the net. Professional SSC/N9403) 131. List features of e-commerce sites. Payment and Order Processing, Knowledge - (2 Hrs) Authorization, Chargeback a n d 10 Hrs. 132. Use e-commerce sites otherpayment methods. to source an item. (3 Hrs) Security issues and payment gateways. Shop online (4.5 Hrs) 133. Undertake transactions on an e- commerce site. (4.5 Hrs) Manage e-commerce operations (14 Hrs) 134. Add products to D an ecommerce website. (4 Hrs) 135. Practice order processing. (3 Hrs) E 136. Practice payment processing. (4.5 Hrs) H 137. Identify common security issues. (3.5 Hrs ) S Professional Secure information 138. Protect information, Cyber Security (10 Hrs) Skill - 20 from Internet by computers and networks from Overview of Information LI Hrs using cyber security viruses, spyware and other Security, SSL, HTTPS, Security concept. (NOS: malicious code (19 Hrs) threats, information Security vulnerability Professional SSC/N9404) Explain Cyber security (2 Hrs) and Risk management. Knowledge - B E I Secure computers & Introduction to Directory Services, 10 Hrs. R IM the network (5.5 Hrs) Access Control, Security, Privacy U Reduce cyber security threats (2 Hrs) Secure a Wi-Fi Network (4 Hrs) protection, Audit and Security. Introduction to IT Act and penalties for Use Anti-Virus software (3 Hrs) P cybercrimes. B ©N Perform back-ups of files, data & information (2.5 Hrs) 139. Explain compliance with IT Act (1 Hr) Identify steps for information privacy. (0.5 Hrs) Identify common cybercrimes and E penalties applicable. (0.5 Hrs) Professional Explain Cloud Cloud Computing (15 Hrs) Working Introduction to Cloud Computing (12 Skill -25 concepts &services with Cloud Services (12 Hrs) Hrs) Hrs; and Describe 140. Practice with IaaS using free cloud Benefits of cloud services, different Application services. (4 Hrs) categories. O Professional Development Life 141. Practice with PaaS using free Resources available in cloud. Knowledge Cycle. (NOS: SSC/ cloud services. (4 Hrs) Explain the Application Development 15 Hrs. T N9405) 142. Practice with SaaS using free Life Cycle (3 Hrs) cloud services. (4 Hrs) Identify Phases of the Application Web hosting in Cloud (3 Hrs) Development Life Cycle. T 143. Host a website in a free cloud. Describe Roles in each of phases of the (3 Hrs) Application Development Life Cycle. O Develop an application and perform the Application Development Life Cycle (10 Hrs) N 144. Identify Phases of the Application Development Life Cycle. (5 Hrs) 145. Describe Roles in each of the phases of Application Development Life Cycle. (5 Hrs) (xxii)  To be selected either "Programming in Python" or "Programming in Java" as Elective Module for COPA. COPA - Elective Module - I Programming in Python Professional Write programs Programming language (Python) Use Programming language (Python) (30 Hrs) Skill - 70 using Python Python from command line (7 Hrs) Introduction to Python History Hrs; language. ( NOS: 1. Install, set up the environment & run Features, Setting up path Basic Syntax, SSC/N9406) Python. (3 Hrs) Comments, Variable Professional 2. Use Command Line and IDE to create Different Data Types Knowledge - and execute a python program. (4 Hrs) 30 Hrs. Casting, string, Boolean Perform Operations using Data Types Python Operators and Operators (15 Hrs) 3. Write and test a python program to Conditional Statements demonstrate print statement, Looping comments, different types of variables. Control Statements, String Manipulation, D (5 Hrs) Lists, Tuple, sets 4. Write and test a python program to Dictionaries E perform data and data type Arrays operations, string operations, date, H Iterators, modules, dates, math, input and output, output formatting Modules, Input and Output. and operators. (5 Hrs) S 5. Determine the sequence of execution based on operator precedence. (5 LI Hrs) Control Flow with Decisions and Loops (20hrs) B E I 6. Construct and analyze code R IM segments that use branching U statements. (10 Hrs) 7. Construct and analyze code segments that perform iteration. (10 P B ©N Hrs) Document and Structure Code (18 Hrs) 8. Document code segments using comments and documentation strings. (3 Hrs) 9. Construct and analyze code E segments that include List comprehensions, tuple, set and Dictionary comprehensions. (16 Hrs) Perform Operations Using Modules and Tools (10 Hrs) O 10.Perform basic operations using built- in modules. (5 Hrs) T 11. Solve complex computing problems by using built-in modu