Gaining feedback is critical in order to improve your instruction. The Excel Survey feature inside of Microsoft OneDrive allows you to create professional looking and easy-to-access surveys that you can share with users, gather results, access and organize results in a spreadsheet, which is saved inside of your OneDrive account.
- [Instructor] Hello, and welcome to Teacher Tech Tips. I'm Oliver Schinkten, and this week I want to introduce a great way for you to create surveys. I'm a huge believer in the importance of feedback, and not only the feedback you provide for students, but feedback from your students to improve you, or feedback from co-workers, parents, or community members. Over the years I've used a lot of different tools to create and track surveys in order to gain feedback and improve my teaching. Today I want to introduce one of my favorite tools, and that is the survey feature inside of Microsoft OneDrive.
Now if you haven't already signed up for a free Microsoft OneDrive account, I highly suggest doing so. You can find this at onedrive.live.com. From here you can click Sign up for free, and sign in with your Microsoft account, and if you don't already have an account, it's really easy to create one. Now OneDrive is a cloud-based storage tool, which allows you to store, organize, access, and share your resources. It's a powerful tool that gives you free storage space, and integrates well with the Microsoft apps.
Also, as an educator or student, you're likely eligible for a free Office 365 account, and once you sign up you'll have one terabyte of storage in your OneDrive account, which is a ton of storage. You can get to this site by navigating to the following URL. Once on this page, if you click inside the box, you can enter in your school email address, and once you have that in there, click Get started. From here, they'll ask whether you're a student or a teacher. In this case, I'm a teacher.
And if it recognizes the institution as a qualified institution, you're ready to go. It says, "Great, go check your email." You'll receive an email in which you can verify your account, sign up for a free Office 365 account, and you have one terabyte of storage in your OneDrive. Now if you'd like to learn more about OneDrive, I suggest checking out the course Up and Running with OneDrive by Garrick Chow. For this video however, I want to show you a really cool and easy to use tool which is inside of OneDrive.
So right now I'm inside of my free OneDrive account, and at the top I have the ability to create a new resource, or upload an existing one. In this case, I'm going to click on New, and I can create a new folder, a Word document, Excel workbook, and more. I want to go down though, to Excel survey, and I'm going to select that. Now once I do that, it'll bring up a popup box that allows me to start creating the survey. Here I first can enter a title for the survey, and this is going to be a Communication Assessment Survey.
We have a communication assessment coming up on Friday, and I want to get some feedback from the students. Next, it says Enter a description for your survey here. In this case I don't have a description, so I'm simply going to get rid of that text. Now below that I can click in the next box to start creating my first question. When I do this, it will bring up another box that allows me to enter in the specific information for that question. Now if you want to know who the student is that answered each question, I suggest creating a question that asks for their name.
So I'm going to create one that says Last Name, going to make that Required, and for the response type, I'm going to keep it as Text. You'll notice I can have Paragraph Text, Number, Date, Time, Yes/No, or Choice. Here I just want that to be text, and I'll click Done. Now I can add a new question by clicking the Add New Question button at the bottom, and then this allows me to add my next question, and here I'm going to type in First Name.
Now that I have those two, I'm ready to add my first question. I'll click Add Question, and I want to type in here and ask students how confident they are about the upcoming assessment. Once I have that question typed in there, I'm going to go down to response type, and I don't want this one to be text, I actually want this one to be a choice. So I'll click Choice, and as you can see, it brings up another box allowing me to enter in what the choices are. Each new choice is represented by another line inside the box.
So here for Choice A, I'm going to enter in Very Confident, I'll click Enter. On the second line I'm going to put Not Sure, and for C, I'll type in Not Confident. Now I want this one Required, I'll click Done. Then I can go ahead and add my next question. Once I have this question in, you can see that is says, "Have you used your study guide "to prepare for the Assessment?" For the Response Type here, I want this to be Yes/No.
I'll click that, make it Required, and click Done. I'll add my final question. And this one asks, "How many hours have you spent "preparing for the assessment?" Now for this question, I could type in the response type as text, and here students then could type in their answer, whether they used numbers or letters, however I want it to be numbers so that I can easily sort it, rather than have some students spell things out like T-H-R-E-E. So I'm going to click on Number, and make this Required.
And for the format of the number, I want it to be a fixed decimal. I can also choose from Percent or Currency, but I want a fixed decimal, and I'm going to choose zero decimal points. So here students can just enter a simple number, like one, two, three, four, and so on. There's no default answer, and I'm clicking Done. Now I'm completed with my survey, so if I want to take a look at the survey, I can do so by entering Save and View, and this is what the survey will look like to the students.
I think it looks pretty sharp. This is a nice-looking survey that's very straightforward and easy to answer. When students are finished answering it, they can click on Submit. Now at the bottom, we have the option to share the survey. I'm going to click Share Survey. And from here, it says that anyone with this link will be able to submit answers without signing in. They won't be able to see the results, however. So I'll click on Create Link, and it gives me the link to this survey. Now I'm going to select that, I'll copy it, and then I'm going to going to the top and open up a new tab, and I'll paste in that link.
As you can see, when I do, it's going to bring up that survey. Here I'll go ahead and answer it. So I'll type in my last name, first name. The one that I gave students a choice for, they have a drop-down menu, so I can click there, select Very Confident. I'll say yes, I did use my study guide, and for the number of hours, I'm going to type in 4. Now when I'm done, I'll click Submit, and it says, "Thanks, your response was received." Now my favorite part about this is that once you create a survey, inside of your OneDrive account, you'll have a Microsoft Excel spreadsheet that is kept, that gives you feedback on all of the replies.
So as you can see, at the top in blue, it gives all of the questions that I asked in the survey. Last name, first name, how confident the students are, and now you can see that my answers appear here, because I did go in and answer it. So it says my last name and first name, how confident I was, and so on. So this is a great feature for you to be able to go and track it. Now if I'm inside of this worksheet, be careful, because at the top, you don't want to click Share up here to share the survey. This will actually share the results, which I don't think you want to share with students in most cases.
You might have situations where you do want to share that with them. However if you just want to share the survey with students, you can click here on Survey, View Survey, and again, share it. Otherwise, you even have the link here directly to click on Share Survey, and it will give you that URL that you can then share with your students to have them access that. Now, I want to go back to my OneDrive account, and real quickly just show you another survey that I created, and this is one that I didn't ask for students' names, so it was one that was anonymous, however, and just to show you how inside of here it shows the four different questions, and then below, I have all of these different answers.
So this is a very quick and easy way to create a survey and gather feedback from your students. I hope this video was successful in introducing you to the survey tool inside of Microsoft OneDrive, and empowered you to use it to gain important feedback from students, co-workers, parents, the community, or anyone else. Embrace the power of feedback in helping you improve your instruction. And as always, if you have any questions, or if you'd like to share a technology tool that's helped you, feel free to contact me at firstname.lastname@example.org, or connect with me on Twitter, where my handle is @schink10.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.