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). Once exported, you can then import them into an LMS.
If you will be importing into an LMS:
If you are exporting your grades from LaunchPad or Writer's Help 2.0 so that you can import them into your campus LMS (Blackboard, D2L, Canvas, or Moodle), we recommend you export your gradebook as a .csv file.
The links below are 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: What file format should I use to import grades?
- D2L/Brightspace: How do I import and export grades?
- Blackboard: Work Offline with Grade Data
- Canvas: How do I format CSV text files for uploading data into Canvas?
- Canvas: How do I upload changes to the gradebook?
- Moodle: Grade Import
- Note on Moodle import: Moodle will not allow you to import a .csv exported from LaunchPad or Writer's Help 2.0. You must either export your gradebook from Moodle and edit that file (by copying and pasting data from your LaunchPad/Writer's Help 2.0 export), then import it or copy and paste data from your LaunchPad/Writer's Help 2.0 export directly into Moodle using the Paste From Spreadsheet import option.
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 below for more information.
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.
- First Name – Pulls students' first names 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 e-mail 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 e-mail address a student uses to log in to LaunchPad or Writer's Help is different from the address that student uses 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.
- E-mail – Displays the e-mail 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.
- 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.
- 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.
- 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.
- 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).
Open the exported 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.
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.
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.