ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Step #TypeNameQuery or URLComments/DetailsDone?
2
1.0Aeries helpEOY 1 Course and Staff Fileshttps://support.aeries.com/support/solutions/articles/14000082464-eoy-1-course-and-staff-files-crsc-scsc-and-sdem-Describes required steps to create CALPADS CRSC, SCSC, and SDEM files which come from 7th & 8th grade courses, grades, and teachers being configured correctly.
3
1.1Data linksdebugging/config infohttps://support.aeries.com/support/solutions/articles/14000082464-eoy-1-course-and-staff-files-crsc-scsc-and-sdem-"Below are the conditions for a transcript (HIS) record to be included in the SCSC file:

The transcript record must match the current school HIS.ST = LOC.SC or if the student has a Reporting Home School (STU.HS) populated, match the CDS of the Reporting Home School. Note: exception is Dual Enrollment Courses, see information below
From the current school year
History Marks (HIS.MK) of blank and “X” will be skipped
History Section (HIS.SE) must match to a valid section in the Master Schedule (MST) and the MST.CN must be a valid course in the CRS file. When Copying Grades to History, the History Section (HIS.SE) and History Staff ID (HIS.SID) will be populated from GRD.
Transcript records with a valid course record. Course records with CBEDS Course number 6012 will be skipped.
History Terms (HIS.TE) must be greater than or equal to 0 and less than or equal to 8"
4
1.2ConfigurationTranscript Definition --> Termshttps://aeries.lbsdk8.org/admin/TranscriptDefinition.aspx
5
1.3ConfigurationGrade Reporting --> Valid Markshttps://aeries.lbsdk8.org/admin/UpdateValidMarks.aspx
6
1.4ConfigurationMaster Schedule --> Staff Numberhttps://aeries.lbsdk8.org/admin/MasterSchedule.aspx
7
1.5ConfigurationCourses --> California Specific Fields --> State Course Codehttps://aeries.lbsdk8.org/admin/Courses.aspx
8
1.6Aeries helpGPA fields infohttps://support.aeries.com/support/solutions/articles/14000080533-gpa-s-credits-and-class-rank-overview-and-fieldsGPA overview & STU fields
9
1.7Aeries helpGPA calculation infohttps://support.aeries.com/support/solutions/articles/14000080546-gpa-calculationGPA calculation within GRD & HIS
10
1.8Aeries helpTranscript (HIS) infohttps://support.aeries.com/support/solutions/articles/14000071849-adding-editing-a-student-s-transcriptTranscript (HIS) info
11
1.9VerifyFind SBG grades ready to mass addTOTAL SBG GR SD BY GR SD IF MT = 1 AND GR > 5 AND M1 # " " AND M1 # NG7th gr 03000, 04000, 06000 - 6th gr 06000 in Sandbox
12
2.0InsertMass add gradeshttps://aeries.lbsdk8.org/admin/MassAddStudentRelatedData.aspxAdd PD, CN, TN, CR; limit students by grade; include inactive students, select all, mass add - PD, CN, and TN are primary keys so the process will fail without them but won't generate an error message. Only do this once per year and then update only new students who enter since that date; don't re-add the grade records for pre-existing students.11/21/19
13
2.1VerifyCheck mass adds in GRDTOTAL GRD PD CN BY PD CN11/21/19
14
2.2VerifyCheck mass adds in GRD vs MSTLIST STU SEC MST GRD STU.ID GRD.PD GRD.CN GRD.TN GRD.M2 GRD.SE MST.TN MST.PD IF MST.CN = GRD.CN11/21/19
15
2.3InsertFix Periods in GRD.PDCHANGE STU SEC MST GRD GRD.PD TO MST.PD IF MST.CN = GRD.CN AND GRD.PD # MST.PD Probably will change 0 records if Mass Add was clean.11/21/19
16
2.4InsertFix Teacher Num in GRDCHANGE STU SEC MST GRD GRD.TN TO MST.TN IF MST.CN = GRD.CN AND GRD.TN # MST.TN Should only change half of PE teachers if Mass Add was done well (roughly 84 records for gr. 6-8).11/21/19117 records for gr. 5-8
17
2.5InsertFix Section nums in GRDCHANGE STU SEC MST GRD GRD.SE TO MST.SE IF MST.CN = GRD.CN AND GRD.SE # MST.SEShould change all records (roughly 1044 for gr. 6-8) - this will not work for inactive students, since they're no longer in the section.11/21/191381 records
18
InsertFix Credits in GRDNot needed if all CR were added in Mass Add.
19
2.6FYI onlySee SBG marks for a given course and standardLIST STU SBG SEC CRS CRS.CO SBG.SD SBG.M1 IF SBG.SD = 03000 AND SEC.CN = 037 AND SBG.MT = 1Works
20
2.7InsertExample query; use the ones in CRS tableCHANGE STU SEC MST CRS GRD SBG GRD.M2 TO SBG.M1 IF SBG.SD = 03000 AND SBG.MT = 1 AND GRD.CN = 037 AND SEC.CN = 037 AND MST.PD = GRD.PD AND GRD.SN = STU.SNWORKS unless there's a glitch in SEC. Possibly improved query here: CHANGE STU GRD SBG GRD.M2 TO SBG.M1 IF SBG.SD = 07000 AND SBG.MT = 1 AND GRD.CN = 077 AND GRD.SN = STU.SN AND SBG.SN = STU.SN
21
2.8VerifyExample query; use the ones in CRS tableLIST STU SEC CRS GRD SBG STU.NM CRS.CO SBG.SD GRD.CN SBG.M1 GRD.M2 IF SBG.SD = 03000 AND SBG.MT = 1 AND GRD.CN = 037 AND SEC.CN = 037 AND GRD.SN = STU.SNView grades; possibly a better Query here: LIST STU GRD SBG STU.NM GRD.SE SBG.SD GRD.CN SBG.M1 GRD.M2 IF SBG.SD = 07000 AND SBG.MT = 1 AND GRD.CN = 077 AND GRD.SN = STU.SN AND SBG.SN = STU.SN
22
2.9Run Queries in CRS pageUse the individualized Queries for each Course and each Term listed in the CRS tabFor Gr. 6-8, with six classes per student, this will require 18 queries per term.11/21/19Except writing 02940 period 1
23
3.0RecordSet Current Termhttps://aeries.lbsdk8.org/admin/UpdateMultipleMarkHeadingAndDescriptions.aspx
24
3.1RecordRecompute GPAhttps://aeries.lbsdk8.org/admin/RecomputeGRDGPA.aspxNote: All of these functions say they will take time and generate an email. In practice, they appear to work (7/18/19) within 5 seconds, generating no email.
25
3.2RecordCopy Grades to GBHhttps://aeries.lbsdk8.org/admin/CopyGradesToGRH.aspx
26
3.3RecordCopy Grades to Transcriptshttps://aeries.lbsdk8.org/admin/CopyGradesToHIS.aspxDo this once per grade level. Repeat steps 2.9 through 3.3 for each Term/Trimester if needed.
27
3.4RecordRecompute Cumulative GPAhttps://aeries.lbsdk8.org/admin/RecomputeHISGPA.aspx
28
4.0PublishCALPADS Extractshttps://aeries.lbsdk8.org/admin/CALPADSExtracts.aspx
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100