SIS: Add, Copy and Restore Gradebook Assignments

SIS: Add, Copy and Restore Gradebook Assignments

Assignments in Teacher Connect Gradebook

Use the Teacher Connect Gradebook to create assignments, configure how they appear in the gradebook and portal, and optionally associate assignments with Learning Standards or Tasks.

Add a Gradebook Assignments

Enter gradebook assignments and scores that calculate into each student’s marking period average or grade.


From the Teacher Connect Gradebook:
  1. Click Assignment.
  2. Complete the required fields:
    1. *Category – Select the appropriate assignment category.
    2. *Assignment – Enter a name for the assignment.
    3. *Due Date – Select the assignment due date.
  3. Complete any additional fields as needed:
    1. Max Possible Points – Enter the maximum number of points available for the assignment.
    2. Bonus Points – Enter bonus points, if applicable.
    3. Multiplier – Use a multiplier to add weight to the assignment.
    4. Description – Enter an optional assignment description.
    5. Allow Comment – Select this option to allow comments to be entered with assignment scores. Assignment comments are viewable in the portal gradebook.
    6. Portal Publish Date – Specify when the assignment will display on the portal.
    7. Publish on Portal – Select what information should be displayed on the portal. Assignment and Grade is the recommended setting.
    8. Display on Gradebook – Select this option to display the assignment in the gradebook.
    9. Color / Background Color – Select text and background colors for the assignment.
    10. Font – Apply Bold, Italic, or Underline formatting as needed.
    11. Exclude Students – Select students who should be exempt from the assignment.
      1. The assignment will not display for excluded students on the portal.
Idea
Tip: Edit gradebook categories to set Assignment defaults  - Comments, Publish, Font & Background Color, Font decoration
  1. Select one of the following:
    1. Save – Saves the assignment to the current gradebook.
    2. Save & Copy – Saves the assignment to the current gradebook and allows it to be copied to one or more additional gradebooks.
Idea
Tip: Use Save & Copy when the same assignment needs to be added to multiple gradebooks.
Add a Gradebook Assignments with Learning Standards

Learning standards attached to gradebook assignments allows teachers to enter standards-based scores directly in the gradebook, which then flow to the Learning Standards screen.


From the Teacher Connect Gradebook:
  1. Click Assignment.
  2. Complete the required fields:
    1. *Category – Select the appropriate assignment category.
    2. *Assignment – Enter a name for the assignment.
    3. *Due Date – Select the assignment due date.
  3. Complete any additional fields as needed:
    1. Max Possible Points – Enter the maximum number of points available for the assignment.
    2. Bonus Points – Enter bonus points, if applicable.
    3. Multiplier – Use a multiplier to add weight to the assignment.
    4. Description – Enter an optional assignment description.
    5. Allow Comment – Select this option to allow comments to be entered with assignment scores. Assignment comments are viewable in the portal gradebook.
    6. Portal Publish Date – Specify when the assignment will display on the portal.
    7. Publish on Portal – Select what information should be displayed on the portal. Assignment and Grade is the recommended setting.
    8. Display on Gradebook – Select this option to display the assignment in the gradebook.
    9. Color / Background Color – Select text and background colors for the assignment.
    10. Font – Apply Bold, Italic, or Underline formatting as needed.
    11. Exclude Students – Select students who should be exempt from the assignment. The assignment will not display for excluded students on the portal.

  4. Click Add Learning Standard.

  5. For each Learning Standard or Task:

    1. Select the desired Learning Standard/Task.

      1. Multiple learning standards can be added.

    2. Enter the Max Points for each standard/task.

  6. Determine how the assignment's maximum points and score should be handled.

Alert
  1. Assignment MAX POINTS counts towards the students marking period average. 
  2. Learning Standard/Task Max Points grade the Standards/Tasks on the Learning Standards Screen and do NOTcount towards the students Marking Period Avrage
Option 1: Manually Set and GradeAssignment Max Points

The assignment's Max Points can be set to any point value. when graded the earned points count towards the marking period averat

For example:

  • Assignment Max Points = 100 points (Impacts Gradebook MPA)
  • Learning Standard 1 = 10 points (Impacts Learning Standard Grades)
  • Learning Standard 2 = 10 points (Impacts Learning Standard Grades)

Option 2: Use Auto Calculate Score

Select Auto Calculate Score to automatically:

  • Set the assignment's Max Points to the sum of the Learning Standard possible points.
  • Calculate the assignment score from the scores entered for the individual Learning Standards.
  • Populate the assignment's score column automatically.
  • Lock the assignment score column in the gradebook.

Example

An assignment contains two Learning Standards:

  • Learning Standard 1 = 10 possible points
  • Learning Standard 2 = 10 possible points

The assignment's maximum score is therefore 20 points.

If a student earns:

  • 7 points on Learning Standard 1
  • 8 points on Learning Standard 2

Auto Calculate Score sets the assignment Max Points to 20 and automatically enters an assignment score of 15 (7 + 8).

This allows a single assignment to affect the marking period average while also using the Learning Standard functionality.


Option 1
Option 2

     

  

Auto Calculate Score: Selected vs. Not Selected

When Auto Calculate Score Is Not Selected

  • The assignment's Max Points are independent of the Learning Standards' Max Points.
  • An assignment score must be entered separately for the assignment to affect the marking period average.
  • Learning Standard scores must also be entered separately to affect the SBRC/Task Lists.

When Auto Calculate Score Is Selected

  • Learning Standard points are summed to determine the Assignment Max Points.
  • Scores entered for Learning Standards automatically populate the assignment Score column.
  • The assignment Score column is locked in the gradebook.
Add Gradebook Template Assignments
Gradebook Templates allow teachers to create a reusable “bank” of assignments that can be applied to classes in future school years. After applying a template to a class, add new assignments to the template to keep the assignment bank up to date for future use.

From the Teacher Connect Gradebook:
  1. Click Templates.
  2. Select a template from the Templates List
  3. Click Add Assignment
  4. Click the Pencil to see the advanced entry screen
  5. Complete the required fields:
    1. *Category – Select the appropriate assignment category.
    2. *Assignment – Enter a name for the assignment.
    3. *Due Date – Select the assignment due date.
  6. Complete any additional fields as needed:
    1. Max Possible Points – Enter the maximum number of points available for the assignment.
    2. Bonus Points – Enter bonus points, if applicable.
    3. Multiplier – Use a multiplier to add weight to the assignment.
    4. Description – Enter an optional assignment description.
    5. Allow Comment – Select this option to allow comments to be entered with assignment scores. Assignment comments are viewable in the portal gradebook.
    6. Portal Publish Date – Specify when the assignment will display on the portal.
    7. Publish on Portal – Select what information should be displayed on the portal. Assignment and Grade is the recommended setting.
    8. Display on Gradebook – Select this option to display the assignment in the gradebook.
    9. Color / Background Color – Select text and background colors for the assignment.
    10. Font – Apply Bold, Italic, or Underline formatting as needed.
    11. Learning Standards - Click the + symbol to select learning standards
Alert
When starting a new school year update template assignment due dates to a date in the current school year!

Import Gradebook Assignments from Excel
From the Teacher Connect Gradebook:
  1. Click Import from CSV
  2. Select Download Template with Data
    1. Use dowloaded template to create a gradebook with the fields required to import into the gradebook
  3. Using the template
    1. Row 1 = Assignment Name
    2. Row 2 = Due date
    3. Row 3 = Max Points
    4. Columns = Student grades
  4. Enter assignment details and student grades
  5. Save the Excel file as .CSV file
  6. Click Import button - Browse and Select File
  7. Double click the file to upload
  8. Click Next
  9. Select Category for each assignment
  10. Click OK
  11. Click Import Grades








Copy Gradebook Assignments

Option 1

Idea
Copy assignments to other Gradebooks in the same marking periods.
From the Teacher Connect Gradebook:
  1. Add or Edit an assignment
  2. Click Save & Copy button
  3. Select the Course
  4. Edit Due Date (Optional)
  5. Click Apply

Option 2

Idea
Copy assignments to other Gradebooks in any marking period.
From the Teacher Connect Gradebook:
  1. Click Setup button
  2. Click the Copy Assignment button
  3. Select the Target Class
  4. Select the Target Marking Period
  5. Click Compare - Highlights category and assignments not found in the target class/marking period.
  6. Select (Blue highlight), or Deselect (no highlight) assignments
  7. Click Append
  8. Click Save

Gradebook Assignment "Task Grades"

CTC teachers can create a gradebook assignment called "Task Grades" with 100 Max Points. Scores entered for standards/tasks on the Learning Standards screen are averaged together and transferred to the Task Grades assignment in the gradebook. A comment on the assignment score indicates how many tasks were used to calculate the grade.

Example: If a student has scores entered for 11 standards/tasks on the Learning Standards screen, those 11 scores are averaged to calculate the student’s Task Grades assignment score and a comment is added.


Skills and Knowledge Categories

Many CTC teachers use Skills and Knowledge categories in their gradebooks. Tests and quizzes are typically entered in the Knowledge category, while the Task Grades assignment can be placed in the Skills category.

Teachers can grade standards/tasks in two ways:

  • Gradebook Assignment → Learning Standards: Attach Learning Standards to a gradebook assignment. Scores entered for the assignment flow to the associated standards on the Learning Standards screen.

  • Learning Standards → Task Grades: Enter scores directly on the Learning Standards screen. The selected scores are averaged and roll up to the Task Grades assignment in the gradebook.

Important Notes

If you do not want Learning Standards scores to impact a student’s marking period average, do not add a Task Grades assignment to the gradebook.

Task Grades assignments only calculates scores that are entered directly on the Learning Standards screen. Scores that appear on the Learning Standards screen because they were calculated from another gradebook assignment will not roll back up into the Task Grades assignment.

Alert
IMPORTANT: Adding an assignment with attached Learning Standards to the Knowledge category will send those scores to the Learning Standards screen. Those Learning Standards scores will not then roll back up to the Task Grades assignment in the Skills category.


Gradebook Category "Daily Score"

Daily Score / Work Ethic Grades

Daily Score (Work Ethic) grades can be recorded through Attendance or by creating Gradebook Assignments. Before creating Daily Score assignments, review the Daily Score Setup article to determine which method is best for your gradebook.  Then review the Record Daily Scores Article to learn how to enter scores and comments related to daily scores.

Related Article: 

Restore Gradebook Assignments

Restore Deleted Assignments

From the Teacher Connect Gradebook:
  1. Click Setup button
  2. Click the Restore Assignments button

Third Party Gradebook - Google Classroom, MS Teams, Schoology, etc

Google Classroom Links:

  1. Import (Link) Assignments
  2. Sync Assignment Scores

Microsoft Teams Assignment and Grade Passback Link

Other Integrated Gradebooks/LMS

Your sis admin sets up a schedule to import assignments and grades from third party vendors.  Once the assignments are imported you can add learning standards, update grades and add assignment comments.