{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Information","User Roles","User Upload File Specifications","User_File_Upload","HiddenValidationData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["User Assignment Batch Upload Instructions","Additional Information"]
["Use this file to upload both required and optional information for the organization's users via the template found on the [User_File_Upload] tab. Use the template to assign, remove, change, and upload the organization's users in a batch.\n\nThese roles can be set in the Test Operations Management System (TOMS) by a local educational agency (LEA) English Language Proficiency Assessments for California (ELPAC) coordinator or site ELPAC coordinator; or California Assessment of Student Performance and Progress (CAASPP) coordinator or site CAASPP coordinator. Note that the values in the Role field must be matched exactly if submitting users via the template.\n\nThe specifications for the user upload template are found in the [User Upload File Specifications] tab of this Excel spreadsheet.\n\nTo make changes to uploaded data generated in TOMS, select the [Users] button in the top navigation bar, and then select the [View & Edit] action tab to first search and then edit users.\n","The LEA ELPAC coordinator or LEA CAASPP coordinator should direct any questions regarding this template to the LEA’s Success Agent."]

{"sheet":"User Roles","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Role In Organization","Definition","Roles That Can Add"]
["Site ELPAC Coordinator","This role identifies and trains all relevant site staff, assigns users at site level, coordinates site test security, performs response and score entry in Data Entry Interface (DEI) or the Teacher Hand Scoring System (THSS), and prints individual Initial ELPAC Student Score Reports (SSRs). Users with this role can be added to a school only.","• LEA ELPAC coordinator"]
["ELPAC Test Examiner","This role administers ELPAC assessments to students (including the audio files), ensures test session security, performs response and score entry in the DEI or the THSS, and prints individual Initial ELPAC SSRs. Users with this role can be added to a school only.","• LEA ELPAC coordinator\n• Site ELPAC coordinator"]
["LS Correspondence Administrator","This role performs response and score entry in the DEI or the THSS, prints Initial ELPAC SSRs individually or in a batch, and exports student results to merge into a parent/guardian notification letter. Users with this role can be added to an LEA only.","• LEA ELPAC coordinator"]
["LS Data Entry","This role performs response and score entry in the DEI or the THSS and prints individual Initial ELPAC SSRs. Users with this role can be added to a school only","• LEA ELPAC coordinator"]
["Site CAASPP Coordinator","This role identifies and trains all relevant site staff, assigns users at the site level, coordinates site test security, prints individual CAASPP SSRs, and enters student responses in the DEI. Users with this role can be added to a school only.","• LEA CAASPP coordinator"]
["CAASPP Test Administrator","This role administers standard summative, interim, practice, and training tests to students; confirms student test settings in the Test Administrator Interface; and ensures test session security. The user accesses the Interim Assessment Hand Scoring System, Completion Status Reports and California Educator Reporting System (CERS) assessment results for students in an associated student roster, and enters student responses in the DEI. Rosters of students are created and assigned to the test administrator user by the LEA CAASPP coordinator or site CAASPP coordinator. Note that unless the test administrator has been assigned to a student roster, the test administrator cannot access any student results in the CERS.","• LEA CAASPP coordinator\n• Site CAASPP coordinator"]
["CAASPP Test Examiner","This role administers alternate and standard summative assessments and interim, practice, and training tests to students; confirms student test settings in the Test Administrator Interface; and ensures test session security. The user accesses the Interim Assessment Hand Scoring System, Completion Status Reports and CERS assessment results for students in an associated student roster, and enters student responses in the DEI. Rosters of students are created and assigned to the test examiner user by the LEA CAASPP coordinator or site CAASPP coordinator. Note that unless the test examiner has been assigned to a student roster, the test examiner cannot access any student results in the CERS.","• LEA CAASPP coordinator\n• Site CAASPP coordinator"]
["IA Administrator Only","This role administers only the interim assessments to students. The user accesses the Interim Assessment Hand Scoring System and Interim Assessment Completion Status Reports. Note that access to interim assessment results is available through the Interim Assessment Reporting System logon.","• LEA ELPAC coordinator\n• Site ELPAC coordinator\n• LEA CAASPP coordinator\n• Site CAASPP coordinator"]
["Educator—District","This role allows access to assessment results in the CERS for the entire LEA. This role is assigned by the LEA CAASPP coordinator.","• LEA CAASPP coordinator"]
["Educator—Test Site","This role allows access to assessment results in the CERS for the entire school. This role is created and assigned to the user by the LEA CAASPP coordinator or site CAASPP coordinator.","• LEA CAASPP coordinator \n• Site CAASPP coordinator"]
["Educator—Roster","This role allows access to assessment results for students in an associated student roster in the CERS. Rosters of students are created and assigned to the user by the LEA CAASPP coordinator or site CAASPP coordinator. Note that unless this user has been assigned to a student roster, the user cannot access any results in the CERS.","• LEA CAASPP coordinator\n• Site CAASPP coordinator"]
["Tools for Teachers Only","This role allows access to Tools for Teachers.","• LEA ELPAC coordinator\n• Site ELPAC coordinator\n• LEA CAASPP coordinator\n• Site CAASPP coordinator"]

{"sheet":"User Upload File Specifications","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Column","Field Name","Description","Maximum Characters","Required or Optional?","Acceptable Value"]
["A","First Name","User’s first name",34,"Required","•  Must use alphanumeric characters\n•  Can use numbers and special characters (with the exception of the comma [ , ] and the pipe [ | ])\n•  Must have a minimum of one character"]
["B","Last Name","User’s last name",34,"Required","•  Must use alphanumeric characters\n•  Can use numbers and special characters (with the exception of the comma [ , ] and the pipe [ | ])\n•  Must have a minimum of one character"]
["C","Email Address","User’s email address",64,"Required","•  Must use alphanumeric characters\n•  Must be in a valid email format (e.g., caltac@ets.org)\n•  The following characters are accepted before the @ sign:\n– Uppercase alpha\n– Lowercase alpha\n– Numbers (0–9)\n– The following special characters: . _ - '  (period, underscore, hyphen, and apostrophe)\n•  The following characters are accepted after the @ sign:\n– Uppercase alpha\n– Lowercase alpha\n– Numbers (0–9)\n– The following special characters: . _ (period and underscore)\n• The following characters are accepted after the period in the domain name (e.g., the “org” in “elpac.org”):\n– Uppercase alpha\n– Lowercase alpha\n– Minimum domain length of two characters and maximum domain length of four characters"]
["D","Phone Number","User’s telephone number",10,"Required","•  Must contain 10 numeric characters (area code, prefix, suffix), like this example: 8009552954\n– Area code must have three numeric characters.\n– Prefix must have three numeric characters.\n– Suffix must have four numeric characters.\n– Entry does not include hyphens."]
["E","Cell Phone Number ","User’s cell phone number",10,"Optional","•  Must contain 10 numeric characters (area code, prefix, suffix), like this example: 8009552954\n– Area code must have three numeric characters.\n– Prefix must have three numeric characters.\n– Suffix must have four numeric characters.\n– Entry does not include hyphens."]
["F","CDS Code","CDS code of the school or program the user is associated with",14,"Required","Code requirements are as follows:\n• Must be a 14-digit, unhyphenated number formatted like this example: 11111111111111\n•  Must be a valid organization defined in the system\n•  Must have active status\n•  Requires an organization code\n\nRequirements for the user entering the code are as follows:\n•  Must have valid authorization for any organization uploaded\n•  Must be a school within the LEA (if the user performing the upload is an LEA CAASPP or ELPAC coordinator)\n•  Must be assigned to the school being uploaded (if the user performing the upload is a site CAASPP or ELPAC coordinator)"]
["G","Role in Organization","User’s role in the organization",64,"Required","This is a drop-down list that contains the following user roles. You may add a user to a role or roles in this file or delete the user from a role or roles in this file.\n• Site ELPAC Coordinator\n• ELPAC Test Examiner\n• LS Correspondence Administrator\n• LS Data Entry\n• Site CAASPP Coordinator\n• CAASPP Test Administrator\n• CAASPP Test Examiner\n• IA Administrator Onlly\n• Educator—District\n• Educator—Test Site\n• Educator—Roster\n• Tools for Teachers Only\n\nNotes:\n• The following roles can only be added to a school: Site ELPAC Coordinator, ELPAC Test Examiner, LS Data Entry, Site CAASPP Coordinator, CAASPP Test Administrator, CAASPP Test Examiner, IA Administrator, Educator—Test Site, and Educator—Roster.\n• The following roles can only be added to an LEA: LS Correspondence Administrator and Educator—District.\n• The following role can be added to an LEA or a school: Tools for Teachers Only. "]
["H","Admin Year","Administration year for which the user wants to perform action",12,"Required","This is a drop-down list containing current and upcoming administration year values. The action will be performed for the logged-on user's administration year."]
["I","Action","Add or Delete action to be performed",12,"Required","This is a drop-down list containing Add Role and Delete Role values. Selection depends on whether the role is to be added or deleted."]

{"sheet":"User_File_Upload","index":3,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["User Upload Template"]
["First Name","Last Name","Email Address","Phone Number","Cell Phone Number","CDS Code","Role in Organization","Admin Year","Action"]

{"sheet":"HiddenValidationData","index":4,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Site ELPAC Coordinator"]
["ELPAC Test Examiner"]
["LS Correspondence Administrator"]
["LS Data Entry"]
["Site CAASPP Coordinator"]
["CAASPP Test Administrator"]
["CAASPP Test Examiner"]
["IA Administrator Only"]
["Educator - District"]
["Educator - Test Site"]
["Educator - Roster"]
["Tools for Teachers Only"]