Skip to main content

Google Forms Presentation Rubric

This idea comes from working with Kathy Laney at Hicksville. We were looking at how to convert a paper form presentation rubric and came up with the idea of using a google form and submitting a record each time the student does a presentation. The results are tabulated in a spreadsheet 




Here is a link to make a copy of the Form

Once you have the copy of the form in your drive you will need to open it and click on the responses tab and create a new spreadsheet to hold your results. (click the Green icon) 


You will notice that the questions from the form correspond to columns in the spreadsheet. Each question has one answer (a checkbox) with the value X. Checking a box will result in an X in that column in the spreadsheet which makes it easy to see at a glance who has been assessed and what they scored.

To customize you can delete the demo students and add your own by editing the first question.

Intermediate Tip:  You can populate this using a Forms add-in called Form Ranger. It will pull in values from a spreadsheet and populate your dropdown menu automatically. 
Make a new sheet in your results spreadsheet (see above) and add your student names to the spreadsheet. For convenience you can combine the First Name and Last Name using a calculation (concatenation) and when you fire up Form Ranger you can create a dynamic popup menu based on that column in the spreadsheet.


Use the Add-ons menu to add Form Ranger to your spreadsheet.


Comments

Popular posts from this blog

Power up Google Classroom with Private Comments

One of the most powerful elements of Google Classroom is the private comments feature, which works with assignments only.  Comments become conversations with students, allowing for more back and forth discussion than can happen with verbal feedback. Every student can have a voice and communicate their ideas or struggles with a task. To use private comments, open an assignment in Classroom, and there you will find a space for private comments. Any comments left here will be seen only by you and the individual student. One of the challenges to using private comments is knowing who the comments belong to. Here’s a workaround from Alice Keeler : Students start all comments to you with your last name You start all comments to students with your initials This helps in filtering those comments in Gmail, or searching. It also lets you quickly see who responded last in the roster: You can also use links in private comments to give students more informat...

What the SHEETS?!?

When creating a new Google Sheet, by default, it will have one sheet tab at the bottom of the page. The program is designed so that you can have a maximum of 200 sheets. To add additional sheets, you can click on the plus sign in the sheets toolbar. One sheet will be added. To rename the sheet, click on the dropdown arrow next to the Sheet, and select RENAME. You may want to explore other sheet tab options available from the menu. There may be times when you want your Google Sheet to open to a specific tab. To accomplish this, copy the URL of the specific sheet tab. For example, if you want the Google Sheet to immediately open to the second sheet tab named Chart, copy the Chart sheet tab URL. You will notice that the information to the right of the / changes: Google Sheet URL: https://docs.google.com/spreadsheets/d/1hivDhrInFjmhl-AFB_frFOvpsyuY541hxn6ShQuo7I8/ edit?usp=sharing Chart Sheet Tab: https://docs.google.com/spreadsheets/d/1hivDhrInFjmhl-A...

I want to Shoot My Screen!

OK so now I have your attention! If we re-arrange the words a bit "I want to take a shot of my screen" aah yes screen shots but what are they good for? Many websites while allowing students to do drill and practice and take quizzes, they lack the ability to save or record scores or results. Have the students take a screenshot of their results and submit via google classroom as an attached image. Screenshots are a way of capturing a picture of your screen, be it your chromebook, a desktop computer or even your cell phone. The secret to unlocking this feature is to know the magic key combinations or button presses for your particular device. Windows - The old standby is Alt + PrnScn which copies the entire screen to the clipboard. You can then paste it into your favorite editor to save as an image file. Windows 7 and above - Included in your list of apps is one called the Snipping Tool . Add a shortcut to your toolbar and when invoked this app lets you take a scree...