Student Information System - Database - Grades
Overview and Prerequisites
Prior to reviewing this page, please review the Generic Student Information System Integration Directory page, including prerequisites found here.
In addition, the following prerequisites are set for the specific grades integration:
Database View Prerequisites | Additional Information |
---|---|
The database view must include the following columns:
|
Additional fields could be used for display purposes (course subjects, etc.) |
User Experience
The grades services allows student to view their final grades by semester.
Property | Static Tile |
---|---|
Default Size | 1x1 |
Minimum Size | 1x1 |
Suggested Design |
Screenshots
Sample Requests
Sample Query to Retrieve List of Terms |
---|
SELECT DISTINCT TERM_ID, TERM_NAME FROM USER_GRADES WHERE USER_ID={userId} |
Sample Response | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Sample Query to Retrieve User Grades |
---|
SELECT DISTINCT TERM_ID, TERM_NAME, COURSE_TITLE, FINAL_GRADE FROM USER_GRADES WHERE USER_ID={userId} AND TERM_ID={termId} |
Sample Response | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||
Offline Functionality
Not supported.
Configuration Options
Configuration Item | Options | Default Value |
---|---|---|
Default Screen |
|
Terms list |
Labels
Label | Default Value |
---|---|
Tile name on home screen | My Grades |
Page title | Grades |
Link to terms | Terms |
Final grade label | Final Grade |
Suggested Testing Guidelines
The following acceptance criteria is recommend to be used as part of the testing and approval process:
- User can access the Grades Tile and see their final grades for the current term
- User can navigate to view their terms
- User can select a term a see their final grades for that term