Assigning Points and Exporting Grades Using Turning Point: Importing Point Values into Desire2Learn (D2L)

In order to collect grades (point values) in Turning Point, you must use the participant list retrieved from clickers.uww.edu in your Turning Point session.  Refer to the  step-by-step guide on Getting a Participant List with Clicker Device ID for my class.

ASSIGNING POINTS (SET POINT VALUES)

You can identify specific point values for answers in the range 1-10,000. You can assign different point values to different answers (if one answer should be awarded more than another, for example). 

Answers marked Correct have an effective point value of 100. Answers marked Incorrect or No Value have an effect point value of 0. 

To set a point value for an answer:

• When a question slide is selected in PowerPoint, the TurningPoint 2008 Answer Values Pane will appear on the right-hand side of the screen.
• There is an Answer Value drop-down menu for each possible answer..
• Select Set Point Value from the drop-down menu.
  
  
• A dialogue box asking you to enter a point value opens. 
• Enter a point value in the space provided and select the OK button. TurningPoint sets the point value for the selected answer. 
  
  

Once you have assigned points to your items, you will poll your students and save your session data (tpz file).  

IMPORTANT: Make sure you save your session file to some drive accessible to you before attempting to export the data. Refer to the “Using Turning Technology in your class” guide for details.

EXPORTING SESSION DATA

You can export the data from a session file into a text file. You can use the text file to import the data into a variety of other applications, specifically, Desire2Learn (D2L).  

You need to export the data from the session file in using a predefined scheme for certain the D2L gradebook.  In order to export data, you will need the export scheme we created for D2L called: D2L Export Scheme 2.2.06.tpx.  Download the Export scheme. If you have problems, try downloading the file inside a ZIP archive.

This scheme will need to be loaded into TurningPoint.  To load the cheme, click on Tools. From the dop-down menu, select Session Management, and Export Session Data. Click the Next Button.

Place a check mark in the Use Export Schemes box. Click on the folder icon to load an export scheme. Browse to find the export scheme file you downloaded and open it. The scheme may not appear in your list of available schemes right away. If you go back a step, and return to this screen it will appear in the list from that point forward.

To export session data into a text file... 

1. Click on Tools. Click the Next Button. Place a check mark in the Use Export Schemes box.. 
2. From the dop-down menu, select Session Management, and Export Session Data.
   
3. You may select My Session Files or My Backup Session Files.  If you are using a current session, simply click next.  Usually, you will be using a previous session. 
   
   Select the Use Current Session check box to use the session currently open in PowerPoint. This option is available only if you have a TurningPoint presentation open and response data has been collected. 
   
   To display the session files from your Sessions folder in the list of files, select My Session Files.
   
   To display the backup session files in the list of files, select My Backup Session Files.
   
   
4. Click the Next button once you have selected a session file.
   
5. Check the Use Export Schemes box to select a pre-defined export scheme for a gradebook application from the Export Schemes list.
6. Select gradebook scheme  D2L Export Scheme 2.2.06.tpx
   
   [If you do not see the D2L Export Scheme, you You can import the scheme now by selecting the Load an Export Scheme button (shaped like a folder). ]
   
   Using an export scheme automatically specifies the settings available to you in the next steps to match the format required by the application you are exporting to. You may still choose to modify some settings, to specify a grading scale, for example.
   
   
   
7. Select the Next button to continue.
   
   The Report Wizard window displays a tabbed view for you to specify the data to be used. 
   
   There are four tabs, one for each of the main groups of data you specified whether to include in the exported file. In each area you chose to include, you should review and modify the settings on the corresponding tab.
   
   No changes need to be made since you are using a template.
   
   Select Next. 
8. Specify the order of the fields in the exported file by moving the fields up and down the list by selecting the Move Up and Move Down buttons.
   
   No changes need to be made since you are using a template.
   
   Select Next. 
9. To save your export data, select the Save the current export file button (shaped like a document with a disk).
   
   A dialog opens for you to specify a location and filename for the exported file. 

• Specify a name and location for the exported file.  Change the txt extension to csv.
• Select the Save button. The file is saved and the dialog closes.  Select the Finish button to exit the Report Wizard. 
• Open the csv file in Excel.  Insert a blank row.
• Label the first column, first row as “studentid” and the second column “username” – then, the third column with be the first row as the assignment title in D2L and out of grade.  For example: TP1Out of Grade
• Make sure to remove any extra data from individual responses or questions in the bottom of the csv file
  

Example data table

Studentid	username	TP1Out of Grade
#	r.benji	0
#	bitzan	1
#	d.bred	0
#	bcameron	0
#	c.corr	0

Your csv file is now ready for import into D2L as long as your D2L course has the grade item (e.g. TP1) set up.

ADDING A GRADE ITEM IN D2L

1. Enter your course site in D2L
2. Click on Grades in the Tool Bar; the Gradebook will open
3. Click on New Item
4. Enter Name of Grade Item(e.g., TP1)
5. Choose Numeric for Type
6. Click on Save
   
    
   
   
   
   Grade details will appear
7. Edit the points your grade item is worth (it must be equal to or greater than the total possible points for that day’s lecture)
   
   
8. Click Save
   
   A confirmation will appear indicating you successfully saved the Grade Item.
   
   

IMPORTING GRADES INTO D2L

1. Click on Grades in the toolbar
2. Click on Import/Export
   
   
3. Click on the button to activate Import
   
   
4. Scroll down the import page
5. Click Browse and locate csv file to import
6. Click Preview Import
   
   Any errors with your file will appear at this point
   
   
7. If you have done everything correctly, a preview page should appear.  Click Import! A confirmation will appear indicating you successfully imported the values.
   
   
   
   
8. Click on Grades in the Toolbar and verify your Turning Point grade values were imported.  
9. You can Generate Report: Graded Participant Results (Points Report to verify points were assigned accurately