About the Quizzes Tool
The Quizzes tool allows you to create a variety of assessments for your students. While labeled Quizzes, this tool can be used for exams, surveys, self assessments, and/or homework assignments. The Quizzes tool can be used to create the following types of questions: multiple-choice, true/false, arithmetic (including specifying ranges of numbers with significant figures), fill-in-the-blank, multi-select, matching, ordering, and long and short answers. Many of these questions can be graded automatically and then automatically entered into the Grades tool. Quizzes can be released conditionally based on date and time.
NOTE: Editing quiz questions after students have begun taking the Quiz may result in students not being able to complete it if they are caught between old and new Quiz versions. In addition, Quiz statistics will be inaccurate.
Quiz Overview:
There are several steps involved in creating a Quiz for your course. Each step is described in greater detail in the sections that follow.
- While it is also possible to create Quiz questions from within a Quiz, rather than in the Question Library, it is strongly recommended that you create all of your questions in the Question Library and then import them to your Quizzes. This will allow you to reuse questions in multiple Quizzes, self assessments and surveys.
- Use the Question Library to insert questions into a randomizing section. Random sections pull their questions from the Question Library. When creating a Quiz, you can specify a list of questions from which the D2L system will randomly choose questions for each student that takes the Quiz.
- Many of the questions types can be graded automatically and then automatically entered into the Grades tool.
- Quizzes can be released conditionally based on date and time.
Question Library
The Question Library is a central repository for your Quiz questions. When you create questions in the Question Library you can reuse them in any number of Quizzes. Using the Question Library feature helps you to avoid tedious re-entry of questions.
To access the Question Library from the main Quizzes page, click the Question Library icon
. The Question Library page displays.

There are three ways to populate your Question Library with Quiz questions:
Creating and Managing Questions and Sections(Folders) in the Question Library
Overview:
Sections are like file folders in your Question Library. They help you to organize your questions. You might choose to create a "multiple choice" Section that includes all of your multiple choice questions, or a Section containing all questions related to a specific topic such as a book chapter.
Sections are also helpful when you are creating a Quiz. Instead of importing questions one at a time, you can import an entire section of questions into a Quiz at once.
To create a New Section in the Question Library:
1. Select Section from the Create New drop-down list and click GO.
![]()
2. Name the Section.
You have the option of adding: a) a message to your students, b) private comments to your fellow instructors, and c) an image that may be displayed to your students.

Display Options allow you to control showing the section name, inserting a line break after section name, or displaying message and image.

To create a New Question in the Question Library:
If you would like to know how each question type works before choosing a question type please refer to Question Types.
The following options are displayed at the top of the Question Library page after you have created sections or questions:

- Create New - see Creating Quiz Sections / Creating Quiz Questions
- Import - use to import questions from an existing quiz or text file
- Move - (appears when you have added and selected questions/sections)
- Delete - (appears when you have added and selected questions/sections)
- Order - (appears when you have added and selected questions/sections)
- Edit Values - use to quickly edit the points and the difficulty level of questions
- Display Options -used to control what you are seeing on this page
You can mange Quiz sections and questions in the Question Library after you have created or imported them in the Question Library.
To change the position of an item in the Question Library list:
![]()
The Order page displays with your list of questions and sections.

To Move a Question inside another Section:
![]()
The Move Objects page displays with a list of Sections in your Question Library.
To Delete a Question or Section:
![]()
You can edit the appearance of the Question Library using the Display Options link:

The Display Options window displays.

- Text and Icons: show both the text and icons for each link
- Text Only: shows only the text for each link
- Icons Only: shows only the icons for each link
Also, from the main Question Library page, you have the following options:
- Select the View icon located to the right a Question to see how it will appear in a Quiz, how it will be marked, feedback comments, and where this Question is used. You can enter the question-edit area by clicking the Edit button in the lower right corner of the screen.
- Click the Edit icon located to the right of a Question or click on the Question title to make changes to the Question.
- Click the Edit icon located to the right of a Section to make changes to the Section.
- Click Edit Values to change the points and difficulty values for your Questions. Click Save to update your changes.
![]()


Note: The Difficulty level feature allows instructors to visually organize and compare questions. For example, after assigning a specific Difficulty value to a number of Questions you can sort and view the Questions by their assigned Difficulty value to ensure consistency. It has no influence on which Questions will be used in a Random Section within the Quiz.
Creating Quiz Sections
You can create Quiz Sections to organize your Questions into folders. This can be done in the Question Library or during the creation of a new Quiz. Both of these areas are identical in functionality, however one creates Sections within the Question Library, while the other creates Sections within a Quiz.
Example Scenario: You want to create a Quiz in which the first five Questions all refer to the same diagram, and you want to repeat the diagram before each Question. To do this you can create a Section that contains the first five Questions, add the image (as in Step 6 below), and set the Display Options for the Section to "Display message and image" and select "repeat section message and image before each question." Note: that this will also repeat any text in the Message field before all of the Questions.
To create a Section, from within an existing Quiz or when creating a new Quiz:



- Check the box beside 'show section name' to have the Section name displayed in Quizzes that contain this Section.
- Check the box beside'iInsert a line break after section name' to insert some extra space below the Section name when displayed in a Quiz.
- Check the box beside 'display message and image' to display text you typed in the Message text box (Step 5 above) and the image you specified in step 7 (above) in your Quiz.
- Select 'display section message and image once' to display these items once at the beginning of the Section, or
- Select 'repeat section message and image before each question' to repeat both the message and image before each Question in the Section.
- Click 'Expand section feedback' to add feedback to the Section. This feature allows you to leave feedback for an entire Section when grading the Quiz.
Creating Quiz Questions
You can create Quiz Questions two ways:
To start creating Quiz Questions, select the applicable question type from the Create New drop-down list and click GO.
Note: It is strongly recommended that you create all your Quiz Questionsfrom within the Question Library. This gives you the ability to reuse questions in various Quizzes and to create random sections within Quizzes. For detailed instructions on each question type see Question Types.
Importing Quiz Questions from a very specific Text File format
Quiz questions can be created offline using Desire2Learn's text format file. The formatting is very specific and if you build the file without first seeing the sample then you will most likely need to adjust your file.
If you have already created your Questions offline using this template, and would like to populate your Questions into the Question Library:



Importing Questions from Respondus or Basic Course Import
Respondus is a software application commonly used to create questions offline. When using this software to import your questions into D2L, the following tips may be useful to you:


Random Question Sets
Overview
Inserting a random section into a quiz ensures that each user will receive a unique set of questions. The random section pulls from a designated pool of questions stored in the Question Library. It is important to note that you can only import questions that have already been created elsewhere into a random section; you cannot create questions within the random section, nor can you move questions into this section.
After selecting the questions from the Question Library, you can specify how many questions from the random question pool each student should see. The random section will then randomly select this number of questions for each student that takes the Quiz. This feature guarantees that each student will receive a unique Quiz with different questions.
There are no limit to the number or type of Questions in a random Quiz, hoever you must create a Quiz before adding a random set of questions. Since random sections can only contain Questions from the Question Library, it is important that you create Questions in the Question Library before creating a Quiz. You can import questions from a Quiz into the Question Library if you first created them in a Quiz. You can then import the Questions into the random section folder of the Quiz.
Creating a Random Section Folder









Note: All Questions in one Random Section must have the same point value. A Question can only exist once in the Quiz so if you have a Question that is in the Quiz and you want it in the Random Section you must first go to the Question Library and import it into the Question Library, then go back to the Quiz and delete the Question. Lastly, go into the Random Section and import it from the Question Library into the Random Section folder.
Properties
The Quiz Properties tab will display by default when you create or edit a Quiz.

- Check Hints to enable question hints. The actual hints must be set up within each question by the instructor.
- Enter your email address in the Notification Email field if you would like to be notified when a participant submits a Quiz. You can use your D2L or an external email address.
- Check Disable Pager Access and Right-Click to prevent users from utilizing these features that can enable cheating while students are taking the quiz.

Restrictions
Use the options located under the Restrictions tab to set up the availability and timing of your Quiz.

Example: You could create a release condition that requires students to view a certain content topic before they can view the Quiz or achieve a certain score on a previous grade item. For more information see Conditional Release.

- Select 'Allow Normal Submissions' to let users submit Quizzes even if the Time Limit and Grace Period have expired. Submissions after the Grace Period will be flagged as late, but still auto graded if this is how you set up the Properties Tab.
- If you select 'Use Late Limit' and select an amount of time, users are given a grade of zero if they submit the Quiz after the Time Limit+ Grace Period + late limit period. You can then go to Grade Quiz, find the student's Attempt, click it and then click Re-Calculate to allow for the Quiz to be graded and the results to be kept.
- Select 'Auto-Submit Attempt' to have the system automatically submit a Quiz after the specified Time Limit and Grace Period have expired. Once all time is expired the next time the student clicks Save it will force the system to submit it automatically and grade the Quiz.
Note: When the 'Auto-Submit Attempt' option is active, the system submits all questions saved before the Time Limit plus the Grace Period, has expired. However, any questions that have not been saved before this Time Limit has expired, even if they have been answered, will be submitted. Participants need to save their answers before the Time Limit expires.
Special Access
Use the Advanced Availability feature to override the availability and timing settings of a Quiz for specified individuals. Advanced Availability is found in the Restrictions tab of a Quiz at the bottom of the page.



Example in Action: Special Access accommodates students with special testing needs or students that deserve a make up.
- Increase the Quiz time limit for special-needs users.
- Allow individual users to have different start and end dates.
- Change the Quiz availability dates for a make-up Quiz.
Because the Quiz can only appear one way to students, they will see it with the regular Restrictions unless they are specifically chosen to have Special Access. Under Advanced Availability if you choose to 'Allow only users with special access to see this quiz', then only students with Special Access see this Quiz. If you choose the default option then all students see the Quiz with either regular Restrictions or with over riding Special Access if they were chosen to receive Special Access.
Attempts
Here you can specify Attempts Allowed and Overall Grade Calculation:

Submission Views
Overview
Use the Submission Views tab to define what information students will see after they submit the Quiz attempt.
Example: Do you want the students to see what they got wrong immediately after the Quiz is submitted, should it display the correct answers, or should it contain the student's responses? 

Add AdditonalView window

- Show questions answered incorrectly: Only shows students questions that they answered incorrectly.
- Show questions answered correctly: Only shows students questions that they answered correctly.
- Show all questions without user responses: Shows all of the quiz questions the student did not answer.
- Show all questions with user responses: Shows all of the quiz questions to the student that they answered.
- Show question answers: Shows the answers next to each question that appears. Answers will not appear for questions that are not displayed.
If you do not want to show any questions to students after they submit their Quiz, leave the button 'No' marked.
If you are using multiple attempts or if you want to release the information after the Quiz period is over then you can click Add Additional View and apply a date restriction to the Submission View. This will allow the Default View to be in affect until the date for the Additional View has occurred. You can also change the default Submission View after the Quiz period is over.
Reports
Reports allow you to gather information on how students have performed on your Quiz. Reports are different from Quiz statistics because they allow you to collect more types of information and are printable.


- Question Statistics: An "overall" report, showing the class average, score distribution, and the percentage of correct responses for each question.
- Question Details: A more segmented report showing a breakdown of all the responses received for each question and the average grade received on each question.
- User Statistics: provides class average and score distribution information to help you see how your class performed as a whole.
- Attempt Details: allows you to view each user's actual quiz.
You can choose whether or not to allow students to see this information or just instructors and your TAs by choosing the appropriate Privilege Roles.
Adding Questions and Setting up the Quiz Layout
To add or remove Questions or Sections to your Quiz:



Import Questions


Create Questions
Create Questions in your Quiz as described in the Creating Quiz Questions. For information on the different types of Questions, please see Common Features Among All Question Types located below.
Editing Quiz Layout

Tip: Using a small number of questions per page reduces page load time.
Bonus Questions
You can create Bonus Quiz Questions, from the Layout/Questions tab while editing your Quiz, or from the Add/Edit Questions page. Follow the instructions below:
Note: The Bonus value will be equal to the point value assigned to that Quiz Question. If you are connecting the Quiz to a Grade Item in the Grades tool, you will need to make sure the Grade Item can exceed the point total if you want a student to get over 100% for the Quiz in the Grades tool. In the Grades tool tyou will need to check a box on the Grade Items propertys screen beside 'Allow to exceed'.
Common Features Among All Question Types
The following features apply to all Question types in the Quizzes tool:
- a) Choose the New icon in the Manage Quizzes page.
- b) Create a Quiz Name.
- c) Click on the Layout/Questions tab.
- d) Click the Add/Edit Questions button.
- e) Click the drop-down menu beside Create New and choose the Question type you want.
- f) Click GO.
Or
- a) Choose the Question Library icon in the Mange Quizzes page.
- b) In the Question Library click the drop-down menu beside Create New and choose the Question type you want.
- c) Click GO.


If you are using hints on the Quiz you will need to enable hints in the Properties tab by clicking the 'Expand optional advanced properties' and checking the box to the right of Hints. 
You have access to the HTML Editor and spell check, and Preview. Remember to Save each Question when you are done building it and you can hit Save and New if you want another Question of the same type.
True or False


Multiple Choice



Optional: If you would like to randomize the question options, check the box beside Randomize Options. Randomizing the options ensures that each student will receive Questions in a different order. You can also type in Feedback that students will see if the Submission View has been enabled.
Multi-Select
Use Multi-Select Questions to have students identify several answers out of a list of possible answers. For example "Identify all of the prime numbers in the following list: 1, 2, 6, 9, 10, 13, 15."

- All or nothing: Students receive full points for the question only if they select all of the correct answers and none of the incorrect answers. Students receive zero points if they miss any correct answers or select any incorrect answers.
- Right minus wrong: Students receive points equal to the number of right answers they choose minus the number of incorrect answers they choose. For example, if each answer is worth one point and a student selects 3 correct answers and 1 incorrect answer, they will receive 2 points for the question (3 minus 1).
Note: To determine how much each answer is worth, the system takes the total number of points that the question is worth and divides it by the number of correct answers. For example, if a question is worth 4 points and has two correct answers, each correct answer will be worth 2 points, and each incorrect answer will be worth -2 points (students receive a minimum of zero on a question: they cannot receive a negative mark).
- Right answers: Students receive points for each correct answer they select and for incorrect answers they leave blank. Incorrect answers selected and correct answers left blank are ignored.

Long Answer


Allowing students to use the HTML Editor will give them spell check and several other features. Students can also copy and paste from Microsoft Word into the boxes so that they can use a spell checker they are more familiar with.
Note: Long answer Questions can not be auto graded. If you are using Questions that can be auto-graded with Long Answer QuestionsQuiz. and you do allow attempt score to be seen immediately upon completion, the score will be misleading to students immediately following the submitting of the Example: 40 Multiple Choice (MC) questions each worth one point, 3 Long Answer (LA) questions worth 20 points each. If a student gets 39 out of 40 MC correct, the score will show 39 out of 100 upon completion of the exam. The best thing to do is allow this to happen but explain the results in your Submission View.
Short Answer


Note: We do not recommend auto grading Short Answer Questions as it can be very difficult to match your answers with what students write. Also, if you allow attempt score to be seen immediately upon completion, the score will be misleading to students immediately following the submitting of the Quiz. Example: 40 Multiple Choice (MC) questions each worth one point, 3 Short Answer (SA) questions worth 20 points each. If a student gets 39 out of 40 MC correct, the score will show 39 out of 100 upon completion of the exam. The best thing to do is allow this to happen but explain the results in your Submission View.
Multiple Short Answers


Note: The button Check Answers is used to validate acceptable syntaxes of the answers. Follow this link for more information about using Regular Expressions.
Note: We do not recommend auto grading Short Answer Questions as it can be very difficult to match your answers with what students write. Also, if you allow attempt score to be seen immediately upon completion, the score will be misleading to students immediately following the submitting of the Quiz. Example: 40 Multiple Choice (MC) questions each worth one point, 3 Short Answer(SA) questions worth 20 points each. If a student gets 39 out of 40 MC correct, the score will show 39 out of 100 upon completion of the exam. The best thing to do is allow this to happen but explain the results in your Submission View.
Fill In the Blanks


- Entering "[C|c]at" (without the quotation marks) would make both "Cat" and "cat" correct.
- Entering "[soccer|football]" (without the quotation marks) would make both "soccer" and "football" correct.
Matching

- Equally Weighted
- All or nothing: student must have all the possible correct answers or else they receive no points.
- Right minus wrong: the number of right answers chosen is subtracted from the number of wrong answers chosen to get an overall score for the question.

Ordering

- Equally weighted
- All or nothing: students must have all the possible correct answers or else they receive no marks.
- Right minus wrong: the number of wrong answers chosen is subtracted from the number of right answers chosen to get an overall grade for the question.
Arithmetic
The Arithmetic Question type is a great way to present unique Questions to each student. Numbers can be randomly chosen for each variable in the Question based on specified number ranges.

- a. Type the name of your variable (for example, x) in the Name column.
- b. Type the minimum value for the variable in the Min column.
- c. Type the maximum value for the variable in the Max column.
- d. Select the applicable number of decimal places for the variable in the Decimal Places drop-down list.
- e. In the Step field, type the increment that the system should use when choosing random numbers from the range you specified in the Min and Max fields.
Example: If you create variable X with Min=100, Max=200 and Step=5, the system will only choose values for X that are increments of 5 above 100 (105, 110, 115, etc., up to 200) when generating questions.

The following constants are supportd:
- PI - 3.14159 (accurate to 50 decimal places)
- e - 2.71828 (accurate to 50 decimal places)

The following functions are supported in the Formula field:
| Sign/Function | Description | |
| +,-,*,/,\,^,% | Basic mathematical operators | |
| {x}^{y} | x to the power of y | |
| abs({n}) | Absolute value of n | |
| cos({n}) | The cosine of n (in radians) | |
| sin({n}) | The sine of n (in radians) | |
| sqr({n}) | The square root of n | |
| tan({n}) | The tangent of n (in radians) | |
| log({n}) | The log base 10 of n | |
| ln({n}) | The log base e of n | |
| atan({n}) | The inverse tangent of n | |
| sec({n}) | The secant of n | |
| cosec({n}) | The cosecant of n | |
| cotan({n}) | The cotangent of n | |
| factorial | Factorials | |
| exp | The power of natural log (e) |
- Check the case sensitive box if the unit is case sensitive.
- If you wish to assign points to students for using the correct unit in their answer, choose a percentage value from the Worth drop-down list.
Example: If 50% is chosen in the Worth drop-down list, the student would receive 50% of the points for the Question for answering with the correct value, and would receive the other 50% if they answered using the correct unit. Note that if you have selected the case sensitive option, students must type the unit in the proper letter case to have their answer considered correct.
Note: If you do not care what unit students put in, you can leave the Units box blank and at zero percentage points.This means that a student will only see one text box for them to type the answer. If they include the units in the answer, it will be marked wrong because the system is only matching the number. Alternatively, if you put the correct unit, but leave the worth at zero percent, the student will get all or nothing credit for the question based only on the number. They will still see two text boxes however, only the number text box will be graded and counted for points.
Significant Figures
The Significant Figures Question type is most applicable to science and math related courses. This Question type is similar to Arithmetic Questions type, but allows students to enter their answers in scientific notation format. The Question are then graded based on what students entered as their significant digits.
Example: A student might submit an answer of 1.9 x 104. In this example, "1.9" are the significant digits.
Example: Answer the following: {x} x {y} =

- Type the name of your variable (for example, "x") in the Name column.
- Type the minimum value for the variable in the Min column.
- Type the maximum value for the variable in the Max column.
- In the Step field, type the increment that the system should use when choosing random numbers from the range you specified in the Min and Max fields.
Example: If you create variable X with Min=100, Max=200 and Step=5, the system will only choose values for X that are increments of 5 above 100 (105, 110, 115, etc., up to 200) when generating questions.
Note: The Min, Max, and Step values must all be entered in scientific notation. Enter the significant digit(s) in the first text box, and the exponent in the second text box that is to the upper-right of "x10".


Example: a tolerance of 3% would allow students to be off by 3%, or a tolerance of 1.2 x 102 units would allow students to be off by that much in their answers.
Example: You might choose to assign 70% of the points for this question for getting the Significant Figures correct, and 30% for getting the unit correct.
- a. Check Case Sensitive if the unit is case sensitive.
- b. If you wish to assign points to students for using the correct unit in their answer, choose a percentage value from the Worth drop-down list.
Example: If 30% is chosen in the Worth drop-down list, a student would receive 30% of the points for the question for using the correct unit, and the remaining 70% would be earned by answering with the correct significant figure(s).
Text Information Item
Use this feature to create a question consisting of text only. You can use it to provide supplementary information on a Quiz. For example, if you are basing several questions on a case study, instead of inserting the case study into each Question you can create a Text Information item in which your related Questions will appear directly underneath the Text Information item.
Enter your information text in the Question Text box and click Save.

Image Information Item
Use this feature to create a question consisting of an image only. You can use it to provide supplementary information on a Quiz. For example, if you have a diagram you would like to refer to in several of your survey questions, instead of inserting the diagram into each Question, you can create and Image Information item in which all of your related Questions will appear directly underneath the Image Information item.
Re-Grading
From the Manage Quizzes page, click the Grade Quiz icon
beside the applicable Quiz name. You are presented with three options for re-grading quizzes:
- Grading by Users
- Grading by individual Attempts
- Grading by Questions (item analysis)
The options are displayed in tabs. The only difference between Users and Attempts is some of the sorting criteria that you can use to view the scores.
Grading by Users or Attempts
From the Manage Quizzes page, click the Grade Quiz icon
beside the applicable Quiz name. Click the Display Options link located aunder the Users or Attempts tab to select the appropriate boxes to change the following Quiz Display Options:
- ID- displays the participants' IDs beside their name
- Quiz Score- displays the grade beside the participants' names
- Percent- displays the percent beside the participants' names
- Completed- displays date and time the quiz was completed
- Allow Reset- allows you to reset participants' grades - if you check the box next to the student's attempt number and then click the trash can, it will delete a student's attempt. (This will let the student sign in again and retake the quiz. However, there will no longer be a record of the student taking the quiz. Make sure you are deleting the CORRECT student's Attempt. )
Search criteria you use will dictate whether or not you view by Users or Attempts.
Grading by Question
Grading by type allows instructors to easily correct mistakes that may have occurred during the initial setup of Quiz Questions by overriding the original grades. For example, perhaps an error was made when creating a Multiple Choice Question and students who completed the Quiz received a grade value 0 for a Question which they really should have received a grade value of 1 for. Grading by type will allow you to override grades for all users at once, instead of individually updating each Quiz attempt. You can also enter additional comments that will be displayed to users when they view their Quiz report.
- The 'Give to all attempts' option allows you to award points to all users who attempted the current question version in the Quiz. Type the desired point value in the text box and click Save.
- The 'Give to attempts with' has several options depending how which type of question you are working with. For example, option allows you to specify a specific value for a specific response. You can allow for those who have answered Option 1, a point value of 1 and those who answered with any other option will receive a point value of 0. This is useful if a Question was incorrectly graded when the Quiz was created. This means that there can only be one correct answer to a Question when you are altering it after students have taken it or you can go to each attempt for each student and re-grade it by hand.
Note: Any modifications made to the grading of the Quiz Question will be logged. The log will document the date, time, username, and action taken for each change to Quiz grading.
Viewing Course and Quiz Statistics
In this view, you will see a list of Quizzes for the course. The average grade for each quiz is shown to the right of the Quiz name.

- The User Stats tab shows the Class Average, a rough score distribution in bar graph format, and the final score of each student's attempts. The final score is dependent upon the choices you made in the Attempts tab of the Quiz's properties.
- The Question Stats tab shows the average score on each question.
- The Question Details tab shows the break downs of answers for each Question (graphs are created if available for that Question type).
Note: The system will export the statistics from the tab you are currently viewing (for example, User Stats).
Exporting Quiz Statistics and Scores
Quiz statistics can be exported to a CVS file and opened with applications such as Microsoft Excel. There are four kinds of Quiz Exports you can use:
The first three kinds of Exports are accessed through the Course Statistics page. The tab you are on when you click Export to CSV file is the CSV file that will be generated.
The fourth kind of Quiz Export is accessed through the Grade Quiz feature, where you would need to click the Export To CSV file button. This will generate a CSV file that has a row for each student's answer to each Question on each Attempt the student submitted. That is, a Quiz with 10 Questions answered by 20 Students and having 2 Attempts per student results in a file with 400 rows.
Note: If any of your students' names contain Jr., II, or III then there may be extra columns for these students in the Excel file. You can use Excel's Data Sort to quickly identify these students and fix the data accordingly.
Using Excel to Analyze Exports
Once you saved your CSV Export file to your computer, you may be lucky enough to open it immediately and have all the information in the correct columns, but depending on how your browser is set you may need to import it into a blank Excel file. The following steps are to import the CSV Export file into a blank Excel file. The following steps may be different if you are using Office 2007.
1. Open a Blank Excel file.
2. Go to Data Menu and choose Import External Data and Import Data.

3. Change the File Type to All Files.

4. Now, locate your file in your computer and then click the Open button .
5. Choose Delimited and Next.

6. Choose Comma and Next.

7. Choose General and Finish.

8. Choose OK.

These eight steps will allow you to Open the Export file in Excel so that you can analyze and create graphs in any way that you want. The Student Attempt Export file may be too large for Excel and require the use of Access and Importing External Data into a New Table.
Viewing Quiz Reports
You must set up Quiz Reports in the Reports Setup tab of the appropriate Quiz before you can view it. Refer to setting up Quiz Reports for details.
To view Quiz Reports:
The Generate Report page displays:

In the Generate Report page:
The report displays:
Copying a Quiz
To copy an existing quiz, click the Quizzes link in your course NavBar to access the Manage Quizzes page:

Re-Order Quizzes
To change the order that your Quizzes are listed on your Manage Quizzes page:

Deleting a Quiz
On the Manage Quizzes page:
Previewing a Quiz
Click the Preview icon
to the right of a Quiz in the Manage Quizzes page to see the Quiz as users would see it. If you have set up a Random Quiz, the Questions will be randomly drawn. As an instructor, you can go through all the steps of answering the Questions, submitting the Quiz, seeing the Submission View and finally viewing the Reports you have setup and released.
Note: It is always a good idea to Preview a Quiz before you release it to students.



