You are here

Developing a Data Collection System

No matter how well you plan your activities, your evaluation questions, and your evaluation plan, it will all be for naught if you don’t have a useful way to collect the data you need to answer your evaluation questions. Some indicators are easier to measure than others. For example, as long as you can get access to academic records from the school or district, you will be able to easily measure grades, attendance in school, and test scores. Other indicators are more cumbersome and labor intensive to measure. For example, determining whether a young person has increased motivation, is more engaged in school, or is better able to solve problems requires a youth survey of some kind, which can be difficult to implement.

Keep the relative complexity of data collection in mind as you finalize your indicators, select data sources, and develop your data collection plan. In most afterschool and expanded learning programs, staff members will have to participate in data collection. As a result, selecting strategies that do not overburden your staff is a good idea. If you know in advance that you need to collect hard-to-find data, it is good to make those arrangements early. Each evaluation question and associated indicator for which you intend to track data should be matched to a good data source.

Many strategies, tips, and tricks can be used to ensure that data collection activities are successful. When participants enroll in your program, for example, make sure you get signed consent from family members to collect information about their children, particularly to conduct surveys and access school records. Having permission from the outset helps simplify data collection requests you may need to make to the school or other personnel in the future. Emphasize that the information will be aggregated and used only for program improvement, not to identify individual participants. Furthermore, collect only the data you will need. For example, if you only want to know age and grade, do not ask other demographic questions. Likewise, ask only for data you do not already have. For example, if your program is based at a school, you may be able to get all the demographic information you need from the main office. Ask your school about its policies on sharing certain kinds of data.

It also is important to know the languages spoken in the homes of your participants and consider translating permission and consent forms, family surveys, and other evaluation materials into the languages most commonly spoken by participants’ families. Make sure that you are aware of cultural norms for the population you are serving and be respectful of roles or positions, particularly with youth and family surveys and focus groups. Try not to use youth as interpreters for their families because this puts them in a potentially uncomfortable role. A bilingual staff member or translator can be more effective.

Assign each participant an identification number or use a school-assigned identification number (if one exists) and keep data filed by that number. This practice reduces the chance of mixing up two youth with similar names or birthdays, allows you to make surveys and other documents anonymous, and is useful when it comes to data analysis. Be sure that you have all the data protections in place. See the management section for guidance on policies that support the data rights of participants. Finally, be sure to collect all your information at one time. For example, the easiest time to collect demographic data is when young people enroll.

You can collect data in many different ways. Whichever way you choose, it is important that you collect data in a systematic and reliable manner—that is, collect data the same way each time; use existing, tested surveys and tools when possible, rather than creating your own; and create appropriate conditions for data collection. Some of the more common forms of data collection include attendance or participation tracking; surveys (see Tool 87: Tips for Developing and Administering Surveys); focus groups (see Tool 88: Tips for Running Good Focus Groups); program observations (see Tool 89: Tips for Conducting Program Observations); interviews (see Tool 90: Tips for Conducting Good Interviews); collecting demographic information about participants in the program; collecting information reports from schools, the district, the police department, or other entities that collect relevant information (e.g., grades, test scores, comparisons of crime statistics, or detention reports); and other documents (newsletters, meeting minutes, and other sources of information).

Participation Tracking
 

One of the most important tools for data collection will be a strong system for tracking participation and attendance in your programs. Ideally, this system will be some kind of Web-based electronic management information system. Numerous companies have existing, well-developed tools that include the ability to purchase a license. In many cases, this option can be cheaper (as low as $500/year) than customizing or developing your own system. A great reference for selecting a system is Building Management Information Systems to Coordinate Citywide Afterschool Programs: A Toolkit for Cities (National League of Cities, 2012).

Having a good system doesn't automatically ensure good data, however. Participation tracking systems are only as good as the data that are entered. When keeping track of youth attendance, consider making one or two staff members responsible for tracking attendance and entering the data into your database. The fewer people entering data into your system, the cleaner the data will be. It also is important to be timely with data entry. If possible, enter it on a daily basis. It is more likely to be accurate if it is entered regularly rather than all at once during a long data-entry session. Most Web-based tracking systems have reports you can generate automatically with attendance sheets. Use those to track daily attendance. That way even if you can't enter the data immediately, you will have a paper trail that your assigned staff member can use at the end of the week to enter the data into your system. You also should train your staff in how to use the data system, including important tips and tricks to ensure good data. Likewise, keep accurate attendance lists. Add and drop youth from your activities as needed to maintain good attendance sheets so that you aren't marking participants as absent when they actually aren't enrolled in the program. You also can select a set time in your program to check young people in and take attendance. If you offer a snack at the beginning of your program, this can be a good time. Most youth don't want to miss snack time, so you can have them sign an attendance sheet as they receive their snack. Alternatively, ask activity leaders to gather everyone together and take attendance before beginning any activities.

Data on the Quality of Your Program
 

It is a good idea to monitor the quality of your activities and program offerings on a regular basis. You can do this through observation. Refer to Tool 85: Program Observation Tools for a list of sample tools, most of which are free. Using an observation tool will allow you to collect data on your program quality that can be recorded and analyzed. At a minimum, quality scores from observation tools can be used to inform the professional development you offer. As your program gets more sophisticated or your data analysis skills develop, you can begin to compare participation data with quality data to look for correlations, use the quality data to create a system for one-on-one coaching for program providers and instructors, and incorporate quality data into your evaluation.

School Data
 

If you have a partnership with your school or district, student-level data may be easier to come by than if you are an independent, community-based organization with no district affiliation. Either way, student-level data can be powerful for examining how youth in your program are doing and may open the door to exploring the impact of your program down the road. Schools keep records of grades, attendance, test scores, demographics, and behavior, as well as many other types of information. If you can access these data, through either a data-sharing agreement or a formal evaluation request, you may be able to use them for evaluation purposes. For example, you or your evaluator could link school data to participation data to look at the effect participation seems to have on youth. At a more basic level, you could use the data in aggregate form to understand your population. For example, you may learn that youth in your program are struggling in mathematics, or your community has a larger English language learner population than you realized. These data can help inform your program design before an evaluation even takes place.

Survey Data
 

Survey data can be collected from youth and families and even from partners and staff members. Distributing simple surveys two or three times a year can help you monitor how happy your various stakeholders are with your program, learn more about youth attitudes and beliefs, and gather ratings of participant or staff skills and behaviors. You can compare results from the beginning of the year with results from the middle and end of the year to see whether things are getting better or worse. Review the results with staff members and incorporate the data into your ongoing staff meetings to discuss adjustments based on the results.