Using Microsoft Forms in your in-person or online classes

Photo by ROBIN WORRALL on Unsplash

One tool I make use of quite a bit in my in-person and synchronous classes is the cell phone. I realize some instructors would rather have students stay off their phones, but I talk with my students about being present in the class which means they leave the class (virtually) when they are on social media or chatting on their phones with friends. Instead, I have students participate in activities using online tools such as Microsoft Forms. This post isn’t meant to be a step-by-step instructional guide to using Forms. Instead, I want to share some ways in which I use forms in my classes and how you might make it work for you as well.

Ranking Question

This is one of my favourite uses for forms in my classes. I have used it my ELLA, Student Success, and TESL courses. Here are some examples of how I put it to use:

  1. In my lowest-level ELLA writing course, we are working on paragraph structure. I took an eight-sentence paragraph that had a topic sentence, supporting sentences with transitional keywords, and a concluding statement and I mixed up the sentence order. Students in groups in class worked together on their phones, tablets, or computers to put the paragraph into a logical order. I only needed one response per group, so I had them designate a leader to post the responses on behalf of the team. Once each group has submitted their response, I then review it together as a class. Forms provides a graph showing the order of the sentences based on a calculated total of all responses. This shows the average response for the entire class. Later, I can review each group to see which group had difficulty with the exercise. Here is an example you can try for yourself along with the graph I would show to the class:
  2. In my TESL course, I had them work through the order of a sample lesson plan that had been mixed up. In this situation, there were multiple ways of doing things, but there were three main blocks that needed to go in a certain order. The items within those blocks could be ordered differently. When we reviewed together, I wanted to show the three main blocks and how they were important. Again, we did this on phones, tablets, or computers in pairs or groups and only one response needed per group.
  3. In my Student Success course, I had students put things in the order they found easiest to most difficult for them. The topics were based on problems students encounter during their first year in college. They discussed these as a group, but responded individually on their phones, tablets, or computers. We reviewed the average responses as a class.

Paperless Practice Activities

I use the text question option a lot in my forms. This allows students to share their ideas or answers in various ways. I’ve used it with APA reference writing practice, discussion style questions, and problem-solving questions. It is often done in pairs or groups with a review at the end with the whole class. It is one of the simplest ways of reducing paper use in my courses.

QR Codes

While you can share a form with students with a link they can click on, Microsoft Forms also creates a QR code for each form that you can share with students and they can scan with their phones or tablets. There are two ways I use QR codes in my classes.

  1. I will often download the QR code for the form and paste it as a full-screen image in my slides. Students can then scan it on their phones or tables and start working on it in class. Having students working pairs or groups helps with situations where some students might not have a phone or tablet. Only one person per pair or group needs to scan the QR code and they submit the responses on behalf of the group. I use this in almost all of my classes. Students are so used to doing this since it was a common practice during the pandemic to access information.
  2. I have also created a scavenger hunt using QR codes. I create a form for each task I want them to perform in the scavenger hunt and then I download and print the QR code. I paste those QR codes around the campus in areas where I think they should get to know such as Student Services, the fitness centre, and The Learning Centre. I try to hide the QR codes a little bit to make it a bit more challenging and to make sure other people don’t find them and remove them. When students scan the QR code, they get a question about the area and they need to submit their answer. They get a customized thank you message that gives them the next clue. They do this in pairs and when everyone is done, we review the answers as a class and I sometimes give prizes for the most correct answers. I don’t give prizes for the fastest completed since some students might have mobility issues and take longer to complete. I also want them to work through the answers instead of just getting it done. This activity takes some time to set up, but my students have mentioned how much fun it is and I know they at least know what some of the key areas of the college are and where they are located. It is really good for newer students to the college. I also provide students with link to the campus guide they can use to help them locate the places based on the clues.

Student-Created Forms

Since each student has access to Office 365, they also have access to Microsoft Forms. That means they can create forms as part of their work for the class. They can also invite others to work on the form with them by getting the Share to Collaborate link and sharing that with their partner(s). In one of my classes, students were assigned a study skill to research such as exam preparation, notetaking, and time management. As part of the assignment, they needed to do their own research study by creating a form they would use to gather data from students across Douglas College. They would then take that data and create an infographic they would share with their classmates and even the college (we put them up in the hallway). They needed to create both open and closed questions which could then be used in different ways in the report and the infographic.

Rating Question

You can add a rating question to your form to check in with students on how things are going. This is helpful as an exit ticket before them leave for the day to see how confident they are about what they learned that day. It can also be used as a way of midterm check-in to find out what has been working and what hasn’t in the course so far.

Creating a copy of a Microsoft Form

Most of the tools within the Douglas College Office 365 accounts store their data and files within the user’s OneDrive account. This makes it easy for the user to copy files from one area to another. One tool that does not store their files in OneDrive is Microsoft Forms [Note: some data may be stored in OneDrive, but the main form or quiz is not]. Whenever a user creates a form or quiz in Microsoft Forms, the form is only stored online. This means the user needs to find another way to copy the file if they want to use it with another account. This could be when someone leaves Douglas College and wants to keep a copy of their forms and quizzes created using their Douglas College Office 365 account. The user can create a free Microsoft account and then copy any forms or quizzes they want to keep into that free account. It is not a difficult task, but it does require the user to do it one form or quiz at at time.

This is also useful when one user wants to share a template of the form or quiz with another user. This might be an instructor who has created a form or quiz that another instructor teaching the same course could use in their own class. It might even be the same user wanting to create a copy for a different section of the course.

Here is how you can copy a form or quiz to another acccount.

  1. Open the form or quiz you want to copy.
  2. In the top-right corner, click on the three dots.
  3. Click on Collaborate or Duplicate.
  4. Under Share as a template, click on + Get a link to duplicate.
  5. Click on Copy.
  6. Open a private or incognito tab in your browser.
  7. Paste the link into the address bar, and hit return/enter on your keyboard.
  8. Click on Duplicate at the top of the screen.
  9. You will be asked to log into an account. Log into the account in which you want to copy the form or quiz.
  10.  Once you are logged in, it will create a copy and you will now see the new copy on your screen.
  11. If you have more than one form to copy, don’t close the private/incognito tab. Simply go back to the other window where your original form is located and start the process again with the next form. You can simply toggle back and forth between your two accounts in separate windows this way.

Here is a video demonstrating these steps using Google Chrome (no audio – only text guides)

Click on the image above to watch the video

Fixing a problem with YouTube videos in PowerPoint slides

Uh oh. Why is the YouTube link not working? (See below)

If you ever use YouTube videos in your PowerPoint slides, you may have run across the screen above recently. It is a documented problem with the desktop version of PowerPoint (i.e. PowerPoint installed on your computer) and YouTube links. If you use try to click on a link in your slides while in the desktop version of PowerPoint, the link takes you the screen pictured above.

There are two main ways to solve this. Both are pretty easy to do, but one has a distinct advantage over the other. Watch the video below to learn more (bonus: learn how I have students do their presentations in my classes when they have PowerPoint slides).

I should also thank Michelle Henderson for alerting me to this issue and one of the fixes for this problem.

Recording audio for PowerPoint slides and exporting as a video (Mac)

One of the simplest ways of recording a video of your PowerPoint slides is to insert audio into each slide and then have that audio automatically play when viewed. You can then export the slides and audio as a video. Here is how to do that.

  1. Make sure you have the PowerPoint app installed on your Mac. If you want to know how to do that for free, read these instructions.
  2. Open or create a presentation and go to the first slide. Click on Insert in the menu bar.​
  3. Click on Audio and then Record Audio.​
  4. You might need to give permission for PowerPoint to use your microphone. Click OK
  5. Click on the record button to start recording
  6. Click on the stop button to stop recording
  7. Click on Insert to add the audio to your slide
  8. Click and drag the speaker icon to somewhere on the slide.​
  9. Click on Playback in the menu bar and then click on the dropdown menu next to Start and choose Automatically.​
  10. Once you have recorded audio for all of your slides, click on File and then Export.
  11. Next to File Format, choose MP4. Next to Quality, choose Internet Quality. Click on Export.
  12. Make sure you save your presentation as well. If you save it to your Douglas College OneDrive account, you can also share that presentation.

Here is an example of a shared PowerPoint presentation with audio recording for each slide. It also shows you visual steps of what is shared above.

Title slide that has the text recording audio for your powerpoint slides mac
Click on the image above to watch an example recording using this method.

Recording audio for PowerPoint slides and exporting as a video (Windows)

One of the simplest ways of recording a video of your PowerPoint slides is to insert audio into each slide and then have that audio automatically play when viewed. You can then export the slides and audio as a video. Here is how to do that.

  1. Make sure you have the PowerPoint app installed on your Windows computer. If you want to know how to do that for free, read these instructions.
  2. Open or create a presentation and go to the first slide. Click on Insert in the menu bar.​
  3. Click on Audio and the Record Audio.​
  4. Type in a name (optional) and then click on the record button to start recording.​
  5. When you are finished recording for that slide, click on the stop button and then OK.​
  6. Click and drag the speaker icon to somewhere on the slide.​
  7. Click on Playback in the menu bar and then click on the dropdown menu next to Start and choose Automatically.​
  8. Once you have recorded audio for all of your slides, click on File.​
  9. Click on ExportCreate a Video, choose HD (720p), and the Create Video.​
  10. Make sure you save your presentation as well. If you save it to your Douglas College OneDrive account, you can also share that presentation.

Here is an example of a shared PowerPoint presentation with audio recording for each slide. It also shows you visual steps of what is shared above.

Title slide that has the text recording audio for your powerpoint slides windows
Click on the image above to watch an example recording using this method.

Install Microsoft Office 365 on your Windows or Mac for free

Office 365 logo

As part of our Douglas College access to Microsoft Office 365, you can install the full office programs (Word, PowerPoint, Excel, etc.) on your computer for free. This is available to everyone in the college with a Douglas College email: staff, faculty, and students. Once you install these programs on your computer, you can activate the full program by logging in with your Douglas College credentials (email and password). This opens up the full features of each program instead of the limited features of the online versions.

Installing Microsoft Office 365 on your Mac

Click on the image above to watch the video on how to install the office apps on your Mac

Installing Microsoft Office 365 on your Windows computer

Here is how to download and install Office 365 on your Windows computer.

  • Log into your Douglas College Office 365 & Email.
  • Click on the Install Office button in the top-right corner and choose Office 365 apps
  • Run the install that downloads.
  • When prompted, use your Douglas College email and password to log in.

Recording: Students Working Together with MS Office 365 and Blackboard

Title slide from the presentation. It says, "Students Working Together with MS Office 365 and Blackboard" Douglas College. Nathan Hall
Click on the image above to access the recording from the session.

Thank you to everyone who was able to attend the session last Wednesday on Office 365 and Blackboard. The recording can be found by clicking the title slide above. The slides can be located here.

Related resources:

OneDrive

InformationExamples
Share PowerPoint slides in OneDriveLLPA 1100 Week One – Design
Share a Word document in review modeSetting up a positive learning environment in Zoom
Upload and share a video in OneDriveSTSU 1100: An introduction to Office 365 and Class Notebook
Use the Microsoft OneDrive app to scan pages ​Example scan to PDF
Using shared folders in OneDrive ​Example shared folder
Record Video in the iOS OneDrive App ​Example video recording

OneNote and Class Notebook

Information
Overview of Class Notebook  ​
OneNote Class Notebook Create Distribute Review ​​
Create and share a OneNote notebook with students ​​
Create a Group Space with OneNote Class Notebook ​​
Add a Class Notebook to your Blackboard course ​​
Create Sections and Section Groups in Class Notebook ​​
Insert Items into a Page in Class Notebook ​​

Bookings

Information
Create an online booking page for office hours using Microsoft Bookings

Sway

Information
Convert a Word document into a webpage

Whiteboard

Information
The new and improved Microsoft Whiteboard

Downloading your Blackboard Collaborate recordings

You would have received a couple of messages recently about Blackboard Collaborate recordings. The summary is this:

  • The amount of Collaborate recordings has exceeded the storage capacity we have with Blackboard and are being charged overage fees.
  • Those fees are costing Douglas College $11,000 per month! 😳
  • A very large number of those recordings have never been watched.
  • Any Collaborate recordings created before April 30, 2021 will be deleted on November 30, 2021.

What are your options?

  • If you don’t care about those recordings, you don’t have to do anything. They will be removed automatically.
  • If you have any recordings you would like to save, follow the instructions below.
  • If you need assistance, reach out to me before November 30.

Saving Collaborate recordings to your computer

Saving Collaborate recordings to your computer

Uploading your recordings to OneDrive

Uploading your recordings to OneDrive

Uploading your recordings to Kaltura

Support for students using Chromebooks

Picture of a Chromebook

With more and more students using Chromebooks to do their work, you may find they will need a little help with completing certain tasks. I recently purchased a Chromebook I can use to support you and your students as much as I can. I will create support document and videos whenever I find something that might be helpful to share. Here are two videos to get you started. I recorded these for students, so feel free to share the links to the videos with them.


Video 1: Using Office 365 on a Chromebook


Video 2: Installing Firefox on a Chromebook

Due to some issues with Kaltura, students may not be able to upload videos using Google Chrome. For regular desktop and laptop computers, this isn’t a real issue. With Chromebooks, there is a way to install the Android version of Firefox for most newer models.

Please let me know if you or your student have any questions about using Chromebooks for doing classwork or completing assignments.