This script will allow you to easily run student elections. It is broken up into 2 parts: Setup & Cleaning.
SETUP: The setup part consists of assigning each student a unique Voting ID (VID). As a tip, once the VIDs are assigned, you can easily export them along with the students name & homeroom, and do a mail-merge in MS Word that you can print out and distribute to each students. Alternatively, if your students have email accounts, you could modify the script so that it emails all of the students their VID as soon as it is created.
CLEANING: Once the election is done, you can clean the results using the 4 functions below. Additionally, the first time you run one of the cleaning functions, it will make a backup of the original results. All of the functions will make a note on this sheet as to why a ballot was removed.
- Check the VID. This will check all ballots to make sure the the VID that was entered was assigned to a student.
- Remove Duplicates. This will remove any ballot that has a VID that was already entered.
- Remove Extra Votes. This will allow you to set a maximum number of votes for a checkbox-type question. This is ideal if you would like to have students choose 2 people out a list of 10. Currently you need to run this script once for every question that has a maximum vote limit. I hope to fix this in the future.
- Remove Votes Submitted Late. This will remove any ballots that were cast after the voting deadline.
You can find the Spreadsheet Template that includes this script here.
If you would like to view the script alone, you can download it here.
Update (March 2013): This is an older version of the script. I am in the process of rewriting this using the HTMLService so that the the script is more streamlined. I will update this and publish the script once I am done.