Session 2'1Data Entry

1
Session 2.1
Session 2.1 Data Entry
2
Objectives

• By the end of this session, we will learn
• How to create and update a database
• Tools for database management

3
Template

• Indicator
• Unit
• Subpop
• I-U-S combinations
• I-U-S links to Sector, Goal, CF, Theme,
  Institution, Convention
• Area Name, Area ID
• Area ID linked to map

4
Data Entry

• Time
• Source
• Data Value
• Footnote (optional)

5

• Ex. Create/Update Data entry sample data

6
Data Entry Tools
7
Split Database
8
Split Database
MDG Database
Health Database
Education Database
9

• EXERCISES split
• from the MDG 2004.05.31 12h00.mdb please create
  three new data base of per 1000 live births
  Number and per 100000 live births. Keep data
  down to the lowest level in each country.

10
Merge Databases
11
Session 3.3 Data Entry
Topic 3.3.12 Merge Databases
HDR Database
MDG Indicators From HDR and SOWC
MDG Template
SOWC Database
12

• EXERCISES merge
• Please merge these two database together
• DevInfo 4.0 MDG 2004.05.31 12h00.mdb
• MDG Info 2005.mdb

13
Extract Database
14
Extract Database
Goals MDGs?
HDR Database
Sector Health?
MDG Health Indicators from HDR for Three Countries
Areas selected countries?
15

• EXERCISE extract
• From EAP2004 database, please create a new
  database which include only IMR and MMR data in
  the year 2002 for Thailand using extract method

16
Export Database
17
Export Database
Spread- sheets
Database
18
Import Spreadsheets
19
Import Spreadsheets
20
Import Spreadsheets
MDG Template
Spread- sheets
Database
Match Subpops
Match Areas
Match Indicators
Match Units
21
Import Database
22
Import Database
SOWP Database
MDG Template
SOWP MDG Database
Match Subpops
Match Areas
Match Indicators
Match Units
23
Compress Database
24
Recommended Sources
25
Information Sheets
26
(No Transcript)
27
(No Transcript)
28
Summary

• A template must be created using the Template
  module before entering data into a
  DevInfo database
• The Data Entry module is used to enter three
  elements of the database data value,
  source and time period
• The Data Entry module can be used to import
  data from spreadsheets
• The Data Entry module provides tools to merge
  and split databases
• The Data Entry module can generate a summary
  report about the contents of a
  database