A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Step # | Type | Name | Query or URL | Comments/Details | Done? | ||||||||||||||||||||
2 | 1.0 | Aeries help | EOY 1 Course and Staff Files | https://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.1 | Data links | debugging/config info | https://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.2 | Configuration | Transcript Definition --> Terms | https://aeries.lbsdk8.org/admin/TranscriptDefinition.aspx | ||||||||||||||||||||||
5 | 1.3 | Configuration | Grade Reporting --> Valid Marks | https://aeries.lbsdk8.org/admin/UpdateValidMarks.aspx | ||||||||||||||||||||||
6 | 1.4 | Configuration | Master Schedule --> Staff Number | https://aeries.lbsdk8.org/admin/MasterSchedule.aspx | ||||||||||||||||||||||
7 | 1.5 | Configuration | Courses --> California Specific Fields --> State Course Code | https://aeries.lbsdk8.org/admin/Courses.aspx | ||||||||||||||||||||||
8 | 1.6 | Aeries help | GPA fields info | https://support.aeries.com/support/solutions/articles/14000080533-gpa-s-credits-and-class-rank-overview-and-fields | GPA overview & STU fields | |||||||||||||||||||||
9 | 1.7 | Aeries help | GPA calculation info | https://support.aeries.com/support/solutions/articles/14000080546-gpa-calculation | GPA calculation within GRD & HIS | |||||||||||||||||||||
10 | 1.8 | Aeries help | Transcript (HIS) info | https://support.aeries.com/support/solutions/articles/14000071849-adding-editing-a-student-s-transcript | Transcript (HIS) info | |||||||||||||||||||||
11 | 1.9 | Verify | Find SBG grades ready to mass add | TOTAL SBG GR SD BY GR SD IF MT = 1 AND GR > 5 AND M1 # " " AND M1 # NG | 7th gr 03000, 04000, 06000 - 6th gr 06000 in Sandbox | |||||||||||||||||||||
12 | 2.0 | Insert | Mass add grades | https://aeries.lbsdk8.org/admin/MassAddStudentRelatedData.aspx | Add 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.1 | Verify | Check mass adds in GRD | TOTAL GRD PD CN BY PD CN | 11/21/19 | |||||||||||||||||||||
14 | 2.2 | Verify | Check mass adds in GRD vs MST | LIST STU SEC MST GRD STU.ID GRD.PD GRD.CN GRD.TN GRD.M2 GRD.SE MST.TN MST.PD IF MST.CN = GRD.CN | 11/21/19 | |||||||||||||||||||||
15 | 2.3 | Insert | Fix Periods in GRD.PD | CHANGE 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.4 | Insert | Fix Teacher Num in GRD | CHANGE 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/19 | 117 records for gr. 5-8 | |||||||||||||||||||
17 | 2.5 | Insert | Fix Section nums in GRD | CHANGE STU SEC MST GRD GRD.SE TO MST.SE IF MST.CN = GRD.CN AND GRD.SE # MST.SE | Should 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/19 | 1381 records | |||||||||||||||||||
18 | Insert | Fix Credits in GRD | Not needed if all CR were added in Mass Add. | |||||||||||||||||||||||
19 | 2.6 | FYI only | See SBG marks for a given course and standard | LIST STU SBG SEC CRS CRS.CO SBG.SD SBG.M1 IF SBG.SD = 03000 AND SEC.CN = 037 AND SBG.MT = 1 | Works | |||||||||||||||||||||
20 | 2.7 | Insert | Example query; use the ones in CRS table | CHANGE 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.SN | WORKS 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.8 | Verify | Example query; use the ones in CRS table | LIST 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.SN | View 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.9 | Run Queries in CRS page | Use the individualized Queries for each Course and each Term listed in the CRS tab | For Gr. 6-8, with six classes per student, this will require 18 queries per term. | 11/21/19 | Except writing 02940 period 1 | ||||||||||||||||||||
23 | 3.0 | Record | Set Current Term | https://aeries.lbsdk8.org/admin/UpdateMultipleMarkHeadingAndDescriptions.aspx | ||||||||||||||||||||||
24 | 3.1 | Record | Recompute GPA | https://aeries.lbsdk8.org/admin/RecomputeGRDGPA.aspx | Note: 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.2 | Record | Copy Grades to GBH | https://aeries.lbsdk8.org/admin/CopyGradesToGRH.aspx | ||||||||||||||||||||||
26 | 3.3 | Record | Copy Grades to Transcripts | https://aeries.lbsdk8.org/admin/CopyGradesToHIS.aspx | Do this once per grade level. Repeat steps 2.9 through 3.3 for each Term/Trimester if needed. | |||||||||||||||||||||
27 | 3.4 | Record | Recompute Cumulative GPA | https://aeries.lbsdk8.org/admin/RecomputeHISGPA.aspx | ||||||||||||||||||||||
28 | 4.0 | Publish | CALPADS Extracts | https://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 |