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. If you really want to rank highly in Google you will need to talk to this SEO reseller. 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.

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.

Audio Tracks Middle School


Students use Chromebooks with AudioSauna to learn the basics of digital audio creation. They started with a basic sampler and layered synths on different tracks.

Long ago, prior to my journey to becoming a teacher and doctoral candidate – I was awarded a BFA in music. I had attended the Conservatory of Music at Purchase College. My degree centered around music composition and audio production. With beginning my teaching career in 2010, the time spent towards music has been minimal. Last year, I explored a program called AudioSauna which would run a digital audio program within your browser. Best of all, it was very Chromebook friendly.

This year, I really started to work with students during my technology class to create playlists of student work. My focus has been on working with 6th and 7th grade students. I have created a simple Blendspace to get started that has been included below. Please check back for more samples as they are completed! Click below to view the embed lesson.  As I continue to teach students about digital audio, I will be creating more resources.


8-Bit Graphic Design

As a change of pace, I decided to create a one day project for my 5th grade graphic design class. I found an online web based pixel editor geared towards creating 8-bit inspired art. Using the program Piq, students created their own 8-bit inspired art and uploaded it to their Google Classroom.

  • myPixelArt
  • sheryl avornu's picture art
  • KB's art
  • espinoza
  • guzman
  • espinoza555
  • myPixelArtch
  • myPixelArt (2)
  • mypixelartvanterpool
  • myPixelArt (1)
  • kazi
  • emily castro's awesome pixel art