|
|
Import Assignment Marks for a Default or Custom Setup 1 Class
To view a video of the following procedure, navigate to the following link:
https://www.youtube.com/watch?v=rUmEDkrQJwc
You can import assignment marks from a third-party company or device for any assignments during any reporting period. You must import a comma-separated file that contains each student's district ID and assignment mark. Once you have imported the file, the assignment marks display on the Assignment Mark Import screen beside the current assignment marks for you to review before saving. You also have the option to overwrite the existing marks.
1.Create or ensure that you have a .csv file with the necessary information for each student for the assignment for which you want to import marks:
•Student ID (Student Number field on the Edit Student Profile screen General tab in StudentInformation without the leading zeros)
•First name
•Last name
•Mark
2.At the top of the Assignment Marks screen, click Import Marks.
The Assignment Mark Import screen File tab displays.
3.At the bottom of the screen, click Choose a file.
4.On the file picker window, navigate to and open the desired file on your computer.
5.Click Next.
|
|
6.On the Map tab, verify that ProgressBook has matched the columns from your file to the correct items. Use the Student ID, First Name, Last Name, and Mark drop-down lists to correct any mismatched items.
7.Click Match Student By ID or Match Student By Name depending on how you want the import to match the students to your grade book.
8.Click Next.
|
|
9.(Optional) If you want to overwrite the existing marks, on the Import tab, select Yes beside the Override existing marks? option.
Note: If an assignment was previously marked as Missing, when you save the imported marks file, the assignment is no longer Missing. Saving the imported marks file, however, does not overwrite an assignment that was previously marked as Excluded or has comments associated with it.
The students for which marks are to be imported, their marks to be imported, their current marks, and any error messages display in the grid.
GradeBook checks the .csv file for the following requirements before the marks are successfully imported:
•Valid student ID
•Student must be enrolled in the class for which the assignment marks are being imported
•Assignment mark must be valid for assignment type associated with assignment
•Assignment mark cannot be longer than 100 characters
If any of these requirements are not met, errors display in the Messages column to indicate the reason the marks cannot be imported.
10.Click Import.
|
|
The imported marks display on the Assignment Marks screen.
Note: You can hover your cursor over the student's name to view an updated average on the Assignment Marks screen.
Import Assignment Mark Messages for a Default or Custom Setup 1 Class
The following errors or warnings may display on the Assignment Mark Import screen while importing an assignment marks file for a Default or Custom Setup 1 class.
•The student is not valid for this class.
•Student ID is missing.
•Special characters are not permitted in the Student ID.
•Duplicate student.
•Mark is invalid for the assignment mark type.
•Mark cannot exceed 50 characters.
•The marks do not match.
Import Assignment Marks for a Custom Setup 2 Class
You can import assignment marks from a third-party testing or scanning device for any assignment, except for floating assignments, during any grading period except in the “+” grading period. The file you are importing must be a .csv (comma separated values) file that contains the student's district ID in the first field and assignment mark(s) in the subsequent fields. You can import assignment marks into a class group only if the assignment was created in the class group. If the assignment was originally created in one of the classes included in the group, then you have to import the assignment marks from the class in which the assignment was created. During the import preview, you can map the import columns to specific assessment columns by dragging the column headings over to the assessment heading, and you can also select between the previously entered mark and imported mark before completing the import.
1.At the top of the Assignment Marks screen, click Import Marks.
2.On the Assignment Marks Import screen, in the Select a CSV file to import field, click Browse.
3.On your computer, browse to the location where the CSV file is saved.
4.On the Choose File to Upload window, select the CSV file, and click Open.
5.In the First row contains headers? option, select No or Yes.
6.Click Upload marks.
Note: If the first row of the file contains headers, the screen uses these headers for each column. If it does not, the screen displays generic headings, such as “Import Mark 1."
7.On the Assignment Mark Import screen, review the marks.
The students for which marks were imported, imported mark, current mark, symbol indicating the status of the imported mark, and error messages, if any, display in the grid.
GradeBook checks the .csv file for the following requirements before the marks are successfully imported:
•Valid student district ID
•Student must be enrolled in the class for which the assignment marks are being imported
•Assignment mark must be valid for assignment type associated with assignment
•Assignment mark cannot be longer than 100 characters
If any of these requirements are not met after the file is imported, various error messages may display describing the reason the marks cannot be imported. The Import Mark 1 column marks have been populated in the first assessment column, the Import Mark 2 column marks have been populated in the second assessment column, etc.
8.If desired, you can change which Import Mark column corresponds to which assessment by clicking and dragging on the Import Mark column (assessment columns change to yellow) and dropping it in the correct assessment column. When you place the Import Mark column over an assessment column, it changes to green, so you know the column in which the imported marks display.
9.For each row indicating a warning 
due to marks not matching, click on the mark that you wish to save.
Note: If there are any existing marks currently entered for the assignment, the existing mark is not overwritten and displays on the Assignment Mark Import screen; however, the previously entered mark and uploaded mark, which display with a white background, display in a split cell.
Note: If there are marks in the CSV file that are invalid (indicated by a pink row), the marks are not uploaded on the Assignment Mark Import screen.
Note: After uploading the CSV file, if there is no Student ID entered in a row in the CSV file, a warning displays, and the row is not uploaded to the Assignment Marks screen.
|
|
Note: You can remove the imported marks from an assessment column by dragging the assessment column to the right and placing it on 
. When the background turns green, release the assessment column. The marks previously entered for the assessment are retained, but the imported marks are removed.
10.Once you are finished reviewing the marks on the Assignment Mark Import screen, click Save.
On the Assignment Marks screen, the marks are imported to the correct assessment.
Import Assignment Mark Symbols for a Custom Setup 2 Class
“Import Assignment Marks Symbols for a Custom Setup 2 Class” displays the icons, warnings, and error messages that may display on the Assignment Mark Import screen while importing an assignment marks file for a Custom Setup 2 class.
