Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Session 1 Orientation Session 2 User Interface Session 3 Database Administration PowerPoint Presentation
Download Presentation
Session 1 Orientation Session 2 User Interface Session 3 Database Administration

Session 1 Orientation Session 2 User Interface Session 3 Database Administration

243 Views Download Presentation
Download Presentation

Session 1 Orientation Session 2 User Interface Session 3 Database Administration

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. DevInfo Database Administration Session 1Orientation Session 2User Interface Session 3Database Administration Session 4Presentations Session 5Work Planning Session 6Certification

  2. Session 3 ü Session 1Orientation Session 2User Interface Session 3Database Administration 3.1 Overview 3.2 Template 3.3 Data Entry 3.4 Tools 3.5 Reports 3.6 Metadata 3.7 Mapping 3.8 Language 3.9 Customize 3.10 Users 3.11 Gallery 3.12 Data Exchange Session 4Presentations Session 5Work Planning Session 6Certification ü ü

  3. Session 3 ü Session 1Orientation Session 2User Interface Session 3Database Administration 3.1 Overview 3.2 Template 3.3 Data Entry 3.4 Tools 3.5 Reports 3.6 Metadata 3.7 Mapping 3.8 Language 3.9 Customize 3.10 Users 3.11 Gallery 3.12 Data Exchange Session 4Presentations Session 5Work Planning Session 6Certification ü ü

  4. Session 3 Database Administration Topic 3.1 Overview Objectives • By the end of this session, we will learn: • Database Administration modules • Basic functions of each module

  5. : Global System Administrator : UI Customizer : Database Administrator : Translator : Data Entry Operator : User Session 3.1 Overview Topic 3.1.7 Data Flow Enter global indicators and MDGs Add multiple main UN language support Global database template Distribute template to countries Add multiple local language support Add local indicators, areas, goals, etc. Country-specific database template Distribute template for data entry Change product skin to country-specific requirements Enter most recent data Country database with most recent data Upload selected MDG data to global level Distribution database to users Table, Graph, Map Query database to create presentation

  6. Session 3.1 Overview Review ? How many modules are available in DevInfo? Name the module that is used to search for data. What module is used to create the framework for building a database? Maps are linked to data in which module? How many languages are supported by DevInfo? Is it possible to create a CD for replication? Which module used to update a CD with a new database? Who can change global indicators in a DevInfo Template?

  7. Session 3 ü Session 1Orientation Session 2User Interface Session 3Database Administration 3.1 Overview 3.2 Template 3.3 Data Entry 3.4 Tools 3.5 Reports 3.6 Metadata 3.7 Mapping 3.8 Language 3.9 Customize 3.10 Users 3.11 Gallery 3.12 Data Exchange Session 4Presentations Session 5Work Planning Session 6Certification ü ü

  8. Session 3.2 Template Home Page

  9. Session 3.2.1 Template Step 1 Indicators

  10. Session 3.2.2 Template Step 2 Units

  11. Session 3.2.3 Template Step 3 - Subgroup - Sex

  12. Session 3.2.4 Template Step 4 - Subgroup - Location

  13. Session 3.2.5 Template Step 5 - Subgroup - Age Group

  14. Session 3.2.6 Template Step 6 - Subgroup - Others

  15. Session 3.2.7 Template Step 7 - Subgroups

  16. Session 3.2.8 Template Step 8 - I-U-S

  17. Session 3.2.9 Template Step 9 - I-U-S Min Max

  18. Session 3.2.10 Template Step 10 - Indicator Classifications

  19. Session 3.2.10 Template Step 10 - Indicator Classifications

  20. Session 3.2.11 Template Step 11 - Area Names

  21. Session 3.2.12 Template Step 12 - Area Maps

  22. Session 3.2.13 Template Update Registry

  23. Session 3 Database Administration Template Summary • Template is used to create a DevInfo database • Template contains indicator names and definitions • Global indicators like the MDGs can only be changed by the Global System Administrator • Each indicator must be defined under a sector and class • Each indicator must be defined with a unit and subpopulation in an I-U-S combination • Template is used to link indicators to goals, themes and other methods of organizing indicators • Template contains area name and area IDs linked to maps

  24. Session 3 Database Administration Review ? What is the file extension of a Template? Is it possible to add an indicator without a sector and class? Explain how to add a new indicator in a Template Can the same indicator be used for many I-U-S combinations? Is it mandatory to link each indicator to a goal? Can an indicator be linked to more than one goal? Can an indicator be linked to both a goal and a theme? Explain how to link map files in a Template.

  25. Session 3 ü Session 1Orientation Session 2User Interface Session 3Database Administration 3.1 Overview 3.2 Template 3.3 Data Entry 3.4 Tools 3.5 Reports 3.6 Metadata 3.7 Mapping 3.8 Language 3.9 Customize 3.10 Users 3.11 Gallery 3.12 Data Exchange Session 4Presentations Session 5Work Planning Session 6Certification ü ü

  26. Session 3.3 Data Entry Data Entry Module

  27. Session 3.3.1 Data Entry Step 1 - Select Template

  28. Session 3.3.2 Data Entry Step 2 - Select Indicator

  29. Session 3.3.3 Data Entry Step 3 - Select Time

  30. Session 3.3.4 Data Entry Step 4 - Select Area

  31. Session 3.3.5 Data Entry Step 5 - Select Source

  32. Session 3.3.6 Data Entry Step 6 - Data Entry

  33. Session 3.3.7 Data Entry Data Entry Online

  34. Session 3 ü Session 1Orientation Session 2User Interface Session 3Database Administration 3.1 Overview 3.2 Template 3.3 Data Entry 3.4 Tools 3.5 Reports 3.6 Metadata 3.7 Mapping 3.8 Language 3.9 Customize 3.10 Users 3.11 Gallery 3.12 Data Exchange Session 4Presentations Session 5Work Planning Session 6Certification ü ü

  35. Session 3.4. Tools Tools Overview

  36. Session 3.4. Tools Import

  37. Session 3.4.1 Tools Step 1 – Select File

  38. Session 3.4.2 Tools Step 2 – Select Database

  39. Session 3.4.3 Tools Step 3 – Indicator Matching

  40. Session 3.4.4 Tools Step 4 – Unit Matching

  41. Session 3.4.5 Tools Step 5 – Subgroup Matching

  42. Session 3.4.6 Tools Step 6 – I-U-S Matching

  43. Session 3.4.7 Tools Step 7 – Area Matching

  44. Session 3.4.8 Tools Step 8 – Process

  45. Session 3.4 Tools Split

  46. Session 3.4.9 Tools Step 1 – Selection

  47. Session 3.4.10 Tools Step 2 – Data

  48. Session 3.4.11 Tools Step 3 - Options

  49. Session 3.4.12 Tools Step 4 - Process

  50. Session 3.4.13 Tools Database Administration Log