COPA - Volume I of II - TP (NSQF 2022) PDF

COMPUTER OPERATOR AND PROGRAMMING ASSISTANT NSQF LEVEL - 3 Volume I of II D E H TRADE PRAC...

COMPUTER OPERATOR AND PROGRAMMING ASSISTANT NSQF LEVEL - 3 Volume I of II D E H TRADE PRACTICAL S LI SECTOR: IT & ITES B E I R IM U (As per revised syllabus July 2022 - 1200 hrs) P E N O B © T T DIRECTORATE GENERAL OF TRAINING O MINISTRY OF SKILL DEVELOPMENT & ENTREPRENEURSHIP GOVERNMENT OF INDIA 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 - Volume I of II Trade Practical - NSQF Level - 3 (Revised 2022) Developed & Published by National Instructional Media Institute Post Box No.3142 Guindy, Chennai - 600 032 INDIA D Email: [email protected] E Website: www.nimi.gov.in H S LI Copyright © 2022 National Instructional Media Institute, Chennai First Edition : January 2023 Copies : 1,000 B E I First Reprint : June 2024 Copies : 2,000 R IM U P E N © Rs.440/- B O All rights reserved. T 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 T Instructional Media Institute, Chennai. 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, 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, Entrepreneurs, Academicians and representatives from ITIs. The National Instructional Media Institute (NIMI), Chennai has now come up with instructional material to D suit the revised curriculum for COPA Volume I of II Trade Practical NSQF Level - 3 (Revised 2022) in IT & ITES Sector. The NSQF Level - 3 (Revised 2022) Trade Practical will help the trainees to get an E international equivalency standard where their skill proficiency and competency will be duly recognized H across the globe and this will also increase the scope of recognition of prior learning. NSQF Level - 3 (Revised 2022) trainees will also get the opportunities to promote life long learning and skill development. S I have no doubt that NSQF Level - 3 (Revised 2022) the trainers and trainees of ITIs, and all stakeholders LI 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 country. B E I R IM The Executive Director & Staff of NIMI and members of Media Development Committee deserve appreciation U for their contribution in bringing out this publication. P E N Jai Hind O B © T Ms. TRISHALJIT SETHI Addl. Secretary/Director General (Training) T Ministry of Skill Development & Entrepreneurship, O Government of India. N New Delhi - 110 001 (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 NCVT/NAC in India, which is to help an individual to master skills to do a job. The instructional materials are generated in the form of Instructional Media Packages (IMPs). An IMP consists of Theory book, Practical D book, Test and Assignment book, Instructor Guide, Audio Visual Aid (Wall charts and Transparencies) and other support materials. E H 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 S theory book provides related theoretical knowledge required to enable the trainee to do a job. The test and LI assignments will enable the instructor to give assignments for the evaluation of the performance of a trainee. The wall charts and transparencies are unique, as they not only help the instructor to effectively present a B E I topic but also help him to assess the trainee's understanding. The instructor guide enables the instructor to R IM plan his schedule of instruction, plan the raw material requirements, day to day lessons and demonstrations. U P In order to perform the skills in a productive manner instructional videos are embedded in QR code of the E N 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 has also been taken to include important skill areas of allied trades as prescribed in the syllabus. B The availability of a complete Instructional Media Package in an institute helps both the trainer and O management to impart effective training. T 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. O NIMI would like to take this opportunity to convey sincere thanks to the Directors of Employment & Training N of various State Governments, Training Departments of Industries both in the Public and Private sectors, 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. 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 Practical) for the trade of COPA Volume I of II (NSQF LEVEL - 3) (Revised 2022) under IT & ITES Sector for ITIs. MEDIA DEVELOPMENT COMMITTEE MEMBERS Shri. E. Agilan _ Junior Training Officer, Govt ITI, Perumbakkam, Chennai - 131. D Shri. Sarbojit Neogi _ Vocational Instructor (COPA), IT- Nodal Officer, E NSTI for women, Kolkata - 700091. H Smt. M. Banumathy _ Assistant Training Officer, S Govt ITI, Ambattur. LI Smt. V. Revathi _ Assistant Training Officer, Govt ITI, Coimbatore. B E I R IM NIMI CO-ORDINATORS U P Shri.Nirmalya Nath - Deputy Director, E N NIMI- Chennai - 32. © Shri.G. Michael Johny _ Manager, NIMI, Chennai - 32. B 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. O NIMI also acknowledges with thanks the invaluable efforts rendered by all other NIMI staff who have contributed towards the development of this Instructional Material. T NIMI is also grateful to everyone who has directly or indirectly helped in developing this Instructional Material. 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 Vol I of II 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 (Revised 2022) Module 1 - Safe Working Practices Module 15 - Manage Data Cells and Ranges Module 2 - Assemble a Desktop PC Module 16 - Manage Tables and Table Data Module 3 - Using Windows Operating System Module 17 - Perform Operations using Module 4 - Computer Basics & Software Formulas and Functions Installation Module 18 - Manage Charts Module 5 - DOS Command Line Interface Module 19 - Manage Pivot Tables Module 6 - Install Ubuntu Linux operating Module 20 - Power Point Presentations D system and execute basic Linux Module 21 - Format Presentations commands E Module 22 - Manage Tables and Bulleted Text Module 7 - Using Word Processing Software Module 23 - Manage Graphic Elements H Module 8 - Format documents Module 24 - Manage Audio & Video Elements Modfule 9- Manage Tables and Lists S Module 25 - Manage Transitions and Module 10 - Create and Manage References Animations LI Module 11 - Manage Graphic Elements Module 26 - Manage Collaboration Module 12 - Manage Document Collaboration Module 27 - Demonstrate on B E I Module 13 - Manage Mailings Module 28 - Demonstrate on R IM Module 14 - Spread Sheet Application, Manage U Module 29 - Demonstrate on Worksheets and Workbooks P E N The skill training in the shop floor is planned through a series of practical exercises centred around some practical 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 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. B TRADE THEORY O The manual of trade theory consists of theoretical information for the course of the COPA Trade. The contents T are sequenced according to the practical exercise contained in the manual on Trade practical. Attempt has been 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. T O 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. N 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 Exercise No. Title of the Exercise Learning Page No. Outcome Module 1 : Safe Working Practices 1.1.01 Locate the electrical connections with computer system setup 1 1 1.1.02 Identifying Safety symbols and Hazard identification 2 1.1.03 Practice safe methods of fire fighting in case of electrical fire 3 1.1.04 Use of fire extinguishers 4 Module 2 : Assemble a Desktop PC 1.2.05 Identify computer peripherals and internal components of a desktop 1 computer 6 1.2.06 Assemble components of desktop computer 9 D Module 3 : Using Windows Operating System 1.3.07 Practice on Windows interface and navigation Windows 1 12 E 1.3.08 Practice on managing files and folders using removable drives 15 H 1.3.09 Customize the desktop 17 1.3.10 Settings and manage user accounts 19 S 1.3.11 View System properties and control panel details 21 LI 1.3.12 Work with keyboard shortcut commands 24 1.3.13 Print and scan documents using different commands 26 B E I Module 4 : Computer Basics & Software Installation R IM U 1.4.14 View the BIOS settings and their modifications 1 28 1.4.15 Install Windows operating system 31 P E N 1.4.16 Format hard disk and create partition 36 1.4.17 Identify and rectify common hardware and software issues during © OS installation 37 1.4.18 Install necessary application software for Windows 38 1.4.19 Configure bluetooth / Wi-Fi settings 44 1.4.20 Install printer, scanner, Web camera & DVD drives 48 B 1.4.21 Burn data, video and audio files on CD/DVD using application software 52 Module 5 : DOS Command Line Interface O 1.5.22 Basic DOS Commands 1 53 1.5.23 Managing files and folders using dos commands 56 T Module 6 : Install Ubuntu Linux operating system and execute T basic Linux commands 1.6.24 Basic DOS Commands 1 60 O 1.6.25 Install necessary application software in Linux 64 N 1.6.26 Use basic Linux commands for directory listing File, Folder management, Password etc., 66 1.6.27 Use the Linux graphical user interface for file and folder management, exploring the system etc 73 1.6.28 Customize desktop settings and manage user accounts in Linux 76 1.6.29 View system properties and manage system setting in Linux 79 Module 7 : Using Word Processing Software 1.7.30 Navigate within documents 2 80 1.7.31 Format documents 85 1.7.32 Save and share documents 94 (vii) Exercise No. Title of the Exercise Learning Page No. Outcome 1.7.33 Inspect documents for issues 2 97 Module 8 : Format documents 1.8.34 Insert text and paragraphs 2 102 1.8.35 Format text and paragraphs 104 1.8.36 Create and configure document sections 109 Module 9 : Manage Tables and Lists 1.9.37 Create tables 2 112 1.9.38 Modify tables 114 1.9.39 Create and modify lists 118 Module 10 : Create and Manage References 2 1.10.40 Create and manage reference elements 124 D 1.10.41 Create and manage reference tables 128 E Module 11 : Manage Graphic Elements H 1.11.42 Insert illustrations and text boxes 2 132 1.11.43 Format illustrations and text boxes 146 S 1.11.44 Add text to graphic elements 150 LI 1.11.45 Modify graphic elements 151 Module 12 : Manage Document Collaboration B E I 1.12.46 Add and manage comments 2 159 R IM U 1.12.47 Manage change tracking 161 Module 13 : Manage Mailings P 2 E N 1.13.48 Perform mail merge 165 Module 14 : Spread Sheet Application, Manage Worksheets © and Workbooks 1.14.49 Open files in MS Excel 3 172 1.14.50 Import data 176 1.14.51 Navigate within workbooks 177 B 1.14.52 Format worksheets and workbooks 183 1.14.53 Customize options and views 186 O 1.14.54 Configure content for collaboration 195 T Module 15: Manage Data Cells and Ranges 1.15.55 Manipulate data 3 204 T 1.15.56 Format cells and ranges 208 1.15.57 Define and reference named ranges 212 O Module 16: Manage Tables and Table Data N 1.16.58 Create and format tables 3 216 1.16.59 Managing tables and its data 218 1.16.60 Filter and sort table data 220 Module 17: Perform Operations using Formulas and Functions 1.17.61 Insert references 223 3 1.17.62 Calculate and transform data 229 1.17.63 Format and modify text 231 (viii) Exercise No. Title of the Exercise Learning Page No. Outcome Module 18: Manage Charts 1.18.64 Create Charts 3 233 1.18.65 Modify charts 237 1.18.66 Format charts 240 Module 19: Manage Pivot Tables 3 1.19.67 Create Pivot Tables 242 Module 20: Power Point Presentations 1.20.68 Open files in MS PowerPoint 253 1.20.69 Format PowerPoint Presentations 257 4 1.20.70 Modify slide masters, handout masters, and note masters 259 1.20.71 Change presentation options and views 261 D 1.20.72 Save and share PowerPoint Presentations 265 E 1.20.73 Configure and present slide shows 267 1.20.74 Prepare presentations for collaboration 269 H Module 21: Format Presentations S 1.21.75 Insert text and paragraphs 4 270 1.21.76 Format text and paragraphs 273 LI 1.21.77 Create and configure sections 278 B E I Module 22: Manage Tables and Bulleted Text R IM 1.22.78 Create tables 280 U 1.22.79 Modify tables 4 283 P 1.22.80 Create and modify bulleted text 288 E N 1.22.80A Create and manage reference elements (hyperlinks) 289 Module 23: Manage Graphic Elements © 1.23.81 Insert illustrations and text boxes 292 4 1.23.82 Format illustrations and text boxes 295 1.23.83 Add and modify text in graphic elements 303 B Module 24: Manage Audio & Video Elements 1.24.84 Add Audio elements 4 308 O 1.24.85 Add Video elements 310 Module 25: Manage Transitions and Animations T 1.25.86 Add slide transitions 4 313 T 1.25.87 Add slide Animations 318 Module 26: Manage Collaboration O 4 1.26.88 Add and manage comments 336 N Module 27: Demonstrate on 1.27.89 Installation of MySQL 338 1.27.90 Troubleshooting basic installation issues 343 1.27.91 Creation and use of database 5 347 1.27.92 Designing of tables 348 1.27.93 Applying data integrity rules 349 1.27.94 Using the DDL, DCL and DML statements 351 1.27.95 Enforcing constraints, primary key and foreign key 354 1.27.96 Adding indices to Tables 356 (ix) Exercise No. Title of the Exercise Learning Page No. Outcome Module 28: Demonstrate on 1.28.97 Simple select queries 5 357 1.28.98 Insert and delete queries Update queries 358 Module 29: Demonstrate on 1.29.99 Using the Number, Date and Character functions. Joins and Functions 5 360 1.29.100 Joins, Group by, Having, Sub query 362 LEARNING / ASSESSABLE OUTCOME On completion of this book you shall be able to D S.No. Learning Outcome Ref. Ex.No. E 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 H 2 Create, format, and edit document using word processing application S software. (Mapped NOS: SSC/N3022) 1.7.30 - 1.13.48 LI 3 Create, format, edit and develop a workbook by using spreadsheet application software. (Mapped NOS: SSC/N3022) 1.14.49 - 1.19.67 B E I R IM 4 Create and customize slides for presentation. (Mapped NOS: SSC/N3022) 1.20.68 - 1.26.88 U 5 Create and manage database file by using MySQL. (NOS: SSC/N9401) 1.27.89 - 1.29.100 P E N SYLLABUS © Duration Reference Learning Professional Skills Professional Knowledge Outcome (Trade Practical) (Trade Theory) B with Indicative hours Professional Install and setup Safe working practices (10 Hrs) Introduction to Computers (3 Hrs) O Skill- 94 Hrs; operating system and 1. Visit COPA Lab. of the institutes Safe working practices related software in a and locate the electrical Scope of the COPA trade. T Professional computer following safety connections with computer Safety rules and safety Knowledge - precautions. (Mapped system setup. (3 Hrs) signs. 32 Hrs T NOS: SSC/N3022) 2. Identifying safety symbols and Types and working of fire hazard identification. (3 Hrs) extinguishers. Introduction to O 3. Practice safe methods of fire Computer components fighting in case of electrical fire. N (2 Hrs) Introduction to computer 4. Use of fire extinguishers. (2Hrs) system (4 Hrs) Assemble a Desktop PC (8 hrs) Concepts of Hardware 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 14.View the BIOS settings and their Line Interface & Linux Operating modifications. (3 Hrs) Systems (10 Hrs) 15.Install Windows operating system. Introduction to basic DOS Internal D (4 Hrs) and External Commands. 16.Format hard disk and create Introduction to Open S o u r c e E partition. (3 Hrs) Software H 17.Identify and rectify common Introduction to Linux Operating hardware and software issues System features, structure, files S during OS installation. (3 Hrs) and processes 18.Install necessary application Basic Linux commands. LI software for Windows i.e. Office Package, PDF Reader, Media B E I Player etc. (2 Hrs) R IM 19.Configure Bluetooth and Wi-Fi U settings. (1 Hr) 20.Install Drivers for printer, scanner, P E 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 directory listing. (5 Hrs) B 23.Manage files and folders using DOS commands. (4 Hrs) O Install Ubuntu Linux operating system and execute basic Linux T commands (27 Hrs) 24.Installation of Ubuntu Linux operating system (6 Hrs) T 25.Install necessary application O software for Linux i.e. Office Package, PDF Reader, Media N Player etc. (4 Hrs) 26.Use Basic Linux commands for directory listing, file and folder management, password etc. (6 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 Word. 31.Format documents (4.6 Hrs) Set up document pages D Apply style sets Insert and modify headers and footers E Configure page background elements 32.Save and share documents (2 Hrs) H Savedocuments in alternative file formats S Modify basic d o c u m e n t LI properties Modify print settings Share d o c u m e n t s B E I electronically R IM 33.Inspect documents for issues U (2.4 Hrs) Locate and remove hidden properties P E N and personal information Locate and correct accessibility issues © Locate and correct compatibility issues Format documents (8 Hrs.) 34.Insert text and paragraphs (2 Hrs) B Find and replace text Insert symbols and special characters 35.Format text and paragraphs (3 Hrs) O Apply text effects Apply formatting by using Format T Painter Set line and paragraph T spacing and indentation Apply built-in styles to text O Clear formatting 36.Create and configure document N sections (3 Hrs) Format text in multiple columns Insert page, section, and 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 formats Define custom bullet characters and number formats D Increase and decrease list levels Restart and continue list numbering E Set starting number values Create and H manage references (3 Hrs.) 40.Create and manage reference S elements (1.4 Hrs) Insert foot notes andend notes LI Modify footnote and endnote properties Create and modify bibliography B E I citation sources R IM U Insert citations for bibliographies 41.Create and manage reference P tables (1.6 Hrs) E N Insert tables of contents Customize tables of contents © Insert bibliographies Manage graphic elements (8.5 Hrs.) 42.Insert illustrations and text boxes (3 Hrs) Insert shapes B Insert pictures Insert 3D models O Insert Smart Art graphics Insert screenshots and screen T clippings Insert text boxes 43.Format illustrations and text boxes T (3 Hrs) O Apply artistic effects Apply picture effects and picture N styles Remove picture backgrounds 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) Track changes Review tracked changes Accept and reject tracked changes D Lockand unlock c h a n g e E tracking Manage Mailings (3.5 Hrs) H 48.Perform mail merge (3.5 Hrs) Create envelopes S Create labels Create a new mailing list LI Perform mail merge using an existing list B E I Professional Create, format, edit Spread Sheet Application (72 Hrs) Spread Sheet Application (18 Hrs) R IM Skill - 72 and develop a Manage Worksheets and Workbooks Introduction to Excel features and Data U Hrs.; workbook by using (12 Hrs.) Types. spreadsheet 49.Open files in MS Excel (1.5 Hrs) P Cell referencing and linking Sheets. E 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 Import data from txt files scenarios B Import data from csv files 51.Navigate within workbooks (2 Hrs) Search data O Navigate to named cells, ranges or workbook elements T Insert and remove hyperlinks 52.Format worksheets and T workbooks (2 Hrs) Modify page setup O Adjust row height and column width Customize headers and footers N 53.Customize options and views (3 Hrs) Display and modify content in 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 56.Format cells and ranges (5 Hrs) Merge and Unmerge cells Modify cell alignment, D orientation and indentation Format cells using Format Painter E Wrap text within cells H Apply number formats Apply cell formats from the Format S cells dialog box Apply cell styles LI Clear cell formatting 57.Define and reference named B E I ranges (4 Hrs) R IM Define a named range U Name a table Summarize data visually Insert P E 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 Apply table styles B Convert tables to cell ranges 59.Manage tables and table data (5 Hrs) O Add or remove table rows and columns Configure table style options T Insert and configure total rows 60.Filter and sort table data (3 Hrs) T Filter records Sort data by multiple columns Perform O operations using formulas and functions (12 Hrs.) N 61. Insert references (3 Hrs) Insert relative, absolute and mixed references Reference named ranges and named 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 Switch between rows and columns in source data Add and modify chart elements D Add trend lines to chart E 66.Format charts (5 Hrs) Apply chart layouts H Apply chart styles Add alternative text to charts for S accessibility Manage Pivot Tables (12 Hrs.) LI 67.Create Pivot Tables(12 Hrs) Create Pivot tables from cell ranges B E I Manipulate fields (columns) to get R IM desired analysis U Use Filters for pivot tables Represent data as Count, Sum, P E 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. (Mapped NOS: Open MS PowerPoint Introduction to the properties a n d Professional B 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 O 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 T 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 O Add PowerPoint templates Duplicate slides N 70.Modify slide masters, handout masters, and note masters (2 Hrs) Change the slide 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 74.Prepare presentations f o r collaboration (1 Hrs) Protect presentations b y D using passwords E Export presentations to other formats Format presentations (6.5 Hrs.) H 75.Insert text and paragraphs (2 Hrs) Find and replace text S Insert symbols and special characters LI 76.Format text and paragraphs (2 Hrs) B E I Apply text effects R IM Apply formatting by using Format U Painter Set line and paragraph P E 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 B Clear formatting Manage tables and bulleted text (8 Hrs) O 78.Create tables (3 Hrs) Insert tables in PowerPoint T Apply built-in table styles Create tables by specifying rows and T columns 79.Modify tables (3 Hrs) O Insert and delete table rows and columns N Configure cell margins and spacing Merge and split cells Resize tables, rows, a n d 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 Insert SmartArt graphics Insert screenshots and screen clippings D 82.Format illustrations and text boxes (4 Hrs) E Apply artistic effects H Apply picture effects a n d picture styles S Remove picture backgrounds Crop images LI Format graphic elements Format SmartArt graphics B E I 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 E 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 Configure audio p l a y b a c k B options 85.Add Video elements (4.5 Hrs) O Import video files i n presentations T Resize video to fit slide Configure video p l a y b a c k options T Manage transitions and animations O (9 Hrs) 86.Add slide transitions (5 Hrs) N Add same slide transition for all slides Set transition effect duration Configure transition start and finish options 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. 13 Hrs 92.Designing of tables. (3 Hr) Designing Database using Normalization 93.Applying data integrity rules. (2 Hr) Rules. 94.Using the DDL, DCL and DML Various data types Data integrity, DDL D statements. (2 Hrs) DML and DCL statements. 95. Enforcing constraints, Enforcing Primary key and foreign key. E primary key and foreign key. (2 Hrs) 96. Adding indices to Tables. (1 Hr) Adding Indices. H Demonstrate on (15 Hrs) Queries (4 Hrs) 97.Simple select queries. (5 Hrs) Concepts of Transactions S 98.Insert and delete queries Update ACID Property of Transaction queries. (10 Hrs) Constraints. LI Demonstrate on (23 Hrs) Joins and Functions (5 Hrs) 99. Using the Number, Date and Joining of tables B E I Character functions. Joins Sub Queries " Functions used in R IM and Functions (11.5 Hrs) query like sum, average, max, min, U 100. Joins, Group by, Having, Sub count etc. query. (11.5 Hrs) P E 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 NOS: SSC/N3022) and share Devices i.e. Printers, files, How are Networks Built?, B folders and drives. (4 Hrs) Routing Across Networks 103. Work with various Network devices, connectors and cables. Explain how end- user devices and local O Create straight and cross cable and networks interact with the global Internet. punch a UTP cable in the patch Communicating in a Connected World T 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. O pinging to test networks. (4 Hrs) What Does a Home Network Look Like? 105. Configure Hub and Switch. (4 Hrs) How Does Wi-Fi Work? N 106. Set up and configure wired and Introduction to LAN Devices, wireless LAN in a Computer Lab Internetworking Devices, within at least three computers. (6 Internet Concepts (4 Hrs) 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) Skill - 67 using HTML and HTML tags (67 Hrs.) Concepts of Static and Dynamic Web Hrs; CSS. (Mapped 113. Practice HTML (46 Hrs) pages. NOS: SSC/N0503, Practice with basic HTML elements D Professional Introduction to HTML and various tags SSC/N0501) (e.g. head, title, body), tag and in HTML. Knowledge - E attributes. Concepts of different controls used 17 Hrs Design simple web page with text, in Web Pages. H paragraph and line break using HTML Concepts of CSS and applying CSS to tags HTML. S Format text, change background Introduction to open source CMS viz, colour and insert pictures in web page LI Joomla, Word press etc. and Web Design simple web page with tables authoring tools viz. Kompozer, and lists. WordPress, Front Page etc. B E I Use marquees, hyperlinks and mail R IM to link in designing web pages U Create frames, add style and design layout. P E 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. Design a web page adding flash file, B audio and video files. Design web page with forms and form O controls using HTML tags 114. Create simple static web pages T using CSS (21 Hrs ) CSS syntax, Adding colors, fonts, backgrounds, images borders, text T alignment, text transformation, Lists O etc. 3 types of CSS N Adding a Navigation Bars(vertical/ horizontal bars) CSS drop downs & Forms CSS counters and website layout, 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 120. Develop dynamic HTML pages and usage. using JavaScript. The String data type in Deploy a simple web project (6 Hrs) JavaScript. Introduction to String, Math D 121. Deploy web project using IIS. and Date. Introduction to Functions i n E JavaScript. H Built in JavaScript functions overview. Concepts of Pop Up boxes in S JavaScript. Introduction to the Document Object LI Model. Concepts of using Animation a n d B E I multimedia files in Java Script. R IM Professional Create workbooks Data Visualization or analysis using Advanced Excel Concepts - Theory- U Skill - 73 with advanced Excel - (73 Hrs) (17 Hrs) Hrs formulas, macros, Create advanced formulas and P MS excel revision (row, columns, basic E 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) © 17 Hrs Types of references and cell naming 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 124. Look up data by using functions. Pivot table and Pivot chart B (6 Hrs) Conditional formatting 125. Use advanced date functions.(6 Hrs) Advanced Graphs O Manage advanced charts and tables Power Queries (21 hrs) T 126. Create and modify advanced charts. (10 Hrs) T 127. Create and m o d i f y PivotTables. (11 Hrs) O Use Power Query and Power BI (24 Hrs) N 128. Create a Power Query, Power Query Function. Invoking the Power Query function and combining queries. 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 an ecommerce website. (4 Hrs) 135. Practice order processing. (3 Hrs) 136. Practice payment processing. D (4.5 Hrs) 137. Identify common security E issues. (3.5 Hrs ) H Professional Secure information 138. Protect information, Cyber Security (10 Hrs) Skill - 20 from Internet by computers and networks from Overview of Information S Hrs using cyber security viruses, spyware and other Security, SSL, HTTPS, Security concept. (NOS: malicious code (19 Hrs) threats, information Security vulnerability LI Professional SSC/N9404) Explain Cyber security (2 Hrs) and Risk management. Knowledge - Secure computers & Introduction to Directory Services, 10 Hrs. B E I the network (5.5 Hrs) Access Control, Security, Privacy R IM Reduce cyber security threats (2 Hrs) protection, Audit and Security. U Secure a Wi-Fi Network (4 Hrs) Introduction to IT Act and penalties for Use Anti-Virus software (3 Hrs) cybercrimes. P E 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 penalties applicable. (0.5 Hrs) B Professional Explain Cloud Cloud Computing (15 Hrs) Working Introduction to Cloud Computing (12 Skill -25 concepts &services with Cloud Services (12 Hrs) Hrs) O Hrs; and Describe 140. Practice with IaaS using free cloud Benefits of cloud services, different Application services. (4 Hrs) categories. Professional T 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. N9405) 142. Practice with SaaS using free T Life Cycle (3 Hrs) cloud services. (4 Hrs) Identify Phases of the Application O Web hosting in Cloud (3 Hrs) Development Life Cycle. 143. Host a website in a free cloud. Describe Roles in each of phases of the N (3 Hrs) Application Development Life Cycle. Develop an application and perform the Application Development Life Cycle (10 Hrs) 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, (5 Hrs) Lists, Tuple, sets 4. Write and test a python program to Dictionaries D perform data and data type Arrays operations, string operations, date, Iterators, modules, dates, math, E input and output, output formatting Modules, Input and Output. and operators. (5 Hrs) H 5. Determine the sequence of execution based on operator precedence. (5 S Hrs) Control Flow with Decisions and LI Loops (20hrs) 6. Construct and analyze code B E I segments that use branching R IM statements. (10 Hrs) U 7. Construct and analyze code segments that perform iteration. (10 P E N Hrs) Document and Structure Code (18 Hrs) © 8. Document code segments using comments and documentation strings. (3 Hrs) 9. Construct and analyze code segments that include List B comprehensions, tuple, set and Dictionary comprehensions. (16 Hrs) O Perform Operations Using Modules and Tools (10 Hrs) T 10.Perform basic operations using built- in modules. (5 Hrs) 11. Solve complex computing problems T by using built-in modules. (5 Hrs) O COPA - Elective Module - II Programming in JAVA N Professional Writing programs Object Oriented Programming and Explain the following: Skill - 70 using JAVA. (SSC/ JAVA Language (15 Hrs) Object Oriented Programming Hrs; N9407) 1. Installing JAVA. with Core Java 2. Setting the Class path. Java Programming features Professional Knowledge - 3. Writing and Executing a simple JAVA JVM, Byte codes and Class path 30 Hrs. Program to display "Hello". Java Program Development Demonstrate writing JAVA programs: Compilation and Execution of JAVA 4. Use of various data types in JAVA. programs 5. Use of various operators in JAVA. Basic JAVA language elements - 6. Create and use of Local, Instance and keywords, comments, data types and Class variables. variables. (xxiii)  7. Read text from the keyboard using JAVA Arithmetic, Assignment, scanner class read text from the Relational, Logical, Increment / keyboard using console class. Decrement operators and expressions. JAVA String Operators JAVA Input and Output streams, System in, System out. Input using Scanner class and Console class methods. (10Hrs.) JAVA Program Flow Control (20 Hrs) Explain the following: Demonstrate writing JAVA programs: Decision making and flow control using 8. Use of the if and if … else statements. if…then, if then else, nested if, switch 9. Use of t