Compute Assessment Mark Results {SSTUD4-14}

This program is used to calculate Assessment Result Codes. Assessments can be entered in options {SSTUD1-2}, {TASKS1-2} and in {COOP-5b2} Tab - Student In-service Projects. The first two options does a lookup of the appropriate Result Code but that lookup does not happen in the last option. Therefore this program was created.

The system cycle ‘M’ must be open for the Year, Block and Offering Type to be calculated. If the selection criteria include one combination for which the cycle is not open, the program will print a message and abort execution.

The validation ‘PM’ determines if cancelled students’ assessment results will be computed. If ‘PM’ = ‘Y’, the cancelled students will be included. If ‘PM’ = ‘N’, the cancelled students will be ignored.

The Restriction “SREC” under option {SMNT-5}, can control access to data in this option. This makes it possible to limit access to the updating of marks in respect of one person to one Faculty / Department and Campus only. Campus restriction is not mandatory.

The marks of all the assessments should ideally being entered before this program is executed. This is however, not a pre-requisite.

Changes made by this program will be written to a log file that can be printed using {SMNTL-6}. The user and the program name is also written to the log file

Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
Enter Academic Year	YYYY
Enter First Block Code To Include Or [ALL]	A2	Up to 10 Block codes can be included
If ALL, Enter First Block Code To Exclude Or <Enter> To Continue	A2	Up to 10 Block codes can be excluded
Enter Faculty Code Or [ALL]	N4	Faculty code of the subject
Enter Start Department Code [0]	N4	Department code of the subject
Enter End Department Code [9999]	N4
Enter Campus Code Or [ALL]	N2
Enter Qualification Code Or [ALL]	A6
Enter Subject Code Or [ALL]	A7
Include Records with a Final Result Yes/No [N]	A1
Enter First Offering Type To Include Or [ALL]	A2	Up to 10 Offering Types can be included
If ALL, Enter First Offering Type To Exclude Or <Enter> To Continue	A2	Up to 10 Offering Types can be excluded
Enter Group Type [C]	A1	Valid values are 'C', 'P' and 'T'
Enter Start Group [0]	A2
Enter End Group [ZZ]	A2
Enter First Mark Type To Include Or [ALL]	A2	Up to 10 Mark Types can be included
If ALL, Enter First Mark Type To Exclude Or <Enter> To Continue	A2	Up to 10 Mark Types can be excluded
Enter Assessment Number or [ALL]	N2
Enter Student Number of [ALL]	N9
Sort Students [N]umeric or (A)lphabetic	A1
Is This A [T]rial Or An (U)pdate Run	A1

Sort Order	Per	Comments
	Faculty Code
	Department Code
	Subject code
	Offering Type
	Mark Type
	Group Type
	Group Value
	Assessment number

System Select
	Exclusions: Cancelled students when validation ‘PM’ = ‘N’ Students that are exempted Competence subjects Professional Judgement Students that are registered as exam only. Students with an existing assessment result than may not be re-calculated - see {SCODE-23} Assessments that are marked as "Type of Evaluation" = C - Competence and P - Professional Judgement. Note: these subject's results should be entered by hand {SSTUD1-2}.

System Select

Exclusions:

Cancelled students when validation ‘PM’ = ‘N’
Students that are exempted
Competence subjects
Professional Judgement
Students that are registered as exam only.
Students with an existing assessment result than may not be re-calculated - see {SCODE-23}
Assessments that are marked as "Type of Evaluation" = C - Competence and P - Professional Judgement. Note: these subject's results should be entered by hand {SSTUD1-2}.

Example:

Processing Rules
	Results are allocated as per the mark entered for the student. These results are defined in {SSTUD3-7} Tab - Assessment Result Criteria
	If there are no results defined for a specific mark, the program will print the student number, mark and the message “No Result Criteria For Assessment Mark XX For Student NNNNNNNNN. The program lists all the students without marks and shows the number of records updated.
	Assessment result should not be calculated if either a Holding bin or Bundle with no marks exists for any of the assessments, this logic is done by a function called from i43pkg.sql
	Allocating of the the default result "Result for Compulsory Assessment not Submitted". If no mark exists and there is no record for this assessment in the Assignments records in {TASKS1-2} Tab - Students in This Bundle, the default result will be allocated for this assessment. This has implications for the calculation of the Mark Type result in {SSTUD4-13}, the calculation of exam admission in {SSTUD4-2} as well as for the calculation of the final mark and result in {SSTUD4-4}.
	If, after the first calculation of the result, the student submitted an assignment that has not yet been marked, and the calculation program is executed again, the program will set the result of the Assessment to NULL (i.e. no value).

Date	System Version	By Whom	Job	Description
22-Aug-2006	v01.0.0.0	Phlip Pretorius	t131455	New manual format.
10-Jan-2007	v01.0.0.1	Phlip Pretorius	t138804	Add new reason for student excluded
27-Aug-2008	v01.0.0.2	Bea Swart	t152378	Check processing rules and correct
31-Aug-2010	v02.0.0.0	Bea Swart	t164727	Add Type of Evaluation P - Professional Judgement
28-Jan-2011	v02.0.0.1	Bea Swart	t172079
15-Jan-2013	v03.0.0.2	Magda van der Westhuizen	T178547	Add restriction type 'SREC' .