Available to use

[Nickooo87]

Hello,

Im trying to create a quiz system that allows users to log in and take
a quiz. However there are two users of the system, lecturers and
students. What I need help with is I want to make a page on my slide
to allow a lecturer to make content avaiable. For instance

If the lecturer logs in they are taken to a page with two buttons on
it saying log out or make slides avaiable.

Then if a student logs in, depending if the presentation is avaiable
they are taken to the quiz, if it is not avaiable a message pops up
and telling them it is unvaiable and they are taken to the login
screen.

Im thinking that i need some sort of button to update a textbox with a
value and if that textbox has the value in then it can be made
available but im ensure on how to do this?

Can anybody help with this? sorry the above is a bit confusing.

Thanks

Nick

 

[David Marcovitz]

This can be done in a number of ways. The simplest thing is to use an
InputBox:

myPassword = InputBox("Type the instructor password.")
If myPassword = "LetMeIn" Then
<do something here such as GotoSlide 7>
Else
<do something else such as MsgBox "Wrong password">
End If

Now, the question is what do you do in the "do somethings" above. You will
need to keep track of what the instructor has done so you'll need to have
the instructor presentation keep track of something. This is really easy if
the presentation is running continuously (just use a variable Dim
quizAvailable As Boolean), but if the presentation is going to be shut down,
you'll have to do something else. If you want to store the information in
the presentation, you'll have to save the presentation
(ActivePresenation.Save). You could do this by hiding and showing buttons.
One button takes you to the quiz, the other pops up a MsgBox saying the quiz
is unavailable. If the instructor makes the quiz available hide one button
and show the other and save. You could do this with a tag and then you would
use an If statement to check the tag. Were you the one working with external
databases? If so, you could store the information about the availability of
the quiz in the external database. Lots of options.

--David

Hello,

Im trying to create a quiz system that allows users to log in and take
a quiz. However there are two users of the system, lecturers and
students. What I need help with is I want to make a page on my slide
to allow a lecturer to make content avaiable. For instance

If the lecturer logs in they are taken to a page with two buttons on
it saying log out or make slides avaiable.

Then if a student logs in, depending if the presentation is avaiable
they are taken to the quiz, if it is not avaiable a message pops up
and telling them it is unvaiable and they are taken to the login
screen.

Im thinking that i need some sort of button to update a textbox with a
value and if that textbox has the value in then it can be made
available but im ensure on how to do this?

Can anybody help with this? sorry the above is a bit confusing.

Thanks

Nick

--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland

 

[Nickooo87]

What exactly do you mean by "logs in"?  Opens the PPT file over a
network?  From a web site?  Something else entirely?

How will the system know the difference between a lecturer and a
student?

One possibly simpler approach:

Lecturer uploads a "dummy" presentation as a placeholder for each
presentation the students will eventually have access to.  This is
nothing more than a slide that says "Not available yet.  Come back
later."

When the content's available, the lecturer uploads it, under the same
name as the file above.

No need for macros or any other confusion.  

==============================
PPT Frequently Asked Questionshttp://www.pptfaq.com/

PPTools add-ins for PowerPointhttp://www.pptools.com/

I am making a quiz in powerpoint, students basically write in there
student number at the start and the student number and quiz results
are saved to my access database. The lecturer however at the same
login screen has to enter a password as well as there lecturer
number!

What i want to beable to do is when the lecturer logs in, go to a page
where they can make the content avaiable to students, where as if the
student logged in and tried to access the data before a lecture it
will be locked unless the lecturer makes it available

 

[Nickooo87]

So you said earlier.  Then I asked a few follow up questions which you
haven't answered.  I'm sorry, but I can't offer much help until you do.

==============================
PPT Frequently Asked Questionshttp://www.pptfaq.com/

PPTools add-ins for PowerPointhttp://www.pptools.com/

Sorry Steve i didnt realise i hadnt answered your questions!

What exactly do you mean by "logs in"? Opens the PPT file over a
network? From a web site? Something else entirely?

By logs in i mean that i have a form that has two text boxes on it for
username and password, for a student they just enter there student
number and that get stored along side there quiz answers in an access
database. When the system sees that only the one text box is filled in
it goes to a certain page, mainly for the student the presentation
unavaiable page or the first slide of the presentation if it is
available

For a lecturer I have defined a password with my vba in powerpoint
that will take the lecturer to a different slide from the student
where they are able to click a button to say the presentation is
available for viewing of a student!

How will the system know the difference between a lecturer and a
student?

This is something i am struggling with, i need the student and the
lecturer to have different access to the presentation, so the lecturer
can only make it available, and no student can get into the
presentation unless the lecturer has made it available! Another page
will have a button for the lecturer to click if they want to show the
results of the quiz in a percentage form. However Im not sure if
something like this is possible inside of 1 presentation as i would
have to essentially have the presentation look to see who is on the
page and if it is a student then limited access, however if it is a
lecturer full access!

Sorry I wasnt clear earlier, any help you can offer i would much
appreciate

thanks for replying

Nick

 

[Nickooo87]

Hold up there.  Again:  Over a network?  Is this an application, a web form,
or what?  What you're doing is obvious to you but you're sitting in front of
the screen and I can't see through ya!  ;-)










==============================
PPT Frequently Asked Questionshttp://www.pptfaq.com/

PPTools add-ins for PowerPointhttp://www.pptools.com/

haha It is just a macro enabled presentation that is linked to an
access database, just a normal presentation at the moment, i do intend
to put it across a network with the presentation client side and the
access database server side! At the moment im building the prototype
and if it all works well then i will be purchasing some server space
to put it onto!

 

[Nickooo87]

I dunno ... it sounds like you're making this WAY more complicated than it
needs to be, but maybe I'm missing some of the details you've got in mind..  

==============================
PPT Frequently Asked Questionshttp://www.pptfaq.com/

PPTools add-ins for PowerPointhttp://www.pptools.com/

I think i have made it sound more complicated than it is becuase its
really confusing reading what ive wrote!

What im looking to do is store a value in powerpoint set at zero for
instance, then a certain slide will read that value and if it is still
at 0 then pop up a message to say presentation is not available and
close. Then i need to have another page on with a button that will
overwrite that value to a 1. Then from that the page from before will
read that it is a 1 so the presentation is available so it carrys on
with the presentation.

eg If available.text=0 then msgbox'not available' exit
else if available.text= 1 then
activepresentation.slideshow.view.slide (5).

then for button page

sub available_click

available.text='1'

end sub

Something along those lines? thats what im working with at the moment!

Another question I would like to ask, Is it possible to deny access to
one slide in a presentation or possibley hide a slide?

Thanks for your help and replying

Nick