Session 1 Orientation Session 2 User Interface Session 3 Database Administration

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