PREPARING THE WORKBOOK TO DEVELOP WORKPAPERS
- Obtain the ASPEN/NJSmart student spreadsheet extract that was transmitted to DOE on October 15th.
- Create a copy of the data sheet, labeled revised data, and leave the original sheet intact for audit.
- Work with the revised data sheet.
- Sort on Status and delete all Inactive students.
- Sort on Local ID and remove NP students to a new sheet labeled NP. They are not reported on the ASSA. Add heading row.
- Sort on Local ID and remove ODP students to a new sheet labeled Sent ODP. They are not reported on the ASSA as On Roll for MK or MH. Add heading row.
- Sort on Tuition Code and remove 06, Choice students to a new sheet labeled 06-Choice. These students are reported separately on the ASSA and not included in each school’s On Roll count. The ASSA Summary does give the District credit for these students in the Resident Students calculation. Add heading row.
- Sort on Tuition Code and remove 05, Tuition Free to a new sheet labeled 05-Tuition Free. Tuition code 05 students are tuition free students and should not be counted as Received or On Roll. They do not get counted on the ASSA. They are usually Choice students registered beyond the NJDOE cap of 128 for MHRD. If any students are reported with District Code Resident 3370, which is MHRD, investigate. Add heading row.
- Sort on Tuition Code and remove 03, Paid by the State students to a new sheet labeled 03-Paid by the State. Add heading row.
- Sort on Tuition Code and remove 01, Paid by Another District students to a new sheet labeled 01-Paid by Another District. Add heading row.
- Generate a report from the students system with tuition codes 01 and 03. In some cases these students are tagged as “Do Not Report” for state reporting and are not included in the NJSMART file. Add them to the ASSA Data Workbook on the 01-Paid by Another District and 03-Paid by the State sheet.
- These students, 01 and 03, are counted On Roll and as Received.
- Sort on Enrollment Type and remove S, Shared Time to a new sheet labeled Sent Shared. These students are usually just Vocational School and ARE reported in each schools On Roll count as shared time.
- Sort on Local ID. Cut and paste all A and E students to a new sheet labeled AHS On Roll.
- Sort on School Code Attending. Cut and Paste all MH 50 to a new sheet labeled MH On Roll.
- Sort on School Code Attending. Cut and Paste all MH 60 to a new sheet labeled MK On Roll.
- Any students remaining on the revised data sheet must be investigated.
Revision:
44
Last modified:
27 October 2020