Data Tables versus Direct Entry
Indicator results can be entered directly, or they can be pulled from a data table.
For a quick breakdown on when to use Data Tables versus Direct Entry, take a look at the Indicator Guidebook.
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
If you currently store your data in an Excel spreadsheet, you can upload this information to DevResults directly.
First go to the Data Tables page and select (+) New data table.
Next select Upload an example.
You can now choose a file from your computer or drag and drop a file from your computer to the page.
Remember to enter a name for your new data table and save.
You will then be prompted to verify what type of data is in each of your columns. Once this has been verified, you can select whether you want to import the data in your spreadsheet, or if you want to create a data table without importing existing data. Then click OK to save.
Your data table has now been created.
Creating a Data Table by Designing it Online
To create a data table online, navigate to the Data Tables page and click on (+) New data table.
You will be taken to your new data table's Design tab, where the system will automatically raise 2 alerts. DevResults requires all data entered to include a date and a location. Your data tables should always include columns that capture this information.
If your data table does not contain required columns, you will not be able to link indicators to it.
You can add a new column by clicking the (+) Add new column button.
You can then name your column and select the data type associated with it from a drop-down menu.
Once you click the Submit button, your new column will be added to the data table. The Add New Column pop-up will remain so you can continue to create columns.
Once you have added all relevant columns, you can either click the Done button or switch to the blue Data tab to begin entering data.
You can now enter data into this data table by:
You can also set up indicators that pull from data tables by:
- Data Table Variations: Average
- Data Table Variations: Count All
- Data Table Variations: Count Unique Sets
- Data Table Variations: Sum
Didn't answer your question? Please email us at email@example.com.