Tuesday, December 29, 2020

Three Neat Things to Create With Google Sheets

As I do every year, I'm taking this week off from writing new blog posts. This week I'll be re-running a few of the most popular posts in 2020. 

Earlier this week my friend Beth asked me for some tutorials on Google Forms for beginners. As a follow up to that I've selected three Google Sheets tutorials from my library. These tutorials are for doing some interesting things with Google Sheets besides just looking at information collected through Google Forms.

Create a Random Name Picker in Google Sheets.


Create a Progress Tracker With Google Sheets


Create a Map of Spreadsheet Data

Monday, December 28, 2020

By Request - How to Create Timed Quizzes in Google Classroom

As I do every year, I'm taking this week off from writing new blog posts. This week I'll be re-running a few of the most popular posts in 2020.

I'm taking a digital portfolio approach to assessment in our remote learning environment and using EDpuzzle for little comprehension checks. But my approach to assessment isn't the only one you might take. In fact, a more than a handful of people have asked me via email, Twitter, and even a phone call (a colleague of mine) about using Google Forms for timed quizzes. It is possible to deliver timed quizzes by using a combination of Google Forms, Google Classroom, and Form Limiter.

In this new video I demonstrate how to you can create a timed quiz in Google Classroom by using Google Forms, the Forms add-on FormLimiter, and the scheduling function in Google Classroom.



Step-by-step directions:
1. Create a new quiz assignment in Classwork in Google Classroom.
2. Create your quiz in the Google Form that was created by step 1 above.
3. Install the FormLimiter add-on for Google Forms.
4. Enable a date and time limit in the FormLimiter add-on.
5. Use the scheduling tool in Google Classroom to make your quiz live at a specific time.

Create Video Lessons Without Making Your Own Recordings

As I do every year, I'm taking this week off from writing new blog posts. This week I'll be re-running a few of the most popular posts in 2020. 

In the latest episode of The Practical Ed Tech Podcast I mentioned that EDpuzzle recently updated their user interface and that I was going to make a video about it. Well I started to make a video just about the updated UI then realized that I could help more teachers right now by making a complete overview of how EDpuzzle works. So that's what I did. In the following I provide a complete overview of how to use EDpuzzle to create video lessons using videos that you find online.

Highlights of the video include:
  • How to create an EDpuzzle account.
  • How to create an EDpuzzle classroom via Google Classroom and without Google Classroom.
  • How to make lessons with videos you've found online.
  • How to make lessons with videos you've created.
  • How students can access and respond to your lessons.

The Difference Between Signing Into Chrome and Signing Into Your Google Account

As I do every year, I'm taking this week off from writing new blog posts. This week I'll be re-running a few of the most popular posts in 2020.

Last week my friend Beth Still asked me if I had a video that showed people how to sign into Chrome and switch between Chrome profiles. She mentioned it because she was helping some people who were confused about the difference between signing into Chrome versus signing into their Google accounts. The differences are small, but significant. In the following video I demonstrate signing into your Chrome profile versus signing into a Google account.


Applications for Education
As I explained in the video, signing into Chrome makes it easy for students to take their bookmarks and personalized Chrome settings with them from computer to computer. It's also important to note that students should sign out of their Chrome profiles if they are sharing computers and don't have separate user accounts for the shared computers.

Sunday, December 27, 2020

Five Ways to Make Whiteboard Instructional Videos in Your Web Browser

As I do every year, I'm taking this week off from writing new blog posts. This week I'll be re-running a few of the most popular posts in 2020. 

Over the last few months I've written a bunch of blog posts and made a handful of videos on simple ways to make whiteboard instructional videos in your web browser. These have been popular, in part, because this style of video can be made using tools that are readily available to Chromebook users. As a reader pointed out to me in an email this morning, I haven't put all of these videos and posts together in one place. So to remedy that I've put together the following compilation of five ways to make whiteboard instructional videos.

Try using Screencastify to record over the free drawing space provided by Google's online version of Jamboard. The online version of Jamboard is free unlike the physical product of the same name that Google sells. One of the benefits of using Jamboard for this kind of video is that when you are done you can share the Jamboard images with your students. You could even share the Jamboard via Google Classroom so that students have a copy of the process that you demonstrated while making your video.



Loom is also an excellent and popular choice for making screencast videos right from your web browser. In the following video I demonstrate how I paired Loom and Google's Jamboard to make a whiteboard-style instructional video. One of the tips that I shared in the video is to use the sharing option in Jamboard to give your students a copy of the drawings or sketches that you use in your instructional video.



Flipgrid offers an integrated whiteboard function. You can use this feature to create whiteboard videos for your students to watch in Flipgrid. You can also have your students use the whiteboard tools to reply to a prompt that you have given to them. In my video that is embedded below I provide an overview of how to use the whiteboard function and a couple of other functions in Flipgrid.



Wakelet has integrated the Flipgrid camera into their service so that you can create whiteboard-style instructional videos directly within your Wakelet collections. Watch my video below to see how that process works.



Seesaw is my go-to tool for making digital portfolios. I like it because it's a versatile platform that can be used for more than just portfolio creation. You can use it as a blog, use it to share announcements with parents, use it to distribute assignments, and you can use it to create whiteboard videos. In fact, there are a couple of ways that you and your students can create whiteboard videos in Seesaw. Both of those methods are outlined in my new video that is embedded below.