eQuizPro V2 Manual
Installation & Setup:
Directory Setup
1) Unzip the zipped file to your web server root directory or desired directory. (Ex. C:\inetpub\wwwroot\)
2) The unzipped directory is a subdirectory called \eQuizPro. (Ex. C:\inetpub\wwwroot\eQuizProV2)
3) The database file is located in subdirectory called \eQuizProV2\xdatabase. Grant FULL
CONTROL system permission for the SYSTEM account to this directory
if the server is an MS Windows NT/2000 server. Open Windows Explorer and select
the xdatabase directory. Right-click on it and select PROPERTIES,
then select the SECURITY tab. Once the popup window is open, click
on the tab called SECURITY. Then click on PERMISSIONS button.
Remove EVERYONE group if selected and add SYSTEM, Administrators,
Domain Admins with Type Of Access set to FULL CONTROL, and
the groups of people you want to have full access to this directory, the eQuizAdmin
group which you must create, with Type Of Access set to CHANGE.
No need to assign permission if using Personal Web Server.
4) You do have the option of moving the /xdatabase subdirectory to a more
secure parent directory. This would require two main files to be setup in
eQuizPro to point the database connection to this new directory location.
5) OR you have the option of setting up an ODBC connection
to the database, by going to the control
panel and clicking on ODBC 32 icon
to launch the ODBC manager program.
Read the help file on how to setup on ODBC connection. Once the ODBC connection
is created, the program will use the DSN=eQuizProV2
(or whichever DSN you chose) to connect to the database.
6) Two files currently connect to the database, and these files must be configured to point to the correct database. Example connections are given within these files. The files are:
1. /eQuizProV2/Config.asp
Below are examples of database connections strings:
'Modify the path of the MS Access database to the
location it will be in located on ‘your server. Allow SYSTEM write permissions
to that directory.
‘Default directory is /xdatabase
‘FOR DSN-less Connection
dblocation =
Server.MapPath("/cgi-bin/eQuizPro/xdatabase/ eQuizPro.mdb")
eQuizPro_ConnectionString = "DBQ="&
dblocation &";Driver={Microsoft Access Driver (*.mdb)};"
‘FOR MS SQL Server Connection
eQuizPro_ConnectionString = "driver={SQL
Server};server=CATNET;uid=eQuizPro_User;pwd=*******;database=eQuizProSQL"
'## MS SQL 7
‘FOR DSN Connection
eQuizPro_ConnectionString =
"DSN=eQuizProV2" '' ’## ODBC
MS SQL Server Setup
(NOTE: It is highly recommended that you have
fairly good knowledge of administrating SQL server)
In the /eQuizProV2/xSQLScripts directory you will
find a file called eQuizProV2-Database.sql. This file when executed
in MS SQL server will create the database needed to run. To run this SQL script
file, type isqlw.exe at the command prompt on your SQL server. Once
the isqlw.exe window appears, login to your SQL server as administrator and
under the FILE prop down menu in isqlw.exe, click OPEN
and select the eQuizProV2-Database.sql. Once you can see the file SQL
code on your screen, press F5 to execute it. Once finished executing,
you can check to see resulting eQuizProV2 database by using MS SQL
Enterprise Manager or Visual Studio V6 or higher. This statement
creates the eQuizProV2 Database. Once you’re finished executing this SQL Script
you must execute eQuizProV2-Tables.sql file. It will create the tables
to populate this database. Before running eQuizProV2-Tables.sql, refresh
your isql.exe/isqlw.exe connection and select the newly created eQuizProV2
database. Once selected, run eQuizProV2-Tables.sql script.
NOTE: If you wish to run Snitz Forum off SQL server,
please notice that there are certain tables in the MS Access database that
contain programmatic information that is needed by Snitz Forum to run properly.
This data must be copied over to respective SQL server tables. To do this,
open MS SQL Import And Export Data
Manager program and transfer ALL the data in the MS Access table
to the empty MS SQL tables. Select APPEND in Import and Export Data
Manager per table and do not select DROP TABLE option.
1) Once these files point to the database, then you must
configure you email options. Currently the configuration is only done by
logining onto the Administration site as an administrator and modifying the
Configuration Control Keys:
2) Then modify the control keys of relevance, like
EmailServerType, EmailServer, and EmailFrom.
3) For EmailServerType
you have the option of selecting JMAIL,
ASPMAIL, or CDONTS. If you are installing eQuizPro on your NT/2000 box with
IIS and SMTP server configured properly, I recommend using CDONTS which needs
no purchase of an extra asp component like JMAIL or ASPMAIL. These ASP
components can be found @ www.Aspin.com
. Most ASP web-hosting providers usually
have one of these components pre-installed on their servers. A trial version of
ASPMAIL is included under /eQuizPro/xemailserver.
4) Set EmailServer to
point to your SMTP server location.
5) Set EmailFrom
to your, administrators, or servers email address.
6) If you do not
want to use the email option then leave these fields blank.
7) There is also another Control Key called DisplayStudentResults.
By setting this to TRUE, the students can long into eQuizPro V2 and view
their quiz results, but not all administrators will like to do this, so just
set it to FALSE.
Header and Footer Setup
You can modify the Header and Footer with any HTML editor
or even NotePad. There are two sets of Header and Footer files. One set is
located in the /eQuizProV2/xadmin directory and are called Header.asp
and Footer.asp. This set should be modified to represent the
administrators area. The other set is located in /eQuizProV2/. This set
should represent the student area.
By modifying these sets of Header and Footer files, you
can customize the look of eQuizProV2 to match the rest of your website. To
further modify the look and colors of eQuizProV2, you will need Macromedia
Dreamweaver to visually edit the HTML in the eQuizProV2 ASP files without
unintentionally modifying the ASP code. I only recommend you advanced
modifications with Macromedia Dreamweaver, NotePad, or MS Visual InterDev. I
recommend no other editors unless you know they will not modify ASP source code
while all you what to modify is HTML source code.
Administrators Directory Security Setup
Currently security for the /eQuizPro/xadmin/ and /eQuizPro/xdatabase/ directories must be setup using Microsoft Management Console for IIS. This setup will allow you to great a quiz administrators group on your NT domain controller server and assign administrators to that group. Here is the procedure:
1) Open you User
Manager administration program on you NT server and create a user group
called eQuizAdmin. It does not have
to be called this.
2)
Assign administrators to this group. Yourself included.
3)
Open Windows Explorer, and find the eQuizProV2
subdirectory xadmin.
4)
Right-click on it, then select Properties.
5)
(NOTE: The following directory security
setup is just to add additional security to eQuizPro V2, because eQuizPro V2
already has security login screens) Then click on the tab called SECURITY.
Then click on PERMISSIONS button. Remove EVERYONE group if
selected and add SYSTEM, Administrators, Domain Admins with Type
Of Access set to FULL CONTROL, and the groups of people you want to
have full access to this directory, the eQuizAdmin group, with Type Of
Access set to CHANGE.
3) Open Microsoft
Management Console (MMC) for IIS and look for the directory /eQuizPro/xadmin
under the root directory. Right-click
on this directory and select Properties.
4) Once admin window is open, click on Directory Security tab.
5) Then click on Edit button under Anonymous Access And Authentication
Control.
6) Deselect Allow Anonymous Access and select Basic Authentication and Windows
NT Challenge/Response.
7) Click on Edit
button under Basic Authentication.
8) Once the window is opened, in the field named Domain Name type yourdomainname\eQuizAdmin.
9) Click OK
and exit. And that’s it. If you did this procedure on a domain backup server,
you might have to wait for it to synchronize with the domain controller server
(primary domain server).
10) Next time you go to, for example, http://<yourdoaminname>/eQuizPro/xAdmin
as NT login popup will show up. To login all you do is type your NT login and
password.
11)
You can also setup SSL for more security if you desire for
xadmin directory, which is currently
beyond the scope of this documentation.
12)
Also it is recommended that the web server eQuizProV2 web
application session timeout time be changed to accommodate the length of the
quizzes. Take into consideration the possible worst case quiz duration. To do
this, Open Microsoft Management Console
(MMC) for IIS and look for the directory
/eQuizPro under the root
directory. Right-click on this
directory and select Properties. Under where it says Application Settings, click the CREATE button. Then type
the application name “eQuizProV2”. Then click the CONFIGURATION button. Once
the popup window is open, click on the App Options tab and add a
check mark to ENABLE SESSION
STATE. The type in the minutes you
believe will be sufficient to navigate and done a single quiz on eQuizPro V2
into the SESSION TIMEOUT field. I would recommend 120 minutes. Then
click APPLY and OK.
If your intentions are to use this program with a web
hosting service provider, email the administrators to setup this security for xadmin directory. If they don’t agree
to do this, then consider switching service provider to http://www.readyhosting.com (perhaps the
best on the market for all the figures and inexpensive).
Documentation
1) First off, the administrator must
login into the Administration section of eQuizPro V2 using the default Login Admin
Admin with password tech33.
2) Once logged in, you must start configuring eQuizPro V2
to meet your needs. It is recommended you start by adding courses. To start
this just click on the Add/Modify/Delete Courses link:
3) Once in the addition of new courses is self
explanatory. Type in the name of the course and the description and click SUBMIT
button.
4) To MODIFY or DELETE a course just click
the links along side the Course listing and follow the instructions.
5) Next step is to add classes to your newly created
courses. Go back to the Admin Menu and click on the Add/Modify/Delete
Classes link.
6) Once in, the setup is again very simple, just select
the course you want to add classes to and press SELECT button. Once into
the next screen, type in the name and description of the new and click SUBMIT
button to add a new class to the course selected.
The next screen:
8) To modify or delete a class, just click on
the MODIFY or DELETE links along side the class listed and follow
the instructions.
9) Once you added your classes, I recommend
adding students. Click on Add/Modify/Delete Students to add students
yourself.
10) Once in,
To add a
student, select ADD in the function drop down and then type in the
required student information and click SUBMIT.
To display current student information select UPDATE in the function drop down and then select student you wish to see information for and click SUBMIT. Once the information is up you can change it and press SUBMIT again.
To add new student/employee select ADD in the Function drop down, type first name and last name, select course/department and enter their LOGIN PASSWORD. The LOGIN will be their "FIRSTNAME" (space) "LASTNAME" without the quotes.
NOTE: When adding or updating Students, changes to database will not be displayed automatically if the database is an MS Access file. In this case, exit Student admin area and reenter it to see changes. If using SQL server, changes will be displayed immediately.
11) The next logical step, if you desire to
take the FULL benefit of eQuizPro V2, is to categorize your potential quiz
questions. This stage can also (actually should be) be done prior to writing in
your quiz. By selecting Add/Delete Question Major Category link, you go
into the area to administer the question major categories. In case your still
confused about question categories, let me explain. By categorizing your quiz
questions with a Major Category and a Minor Category, eQuizPro V2 can run a
report showing you your class’ problem areas based on category. Quizzes can
have hundreds of questions, with only a few different material categories
actually being covered. For example, you write a quiz on operating systems with 50 questions. Of the
50 questions, 10 cover MS DOS, 10 cover MS Windows Me, 15 cover MS Windows 2000
Server, 10 cover Linux, and 5 cover MAC OS. So how would you know which one of
these categories your class is having more problems with without time consuming
comparison between quizzes. eQuizPro can tell you by the click of a button. Of
course, you can be as specific or as general as you wish with these categories.
The question category system is common to all classes, so you can build a standardized
and useful category system that will not need to be entered every time a quiz
is entered for other classes.
12) To administrate the question minor
categories you would click on Add/Delete Question Minor Categories link
from the Admin Menu. To add a new Minor Category is very similar as
adding a new Major Category. First you select the Major Category and then type
in the name of the Minor Category and SUBMIT. To modify or delete, just
click the MODIFY or DELETE link a long side the minor category of
your choice.
13) Now we move onto adding quizzes to a
class. Click on Add/Delete Quizzes link. This will take you to a screen
where you select to add a quiz or delete a quiz. To delete a quiz, just select
the quiz to delete and click the DELETE button.
14) When adding a quiz, you will see this
screen:
Just fill in the information and click NEXT
button. But before you start, it is HIGHLY recommended
that you have a personal rough copy of the quiz on paper, completed, prior to
entering it into eQuizPro V2. Also, it is HIGHLY recommended that if your
categorizing your questions that you do so in the question category
administration section prior to the start of entering your quiz. These recommendations will assure you a smooth quiz creation.
16) In the next screens, all you do is enter
your question, select a category, enter all your potential answers, of which
you can enter ONLY 5, and select the correct answer. Once that is done, you
click the NEXT button.
This screen will continue until all the
specified number of questions is reached. Once the quiz is finished being
entered, it is automatically live for students to do. If you do not finish
entering the quiz for whatever reason, don’t worry it will not be published
live partially complete. The only problem with this is the database gets
filled with garbage.
15) Finally, there are the reports. You can
from viewing the quiz results per student, per class, and per course. Also you
can view the question category report per class.
Overall Course Results:
Overall Class/Student Results:
Correct Student Quiz:
Question Category Report Based On Class:
Student Instructions
Students, have it easy. All they do is Login, select one of their potentially many courses, select the class of their choosing within that course and then select the quiz to take. And if they have the option, they can also view their quiz results. That’s it.
NOTE 1: When a students registers themselves on
eQuizPro V2, they are not enrolled into an course until the administrator
enrolls them. Attempting to Login after they just registered will give them a
message that they must email the administrator whose email address is the email
under the Control Key “EmailFrom”.
Note 2: When a students register themselves onto
eQuizPro V2, their login is the First & Last Name with a space in-between
and the password of their choosing.
Snitz Forum Integration
To link the included FREE
Snitz Forum to the eQuizPro V2 database, you must change the connection string
the config.asp file in the Snitz Forum directory to link with eQuizPro V2
database DSN connection (ex. “DSN=eQuizProV2”). For more information on how
to do this goto http://forum.snitz.com/
.
The Administrators Default Login Is:
NOTE: Students
added by administrator or registered on eQuizPro V2 can login to Snitz Forum
with the same login and password as used on eQuizPro V2. If the a forum member registers
on Snitz Forum, his first and last name and password are required to login to
eQuizPro V2.
TechSupport
If you require help or information, or you would like to
report and error with the program, then email me @ Admin@Gigaframe.com.