We start the class right away with me leading the students through an effective strategy to compile and analyze results. I show the students how to make a spreadsheet that can be used to tally the results of the surveys, so it will be easy to read and understand. In setting this stage for them, I am better able to ensure successful outcomes. My process for this and thinking behind it are pretty much like I share in the video, Using Excel To Average Data.
Students use the next 30 minutes of the class period to compile and enter the survey results into the spreadsheet they have created. They are expected to have the results available by the end of the 30 minute time frame provided. I make sure to move between the groups that need help first, and then check in on the other groups after that. It is important to check in with each group, even the ones who feel confident in their ability, to ensure they are correct.
Based on the ability to use our AP Time period to administer some of the surveys, most of the groups have met their minimum number by this point. For those groups who have not, I ask that they still participate in this task because it is a useful process, and not only for this assignment. I also do this in an effort to have them see that not being finished puts them at a disadvantage, while still an overcomable one. Even without all surveys completed, if they have a significant percentage completed (over 50% I would consider for this at this time), they will still get some useful information in order to help the members of the group doing other tasks to continue moving forward with their own pieces with some more guidance and a more accurate perspective.
I do not want the students to give up, and I do not want them to remain behind on the timeline. I want them to recognize the issues they face and work together to overcome them and move forward.
To conclude the class, I ask each group to write down a list of the choices they made in the preliminary plan that will be acceptable and effective as they are, and a list of the necessary changes they need to make based on the survey outcomes. Students will then be able to work on the actual advertisements as appropriate. Students are expected to have a solid start on each of the three products when they come to class the following day. Since they were able to make a preliminary plan, they need only make edits to the work they started already. This makes the process more manageable for them to complete.
Having the students write these items down is essential because it takes it to another level of commitment than simply recognizing a need or a goal. Putting it in writing changes the game a little bit and it makes it feel more formal and official for the students.