Standards: Import Standards

To prepare your school for standards-based grading, you can create a standards import template from the Blank Template or Common Core Template we provide. Once you have a complete template, you can import the data into the TeacherPlus Gradebook Management Site.

Create a Standards Import Template

1. Click Standards > Library/Tools > Manage Import.
2. On the Manage Import page, under Download Template, click one of the following options to download a template to set up a Standards Library for courses:

   Name	Template Description
   Blank Template	Used to define custom standards and link those standards to courses.
   Common Core Template	Used to link courses to common core codes and descriptions.

3. In Excel, using the template you downloaded as a starting point, customize the contents for your school.
   Your finished template should meet the following requirements:
   • The import template header rows (rows 1 & 2) are required to map the standards to the course.
   • 6-Course Code (Course Number), 1-Indicator Code, and Description are required fields.
   • It is strongly recommended that the Grade Level be entered as a Tag for each level being used.  The Tag is used with the Code as the unique identifier for the 
   • Any optional levels (2-Standard, 3-Strand, 4-Master Strand, and  5-Super Strand) must be used in sequence. Levels in the TeacherPlus Gradebook Management Site can be renamed later.
   • Each row must contain Code and Description values for each level being used.
     

     For the first import, any level with empty Code or Description fields in every row will be marked as "hidden" in the library. For subsequent imports, all levels marked as "hidden" during the first import are ignored.

4. In Excel, save the completed template sheet as a CSV (Comma Delimited) file and confirm the following warning: "The selected file type does not support workbooks that contain multiple sheets."
5. To save the completed file in Excel for future reference, click Save As and change the File Type to Excel Workbook.

Import the Standards Template

1. Click Standards > Library/Tools > Manage Import.
2. Under Import Standards, click Import.
3. In the Import File Specificationsdialog box, select one of the following import file types:
   • (Recommended) For a CSV file, click Comma delimited.
   • For a TSV file, click Tab delimited.
4. Next to Select import file, click Choose File, locate and select the .csv (or .tsv) file you just created, click Open, and then click Next.
   
5. The import wizard maps the fields automatically. Click Next to confirm mapping.
6. When the mapping is confirmed, click Import.
   

   Invalid entries are skipped during the import process.

7. When the import process is complete, the Import Information screen lists the number of records imported/updated and the number of invalid entries skipped.