ER

1
ER DCI NOIDA
ISO 9001 Organization
2
ABOUT ERDCI, NOIDA A Scientific Society
under Department of Information Technology
in the fore front of Research
Training Merged with the newly formed
ERDCI Society in 1994 Governed by the
Governing Council, DIT, M/o CIT
3
AREA OF COMPETENCE
ER DCI NOIDA
RESEARCH
HI-TECH EDUCATION
Broad Band Technologies
Career Development
NLP
Business Oriented
ER DCI NOIDA
Security Systems
Skill Upgradation
e-Governance
Formal
Software Applications
Non-Formal
Internet Based Technology
4
TAILOR NEW TECHNOLOGIES TO SUIT THE
NATIONS NEEDS
5

• OBJECTIVES OF ERDCI, 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, RD 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.

6
SERVICES OFFERED Training
Research Software Development
System Integration Maintenance Internet
Service Provider FASTNETE-
Learning
7
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

8
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

9
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

10
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
  ERDCI,Noida at seven different locations.

11
WHY - DACNET

• 100 Computer literacy.
• Directorates under single umbrella of Network.
• Faster Communication through Internet.
• Easier Data sharing and more transparency.

12
Level of Participants for the Training Modules
S.No Course Title Level of participants
1 Office Productivity Tools (OPT) A,B and C
2 Database Creation and Analysis (DCA) A,B and C
3 Decision Support system (DSS) A, B and Interested C
4 Geographical Information System (GIS) A, B and Interested C
5 CAD/CAM A,B,C
6 SPSS A,B
This module is not covered by ERDCI, Noida
13
Training Programmes of DACNET training

• Office Productivity Tools
• Database Analysis and Design
• Decision Support System
• Geographical information System
• CAD/CAM (Only at Bhopal)

14
WHYOffice 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.

15
Contents of Office Productivity Tools

• The Applications which are covered under OPT are
• MS-Word
• MS-Excel
• MS-PowerPoint
• MS-Outlook and Internet

16
(No Transcript)
17
Office Productivity ToolsMS-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

18
Office Productivity ToolsMS-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

19
Office Productivity ToolsMS-POWERPOINT

• Working with slides
• Customizing
• Color Scheme
• Design template
• Animations
• Preset
• Customizing
• Timing
• Lab Exercise
• Comprehensive exercise based on all the topics

20
Office Productivity ToolsMS-OUTLOOKand 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.

21
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.

22
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.

23
WHYDatabase 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.

24
(No Transcript)
25
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.

26
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.

27
WHY DECISION SUPPORT SYTEM

• After DDA 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

28
(No Transcript)
29
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.

30
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

31
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

32
 
 
33
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
•  

34
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.

35
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

36
DACNET TRAINING LOCATION MUMBAI
37
DACNET TRAINING LOCATION Bikaner
38
DACNET TRAINING LOCATIONJAIPUR
39
Course Material

• The course material was well appreciated by the
  participants
• Participants felt the courseware was
  comprehensive
• Relevant examples were used
• CDs was thought out to be a very good idea.
• Case Study and Lab Exercises were appreciated for
  their

40
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,(ERDCI,
  Noida)
• RCC Chandigarh.

41
DDA Courseware

• DDA 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,(ERDCI,
  Noida)
• RCC Chandigarh and RCC Kolkatta

42
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,(ERDCI, Noida)
• RCC Chandigarh and RCC Kolkatta.

43
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
  (ERDCI, Noida)
• Mr Dilip Paul (PPC) shared his kind in depth
  knowledge in preparation of the material.

44

• ERDCI,Noida along with DACNET Coordinator(NIC)
  coordinated with the printer and other agencies
  for the books to be printed.
• ERDCI, Noida Coordinated the Training of
  Trainers programme on TNT Mips with NIC and other
  training agencies participantion.

45
Manpower Trained-Present Status
Sno Locations OPT OPT DAD DAD DSS DSS GIS GIS CAD/ CAM CAD/ CAM
Sno Locations Projected Actual Projected Actual Projected Actual Projected Actual Projected Actual
1 Bhopal (Budni) 176 112 112 80 36 29 36 30 80 N O T S T A R T E D
2 Ghaziabad 128 90 90 89 20 38 20 13 N O T S T A R T E D
3 Faridabad 212 123 123 95 73 27 73 21 N O T S T A R T E D
4 Mumbai 252 155 155 117 55 2 55 N/S N O T S T A R T E D
5 New Delhi 344 210 210 194 49 6 49 N/S N O T S T A R T E D
6 Rajasthan 182 127 127 122 29 24 29 14 N O T S T A R T E D
7 Trivandrum (cochin) 147 102 102 42 27 N/S 27 N/S N O T S T A R T E D
46
Faridabad Status
47
Ghaziabad Noida
Percentage
Attended
48
Mumbai
Attended
Percentage
49
Rajasthan
Attended
Dropout Percentage
50
Budni (Bhopal)
Attended
Percentage
51
New Delhi
Attended
Percentage
52
Trivandrum
Attended
Percentage
53
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.

54
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.

55
How candidates have been benefited

• Departments 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.

56
Feedback Analysis Report

• Appreciation of faculty members
• Appreciation of the Structure of the course
• Duration is short

57
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
  participants desire to attend the training

58
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

59
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)