NOTE: the CERS Student Groups Extract is in BETA testing at this time


Navigate to CERS Student Groups


CERS Student Groups Extract is a new page used to create comma-delimited student group files for uploading into CERS (California Educator Reporting System). These student groups are used to aid in analyzing the assessment results. In the first phase the files will need to be manually uploaded into CERS. Development is continuing on a process that will use the CSV files as a data transfer format, but they will be sent to CERS through an API-based method using security similar to the State Electronic Score Reports


The CERS Student Groups Extract can be run at the District level or the School level and includes several levels of options to customize the student group rosters. It is being released as a BETA for testers to use and provide feedback. 


CERS Student Groups Extract page



Security for CERS Student Groups 

The Admin user type automatically has the ability to use the CERS Student Groups Extract page without any additional security setup. User and Portal Group accounts will need Administer permission to the CERS Student Groups area. It can be found within the Other area in Security.

CERS Student Groups - Security


Please view this article:  Security  for more detailed information on how to set up permissions for users and groups.



Profiles

Click on the Profiles tab.


A profile is a collection of settings that will determine the data that is provided in the CERS Student Groups extract. 


Click on New Profile to begin to configure a profile. After clicking on New Profile you are directed to the School Selection tab to select the schools that will be included in the profile. 


Click on a profile name in the list and then on Edit Profile to edit an existing profile. The Filter option at the top of the list is used to filter the profiles in the list so that you can quickly find the one to modify. After clicking on Edit Profile you are directed to the Extract Configuration Options tab. 



CERS Student Groups page - Profiles tab


NOTE The Profile and all other options are stored in the User Options (USO) table, so all CERS Student Group Extract settings are set by the individual user and cannot be shared between users.



School Selection

When the CERS Student Groups is run at the District level at least one school must be selected. When run at the School level the school that you are logged into will be selected by default, however other schools can also be selected. By default only active schools are displayed in the list, but temporarily all schools can be displayed by un-checking the Show active schools only option. There is a Filter at the top of the school list as well as Select All Schools and Clear All buttons at the bottom of the school list to make selections quicker.


Once the school(s) have been selected click on the Extract Configuration Options tab to continue.


CERS Student Groups page - School Selection tab


Extract Configuration Options

Subject Area - Select the Subject Area in the state reporting system that this student group roster is for. The available options are ELA, Math or All


Type - Select the type of student group roster. This selection will affect the filtering options in the Extract Configurations Options tab.

  • Secondary Master Schedule Classes - provides Course filters for Department Code, Subject Area and Courses
  • Elementary Teachers - provides a Teacher/Counselor Code or Name filter
  • Elementary Grade Level - provides a Filter by Grade
  • Counselor  - provides a Teacher/Counselor Code or Name filter
  • Student Group - provides a filter of Student Groups by Group Code or Name


Group Name Pattern - select the naming scheme for the Student Group Name that will be sent up to CERS. Each student group can have at most 200 students. If a group contains more than 200 students the number at the end will be incremented for the next set of 200 students.

  • Teacher Name + Period - Student Group Name will be in the format  School Number+Teacher Last Name First Name+Period+number.  
  • Teacher Name + Section - Student Group Name will be in the format  School Number+Teacher Last Name First Name+Section Number+number 
  • Teacher Name + Course Title - Student Group Name will be in the format  School Number+Teacher Last Name First Name+Course Title+number
     

CERS Student Groups page - Extract Configuration Options tab - Group Name Pattern dropdown


Include only Primary Classes - This option is available when logged into the District or into a school using Tracking Primary Classes, and the Type is Secondary Master Schedule Classes.  If the Include only Primary Classes is selected with NO course or teacher filters, then ALL schools selected in the profile need to be Tracking Primary Classes.  Otherwise, the extract will have no data. When limiting to Primary Classes, if the other filters (Department, Subject, Course, and Teacher) were selected in the profile, they will also be applied. 


Course Filters - The Course Filters is available when the CERS Student Group Type is set to Secondary Master Schedule Classes and allows you to create rosters of students based on one or more Department Codes, Subject Areas or Courses. The Allow selection on Department and Subject Areas allows you to select courses using both criteria.


Filters are available at the top of each list to help limit the lists for easier selection. Select All and Clear All buttons are also available for each list. The selections build upon each other.


In the below example selecting the English Subject Area limits the list of courses to only those with that subject area. The filter was used in the Courses list to only display English courses that include the characters 030.


CERS Student Groups page - Extract Configuration Options tab - Department Code, Subject Area and Courses options


NOTE:  At this time, the teacher is is NOT currently being limited by the selections made in the other filter boxes.



Teachers to Include in the Extract to Access the Assessment Results - This list is available when the CERS Student Group Type is set to Secondary Master Schedule Classes or Elementary Teacher and allows you to create rosters of students for one or more teachers. For elementary schools with no Master Schedule the list of teachers is based off the the Teachers (TCH) table. For school that use a Master Schedule it is based off of Master Schedule in conjunction with the Teachers table.


A Filter is available at the top to help limit the list for easier selection. Select All Teachers and Clear All buttons are also available. NOTE: the fields that hold the teacher selection is limited to 255 characters and may not hold more than 30 teachers. Please limit the list of teachers to 30 or less per extract.


In order for the extract to include the elementary teacher's email address, the Email field in the Teachers table  (TCH.EM) needs to be populated with the email address. 


In the below example the filter is being used to quickly select the English teachers by typing in the teacher number, selecting the teacher and then typing in the next teacher number. Once all of the teachers were selected clicking on the Only show selected teachers displayed the list concisely.

CERS Student Groups page - Extract Configuration Options tab - Teachers to Include options



Filter by Grade - The Filter by Grade is available when the CERS Student Group Type is set to Elementary Grade Level and allows you to create rosters of students based on one or more grades. A Filter is available at the top to help limit the list for easier selection. Select All Grade Levels and Clear All buttons are also available. The selections build upon each other.


In the below example the filter is being used to list all grade levels that begin with F so that the fourth and fifth grades can be quickly selected.


CERS Student Groups page - Extract Configuration Options tab - Grades options


Filter by Group Code or Name - The Filter by Group Code or Name is available when the CERS Student Group Type is set to Student Group and allows you to create rosters of students based on one or more student groups defined in the Aeries Student Groups page. Please see the Student Groups documentation for more information on how to create and maintain student groups in Aeries. A Filter is available at the top to help limit the list for easier selection. Select All Groups and Clear All buttons are also available. The selections build upon each other.


In the below example the filter is being used to list all student groups that contain "Re" so that the elementary Reading groups in school 990 can be quickly selected.


CERS Student Groups page - Extract Configuration Options tab - Student Groups options



Filter by Counselor Code or Name  - The Filter by Counselor Code or Name is available when the CERS Student Group Type is set to Counselor and allows you to create rosters of students based on one or more counselors in the Student Counselor (STU.CU) field. In order for the extract to include the counselor's email address, the Email field in the Teachers table  (TCH.EM) needs to be populated with the email address.


CERS Student Groups page - Extract Configuration Options tab - Counselors options



Additional Users With Permissions to Access the Assessment Results - Select additional staff that the CERS Student Group is being created for. At this time all active records in the Staff (STF) table that have a State Educator ID (STF.SID) populate the list.


NOTE: CERS requires that the staff members have a valid email address. Make sure that any staff members that are selected to receive student groups have a valid email address in the Staff Email (STF.EM) field.



The table includes a Filter at the top of the list to quickly search for individual staff members. Multiple records can be selected by filtering for a staff member, clicking on the Staff record, then filtering for the next staff member. The Select All Staff button can also be used to select all records in the filtered list. NOTE: the fields that hold the staff selection is limited to 255 characters and may not hold a large number of staff. 


In the below example two counselors from school 994 have been selected. These counselors will be able to log into the CERS system and create assessment reports for the student groups that are created in the extract.


CERS Student Groups page - Extract Configuration Options tab - Additional Users option


NOTE: When creating a new CERS Student Groups extract click on the Clear All button to ensure that no default Staff are selected prior to making your selections



Profile Name - Enter a name for the new profile that is being created. Click on Save. After a new profile has been created, the CERS Student Groups extract page needs to be refreshed before the profile will be available in the Profile or the Select Profiles & Create Files tabs.



Select Profiles & Create Files


Select Profiles to Extract - The available profiles are listed based on your prior selections. A Filter is available at the top of the list to quickly limit the selections. Select All and Clear All buttons are also available to quickly edit the selection. Click on a profile to select it. 


Select the Consolidate selected profiles into one file in order for the system to merge the results of the selected profiles into one larger file.


Click on the Create CERS Student Groups File to create the CERS Student Groups roster file. A popup message will display when the file creation has completed.


CERS Student Groups page - Select Profile & Create Files tab



Extracted Files

This tab lists the CERS Student Group extract files along with the date and time they were created, the logged in user that created them, and the number of records in the file. Click on the Download icon to download the file. In the Chrome browser the file will also display at the bottom of the browser. This file can then be taken from your computer's Downloads folder and imported into the CERS system.


CERS Student Groups page - Extracted Files tab



CERS Student Groups Extract Files - File Layout

The CERS Student Groups Extract files follow the template specifications outlined in the 2019-20 California Educator Reporting System User Guide.  Below is a screenshot of what the file looks like. Please follow the guidelines in the CERS User Guide for importing the Student Groups file into CERS.


CERS Student Groups - Screenshot of data in an extracted file