I have a worksheet.... now what? Update 2020

 It is now one and a half years after our first "I have a worksheet... now what?" post.   

Back in May of 2019 we spoke of formatting Google Docs with textboxes for responses, using Google Forms as well as leveraging Add-Ons Such as Alice Keeler's Pull Table for digital worksheet completion.

Earlier that year we also looked into ClassKick  which provided a way for students to draw on top of PDFs and access a toolbar with text, scribble and audio recording features. 

Wizer.me made its debut to the TechSpot in 2017 creating a more interactive experience for the student, but with perhaps more upfront work for the teacher. 

Remote learning heightened our awareness and increased the need for taking our paper tasks and enabling their access digitally.  Previous mentioned methods became more popular, and Google Slides allowed us to create backgrounds with our activities and have students respond on top. 

But then, here last month TeacherMade came out with a web application that is exactly what teachers had been looking for.  A quick and easy way to upload a worksheet and have students write on top with little to no prep. 

Here in today's TechTuesday, instead of just introducing TeacherMade, I decided to take a paper worksheet that I had given my students this week as a pre-reading activity and put it to the test of 4 top digital worksheet tools. 

You can view the Google Slides presentation alone to see some screenshots of my results and/or follow along with me as I test each one in the Loom recording: 

Intro: 0:02   TeacherMade: 1:03   Google Slides: 7:00   ClassKick: 12:22  Google Forms: 16:58

Elementary teachers now have SeeSaw which enables them to push out a PDF for students to complete.  The above applications may have some features that could further enhance some of  your activities and certainly be assigned through your SeeSaw platform as well.   Is there anything that stands out to you? Let us know in the comments below! 

Have you been able to try any of these applications yet?

How did it go? 

Would you mind sharing a sample with us? 

As always I would love to hear how I can help you brainstorm new ways that technology can enhance and amplify what you do in the classroom! jtamburlin.youcanbook.me

Google Form Fans, This One's for You!

Google Form Fans, This One's for You!

If Google Forms have become part of your regular routine, you may want to check out some of these time-saving tips.

Make a Google Form from a Spreadsheet.

I always say teacher time is too limited to waste!  Get the most out of your efforts when creating new materials!  This is why I always promote putting vocabulary terms and key unit questions into a spreadsheet first and foremost.  From there you can import them into a variety of online quiz games and assessments.

Google Forms is no different!  And, with the help of Alice Keeler of Teacher Tech you can create a form directly from a spreadsheet.   Go to alicekeeler.com/form to get started.  Copy and paste your questions from your unit spreadsheet or import this one later for a Quizz.izz, Quizlet or Kahoot !

*Be patient with the Add-On menu when you first try it.  It takes a moment to appear on the list.



Import Questions from one Form to Another
Now that you have an easy way to create a Form from Sheets, why not make a "Master Form" for your chapter, unit or novel?   Have the whole department collaborate on a "Question Bank" Form.  No one will really use this form, it will just hold your question inventory!

Then, when creating pre-tests, post-test, formative checks, spiral reviews, differentiated quizzes, etc  all you need is one button > Import Question to access your bank of pre-made questions.

Select the "Master Form" and quickly check off the questions you would like to reuse in your comprehension check, exit ticket or summative assessment.  Then POOF you are done, faster than you could have gone to the copier!

Let me know how I can help you make this and other tech work in your classroom or office!


Keep working smarter, not harder SMASD!

NEW Easy Grade Google Form Questions

Google Forms Quizzes are awesome because they:

• self grade
• give quick formative assessment data
•  easy to edit, enhance & adapt
• can be in "locked" mode on district Chromebooks 
• Ss cannot access other websites while taking the quiz

And, all was well and fine when questions elicited only one correct response.   However, when an open-ended question was given, teachers were manually scrolling through individual responses or using the spreadsheet to view answers.

Both were cumbersome and time consuming.  Leading us to limit ourselves to DOK Level 1 style questions when using Forms.

But the wait is now over!  

In your Google Form "Quiz" Responses you will notice a new button called "Question".

By choosing "Question" the teacher can grade each open-ended response quickly by going down through the list.  Evaluating all of the class's responses for the same question at once.  

Scores are automatically tallied in the total.  

The grading process is similar to those of Actively Learn and EdPuzzle.

There are options to:

• quick check "correct" or "incorrect" 
• give partial credit
• add feedback

Now go back in those Google Forms and add your Open-Ended questions!  
Analyze., Explain., Predict., Compare., How?, Why?, Elaborate., etc

Tech or Treat

Today finds me hanging out in the flexible learning space in the SMAMS Library.

The event is a "Tech or Treat" PD opportunity, focused on differentiated learning.

There are three learning stations at "Tech or Treat":

• Google Forms
• For Mastery
• Students have to get all of the answers correct before submitting

• For Remediation & Challenges
• <Go to Section Based on Answer>
• Upon answering incorrectly, students can be directed to a worked example or tutorial, before attempting to answer again.
• Upon answering correctly, students can level up to a harder question

• Quizalize
• For Mastery
• Turn on the "Mastery Mode" so that missed multiple choice questions will be re-entered into the quiz again, and again until the student gets them right. 

• For Remediation & Challenges
• Based on the student's achievement, he/she will be sent to an appropriate follow-up quiz, activity, video, etc. 

• Differentiation Design 
• What are you going to differentiate in your lesson... 
• the content?
• the process?
• the product?
• How are you going to differentiate... 
• by student interest? 
• by skill level? 
• by learner profile? 
• Are you going to include...
• centers?
• flexible groupings?
• student choice?

Then...  will you find your groupings by a pretest or something else?   Will there be direct instruction at all?  What will that look like?   What happens after formative assessment results are taken? 
How will the summative assessment be conducted? 

A differentiated lesson plan has so many layers and potential combinations of strategies.   The MS is creating a Differentiation Design Team of teachers to pilot some design frameworks this year.

Are you interested in building a lesson plan this way for your department or grade level?  Reach out to me and we can work though this together!  jtamburlin@smasd.org 

In the meantime please stop by the MS Library for our second day of "Tech or Treat" tomorrow, Wednesday, October 30th.  Here are some pictures from what we have in store!  

Google Forms Quick Ideas

Google Forms with Guest Mentor Teacher

Last week we #Brokeout of the traditional lesson plan with #BreakoutEDU.  
This week the TechSpot is going to #Breakout of the traditional blog post.   

Mentor teachers are all around us here at SMA, and can give different perspectives on the integration of our Tech Tools.  Therefore we thought it best to actually give those teachers the mic and hear what they have to say.

Tune in to our first TechSpot podcast on Google Forms below.  

You can expect to hear about: 

• How the mentor teacher has already used Google Forms this fall in 3 different ways
• How we can use Forms for productivity and organization
• How we can use Forms for data collection and data-based lesson planning

You may watch, or just have it playing in the background while you work.  

Having trouble viewing the video?  Click HERE.

Need something different?  Check out these sites!

• Goformative.com
• different options for questions, unique layout, nice display of student answers to share with the class

  

  Go Formative

• Edulastic.com 
• great for math teachers as you can embed your algebraic symbols within a text set

Edulastic

How have you used Google Forms this year?  

Want to share another site you use for gathering data?

Leave a comment below!

Want to nominate a mentor teacher for next month?  Let us know!

jtamburlin@smasd.org
acatalone@smasd.org
avollmer@smasd.org

Google Forms as Quizzes

Google Forms: 

If you are like me, you have come to love Google Forms.  

Google Forms help me: 

• Gather parent/student info at the beginning of a course
• Obtain Exit Ticket data at the end of a lesson
• Survey and poll the class and faculty
• Create self-grading assignments for quicker feedback
• Design flipped lessons
• Take orders for fundraisers
• Collect RSVPs for an event

Now Google Forms offers a Quiz feature within the app itself!  (no extension needed)

For multiple choice questions, it is as easy as a mouse click to assign correct and incorrect answers that will be self-graded.

Check out my video as I make a Google Form into a Quiz.  
**Form-pros can start the video at about 1:12 to get straight to the action!**

Video Tutorial - Making a Google Form a Quiz

For those of you accustomed to using Flubaroo as an extension in your Google Response Sheet, I have a link here that provides a comparison of the two options. Scroll down on the page to see an info-graphic highlighting the features of each.

Google Forms vs. Flubaroo

Have you used Google Forms as a Quiz?  Send us your feedback in the comment section below.

When it doubt, FORM it out!

Want pre-testing data?  Or an exit ticket?  How about a class survey?  Would you like to gather info for a department meeting?Don't forget those T-shirt orders!

Google Forms is allowing teachers to create digital questionnaires that provide real-time results and feedback.  Increase productivity while gathering data that was impossible with paper worksheets and quizzes.

How to make a form:

1. Go to: forms.google.com (log in with your smdutch.net acct)

2. Click the + sign to make a new form from scratch.

3. Start filling in the field boxes.

     a. Change the title of your form. 

     b. Type in your first question (don't worry you can rearrange them later, just drag 'em)

     c. Decide the type of response you would like.  (multiple choice, short answer, etc)

     d. Put in your answer choices.

     e. Decide if the question is required or not by clicking the switch.  (if on, students cannot leave a question blank)

     f. Use this menu to create another question, a header for a new section, instructions, add an image or a YouTube video.

     g. Change the style of your form, preview it and change form settings.

    h. Get the link for your form to post on your Google Classroom or class website.

Viewing Results:

The best way to see how the results will come in is to take the quiz or survey yourself.  Using the SEND (h) button, get yourself the link to complete a sample or a key.

To view your results, go back to your form (in your Google Drive or forms.google.com) and click RESPONSES.  Here you will see data in graph format as well as the ability to see each individual participant's responses.

Your results can be downloaded to a Google Sheet for easy grading or tallying.  (green button below) You can even have the results automatically graded for you with the Flubaroo extension.  (Send an email to a techcoach for more info on implementing Flubaroo).

Watch me make a form for you!  Click here.

(use your smdutch.net login for access)

View and respond to the same form.  Click here.

Tips: 

• make a copy of your form for each period you teach
• easily adapt forms for IEP accommodations
• make changes that take effect immediately 
• have your STUDENTS create a form for your class that accompanies their presentation, project or video