Google Forms: File Upload

I have many teachers wishing there was a better way to collect files like videos and photos from their students.  The separate emails or share notifications from each student can get frustrating and overwhelming.  There is a really easy way to collect these types of files - or any other file for that matter - and you won't have to search through your email inbox or Shared With Me to find them.  The answer?  Google Forms!

There is a question type in Google Forms called "File Upload" and it will ask the person filling out a form to add a file.  Once they hit submit, this file will be uploaded into a folder in your Google Drive and you have sole ownership over the files.  They are not shared with the person who uploaded them - nor can they access the file once they have uploaded it.  This is simply a way for them to quickly and easily submit a file to you.  Keep in mind that the person submitting the file will be required to log into Google - so only people with Google Accounts will be able to upload files.

If you are not familiar with Google Forms at all - check out my Google Forms 101 post which gives you all the information you need to get started making your own form.  You can always feel free to set up an appointment with me as well to help you get going.  You can read on to see how to start a new form and how to find the "File Upload" question type.

To start a new Google Form, browse to your Google Drive and click "New" --> "More" --> and "Google Forms".

Make sure to give your form a title so it looks nice and you will be able to find it in your drive later.  Then you can change the question type from "Multiple Choice" to "File Upload" by clicking on the little drop down for question type. 

You'll get a warning about how it will make the person responding log into Google in order to access your form.  You can just click on "Continue" when this message comes up. 

Now you will see some options for your file upload.

If you turn on the "Allow only specific file types" option, then it will give you some checkboxes to choose which types to allow. You can also choose how many files a respondent can upload and put a limit on the file size.  If they are uploading pictures and videos - you will want to choose a larger maximum size.  You'll also want to adjust the total file upload limit for the whole form by clicking on that little blue "Change" link you see under the "Maximum file size" (pictured above).  You can then set the total file upload limit in the settings there (pictured below).

When someone goes to fill out the form, they will see a little "Add File" link and all they have to do is click to upload their file and hit submit.  Easy!

To find the files that have been uploaded, click on the "Responses" tab of your Google Form.  You will see all the files listed there and you can click the links to open them one by one.  If you'd like to view the folder that contains all of the files, click on the "View Folder" link.  You'll notice that the name of the person who uploaded the file is included in each file name.  Thanks, Google!

#SketchCUE

*The information below was for #SketchCUE 2018.  Information on #SketchCUE 2019 will be coming soon!

*********************************************************************************

My favorite Ed Tech event of the year is Spring CUE in Palm Springs.  Not only do I get to go and learn, but I get to hang out with all my amazing PLN people face to face.  These people are online colleagues, but I'm proud to call many of them friends as well.  Every January, I start to get excited because I know CUE is just around the corner.  This year, I'm extra excited!  Why?  #SketchCUE!!

I'm a sketchnoter and the Spring CUE conference is when I do most of my sketchnoting.  So many amazing sessions and keynotes - I can't help it!  I LOVE to sketchnote, but I don't consider myself an artistic person.  It has taken me years to practice and dial in my sketching skills and I still don't consider myself artistic.  I do, however, feel confident enough in my sketches to share them out now, but it has been a journey of practice!  I don't know about you, but I love to see other people's sketchnotes.  The way the learning is made visual in so many different styles just blows my mind.  

Last year, I participated in an event that took place after Spring CUE called #Sketch50.  A bunch of people joined together on Twitter and did a sketch a day for 50 days.  This sketching practice helped me so much!  Not only did it give me practice, but it also gave me a library of little sketches that I can copy and paste and use in the future.  This got me thinking...what if we did some sketch practice leading up to CUE?  Something simple and fun that would help us brush the dust off our sketching tools and get some practice in before CUE comes around.  I reached out to fellow sketchnoters Wanda Terral (@wterral) and Cate Tolnai (@CateTolnai) and #SketchCUE was born!

Here's how it works:

From February 5th until March 9th, there will be a prompt tweeted out using the #SketchCUE hashtag each day (weekdays only).  We will have 25 simple prompts that will help you practice your sketching skills.  When it is all said and done, you will have a whole library of sketches that can inspire your future notes.  If you sketch digitally, and your app of choice allows it, you might even be able to copy and paste your sketches directly into your future notes. 

Steps to participate:

• Watch the #SketchCUE hashtag every weekday from February 5th to March 9th for the daily prompts.  (I will tweet them out, so you could also follow me - @TeachingTechNix.) 
• Sketch using your tools of choice.  This could be on paper or digitally.
• Tweet your sketch out to the community using the #SketchCUE hashtag before the end of the day for each prompt.  

That's it.  It's easy and it will be so much fun!  I hope you join in with us during the next few weeks as you prepare to #SketchCUE at #CUE18.

Instagram Template with Google Slides

*Update - See the new updated Instagram Template here.

For better or for worse, students are all over Social Media - so why not give them a little of what they love mixed in with the learning?  My friend Ryan O'Donnell, (@creativeedtech), is quite talented with creating templates and he made an Instagram post template in Google Slides that caught my eye and sparked my imagination.  There are so many fun ways to use this in the classroom!  You can get a copy of his template by clicking the link I provide at the end of this post.  You can also find my updated templates for 2019 and 2022. Here is a glance at what he created:

How could you use this in the classroom, you ask?  Here are a few examples:

Summarizing chapters or sections of a book:
It takes quite a bit of skill to boil a summary down to a few sentences that truly capture the main ideas of a chapter.  Students can create a Slides file from the template where each slide becomes the summary for each section of text you assign.  They will need to choose a screen handle and profile picture that are appropriate for the character they are impersonating.  They will also choose a picture and some text for their "post".  This is an example for Chapter 1 of Charlotte's Web.

Baby pig photo from Michael Kappel

Responding to a historical event:

Students will need to choose a screen handle and picture appropriate for the historical person they are impersonating.  They will find a profile picture and "post" some text. This can be used to summarize an event or show their understanding of an event and/or its importance. 

Animal Study:

Students will take on the perspective of the animal and make posts to show their knowledge of that animal's life, habits, habitat, and diet, etc.  Think of something like "If an iguana had Instagram".  I'll tell you what, I learned quite a bit about Iguanas while creating these "posts" for this example!

Wild Plum photo from Forest and Kim Starr

Some other ideas are:

• Highlight a scientific discovery or invention
• Make a post that a book character would make about a certain event from the story if they had an Instagram account and lived in our day and age
• Make a post to show their knowledge of why a noteworthy person is well known
• Assume the role of Social Media manager for a specific state and make multiple posts showing the important things about your state, including all the things you might include in a state report

There are so many ways to utilize this type of template.  I'd love to hear how you decide to use it, and so would Ryan!  Feel free to tweet it out and tag us both (@TeachingTechNix and @creativeedtech).

You can get a copy of Ryan's original Instagram template by clicking here and view my 2019 template here.  I've recently updated the template with a new 2022 version, which you can view here. On the page that opens up, click the blue "Use Template" button in the upper right corner.

Check out Ryan's website for more amazing templates for all sorts of fun things.

*If you liked this Instagram template, you might also like my Fake Tweet Template.

Google Slides: Grid View

There is a new feature in Google Slides and I just can't contain my excitement!  Google has finally added the grid view feature!  This was the last remaining thing I missed from PowerPoint and I'm thrilled Google has given it to us in Slides.

To view your slides in Grid View, click on "View" across the top and choose "Grid view" from the list.  You can also look at the bottom left corner of your Slides window and see the little icons to swap from standard view to grid view.

There are a few more features they just added, like Add-ons and Google Keep integration, that you can read about in this post from Google.  

If you don't see the "Grid view" option in your "View" menu - don't worry.  It is still in the process of rolling out to all domains.  Hang tight and you should see it soon!

The Time is Now

A few weeks ago, I attended the 2017 CUE National Conference and I had the opportunity and privilege of taking eight teachers and two administrators with me.  It was an outstanding learning experience for all.  If you ever have the chance to attend a CUE National Conference - I highly recommend it.

I always come home with some fun and useful things I've learned, but this year I came home with much more than that - in fact, my whole team did.  It is an overwhelming sense of urgency.  The time is now.

I think we can all recognize that there are some significant shifts happening in education right now.  The way our students learn and relate to their world, the skills they will need to be successful in their future jobs, and the way teaching and learning need to change due to the presence of technology.  This list can go on and on.  We are irrefutably in the midst of a huge transformation in our education system.  At this point, we can agree technology isn't a fad - it isn't going anywhere.  Our students learn differently and have different needs because of the way our world has changed.  Don't we owe it to them to change the way we educate them to match the world we are educating them for?

We are at the point where we can no longer wait and see how things go.  We can't keep saying, "I'll try it next year, next unit, next time."  The time is now.  Right now.  We cannot continue to stand on the sidelines and watch others do the changing.  It is time to jump into the trenches as fellow teachers and figure this stuff out!  We are told our students need more collaboration - it's true - but so do we!  Let's hunker down together and try new things, share our successes and our failures, observe each other and learn from one another.  The time has come to take our toes out of the water and dive in.  The time has come to try new things and learn through all the victories and the mistakes.

"The best chance you have to change the future walks through your classroom doors every morning." - James Sanders 

Look at your students as they walk through the door.  They need us.  They need us to climb out of our comfort zones, set aside our fears - of failure, of technology, of going "off the lesson plan".  They need us today.  The time is now.

"Tweet" Template with Google Slides

When you can't take your kids to Twitter, take Twitter to your kids!  Often age limits, privacy laws, and school policies prevent you from having your students use Twitter.  This isn't necessarily a bad thing, but sometimes having your students write a tweet works very well with your lesson plan.  After all, summarizing something into a 280 character tweet is more of a skill than you'd think.

There is a 5th grade teacher at my site who wanted her students to form a tweet, so I created a single tweet template in Google Slides.  I edited the master slide so the template became the background of the slide, and the only things the students could edit were the text boxes they needed.  Doing this made it so that they couldn't accidently delete the images in the template.  If you want to see how to edit the master slide - watch this quick video tutorial.

Here is what the template looks like:

We didn't have a ton of time for the activity, so instead of having students take a picture of themselves and put it in the image box, I placed some profile icon choices in the gray workspace around the slide so they could drag and drop the one they wanted to use.

If you'd like to use this template - feel free to click here and get your own copy.  You can edit the master slide to change the date and time on the tweet if you wish.

Happy "tweeting"!

Google Forms: Digital Assignment Tracking

You can use a Google Form to easily keep track of the turn-in rate of homework or other student assignments.  Make the first question the name of the assignment for easy sorting.  As the second question, use a multiple choice grid with each row being a student name and each column being a turn-in status.  You can even make it a required question so that you force yourself to never skip a student.

This type of form could also be used to take a quick snapshot of student mastery or progress on a particular skill.  The first question would be used to identify the skill or subject you are assessing.  For the second question, the multiple choice grid, you would use the rows again as student names, but make the columns be progress indicators - struggling, emergent, proficient, mastered, etc.

Make this even better by using the add-on for Sheets called Row Call.  This could put the responses for each unique topic or subject into their own tab in the spreadsheet for a more organized view of the responses.

I always mark the option to provide a link to submit another response, so after I submit, I’m ready for the next assignment or topic.

Thank you to Kyra Bowers (@KyraBowers) for sharing this idea with me!

What to ask?

• Assignment name, Topic, or Skill
• Multiple Choice Grid with student names as rows and assessment criteria as the columns. 

If you'd like to copy a sample form to make it your own - click here. 

Here is what this form could look like: