Creating a Google Form
Teachers can use Google Forms in a variety of ways. I am a music teacher; I used my Form as a 4-point rubric-based assessment that I completed as each student performed a singing task. Google Forms can also be used as a survey tool, exit ticket, quiz, and much more.
Below, I have created a Google Form to track data for a 1st grade singing assessment. This tracker is for the pre-assessment data that I will be using to track my 2017 student learning objectives (SLOs).
Google Forms can be accessed through forms.google.com using your Google account. If your school or work does not offer a Google account, you can create a Google account for free. Saved forms can also be accessed at drive.google.com.
Once on the Google Forms homepage, you will have the option of choosing to use a sample assessment created by Google, modifying that sample assessment, or you can create your own from the bottom up. I chose to create assessment from a blank form. I then copied the assessment for each class to track the data separately.
In the video below, I demonstrate how I made my assessment and what I chose to add. You may find you have different needs and can create your assessment accordingly.
After the base form was created, I entered student's' names and assessment scores as they sang the song. Once all the students had sung, I analyzed the responses page.
I captured 23 responses. I can view a summary of the responses or individual reports. The green icon will generate a separate spreadsheet saved in Google Sheets.
Google Forms provided me with an overview of how my students performed. For example, in the data gathered below, I see that 14 students (almost 61%), achieved a score of beginning, meaning they only used their talking voice on the assessment. 7 students used a combination of talking and singing voices, and only 2 were able to sing the song using their singing voice most of the time.
The data can be re-arranged and presented using a spreadsheet generated in Google Sheets. I submitted my assessment data using the spreadsheet generated in Google Forms to my district's teacher evaluation platform.
Now that my data has been collected for the pre-assessment, I know that the majority of my students struggled to sing a three note song when seeing it for the first time. Because 61% used their talking voice and not singing voice, I first reviewed the difference between talking voice and singing voice. I then backtracked to have students practice singing two note songs before introducing three note songs. Once students have more practice singing these two and three note songs, they will (hopefully!) improve in their singing abilities during mid-year and end of the year assessments.