Evaluation 2018: Speaking Truth to Power

View Printable Version

Automating Data Validation and Collection Using Excel and RedCap

Session Number: 1176
Track: Internal Evaluation
Session Type: Demonstration
Session Facilitator: Matthew James Hanauer [Evaluation Associate - Centerstone Research Institute]
Time: Nov 02, 2018 (03:30 PM - 04:15 PM)
Room: CC - 23

Audience Level: Intermediate, Advanced

Session Abstract (150 words): 

Research demonstrates higher error rates in the data when limited data validation techniques are used.  Unfortunately, internal evaluators are often held to strict deadlines and have limited resources relative to external evaluators and academic researchers.  Given the constraints of internal evaluation and importance of data integrity,  in our presentation, we will be covering (1) data validation in Microsoft Excel and (2) data collection, validation, and set-up in the online survey program RedCap.  We will provide an example dataset to the participants and walk them through both points giving them hands-on experience.  With these new skills, internal evaluators will have a more consistent data entry protocol leading to decreases in the amount of time internal evaluators spend on data collection and validation by automating these processes.  We anticipate that after this presentation, internal evaluators will immediately be able to use these skills to streamline the data collection and validation process. 



For questions or concerns about your event registration, please contact registration@eval.org or 202-367-1173.

For questions about your account, membership status, or help logging in, please contact info@eval.org.



Cancellation Policy: Refunds less a $50 fee will be granted for requests received in writing prior to 11:59 PM EDT October 8, 2018. Email cancellation requests to registration@eval.org. All refunds are processed after the meeting. After October 8, 2018 all sales are final. For Evaluation 2018, international attendees and presenters who encounter complications due to the international travel environment will have up to 30 days after the event to request a refund and submit appropriate documentation. No administrative fee will apply for the international requests.