Data Analyst, Program Evaluation Expertise & Technical Support Available:
Organize & Track data carefully and efficiently (make program monitoring simpler, smoother and faster!)
Create user-friendly, powerful spreadsheets with formulas to capture simple and complex needs, and pivot table summaries in MS Excel or online using Google Sheets. Includes setting up data validation, pull-down menus, pivot tables and/or conditional formatting.
Review existing data tracking systems for streamlining, user experience improvement, data cleaning & summarizing/reporting needs.
Develop efficient and powerful databases with customized, user-friendly forms & reports in MS Access. Create new queries or reports for your current database or design and create a new one for your agency. (sample manual: Training Database Manual)
Program Evaluation Plans - design & implement a quarterly reporting system in MS Excel, or online using Google Sheets, that incorporates both qualitative and quantitative data into one file per activity.
Meeting Smart Start requirements - program development or implementation support: programs change over time, let me keep up with best practices and the changes for you! Review requirements for PIDs, Outputs, Outcomes & Measures and ensure Quarterly Reports match what's in Fabrik.
Logic Models - updating Needs sections, aligning with NC State Program Identifiers' required outputs, selecting shared outcomes and related/required measures
Survey design and implementation - using Qualtrics, Google Forms or Survey Monkey reduces data entry. Contact me to request a brief, one page survey planning tool.
Community Needs & Assets Assessments - both compiling existing data & conducting targeted surveys
Program Monitoring - annual visits not necessary! Remote, desk monitoring is available. Consider adopting a risk assessment tool to prioritize what needs monitoring when - contact me for sample!
Social Media Presence: maintain an agency Facebook page, adding events & promoting mission by sharing relevant news and research, direct traffic to website and link to a twitter account to automatically post there.
Other basic IT support: Hitting a wall? Struggling with new or old technology? I can help ease your stress and provide technical assistance as needed with email, internet, Facebook, MS Office Suite products or Google Drive, including Docs, Sheets, and Forms.