Class/Standards and Test ProfileTips and Tricks

NOTE: If the names in the column are in last name, first name order, you will need to split the data in your roster, then move the first name column to the left of the last name column before bringing the student data into ScoreIT.

1. Highlight all the cells in the name column except the column heading.
2. Click the Data ribbon at the top of the Excel screen.
3. In the Data Tools section of that ribbon, click Text to Columns.
4. Follow the instructions on-screen. See your Excel documentation for details.

1. In the copy of your student roster, highlight the entire column you want to move.
2. Cut the column (CTRL+X, right-click+Cut, etc.)
3. Highlight the column to the right-hand side of where you want the column you just cut.
4. Right-click and select Insert Copied Cells….

CAUTION: Do not just paste the cut column; this will replace the column you select, which is not what you want. If you should accidentally paste the column instead of inserting it, press CTRL+Z (Undo) and try again.

1. Open your electronic class roster. If the data is not already in an Excel spreadsheet, export it.

See the documentation for your Student Information System or class roster software for details on how to do this.

2. In the class roster spreadsheet, highlight all the individual cells in the Student ID column. Do not highlight the header cell.
3. Copy the cells (CTRL+C, right-click+copy, etc.)
4. Open or switch to your ScoreIT Class/Standards Profile.

TIP: You may need to create a profile for this class.

5. In the Class/Standards profile, on the Students tab, highlight the first cell under Student ID.
6. Paste the cells you copied in step 3.
7. Repeat for the other two columns.

1. Open your electronic class roster. If the data is not already in an Excel spreadsheet, export it.

See the documentation for your Student Information System or class roster software for details on how to do this.

NOTE: If the student ID, first name, and last name columns are not next to each other, move them so that they appear in the following order: Student ID, First Name, Last Name. See To move columns, above, for details.

2. In the class roster spreadsheet, highlight all the individual cells in the all three columns. Do not highlight the header cells.
3. Copy the cells (CTRL+C, right-click+copy, etc.)
4. Open or switch to your ScoreIT Class/Standards Profile.

TIP: You may need to create a profile for this class.

5. In the Class/Standards profile, on the Students tab, highlight the first cells under the heading row.
6. Paste the cells you copied in step 3.

1. Locate the document on your state or district website containing the standards/objectives you want to use.

TIP: If the standards/objectives are in a .DOC or .PDF format, consider saving a copy locally so you can easily find the document again.

2. Within the document, locate the specific standards/objectives you want to use.
3. Open or create a Class/Standards Profile and click the Objectives tab.
4. If necessary, add more rows to the data entry area. See To add more objective rows, below.
5. In the standards document, highlight and copy the standard ID, which is a combination of letters and numbers identifying a specific learning objective.
6. In the Class/Standards Profile, on the Objective tab, paste the standard ID in the first row of the ID column.
7. In the standards document, highlight and copy as much of the description as you want on your ScoreIT reports.
8. In the Class/Standards Profile, on the Objective tab, paste the standard ID in the first row of the Description column. Be aware of the following when you paste:
   • If you highlight multiple paragraphs, each paragraph will paste into a separate row in Excel.
   • ScoreIT requires each combination of objective ID and description to occupy one row in the Objectives tab. Sometimes the standard is broken into multiple paragraphs in the standards document. If this is true for a standard you want to use, you must do one of the following:
     • Paste the objective description, then cut the text from subsequent cells and paste it onto the end of the text in the first row. To do this, double-click the cell and press End on your keyboard, then paste the text.
     • Copy and paste only one paragraph at a time into the Description cell.
     • Include the paragraph number with the Objective ID, and only copy a single paragraph. For example, if the standard number is HCC3 and has two sub-paragraphs (a and b), you could create two lines in the profile: HCC3a and HCC3b.
   • All objective IDs/descriptions must appear within the gridlines in the profile. You may need to add more lines to the gridlined area. See To add more objective rows, below, for details.
9. Repeat these steps for each objective you want to associate with tests for this class.

TIP: Don't forget that you can use this class profile with multiple tests, so try to include all the objectives you might need for the class.

1. In the Class/Standards Profile, on the Objectives tab, highlight any gridlined row.
2. Right-click and select Insert.
3. Press F4 on your keyboard or repeat step 2 until there are enough lines to contain all the standards/objectives you plan to associate with test items for this class.

TIP: Don't forget that you can use this class profile with multiple tests, so try to include all the objectives you might need for the class.