You can download an import template from the full assessment page. If you're creating a new assessment, you'll immediately see a "Download Import Template" link (for existing assessments, see below). Before you click the link, make sure that you've filled out the assessment basics at the top: name, assessment type, course, and sections. This allows Schoolrunner to include the correct students in the spreadsheet file you download.

Once you click the "Download Import Template" link, you'll be able to choose how many questions your template should have. Alternately, you can download a basic one-question template and manually add questions and other details directly into the spreadsheet.

When you download a template for a brand new assessment, you'll be presented with a file in which you can enter student responses and/or assessment definition details. Student responses will always be missing, but if you've added in definition details via the "Input" tab, you'll see those in the file.

The template file consists broadly of two sections. The upper section, in blue below, is the assessment definition and lays out question numbers, correct answers, point values, objectives, and tag details. If you want, you can add additional columns to represent new questions, but don't add or remove any rows. The second section, in orange below, is where student responses go.

When you're finished entering responses or changing definition values, drop the file right back into the gray import box shown above. If you've manually changed questions, point values, tags, or other details related to the structure of the assessment, Schoolrunner will be able to recognize and process those changes.

When you're working with the assessment template, be sure to change only student responses or definition details. Other changes to the file may cause it to not be recognized when you drop it back into Schoolrunner.

Note: When adding objectives to questions, you only need to use the codes if they're already in our system for the course you've selected. If you want to add new objectives to your course via this template, you can (assuming you have the appropriate setting enabled), but you must enter both a code and a description. And even though you can add new objectives via the import, you must save the assessment before we log the new objective in our system and it's available in the "Objectives" dropdown. (In other words, if you add a new objective and then immediately look at the "Input" tab, you won't see it. It is logged on the assessment though, and will be visible upon save.)

Existing Assessments

If you're working with an existing assessment, downloading the assessment template works just a little differently. Make sure the assessment is opened in edit mode, and then click the "Download" link. You'll notice that the box is smaller than when starting from a new assessment. You'll also notice that when you click the "Download" link, the number of questions is already filled in. You can add questions, if you'd like, but any smaller numbers will be ignored (if you want to deactivate questions, use the "Input" tab).

Once you download the file from an existing assessment, you'll also see that existing student responses are already in the spreadsheet. You can edit responses, add questions, change point values or correct answers for the existing questions, just as if you had downloaded the file from a fresh assessment. Uploading a modified file into an existing assessment uses the same process as well: just drag the updated file onto the import box and any changes will be processed.