Dict-Physical

Table MF_SectionGradeByTerm

Card of table MF_SectionGradeByTerm

Name	MF_SectionGradeByTerm
Dimensional Type	Fact
Comment	This fact table records grades for sections. The grain is one row per student per section. To make reporting and analysis easier, this dimension uses regular terms (SU, FA, WI, SP) instead of variable-length terms. If a section crosses multiple regular terms, we use the first regular term during which it occurs and link to it here. This is the only practical way to make everything comparable and easily analyzable in, e.g., a pivot table that uses normal, non-overlapping time intervals. This fact table only includes counts for PRIMARY sections.

Check constraint name of the table MF_SectionGradeByTerm

CKT_MF_SECTIONGRADEBYTERM

List of outgoing references of the table MF_SectionGradeByTerm

AidPersRecdGradeForRegTerm

MD_FinancialAidPerson (Shortcut)

MD_CollPers_SurrogateKeyFAidPers

DStuReceivedGradeForRegularTerm

MD_DegreeStudent (Shortcut)

MD_CollPers_SurrogateKey

NonDStuRecdGradeForRegularTerm

MD_NonDegreeStudent (Shortcut)

MD_CollPers_SurrogateKeyNonDegr

Relationship_55

MD_Section (Shortcut)

MD_Sect_SurrogateKey

Relationship_56

MD_Course (Shortcut)

MD_Course_SurrogateKey

Relationship_57

MD_CarlTerm (Shortcut)

MD_CarlTerm_SurrogateKey

Relationship_163

MD_Grade

MD_Grade_SurrogateKey

List of referencing views of the table MF_SectionGradeByTerm

VMF_SectionGradeByTerm

VMF_SECTIONGRADEBYTERM

List of diagrams containing the table MF_SectionGradeByTerm

StarsAcademicRecordDiagram

List of columns of the table MF_SectionGradeByTerm

MD_Sect_SurrogateKey

<None>

numeric

MF_SectGradeBT_CollID

Used for internal bookeeping during ETL process. Do not expose to users, unless they want unique student counts in SSAS. This attribute may be used for that purpose. The Colleague ID here is that of the student.

DW_ColleagueID

char(7)

MD_CarlTerm_SurrogateKey

Link to first regular term in which a course is offered (the distinction between this and the course term only matters in the case of multi-term courses).

<None>

numeric

MD_Grade_SurrogateKey

<None>

numeric

MD_CollPers_SurrogateKey

<None>

numeric

MD_CollPers_SurrogateKeyNonDegr

<None>

numeric

MD_CollPers_SurrogateKeyFAidPers

<None>

numeric

MD_Course_SurrogateKey

<None>

numeric

MF_SectGradeBT_TranscriptedGrade

Final grade entered into Colleague by the Registrar and used in transcripts, expressed as a numeric value (suitable for averaging).

This grade may differ from the final grade assigned by the instructor. Cf. MF_SectEnrBT_AssignedGrade.

May be NULL in the case of S/CR/NC grades (credit / no credit), or in cases where a course isn't yet finished, or a grade hasn't been submitted and is overdue (X).

To do a grade calculation, multiply each transcripted grade given times the number of credits attempted (not received) for the class, then divide the total by the number of credits attempted. Basically it's just a weighted average.

<None>

float

MF_SectGradeBT_AssignedGrade

Final grade assigned by instructor, expressed as a numeric value (suitable for averaging).

This grade may differ from what is entered by the registrar (transcripted). Cf. MF_SectEnrBT_TranscriptedGrade.

May be NULL in cases where a course isn't yet finished, or a grade hasn't been submitted. Will also NULL also if the course was scrunched (S/CR/NC) and the professor knew it, and didn't assign a true letter grade. S/CR/NC grades do have numeric equivalents, but we don't allow those here, because it would require mixing these with normal letter grades. Since the two systems are different, averages would get thrown off. To analyze all grades (not just standard A, B, C letter grades), don't use this field. Instead, join the fact table to MD_Grade and count grades (or express grade counts as a percentage of row totals).

Grades can't be aggregated, per se. They are weighted, averaged, etc. along with credits.

DO NOT use this field for calculating transcripted GPAs. Use only for internal assessment.

<None>

float

MF_SectGradeBT_CompletedCredit

Number of credits completed for a course. Rows all must have a value here, although the value might well be zero if the student failed the section (got an F).

The value of this field is allocated across (possibly) several regular terms (SU, FA, WI, SP), as in the case of multi-term OCP sections. Hence it can't be used as a grade, in the sense of having a one-to-one correspondence with sections.

In the production system (Colleague), credits are used to weight grades, in order to calculate GPAs.

<None>

float

MF_SectGradeBT_AttemptedCredit

Number of credits attempted for a course. Rows all must have a value here.

Credits attempted are a good measure (when aggregated) of raw instructional hours. Use them to help determine what portion of the actual, working, instructional load is being carried by departments, or particular terms, or subject areas.

The value of this field is allocated across (possibly) several regular terms (SU, FA, WI, SP), as in the case of multi-term OCP sections. Hence it can't be used as a grade, in the sense of having a one-to-one correspondence with sections.

In the production system (Colleague), credits are used to weight grades, in order to calculate GPAs. But in this case it's not credits attempted that's used, but rather credits completed.

<None>

float

MF_SectGradeBT_AuditKey

DW_AuditKey

bigint

MF_SectGradeBT_Timestamp

<None>

timestamp