Introduction

U.P. Electronics Corporation Limited (UPLC) is a state Government Undertaking engaged in providing IT services to various Government Department including training of Government Employees. It has been providing computer training to government employees since 2002 and imparting training to government employees at UPLC’s own Computer Centres/ Labs and computer centres of Authorized Business Associates empanelled by UPLC for conducting computer training of government employees vide GO No. 1157/78-IT-2001 dated 13.08.2001 and GO No. 1220/78 IT-2-2002 dated 12.07.2002. UPLC has a vast network of centres through their Business Associates, operational in all districts of Uttar Pradesh.

Concerned Officers/ Staff for Computer Education Division:

• Mrs Taruni Garg, Assistant Manager (Computer Educating & Training)

Objectives of the Training

• The Objectives of imparting computer training to the government employees of Uttar Pradesh is to acquaint the staff with the Course on Computer Concept (CCC i.e. Basic Course): So that, it could help them to discharge their routine work more professionally and proficiently in a short span time. It could also help the staff to achieve proficiency in computer operations vis-a-vis with their routine job. Besides these, we are providing DOEACC “O” Level equivalent course Job Orientation Programme through Government Department and short term Computer Training at ACL Centre, Agra, 4, Dhaulpur House, M.G. Road, Agra.

(i) Certificate on Computer Course (CCC) – 80 hrs Programme

• Duration : 80 Hours - (Theory: 25 hrs + Practical: 50 hrs+ Tutorial: 5 hrs)

S.No.	Module Unit Duration	Theory	Tutorial	Practical
1	Introduction to computer	2	1	4
2	Introduction to GUI Based Operating System	3	-	8
3	Elements of Word Processing	4	2	10
4	Spreadsheets	4	2	10
5	Computer communication and Internet	4	-	5
6	WWW and web browsers	2	-	3
7	Communication and Collaboration	2	-	3
8	Making small presentations	4	-	8
9	Grand Total	25	5	50

Duration of the Training :

• The duration of the training shall be 80 hours of which 8 hours training daily to be given which shall be completed in 10 days or 04 hours training/day will be completed in 20 days. These training will be provided in batches.

Certificates :

• The certificates shall be issued to the trainees by U.P. Electronics Corporation Limited (UPLC), Lucknow to the centre after the receipt of satisfactory performance report of the centre issued by the competent authorities of the District offices of government department and availability of training fees.

Training Fees per trainee:

• The training fees for imparting computer training shall be 2400/- per trainee, which is as per the GO No. 1157/78/IT-2001 dated 13.8.2001..

S.No.	Particulars	80 hours Training Cost (in ₹)
1	Training Fees: for 80 hours ₹2400/- per trainee. Service Tax 12.36%	2400.00 297.00
	Total =	2697.00

IT Tools and Application

S.No.	Major Topic	Hours
1	Computer Application	4
2	Computer Organization	13
3	Operating System	13
4	Word Processing	10
5	Spreadsheet Package	10
6	Presentation Package	10
7	Information Technology & Society	4

Module-2

S.No.	Major Topic	Hours
1	Introduction to Business Data Processing	6
2	Concept Files	6
3	Principles and Techniques of Programming	6
4	Visual FoxPro	38
5	Business Application	8
		Lectures = 60 Practical = 60 ------------------------------------ Total = 120 Hours ------------------------------------

Module-3

Internet and Web Design

Duration in hours

S.No.	Major Topic	Hours
1	Introduction to Internet	2
2	Internet Technology and Protocol	8
3	World Wide Web	6
4	Browsers	5
6	Electronic Mail	8
7	File Transfer Protocol	3
8	Telnet	2
9	Internet Relay Chat	1
10	Web Publishing	4
11	HTML	9
12	Interactivity Tools	4
13	Multimedia and Graphics	4
14	Internet Security Management Concepts, Information Privacy and Copyright Issues	3

Module-4

Programming and Problem Solving Through ‘C’ Language Design

Duration in hours

S.No.	Major Topic	Hours
1	Introduction to Programming	4
2	Algorithms for Problem Solving	12
3	Introduction to ‘C’ Language	4
4	Conditional Statement and Loops	6
5	Arrays	8
6	Functions	3
7	Structures and Unions	2
8	Pointers	1
9	Self Referential Structures and Linked Lists	4

Certificates:

The certificates shall be issued to the trainees by U.P. Electronics Corporation Limited (UPLC), Lucknow to the centre after the receipt of satisfactory performance report of the centre issued by the competent authorities of the District offices of government department and availability of training fees.

Training Fees per trainee:

The training fees for imparting computer training shall be 8500/- per trainee, which is as per the GO No. 1157/78/IT-2001 dated 13.8.2001.

S.No.	Particulars	480 hours Training Cost
1	Training Fees: for 480 hours ₹8500/- per trainee. Service Tax 14%	8500.00 1190.00
	Total =	9690.00

(iii) As per department requirement Computer Training may also be given 30/hrs. and Service Tax 14% (or as applicable)

Training Fees per trainee:

The training fees for imparting computer training shall be 30/hrs., which is as per the GO No. 1157/78/IT-2001 dated 13.8.2001.

U P Electronics Corporation Limited owns Computer Labs. Details are as under:

1. U P Electronics Corporation Limited, Nav Chetna Kendra, 10, Ashok Marg, Lucknow have 02 Computer Labs & having each 20 Computers, Incharge Shri Rajiv Karnatak Mobile No. 9721451220
2. U P Electronics Corporation Limited, ACL Agra Centre at 4, Dhaulpur House, M. G. Road, Agra, approved by DOEACC Authority, Government of India, Incharge, Shri Premkant Sharma, Mobile No. 9235567216

UPLC have empanelled Business Associates, who have nominated Computer Centres in all Districts of Uttar Pradesh:-

S.No.	Name of Business Associates	Validity Period
1	M/s Sri Ram New Horizons, Limited, Lucknow	05/05/2012 to 04/05/2015
2	M/s MHWH Computer Education Society, Lucknow	04/01/2012 to 03/01/2015
3	M/s Navodaya Lok Kalyan Samiti, Lucknow	22/06/2012 to 21/06/2014
4	M/s Tanmay Institute of Computer Education, Lucknow	12/12/2011 to 11/12/2014
5	M/s Rajeev Gandhi Computer Saksharata Mission, Lucknow	12/12/2011 to 11/12/2014
6	M/s Satya Solutions, Lucknow	21/07/2012 to 20/07/2015
7	M/s Planet Comnet Technologies (P) Limited, Lucknow	18/01/2013 to 17/01/2016
8	M/s BSN Infotech PVT. Limited, Lucknow	15/06/2013 to 14/06/2016
9	M/s Saraswati Foundation, Lucknow	20/06/2013 to 19/06/2016
10	M/s B S L Infra – Tech Private Limited	5/7/2013 to 4/7/2016

Computer Training in-hand (Period 01.04.2013 to 24.10.2013):-

S.No.	Name of Department	Training expected Fees (in ₹ )
1	Kaushal Vriddhi Computer Training for SC/ST candidates by ANUGAM for 2013-14	2,70,00,000.00
2	Samaj Kalyan Department	Near about 15,00,000.00
3	Directorate, Sainik Kalyan, Uttar Pradesh for dependent of Ex. Servicemen	32,72,500.00
4	Irrigation Department	1,44.000.00
5	600 Hrs./one year computer training for candidates by DUDA	2,50,000.00
6	180 Hrs. computer training for educated unemployed students under DUDA in the Districts: of Balrampur & Basti	4,02,500.00
7	06 months computer training for minority students by Alp Sankhyak Vitta Evam Vikas Nigam Limited	4,50,268.00
8	Rajya Krishi Utpadan Parishad, Uttar Pradesh	Near about 10,00,000.00
	Total =	3,40,19,268.00

Syllabus of O level Course

1. Duration : 480 Hours - (Theory: 192 hrs + Practical: 288 hrs)

Module 1:Information Technology Tools and Network Basics

1. Duration : 120 Hours - (Theory: 48hrs + Practical: 72 hrs)

Module Unit Duration	Practical		Learning objective
	Theory	Practical
1. Introduction to Computer	4	6	After completion of this unit of module, the Learner will be able to Identify computers, IT gadgets and explain their evolution and applications. Get familiar with various input, output and hardware components of a computer along with storage devices. Get familiar with various types of software, utilitiesused for computer and mobile apps.
2. Introduction to Operating System	4	6	After learning this unit, Learner will be: Well acquainted with Operating System and its applications for both desktop and mobile devices. Able to identify various desktop screen components and modify various properties, date, time etc. Able to add and remove new program and features, manage files and folders. Well versed with printing and know various types of file extensions.
3.Word Processing	6	9	After completion of this unit, Learner will have in depth knowledge of Word Processing, their usage, details of word processing screen. Opening, saving and printing a document including pdf files. Document creation, formatting of text, paragraph and whole document . Inserting Header and Footer on the document. Finding text on a word document and correcting spellings. Inserting and manipulating tables, enhancing table using borders and shading features. Preparing copies of a document labels etc. for sending various recipients using Mail Merge.
4.Spreadsheet	8	12	After completion of this unit, Learner will have good handson practice on Basic Knowledge of Spreadsheet Processing, their usage, details of Spreadsheet screen. Opening, saving and printing a Spreadsheet. Spreadsheet creation, inserting and editing data in cells, sorting and filtering of data. Inserting and deleting rows /columns. Applying basic formulas and functions. Preparing chart to represent the information in a pictorial form.
5.Presentation	6	9	After completion of this unit, Learner will have good hands on practice on Basic Knowledge of presentations. Opening/saving a presentation and printing of slides and handouts. Manipulating slides to enhance the look of the slides as well as whole presentationby inserting a picture, objects, multimedia formatting etc. Running a slide show with various transitions.
6.Introduction to Internet and WWW	6	9	After completion of this unit, Learner will be able to Gather knowledge of various types of networks and topologies Get an overview of the Internet, its applications and various browsers available to access the Internet. Connect to the Internet using various modes of connections/devices available. Get knowledge of device identification on local network as well as on the Internet for both Desktop and Mobile Devices. Can search Information on the Internet on various topics. Download and print web pages.
7. E-mail, Social Networking and e-Governance Services	6	9	After completion of this unit, Learner will be able to Create an email account, compose an email, reply an email and send the email along with attachments Get familiar with Social Networking, Instant Messaging and Blogs. Get familiar with e-Governance Services, e-Commerce and Mobile Apps.
8. Digital Financial Tools and Applications	4	6	After completion of this unit, Learner will be able to Know the Digital Financial Tools. Get Knowledge of the Internet Banking Modes. Use the Digital Locker and will be able to store documents in Digital Locker.
9. Overview of Future Skills& Cyber Security	4	6	After completion of this unit, Learner will be familiar with the Latest trends and technologies in upcoming fields in IECT. Need of Cyber Security and will be able to secure their PC and Mobile devices by using basic security features.

Module 2:Web Designing and Publishing

1. Duration : 120 Hours - (Theory: 48hrs + Practical: 72 hrs)

Module Unit Duration	Practical		Learning objective
	Theory	Practical
1.Introduction to Web Design	2	3	After completing this unit, Learner will be able to Know the types of website. Know the role of front end and back end application. Understand the concept of client side scripting and server side scripting
2. Editors	2	3	After completing this unit, learner will be able to Use different editors available for writing code. Understand working of editors
3.HTML Basics	10	15	After completing this unit, Learner will be able to develop static website using different HTML Controls. Inserting and manipulating tables, enhancing table using borders and shading features. Preparing copies of a document labels etc. for sending various recipients using Mail Merge.
4.Cascading Style Sheets (CSS)	10	15	After completing this unit, Learner will be able to understand the Purpose of CSS. Role of CSS in websites. Roles of effects in Web site.
5.CSS Framework	6	9	After completing this unit, Learner will be able to use CSS Framework to develop web site effectively.
6.JavaScript and Angular JS	10	15	After completing this unit, Learner will be able to Apply client side scripting. Adding validations and checks on forms (web pages).
7. Photo Editor	6	9	After completing this unit, Learner will be able to edit images and embed in web pages.
8.Web Publishing and Browsing	2	3	The Learner will finally be able to publish the websites.

Module 3:Programming and Problem Solving Through Python Language

1. Duration : 120 Hours - (Theory: 48hrs + Practical: 72 hrs)

Module Unit Duration	Practical		Learning objective
	Theory	Practical
1. Introduction to Programming	2	3	After completion of this unit of module, Learner will be able to Understand the concept of Programming. Understand evolution of Programming.
2. Algorithm and Flowcharts to solve problems	6	9	After completion of this unit of module, Learner will be able to Understand the concepts and purposes of algorithm and flowchart. Use algorithm and flowchart to solve problem independent of language. Gain knowledge of different constructs of algorithm and flowchart.
3. Introduction to Python	2	3	After completion of this unit of module, candidate will be able to Understand features of Python that make it one the most popular languages in the industry. Understand structure of Python problem. Understand the areas where Python is used.
4. Operators, Expressions and Python Statements	10	15	After completion of this unit of module, Learner will be able to Use the basic operators and expressions available in Python in developing program. Understand and use various Python statements like conditional constructs, looping construct
5. Sequence data types	6	9	After completion of this unit of module, Learner will be able to Work with various built-in Sequence datatypes and their use Understand the concept of mutable and immutable objects
6. Functions	10	15	After completion of this unit of module, Learner will be able to Apply the in-built functions available in Python in solving different problems. Work with modular approach using user defined functions.
7. File Processing	6	9	After completion of this unit of module, Learner will be able to work with files and reading/writing onto files.
8. Modules	2	3	After completion of this unit of module, Learner will be able to Understand the concept of modules and importing, loading and reloading of modules in programs.
9. NumPy Basics	4	6	After completion of this unit of module, Learner will be able to Work on NumPy array manipulation to access data and subarrays and to split, reshape, join arrays etc

Module 4:Internet of Things and its Applications

1. Duration : 120 Hours - (Theory: 48hrs + Practical: 72 hrs)

S. No.	Module Unit Duration	Practical		Learning objective
		Theory	Practical
1.	Introduction to IoT Applications/Devices, Protocols And Communication Model	4	6	After completion of this unit of module, Learner will be able to
2.	Things and Connections	4	6	After completing this unit, Learner will be able to understand Closed loop/ feedback loop system. The use of sensors, actuators and controllers in the IoT process flow. TCP/IP Versus OSI models. Wired and wireless connectivity.
3.	Sensors, Actuators and Microcontrollers	8	12	After completing this unit, Learner will be able to understand The role of Sensors, transducers in measuring physical quantities. Working and characteristics of actuators. Role and use of microcontroller in building various electronic devices.
4.	Building IoT Applications	20	30	After completing this unit,Learner will be able to understand Working of microcontroller and hardware prototyping Arduino platform . The role of ‘C’ language in building IoT applications. Built-in Data-type, operators-expressions Conditional statements and loops. Arrays, functions. Digital, analog pins of Arduino. Interfacing sensors, actuator. Using ArduBlock GUI tool.
5.	Security and Future of IoT Ecosystem	4	6	After completing this unit Learner will be able to understand Need of security in IoT. Various basic concept of security. Security levels. Need of powerful CPU for Future IoT eco system.
6.	Soft skills-Personality Development	8	12	After completing this unit, Learner will be able to understand Role of positive personality and determinants of personality. Self-esteem. Communication and writing skills.

Note: For any further information you may be contact to Mrs Taruni Garg, Assistant Manager (Computer Education & Training) Phone no 0522 4130303 ext 316

(Mrs Taruni Garg)
Assistant Manager
Computer Education & Training