| Class
Description: |
Agenda
9am-Noon (ODE presentation presented by NCOCC)
-Data Collector FTE Reports
-FTE Adjustment Report
-FTE Detail Report
-FTE Summary Reports
This presentation will focus on troubleshooting the FTE
Reports in order to resolve data reporting issues and
verify data for accuracy and completeness.
1pm-4pm
NCOCC FTE Reconciliation in Excel
NCOCC guides districts step by step through
troubleshooting the FTE Detail report in Excel from
preparing the FTE detail report in Excel with district
names instead of IRN's to data quality checks including
fatal & critical errors to reconciling FTE detail data to
the SFPR report for treasurers. New to error checking is
the ability to add power queries in replacement of
filters and pivot table refresh by just adding updated
source data (updated FTE report), no more recreating the
same tired worksheets each week, simply refresh :)
EMIS 101 - Prepare FTE Detail in Excel
Merge District Name to IRN
Errors Checking:
-No Names
-999999 & IRN-IRN-**-**
-Fatal Error: NFRG, NFER, NFST, **** & Inclusion = NONE
-Calendar Totals
-Critical Error: Adjusted FTE > 0 AND < Original FTE
-Fatal Error: FTE = 0
-FTE < 1
-Not Available Errors
Data Quality
-FTE = 1
-% of Time
-Economic Disadvantagement
-LEP
-Special Ed.
SFPR Reconciliation for Treasurers
-Students Educated Elsewhere
-Preschool Funding Pivot
-Open Enrollment Funding
-SFPR Reconciliation
|
