Forms for Data Reporting

CZLpIWiWcAExUxX (1)I have written and posted a lot of information regarding the use of Google Forms for collecting student data snapshots. As my work with forms has increased, I have thought about data reporting at the local school level. When working with academic data, the norm tends to center around the importing and exporting of .csv files – sending back and forth Excel data. Using Google Forms provides a seamless connection between the form and the response spreadsheet it is linked to. The following simple steps will help you setup a way to report and share important assessment level data with colleagues and administrators. This can work for those teachers that are part of Apps for Education and accounts that are just normal Google based. The idea here is to keep from sending documents all over the place, or having teachers import and export data exhaustively. Even the best LMS software often has extra steps that are needed to share out comprehensive or cumulative student achievement data.

Screenshot 2016-01-20 at 6.59.30 PMThe important thing to think about when creating your assessment form will be the fields that you use to collect data from. If you are familiar with survey design, this will be an easy transition. You basically want to think of fields that will give you clear searchable data later. You do not want to try to fit too many bits of information to any one field. The idea is to separate each bit of data that you would like to collect into each separate field. Once submitted, this data will be organized into a spreadsheet document – so keep that in mind for the amount of text at any given time you will be inputting. I like to keep it realistically simple. Fields for: test name, test subject, type (exit slip, midterm), date of assessment, grade average, class average etc. I use forms to report assessment data to my school principal, so I design the fields in a way that will offer a complete snapshot of each class section and overall student achievement.

Screenshot 2016-01-20 at 7.10.19 PMI will also add some paragraph text fields to list standards that students excelled on, or standards that they may need more targeted review for. While other SIS or LMS systems can track standards, they often truncate them into the abbreviation they are listed as – this type of field can keep a more logical listing of skills and standards for the colleague or administrator to examine.

Once the basic form layout is done, I test it by entering data from one of my most recent assessments to see how it looks in the response document. In the design view of creating a form, the responses are indicated in the top menu. This view will allow you to see the spreadsheet that will keep all the responses as they are entered into the form. The response document spreadsheet is what I ultimately share with my admin team. This document will be constantly updated with assessment data of various types allowing for a sort-able and searchable view of student achievement.

Google Form Feedback

Screenshot 2015-12-16 at 8.41.21 PMForms are one of those things that are extremely useful for collecting quick information. It seems like everyone at one point or another was shown the magical ways of collecting and sorting information via form input. Unfortunately, most have moved on from traditional form design in favor of single serving cloud based programs – designed to make these tasks more seamless. In conducting research forms (surveys) are a necessity. I need a way to collect multiple points of substantial data. This comes in the form of programs like Google Forms and a more robust program like Qualtrics. While using Gradecam to bubble in rubric points for a science presentation, I decided to create a form that could keep track of all my student rubric scores across three classes. I wanted a way to add up and display all the final student scores. Google Forms automatically creates a spreadsheet for each form you launch. This spreadsheet can be edited and formulas applied without worrying about the integrity of your data. Screenshot 2015-12-16 at 8.57.50 PMAfter that, I applied this same thinking to tracking student understanding for my 7th grade science labs. At the end of each lab I would post a feedback form for my students on Google Classroom. While I consider this informal data collection, the quick insights are a good barometer for what students understood. Google Forms also gives you the option for displaying a “quick summary” which contains basic descriptive statistics – which is very useful for seeing class data. In the end, I think the process of creating the forms and viewing the data promotes best practices among teachers. The validity of the data received from students informally really only provides a surface level snapshot, but it instills a sense of self-reflection among students and teachers. There have been a few instances where I knew a lab direction set was challenging and the data received supported that notion. Having seen data from three full classes, it definitely made me think about certain lab presentations for the future.

Open “Book” Google Classroom Quiz

Screenshot 2015-12-01 at 9.25.33 PM

Google classroom is great for classroom management and engaging students. Some of the power comes from being able to attach different types of documents or links to each assignment type. A successful strategy that I have employed in the past has students using materials to both study and complete a take home quiz.

Click below to view the tutorial!
(more…)

Best of the Old

Screen Shot 2015-11-02 at 10.31.34 AMI have been looking for ways to improve study skills and content enrichment with my 7th grade science class. We have used a lot of technology, but for a recent Geology test, I thought it might be interesting to conduct an activity that was more grounded in traditional study skills. I had used Quizlet years back when studying for graduate level tests and thought that It may be useful for my students. Since then, with implementation of study sets and various practice activities, Quizlet has definitely expanded its offerings. I split my class review time between Quizlet and PollEveryWhere allowing students to have an online study session. I provided URLs for both so that students could access at home easily as well. Screen Shot 2015-11-02 at 10.31.17 AMTraditionally, study time prior to our unit tests might resemble paper study guides, but students really enjoyed this one. They were enforcing traditional study skills, but in a way that was more business as usual in their ever digital lifestyles. It is extremely easy to create a class, study set, and various activities that students can use to study from.