Skip to main content

Export grades to Schoology

Your students' Lab Games scores can go straight into your Schoology gradebook. No retyping. You download one file here and upload it there.

About 2 minutes per class

Before you start: student ID numbers

Schoology matches each row of the file to a student using their ID number. Students already sign in to The Lab Games with their school ID number, so most rosters are ready.

Check this once: the number in your roster has to match the Unique User ID Schoology has for each student. In most districts that's the same as the student ID. If a test import says students weren't found, ask your Schoology admin which number your district uses.

Part 1: download the file from The Lab Games

  1. Open your gradebook

    Sign in, open the Teacher dashboard, go to Gradebook, and pick the class.

  2. Show only what you want to export

    Set the dates and the activities you want. The file includes exactly the activity columns on your screen, up to 50 at a time.

  3. Click Export CSV…

    • Format: choose Schoology import.
    • Score as: Percent (0–100) is the easiest. Use Points earned only if your Schoology assignment uses the same point total.
    • Include: All work, or Only completed work to leave unfinished attempts blank.

  4. Check the preview, then click Download

    Read any yellow warnings first, such as missing or duplicate ID numbers. The file you download is exactly what the preview shows.

The file looks like this. Blank cells mean the student hasn't turned the work in, and they are never counted as a zero.

Unique User ID,Student Name,Liver Catalase Lab,Build a Cell
204518,Maria Lopez,92,100
204533,Devon Price,78,
204540,Ana Chen,,85

Part 2: import the file into Schoology

  1. Open your Schoology gradebook

    Go to the course, open Gradebook, open the ⋮ menu, and choose Import.

  2. Upload the file

    Choose the file you downloaded. When Schoology asks how to match students, match Unique User ID to Unique User ID. Leave Student Name unmatched.

  3. Match each activity column

    • Existing Assignment: pick the Schoology assignment you already made for that lab.
    • New Assignment: Schoology creates one for you. If you exported percents, set it out of 100, and choose the category and grading period.

  4. Review and import

    Schoology shows a summary before saving. Check a couple of students against The Lab Games gradebook, then confirm.

Common questions

A student redid a lab. Which score goes over?
The attempt marked Counts in the gradebook. Click a student's cell to see every attempt and change which one counts.
Can I import the same lab again later?
Yes. Export again and map the column to the same existing assignment. Schoology updates the scores.
Schoology says some students weren't found.
Their roster number doesn't match their Schoology Unique User ID. Fix the number on the roster page and export again.
What about PowerSchool or another gradebook?
Choose Full detail in the export window to get every submission in a spreadsheet you can sort or paste anywhere.
Open my gradebook