Thursday, June 30, 2016

Google Forms to Quiz

So I tried to create a form today and was asked if I wanted to change it to a quiz... So I investigated.

The fact that the gear in the upper right was highlighted told me to click it.  Here is what I found.

What?! There are 2 new tabs in here... Presentation and Quizzes.  Like Alice, I traveled deeper down the rabbit hole.


This appeared to be just like the old new forms.  Thought it was something about google slides.  Apparently, it is the presentation of the form.  How is it presented to the person filling it out.
Dreams = crushed.


Hoping for better, I lurched my mouse to the quizzes tab.  That was where the magic happened.

There are options for emailing respondents their quiz scores or releasing scores after teacher review.  This means that there must be a way to assign points to each response... There are also options for what students get after they submit their scores.

I wait with bated breath. What secrets lie ahead.

Further down the Rabbit hole:

That is right, I wrote a question.  Check it out.

I clicked on the ANSWER KEY button and added the correct answer.  I left out the picture so you can try it yourself, but it put a check mark to the right of the correct answer (next to the X).  That button becomes like a toggle switch.  This only shows up for Multiple Choice, Dropdown, and Checkbox questions.  When you assign the correct answer, you can:

  • Assign a point value for the question.
  • Create feedback for answers (incorrect and correct)
  • Attach links to the answer feedback for further investigation/reteaching.

I filled out the Form.  The question has the point value next to it.  See!

When I was done I got my confirmation page.  I had the setting checked to give feedback immediately.  Here is what it said.

What happens when you click that?


Notice that the things shown correspond to the options that I checked for this quiz.  Guessing that this changes based on what you have checked with your quiz.

What is the moral of the story?

Click that Dang Button!

To figure out what the other things do, go and create your own.  Change the settings and figure out what it does.  Not that I am trying to be a jerk, but clicking the button is fun.


Number formatting in Google Sheets

There are plenty of number formatting types in google sheets (and you can always copy them from excel and add more custom ones if needed), but that is not my issue.

The issue here is that these formatting options go away when a sheet is copied. Unless the cell is not blank.

So if you highlight a cell and make a specific number format, you can later go into the cell and add a number, it will fit that format.

save image                save image

But that only works if you have not made a copy of the sheet.

Why would you make a copy of the sheet?  What if I am giving out the sheet to a group of students or collaborating on a document that always has the same start point (you know, a template).

Put a number in the cell, in the template!

The trick is to have a number in the cell, in the template.  Just add zero, or 1, 2, 3, or 4.  Then when you make a copy of the sheet, because the cell is not empty, it will keep the number formatting.

save image

And you can fill them in with the correct numbers on the new copy of the template.

The more you know.

Saturday, June 18, 2016

Onetab - a must have for Twitter chats

I love Twitter chats. As innovative educators we can get complacent with being seen as innovative in a small group, on a school campus, or in a school district.  In reality, how are we beyond our campus, district, or particular situation.  The members of my PLN (professional learning network) inspire, challenge, and motivate me to try new things and apply what I have done in other ways.  They also teach me through our conversations. Truly amazing people who exemplify growth mindset, entrepreneurial spirit, and collaborative learning.  In 1 hour, I learn more than I could articulate in 40 hours of work.  Here are my favorites.

There are so many more, but I have a family and moderation is key to sustaining that.

So where does OneTab fit in?

  • Chats move fast.  People share resources and links.  I want to read them, but I don't have the time to do it during the chat.  Here is how I handle it.
  • Hold Ctrl and Click the links that people share that you want to read.  That will open the link in another tab.
  • Continue with Chat.
  • At the end of the chat, I use Onetab to save the links for later.  I go about my day with my family.

How to... with OneTab

Go to the chrome webstore and download the extension to google chrome. Here is the link for it. Onetab takes all your open tabs and turns it into a single tab (onetab) with all the links to the resources that are currently open in your web browser.
save image

This will save on this chrome account on your computer (will not be on another computer).  The next time you open chrome on the computer, it is there.  

I name the set of tabs and click Share as Webpage.  This will turn the set of tabs into a webpage with a shareable link.  I create a calendar event for later in the week, when I have time to look at these and I paste the link into the notes of the calendar event as well as reminder test to let me know the topic of the chat.  This ensures that I revisit my train of thought and that the PD I have in my chat is not lost and gone.