Final Grade Report

Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.

 

Use the example query in order to run a final grade report.

Release 6.3.x and above

SELECT stac.stuID AS 'Student ID',
CONCAT(person.lname,', ',person.fname) AS 'Student Name',
stac.courseSection AS 'Course Section',
stac.shortTitle AS 'Course Title',
stac.grade AS 'Final Grade'
FROM stac
LEFT JOIN person
ON stac.stuID = person.personID
WHERE stac.termCode = '2013/FA';

Release 4.4 => 6.2.x

SELECT a.stuID AS 'Student ID',
 
CONCAT(b.lname,', ',b.fname) AS 'Student Name',
 
a.courseSection AS 'Course Section',
 
a.shortTitle AS 'Course Title',
 
a.grade AS 'Final Grade'
 
FROM stu_acad_cred a
 
LEFT JOIN person b
 
ON a.stuID = b.personID
 
WHERE a.termCode = '13/FA';

Release 4.3 and below

SELECT a.stuID AS 'Student ID',

CONCAT(b.lname,', ',b.fname) AS 'Student Name',

CONCAT(a.termCode,'-',a.courseSecCode) AS 'Course Section',

c.secShortTitle AS 'Course Title',

a.grade AS 'Final Grade'

FROM stu_acad_cred a

LEFT JOIN person b

ON a.stuID = b.personID

LEFT JOIN course_sec c

ON a.courseSecCode = c.courseSecCode

AND a.termCode = c.termCode

WHERE a.termCode = '13/FA';

 

 

Last Modified: Jun 22, 2017 @ 11:58 PM

Was this article helpful?

Related Articles