Students will be able to view their individual exam results for each component/module of their Apprenticeship.
This information will be extracted from tbl_ASC_Backend and tbl_ROTC_Backend.

ASC_Backend Details:

• Fields to be extracted are – Student No., Component, Test Score, Resit Score and Attendance
• Student No. is located in tbl_ASC_Students and will be used as the username for each Student logging into the website
• tbl_ASC_Students is linked to tbl_ASC_Contracts via the Student ID field, from there tbl_ASC_Contracts is linked to tbl_ASC_Results via the Contract ID field.
• Component is located in tbl_ASC_Components, which is linked to tbl_ASC_Results via the Component ID field
• Test Score, Resit Score and Attendance are all located in tbl_ASC_Results (please note: at this point in time the Results section of the ASC database has not been used, this table will need to be populated via a download from an existing ASC excel spreadsheet which will be completed by me)

The ROTC_Backend database is very similar in structure; all fields are located in the same tables (ie tbl_ROTC_Students, tbl_ROTC_Contracts, and tbl_ROTC_Results). The same fields will need to be extracted – the only difference being that the Module field needs to be extracted rather then the Component field. Module is located in tbl_ROTC_Modules and is linked to tbl_ROTC_Results via the Module ID field.

Students will also have access to view Class Notes and Timetables (both of which will be stored as pdf’s in the system). Class Notes and Timetables will be specific to the Component/Module being completed by the Student and will be stored in the system under the relevant Component/Module name.