Transcript Document
ER & DCI NOIDA
ISO 9001 Organization
ABOUT ER&DCI, NOIDA • A Scientific Society under Department of Information Technology in the fore front of Research & Training • Merged with the newly formed ER&DCI Society in 1994 • Governed by the Governing Council, DIT, M/o C&IT
ER & DCI NOIDA
AREA OF COMPETENCE
RESEARCH HI-TECH EDUCATION Broad Band Technologies NLP Security Systems
ER & DCI NOIDA
e-Governance Career Development Business Oriented Skill Upgradation Formal Software Applications Internet Based Technology Non-Formal
“TAILOR NEW TECHNOLOGIES TO SUIT THE NATIONS NEEDS”
OBJECTIVES OF ER&DCI, NOIDA • To undertake Application Oriented Region Specific Research,Design, Development and Engineering on a mission oriented and time bound manner.
• To generate the State-of-the-Art, Producible, Marketable and Field Maintainable Products and Systems.
• To promote accelerated growth of Electronics Industry in the region and to enhance their self-reliance for Technologies, System Engineering, Industrial Design, Pilot Production etc.
• To forge institutional linkages between Academia, R&D Institutions and Industries for developing Commercial Technologies.
• • To develop Human Resources in Hi-Tech Areas.
Business process study, need based ERP solution and implementation of ERP Software globally.
SERVICES OFFERED
• • •
System Integration & Maintenance
Internet Service Provider – FASTNET&E-
DACNET- An e-Governance Project
This is an e-governance project of Department of Agriculture and cooperation, being executed by National Informatics centre to facilitate Agriculture-on-line. DACNET is conceived and designed to address the following issues Qualitative enhancements in the work culture by introducing better transparency and work flow automation Streamlining the existing methods and practices, both administrative and technical aspects Easy access to the publishable information with minimum administrative intervention, with proper Query and Request features
DACNET- An e-Governance Project
Faster and reliable information dissemination and exchange across the Ministry and their Directorates and field units Greater integration and use of data from variety of data sources Optimum utilization of available recourses including office stationary and there by helping to inch towards the paper-less office Internet-to-Internet capability to provide Tele-commuting features and thus providing geography-independent working Better Communication among the officers of the organization using E-mail/ messaging to enhance better coordination, knowledge sharing and research
Scope of DACNET
• Establishing e-business Infrastructure • Achieving the minimum agenda of e-governance • Developing e-governance application package • Integration of Government functions • Enhancing Government productivity • Decision support for planners • IT empowerment of the officials of the Directorates/Attached/Subordinate and the field unit • Users in e-governance which would eventually facilitate agriculture-on-line
DACNET-Its Objectives
• Manpower Development of Department Of Agriculture Cooperation • Computerisation of Department Of Agriculture Cooperation • Computer Training to Officials of the Department Of Agriculture Cooperation • Total number 2650 candidates to be trained by ER&DCI,Noida at seven different locations.
WHY - DACNET
• 100 % Computer literacy.
• Directorates under single umbrella of Network.
• Faster Communication through Internet.
• Easier Data sharing and more transparency.
Level of Participants for the Training Modules 5 6 3 4 S.No
1 2 Course Title Office Productivity Tools (OPT) Level of participants A,B and C Database Creation and Analysis (DCA) Decision Support system (DSS) A,B and C A, B and Interested C Geographical Information System (GIS) A, B and Interested C CAD/CAM A,B,C SPSS * A,B * This module is not covered by ER&DCI, Noida
Training Programmes of DACNET training
• Office Productivity Tools • Database Analysis and Design • Decision Support System • Geographical information System • CAD/CAM (Only at Bhopal)
WHY Office Productivity Tools
• Helping the participants to understand the Computers and using the Computers as User Friendly Tool • It creates a base to understand the other modules • Be confident to handle the computers for their official work to expedite their job efficiently.
• Browsing the Web Site for searching the data according to the Directorates necessity .
• Using e-Mail for sending and receiving data.
Contents of Office Productivity Tools
• The Applications which are covered under OPT are • MS-Word • MS-Excel • MS-PowerPoint • MS-Outlook and Internet
Office Productivity Tools MS-WORD
• Editing of Document • Formatting of Document • Tables, Mail Merge and Macros • Advance Features – Smart Tags, Task Pane etc.
• Lab Exercises: – Comprehensive exercise based on all the topics
Office Productivity Tools MS-EXCEL
• Working with Cells • Sheets and Workbooks • Editing • Insertion of Formulas, • Functions, Charts, Filters, Goal Seek etc • Advance Features – Smart Tags, Task Pane etc.
Lab Exercises: • Comprehensive exercise based on all the topics
Office Productivity Tools MS-POWERPOINT
• Working with slides • Customizing • Color Scheme • Design template • Animations – Preset – Customizing – Timing Lab Exercise: • Comprehensive exercise based on all the topics
Office Productivity Tools MS-OUTLOOK and INTERNET • Using Day, Week and Month Calendar • Working with Task Folder • Content Folder • Email • Browsing • Searching.etc.
• Lab Exercise: – An exercise based on on these topics.
Case Study
• A case study was taken in which the participants had to use all the Applications of Office Productivity Tools.
• This included most of the important features and also helped the participants to grasp the practical use of these topics.
What the Participants can be expected to accomplish after undergoing the training in this module • Creating and managing Files and Folders • Preparing a Document in the required Format • Effective Working with Tables and through Mail Merge and Macros.
• Prepare a Salary Sheet using Formulas and setting up the required Worksheet.
• Graphical representation through Charts.
• Preparation of PowerPoint presentation – With Formatting – Animation.
• Can be expected to send and receive e-mails.
WHY Database Analysis and Design
• After the Introduction to Computers (OPT) the stage was SETUP for next Step.
• How to create and analyse the data.
• The database concept is very useful for Directorates so that redundancy could be removed and all records could be maintained easily.
Database Creation and Analysis
• Database Overview, Normalization, Overview of MS Access, • Tables, Multi Tables and their Relations-an comprehensive exercise based on these topics • Queries-an comprehensive exercise based on these topics • Forms-an comprehensive exercise based on these topics • Reports-an comprehensive exercise based on these topics
Case Study
A case Study based on the participants Directorate.
What the Participants can be expected to accomplish after undergoing the training in this module • Creating Database and managing them.
• Redundancy less Tables • Multiple Tables • Relationships • Retrieving the Data as per requirement • Adding the Data using Forms.
• Giving reports as per requirement.
WHY DECISION SUPPORT SYTEM
• After DD&A the next module to be conducted is DSS, which is used to take the efficient decisions • DSS is used in the case of unstructured problems where there is no specific solution.
• Used to Maximise or minimise objective function according to the requirments
Decision Support System
• Overview of System and Information System- a Case Study based on these topics • Introduction to Decision Support System • Decision making Process- a Case Study based on these topics • Implementation of Decision Support System- a Case Study based on these topics • Group Decision Support System- a Case Study based on these topics • Expert Systems- a Case Study based on these topics • Data Warehousing • Implementation of Practical computer based Decision Support System through – Goal Seek – Scenario – Solver-Pivot Table.
What the Participants can be expected to accomplish after undergoing the training in this module • Designing Information System • Taking help of Database for arriving at Decisions.
• Practical Implementation through features of Excel.
• The participants can understand the software to be provided by NIC
Why GIS
• Designing Information System • Taking help of Datadbase for arriving at Decisions.
• Practical Implementation through features of Excel.
• The participants can understand the software to be provided by NIC
Geographical Information System
• Introduction to GIS and Remote Sensing • Over view of various Software • Import / Exporting • Geo Referencing • Removing Residual errors • Digitization • Attachment to Database • Queries • Styles Case Study A case Study will be taken based on the Agriculture Department
What the Participants can be expected to accomplish after undergoing the training in this module • Understanding the concepts of GIS.
• Importing and Exporting of Images.
• Digitization of Images. • Show a proper presentation of Image and Data.
Training Methodology Used
• Through Facilitated Labs • Access to Computers all the time • Experienced faculty members for Theory and Lab • The day is divided into four sessions including theory and practical
DACNET TRAINING LOCATION MUMBAI
DACNET TRAINING LOCATION Bikaner
DACNET TRAINING LOCATION JAIPUR
Course Material
• The course material was well appreciated by the participants – Participants felt the courseware was comprehensive – Relevant examples were used – CD’s was thought out to be a very good idea.
– Case Study and Lab Exercises were appreciated for their
OPT Courseware
• OPT courseware was designed in consultation with • Mr.Moni, • Mr.Y.D.S.Sharma, • Mrs Alka Mishra and DACNET team (NIC), • Mr V.K.Sharma, Mr.Manoj Kumar Gupta,(ER&DCI, Noida) • RCC Chandigarh.
DD&A Courseware
• DD&A courseware was designed in consultation with • Shri. M. Moni, DDG,(NIC) • Mr.Y.D.S.Sharma, • Mrs Alka Mishra and DACNET team (NIC), • Mr V.K.Sharma, Mr.Manoj Kumar Gupta,(ER&DCI, Noida) • RCC Chandigarh and RCC Kolkatta
DSS Courseware
• DSS courseware was designed in consultation with • Mr.M.Moni,DDG,(NIC) • Mr.Y.D.S.Sharma, • Mr.M.V.S.Sarma
• Mrs Alka Mishra and DACNET team (NIC), • Mr V.K.Sharma, • Mr.Manoj Kumar Gupta,(ER&DCI, Noida) • RCC Chandigarh and RCC Kolkatta.
GIS Courseware
• GIS courseware was designed in consultation with • Mr.Moni, DDG (NIC) • Mr.M.V.S.Sharma, • Dr.A.Mohan, • Mrs Alka Mishra and DACNET team (NIC) • Mr V.K.Sharma
• Mr.K.Balaji, Ms Rita Verma, Ms S.U.Ujjwala
(ER&DCI, Noida) • Mr Dilip Paul (PPC) shared his kind in depth knowledge in preparation of the material.
• ER&DCI,Noida along with DACNET Coordinator(NIC) coordinated with the printer and other agencies for the books to be printed.
• ER&DCI, Noida Coordinated the Training of Trainers programme on TNT Mips with NIC and other training agencies participantion.
1 2 3 4 5 6 7 Sno
Manpower Trained-Present Status
Locations OPT DA&D DSS GIS Projected Actual Proje cted Actual Projec ted Actu al Pro ject ed Actua l CAD/ CAM Pro ject ed Actu al Bhopal (Budni) Ghaziabad Faridabad Mumbai New Delhi Rajasthan 176 128 212 252 344 182 Trivandrum (cochin) 147 112 112 80 90 123 90 89 123 95 155 210 127 155 117 210 194 127 122 102 102 42 36 20 73 55 49 29 27 29 38 27 2 6 24 36 30 20 13 73 21 55 N/S 49 N/S 29 14 80
T E D S T A R N O T
N/S 27 N/S
250 200 150 212 123 100 50 73 0 Projected
Faridabad Status
Faridabad 123 95 27 58.01
77.23
36.98
OPT DCA DSS Attended Percentage
Ghaziabad & Noida
200 180 160 140 120 128 100 90 80 60 40 20 20 0 Projected 90 89 70.31
38 Attended 190 98.89
Percentage OPT DCA DSS
Mumbai
300 250 252 200 150 155 100 155 117 75.48
61.51
50 0 Projected Attended Percentage OPT DCA DSS
Rajasthan
200 180 182 160 140 120 127 127 122 100 80 60 40 20 29 24 0 Projected Attended 96.06
69.78
Dropout Percentage OPT DCA DSS
Budni (Bhopal)
180 176 160 140 120 100 80 60 112 112 80 71.43
OPT 80.56
DCA DSS 63.64
40 36 29 20 0 Projected Attended Percentage
New Delhi
350 344 300 250 200 198 210 194 150 100 96.06
69.78
50 0 Projected Attended Percentage OPT DCA
Trivandrum
160 140 147 120 100 102 102 80 60 69.39
41.18
40 20 42 0 Projected Attended Percentage OPT DCA
How candidates have been benefited
• A very positive reaction of the participants to the training provided • An interest was kindled towards the Computers and its working • Participants realized their learning curve was rising • Participants desire to come back for training for other modules.
How candidates have been benefited
• Percentage of attending participants increasing with successive modules • Participant's ability to implement the training modules at their respective Departments • The ability to work more efficiently as a result of the training and thereby saving Time.
How candidates have been benefited
• Department’s is progressing towards achieving a hundred computer literacy thereby : – Getting work done quicker and able to pass the information to other departments in an efficient manner – A better way to interact with other departments has been evolved.
Feedback Analysis Report
• Appreciation of faculty members • Appreciation of the Structure of the course • Duration is short
Difficulties Faced
• The only aberration during the training was the difficulty faced in obtaining nomination • The heads of the certain departments were not willing to send their employees despite the participant’s desire to attend the training
Proposed Scheme for more effectiveness
• A refresher module which covers all the topics in brief should be conducted after the end of all the modules for all the participants
Directorates from where less than 50% candidates has come
• Central Fertilizer Quality Control & Training Institute (Faridabad) • Dte of Arecanut & Spices Development (Trivendram) • NBDC (Madhya Pradesh) • PAO (Mumbai-Balard State) • PAO (Mumbai-PM Road) • DMI (Mumbai-Nasik) • DMI (Mumbai-Pune) • Dte of Plant Protection, Quarantine & Storage (Indore)