HE Instructor Knowledge Base URL: http://cmg.screenstepslive.com/s/MacmillanMedia/m/LaunchPadIM/l/157744-how-to-import-scores-for-offline-assignments
How to Import Scores for Offline Assignments
In this article, we'll learn how to add offline assignment scores to the gradebook. Such assignments might include in-class quizzes/exams, class participation points, or clicker scores.
From the home page, click + Add New.
If you've created assignments:
If you've created assignments, + Add New will be located to the right of the Unassigned section, which is directly below the Assigned section.
If you haven't yet created assignments:
If you haven't yet created assignments, + Add New will be toward the top of your home page, directly beneath the notification about assignments due in the next 7 days.
Create an offline assignment.
From the menu that appears, click on Offline Assignment and then Done.
Add basic information so that students know the assignment was or will be completed in class.
Title your assignment in the Title field and enter a description of the assignment in the Directions field so that students who click on the item know what this grade will be for. When you're done, click Save.
Enter the due date and point value.
Go to the Assignment tab at the top of the editor. For the due date, select the date on which the assignment was or will be given. Under Points, enter a point value.
If you are using categories, please be sure to also go to Gradebook Category, click the drop-down menu, and select the proper category or make a new one using the Create new category option.
Return to your LaunchPad home page.
To return to your home page, click Done Editing at the top of the page and then Home. The assignment should now appear on your home page. Again, because the assignment will be completed in class, you may want to make it clear to students that they aren't responsible for completing anything within LaunchPad on this particular assignment.
To import your grades, go to your LaunchPad gradebook.
When you’re ready to enter grades for this assignment, you can do so in two ways: 1) by manually entering the grades or 2) by importing the grades from a .csv file. Whichever way you choose, you should start from your home page and click Gradebook.
Option 1: Enter grades manually.
In your gradebook, you should now have a column for the assignment. If you want to enter the grades manually, you can click on the grade column next to each student and enter in the correct point value. The cursor will automatically move from student to student down the list in the gradebook.
Option 2: Import grades from a .csv file.
If you have grades recorded outside of LaunchPad (for example, in a .csv file), you can import them into the LaunchPad gradebook. Be sure your spreadsheet contains the following student data columns and that the data matches what's in LaunchPad:
- First Name
- Last Name
- Either Email (which must be the email address the student registered for LaunchPad with) or External ID (otherwise known as the LMS ID, which you can use only if you've enabled this feature in LaunchPad)
- The assignment title and scores students received
Important note: If the data doesn't match, you won't be able to import the scores. For example, if student names are spelled differently on your spreadsheet than they are in your LaunchPad gradebook, the import won't be successful. Similarly, if you have a school email address recorded for a student, but the student used a personal email address to register for LaunchPad, the import won't be successful.
The best way to ensure a successful import is to export your LaunchPad gradebook as a .csv file first, add your scores to this file, then import the file back into your LaunchPad gradebook. In this way, you can be sure that the data will match, for the source of the data was LaunchPad.
Export your LaunchPad gradebook.
In the upper-left corner of the LaunchPad gradebook, click Export Scores.
Select Student Information, Item Information, and Item Data.
Since the purpose of this export is to quickly import scores you're currently keeping outside your LaunchPad gradebook, it's best to keep things simple.
- To identify your students, under Student Information, select First Name, Last Name, and Email. Instead of Email, External ID is also a good option if you've enabled the LMS ID feature in your course.
- To identify one or more offline assignments for which you wish to import grades, under Item Information, select Title.
- Finally, to dictate whether assignment scores should display as number of points or as a percentage, tick Points or Percent, respectively.
Select the LaunchPad gradebook columns to which you will be adding scores.
Use the Item Selection section to focus on only the assignments to which you wish to add scores. By default, you'll see a + sign, an icon of a folder, and All, which means data from all assignments in your gradebook will be exported into a .csv file. Click the + to display your gradebook categories, if you're using them. Similarly, click the + sign next to a category to see the assignments within it.
To quickly select only the assignments to which you'd like to add scores:
- Untick the check box next to All.
- Click the + next to the category or categories that contain the assignment(s) to which you wish to add scores.
- Tick the check box(es) next to the assignment(s) to which you wish to add scores.
Export your LaunchPad gradebook.
Change the file name, if desired. Leave the File type: drop-down menu on comma-separated file (*.csv) and click Export.
Copy and paste scores into the .csv file.
You'll now have an exported gradebook that includes the student data and assignment columns you selected. Simply copy the grades from each of your offline assignments and paste them into the appropriate grade column.
Save your changes in your .csv file.
When you save the changes you made to the gradebook, you may get a message that looks similar to the screen shot below, asking if it is OK to save in CSV format. If this message appears, press Yes.
Return to your LaunchPad gradebook and click Import Scores.
To import the new grades into LaunchPad, return to your gradebook and click Import Scores at the top of the page.
Choose the file for import.
Click Choose File and select the gradebook CSV file you exported and edited. If your file included a header, such as one or more assignment titles, make sure the box next to Header Row is checked. When you are ready, click Continue.
On the screen that appears, make sure that the identifying information in the drop-down menus match the headers of your spreadsheet. For the assignment title columns, you'll also need to select Points or Percent from the drop-down, depending on how your scores should display. When you are ready, click Import.
Close verification screen.
A page should appear verifying that the information was successfully imported. When you close out of this window, your grades appear in your gradebook.