The Standards Based set up tables are district-owned in Aeries. Once the Standards Based Grades are set up at one school it will be available to all schools in the database. The Standards Based Grades module is comprised of the following tables:
STN – Standards (District owned)
SBV – Standards Based Valid Marks (District owned)
COD - Mark Type Descriptions (District owned)
SBD – Standards Based Template Details (District owned)
SBS – Standards Based Templates (District owned)
SBE – Standards Based Setup (District owned)
SBR – Standards Based Courses (District owned)
OPT - Options (contains Standards Based Options records)
GRO - Grade Reporting Options (contains Standards Based Options records where TY = "E". These records record the report card type, date range and term of the last time Standards Based Grades was initialized.)
SBC – Standards Based Comments
SBG – Standards Based Grades
SBH – Standards Based History
CRS - Courses (for Elementary with Master Schedule schools that want to have the teacher for the course enter the grades rather than the "homeroom" teacher enter all grades for the student)
Minimum permissions to view or modify the Standards Based Report Card Templates are:
Table | Permission | Description |
---|---|---|
Standards Based Report Card Templates (SBS) | Read Update | Allows users to open existing templates, view what is in SBE for import, and run print previews Users can create new templates, save templates, delete templates and import from SBE |
Standards Based Setup (SBE) | Read Insert | Allows users to view the Standards Based Setup page and create printouts Allows users to push/copy the template to the current set-up with the Push to SBE icon |
Standards (STN) | Insert and Update | Allows users to add and edit standards from the Standards Based Report Card Templates page |
We recommend that Non-Admin users that will be updating or creating Standards Based Grade report cards have the following permission to these security areas:
Table | Permission | Description |
---|---|---|
Student Data (STU) | Read | View students and enter/edit the Report Card Type (STU.RC) on the Standards Based Input page |
Standards (STN) | Read, Insert, Update and Delete | Add, edit, delete Standards |
Standards Based Options (Standards Based Options are particular records stored in the Options (OPT) table) | Read, Insert, Update and Delete Administer | Update Standard Based Grades Options Administer allows non-Admin users to push the option set from one school to other schools |
Grade Reporting Options (GRO) | Read, Insert, Update and Delete Administer | These permissions drive access to edit the Legends on the report card |
Standards Based Setup (SBE) | Read, Insert, Update and Delete | Add, edit, delete Standards Based Setup |
Standards Based Report Card Templates (SBS) | Read and Update | Create and update SBG Report Card Templates |
Standards Based Template Details (SBD) | Read | Create and update SBG Report Card Templates |
Standards Based Valid Marks (SBV) | Read, Insert, Update and Delete | Add, edit, delete Standards Based Marks |
Standards Based Grades (SBG) | Read, Insert, Update and Delete Administer | Add, edit, delete Standards Based Grades. Include initializing SBG. Administer allow non-Admin users to have access to the Teacher Emulation > Standards Based Grades by Teacher page |
Standards Based Comments (SBC) | Read | Add, edit, delete Standards Based Comments |
Standards Based History (SBH) | Read, Insert, Update and Delete | Add, edit, delete Standards Based History |
Codes (COD) | Read, Insert, Update and Delete | Add, edit, delete Standards Based Report Card Comment Codes (SBC.CD) and Report Cart Types (STU.RC) |
Standards - Courses (SBR) | Read | |
Courses (CRS) | Read, Insert, Update and Delete | In Elementary with Master Schedule schools allows users to associate standards with courses. |
Elementary teachers will need the following permissions:
Table | Permission | Description |
---|---|---|
Standards Based Grades (SBG) | Read and Update | Allows teachers to view, enter and update Standards Based Grade marks and comments |
NOTE: Editing an existing standard will impact standards already in use. Permissions to the Standards (STN) table should be limited to admin type users and be granted with caution.
Please see the Security article for more detailed information on how to set up permissions for users and groups.