1. sports
2. skating
3. figure skating

Connecticut Smarter Balanced Assessments
Test Information and
Distribution Engine
User Guide
2014-2015
Published April 10, 2015
Prepared by the American Institutes for Research®
Descriptions of the operation of the Test Information Distribution Engine, Test Delivery System,
and related systems are property of the American Institutes for Research (AIR) and are used
with the permission of AIR.
Table of Contents
Introduction to This User Guide ................................................................................................................ 1
Organization of This User Guide .............................................................................................................. 1
Document Conventions ............................................................................................................................ 2
Intended Audience .................................................................................................................................... 2
Section I. Overview of the Test Information Distribution Engine........................................................... 3
Description of TIDE................................................................................................................................... 3
System Requirements .............................................................................................................................. 4
Understanding User Roles and Permissions ............................................................................................ 4
Section II. Accessing TIDE ......................................................................................................................... 7
Activating Your TIDE Account .................................................................................................................. 7
Logging in to TIDE .................................................................................................................................... 9
Changing Your Account Information....................................................................................................... 10
Resetting Your Password ....................................................................................................................... 11
Logging out of TIDE ................................................................................................................................ 12
Section III. Understanding the TIDE Interface ........................................................................................ 13
TIDE’s Home Page ................................................................................................................................. 13
Sorting Retrieved Records...................................................................................................................... 14
Switching Between CT Smarter Balanced Systems ............................................................................... 14
Changing Test Administration or Institution ............................................................................................ 15
Selecting Records for an Action ............................................................................................................. 16
Navigating Back to Retrieved Records ................................................................................................... 16
Section IV. Managing TIDE Users ............................................................................................................ 17
Retrieving User Accounts ....................................................................................................................... 17
Viewing and Editing User Details ........................................................................................................... 18
Adding User Accounts ............................................................................................................................ 20
Deleting User Accounts .......................................................................................................................... 21
Adding, Editing, or Deleting Users through File Uploads ....................................................................... 21
Understanding the User Upload File Format ...................................................................................... 21
Submitting a User Upload File ............................................................................................................ 23
Section V. Working with Student Information ........................................................................................ 25
Retrieving Student Records .................................................................................................................... 25
Viewing and Editing Students ................................................................................................................. 28
Moving Students Between Schools ........................................................................................................ 33
Printing Testing Tickets .......................................................................................................................... 33
ii
TIDE User Guide
Table of Contents
Printing PreID Labels .............................................................................................................................. 34
Uploading Test Settings.......................................................................................................................... 35
Understanding the Test Settings Upload File Format ........................................................................ 36
Submitting a Test Settings Upload File .............................................................................................. 42
Section VI. Working with Classroom Activities ..................................................................................... 44
Reviewing Classroom Activities .............................................................................................................. 44
Modifying Classroom Activities ............................................................................................................... 45
Section VII. Working with Appeals .......................................................................................................... 46
Understanding Appeals .......................................................................................................................... 46
Types of Appeals ................................................................................................................................ 46
Status of Appeals ............................................................................................................................... 47
Available Appeals by Test Result Status............................................................................................ 47
Retrieving Appeals .................................................................................................................................. 48
Creating Appeals .................................................................................................................................... 51
Creating Appeals Through File Uploads................................................................................................. 52
Understanding the Appeal Upload File Format .................................................................................. 52
Submitting an Appeal Upload File ...................................................................................................... 53
Section VIII. Working with Rosters of Students ..................................................................................... 54
Viewing Rosters ...................................................................................................................................... 54
Adding a New Roster .............................................................................................................................. 55
Modifying an Existing Roster .................................................................................................................. 56
Deleting a Roster .................................................................................................................................... 56
Printing a Roster ..................................................................................................................................... 57
Creating Rosters Through File Uploads ................................................................................................. 58
Understanding the Roster Upload File Format ................................................................................... 58
Submitting a Roster Upload File ......................................................................................................... 59
Section IX. Downloading and Installing Voice Packs ............................................................................ 61
Appendix A. Exporting Retrieved Records ............................................................................................ 62
Appendix B. Processing File Uploads .................................................................................................... 64
How TIDE Processes Large Files ........................................................................................................... 64
How TIDE Validates File Uploads .......................................................................................................... 64
Resolving File Upload Errors .................................................................................................................. 65
Reviewing Upload History....................................................................................................................... 66
Appendix C. Opening CSV Files in Excel 2007 or Later ........................................................................ 68
Appendix D. User Support ....................................................................................................................... 70
Appendix E. Change Log .......................................................................................................................... 71
iii
Table of Figures
Figure 1. TIDE’s position in the assessment process ................................................................................... 4
Figure 2. Hierarchy of User Roles ................................................................................................................. 6
Figure 3. Fields in the Please Log In page ................................................................................................... 7
Figure 4. Fields in the Reset Password Page ............................................................................................... 8
Figure 5. Fields in the Select a Security Question Page .............................................................................. 8
Figure 6. TIDE Card ...................................................................................................................................... 9
Figure 7. Please Log In Page ....................................................................................................................... 9
Figure 8. Fields in the My Account Page .................................................................................................... 10
Figure 9. Fields in the Reset Your Password Page .................................................................................... 11
Figure 10. TIDE Home Page for the District Administrator Role ................................................................. 13
Figure 11. Sort Columns ............................................................................................................................. 14
Figure 12. Switching Between CT Smarter Balanced systems .................................................................. 14
Figure 13. Change Institution/Test Administration Page ............................................................................ 15
Figure 14. Options for Selecting Retrieved Records .................................................................................. 16
Figure 15. Button to use to return to a listing of retrieved records .............................................................. 16
Figure 16. Selection Fields in the View/Edit Users Page ............................................................................ 17
Figure 17. Retrieved Users ......................................................................................................................... 17
Figure 18. Edit User Page ........................................................................................................................... 18
Figure 19. Form Fields in the Add Users Page ........................................................................................... 20
Figure 20. Sample User Upload File ........................................................................................................... 23
Figure 21. User Upload File Preview .......................................................................................................... 24
Figure 22. Selection Fields in the View/Edit Students Page ....................................................................... 25
Figure 23. Additional Student Search Criteria (Form Fields) ...................................................................... 25
Figure 24. Additional Student Search Criteria (Displayed) ......................................................................... 26
Figure 25. Retrieved Students (partial view) ............................................................................................... 26
Figure 26. View Student Details Page (Top Portion) .................................................................................. 28
Figure 27. Sample Testing Ticket ............................................................................................................... 33
Figure 28. Sample PreID Label ................................................................................................................... 34
Figure 29. Menu from the PreID Labels button ........................................................................................... 35
Figure 30. Label Template (partial view) ..................................................................................................... 35
Figure 31. Sample Test Settings Upload File ............................................................................................. 42
Figure 32. Test Settings Upload File Preview (partial view) ....................................................................... 42
Figure 33. Fields in the View Classroom Activities page ............................................................................ 44
Figure 34. Retrieved Classroom Activities .................................................................................................. 44
Figure 35. Performance Task Fields in the View Student Details Page ..................................................... 45
iv
TIDE User Guide
Table of Figures
Figure 36. Selection Fields in the View Appeals Page ............................................................................... 48
Figure 37. Retrieved Appeals...................................................................................................................... 49
Figure 38. Selection Fields in the Create Appeals Page ............................................................................ 51
Figure 39. Retrieved Appeals...................................................................................................................... 51
Figure 40. Sample Appeals Upload File ..................................................................................................... 52
Figure 41. Appeals Upload File Preview ..................................................................................................... 53
Figure 42. Manage Rosters Page—selection fields .................................................................................... 54
Figure 43. Manage Roster Page—Viewing a Roster’s Students ................................................................ 55
Figure 44. Printer-Friendly Version of a Roster .......................................................................................... 57
Figure 45. Sample Roster Upload File ........................................................................................................ 59
Figure 46. Roster Upload File Preview ....................................................................................................... 60
Figure 47. Export Options ........................................................................................................................... 62
Figure 48. Sample Error Messages ............................................................................................................ 65
v
Table of Tables
Table 1. Document Conventions ................................................................................................................... 2
Table 2. User Roles and Associated Permissions ........................................................................................ 4
Table 3. Fields in the View User Details Page ............................................................................................ 19
Table 4: Columns in the User Upload File .................................................................................................. 21
Table 5. Fields in the View Student Details Page ....................................................................................... 29
Table 6: Columns in the Test Settings Upload file. ..................................................................................... 36
Table 7. Types of Appeals .......................................................................................................................... 46
Table 8. Statuses of Appeals ...................................................................................................................... 47
Table 9. Available Appeals by Test Result Status ...................................................................................... 47
Table 10. Fields in the View Appeals Page ................................................................................................ 49
Table 11: Columns in the Appeals Upload File ........................................................................................... 52
Table 12: Columns in the Rosters Upload File ........................................................................................... 58
Table 13. Export Options ............................................................................................................................ 62
Table 14. Record Thresholds for Offline Processing .................................................................................. 64
Table 15. File Upload Error Icons and Resolutions .................................................................................... 65
Table 16. Columns in the Error Messages report ....................................................................................... 65
Table 17. Columns in Upload History ......................................................................................................... 66
vi
Introduction to This User Guide
This section describes the contents of this user guide.
Organization of This User Guide
This guide contains the following sections:

Section I, Overview of the Test Information Distribution Engine, lists TIDE’s features, system
requirements, and provides an overview of user roles and permissions.

Section II, Accessing TIDE, describes how to activate your TIDE account, how to log in and
log out, and how to change your password.

Section III, Understanding the TIDE Interface, describes what appears in the TIDE interface,
how to sort columns, how to switch between other assessment applications, and how to
change your user role and test administration.

Section IV, Managing TIDE Users, describes how to view, add, and modify TIDE user
accounts.

Section V, Working with Student Information, describes how to view, add, and modify
information pertaining to students, their test eligibilities, and their test accommodations.

Section VI, Working with Classroom Activities, describes how to view and reassign
Classroom Activities.

Section VII, Working with Appeals, describes how to view and create testing appeals.

Section VIII, Working with Rosters of Students, describes how to create, modify, and delete
rosters of students associated with teachers and schools.

Section IX, Downloading and Installing Voice Packs, describes how to download the
available voice packs.

Appendix A, Exporting Retrieved Records, describes how to export retrievals into a variety
of file formats.

Appendix B, Processing File Uploads, describes how TIDE processes file uploads and how to
resolve associated error messages.

Appendix C, Opening CSV Files in Excel 2007 or Later, describes how to open CSV files in
recent versions of Microsoft Excel.

Appendix D, User Support, explains how to contact the help desk.
1
TIDE User Guide
Introduction to This User Guide
Document Conventions
Table 1 describes the conventions appearing in this user guide.
Table 1. Document Conventions
Icon
Description
Warning: This symbol accompanies information regarding actions that may cause loss of
data.
Caution: This symbol accompanies information regarding actions that may result in incorrect
data.
Note: This symbol accompanies helpful information or reminders.
bold
italic
Boldface italic indicates a page name.
bold
Boldface indicates an item you click or a drop-down list selection.
mono
Monospace indicates a file name or text you enter from the keyboard.
Intended Audience
This user guide is intended for state-, district-, and school-level test administrators and
coordinators who manage the assessment effort. You should be familiar with the concepts of
test eligibility, test settings, accommodations, and general management of user accounts for an
enterprise-wide system.
To use TIDE, you need to be familiar with using a web browser to retrieve data and with filling
out web forms. If you want to use the file upload and download features, you also need to be
familiar with using a spreadsheet application and working with comma-separated value (CSV)
files.
2
Section I. Overview of the Test Information
Distribution Engine
Description of TIDE
Test Information Distribution Engine (TIDE) performs the following functions:

Registering students for assessments

Establishing test settings and accommodations

Viewing students’ associations with districts, schools, and rosters

Delivering voice packs for testing computers

Managing appeals

Managing rosters

Managing users accounts
Depending on your state and user role, you may not have access to all these functions.
Figure 1 illustrates TIDE’s functions and their place in the assessment process. At its core, TIDE
contains a list of students enrolled in your schools. TIDE receives the vast majority of this
student information from uploads from external systems, although TIDE has features for
manually modifying students’ test settings. TIDE then distributes this information to the
appropriate target system. Test Delivery System (TDS) receives students’ eligibilities, settings,
and accommodations; this enables TDS to deliver the appropriate test to any given student in
the required format. Online Reporting System (ORS) receives students’ institutional
associations; this enables ORS to aggregate scores at the classroom, school, district, and state
levels.
3
TIDE User Guide
Overview of the Test Information Distribution Engine
Figure 1. TIDE’s position in the assessment process
Manual
Registrations
Test Delivery System
Students’ test eligibility, settings,
accommodations
TIDE
Students’ demographics, roster,
school, and district associations
Overnight
Loads
Online Reporting
System
System Requirements
To use TIDE, you need a recent version of a web browser, such as Firefox, Chrome, or Internet
Explorer. For a detailed list of system requirements, which includes the supported operating
systems and web browsers, see the Online System Requirements. This publication is available in
the Resources section of the Connecticut Smarter Balanced Assessments Portal,
https://CT.portal.airast.org.
Understanding User Roles and Permissions
Each user in TIDE has a role, such as a district-level user or a school-level user. Each role has an
associated list of permissions to access certain features within TIDE. For example, a district-level
user can perform activities related to districts. This can include adding or deleting TIDE users. A
teacher can perform different activities. This can include downloading screen readers but not
re-opening a test.
Table 2 describes TIDE’s user roles. The top row contains the various roles, and the subsequent
rows indicate the tasks permitted to those roles.
Table 2. User Roles and Associated Permissions
*
Task
DA
DC
SC
TE
TA













Working with Student Information
Retrieving Student Records
Uploading Test Settings
1
Viewing Students (Demographic Information)
1
Text-to-Speech for Passages and Print-on-Demand can only be set by a district-level user. SCs may work with all
other appropriate test settings.
4
TIDE User Guide
Overview of the Test Information Distribution Engine
*
Task
DA
DC
SC
TE
TA
Viewing and Editing Students (Test Settings)



View
Only
View
Only
Printing Testing Tickets





Retrieving User Accounts



Adding User Accounts



Adding, Editing, or Deleting Users through File
Uploads



Viewing and Editing User Details



Deleting User Accounts



Creating Appeals



Retrieving Appeals





Creating Appeals Through File Uploads



Viewing Rosters




Adding a New Roster




Modifying an Existing Roster




Deleting a Roster




Printing a Roster




Creating Rosters Through File Uploads




Reviewing Classroom Activities





Modifying Classroom Activities








Managing Users
Working with Appeals
Working with Rosters of Students
PT Classroom Activities
Voice Packs
Downloading and Installing Voice Packs
*
DA—District Administrator; DC—District Test Coordinator; SC—School Test Coordinator; TE—Teacher,
TA—Test Administrator
5
TIDE User Guide
Overview of the Test Information Distribution Engine
Figure 2. Hierarchy of User Roles
There is a hierarchy to the user roles
listed in Table 2. As indicated in
Figure 2, the district administrator is at
the top of the hierarchy, followed by
district test coordinator, then school
test coordinator, then teacher and test
administrator. Generally, user roles that
are higher in the hierarchy have access
to more sensitive or critical data and
tasks within TIDE.
District Administrator
District Test
Coordinator
School Test
Coordinator
Teacher
6
Test Administrator
Section II. Accessing TIDE
This section explains how to activate your TIDE account, log in to TIDE, reset a forgotten
password, change account information, and how to log out.
Activating Your TIDE Account
Your TIDE administrator creates your account, and then TIDE sends you an introductory email.
This email contains the following information:

A link for logging in to TIDE. This link expires 30 days after the email was sent.

Your temporary password.
If you do not receive an account activation email, check your spam folder. Emails are sent from
[email protected], so you may need to add this address to your contact list.
To activate your account:
1. Click the link in the activation email. The Login page appears.
Figure 3. Fields in the Please Log In page
2. Enter your email address and temporary password.
3. Click Secure Login. The Reset Password page appears (see Figure 4).
7
TIDE User Guide
Accessing TIDE
Figure 4. Fields in the Reset Password Page
4. In the Old Password field, enter the password in the activation email.
5. In the other password fields, enter a new password. The password must be eight characters
long and have at least three of the following: one lowercase alphabetic character, one
uppercase alphabetic character, one number, and one special character %, #, or !.
6. Click Submit. The Select a Security Question page appears (see Figure 5).
Figure 5. Fields in the Select a Security Question Page
7. Mark the checkbox next to a question, and enter an answer.
8. Click Save. The Connecticut Smarter Balanced Assessments portal page appears.
Account activation is complete. You can proceed to TIDE by clicking the TIDE card (see Figure 6)
in the portal page.
8
TIDE User Guide
Accessing TIDE
Logging in to TIDE
To log in to TIDE:
1. Open your web browser and navigate to
the CT Smarter Balanced portal at
https://CT.portal.airast.org.
Figure 6. TIDE Card
2. Click the Test Administrators or Test
Coordinators card.
3. Click the TIDE card. The Please Log In page
appears.
4. Enter your email address and password,
and then click Log In. The Home page
appears.
Figure 7. Please Log In Page
Depending on your user role, TIDE may prompt
you to select a role, district, or school to
complete the login.
9
TIDE User Guide
Accessing TIDE
Changing Your Account Information
You can modify your name, phone number, and other account information.
To modify account information:
1. In the banner (see Figure 10), click My Account. The My Account page appears (see
Figure 8).
Figure 8. Fields in the My Account Page
2. To modify your user information, in the User Information section, enter updates as
necessary. (To change your email address, contact your TIDE administrator).
3. Click Update. TIDE saves your changes, and a confirmation message appears.
10
TIDE User Guide
Accessing TIDE
Resetting Your Password
You need to reset your password if you forgot it or if the TIDE administrator locked your
account.
To reset your password:
1. Display the Login page by following steps 1–3 in the section Logging in to TIDE.
2. In the Login page (see Figure 7), click Forgot Your Password?. The Reset Your Password
page appears (see Figure 9).
Figure 9. Fields in the Reset Your Password Page
3. Enter your TIDE email address, and click Next. Your security question appears.
4. Enter the response to the security question, and click OK. TIDE sends you an activation
email with a new temporary password.
5. Return to the login page, enter your username and the temporary password from step 4,
and click Log In. The Please Log In page appears (see Figure 3).
6. In the Old Password field, enter the temporary password from step 4, and enter a new
password. The password must be eight characters long and have at least three of the
following: one lowercase alphabetic character, one uppercase alphabetic character, one
number, and one special character %, #, or !. Your password cannot be the same as your
current or previous password.
7. Click Submit. TIDE resets your password. The Select a Security Question page appears.
8. Review and modify your answers to the security question as necessary, and click Save.
The TIDE home page appears.
11
TIDE User Guide
Accessing TIDE
Logging out of TIDE
To log out of TIDE:

In the TIDE banner (see Figure 10), click Logout.
12
Section III. Understanding the TIDE Interface
This section describes TIDE’s Home page and some common tasks such as sorting retrieved
records.
TIDE’s Home Page
The first page you see after logging in to TIDE is the Home page (see Figure 10). This page’s
appearance differs depending on your role. Some roles, such as those for schools, have just a
few tabs and tasks; other roles, such as those at the district level, have several tabs and tasks.
Figure 10. TIDE Home Page for the District Administrator Role
User
name
Role
Logout
District and Test
Administration
Tabs
Tasks
CAUTION: Loss of Data Working with TIDE in more than one tab or browser window may
result in changes in one tab overwriting changes made in another tab. Do not have more than
one TIDE browser tab or window open at one time.
13
TIDE User Guide
Understanding the TIDE Interface
Sorting Retrieved Records
Many tasks in TIDE involve retrieving data from a database. You can sort the retrieved records
by clicking any of the column headings in the retrieval table. For example, Figure 11 is a portion
of the View/Edit Users page. You can sort the records by clicking Role, District, or School. (In
the complete View/Edit Users page, there are many more columns by which you can sort.)
Figure 11. Sort Columns
Sort columns
Switching Between CT Smarter Balanced Systems
Depending on your role, when you log in to TIDE you can also switch to other CT Smarter
Balanced systems.
To switch to another CT Smarter Balanced system:

In the banner, click Test Information Distribution Engine, and then select the other system
you want to use (see Figure 12).
Figure 12. Switching Between CT Smarter Balanced systems
Available CT
Smarter Balanced
Systems
14
TIDE User Guide
Understanding the TIDE Interface
Changing Test Administration or Institution
Depending on your permissions, you may have access to more than one test administration or
more than one school. You can also change to another user role if one is available to you. (For
an explanation of user roles, see Understanding User Roles and Permissions.)
To change test administration or institution:
1. In the TIDE banner (see Figure 10), click Change Institution/Test Administration. The
Change Institution/Test Administration page appears (see Figure 13).
Figure 13. Change Institution/Test Administration Page
2. Update the information as necessary. All fields are editable.
3. Click Submit. A new home page appears that is associated with your selections.
15
TIDE User Guide
Understanding the TIDE Interface
Selecting Records for an Action
In some retrieval pages, you can perform an action on the retrieved records. For example, in
the View Users page, you can export and download the retrieved records as an Excel file.
You can select all the retrieved records for a given action, or you can select some of them.
Referring to Figure 14, if you mark the checkbox in the header row, TIDE selects all the records.
If you mark a checkbox in an individual row, TIDE selects that record—and any other individual
records you mark.
Figure 14. Options for Selecting Retrieved Records
Selects all retrieved records
Selects individual record
Navigating Back to Retrieved Records
When you retrieve records, such as a listing of students or users, you can click on a View button
that provides a page to view or modify an individual record. (See, for example, Figure 17.) If you
want to return to the retrieved records, you must click Go Back To Search Results, not your
browser’s Back button. See Figure 15.
Figure 15. Button to use to return to a listing of retrieved records
Use this button instead of
your browser’s Back button
to return to a listing
16
Section IV. Managing TIDE Users
This section describes user roles and associated permissions. This section also describes how to
manage user accounts.
Retrieving User Accounts
You can retrieve up to 1,000 user accounts that satisfy given criteria. For a list of user roles that
can perform this task, see Table 2.
To retrieve user accounts:
1. Click the Manage Users tab, then click View/Edit Users. The View/Edit Users page appears
(see Figure 16).
Figure 16. Selection Fields in the View/Edit Users Page
2. From the drop-down lists, select search criteria.
3. Optional: Refine your search by specifying an email address, first name, or last name.
4. Click Search. TIDE displays the found users at the bottom of the View/Edit Users page (see
Figure 17).
Figure 17. Retrieved Users
17
TIDE User Guide
Managing TIDE Users
From the listing of retrieved users, you can do the following:

View detailed information about a user; see Viewing and Editing User Details.

Delete user accounts; see Deleting User Accounts.

Sort the listing; see Sorting Retrieved Records.

Export the listing; see Appendix A, Exporting Retrieved Records.
Viewing and Editing User Details
You can view and modify detailed information about a user’s TIDE account. For a list of user
roles that can perform this task, see Table 2.
To view and edit user details:
1. Retrieve the user account you want to view or edit by following the procedure in the
section Retrieving User Accounts.
2. In the listing of retrieved users, click View corresponding to the user whose account you
want to view (see Figure 17). The Edit User page appears (see Figure 18).
Figure 18. Edit User Page
3. If your user role allows it, modify the user’s details as required. Use Table 3 as a reference.
18
TIDE User Guide
Managing TIDE Users
4. Click Save.
5. To return to the listing of user accounts, click Go Back to Search Results. (Do not use your
browser’s Back button to return to the listing.)
Table 3 describes the fields in the View User Details page.
Table 3. Fields in the View User Details Page
Field
Description
District
District associated with the user. To modify the district, you must delete
and then add the user. For details, see Deleting User Accounts and
Adding User Accounts. (This field does not appear for school-level
users.)
School
School associated with the user. To modify the school, you must delete
and then add the user. For details, see Deleting User Accounts and
Adding User Accounts. (This field does not appear for district-level
users.)
Username
Email address for logging in to TIDE.
First Name
User’s first name.
Last Name
User’s last name.
Phone
User’s phone number.
19
TIDE User Guide
Managing TIDE Users
Adding User Accounts
When you add a user account, its role must be lower in the hierarchy than your role. (For an
explanation of the user role hierarchy, see Understanding User Roles and Permissions.)
Referring to Figure 2, school test coordinators can add teachers and test administrators, and
district administrators can add all user roles. Furthermore, you can add only those users that
fall within your institution. For example, district-level users can create school-level accounts
only for schools within their district.
For a list of user roles that can perform this task, see Table 2.
To add a user account:
1. Click the Manage Users tab, then click Add Users. The Add Users page appears.
Figure 19. Form Fields in the Add Users Page
2. Select the required role, district, and school (for school-level users) associated with the new
user.
3. Using Table 3 as a reference, enter the user’s email address, first name, last name, and
other details in the optional fields.
4. Click Add User.
TIDE adds the account and sends the new user an activation email from [email protected].
20
TIDE User Guide
Managing TIDE Users
Deleting User Accounts
For a list of user roles that can perform this task, see Table 2.
To delete user accounts:
1. Retrieve the user accounts you want to delete by following the procedure in the section
Retrieving User Accounts.
2. In the View/Edit Users page, do one of the following (see Figure 14):
o Mark the checkbox for the accounts you want to delete.
o Mark the checkbox at the top of the table to delete all retrieved user accounts.
3. Click Delete.
4. In the confirmation dialog box, click OK.
TIDE deletes the user accounts.
Adding, Editing, or Deleting Users through File Uploads
If you have many users to add, edit, or delete, it may be easier to perform those transactions
through file uploads. This task requires familiarity with composing comma-separated value
(CSV) files or working with Microsoft Excel. The following sections describe how to compose the
files and then upload them to TIDE.
Understanding the User Upload File Format
The upload file is an Excel or CSV file with a heading row and data rows. Table 4 describes the
columns in the upload file and associated valid values.
Table 4: Columns in the User Upload File
Column
Description
Valid Values
District ID*
District associated with the user.
District ID that exists in TIDE. Up
to 30 characters.
School ID
School associated with the user.
School ID that exists in TIDE. Up
to 30 characters. Must be
associated with the district ID.
Can be blank when adding
district-level users.
FirstName*
User’s first name.
Up to 35 characters.
LastName*
User’s last name.
Up to 35 characters.
21
TIDE User Guide
Managing TIDE Users
Column
Description
Valid Values
Email*
User’s email address.
Any standard email address. Up
to 128 characters that are valid
for an email address. This is the
user’s username for logging in to
TIDE.
Phone
User’s phone number.
Phone number in xxx-xxx-xxxx
format.
Role*
User’s role. For an explanation of user
roles, see Understanding User Roles
and Permissions.
One of the following:
DA—District administrator.
DC—District test coordinator.
SC—School test coordinator.
TE—Teacher.
TA—Test administrator.
Action*
Indicates if this is an add, modify, or
delete transaction.
One of the following:
Add—Add new user or edit
existing user record.
Delete—Remove existing user
record.
*Required field.
22
TIDE User Guide
Managing TIDE Users
Figure 20 is an example of a simple upload file with the following transactions:

The first row adds Thomas Walker as a TIDE user, specifying all fields except phone number.

The second row modifies Thomas Walker’s account, changing his role and adding the phone
number. In this case you must list values in all other columns, even if you do not change
them.

The third row deletes Thomas Walker’s account.

The fourth row adds Patricia Martin as a test administrator for school 9000.

The fifth row adds Patricia Martin as a school test coordinator for a different school—9001.
Figure 20. Sample User Upload File
Submitting a User Upload File
This section describes how to upload a file for adding, modifying, or deleting users. For a list of
user roles that can perform this task, see Table 2.
To submit a user upload file:
1. Click the Manage Users tab, then click Upload Users. The Upload Users page appears.
2. Download one of the file templates by clicking Download Excel Template or Download CSV
Template.
3. Open the file in a spreadsheet application or text editor, and add a row for each user you
want to add, modify, or delete. Be sure to follow the guidelines in Table 4. Save the file on
your computer.
4. In the Upload Users page, click Browse, and navigate to the file you created in step 3.
23
TIDE User Guide
Managing TIDE Users
5. Click Upload File. TIDE displays a preview of the uploaded file (see Figure 21). Use this
preview to verify you uploaded the correct file.
Figure 21. User Upload File Preview
6. Click Next. TIDE validates the file and displays error messages, if any. For information about
resolving error messages, see Resolving File Upload Errors.
NOTE: Validation and commitment of large files If your file contains a large number of
records, TIDE processes it offline and sends you a confirmation email when complete. While
TIDE is validating the file, do not press Cancel as TIDE may have already started processing
some of the records. For more information, see How TIDE Processes Large Files.
7. Click Commit. TIDE commits those records that do not have errors.
You can view a history of file uploads; see the section Reviewing Upload History for details.
24
Section V. Working with Student Information
This section describes how to add, modify, and delete students’ records, and how those records
affect testing and reporting.
Retrieving Student Records
You can retrieve up to 5,000 student records that satisfy given criteria. For a list of user roles
that can perform this task, see Table 2.
To retrieve student records:
1. Click the Student Information tab, then click View/Edit Students. The View/Edit Students
page appears (see Figure 22).
Figure 22. Selection Fields in the View/Edit Students Page
2. From the drop-down lists and in the text boxes, enter search criteria.
3. Optional. To refine your search, do the following:
a. Click Add Additional Search Criteria. Additional search fields appear (see Figure 23).
Figure 23. Additional Student Search Criteria (Form Fields)
25
TIDE User Guide
Working with Student Information
b. Make selections for the additional search criterion, and then click Add Criteria. TIDE
displays the criterion in the View/Edit Students page (see Figure 24).
Figure 24. Additional Student Search Criteria (Displayed)
Standard
search
criteria
Additional
search
criteria
c. Repeat steps a–b to add additional search criteria.
d. To delete an additional search criterion, click X next to it.
4. Click Search. TIDE displays the retrieved students at the bottom of the View/Edit Students
page (see Figure 25).
Figure 25. Retrieved Students (partial view)
26
TIDE User Guide
Working with Student Information
From the listing of retrieved students, you can do the following:

View and edit detailed information about a student; see


Viewing and Editing Students.

Print testing tickets and PreID labels; see Printing Testing Tickets.

Sort the listing; see Sorting Retrieved Records.

Export the listing; see Appendix A, Exporting Retrieved Records.
27
TIDE User Guide
Working with Student Information
Viewing and Editing Students
You can view and edit detailed information about a student’s record. For a list of user roles that
can perform this task, see Table 2.
Text-to-Speech for Passages and Print-on-Demand can only be set by a district-level user.
SCs may work with all other appropriate test settings.
To view and edit student details:
1. Retrieve the student record you want to view or edit by following the procedure in the
section Retrieving Student Records.
2. In the listing of retrieved records, click View corresponding to the student whose record you
want to view (see Figure 25). The View Student Details page appears (see Figure 26).
Figure 26. View Student Details Page (Top Portion)
3. If your user role allows it, modify the student’s record as required. Use Table 5 as a
reference.
4. Click Save.
28
TIDE User Guide
Working with Student Information
5. To return to the listing of student accounts, click Go Back to Search Results. (Do not use
your browser’s Back button to return to the listing.)
Table 5 describes the fields in the View Student Details page.
Table 5. Fields in the View Student Details Page
Field
Description
School IRN
Internal Retrieval Number (IRN) of school where student is enrolled.
Student Demographics
Reporting District
ID of district in which student is enrolled.
Reporting School
ID of school in which student is enrolled.
Last Name
Student’s last name.
First Name
Student’s first name.
Birth Date (MMDDYYYY)
Student’s date of birth.
Middle Name
Student’s middle name.
SSID
Student’s State Student Identifier (SSID) within the enrolled district.
Confirmation Code
Code used to authenticate the student at testing time.
User Defined Name 2
Free-text field for supplementary information about the student.
User Defined Name 1
Free-text field for supplementary information about the student.
Resident Town Code
Connecticut’s code for the town where the student resides.
Grade Level When
Assessed
Grade in which student is enrolled during the test administration.
Gender
Student’s gender.
Paper Tester
Indicates if the student’s school is testing with paper-pencil in one or
more subjects where an online test is available.
IDEA Indicator
Student’s Special Education program status.
LEP Status
Student’s LEP status.
Section 504
Student’s 504 status.
Economic Disadvantage
Status
Student’s economic status.
Language Code
The primary language spoken by the student.
English Language
Proficiency Level
Student’s English-language proficiency status.
Migrant Status
Student’s migrant status.
29
TIDE User Guide
Working with Student Information
Field
Description
First Entry Date into a US
School
Student’s first day of school (ELL students only).
LEP Entry Date
Student’s English Proficiency entry date, if applicable.
LEP Exit Date
Student’s English Proficiency exit date, if applicable.
Title III Language
Instruction Program Type
Student’s Title III language status.
Primary Disability Type
Student’s primary disability.
Race and Ethnicity
Hispanic or Latino
A student of Cuban, Mexican, Puerto Rican, South or Central American,
or other Spanish culture or origin, regardless of race.
American Indian or Alaska
Native
A student having origins in any of the original peoples of North America
and South America (including Central America) and who maintains tribal
affiliation or community attachment.
Asian
A student having origins in any of the original peoples of the Far East,
Southeast Asia, or the Indian Subcontinent. This area includes, for
example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the
Philippine Islands, Thailand, and Vietnam.
Black or African American
A student having origins in any of the black racial groups of Africa.
White
A student having origins in any of the original peoples of Europe, the
Middle East, or North Africa.
Native Hawaiian or Other
Pacific Islander
A student having origins in any of the original peoples of Hawaii, Guam,
Samoa, or other Pacific Islands.
Interim Testing Grade
<subject>
Grade at which the student is tested during the upcoming interim test.
For example, marking the Grade 4 checkbox under the Mathematics
subject indicates the student receives the fourth-grade mathematics
interim test.
Test Settings
Non-Embedded Designated Supports
ELA
Designates the non-embedded designated supports available to students
for English-language arts tests.
ELPT
Designates the non-embedded designated supports available to students
for performance tasks.
Mathematics
Designates the non-embedded designated supports available to students
for mathematics tests.
30
TIDE User Guide
Field
Working with Student Information
Description
Color Contrast
ELA
Student’s color contrast designation for English-language arts tests.
ELPT
Student’s color contrast designation for performance tasks.
Mathematics
Student’s color contrast designation for mathematics tests.
Masking
ELA
Designates if masking is available for English-language arts tests.
ELPT
Designates if masking is available for performance tasks.
Mathematics
Designates if masking is available for mathematics tests.
Permissive Mode
ELA
Designates if permissive mode is allowed for English-language arts tests.
ELPT
Designates if permissive mode is allowed for performance tasks.
Mathematics
Designates if permissive mode is allowed for mathematics tests.
Print Size
ELA
Designates if zoom is permissible for English-language arts tests.
ELPT
Designates if zoom is permissible for performance tasks.
Mathematics
Designates if zoom is permissible for mathematics tests.
Translations (Glossary)
ELA
Designates the glossaries available for English-language arts tests.
ELPT
Designates the glossaries available for performance tasks.
Mathematics
Designates the glossaries available for mathematics tests.
Language (Designated Supports and Accommodations)
ELA
Designates the languages available for English-language arts tests.
ELPT
Designates the languages available for performance tasks.
Mathematics
Designates the languages available for mathematics tests.
Text-to-Speech (Designated Supports and Accommodations)
ELA
Designates the text-to-speech options available for English-language arts
tests.
ELPT
Designates the text-to-speech options available for performance tasks.
Mathematics
Designates the text-to-speech options available for mathematics tests.
31
TIDE User Guide
Field
Working with Student Information
Description
American Sign Language
ELA
Designates if American Sign Language is available for English-language
arts tests.
ELPT
Designates if American Sign Language is available for performance
tasks.
Mathematics
Designates if American Sign Language is available for mathematics
tests.
Print on Demand
ELA
Designates if print-on-demand is available for English-language arts
tests.
ELPT
Designates if print-on-demand is available for performance tasks.
Mathematics
Designates if print-on-demand is available for mathematics tests.
Close Captioning
ELA
Designates if closed captioning is available for English-language arts
tests.
Non-Embedded Accommodations
ELA
Designates the non-embedded accommodations available to students
outside of Test Delivery System for English-language arts tests.
ELPT
Designates the non-embedded accommodations available to students
outside of the Test Delivery System for performance tasks.
Mathematics
Designates the non-embedded accommodations available to students
outside of the Test Delivery System for mathematics tests.
Streamlined
ELA
Designates if streamlined-mode is available for English-language arts
tests.
ELPT
Designates if streamlined-mode is available for performance tasks.
Mathematics
Designates if streamlined-mode is available for mathematics tests.
Performance Tasks
ELA
ELA Classroom activity assigned to the student. For more information
about classroom activities, see Section VI: Working with Classroom
Activities
MA
Mathematics Classroom activity assigned to the student. For more
information about classroom activities, see Section VI: Working with
Classroom Activities
32
TIDE User Guide
Working with Student Information
Moving Students Between Schools
When a student is moved to a new school and the SchoolID changes, the student’s classroom
activity assignment updates to that for the new school. If you previously assigned that student a
particular classroom activity, you need to reassign that activity after the move. For details, see
Modifying Classroom Activities.
Printing Testing Tickets
A testing ticket is a hardcopy form that includes a student’s username and confirmation code
for logging in to a test. Referring to the example Figure 27, the student’s username for testing is
8894651001, and the confirmation code is 09-UI&^.
Figure 27. Sample Testing Ticket
TIDE generates the test tickets as PDF files that you download with your browser.
To print test ticket labels:
1. Retrieve the students for whom you want to print test tickets by following the procedure in
the section Retrieving Student Records.
2. Click the column headings to sort the retrieved students in the order you want the test
tickets printed. (For information about sorting, see Sorting Retrieved Records).
3. Do one of the following (see Figure 14):
o Mark the checkboxes for the students you want to print.
o Mark the checkbox at the top of the table to print tickets for all retrieved students.
33
TIDE User Guide
Working with Student Information
4. Click Print Test Tickets.
Your browser downloads the generated PDF file.
Printing PreID Labels
A PreID label is a label that you affix to a student’s testing materials, such as an answer booklet.
Referring to the example in Figure 28, the student’s name, SSID, and identifying bar code
appear on the label. The test administrator affixes this label to the student’s answer booklet.
Figure 28. Sample PreID Label
TIDE generates the labels as PDF files that you download with your browser. See Table 2 for a
list of users who can perform this task.
To print PreID labels:
1. Retrieve the students for which you want to print tickets or labels by following the
procedure in the section Retrieving Student Records.
2. Click the column headings to sort the retrieved students in the order by which you want
them printed. (For information about sorting, see Sorting Retrieved Records.)
3. Do one of the following (see Figure 14):
o Mark the checkboxes for the students you want to print.
o Mark the checkbox at the top of the table to print labels for all retrieved students.
34
TIDE User Guide
Working with Student Information
4. Establish the start position for printing on the first page by doing the following:
a. Hover over the PreID Labels button, and click Download PreID Labels Template (see
Figure 29). Your browser downloads a PDF indicating the available start positions for
printing (see Figure 30).
Figure 30. Label Template (partial view)
Figure 29. Menu from the PreID Labels button
b. Using the downloaded template, identify the starting position. For example, 1 indicates
the top-left corner of the label sheet, and 2 indicates the top-right corner.
c. Again hover over the PreID Labels button; from the Select start position drop-down list,
select the number you determined in step 4.b.
This start position applies only to the first page of labels. For all subsequent pages, the
printing starts in position 1, the top-left corner.
5. Hover over the PreID Labels button, and click Print PreID Labels.
Your browser downloads the generated PDF file.
Uploading Test Settings
If you have many students for whom you need to apply test settings, it may be easier to
perform those transactions through file uploads. This task requires familiarity with composing
comma-separated value (CSV) files or working with Microsoft Excel. The following sections
describe how to compose the files and then upload them to TIDE.
35
TIDE User Guide
Working with Student Information
Understanding the Test Settings Upload File Format
The upload file is an Excel or CSV file with a heading row and data rows. Table 6 describes the
columns in the upload file and associated valid values.
Table 6: Columns in the Test Settings Upload file.
Column Name
Description
Valid Values
SSID*
State-assigned student
identifier which is unique
within that district.
Up to 30 alphanumeric characters.
Must exist in TIDE.
PrintSize:<subject>
Student’s print-size
accommodation for tests in
the indicated subject. For
example, the column
PrintSize:ELA indicates the
print size for tests in Englishlanguage arts.
One of the following:
TDS_PS_L0—No magnification, 14 pt.
TDS_PS_L1—1.5 magnification, 21 pt.
TDS_PS_L2—1.75 magnification,
24.5 pt.
TDS_PS_L3—2.5 magnification, 35 pt.
TDS_PS_L4—3.0 magnification, 42 pt.
If blank, text appears as 14 point.
ColorContrast:<subject>
Color of text and background
for tests in the indicated
subject. For example, the
column ColorContrast:ELA
indicates the color for tests in
English-language arts.
One of the following:
TDS_CC0—Black on white.
TDS_CCInvert—White on black.
TDS_CCMagenta—Black on rose.
TDS_CCMedGrayLtGray—Medium gray
on light gray.
TDS_CCYellowB—Yellow on Blue.
If blank, test appears as black text on
white background.
Masking:<subject>
PermissiveMode:<subject>
Masking setting for tests in
the indicated subject. For
example, the column
Masking:ELA indicates the
masking setting for tests in
English-language arts.
One of the following:
Permissive mode setting for
tests in the indicated subject.
For example, the column
Permissive Mode:ELA
indicates the permissive
mode setting for tests in
English-language arts.
One of the following:
TDS_Masking0—Masking is not
available.
TDS_Masking1—Masking is available.
If blank, masking is turned off.
TDS_PM1—Students can use
accessibility software during tests,
such as screen readers or magnifiers.
TDS_PM0—Students can use only the
secure browser during tests.
If blank, permissive mode is off.
36
TIDE User Guide
Working with Student Information
Column Name
Description
Valid Values
StreamlinedMode:
<subject>
Streamlined interface setting
for tests in the indicated
subject. For example, the
column Streamlined
Interface:ELA indicates the
streamlined interface setting
for tests in English-language
arts.
One of the following:
Student’s text-to-speech
accommodation for tests in
the indicated subject. For
example, the column
TexttoSpeech:ELA indicates
the text-to-speech
accommodation for tests in
English-language arts.
One of the following:
TTS:<subject>
TDS_SLM1—Streamlined interface is
available.
TDS_SLM0—Streamlined interface is
not available.
If blank, streamlined interface is not
available.
TDS_TTS0—TTS not available.
TDS_TTS_Item—Enable TTS for test
items.
TDS_TTS_Stim—Enable TTS for test
stimuli.
TDS_TTS_Stim&TDS_TTS_Item—
Enable TTS for test items and stimuli.
If blank, TTS is not available.
Language:<subject>
ASL:<subject>
Language in which the tests
in the indicated subject
appear. For example, the
column Language:ELA
indicates the language
setting for tests in Englishlanguage arts. Not all
languages are available for
all tests.
One of the following:
Student’s ASL
accommodation for test in the
indicates subject. For
example, the column
ASL:ELA indicates the ASL
setting for tests in Englishlanguage arts.
One of the following:
37
ENU—English.
ENU-Braille—Braille.
ESN—Spanish.
If blank, tests appear in English.
TDS_ASL0—ASL videos not available.
TDS_ASL1—ASL videos available.
If blank, ASL videos are not available.
TIDE User Guide
Working with Student Information
Column Name
Description
Valid Values
Translation (Glossary):
<subject>
Student’s glossary
accommodation for tests in
the indicated subject. For
example, the column
Translation (Glossary):ELA
indicates the glossary
available for tests in Englishlanguage arts.
The following glossaries are available
for all subjects:
TDS_WL0—Glossary not available.
TDS_WL_Glossary—Word-list glossary
available.
The following additional glossaries are
available for mathematics:
TDS_WL_ArabicGloss
TDS_WL_CantoneseGloss
TDS_WL_ESNGlossary
TDS_WL_KoreanGloss
TDS_WL_MandarinGloss
TDS_WL_PunjabiGloss
TDS_WL_RussianGloss
TDS_WL_TagalGloss
TDS_WL_UkrainianGloss
TDS_WL_VietnameseGloss
TDS_WL_ArabicGloss&TDS_WL_Gloss
ary
TDS_WL_CantoneseGloss&TDS_WL_Gl
ossary
TDS_WL_ESNGlossary&TDS_WL_Gloss
ary
TDS_WL_KoreanGloss&TDS_WL_Gloss
ary
TDS_WL_MandarinGloss&TDS_WL_Glo
ssary
TDS_WL_PunjabiGloss&TDS_WL_Glos
sary
TDS_WL_RussianGloss&TDS_WL_Glos
sary
TDS_WL_TagalGloss&TDS_WL_Glossa
ry
TDS_WL_UkrainianGloss&TDS_WL_Gl
ossary
TDS_WL_VietnameseGloss&TDS_WL_G
lossary
If blank, glossaries are not available.
38
TIDE User Guide
Working with Student Information
Column Name
Description
Valid Values
ClosedCaptioning:
<subject>
Student’s closed-captioning
accommodation for tests in
the indicated subject. For
example, the column Closed
Captioning:ELA indicates the
closed-captioning setting for
tests in English-language
arts.
One of the following:
39
TDS_ClosedCap0—Closed captioning
not available.
TDS_ClosedCap1—Closed captioning
available.
If blank, closed captioning is not
available.
TIDE User Guide
Working with Student Information
Column Name
Description
Valid Values
Non-Embedded Designated
Supports:<subject>
Student’s non-embedded
designated supports (NEDS)
accommodation for tests in
the indicated subject. For
example, the column NonEmbedded Designated
Supports:ELA indicates the
NEDS setting for tests in
English-language arts.
The following NEDSs are available for
all subjects:
NEDS0—No supports available.
NEDS_CC—Color contrast.
NEDS_CO—Color overlay.
NEA_NoiseBuf—Ear mufflers, white
noise, or other equipment used to
block external sounds.
NEDS_Mag—Magnification.
NEDS_RA_Items—Read-aloud for test
items.
NEDS_SC_Items—Scribe items.
NEDS_SS—Separate setting.
NEDS_TransDirs—Translated testing
directions.
The following additional NEDSs are
available for Non-Embedded
Designated Supports: ELA-PT:
NEDS_BD—Bilingual dictionary.
NEDS_RA_Stimuli—Read-aloud for
test stimuli.
The following additional NEDSs are
available for Non-Embedded
Designated Supports: Mathematics:
NEDS_RA_Stimuli—Read-aloud for
test stimuli.
NEDS_TArabic—Arabic translation.
NEDS_TCantonese—Cantonese
translation.
NEDS_TFilipino—Filipino translation.
NEDS_TKorean—Korean translation.
NEDS_TMandarin—Mandarin
translation.
NEDS_TPunjabi—Punjabi translation.
NEDS_TransDirs—Translated test
directions.
NEDS_TRussian—Russian translation.
NEDS_TSpanish—Spanish translation.
NEDS_TUkrainian—Ukrainian
translation.
NEDS_TVietnamese—Vietnamese
translation.
If blank, no NEDSs are available.
40
TIDE User Guide
Working with Student Information
Column Name
Description
Valid Values
Non-Embedded
Accommodations:
<subject>
Student’s non-embedded
accommodations (NEA) for
tests in the indicated subject.
For example, the column
Non- Non-Embedded
Accommodations: ELA
indicates the NEA for tests in
English-language arts.
The following accommodations are
available for all subjects:
NEA0—No NEAs available.
NEA_AR—Alternate response options.
NEA_STT—Speech-to-text.
The following additional NEAs are
available for Non-Embedded
Accommodations: ELA:
NEA_RA_Stimuli—Read-aloud stimuli.
NEA_SC_WritItems—Scribe items
(writing).
The following additional NEAs are
available for Non-Embedded
Accommodations: ELA-PT:
NEA_SC_WritItems—Scribe items
(writing).
The following additional NEAs are
available for Non-Embedded
Accommodations: Mathematics:
NEA_Abacus—Abacus
NEA_Calc—Calculator
NEA_MT—Multiplication table
If blank, no NEAs are available.
Print on Demand: <subject>
Student’s print-on-demand
(POD) accommodation for
tests in the indicated subject.
For example, the column
Print on Demand: ELA
indicates the POD setting for
tests in English-language
arts.
One of the following:
TDS_PoD0—No POD.
TDS_PoD_Item—POD available for
test items.
TDS_PoD_Stim—POD available for
test stimuli.
TDS_PoD_Stim&TDS_PoD_Item—
POD available for test items and
stimuli.
If blank, no POD is not available.
*Required field.
41
TIDE User Guide
Working with Student Information
Figure 31 is an example of a simple upload file that sets print size and color contrast for the
student with ID 999999999. For English-language arts and practical tests, the print size is the
default; for mathematics, the print size is 150% magnification; for English-language arts, the
color contrast is inverted (white on black background).
Figure 31. Sample Test Settings Upload File
Submitting a Test Settings Upload File
This section describes how to upload a file for adding, modifying, or deleting test settings. For a
list of user roles that can perform this task, see Table 2.
Text-to-Speech for Passages and Print-on-Demand can only be set by a district-level user.
SCs may work with all other appropriate test settings.
To submit a test setting upload file:
1. Click the Student Information tab, then Upload Student Settings. The Upload Student
Settings page appears.
2. Download one of the file templates by clicking Download Excel Template or Download CSV
Template.
3. Open the file in a spreadsheet application or text editor, and add a row for each test setting
you want to add or modify. Be sure to follow the guidelines in Table 6. Save the file on your
computer.
4. In the Upload Student Settings page, click Browse, and navigate to the upload file you
created in step 3.
5. Click Upload File. TIDE displays a preview of the uploaded file (see Figure 32). Use this
preview to verify you uploaded the correct file.
Figure 32. Test Settings Upload File Preview (partial view)
6. Click Next. TIDE validates the file and displays error messages, if any. For information about
resolving error messages, see Resolving File Upload Errors.
42
TIDE User Guide
Working with Student Information
NOTE: Validation and commitment of large files If your file contains a large number of
records, TIDE processes it offline and sends you a confirmation email when complete. While
TIDE is validating the file, do not press Cancel as TIDE may have already started processing
some of the records. For more information, see How TIDE Processes Large Files.
7. Click Commit. TIDE commits those records that do not have errors, and sends a
confirmation email.
You can view a history of file uploads; see the section Reviewing Upload History for details.
43
Section VI. Working with Classroom Activities
A classroom activity is a performance-task assignment that introduces students to a particular
setting or situation. Students typically participate in these activities shortly before the
corresponding assessment test.
Reviewing Classroom Activities
You can review classroom activities for all grades within a particular school. For a list of user
roles that can perform this task, see Table 2.
To review classroom activities:
1. Click the PT Classroom Activities tab, then View Classroom Activities. The View
Classroom Activities page appears (see Figure 33).
Figure 33. Fields in the View Classroom Activities page
2. From the drop-down lists, select search criteria.
3. Click Show Classroom Activities. TIDE displays the found classroom activities at the
bottom of the View Classroom Activities page (see Figure 34).
Figure 34. Retrieved Classroom Activities
44
TIDE User Guide
Working with Classroom Activities
4. To view an individual classroom activity, click the corresponding link. For example,
referring to Figure 34, to view the ELA classroom activity for third-graders, click next
to G3E-Summative-Perf-LandFormations.
Modifying Classroom Activities
You can modify an individual student’s classroom activity. This is useful if a student moves from
one school to another during a semester. For example, a student starts third grade in School A
where the students have a standard activity pertaining to libraries. During the semester the
student moves to School B, where the standard activity pertains to trees. To avoid penalties for
starting the semester late in School B, you can modify the student’s classroom activity to the
library activity used in School A.
For a list of user roles that can perform this task, see Table 2.
To modify classroom activities:
1. Using the procedure described in
2.
3. Viewing and Editing Students, open the View Student Details page for the student whose
classroom activities you want to modify.
1. In the View Student Details page, scroll down to the Performance Tasks section (see Figure
35).
Figure 35. Performance Task Fields in the View Student Details Page
2. From the ELA and Mathematics drop-down lists, select the required classroom activities.
3. Click Save Changes.
45
TIDE User Guide
Working with Appeals
Section VII. Working with Appeals
In the normal flow of a test, the student takes the test in TDS and then submits it. Next, TDS
forwards the test for scoring, and then ORS reports the tests scores.
Appeals are a way of interrupting this normal flow. A student may want to re-take a test or
have another test opportunity. A test administrator may want to invalidate a test because of a
hardware malfunction or an impropriety. This section describes how you view and create
appeals.
Understanding Appeals
This section describes two aspects of appeals: the types of appeals and the statuses of appeals.
Types of Appeals
Table 7 lists the available types of appeals.
Table 7. Types of Appeals
Type
Description
Invalidations
Eliminates the test opportunity, and the student has no further opportunities for the
test. You can submit these appeals until the end of the test window.
Resets
Allows the student to restart a test opportunity, removing all responses on the test, or
allows the data entry operator to restart data entry. You can submit these appeals until
the end of the test window.
Re-opens
Re-opens a test whose window expired and the student never took the test.
Restores
Reverses a reset, restoring the student’s responses on the test when the reset was
processed.
Grace Period
Extension
Allows the student to review previously answered questions upon logging back in to
the test after expiration of the pause rule. Loss of Internet access is often the reason
for requesting a Grace Period Extension.
WARNING: Timing of resets and restores Submit resets and restores at least one day prior
to the end of a test window so that students can complete their test opportunity or so that data
entry can be completed for paper-based tests.
46
TIDE User Guide
Working with Appeals
Status of Appeals
An appeal’s status can change throughout its life cycle. Table 8 lists the available statuses. Many
of the statuses have a corresponding reason or description, which you can view in the
Comments column of the View Appeals page (see Figure 37).
Table 8. Statuses of Appeals
Appeal Status
Description of Status
Error Occurred
An error was encountered while the appeal was being processed.
Pending Approval
Appeal is pending approval.
Processed
Appeal was successfully processed and the test opportunity has been
updated.
Rejected
Appeal was rejected.
Rejected by System
Test Delivery System was unable to process the appeal.
Requires Resubmission
Appeal must be resubmitted.
Retracted
Originator retracted the appeal.
Submitted for
Processing
Appeal submitted to Test Delivery System for processing.
Available Appeals by Test Result Status
Table 9 lists the valid combinations of appeals and test statuses. For example, you can
invalidate a test that is in one of the following statuses: approved, completed, denied, expired,
paused, reported, scored, or submitted.
Table 9. Available Appeals by Test Result Status
Test
Result
Status
Invalidate a
test
Restart a
test
Re-open
Restore a
test that has
been reset
Report
Problem
with Item
Grace
Period
Extension
Approved






Completed






Denied






Expired






Paused






Pending






Processing












Reported
47
TIDE User Guide
Test
Result
Status
Working with Appeals
Invalidate a
test
Restart a
test
Re-open
Restore a
test that has
been reset
Report
Problem
with Item
Grace
Period
Extension
Review






Scored






Started






Submitted






Suspended






Invalidated






Retrieving Appeals
You can retrieve appeals that satisfy given criteria. For a list of user roles that can perform this
task, see Table 2.
To retrieve appeals:
1. Click the Appeals tab, then click View Appeals. The View Appeals page appears (see
Figure 36).
Figure 36. Selection Fields in the View Appeals Page
2. From the Select Request Type drop-down list, select the type of appeal you want to retrieve.
For a listing of available types, see Table 7.
3. From the Select Status drop-down list, select the status of the appeals you want to retrieve.
For a listing of statuses, see Table 8.
4. From the Filter By drop-down list, select a field by which you want to search.
5. If you selected something other than -All- in step 4, enter a value for the search field you
selected.
48
TIDE User Guide
Working with Appeals
6. Click Search. TIDE displays the found appeals at the bottom of the View Appeals page (see
Figure 37).
Figure 37. Retrieved Appeals
7. Optional: To review additional information about an appeal, click show comment.
Table 10 describes the fields in the View Appeals page.
Table 10. Fields in the View Appeals Page
Field
Description
Case Number
ID number associated with the appeal.
Request Type
One of the appeal types listed in Table 7.
Status
One of the status codes listed in Table 8.
Request Date
Date appeal was created.
Comments
Comment or explanation added by user who created the appeal.
SSID
Student’s SSID associated with the result.
Result ID
Result ID associated with a test opportunity. A test can have more than
one opportunity.
Student’s First Name
Student’s first name.
Student’s Last Name
Student’s last name.
Test
Name of the test associated with the appeal.
Test Opp #
Test opportunity associated with the result ID.
49
TIDE User Guide
Working with Appeals
Field
Description
Test Status
Approved—TA approved the student for the session, but the student has
not yet started or resumed the test.
Completed—Student submitted the test for scoring.
Denied—TA denied the student entry into the session. If the student
attempts to enter the session again, this status changes to Pending until
the TA approves or denies the student.
Expired—Student did not complete the opportunity, and cannot resume
the test because the test opportunity expired.
Invalidated—The test result was invalidated.
Paused—The test is currently paused as a result of one of the following:
 Student or TA clicked the Pause button on the test.
 Student or TA idled for too long and the test automatically paused.
 Test Administrator stopped the student’s session.
 Test Administrator paused the individual student’s test.
 Student’s browser or computer shut down or crashed.
Pending—Student is awaiting TA approval for a new test opportunity.
Reported—Student’s score for the completed test has been submitted to
the reporting system.
Review—Student has answered all test items and is currently reviewing
answers before submission for scoring.
Scored—Test Delivery System processed the student’s answers on the
test.
Started—Student started or resumed the test and is actively testing.
Submitted—Test was submitted for quality assurance review and
scoring before it is sent to the Online Reporting System.
Suspended—Student is awaiting TA approval to resume a test
opportunity.
Requested by
User who created the appeal.
Test Start Date
Date student started the test opportunity.
From the listing of retrieved appeals, you can do the following:

Sort the listing; see Sorting Retrieved Records.

Export the listing; see Appendix A: Exporting Retrieved Records.
50
TIDE User Guide
Working with Appeals
Creating Appeals
You can create an appeal for a given test result. For a list of user roles that can perform this
task, see Table 2.
To create appeals:
1. Retrieve the result for which you want to create an appeal by doing the following:
a. Click the Appeals tab, then click Create Appeals. The Create Appeals page appears (see
Figure 38).
Figure 38. Selection Fields in the Create Appeals Page
b. From the drop-down lists and in the text field, enter search criteria.
c. Click Search Student Results. TIDE displays the found results at the bottom of the View
Appeals page (see Figure 39).
Figure 39. Retrieved Appeals
2. For each result for which you want to create an appeal, enter the reason in the text box,
and then click Create. TIDE displays a confirmation message.
51
TIDE User Guide
Working with Appeals
Creating Appeals Through File Uploads
If you have many appeals to create, it may be easier to perform those transactions through file
uploads. This task requires familiarity with composing comma-separated value (CSV) files or
working with Microsoft Excel. The following sections describe how to compose the files and
then upload them to TIDE.
Understanding the Appeal Upload File Format
The upload file is an Excel or CSV file with a heading row and data rows. Table 11 describes the
columns in the upload file and associated valid values.
Table 11: Columns in the Appeals Upload File
Column Name
Description
Valid Values
Type*
Type of Appeal.
One of the following:
Invalidate a test
Reset a test
Re-open a test
Revert a test that's been reset
Grace period extension
Search Type*
Student field to perform a
search on.
One of the following:
Result ID
Session ID
SSID
Search Value*
Search value corresponding
to the search type.
Up to 1,000 alphanumeric characters.
The value must exist in TDS or TIDE.
For example, specifying a result ID of
123456 requires that this result ID exist
in TDS.
Reason*
Reason for creating
impropriety.
Up to 1,000 alphanumeric characters.
*Required field.
Figure 40 is an example of a simple upload file that re-opens a test with result ID 99999999.
Figure 40. Sample Appeals Upload File
52
TIDE User Guide
Working with Appeals
Submitting an Appeal Upload File
This section describes how to upload a file for adding appeals. For a list of user roles that can
perform this task, see Table 2.
To submit an appeal upload file:
1. Click the Appeals tab, then Upload Appeals. The Upload Appeals page appears.
2. Download one of the file templates by clicking Download Excel Template or Download CSV
Template.
3. Open the file in a spreadsheet application or text editor, and add a row for each appeal you
want to add. Be sure to follow the guidelines in Table 11. Save the file on your computer.
4. In the Upload Appeals page, click Browse, and navigate to the upload file you created in
step 3.
5. Click Upload File. TIDE displays a preview of the uploaded file (see Figure 41). Use this
preview to verify you uploaded the correct file.
Figure 41. Appeals Upload File Preview
6. Click Next. TIDE validates the file and displays error messages, if any. For information about
resolving error messages, see Resolving File Upload Errors.
NOTE: Validation and commitment of large files If your file contains a large number of
records, TIDE processes it offline and sends you a confirmation email when complete. While
TIDE is validating the file, do not press Cancel as TIDE may have already started processing
some of the records. For more information, see How TIDE Processes Large Files.
7. Click Commit. TIDE commits those records that do not have errors, and sends a
confirmation email.
You can view a history of file uploads; see the section Reviewing Upload History for details.
53
Section VIII. Working with Rosters of Students
Rosters are groups of students associated with a teacher in a particular school. Rosters typically
represent entire classrooms in lower grades, or individual classroom periods in upper grades.
Rosters can also represent special courses offered to groups of students.
The rosters you create in TIDE are available in the Online Reporting System. ORS can aggregate
test scores at these roster levels.
Viewing Rosters
You can view rosters associated with your district or school. For a list of user roles who can
perform this task, see Table 2.
To view a roster:
1. Click the Rosters tab, then Manage Rosters. The Manage Rosters page appears (see
Figure 42).
Figure 42. Manage Rosters Page—selection fields
2. From the District and School drop-down lists (as available), make selections for the district
and school associated with the roster you want to view.
3. From the Roster drop-down list, select the roster you want to view.
54
TIDE User Guide
Working with Rosters of Students
4. Click Next. The Manage Rosters page appears, showing a list of students in the selected
roster and the associated teacher (see Figure 43).
Figure 43. Manage Roster Page—Viewing a Roster’s Students
Adding a New Roster
You can create rosters from students associated with your school or district. For a list of user
roles who can perform this task, see Table 2.
To add a roster:
1. Click the Rosters tab, then Manage Rosters. The Manage Rosters page appears (see
Figure 42).
2. From the District and School drop-down lists, make selections for the district and school
containing the roster you want to add.
3. From the Roster drop-down list, select – ADD NEW ROSTER.
4. Click Next. The Manage Rosters page appears (see Figure 43).
5. In the Roster Name field, enter a name for the roster.
6. From the Teacher Name drop-down list, select the roster’s teacher.
7. Mark the checkboxes for all the grades from which you wish to build the roster. The names
of all the available students in the selected grades appear in the Available Students list.
55
TIDE User Guide
Working with Rosters of Students
8. Select each student you want to add to the roster, then click Move In >>. The students you
selected move from the Available Students list to the Students in This Roster list.
9. Click Save.
Modifying an Existing Roster
You can modify rosters by adding students or removing students. For a list of user roles who
can perform this task, see Table 2.
To modify a roster:
1. Click the Rosters tab, then Manage Rosters. The Manage Rosters page appears (see
Figure 42).
2. From the District, School, and Roster drop-down lists, make selections for the roster you
want to modify.
3. Click Next. The Manage Rosters page appears (see Figure 43).
4. Change the roster’s name and associated teacher as required.
5. To add students to the roster, do the following:
a. Mark the checkbox for the appropriate grade. The students associated with the grade
appear in the Available Students list.
b. From the Available Students list, select the students you want to add to the roster, then
click Move In >>.
6. To remove students from the roster, do the following:
a. From the Students in this Roster list, select the students you want to remove.
b. Click << Move Out.
7. Click Save.
Deleting a Roster
You can delete rosters created in TIDE, Online Reporting System, or Learning Point Navigator.
(This feature is not available for system-generated rosters.) For a list of user roles who can
perform this task, see Table 2.
1. Click the Rosters tab, then Manage Rosters tab. The Manage Rosters page appears (see
Figure 42).
56
TIDE User Guide
Working with Rosters of Students
2. From the District, School, and Roster drop-down lists, make selections for the roster you
want to delete.
3. Click Next. The Manage Rosters page appears (see Figure 43).
4. Click Delete.
Printing a Roster
You can print a roster. This feature is useful when you want to print test tickets. For a list of
user roles who can perform this task, see Table 2.
1. Click the Rosters tab, then Manage Rosters. The Manage Rosters page appears (see
Figure 42).
2. From the District, School, and Roster drop-down lists, make selections for the roster you
want to print.
3. Click Next. The Manage Rosters page appears (see Figure 43).
4. Click Print. A printer-friendly version of the roster appears in your browser.
Figure 44. Printer-Friendly Version of a Roster
57
TIDE User Guide
Working with Rosters of Students
Creating Rosters Through File Uploads
If you have many rosters to create, it may be easier to perform those transactions through file
uploads. This task requires familiarity with composing comma-separated value (CSV) files or
working with Microsoft Excel. The following sections describe how to compose the files and
then upload them to TIDE.
Understanding the Roster Upload File Format
The upload file is an Excel or CSV file with a heading row and data rows. Table 12 describes the
columns in the upload file and associated valid values.
Table 12: Columns in the Rosters Upload File
Column Name
Description
Valid Values
District ID*
District associated with the
roster.
District ID that exists in TIDE. Up to 10
characters.
School ID
School associated with the
roster.
School ID that exists in TIDE. Up to 10
characters. Must be associated with
the district ID.
Can be blank when adding district-level
rosters.
User Email ID*
Email address of the teacher
associated with the roster.
Email address of a teacher existing in
ORS.
Roster Name*
Name of the roster.
Up to 50 characters.
SSID*
Student’s unique identifier
within the district.
Up to 30 alphanumeric characters.
*Required field.
58
TIDE User Guide
Working with Rosters of Students
Figure 45 is an example of a simple upload file that creates a roster with two students.
Figure 45. Sample Roster Upload File

The first row does the following:
o If the roster American History does not exist in school 9999, TIDE does the following:
 Creates the roster American History.
 Associates the teacher whose email address is [email protected] with the roster.
o Adds the student ID 9999999999 to the roster American History.

The second row adds the student ID 9999999998 to the roster American History.
Submitting a Roster Upload File
This section describes how to upload a file for creating rosters. For a list of user roles that can
perform this task, see Table 2.
To submit a roster upload file:
1. Click the Rosters tab, then Upload Rosters. The Upload Rosters page appears.
2. Download one of the file templates by clicking Download Excel Template or Download CSV
Template.
3. Open the file in a spreadsheet application or text editor, and add a row for each studentroster pair you want to add. Be sure to follow the guidelines in Table 12. Save the file on
your computer.
4. In the Upload Rosters page, click Browse, and navigate to your upload file you created in
step 3.
59
TIDE User Guide
Working with Rosters of Students
5. Click Upload File. TIDE displays a preview of the uploaded file (see Figure 46). Use this
preview to verify you uploaded the correct file.
Figure 46. Roster Upload File Preview
6. Click Next. TIDE validates the file and displays error messages, if any. For information about
resolving error messages, see Resolving File Upload Errors.
NOTE: Validation and commitment of large files If your file contains a large number of
records, TIDE processes it offline and sends you a confirmation email when complete. While
TIDE is validating the file, do not press Cancel as TIDE may have already started processing
some of the records. For more information, see How TIDE Processes Large Files.
7. Click Commit. TIDE commits those records that do not have errors, and sends a
confirmation email.
You can view a history of file uploads; see the section Reviewing Upload History for details.
60
Section IX. Downloading and Installing Voice Packs
The NeoSpeech™ Juliet Voice Pack is a screen reader. Students with a text-to-speech
accommodation can use the voice pack during a test opportunity. You can download and install
the voice pack from TIDE and install it on testing computers.
For a list of user roles that can perform this task, see Table 2.
To download the voice pack:
1. Click the Voice Pack tab. The Voice Pack page appears.
2. Click Download for the voice pack you want to install. Your browser downloads the
installation file onto your computer. If you have an option to run or save the file, save it.
3. Read the installation instructions available from the Download Voice Pack page, and then
proceed with installation.
61
Appendix A. Exporting Retrieved Records
When you retrieve a group of records, such as students or users, only a few records are visible
on the page at a time. You can export all the records as a file, which may be more convenient
for viewing and analysis. TIDE exports up to 1,000 user records and up to 5,000 student
records; there is no limit on exports of other records, such as orders or appeals.
For a list of user roles that can perform this task, see Table 2.
To export retrieved records:
1. Optional: In the list of retrieved records (see, for example, Figure 25), mark the checkboxes
next to the records you want to export. You can select all the records by clicking the
checkbox in the header next to View.
2. Above the list of retrieved records, hover the mouse over Export. A list of export options
appears (see Figure 47).
Figure 47. Export Options
3. Referring to Table 13, click the desired export option.
4. Depending on your browser’s configuration, you can save the file to disk or open it directly
in a spreadsheet application.
Table 13. Export Options
Option
Description
Export all to Excel
Exports all retrieved records in xlsx format. Use this format if you have
Excel 2007 or later.
Export selected to Excel
Exports selected records in xlsx format. Use this format if you have Excel
2007 or later.
Export all to CSV
Exports all retrieved records in CSV format. Use this format if you have
Excel 2003 or earlier.
Export selected to CSV
Exports selected records in CSV format. Use this format if you have
Excel 2003 or earlier.
62
TIDE User Guide
Exporting Retrieved Records
63
Appendix B. Processing File Uploads
This appendix describes how TIDE processes file uploads.
How TIDE Processes Large Files
If your file contains a large number of records, TIDE processes it offline. TIDE displays a page
with your name and default email address, and prompts you to provide a phone number and
optional alternate email. When TIDE finishes validating the file, you receive a confirmation
email. When TIDE finishes committing the records to its databases, you receive a second
confirmation email.
Table 14 lists the various upload files and the number of records in those files that triggers
offline processing. For example, if your user upload file contains 1,000 records or more, TIDE
processes that file offline.
Table 14. Record Thresholds for Offline Processing
Upload File
Offline Processing Threshold
Users
1,000
Students
2,000
Test Settings
1,000
Appeals
2,000
Rosters
1,000
How TIDE Validates File Uploads
After you submit an upload file, TIDE applies two validations: layout and data.

Layout validation determines if the records have proper format. This includes checks for
alphanumeric or numeric-only values and record length. For example, if the SSID field in the
student upload file is numeric only, and a record has a letter in that field, the record does
not pass layout validation.

Data validation determines if the fields contain valid data. For example, if a record in the
student upload file contains a school ID that does not exist in TIDE, the record does not pass
data validation.
If TIDE displays validation errors, you can resolve them by following the recommendations in
Resolving File Upload Errors.
64
TIDE User Guide
Processing File Uploads
Resolving File Upload Errors
During validation, TIDE displays messages for the errors it detects, as in the example in
Figure 48.
Figure 48. Sample Error Messages
The first column in the table of error messages shows an icon that indicates the error’s severity.
Table 15 describes those icons and associated resolutions.
Table 15. File Upload Error Icons and Resolutions
Icon
Description
Resolution
Indicates the record causes
the entire upload file to fail.
Click Cancel to abort the file upload. Make the indicated
correction, and upload the file again.
Indicates TIDE ignores the
record due to an error.
One of the following:
 Click Commit to submit all records that have no errors.
Repair those records that have errors and submit them in
a separate file.
 Click Cancel to abort the file upload. Make the indicated
corrections, and upload the file again.
Warning that the record has
an error; TIDE accepts it
anyway.
One of the following:
 Click Commit to submit all records that have warnings.
Review the warning messages, repair the records as
necessary, and upload them again in a separate file.
 Click Cancel to abort the file upload. Make the indicated
correction, and upload the file again.
Table 16 describes the columns appearing in the error messages report.
Table 16. Columns in the Error Messages report
Column Name
Description
Record Number
Line in the upload file where the error occurred.
Field Name
Name of the column in which the error occurred.
Field Value
Value that caused the error.
Validation Message
Message describing the error.
If you are unable to resolve file upload errors, contact user support; see Appendix D, User
Support for contact information.
65
TIDE User Guide
Processing File Uploads
Reviewing Upload History
You can review the log file that TIDE retains of your file uploads.
To display file upload history:

In the upload file page, click show history.
Table 17 describes the columns appearing in the upload history.
Table 17. Columns in Upload History
Column Name
Description
File Name
Name of uploaded file. Clicking this field downloads the .txt
file that was originally uploaded by the district.
Date Uploaded
Date and time file was uploaded.
Status
Upload file’s processing status. One of the following:
Error—TIDE rejected the entire file before processing it.
Started—TIDE successfully received uploaded the file.
In Process—TIDE recorded an entry in the database that
the file was received; the file is in queue awaiting
processing.
UI Validated—There were up to n records in the file, and
TIDE displayed the validation results for those n records in
the file upload page. The value for n depends on the type of
file uploaded; see Table 14 for details.
Offline Validated—There were more than n records in the
file; TIDE displayed validation results for the first n records
in the file upload page, and displayed results for the
remaining records in an email to the user who uploaded the
file. The value for n depends on the type of file uploaded;
see Table 14 for details.
Rejected—TIDE rejected the file due to too many validation
errors.
Processed—TIDE processed the file, reporting errors as
necessary.
Record Processed
Number of records in the upload file. For quality control
purposes, you can compare this number with the actual
number of records in the file you created. Clicking the link in
this field downloads a CSV file containing the processed
records.
Record Rejected
Number of records that TIDE rejected. Clicking the link in
this field downloads a .txt file containing the rejected
records.
66
TIDE User Guide
Processing File Uploads
Column Name
Description
Validation Log
Link to a copy of the validation log. The log contains
informational and error messages. Each error message
includes a severity code, offending line number in the
upload file, error text, offending field, and offending value.
67
Appendix C. Opening CSV Files in Excel 2007 or
Later
This appendix explains how to open comma-separated value (CSV) files in Microsoft Excel 2007
or later.
1. Open Microsoft Excel.
2. On the Data tab, in the Get External Data
group, click From Text. The Import Text File
dialog box appears.
3. Navigate to the CSV file, and click Import.
The Text Import Wizard appears.
4. In Step 1 of the wizard, mark Delimited, and
click Next.
5. In Step 2 of the wizard, mark Comma, and
then click Next.
68
TIDE User Guide
Opening CSV Files in Excel 2007 or Later
6. In Step 3 of the wizard, do the following:
a. In the Data Preview section, click a
column. Excel shades the column with a
black background.
b. In the Column Data Format section, mark
the Text radio button. This setting
preserves leading zeros that can appear
in fields such as SSID or District ID.
c. Repeat steps a–b for all columns in the
CSV file.
d. Click Finish.
Excel imports and displays the CSV file.
69
Appendix D. User Support
For additional information and assistance in using TIDE, contact the Connecticut Smarter
Balanced Assessments Help Desk.
The Help Desk is open Monday–Friday 7:00 a.m. to 4:00 p.m. Eastern Time outside of the
testing window, and Monday–Friday 7:00 a.m. to 7:00 p.m. Eastern Time during testing (except
holidays or as otherwise indicated on the Connecticut Assessment Portal).
Connecticut Smarter Balanced Assessments Help
Desk
Toll-Free Phone Support: 1-844-202-7583
Email Support: [email protected]
Please provide the Help Desk with a detailed description of your problem, as well as the
following:

If the issue pertains to a student, provide the SSID and associated district or school for that
student. Do not provide the student’s name.

If the issue pertains to a TIDE user, provide the user’s full name and email address.

Any error messages that appeared.

Operating system and browser information, including version numbers (e.g., Windows 7
and Firefox 13 or Mac OS 10.7 and Safari 5).
70
TIDE User Guide
Appendix E. Change Log
Change
Change Log added
New section pertaining to
performance-task activities.
Clarified limits on number of
records TIDE retrieves or
exports.
Section
Date
Appendix E
3/2/15
Section VI Working with
3/2/15
Classroom Activities
Retrieving User Accounts
3/2/15
Retrieving Student Records
Appendix A Exporting Retrieved
Records
Noted that modifying a school Moving Students Between
3/2/15
or grade changes student’s
Schools
classroom activity.
Updated User Roles to include Table 2. User Roles and
3/2/15
Classroom Activities
Associated Permissions
Updated TIDE login screenshots Activating Your TIDE Account 3/6/15
Updated Masking default
Table 6: Columns in the Test
3/23/15
information
Settings Upload file.
Updated Pre-ID label
Figure 28. Sample PreID Label 3/23/15
screenshot
Added Classroom Activity field Table 5. Fields in the View
4/3/15
Student Details Page
Updated changing password
Changing Your Account
4/3/15
functionality
Information
Added steps to printing pre-ID Printing PreID Labels
4/3/15
labels section
New section defining available Available Appeals by Test
4/3/15
appeals
Result Status
Refined definitions for Restore Table 7. Types of Appeals
4/3/15
and Reset
Print-on-Demand and TTS for Table 2
4/10/15
passages can only be set at the Viewing and Editing Students
district-level
Uploading Test Settings
71