Data Tables versus Direct Entry
Indicator results can be entered directly, or they can be pulled from a data table.
For example, if you have indicator like # people trained disaggregated by Sex: Male/Female, the data entry would look like this:
Direct entry: Data table:
What Goes In a Data Table
- Date: Your data table must have a column for date.
- Place: Your data table must have a column for a geographic place, such as district, region, or specific locations. National-level data should have a column that specifies the place for each row as the whole country.
- Activity: All data should be associated with the activity that did that work. The few exceptions include national-level indices, such as literacy rate, which don't represent work attributable to one of your activities.
- A column for what you're counting: Are you counting trainees? You'll need a column to list each trainee. Patients? You'll need a column for each patient.
- A column for each disaggregation of any indicators that pull from this table: Hint -- if you're disaggregating by sex, the column heading would be "Sex", and the rows in that column would contain "Male" or "Female". You would not have separate columns for male and female.
Facts about Data Tables
- Data Tables in DevResults allow you to directly upload spreadsheets of individual-level data. Indicators can then be set to pull results from these tables.
- Partners can access and edit Data Tables if you so choose, but only the rows of data that are associated with their activities. Any information added by a partner will be automatically labeled with their activity. Partners cannot see rows of data entered by others' activities.
- Data Tables enforce good data practices. All data in DevResults must be associated with a time and a place, so you must include a column for the date of the result and the area it represents, such as a single facility, a district, or the whole country. If results were generated by an activity, you must include a column to label that activity.
- Data Tables can inform multiple indicators.
- Data Tables can have as many columns as you want, including text fields that allow you to store additional qualitative information for each row.
- You can add/edit information in Data tables by:
- Uploading an Excel file with new rows of data
- Uploading an Excel file and replacing all rows of data
- Editing the table and adding rows directly online
Creating a Data Table by Uploading a Spreadsheet
Creating a Data Table by Designing it Online
Not what you're looking for? These pages might be helpful:
For setting up indicators that pull from data tables:
- Data Table Variations: Average
- Data Table Variations: Count All
- Data Table Variations: Count Unique
- Data Table Variations: Sum
For entering data into a data table: