LaunchPad and Writer's Help 2.0 > How can I export my Gradebook?

Document created by Digital Support on Jan 25, 2017Last modified by Digital Support on Apr 14, 2017
Version 10Show Document
  • View in full screen mode

In LaunchPad and Writer's Help 2.0, you can export your grades to a comma-separated file (.csv) or a tab-delimited file (.txt). If you are exporting your grades from LaunchPad or Writer's Help 2.0 so that you can import them into your campus LMS--such as Blackboard, D2L, or Canvas--we recommend you use the .csv file.

Throughout this article we've included notes on considerations for exporting scores from LaunchPad and Writer's Help 2.0 so that you might successfully import them into your campus LMS. Please look for Note on campus LMS import for more information.

To start, for your reference, here are links to articles that will help you to format the file you exported from LaunchPad or Writer's Help 2.0 for optimized import into your campus LMS. You'll want to align the data you export from your LaunchPad or Writer's Help 2.0 gradebook with the data that's already in your LMS gradebook.

D2L/Brightspace: how to format a .csv file for import (You'll need to search for the word "format" from here. Your search results will list the article you need, "D2L Instructor FAQs - What is the file format I should be using to import grades?")

D2L/Brightspace: how to import data from a .csv file (You'll need to search for the word "import" from here. Your search results will list the article you need, "D2L Instructor FAQs - How do I import grades?")

Blackboard: how to format a .csv or .xls file for import and how to import data from a .csv or .xls file

Canvas: How do I format CSV text files for uploading data into Canvas?

and

Canvas: How do I upload changes to the gradebook?

Open the Gradebook

From the home page, Click on the tab for Gradebook.

 

 

Click Export Scores

In your Gradebook, Click Export Scores at the top of the page.

 

 

Select items on the Export Scores screen

The Export Scores window will open and will display several pieces of information that you have the option of exporting from your LaunchPad or Writer's Help Gradebook into a .csv file. We'll walk through each section of the Export Scores window and highlight the selections most of our instructors make.

 

Student Information

  • First Name – Pulls students' first name into the first column (i.e., far-left column) of the .csv file.
  • Last Name – Pulls students' last names into the second column of the .csv file.
  • External ID – If you haven't enabled the campus LMS ID feature (in LaunchPad or in Writer's Help 2.0), this column displays the email addresses students use to log in to LaunchPad or Writer's Help; i.e., their LaunchPad or Writer's Help usernames. If you have enabled LMS ID, this column will display students' LMS ID. Note on campus LMS import: If the email address students use to log in to LaunchPad or Writer's Help is different from the address students use to log in to your campus LMS, you may receive an error message upon importing your scores. Similarly, if students have incorrectly entered their campus LMS ID into LaunchPad or Writer's Help, you may receive an error message when importing because the IDs won't match.
  • Email – Displays the email addresses students use to log in to LaunchPad or Writer's Help. Include only if you've enabled LMS ID and want to the report to include both students' LaunchPad or Writer's Help usernames and their campus LMS IDs.
  • Points or Score – Score will display the cumulative score, expressed as a percent, for each student. Points will display as a fraction the total number of points earned out of the total number of points possible in the course. If you don't wish to import your students' cumulative LaunchPad or Writer's Help scores into your campus LMS, leave the Points or the Score option unticked.
 

Item Information

  • Title – Displays the title of an assignment.
  • Category – If you use Gradebook categories in your LaunchPad or Writer's Help Gradebook, ticking Category will superimpose the title of the category over each assignment title. Note on campus LMS import: If you don't use categories, or if your LaunchPad/Writer's Help categories don't match your campus LMS categories, leave this item unticked.
 

Item Data

  • Percent or Points – Displays each assignment score as a percentage or number of points achieved.
  • Category Totals – If you use Gradebook categories in your LaunchPad or Writer's Help Gradebook, ticking Category Totals will pull in the total number of points or total percentage that students have earned in each category. Note on campus LMS import: If you don't use categories, or if your LaunchPad/Writer's Help categories don't match your campus LMS categories, leave this item unticked.
 

Item Selection

  • Tick All to export your entire Gradebook.
  • Click the + next to the All folder to view and select or de-select categories you wish to include or exclude.
  • Tick the + next to a category folder to select or de-select individual assignments you wish to include or exclude.
 

File

  • Your File name will be "Grades" by default. You can change it to whatever you like.
  • Again, by default, your grades will be exported into a .csv file, but you can drop the File type: menu down to select Tab-separated file (.txt).
 

Export your grades

When you're done, Click Export.

 

Open the export file

Depending on your browser, the download may begin automatically, or you may be asked if you’d like to open or save your file. Select the option to open and Click OK.

 

Save the file and format for import into your campus LMS, if applicable

Once you save the file, you can reformat and manipulate the data. For example, to arrange students in alphabetical order, you can apply filters to the columns and sort the Last Name column by A to Z going down. The next steps will show you how to do this.

 

Click Sort & Filter and select Filter

 

Sort the Last Name column by A to Z

Filters, the gray boxes with down arrows, will appear on each column. Click the filter on the Last Name column and select Sort A to Z.

 

Confirm that your students are in alphabetical order

 

If applicable, further format the file for import into your campus LMS

If you're importing your grades into your campus LMS, you'll want to follow the guidelines we linked to in the introduction of this article to ensure that your LaunchPad or Writer's Help Gradebook data will successfully import into your campus system.


Attachments

    Outcomes