Counting Apples (Data Collection & Reporting)
0 likes316 views
This document discusses collecting and reporting apple count data. It explains that standardized questions and objective data collection allows comparison between groups over time. Decision were made regarding who collects data, what data is collected, where it is stored, when it is loaded, and how it is accessed and shared. The system demonstrated allows users associated with sites to add participants, courses, and attendance sessions. Reports mirroring the original spreadsheet can be generated. Potential issues concern verifying accurate participant counts by site. Updates could include custom data fields, additional reports, and administrative functions.
Counting Apples (Data Collection & Reporting)
- 1. COUNTING APPLES (DATA COLLECTION & REPORTING) S. Todd McKee, MEd Instructional Developer Arkansas Geriatric Education Center (AGEC) Geriatric Research Education and Clinical Center (GRECC) Central Arkansas Veterans Healthcare System Little Rock, AR
- 4. OBJECTIVES ? Apples are apples, aren¡¯t they? ? Why do we have the spreadsheet? ? Decisions we made ? Our system (Demo) ? Questions
- 6. IS THIS THE SAME?
- 7. OR THIS ONE?
- 9. HOW DO WE SORT IT OUT?
- 10. WHAT IS THIS?
- 11. DATA ? Standardized questions ? Objective ? Allows comparison among groups ? Numbers, numbers, numbers ...
- 12. REAL REASON
- 13. REAL REASON 150 113 75 38 2007 0 2008 2009 2010
- 14. REAL REASON Green Red 150 113 75 38 2007 0 2008 2009 2010
- 15. DECISIONS WE MADE ? Who? ? What? ? Where? ? When? ? How?
- 16. DECISIONS WE MADE ? Who? ? Collect data ? Load data ? Access
- 17. DECISIONS WE MADE ? What? ? Data variables ? Report to others
- 18. DECISIONS WE MADE ? Where? ? Data housed ? Access
- 19. DECISIONS WE MADE ? When? ? Time for loading ? How long will it take?
- 20. DECISIONS WE MADE ? How? ? Access ? Store ? Share
- 21. HOW WE HANDLE IT... ? User ? Associated with a Site ? Data entry ? Add Participants ? Add Course ? Add Sessions ? Reports
- 23. New User form
- 24. Simple Administrative Menu Proper order is listed on right
- 25. List of all participants for a site. Click on ¡°Add New¡± to enter new participant
- 26. Participant form with all fields
- 27. List of all participants for a site. Participants may be Updated at any time.
- 28. All courses are listed to edit or ¡°Add New¡±
- 30. Select the appropriate course to add attendance.
- 31. All participants are listed Simply check which are present
- 32. Administrative Menu Additional Tasks include: ?! User Administration ?! Editing ! Sites/Organizations
- 33. Final Report that mirrors the Excel report.
- 34. ISSUES/UPDATES ? Issues ? Number of participants per site ? Verifying data entry ? Updates ? Custom data collection ?elds ? Additional Reports ? Additional administrative functions
- 35. QUESTIONS? S. Todd McKee todd@uams.edu