SASIxp: Printing a High School Schedule with Fees Updated: 8/3/01

District Home Page SASIxp Index

The following process will print high school schedules with course fees from the described query. You must enter your course fees in the Fee1 field in the Course file. You would use this query instead of printing schedules from inside the mass scheduling module. The following query will print each student’s schedule for Semester 1 in a 4x4 block scheduling environment, sorted alphabetically by grade level. The schedule will include the value placed in the FEE1 field on the course screen in the Course file. The query also totals the fees and prints that total at the bottom of the Course Fee column. The query can be modified to print second semester schedules, also. Although not tested, it probably can be modified to print both semesters on one page, although the total feature may have to be turned off. Column widths must be adjusted to fit the page and the schedules must be printed in landscape mode. Set your page layout in File/Page Setup. Please note the following about the query: IMPORTANT: After the four files are listed in the columns in the Query table, you must drag the ClassLink field from ASSS to top of the column for ASMS. This links those two files so specific information can be linked for each student’s classes. (The original index between ASSS and ASMS does not work for this query.) The two backslashes (\\) must follow the names of the four files and must precede the PermNum field. This causes the printer to print each student’s schedule on a separate sheet of paper (based on the PermNum). If you DISPLAY this query before printing it, it will not show page breaks. The dollar sign ($) causes the query to sum the numbers in the FEE1 field. That sum is printed at the bottom of the column on the report. This query can be saved as Fall Schedules because the IF statement includes TERMCODE= “S1” OR TERMCODE=”Q1” OR TERMCODE=”Q2”) This query can be copied and saved as Spring Schedules after changing the TERMCODE to S2, Q3, and Q4, respectively. LN and FN are valid abbreviations for LastName and FirstName in the query. PRINT ASTU ASSS ASMS ACRS \\ PERMNUM LN FN GRADE SECTIONID CRSTITLE TERMCODE BEGPERIOD ENDPERIOD CREDIT TCHNUM TCHNAME $ FEE1 SORT GRADE LN FN PERMNUM TERMCODE BEGPERIOD IF 3,COURSE = 4,COURSE AND (TERMCODE="S1" OR TERMCODE= “Q1” OR TERMCODE= “Q2”) IMPORTANT: After the four files are listed in the columns in the Query table, you must drag the ClassLink field from ASSS to top of the column for ASMS, replacing the field name that is already there. The original query was developed and shared by Russ Bowling of Lexington School District 1.