Resources‎ > ‎

Data Doesn't have to be a Four-Letter Word

Hyperdoc

 


Entry Tickets

        An entry ticket doesn't have to be anything fancy or complicated. You can create a basic entry ticket in a matter of minutes, and use it with your students quickly and easily. As students become accustomed to the style and types of questions they can expect, you may begin to have students design and implement their own entry-ticket style assessments for use in your class.

Objective

Gain a better understanding of your students, in order to inform teaching decisions you’ll make today.

Steps
  1. Create a new Google Form
  2. Automatically collect user names.
  3. Ask questions designed to gather data about areas of interest
    1. Prior knowledge
    2. Attitude towards learning
    3. Mood and motivation
  4. Share the form by generating a short URL
  5. Use the summary of responses to analyze the data.

Conditional Formatting Challenge

        Conditional formatting is a feature of Google Sheets that will automatically change the appearance of data according to rules you've defined. This challenge is shown in the context of a math classroom, but the same approach can be used in any subject area.

Objective

        Identify students according to their level of understanding: complete understanding, computational errors, or conceptual errors. 

Steps

 1. Use a Google form to collect student responses. This would be a great time to try out one of those "entry tickets" we've been working with.  
 2. Open the form in Google Drive.  
 3. Click on "Responses - View Responses"  
 4. If there is not a spreadsheet associated with the form (that is, if you don't see "view responses"), create a response destination spreadsheet.

 5. Choose a column that contains responses to a question, and right click on one of the cells.
 6. Select the range to apply conditional formatting to. Tip: to select an entire column, enter the start cell letter and number, and the ending letter without a number. E.g. C2:C

 7. Choose a rule type and the comparison. In this example, we are looking for responses that include a decimal, since a fraction shouldn't contain a decimal.

 8. Click "Done" when you're happy with the appearance. You can choose to add another rule to the sheet.

Filter View Challenge

        Filter views can be created before or after you have used a form with your students. It is a fast way to apply a filter rule (or multiple filter rules) with a single click.

Objective

        Create filter views that will help you quickly identify students who demonstrate an understanding of the material, or computational or conceptual errors. This challenge will use previously-created data, but the same procedure can be used before any responses have been submitted.

Steps

  1. Open your form, and click on "Responses - View Responses."
  2. In the tool bar, look for the filter icon. Click on the small drop-down triangle next to the filter icon to show the filter view menu.
 1. Open your form, and click on "Responses - View Responses." Make sure that you have only one cell selected before the next step.  
 2. In the tool bar, look for the filter icon. Click on the small drop-down triangle next to the filter icon to show the filter view menu. Choose "Create new filter view"  
 3. In the first row on your spreadsheet, you will see small drop-down triangle icons. Click on one to see a list of the unique values that appear in that column.  
 4. Place a check next to all the unique values you want to include in this view. You can use "select all" or "clear" to quickly change selections. To search, type in the text box and use the options to select all or clear to change selections in batches.
 5. You can filter by condition. Click the small drop-down triangle to create a filter rule to apply to the column.
 6. Apply additional filters to other columns by following the same steps.

 7. Give the view a descriptive name by clicking on the name field in the grey bar above your data.

 8. To close the filter view, click on the small "X" in the grey bar. You can create as many different filter views as you wish, and access them from the same filter view menu as in step 2.

Real-time Feedback Challenge

        Add-ons are a feature of Google Apps that allows users to add functionality to the core suite of apps. One popular add-on goes by the name of Flubaroo, and it allows users to grade student submissions automatically.

Objective

        Use the Flubaroo add-on to grade student submissions as they are entered in your form, to give students information about their own learning as it happens.

Steps


 1. Open a form in Google Drive. Make sure you have enabled "automatically collect usernames"  
 2. Click on "View live form" and submit the correct answers as the first form submission.  
 3. Click on "Responses - View Responses"  
 4. If there is not a spreadsheet associated with the form (that is, if you don't see "view responses"), create a response destination spreadsheet.

 5. In the spreadsheet, click on the "Add-ons" menu, and choose "Get add-ons". Select "Flubaroo" and click the blue "Install" button.
 6. In the add-ons menu, choose "Flubaroo" and select "Enable in this sheet."

 7. In the Flubaroo menu, choose "Advanced," and select "Enable Autograde."

 8. Follow the instructions to enable auto-grading of the assignment.

Exit Ticket Challenge