Exporting items in ePortfolio

Export specific items in your portfolio

1. From the main Import/Export page, select Export ePortfolio Content.
2. Click Selected Items.
3. Click Add Items.
4. Select the items you want to export and click Add.
5. Select the auto-include options you want. To remove unwanted items from the export list, click the Remove icon for those items.
6. Click Next.
7. Select Open processing pop-up and click the link for your export file when the file packaging is complete.
   Tip  If you want to navigate away from this page or close the window, you can retrieve your export package from the Import/Export area in the Recent Import/Export Activity list.
8. Save the export file to your computer or storage device.

Export single portfolio item in ePortfolio

Export a single portfolio item

Use theExport option in the action bar when editing an artifact, collection, reflection, or presentation. If you export a presentation, there is an option to export it to HTML format. See Export portfolio to HTML for more information.

Add a Point to a Grade Item

Sometimes, an instructor has reason to add a point to every student's grade on a Quiz or assignment.  


Click this link to see instructions for changing the scoring for a particular Quiz Question.  


Another way to add a point to every student's score is to export the scores for the grade item and make the addition in Excel.  Here's how:

1. Log into D2L, go to your course, and click on [Grades]
2. Click on [Export Grades]
3. Select 'Both' in Key Field, 'Points Grade' in Grade Values, and 'First Name'  & 'Last Name' in User Details
4. Under "Grades to Export," check the grade item for the quiz or assignment that needs attention
5. Click [Export to CSV]
6. (If it doesn't open automatically, you'll need to open the .csv file in Excel)
7. *In the spreadsheet that shows up, write the following formula in the cell at the end of the row for the first student: =if(XY
8. Hit [Enter]
9. Copy the formula down the column for all students
10. Copy all the new scores and paste them in the same column using the 'paste special' function so that the formula calculations become actual numbers
11. Copy the new scores again, and this time paste them into the column with the orgiinal scores (thus replacing them)
12. Delete all columns except Username, the new scores column and the End-of-Line Indicator column with all the pound signs
13. Make sure that cell B1 text ends after the phrase 'Points Grade'
14. Save the file as a csv file and re-import the scores into D2L

*In case you are not familiar with writing formulas in Excel, here's a real formula example where the original scores are in column e in my spreadsheet:
 =if(e2<100,(e2+1),e2).  This means "if the score in cell e2 is less than 100, add one point, otherwise just copy the score in e2".


Many thanks to the LTC's Gerry Bergtrom for these instructions!

Exporting quiz reports

Instructors must set up quiz reports using the Reports Setup tab for the appropriate quiz before they can view or export reports. Refer to Setting up quiz reports for details.

1.     From the D2L Course Home page, click [Quizzes]

2.     Click the name of the appropriate quiz

3.     Click the [Reports] icon (bar graph and line graph on paper)

4.     Click the name of the report to be exported. The Generate Reports page appears.

5.     Optional: Select the “From” box and choose the applicable date from the drop-down lists to include quizzes submitted on or after a certain date.

6.     Optional: Select the “To” box and choose the applicable date from the drop-down lists to include quizzes submitted on or before a certain date.

7.     Click [Generate HTML Report] to view the report in your browser, or [Generate CSV Report] to save the report as a CSV file on your computer.

What data is exported?

Description of exported data by report type

Report Type	What is included
Question Statistics	The average score on questions by points and percentage. Unlike a report created using the Questions Stats tab on the Quiz Stats page, you can choose to exclude the class average, score distribution, bonus questions, or the Out Of value.
Question Details	All of the answers provided for each quiz attempt, how many users chose each possible answer, the total number of responses, and the average score on each question. Unlike a report created using the Question Details tab on the Quiz Stats page, you can choose to exclude the level of difficulty, text responses, or bonus questions. You can also choose to include private comments added to the report.

Exporting Quiz Statistics

Exporting quiz statistics

Instructors can export quiz statistics and reports to a comma-separated value (CSV) file. The CSV file contains all pertinent information on the quiz so the data can be queried, sorted and evaluated.

To export quiz statistics

1.     From the Course Home page, click [Quizzes]

2.     Click the [Statistics] icon (bar graph) beside a quiz name

3.     Click the [User Stats], [Question Stats] or [Question Details] tab to view statistics broken down by user or by question.

4.     Click [Export] to save the quiz statistics as a CSV file on your computer.

User Stats CSV files contain performance data by user, including: the user’s Org Defined ID, username, first name, last name, quiz score, the value the quiz was graded out of, the user’s score as a percentage, and the class average.

Question Stats CSV files contain data about the average score on questions by points and percentage.

The question title, text, bonus status, and difficulty level are included in the CSV file.

Question Details CSV files contain detailed information about each question in the quiz, including a list of all of the answers provided for each quiz attempt, how many users chose each possible answer, the total number of responses, and the average score on the question. The question title, text, bonus status, and difficulty level are included in the CSV file.

What data is exported?

Description of exported data by question type

Question Type	What is exported
Multiple Choice	All of the possible answers and the number of responses for each answer.
True and False	All of the possible answers and the number of responses for each answer.
Long Answer	All of the responses provided listed on  separate rows.
Short Answer	The correct answer for each blank and an additional row for all other answers, and the number of responses for the correct answer versus other answers.
Multi-Short Answer	The correct answers for each blank and an additional row for all other answers, and the number of responses for the correct answer versus other answers.
Fill in the Blanks	The correct answers and an additional row for other answers, and the number of responses for the correct answer versus other answers.
Multi-Select	All of the possible answers and the number of responses for each answer.
Matching	All of the possible matches and the number of responses for each match.
Ordering	All of the answers in the order match and the number of responses for each match.
Arithmetic	Questions broken down by results and units. Also lists which users had both results and units correct, only results correct, only units correct, and neither correct.
Significant Figures	Questions broken down by results and units. Also lists which users had both results and units correct, both results and units correct as well as significant figures, only results correct, only results and significant figures correct, only units correct, and neither results or units correct.

Special Considerations Regarding Student Records

Can an instructor retain student contributions and D2L grade book information, in case it is necessary to review student performance several years after the course ends?

When downloading or saving grade books or student submissions, it is imperative to maintain the privacy of student records, which should be saved on campus-housed, password-protected network storage rather than on local hard drives or portable storage devices.

Questions about how long grade books and student records may be retained should be discussed with the UWM Records Officer.

The D2L grade book can be exported to a CSV* file that can be opened with Excel and other applications.   Step-by-step instructions for exporting the D2L gradebook

*CSV: Comma Separated Values

Saving Discussion Posts

When downloading or saving student submissions, it is imperative to maintain the privacy of student records, which should be saved on campus-housed, password-protected network storage rather than on local hard drives or portable storage devices.

Questions about how long student records may be retained should be discussed with the UWM Records Officer.

To save Discussions, an instructor must either copy-and-paste into Microsoft Word or another word processor, or print posts to a PDF file.

1. On the D2L Course Home page, click [Discussions] on the navigation bar.

2. Click on the name of the Topic you wish to archive posts from.

3. Change view options to "All Messages" under "Unthreaded"

4. Increase the "posts per page" to the highest number as possible -- typically 50.

5. To select all posts, click the checkbox at the top of the list of posts, to the left of the headings. The background of each message title, name, etc. will turn green.

6. Click the [Print] icon (looks like a printer) at the top of the page. A window will appear with the text from all posts.

• If Adobe Acrobat is installed, you can also select the [Print] button in the window to open the Print settings window for your computer. Select [Adobe PDF] as your printer.

• If you use other PDF software, use that software to convert the posts to a PDF.

• If you have Microsoft Office XP or higher for Windows, you can also print the document to 'Microsoft Office Document Image Writer" which will save all pages as a multi-page TIFF file.

• Alternatively, you could highlight all text, then copy-and-paste into Word or another word processor document.

For technical assistance in using Adobe, MS Office, or other software, please contact the UWM Help Desk.

D2L 9.2.1 SP3 – September 2011

Downloading Dropbox Files

Downloading files from the D2L Dropbox

When downloading or saving student submissions, it is imperative to maintain the privacy of student records, which should be saved on campus-housed, password-protected network storage rather than on local hard drives or portable storage devices.

Questions about how long student records may be retained should be discussed with the UWM Records Officer.

1. From your Course Home page, click on [Dropbox] in the main navigation bar


2. Click on the name of the appropriate drop box folder.


3. To select all files in the folder, click the box at the top of the list of students –or– click the box beside the names of the student(s) whose files you wish to download.


4. Click on the [green circle] icon to initiate the download.


5. In the popup window, click on the blue hotlink; the link name will include:

• your folder name
• the word “Download”
• current date and time
• the file extension “.zip”

6. In the new popup window, click on [Save File].


7. Choose a location on your computer (e.g., desktop) where you will save the .zip file that contains your drop box files.


8. Click on [Save].


IMPORTANT NOTE: Additional benefit when following the above procedure!

• When any or all files in a D2L Dropbox are selected for download, they come out as a zip file. When the individual file (or files) are extracted, the filenames will begin with students' last, then first name.

• On the other hand, if you click on the file in the Dropbox, then just open it and save it to your desktop, the file retains the name given by the student. If many students have uploaded files called "Assignment 1" it will be impossible to determine which belongs to which student ... so we don't recommend doing this!

D2L 9.2.1 SP3 – October 2011

Exporting D2L Gradebook

When downloading or saving grade books or student submissions, it is imperative to maintain the privacy of student records, which should be saved on campus-housed, password-protected network storage rather than on local hard drives or portable storage devices.

Questions about how long grade books and student records may be retained should be discussed with the UWM Records Officer.

All information from a D2L Gradebook, including the original point values, grade scheme symbols and 'out of' grades can be exported to a .CSV file which can be opened in Microsoft Excel, OpenOffice and many other spreadsheet applications.

1. In your D2L course site, click the [Grades] link in the navigation bar.
2. At the top of the "User List" page, click the [Export Grades] icon, which looks like a curved green arrow pointing to the right.
3. The "Export Grades" page will appear.
4. By default, the "Export Grade Items For" field is set to "All users." Leave it as set.
5. To export all available information, in the "Key Field" heading, select the [Both] radio button.
6. Select the "Grade Values" to be exported. Suggested are "Points Grade" and "Grade Scheme."
7. Select the "User Details" you wish to export.
8. Select the "Grade Items" you wish to export. (To select individual items, select the checkboxes to the left of each grade item. The background of the item will turn green. To select all items, select the checkbox to the left, above the "Grade Item" heading. Be sure to also choose the "Final Grade" to be exported.)
9. Click [Export to CSV] at the bottom of the page to initiate the export process.
10. A window will open, containing a link that will allow you to save the .CSV file to your computer. Click the link to download the file.

Notes on the export process:

• "Text" grade items cannot be exported.
• "Selectbox" grade items will not export the "label." Instead, only the lowest percentage in the scheme range is exported.

D2L 9.2.1 SP3 – October 2011