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 Aug 30, 2017
Version 11Show 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.


Open the gradebook

From the home page, click Gradebook in the left hand menu.

 

 

Click "Export Scores" in the top toolbar

 

 

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 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.

 

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 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.


 

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