9

8
7
6
5
4
3
2
1

10
Assignment No.

SIGN OF C.I.
Fire Safety Measures in Technical Labs

Cyber Safety Practices for COPA Students

Skill/Demo No.

Hazard Identification and Risk Assessment

Electrical Safety Guidelines for ITI Students
Importance of Safe Working Practices in ITI
Assignment Name
Skill/Demo Name:

First Aid Procedures for Workshop Accidents

Role of Ergonomics in Safe Working Practices

E-Waste Management and Environmental Safety
Machine Handling and Maintenance Safety Rules
Personal Protective Equipment (PPE) in Workshops
Always wear appropriate Personal Protective Equipment (PPE) like gloves,
1

safety goggles, or aprons, depending on the task.

2

Maintain a clean and organized workspace to prevent slips, trips, and falls.

Follow proper lifting techniques to avoid injuries—bend your knees, not your
Batch No :-2

back.
4

Switch off machines and power supplies before starting maintenance work.

Use insulated tools for electrical tasks and check wiring for damages before
5

use.

Never handle electrical equipment with wet hands to prevent electric shocks.
6
7

Inspect tools and equipment for wear and damage before use.

Operate machines only after receiving proper training and understanding

8

their mechanisms.

SIGN OF G.I.
Avoid loose clothing or accessories that could get caught in moving parts.
9

Know the location of fire extinguishers and how to use them.

10

Follow evacuation procedures during emergencies.

11
SKILL CHART : 1.Safe working Practice
Computer Operator and Programming Assistant (COPA)

Do not overload electrical sockets to minimize fire risks.

12

Keep passwords confidential and use strong, unique passwords.

13

Avoid downloading unauthorized software or accessing suspicious websites.

14
INSTRUCTOR :- YADAV V.A

Regularly back up data and install antivirus software to protect against cyber
15

threats.
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Handle hazardous materials with caution and store them properly.

16

Refer to Material Safety Data Sheets (MSDS) for information on handling

17

specific chemicals.

Take breaks to avoid eye strain and fatigue when working on computers.
18

Ensure proper posture while sitting—use ergonomic chairs and maintain

SIGN OF PRINCIPAL
19

screen height at eye level.

Stay hydrated and avoid long periods of inactivity.

20
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Testing and Booting the Assembled PC

ntroduction to Desktop PC Components

SIGN OF C.I.
Safety Precautions While Assembling a PC

Installing and Configuring the Motherboard

Skill/Demo No.

Tools Required for Assembling a Desktop PC

Assignment Name
Skill/Demo Name:

Step-by-Step Guide to Assembling a Desktop PC

Connecting and Securing Storage Drives (HDD/SSD)

Importance of Regular Maintenance for Desktop PCs

Troubleshooting Common Issues During PC Assembly
Power Supply Unit Installation and Cable Management
Component Identification on Motherboard, Processor (CPU), RAM
Batch No :-2

(Memory),Storage Drives, Power Supply Unit (PSU),Case/Chassis,

21

Graphics Card (GPU),Cooling Systems.

Install the CPU

- Align the CPU with the socket on the motherboard.
22

-Secure it gently without forcing it into place.

Attach the CPU Cooler

-Apply a thin layer of thermal paste if required.
23

-Mount the cooler using the provided screws or clips.

Install RAM
Align the notch on the RAM module with the slot and press firmly until it
24

clicks.

SIGN OF G.I.
Mount the Motherboard in the Case
25

Secure the motherboard using standoffs and screws to prevent short circuits.
SKILL CHART : 2.Assemble a Desktop Pc
Computer Operator and Programming Assistant (COPA)

Install the Power Supply Unit (PSU)

-Secure the PSU in the case and connect the required power cables to the
26

motherboard, CPU, and other components.

Connect Cables and Peripherals

-Attach front panel connectors (power button, USB ports, etc.).
27
INSTRUCTOR :- YADAV V.A

-Connect the GPU (if applicable) to the PCI-E slot and secure it.
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

nstall Case Fans

28

Position the fans for optimal airflow and connect them to the motherboard.

Test the Assembly

Plug in the monitor, keyboard, and mouse.
29

SIGN OF PRINCIPAL

Power on the system to ensure all components work correctly.

 9
8
7
6
5
4
3
2
1

10
Assignment No.

SIGN OF C.I.
Skill/Demo No.

Managing Files and Folders Using File Explorer

Creating and Restoring Backups in Windows 10

Assignment Name
Skill/Demo Name:

Exploring the Start Menu and Taskbar in Windows 10

Networking and Internet Configuration in Windows 10

Installing and Uninstalling Applications in Windows 10
Setting Up and Customizing User Accounts in Windows 10

Configuring Windows Update and Ensuring System Security

Understanding and Configuring Windows 10 System Settings

Keyboard Shortcuts and Accessibility Features in Windows 10

Using Task Manager for System Monitoring and Troubleshooting
Using the Start Menu, Taskbar, and Action Center.
30

Personalizing the desktop: changing wallpapers, themes, and icons.

31

Using and managing desktop shortcuts.

32

Creating, renaming, moving, and deleting files and folders.

33

Understanding file extensions and properties.

34
Batch No :-2

Using File Explorer and the search function efficiently.

35

Creating and managing multiple user accounts.

36

Setting up passwords, PINs, and biometric authentication.

37

SIGN OF G.I.
Configuring user permissions and parental controls.
38

Navigating the Settings app and Control Panel.

39

Adjusting display, sound, and power settings.

40

Configuring network and internet settings (Wi-Fi, Ethernet, VPN).

41

Installing applications through the Microsoft Store or setup files.

42
SKILL CHART : 3.Windows OS

Uninstalling or repairing programs.

43
Computer Operator and Programming Assistant (COPA)

Managing default applications (e.g., browser, photo viewer).

44

Using Task Manager to monitor system performance and close unresponsive apps.
45

Running Windows Troubleshooter for hardware and software issues.

46
INSTRUCTOR :- YADAV V.A

Performing disk cleanup and defragmentation to optimize performance.

47
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Configuring Windows Update to ensure the system is up to date.

48

Enabling and managing Windows Defender Antivirus.

49

Setting up a firewall and checking for security vulnerabilities.

50

Learning common shortcuts like Ctrl + C (Copy), Alt + Tab (Switch Apps), etc.
51

Using Ease of Access tools like Magnifier, Narrator, and On-Screen Keyboard.
52

Setting up File History or creating a system restore point.

53

Using the Backup and Restore tool for important data.

54

Troubleshooting startup issues using recovery options.

55

Connecting to Wi-Fi, setting up hotspots, and sharing files on a local network.

56

SIGN OF PRINCIPAL

Configuring and troubleshooting printers and external devices.

57

Understanding network settings and troubleshooting connectivity issues

58
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Batch Scripting Basics: Automating Tasks in DOS

System Recovery and Repair Using DOS Commands

System Information Retrieval Using DOS Commands

SIGN OF C.I.
Managing Processes and Terminating Applications via DOS

Using DOS Commands for System Security and Permissions

Skill/Demo No.

Introduction to DOS Command Prompt and Basic Commands

Assignment Name
Skill/Demo Name:

Understanding and Using Disk Management Commands in DOS

File Management in DOS: Creating, Renaming, and Deleting Files

Advanced DOS Commands for File Search, Copy, and Backup Operations
Network Configuration and Troubleshooting Using DOS Commands
Batch No :-2

Navigating directories using cd (change directory) and dir (list directory contents).
59

Creating, renaming, and deleting files and directories using mkdir, del, and rmdir.
60

Copying and moving files with copy and move commands.

61

Viewing contents of a file using the type command.

62

Managing file attributes using attrib (e.g., changing read-only or hidden attributes).
63

Renaming files with the ren command.

64

Searching for files using dir /s or find.

65

Copying files and directories with the xcopy and robocopy commands.
66

SIGN OF G.I.
Displaying disk information using chkdsk to check for file system errors.
67
Computer Operator and Programming Assistant (COPA)

SKILL CHART : 4.DOS Command Interface

Formatting drives with format (e.g., format a USB drive).

68

Checking disk space usage using dir with parameters like /s or /a.
69

Displaying system information with systeminfo to get details about the OS, memory,
70

and other system specs.

INSTRUCTOR :- YADAV V.A

Managing processes with tasklist to see running processes and taskkill to terminate
71

processes.
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Setting environment variables using set and setx.

72

Writing batch scripts using .bat files for automating repetitive tasks (e.g., backup
73

scripts).

Shutting down or restarting the system using the shutdown command with various
74

options (e.g., /r for restart, /s for shutdown).

Scheduling tasks with the at or schtasks commands to automate operations like system
75

shutdown.

Managing file permissions using the cacls command to change access control lists
76

(ACLs).

ncrypting files with the cipher command to ensure secure file storage.
SIGN OF PRINCIPAL
77

Repairing system files using sfc /scannow to scan and restore corrupted system files.
78
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Backing Up and Restoring Files in Ubuntu Linux

SIGN OF C.I.
Compressing and Archiving Files in Ubuntu Linux
Skill/Demo No.

Assignment Name

Managing Disk Space and File System in Ubuntu Linux

Skill/Demo Name:

Managing User Accounts and Permissions in Ubuntu Linux

Monitoring System Resources and Processes in Ubuntu Linux

Navigating the File System and Managing Files in Ubuntu Linux

Basic System Troubleshooting and Log Analysis in Ubuntu Linux

Shutting Down and Restarting Ubuntu Linux Using Command Line
Configuring Network Settings and Troubleshooting in Ubuntu Linux
Installing and Removing Software Packages Using apt in Ubuntu Linux
Navigating the File System
79

cd (change directory) and ls (list directory contents).

File Management
Batch No :-2

80

touch (create files), cp (copy files), mv (move/rename files), rm (delete files).

Directory Management
81

mkdir (create directories) and rmdir (remove directories).

Viewing Files
82

cat, less, more (view file contents).

File Permissions
83

chmod (change file permissions), chown (change file ownership).

Finding Files
84

find (search files), grep (search text patterns within files).

Package Installation
85

apt-get install (install software), apt-get remove (remove software).

Package Updates
86

apt-get update (update package lists), apt-get upgrade (upgrade installed packages).

System Resource Monitoring

SIGN OF G.I.
87

top (monitor CPU/memory usage), htop (advanced monitoring).

Disk Usage
SKILL CHART : 5.Ubuntu Linux OS
88

df (disk space usage), du (directory space usage).

Computer Operator and Programming Assistant (COPA)

Network Configuration
89

ifconfig or ip a (view network interfaces), ping (check connectivity).

Viewing System Information

90

uname -r (kernel version), lscpu (CPU details), lsblk (block devices).

User Account Management

91

useradd (create user), passwd (change password), usermod (modify user).

INSTRUCTOR :- YADAV V.A

Group Management
92

groupadd (create group), gpasswd (manage group passwords).

SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Process Management
93

ps (view running processes), kill (terminate processes).

Searching System Logs

94

dmesg (view boot messages), journalctl (view system logs).

Backing Up Files
95

cp -r (backup directories), rsync (efficient file copying).

File Compression
96

tar (create/extract archives), gzip (compress files), zip (archive files).

Disk Repair and Management

SIGN OF PRINCIPAL
97

fsck (check and repair file systems), mount (mount drives).

System Shutdown and Restart

98

shutdown (turn off system), reboot (restart system).

 9
8
7
6
5
4
3
2
1

10
Assignment No.

Creating and Managing Tables in MS Word

SIGN OF C.I.
Creating and Managing Mail Merge Documents
Exploring Basic Features and Tools of MS Word
Skill/Demo No.

Sharing and Co-Authoring Documents in MS Word

Assignment Name
Skill/Demo Name:

Formatting and Organizing Bibliographies in MS Word

Working with Bulleted and Numbered Lists in MS Word
Formatting Text, Paragraphs, and Page Layouts in MS Word

Using Track Changes and Comments for Document Collaboration

Creating and Managing References: Footnotes, Endnotes, and Citations

Inserting and Managing Graphic Elements: Images, Shapes, and SmartArt

Introduction to MS Word: Basic Features and Tools
99
Batch No :-2

Creating and Formatting Simple Documents in MS Word

100

Formatting Text: Fonts, Sizes, and Styles in MS Word

101

Working with Paragraphs and Alignment in MS Word

102

Creating and Managing Headers, Footers, and Page Numbers in MS

103

Word

Using Styles and Themes for Consistent Document Formatting

104

Creating and Formatting Tables in MS Word

105

Using Lists: Bulleted, Numbered, and Multilevel Lists in MS Word

106

SIGN OF G.I.
Inserting and Formatting Tables in MS Word
107
SKILL CHART : 6.MS-WORD

Creating, Managing, and Formatting References in MS Word

108
Computer Operator and Programming Assistant (COPA)

Inserting Footnotes, Endnotes, and Citations in MS Word

109

Managing Bibliographies and References Lists in MS Word

110

Inserting and Editing Graphics: Images, Shapes, and SmartArt

111
INSTRUCTOR :- YADAV V.A

Working with Text Boxes, WordArt, and Shapes in MS Word

112
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Creating and Formatting Charts in MS Word

113

Reviewing and Collaborating on Documents: Track Changes and

114

Comments

Protecting and Securing Documents in MS Word

115

Sharing and Co-Authoring Documents in MS Word

116

SIGN OF PRINCIPAL

Creating and Managing Mail Merge Documents in MS Word

117

Using Labels, Envelopes, and Mass Mailing Features in MS Word

118
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Excel

Sorting and Filtering Data in Excel

SIGN OF C.I.
Creating and Managing Tables in Excel

Creating and Customizing Charts in Excel

Skill/Demo No.

Formatting and Editing Data in Excel Cells

Assignment Name
Skill/Demo Name:

Understanding and Using Cell References in Excel

Creating, Saving, and Managing Excel Workbooks

Organizing, Renaming, and Moving Worksheets in Excel

Performing Basic Calculations and Using Excel Functions

Exploring the Excel Spreadsheet Interface and Navigation

Inserting, Deleting, and Moving Cells, Rows, and Columns in

Introduction to Excel: Navigating the Spreadsheet Interface
119

Creating, Saving, and Managing Workbooks in Excel

120
Batch No :-2

Organizing and Renaming Worksheets in Excel

121

Inserting, Deleting, and Moving Cells, Rows, and Columns

122

Entering, Editing, and Formatting Data in Cells

123

Using Cell References: Relative, Absolute, and Mixed References

124

Formatting Data Ranges: Alignment, Number Formats, and Borders

125

Sorting and Filtering Data in Excel

126

SIGN OF G.I.
Creating and Managing Excel Tables
127

Inserting, Editing, and Removing Table Data

128
SKILL CHART : 7.MS-EXCEL

Applying Table Styles and Formatting in Excel

129
Computer Operator and Programming Assistant (COPA)

Performing Basic Calculations Using Formulas

130

Using Common Functions: SUM, AVERAGE, COUNT, MIN, MAX

131

Working with Logical Functions: IF, AND, OR

132
INSTRUCTOR :- YADAV V.A

Using Date and Time Functions in Excel

133
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Creating and Customizing Charts in Excel

134

Editing and Formatting Chart Elements in Excel

135

Using Pivot Tables for Data Analysis in Excel

136

SIGN OF PRINCIPAL

Creating and Modifying Pivot Tables in Excel

137

Analyzing Data with Pivot Charts and Pivot Table Calculations

138
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Design
Scratch

PowerPoint

Presentations

SIGN OF C.I.
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Adding and Editing Audio and Video Elements in

Formatting Text, Fonts, and Layouts in PowerPoint
Navigating the PowerPoint Interface and Basic Tools
Creating and Editing a PowerPoint Presentation from

Inserting and Managing Images, Shapes, and SmartArt

Using Themes and Templates for Consistent Presentation

Using Transitions and Animations to Enhance PowerPoint

Working with Bulleted and Numbered Lists in PowerPoint
Adding and Managing Slides in a PowerPoint Presentation

Inserting, Formatting, and Managing Tables in PowerPoint

Creating a New PowerPoint Presentation
139

Navigating the PowerPoint Interface and Using Basic Tools

140
Batch No :-2

Adding, Editing, and Deleting Slides in PowerPoint

141

Inserting and Formatting Text in PowerPoint Slides

142

Using Themes and Templates for Consistent Design

143

Customizing Slide Layouts and Backgrounds

144

Managing Tables and Text Boxes in PowerPoint

145

Creating and Formatting Bulleted and Numbered Lists

146

SIGN OF G.I.
Inserting and Formatting Tables in PowerPoint
147

Adding and Managing Images, Shapes, and SmartArt

148

Working with Charts and Diagrams in PowerPoint

149
SKILL CHART : 8.MS-POWERPOINT
Computer Operator and Programming Assistant (COPA)

Inserting and Formatting Icons and 3D Models

150

Inserting and Managing Audio Files in PowerPoint

151

Adding and Editing Video Clips in PowerPoint

152
INSTRUCTOR :- YADAV V.A

Using Transitions Between Slides

153
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Adding and Customizing Animations to Text and Objects

154

Setting Up and Managing Slide Show Timings

155

Collaborating on PowerPoint Presentations

156

SIGN OF PRINCIPAL

Sharing and Co-authoring Presentations in PowerPoint

157

Reviewing and Adding Comments in PowerPoint

158
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Tables

Having Clauses

SIGN OF C.I.
Skill/Demo No.

Installation and Troubleshooting of MySQL

Assignment Name

Creating and Managing Databases in MySQL

Skill/Demo Name:

Writing Subqueries for Advanced Data Retrieval

Adding and Managing Indexes in MySQL Tables
Using DDL, DML, and DCL Statements in MySQL
Designing Tables and Applying Data Integrity Rules

Enforcing Constraints: Primary Key and Foreign Key in

Performing Joins and Grouping Data with Group By and

Writing Simple Select, Insert, Update, and Delete Queries

Using Number, Date, and Character Functions in Queries

Installing MySQL on Different Operating Systems
159

Troubleshooting Basic Installation Issues in MySQL

160
Batch No :-2

Creating and Managing Databases in MySQL

161

Designing Tables with Appropriate Data Types

162

Applying Data Integrity Rules for Consistent Data

163

Using Data Definition Language (DDL) Statements in MySQL

164

Using Data Manipulation Language (DML) Statements in MySQL

165

Using Data Control Language (DCL) Statements in MySQL

166

SIGN OF G.I.
Enforcing Constraints Like Primary Key and Foreign Key in Tables
167
SKILL CHART : 9.My-SQL

Adding and Managing Indexes in MySQL Tables

168

Writing Simple Select Queries to Retrieve Data

169
Computer Operator and Programming Assistant (COPA)

Inserting Data into Tables Using Insert Queries

170

Deleting Data from Tables with Delete Queries

171

Updating Existing Data in Tables Using Update Queries

172
INSTRUCTOR :- YADAV V.A

Using Number Functions in MySQL Queries

173
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Using Date Functions for Date and Time Operations in MySQL

174

Using Character Functions for String Operations in MySQL

175

Performing Table Joins: Inner, Left, Right, and Full Joins

176

SIGN OF PRINCIPAL

Grouping Data with Group By and Filtering with Having Clause

177

Writing Subqueries for Advanced Data Retrieval

178
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Computers
and Devices

Maintenance
Communication

Source Software
and Test Using Ping

Secure Network Access

Cables into Patch Sockets

SIGN OF C.I.
View and Analyze Network Connections
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Install and Configure a Wireless LAN for Network

Set Up and Configure a Wired LAN with Three or More

Set Up a Proxy Server or DHCP Server with Firewall for

Use Open-Source Tools for Network Troubleshooting and

Practice IP Addressing and Subnet Masking for IPv4/IPv6

Configure and Test Hubs and Switches in a Network Setup

Connect a Computer to a Network and Share Files, Folders,

Create and Test Straight and Cross Cables, and Punch UTP

Set Up Internet Access and Video Conferencing Using Open-

Viewing and Managing Network Connections.
179

Connecting a Computer to a Network.

180
Batch No :-2

Sharing Devices like Printers, Files, Folders, and Drives over a Network.
181

Identifying and Using Various Network Devices, Connectors, and Cables.

182

Creating Straight and Cross Cables for Network Connections.

183

Punching UTP Cables into Patch Sockets and Testing Connectivity.

184

Practicing IP Addressing and Subnet Masking for IPv4 and IPv6.

185

Testing Network Connectivity Using Ping Commands.

186

SIGN OF G.I.
Configuring a Hub and Switch for Network Communication.
187

Setting Up and Configuring a Wired LAN in a Computer Lab with at Least Three
188

Computers.

Configuring a Wireless LAN and Testing Connectivity.

189
Computer Operator and Programming Assistant (COPA)

Using a Patch Panel and I/O Box for Wired LAN Setup.
190

Installing and Configuring Internet Connections in Single PCs and LANs.

191
SKILL CHART : 10.Set-up & Configure a Computer Network

Setting Up a Proxy Server with a Firewall for Network Security.

192
INSTRUCTOR :- YADAV V.A

Configuring a DHCP Server to Manage IP Addresses.

193
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Setting Up Video Conferencing Using Open-Source Software.

194

Enabling Internet Access and Communication for LAN and Standalone PCs.
195

Using Open-Source/Free Tools for Network Troubleshooting and Maintenance.

196

SIGN OF PRINCIPAL

Implementing Network Security Measures for Wired and Wireless Networks.

197

Monitoring and Maintaining Network Health Using Diagnostic Tools.

198
 SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI
Computer Operator and Programming Assistant (COPA)

Batch No :-2 INSTRUCTOR :- YADAV V.A

SKILL CHART : 11.HTML & CSS

Skill/Demo No. 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218

Structuring Content with Semantic Tags like <header>, <footer>, and <section>.

Working with Box Model: Margins, Padding, and Borders.

Building Forms with Input Fields, Buttons, and Textareas.
Organizing Content with Ordered and Unordered Lists.

Designing Responsive Web Pages with Media Queries.

Linking an External CSS File to an HTML Document.
Understanding the Structure of an HTML Document.

Creating Tables Using <table>, <tr>, and <td> Tags.

Applying Background Colors, Images, and Patterns.

Using CSS Selectors and Combinators Efficiently.

Including Images in Web Pages with <img> Tags.
Creating Headings, Paragraphs, and Line Breaks.

Creating Layouts Using CSS Flexbox and Grid.

Adding Hover Effects to Elements with CSS.

Applying Attributes to HTML Elements.
Using Basic HTML Elements and Tags.

Adding Inline and Internal CSS Styles.

Styling Text: Fonts, Colors, and Sizes.

Styling Links and Navigation Menus.

Skill/Demo Name:

Adding Links Using Anchor Tags.

Assignment No.

Assignment Name

Create a Basic HTML Document with Headings,

1
Paragraphs, and Links

2 Design a Web Page with Images, Lists, and Tables

Develop a Web Form Using HTML Tags for Input Fields,

3
Buttons, and Textareas

4 Embed Audio and Video Elements in a Web Page

Create a Static Web Page with Internal CSS for Styling Text
5
and Backgrounds
Design and Link an External CSS File to Style a Simple
6
HTML Page

7 Use CSS Selectors to Style Specific Elements on a Web Page

Implement a Responsive Web Design Using CSS Media

8
Queries
Style a Navigation Bar Using CSS for Layout and
9
Interactivity
Design a Web Page with Styled Tables, Lists, and Forms
10
Using CSS

SIGN OF C.I. SIGN OF G.I. SIGN OF PRINCIPAL

 9
8
7
6
5
4
3
2
1

10
Assignment No.

Information

Slide Effect)
Page Content

Catch, and Finally

and Managing Data

Elements Dynamically
Results on a Web Page

Elements (Audio/Video)

Content Without Reloading

Instantiation and Inheritance

SIGN OF C.I.
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Create a JavaScript Class and Demonstrate Object

Build a Dynamic Web Page Using JavaScript to Update
Implement JavaScript to Handle User Input and Display
Create a Simple JavaScript Function to Manipulate Web

Create and Manipulate Objects in JavaScript for Storing

Embed JavaScript in an HTML Page to Display Dynamic

Design a Web Page with JavaScript to Control Multimedia

Develop a Simple Animation Using JavaScript (e.g., Fade In,
Use JavaScript to Modify the DOM and Add/Remove HTML

Write a JavaScript Program with Error Handling Using Try,

Understanding the role of JavaScript in creating dynamic HTML pages.
219

Embedding JavaScript into HTML documents using the <script> tag.

220

Using JavaScript to display information in web pages using document.write(),

Batch No :-2

221

innerHTML, or console.log().

Creating and modifying HTML elements dynamically using JavaScript.

222

Manipulating the DOM (Document Object Model) with JavaScript.

223

Handling user interactions (e.g., mouse clicks, form submissions) with event
224

listeners.

Working with JavaScript variables, data types, and operators.

225

Using control structures in JavaScript (e.g., if, else, switch, for, while).
226

SIGN OF G.I.
Defining and invoking functions in JavaScript to modularize code.
227

Passing parameters and returning values from JavaScript functions.

228
SKILL CHART : 12.JavaScript

Implementing error handling using try, catch, and finally blocks in JavaScript.
229
Computer Operator and Programming Assistant (COPA)

Using JavaScript’s throw statement for custom error handling.

230

Debugging JavaScript code using browser developer tools and console logs.
231

Creating and using objects in JavaScript to store related data.

232
INSTRUCTOR :- YADAV V.A

Accessing and modifying object properties and methods.

233
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Defining classes in JavaScript and creating instances (objects).

234

Working with object inheritance in JavaScript using prototypes.

235

Creating simple animations using JavaScript (e.g., changing element styles over
236

time).

Integrating multimedia content (audio, video, images) into web pages using
SIGN OF PRINCIPAL
237

JavaScript.

Using JavaScript for more complex animations and interactive visual effects (e.g.,
238

HTML5 canvas or CSS3 animations).

 9
8
7
6
5
4
3
2
1

10
Assignment No.

Sets

Data
Excel

in Excel
Data in Excel

Multiple Sources

Reporting and Analysis

SIGN OF C.I.
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Create Simple Data Visualizations Using Power BI for

Use Power Query to Import and Transform Data from
Create and Modify Simple Macros to Automate Tasks in

Create a PivotChart to Visualize Data from a PivotTable

Combine Multiple Queries in Power Query to Consolidate

Perform Date Calculations Using Advanced Date Functions
Design a Data Entry Form with Macros for Easy User Input

Use VLOOKUP and INDEX-MATCH Functions to Look Up

Develop a PivotTable to Summarize and Analyze Large Data

Create and Customize Charts in Excel for Data Visualization
Creating and Modifying Simple Macros in Excel
239

Recording and Running Macros for Automation of Repetitive Tasks

240
Batch No :-2

Creating and Using Data Entry Forms with Macros for User Input
241

Using Excel Functions to Look Up Data (e.g., VLOOKUP, HLOOKUP, INDEX-

242

MATCH)

Implementing Conditional Logic with Excel Functions (e.g., IF, SUMIF,

243

COUNTIF)

Using Advanced Date Functions in Excel (e.g., DATE, YEAR, MONTH,

244

DATEDIF)

Performing Date Calculations and Analyzing Date Ranges

245

Sorting and Filtering Data Based on Date Criteria

246

SIGN OF G.I.
Creating and Modifying Basic Charts in Excel (e.g., Bar, Line, Pie charts)
247

Customizing Chart Elements (Titles, Axes, Labels, Legends)

248

Using Advanced Chart Types for Data Visualization (e.g., Histogram, Radar,
249

Combo charts)
Computer Operator and Programming Assistant (COPA)

Creating Dynamic Charts Using Named Ranges and Data Validation

250

Creating and Modifying PivotTables for Summarizing Data

251
SKILL CHART :13.Data Visualization or Analysis using Excel

Using PivotTable Filters, Rows, Columns, and Values to Analyze Data

252
INSTRUCTOR :- YADAV V.A

Creating PivotCharts to Visualize PivotTable Data

253
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

Creating and Modifying Queries Using Power Query

254

Transforming and Cleaning Data Using Power Query (e.g., Removing duplicates,
255

Changing data types)

Invoking Power Query Functions to Automate Data Transformation

256

SIGN OF PRINCIPAL

Combining Multiple Queries in Power Query to Consolidate Data

257

Organizing and Managing Workbook Queries Using Power Query

258
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Order Price
Functionalities

Delivery Times

Commerce Platform
Using a Credit/Debit Card
Compare Multiple Options

Making a Purchase Decision

Before Proceeding to Checkout

Search on an E-Commerce Site

Commerce Sites and Suggest Solutions

SIGN OF C.I.
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Identify Common Security Issues When Browsing E-

Review Customer Feedback and Product Ratings Before
Complete an Order Transaction on an E-Commerce Site

Use Filters and Sorting Options to Narrow Down Product

Search for a Specific Product on an E-Commerce Site and

Apply a Discount Code During Checkout and Confirm the

Track an Order After Purchase and Analyze the Estimated

Explore an E-Commerce Site and List Its Key Features and

Process a Return/Exchange for an Item Purchased on an E-

Add a Product to Your Shopping Cart and Review the Cart
Demonstrating How E-Commerce Sites Function and Operate
259

Listing the Common Features of E-Commerce Websites (e.g., Search, Product

260

Filters, Reviews)
Batch No :-2

Navigating E-Commerce Sites to Identify and Compare Products and Services

261

Exploring Different Categories of Products and Services on E-Commerce

262

Platforms

Evaluating Product Details (e.g., Description, Specifications, Pricing, and

263

Availability)

Using E-Commerce Sites to Search for Specific Products or Services

264

Applying Filters and Sorting Options to Narrow Down Search Results

265

Reading and Analyzing Customer Reviews and Ratings to Inform Purchase

266

Decisions

SIGN OF G.I.
Using Advanced Search Techniques to Find Products Based on Specific Criteria
267

(e.g., Brand, Size, Color)

Comparing Multiple Products from Different Sellers on an E-Commerce Site

268

Adding Products to the Shopping Cart for Purchase

269
Computer Operator and Programming Assistant (COPA)

Reviewing and Editing Shopping Cart Items Before Checkout

270

Identifying Product Availability and Estimated Delivery Times

271

Completing the Order and Payment Process on an E-Commerce Site

272
INSTRUCTOR :- YADAV V.A

Applying Coupons, Discounts, and Promo Codes during Checkout

273

Undertaking Secure Transactions on E-Commerce Sites Using Credit Cards,

SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

SKILL CHART : 14.Browsing E-Commerce Sites to Identify Products & Services

274

Debit Cards, or E-Wallets

Understanding Payment Gateway Systems and Their Role in E-Commerce

275

Confirming Order Details and Receiving Payment Confirmation After

276

Completing a Purchase
SIGN OF PRINCIPAL

Tracking Orders and Processing Returns/Exchanges on E-Commerce Platforms

277

Identifying Common Security Issues on E-Commerce Sites (e.g., Phishing, Fraud,

278

Data Protection)
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Services

on a PaaS Service

Seamless Workflow
and Connect to it Remotely
(e.g., Dropbox, Google Drive)
and Set Up a Virtual Machine

Explore File Sharing Features

365) for Document Collaboration

SIGN OF C.I.
Skill/Demo No.

Platform (e.g., Heroku, Google App Engine)

Assignment Name

Platform and Integrate it with an Application

Skill/Demo Name:

Create and Configure a Database Service on a PaaS

Create a Simple Application and Deploy It on a PaaS

Use a Free SaaS Tool (e.g., Google Workspace, Microsoft

Integrate Multiple Cloud Services (IaaS, PaaS, SaaS) for a

Sign Up for a Free IaaS Service (e.g., AWS, Google Cloud)

Use Free Cloud Storage (e.g., Google Drive, OneDrive) and

Deploy and Configure a Virtual Network Using IaaS Cloud

Manage User Access and Permissions in a SaaS Application

Set Up Auto-Scaling and Load Balancing for an Application

Deploy an Operating System on a Cloud Platform Using IaaS

Understanding the Different Service Models of Cloud Computing (IaaS, PaaS,
279

SaaS)

Exploring the Benefits and Challenges of Cloud Computing

280
Batch No :-2

Understanding Cloud Storage, Security, and Data Privacy

281

Learning about Cloud Deployment Models (Public, Private, Hybrid)

282

Getting Familiar with Cloud Providers (e.g., AWS, Google Cloud, Microsoft
283

Azure)

Using Free IaaS Cloud Services (e.g., AWS Free Tier, Google Cloud Free Tier)
284

Setting Up Virtual Machines (VMs) on IaaS Platforms

285

Managing and Configuring Virtual Networks in IaaS Environments

286

SIGN OF G.I.
Deploying Operating Systems and Applications on IaaS Resources
287

Scaling Infrastructure Resources (e.g., Compute, Storage) on IaaS Platforms

288

Using Free PaaS Cloud Services (e.g., Heroku, Google App Engine, AWS Elastic
289
SKILL CHART : 15.Cloud Computing

Beanstalk)
Computer Operator and Programming Assistant (COPA)

Deploying Applications Using PaaS Platforms

290

Managing Application Services (e.g., Databases, APIs) on PaaS

291

Integrating Development Tools with PaaS for Application Deployment

292
INSTRUCTOR :- YADAV V.A

Using Auto-Scaling and Load Balancing in PaaS Environments

293

Using Free SaaS Cloud Services (e.g., Google Workspace, Microsoft 365,
SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

294

Dropbox)

Accessing and Managing SaaS Applications for Business or Personal Use

295

Collaborating and Sharing Documents Using SaaS Tools

296

SIGN OF PRINCIPAL

Integrating SaaS Tools with Other Cloud Services

297

Managing User Accounts and Permissions in SaaS Platforms

298
 9
8
7
6
5
4
3
2
1

10
Assignment No.

Key Components

Deployment Phase
Phase of the ADLC

Impact on the ADLC

Types of Testing Used

and Discuss Challenges

Development Life Cycle

Explain the Development Process

Application Development Life Cycle
Application Development Life Cycle

SIGN OF C.I.
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Explain the Importance of Feasibility Study in the

Identify and Explain the Phases of the Application

Write a Sample Code for the Development Phase and

Compare Waterfall and Agile Models and Explain Their

Describe the Role of the Business Analyst in the Analysis

Discuss the Role of Maintenance and Support in the Post-

Design a Simple Application Architecture and Explain Its

Create a Test Plan for an Application and Explain Different

Create a Flowchart Representing the Different Phases of the

Document the Deployment Process for a Sample Application

Identifying the Planning Phase: Defining the project scope, goals, and objectives.
299

Recognizing the Feasibility Study Phase: Assessing technical, operational, and

300

financial feasibility.
Batch No :-2

Understanding the Design Phase: Designing the architecture and user interface of
301

the application.

Exploring the Development Phase: Writing the code, building the application, and
302

integrating components.

Defining the Testing Phase: Ensuring quality and performance through various
303

types of testing (unit, integration, etc.).

Understanding the Deployment Phase: Deploying the application into a live

304

environment and making it available to users.

Recognizing the Maintenance Phase: Updating and fixing the application after
305

deployment to ensure ongoing functionality.

Distinguishing Between Iterative and Waterfall Models: Understanding different

306

development models and when to apply them.

SIGN OF G.I.
Mapping the Phases in a Visual Format: Creating diagrams and flowcharts to
307

visualize the phases of the ADLC.

Describing the Importance of Each Phase in ADLC: Knowing how each phase
contributes to the overall success of the project.
308

Business Analyst in the Analysis Phase: Gathering and analyzing project

309

requirements.
Computer Operator and Programming Assistant (COPA)

Project Manager in the Planning Phase: Overseeing project timelines, resources,

310

and deliverables.

System Architect in the Design Phase: Designing technical architecture and high-
311
SKILL CHART : 16.Application Development Life Cycle

level specifications.

Developers/Programmers in the Development Phase: Writing the code and

312

integrating software components.

INSTRUCTOR :- YADAV V.A

UI/UX Designer in the Design Phase: Designing the user interface and ensuring a
313

good user experience.

Database Administrator (DBA) in the Design Phase: Designing and managing

SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

314

databases for the application.

Quality Assurance (QA) Engineer in the Testing Phase: Conducting various tests
315

to ensure application stability and performance.

Security Expert in the Testing Phase: Ensuring the application is secure from
316

potential vulnerabilities.

Deployment Engineer in the Deployment Phase: Managing the deployment

SIGN OF PRINCIPAL
317

process, ensuring the system runs smoothly post-launch.

Support and Maintenance Team in the Maintenance Phase: Providing ongoing

318

support and ensuring the system operates efficiently.

 9
8
7
6
5
4
3
2
1

10
Assignment No.

in Python.
Statement.

Docstrings.

Operations.
Comprehensions.
Number Positivity.

Data Manipulation.
Various String Operations.

SIGN OF C.I.
Skill/Demo No.

Assignment Name
Skill/Demo Name:

Write a Python Program that Demonstrates List

Document a Python Program Using Comments and

Create a Python Program to Manipulate Strings Using

Use Python Built-in Modules for Mathematical and Date

Create a Program to Use Tuples, Sets, and Dictionaries for
Install Python and Set Up an IDE for Python Development.

Perform Basic Arithmetic and Type Conversion Operations

Write a Python Program to Print a Message Using the Print

Write a Program that Uses Conditional Statements to Check

Implement a Python Program that Uses for and while Loops.

Install and Set Up Python Environment: Install Python on your system and
319

configure the development environment (IDE or CLI).

Run Python Programs: Execute Python programs using both command-line

320

interface (CLI) and Integrated Development Environments (IDE).

Batch No :-2

Use Print Statements and Comments: Write Python programs with print()
321

statements and document code with comments.

Declare and Use Variables: Create variables with appropriate data types and
322

perform simple operations.

Understand Python Data Types: Work with different Python data types such as
323

integers, floats, strings, booleans, and complex numbers.

Perform Data and Data Type Operations: Conduct arithmetic and logical
324

operations on various data types, and perform type conversions.

Apply String Operations: Use string methods and operators for concatenation,
325

slicing, and manipulation.

Work with Input and Output: Handle user input and format outputs in Python.
326

SIGN OF G.I.
Use Operators in Python: Understand and apply arithmetic, logical, comparison,
327

and assignment operators.

Determine Operator Precedence: Understand the order of operations (PEMDAS)

328

in Python and how it affects expression evaluation.

Write Branching Statements: Implement if, elif, and else statements to control
329

program flow based on conditions.

Computer Operator and Programming Assistant (COPA)

Create Loop Structures: Use for and while loops for repetitive tasks and data
330

iteration.

Document Code with Comments and Docstrings: Use inline comments and
331
SKILL CHART : 17.Application Development Life Cycle

docstrings to make code readable and explain its purpose.

Use List Comprehensions: Create concise and efficient code with list
332

comprehensions for transforming and filtering data.

INSTRUCTOR :- YADAV V.A

Work with Tuples in Python: Understand and utilize tuples for storing immutable
333

sequences of data.

Implement Sets in Python: Use sets to store unordered collections of unique

SHREE GORAKSHNATH GOVT. INDUSTRIAL TRANING INSTITUTE , SHIRALA DIST.SANGLI

334

elements and apply set operations.

Work with Dictionaries: Create and manage key-value pairs using Python
335

dictionaries.

Perform Basic Operations with Built-In Modules: Use Python’s built-in modules
336

like math, datetime, random for specific tasks.

Handle Date and Time Operations: Perform operations with dates and times using
SIGN OF PRINCIPAL
337

Python’s datetime module.

Apply Functions and Classes: Create reusable functions and classes, understand
338

their syntax, and implement basic object-oriented principles.