From:���������������������������������������� Jones, Dianna

Sent:������������������������������������������ Thursday, July 29, 2010 10:14 AM

To:���������������������������������������������� Wurtz, Keith

Cc:���������������������������������������������� Garnick, Everett; Smith, James; Angelo, Dan; Cabrales, Joe; Cota, Marco; Gamboa, Colleen; Colvey, Kirsten

Subject:������������������������������������ RE: Grade change history

Attachments:������������������������� Sampling_Fall2009_MIS Discrepancy Review.docx; SXREFSUM3980_Fall 2009_MIS Discrepancy Review.docx

 

Importance:��������������������������� High

 

Keith,

 

Attached are 2 documents that may be helpful in reviewing the Discrepancy we discussed in today�s MIS Committee meeting.

 

(1)    A �Sampling� from the Fall 2009 MIS Course Basic, Section, and Enrollment data files that were submitted to the State, where a spot-check reveals that students identified on the �Not in MIS� list (791 records) can be found in the MIS SX file that was submitted to the State.. 

(2)    The SX Referential Summary Report from the State Chancellor�s Office generated during submission of Fall 2009 MIS data shows an Enrollment count of 18,267 for Crafton.  Records included in the SX file contain one of the following grades: A, B, C, D, F, IF, MW, NP,  P, and W.

 

After reviewing the attached, please let me know your thoughts.

 

 

Dianna Jones, M.S.

San Bernardino Community College District

District Computing Services (DCS)

Phone: 909-384-4364

Email: dijones@sbccd.cc.ca.us         

 

 

 

 

 

Thanks Everett!

This will get me started.  I will let you know what I find.

 

 

 

Keith:

 

There is a file named STUDENT.ACAD.CRED.HIST from which you can pull a history of changes made to selected data fields in the STUDENT.ACAD.CRED file. VERIFIED.GRADE is one of those fields. The dictionary of the file looks like the list below:

 

:LISTDICT STUDENT.ACAD.CRED.HIST

;SORT DICT STUDENT.ACAD.CRED.HIST TYP LOC CONV MNAME FORMAT SM ASSOC BY TYP BY

LOC BY @ID 08:51:38 Jul 29 2010 1

@ID............ TYP LOC.......... CONV MNAME.......... FORMAT SM ASSOC.....

 

@ID             D               0      HIST            32L    S

HIST.FIELD.NAME D               1      Field           28L    S

HIST.OLD.VALUES D               2 BL   Old Values      25L    M

HIST.NEW.VALUES D               3 BL   New Values      25L    M

HIST.LOG        D               4      Hist Log        10L    S

HIST.ID         I   FIELD(@ID,"*"      Hist            80L    S

                    ,1)

QBSEC           I   SUBR("QBSEC",                      1R     S

                    "STUDENT.ACAD

                    .CRED.HIST",@

                    ID,@RECORD)

 

A sample of two records listed is shown below. The first is a grade change record showing addition of a grade where one did not exist (�Old Values� is blank). The Id of the records is date*time*operatorid*studentid*changenumber. I�ve highlighted the one for the first record below. The date is in internal format- it is just a number. To see what it is as a date, use Excel and add 24837 to the number in a date-formatted cell. (1/0/1900 is 0 in excel but 0 in Datatel is 12/31/67)

 

 

:LIST STUDENT.ACAD.CRED.HIST HIST.FIELD.NAME HIST.OLD.VALUES HIST.NEW.VALUES HIS

T.LOG

;LIST STUDENT.ACAD.CRED.HIST HIST.FIELD.NAME HIST.OLD.VALUES HIST.NEW.VALUES HI

ST.LOG 08:52:33 Jul 29 2010 1

HIST         13865*46284*CCENTRAL*3857576*1

Field        STC.VERIFIED.GRADE

Old Values

New Values   1

 

HIST         14933*72582*CCENTRAL*3138007*1

Field        STC.STATUS

Old Values   N

New Values   X

             N

 

Give me a call if you have any questions.

 

Everett Garnick

Director, District Computing Services

San Bernardino Community College District

441 West 8th Street

San Bernardino, CA 92401

(909) 384-4360 Office

"The test of courage comes when we are in the minority. The test of tolerance comes when we are in the majority." -- Ralph W. Sockman