Hi there, welcome to this PowerPoint quiz training course. Now last time, if you've been following along
we looked at how to take a quiz, or take PowerPoint make a quiz out of it, and put the quiz online. Now
I did promise you that this week that we would look at how to get results from your
users - you know answers to their questions , the questions that they answered, we
want to basically recover their results. That's right we want to take their results, allow
them to interact and get the results in an Excel spreadsheet. So how do we do that with
Microsoft PowerPoint? And what's more how do we do that online? So this Computer Tutoring.
All right so hopefully I'm recording the screen, now you see my PowerPoint
presentation in front of me. What I need to do is I need to add in these questions. Now if you remember
before that we did a series of buttons that we had the CHOW CHOW this one here, in fact if I just go
here I've got the latest tests, If I remember that's the one there, nope it's not that
one, let me just close that one down. Which one was it then? For the love of animals was it this
one here? That's the baby! And we went here when we played this one you decided on whether it's
a Great Dane and it was wrong you know that type of thing, so it was is this is real or
fake? You had different options there so I think you remember that one there, if I clicked on
Chow Chow it came up correct and went to the next one. So the trouble with this one is it's great for
a bit of fun- but if you want to start to get users results, you actually want to test them, maybe
not on whether animals are real or fake or not but maybe on something
a little bit more important, then this is how you do it. Okay so firstly let's close
down that quiz. We're gonna go to this breed what breed of
dog is this? So we know this is a Chow Chow okay now instead of getting users to just
click on a button we're going to use Microsoft Forms, that's right we're going to use
Microsoft Forms put a form into this PowerPoint presentation and then with that will enable users
to select the right answer. Let's get started. So what we'll do for Microsoft Forms is we're going
to make sure we're going to go to Insert, now just one quick thing just if you want to carry on with
this please make sure you've got Office 365 and Office 2019 so this is PowerPoint 2019. If you're in
any doubt of that if it looks something similar to mine then that's great. if I
click on file there, if I go there and then I go down to accounts
you can quickly see the Office suite here that you've got. Which is
good. So let's go here, and I'm going to insert another slide after this, so I'm just going
to click on home. I'm not sure why I'm zooming in, I'm gonna try and zoom in actually by
using the just another feature which is a way of doing it but it makes it a bit more smoother
in post-production. So I'm gonna click on home, I'm gonna click on new slides just here, and I'm going to choose
blank slide and there we go I've got a blank slide, after the Chow Chow after the dog. So now I can put
my quiz in. So here I'm going to go to Insert and then I'm going to go over to Form so you
can see this form section just here, give that a form section a click -
you clicked it? Good. Alright so let's click on that and over on the right hand side here I can see a
list of my forms that will appear. Let's just load them up, there we go. So over
here on the right hand side you can see the forms. I've mucked around with a few of these ones beforehand
but you can see 'for the love of animals' is there quite a few times. In a future video
I'll look at how to take all of these forms which will be separate in this
tutorial and then bring it all together. Doing this there's an easy way and there is a hard way.
So we're going to do the easy way basically. So it's getting all of the information, putting it
together in one form, and then collecting the data from one form. And then we do it the harder way - where
we can do basically forms after each slide, so after Chow Chow here I can do a form after that,
and then after real or fake I can do a form, so in that way it's a little bit
more difficult to callate those results together but I'll show you how you can do it a bit fiddly
but I'll show you how you can do it in a future tutorial so make sure you subscribe. Okay of course
if you're asking questions it really helps if you're a subscriber doesn't it
because then you don't miss anything. Alright now let's carry on with this.
So I'm gonna do a new quiz. Make sure we click on new quiz just here, so you're gonna click on
new quiz so let's click on a new quiz. Here we got our quiz, it's actually opening up our
browser and now going into Microsoft Forms as you can see here with this cyan type of view, so now
I'm in Microsoft Forms. So let's carry on shall we? So let's just call this....I'm gonna
call this form 'the craziest animals' okay, and then just enter a description, 'here is a little old
quiz about crazy animals' yeah okay alright then so now I'm going to add a question, so if I click
on the add new button to add a new question in, this is going to be a choice question and I goes
What breed of dog is this? Okay now I need to get a picture now if you look at the button just over
here on the right hand side give it a click and then it will go into your media section over here
on the very right hand side I'm gonna click on 'Image' just here,
I'm gonna go to my onedrive just find my folder for leisure
and then scroll all the way down and find my quizzes and inside my quizzes, I have my dog, and that
should be there, it is. There's the Chow Chow click on add and then that will add the Chow Chow
dog here, that's great. I can edit this a little bit decide maybe to zoom in.
let's just move that a little bit, that's great. Brilliant okay and then I'm gonna do this one
here I'll put some options let's put Terrier let's put Newfoundland, lets add
another option, put in Alsatian and then let's put the the right option here Chow Chow. Hope they're
all spelt right. So you see you've got these little ticks just here on the right hand side here that
will allow you to choose this the right answer. Because
Chow Chow is correct and let us click on that tick that's great that's the only one we need to do, we
might need to put some comments in if we need to, but there's no real need to do that.
At the bottom here we need to decide on how many points the person gets for this question, so
I'm gonna click on one point just here and it's not required so that's great I can go on to the
next question, and I go on so this one's gonna be a choice 'is this creature real or fake?' okay
let's choose the creature by going to my image of my onedrive and let's choose my
little owly weirdy Terrier type creature, that we can see, just gonna edit that a bit and zoom
in just a little touch there and there we go, maybe back just a tad there we go.
Perfect okay so now I can go 'real' or 'fake 'okay and then if 'fake' the right answer I can even add
a little comment just in here. You see that so if I just click on that little commentary here I can
then type in 'you've guessed correctly this animal does not exist' there we go. If you said it was real
'what type of creature do you think this is, what would you call it?'
There we go, so that's the correct answer and then you would go on and on and on
doing that. One good thing as well you can add with the quiz, maybe if you want to
get a person's name. You can add that in the form of a question. So if I just 'add new' this
is going to be text, just type in 'please enter your full name' there we go that's good, and then
that's a long answer that's required, there's no points for that, so I can just get
rid of the points for that. That's great but I'll use these buttons just here particularly this one
just here so that I can move that up to the top. So here we go, so this is called
'the craziest animals'. Full name is this one here, and then I've got the Chow Chow,
that's worth one point, and then this one here, and that's worth one point and there we
go. That's great. So there we have our quiz. So that's actually opened up on the browser, so let's
swap back to PowerPoint and then we'll see in PowerPoint how this is affected. So what we're
going to do is firstly go back to PowerPoint just gonna click on the bottom , now I
can actually see this, it's quite common 'something went wrong' so I don't want you to panic.
I will say that this does happen a lot when you're working with Microsoft Forms
in applications, so don't panic we'll have a quick look at how we can do this. So the first
thing we need to do is go back to the forms and allow it that anybody can access this form, not
just people within our organization. So if we swap back to our browser here and then
I'm gonna click on this little ellipsis button top right hand corner, I'm gonna go down to
settings and click on settings, and then where it says 'anyone with the link can respond' that's what
we're going to click on. Okay so anyone with the link can
respond, make sure that's selected that's great I can click away to get rid of that menu that's fine.
Swap back to PowerPoint and then we're gonna click on this tiny little button just
top right hand corner, so if we go there and click on that button top right corner and go down to and
choose reload. So we're gonna reload the form and now our form should be available in PowerPoint.
Great remember that thumbs up button if you got something out of this. If you knew this
already fine that's right you can fast-forward to the nitty-gritty. Great so now we can go through
this. This is really cool I mean say for instance, as I'm going through here, I thought
I inserted it on this one, maybe I was on the wrong slide here that's fine, I
could just delete that. So now I'm on here I can just click on Shift & F5 on the keyboard
remember Shift & F5 on the keyboard starts the presentation from the current slide, just like
you're clicking the button in the right hand corner. So 'what breed
of dog is this?' I can now click and it now takes me to Microsoft forms where I can enter my answer. I
can enter my user name here and type in Simon and then I can say what breed of dog is this and I can
choose my Chow Chow. That's good and I can go to the next slide and then you know go on from that one.
So if I keep going on and yet you can sort of see just different ones there - where's my real or fake?
Can't see my little 'real or fake' let me just undo a couple of times.
There we go I think I inserted it on the wrong one so let's just try that one again if I go up here
there's the 'craziest animals' let me just insert that form here that's better, so that's good. Now
as you can see it's probably best if I put that form after these two, so when I go through the
presentation so for instance if I just F5 go through that presentation I click what breed
of dog is this, real or fake, so I'm going through that and now I go to the form so I can then answer
those questions. So I can type my name and then mention that's a Chow Chow there and
I believe that's fake, click on submit and then the answers will be submitted. Great excellent - so just
while you're on this form, it takes a little while to submit I will have admit but you
can then review the results and see if you've got them right, yes
you guessed correctly that's great. So I can then go to next slide and now on this one and I can go and
I can add another form in there. Okay brilliant so just one quick thing with this, I will show
you just to get an inkling of how you would get those results on a basic level. So if I come back
out here now, if you haven't already done so you can download Forms online.
I've got my office shortcut there with a little app shortcut where I can go to forms online.
In fact because I was already online I could just click this button here see I can
access my forms, so where I've got 'the craziest animals' I can click on that and then
I can see my responses here, if I wanted to see them I can click on this button that says 'open up
in Excel' so I can click on 'open up in Excel' this will then open it or download it into an Excel
spreadsheet - you can see I've got the craziest animals when I click on 'save' it will download
it into an Excel spreadsheet. And then see if I can just show you that spreadsheet on the screen it's
pretty cool, so it's just loading up now, there we go and then we just drag it to the other
screen so you can see and it's gone into a form of a table here in Excel , there you go Table 1
and you've got this here. Brilliant really good. So there are a couple of downsides to this. Let's just
talk about them because that's what we're going to address next week so make sure you subscribe
so you don't miss out! So let me just close that one down. Say for instance I run my
Microsoft PowerPoint presentation again and let's say we do it online, yeah there's normally a little
bit of problems when we do this online, so let's just take a plunge shall we? So I'm just going to
click on 'slideshow' just here at the top and then 'present online' just over here. Okay I'm going to go
to make sure they can download the presentation just in case there's any issues at all, and I'm
going to click on connect, and it will present this online, push it to its PowerPoint online servers
wherever they happen to be, and I will be able to present this remotely and then we'll have a look
and see what the users are seeing remotely. I've done this already on a previous video so if you
haven't really done so please have a look at that I'll make sure on the links available. Great there
we go this link shared brilliant or I can just click on 'copy link' here so I'm gonna click on copy
link I'm gonna go back to my browser and I am just going to paste and that's it and pretend
I am a delegate I am somebody, a user somebody who's experiencing the quiz. As you can see it's
saying I'm waiting for the presentation to begin so let's make sure we begin it. Just going to swap
back to PowerPoint, I'm just gonna click on 'start presentation' and then what I would do is
I'm going to swap and pretend to be a user okay? So let's pretend to be a user so just ALT & TAB
to swap back to the browser and I'm gonna click on the buttons to go next I'm not
following the presenter I can go next and I can see 'real or fake' when I go next, you see what happens
it takes me to the actual quiz and what I can do is I can actually enter my name in here, that's good.
Here we go, let's say I'm Simon the second. There you go I can say this
is a Chow Chow, and I can go down and I say I'm gonna pretend to get this wrong and say 'real'
submit. So now I'm interacting with this as the presenter he or she is going on doing
their own thing now I'm interacting with this, I can still view the results if I'm right and see
if I'm wrong I can see oh I've got this one wrong and we'll just zoom back a tiny bit so you can see
yeah there we go. Brilliant excellent and then I can go through this here. Great so the downside
with this one is you think okay that's fine let's just go and stop that presentation, so I'm
just gonna come out of it and click on the button at the top here that says end online presentation.
That's good let's exit. Now I want to see the results for that form.
If I go back to Microsoft Forms at the top and close that one here and go to Microsoft forms
okay you can see I've got my two responses so I've got this page here which is great I can bring it
together, but when I go to open in Excel like so, okay it opens it up in Excel you see I've
downloaded a separate file, if you look very carefully at the name of the file it says the
craziest animals 1-2 so that means I've got two responses and then when the third one happens or
the fourth or the fifth or whatever, so the idea is is this is great for a form where I want to
get quick results on maybe I'm presenting and pretty much there's 20 people watching
the presentation and I want to get everyone's results together all nice and download it as an
excel file no problem! But say for instance this is a more ongoing quiz or presentation I'm just
putting on a website somewhere or a quiz and putting on a website somewhere and then I want
them to their leisure go and fill in the details you know I'm the way have to wait for ages to keep
downloading files and I might download a file, say my boss says I need updates right now, I download
the file and then somebody else adds a response
or fills out the form, but the problem there is, that makes another excel file. It all downloads
as separate files. So what we'll do next time is show you just a little trick of how to get it all
collated in one so it all populates a file. It's a bit tricky that one is, so if you've tried doing
that, and I've had a look at a few forums as well and I think I've got the answer mmm brilliant! So
just hope you got something out of that!
If you have done please give us a thumbs up if you haven't already
done so please check our live online training so at the moment we do Excel and we do Power BI as
classes but we do PowerPoint as well and many other different programs so please have a look
at computertutoring.co.uk click on Live Online Training and then you'll see all the
different courses that we do. Hope you're ok I hope you're enduring through this time of isolation
hopefully it won't be too long. So just want to say thank you so much for watching and take care guys.