NCEA School Summary

Contents

Introduction

This report includes the school-level information as found on the School spreadsheet provided by the National Catholic Educational Association (NCEA). When the report is generated, a compressed .zip file containing both the CSV and PDF versions of the report is output. Unzip the file to access the individual reports.

The PDF report duplicates the NCEA Databank School Report distributed by NCEA, and allows the user to view the contents of the School data file. The CSV report duplicates the NCEA School Databank Form Excel file, and is output for submission by the school to the Diocese.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Record Selection

The report selects records from the School, Students, and Staff tables based on the following criteria:

All NCEA-specific information must be completed for all students, teachers, and the school.
The school must not be excluded from NCEA reporting.
The staff member must not be excluded from NCEA reporting.
The student must not be excluded from NCEA reporting.
The student must be enrolled on the Count Day specified by the user at runtime on the report page.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Schools to Include	Use Ctrl+Click to select multiple schools or Shift+Click to select a range of schools. Note: When at a school, only that school will be available.
Students to Include*	Indicate which students to include in the report by selecting one of the following options: The Selected x Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school(s) or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Current Selection Staff*	Indicate which staff members to include in the report by selecting one of the following options: The Selected x Staff Only – Run the report for staff in the current selection. All Staff – Run the report for all staff in the current school(s) or district. Note: If running the report for a single staff member, or group of staff, select the prior to running the report.
Count Date*	Enter the date requested by NCEA as the official count date for the current school year.
Processing Options	Choose a time to run the report: Run Now (Recommended) – Run the report immediately in the background. Schedule – Run the report in the order it is received in the Report Queue. Start Date – The date the report is scheduled to run Start Time – the time the report is scheduled to run Run Once OR Repeat – The report can be scheduled to run one time or run on a Daily, Weekly, Monthly, or Yearly schedule, Weekdays only and an end date can be entered.

Report Output: NCEA School Summary.pdf

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

The percentages are rounded to the closest whole number. In any percent column if the percentage is less than one then <1 is displayed in the field. Due to rounding, the total percent may not add up to 100%.

Location/ Column	Data Element or Column Heading	Description	[Table]FieldName
	School Name	The name of the school.	[Schools]Name
School Address	Principal	The principal's name from School Info.	[Schools]Principal
	Address	The school address from School Info.	[Schools]Address
	E-Mail	The Principal's email from School Info.	[Schools]PrincipalEmail
	School Category	The school's category (Elem/Middle, Secondary or Combined) based on the low and high grades for the school.	[Schools]High_grade [Schools]Low_grade
	Phone	The school phone number from School Info.	[Schools]SchoolPhone
School Information
A1a	Location	The school location.	[S_SCH_NCEA_X]Location
A1b	Sponsorship	The primary sponsorship of the school.	[S_SCH_NCEA_X]Sponsorship
A2	Gender	The gender makeup of the school.	[S_SCH_NCEA_X]SchoolGender
Student Information
B1a	Enrollment by Ethnicity and Religion	The number of students by ethnicity (Hispanic or Non-Hispanic), and religious affiliation. The percent of each group against the total.	[Students]FedEthnicity [S_STU_NCEA_X]ReligiousAffiliation
B1b	Enrollment by Race and Religion	The number of students by race and religious affiliation. The percent of each group against the total.	[StudentRace]RaceCd [S_GEN_NCEA_X]RaceCodeMap [S_STU_NCEA_X]ReligiousAffiliation
B2	Enrollment by Grade Level	The number of students by grade level and school category. The percent of each group. PK students in PowerSchool Grade Level -1 or below are now reported in three categories by age as of September 1 of the current school year: EL-PK2: Number of students who are < 3 years old EL-PK3: Number of students who are < 4 years old EL-PK4: Number of students who are < 5 years old; also includes students who are older than 5 but who remain enrolled in grade level -1 or below. Note: Refer to Report Logic for School Categories for additional details.	[Schools]High_Grade [Schools]Low_Grade [Students]Grade_Level [S_STU_NCEA_X]Ungraded_TF
Professional Staff
C1a	Professional Staff by Ethnicity and Religion	The number of all paid professionals by ethnicity and religious affiliation. Paid professionals are defined as faculty, administrators, counselors, etc. who have responsibility for the teaching and learning process. The percent of each group against the total.	[Users]FedEthnicity [S_USR_NCEA_X]ReligiousAffiliation
C1b	Professional Staff by Race and Religion	The number of all paid professionals by race and religious affiliation. Paid professionals are defined as faculty, administrators, counselors, etc. who have responsibility for the teaching and learning process. The percent of each group against the total.	[TeacherRace]RaceCd [S_GEN_NCEA_X]RaceCodeMap [S_USR_NCEA_X]ReligiousAffilation
C2	Full and Part-time Staffing	The number of paid employees by gender and faculty type. Full time is defined as paid employees who regularly work a full day or 100% of contract. Full time employees may have one position or divide their time between more than one position (teaching/administration, etc.) but work the full schedule. Part-time is defined as paid employees who work less than the full school day/week or 100% of contract.	[UserCoreFields]Gender [S_SSF_NCEA_X]FTE [S_USR_NCEA_X]ReligiousClergyLay
C3	Total Staff by Type	The total number of staff (both professional and non-professional) by type. President/Head of School Principal Assistant Principals Guidance Counselors Teachers Teacher Assistants/Instructional Aides Librarians Other Staff Because all staff are included, the total will not match the totals for the other staff counts, which are limited to professional staff.	[S_SCH_NCEA_X]Staff_Pres [S_SCH_NCEA_X]Staff_Princ [S_SCH_NCEA_X]Staff_Asst_Princ [S_SCH_NCEA_X]Staff_Guid_Cnslr [S_SCH_NCEA_X]Staff_Teacher [S_SCH_NCEA_X]Staff_Teacher_Asst_Aide [S_SCH_NCEA_X]Staff_Lib [S_SCH_NCEA_X]Staff_Other
C4	Teacher Retention	Number of teachers who were employed during the last school year. Number of teachers who did not return for the current school year.	[S_SCH_NCEA_NCEA]Teacher_Last_Year [S_SCH_NCEA_X]Teacher_Not_Return
D. Government Funded Programs
1	Title I	Does the school receive Title I services?	[S_SCH_NCEA_X]OffersTitleI_TF
2	Title II	Does the school receive Title II services?	[S_SCH_NCEA_X]ReceivesTitleII_TF
3	Title III	Does the school receive Title III services?	[S_SCH_NCEA_X]ReceivesTitleIII_TF
4	Title IV	Does the school receive Title IV services?	[S_SCH_NCEA_X]ReceivesTitleIV_TF
5	Receives Title I	The number of students who receive Title I services. If the school is not designated as Receiving Title I Services, no students will be reported.	[S_STU_NCEA_X]TitleI_TF
6	Eligible Title I	The number of students who are eligible for Title I services.	[S_STU_NCEA_X]TitleI_Elig_TF
7	Receives Free/Reduced Lunch	The number of students who receive free or reduced price lunch. If the school is not designated as Offering Federal Nutrition Services, no students will be reported.	[S_STU_NCEA_X]FederalNutrition_TF
8	Eligible Free/Reduced Lunch	The number of students who are eligible for free or reduced lunch.	[S_STU_NCEA_X]FederalNutrition_Elig_TF
9	Parental Choice	The number of students accessing funding through a parental choice program.	[S_STU_NCEA_X]Parental_Choice_TF
E. Additional Information
1	Board, Commission or Council	Does the school have a Board, Commission or Council? A - Advisory C - Consultative F - Limited Jurisdiction L - Full Authority N - No Board Not Selected	[S_SCH_NCEA_X]BoardType
2	Extended Day Program	Does the school have an Extended Day Program?	[S_SCH_NCEA_X]ExtDayProgram_TF
3	Waiting List	Does the school have a waiting list for any grade?	[S_SCH_NCEA_X]WaitList_TF
4	Received E-rate Discount	Did the school receive E-rate telecom discounts during the previous school year?	[S_SCH_NCEA_X]ERateReceived_TF
5	Dual Lang Immersion	Does the school offer a dual language immersion program?	[S_SCH_NCEA_X]Dual_Lang_Imm_TF
6	International Baccalaureate	Does the school offer an International Baccalaureate program?	[S_SCH_NCEA_X]IB_Prog_TF
7	Students – diagnosed disability	The number of students with a diagnosed disability from a Local Education Authority	[S_STU_NCEA_X]DiagnosedDisability_TF
8	International	The number of international students with visas.	[S_STU_NCEA_X]Intl_Visa_TF

Report Output: NCEA School Summary.csv

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Column Letter	Column Heading	Description	[Table]FieldName
A	School Name	The name of the school.	[Schools]Name
B	School Category	The school's category (Elem/Middle, Secondary or Combined) based on the low and high grades for the school.	[Schools]High_grade [Schools]Low_grade
A.1a Location
C	Urban	School is located in an urban area defined as within the limits of a major city or one with at least 50,000 population.	[S_SCH_NCEA_X]Location
D	Inner-city	School is located in an inner-city area defined as located within a major city and characterized by a concentration (greater than 40%) of low-income inhabitants.	same as above
E	Suburban	School is located in a suburban area defined as outside of, but tangent to, a major city or its immediate suburbs.	same as above
F	Rural	School is located in a rural area defined as located outside of an urban or suburban area and having fewer than 50,000 inhabitants.	same as above
G	Virtual	School is a Virtual school.	same as above
A.1b Sponsorship
H	Parish	School is sponsored by a single parish.	[S_SCH_NCEA_X]Sponsorship
I	Inter-parish	School is sponsored by multiple parishes.	same as above
J	Diocesan	School is sponsored by a Diocese.	same as above
K	RelCon/Priv	School is sponsored by a religious congregation or is private.	same as above
A2. Gender
L	Male	School enrollment is predominantly male.	[S_SCH_NCEA_X]SchoolGender
M	Female	School enrollment is predominantly female.	same as above
N	Coed	School enrollment is coed.	same as above
B1. Enrollment by Ethnicity (Race) and Religion
O	NA-Cath	American Indian/Native Alaskan - Catholic	[StudentRace]RaceCd [S_GEN_NCEA_X]RaceCodeMap [S_STU_NCEA_X]ReligiousAffiliation
P	NA-Non	American Indian/Native Alaskan – Non-Catholic	same as above
Q	NA-Unk	American Indian/Native Alaskan - Unknown	same as above
R	Asian-C	Asian - Catholic	same as above
S	Asian-NonC	Asian – Non-Catholic	same as above
T	Asian-Unk	Asian - Unknown	same as above
U	Black-Cath	Black - Catholic	same as above
V	Black-NonC	Black – Non-Catholic	same as above
W	Black-unk	Black - Unknown	same as above
X	HawPI-CathC	Native Hawaiian/Pacific Islander - Catholic	same as above
Y	HawPI-NonC	Native Hawaiian/Pacific Islander – Non-Catholic	same as above
Z	HawPI-unk	Native Hawaiian/Pacific Islander - Unknown	same as above
AA	White-C	White - Catholic	same as above
AB	White-NonC	White – Non-Catholic	same as above
AC	White-unk	White - Unknown	same as above
AD	MR-C	Two or More Races - Catholic	same as above
AE	MR-NonC	Two or More Races – Non-Catholic	same as above
AF	MR-unk	Two or More Races - Unknown	same as above
AG	Unk-C	Unknown – Catholic	same as above
AH	Unk-NonC	Unknown – Non-Catholic	same as above
AI	Unk-unk	Unknown – Unknown	same as above
B2. Enrollment by Grade Level (Elementary/Middle)
AJ	EL-PK2	The number of PK students in grade level -1 or below who are < 3 years old as of September 1.	[Students]Grade_Level [Students]DOB
AK	EL-PK3	The number of PK students in grade level -1 or below who are < 4 years old as of September 1	same as above
AL	EL-PK4	The number of PK students in grade level -1 or below who are < 5 years old as of September 1; also includes students who are older than 5 but who remain enrolled in grade level -1 or below.	same as above
AM	EL-Kind	The number of K students in Elementary/Middle Schools.	[Students]Grade_Level
AN	EL-1	The number of 1^st grade students in Elementary/Middle Schools.	same as above
AO	EL-2	The number of 2^nd grade students in Elementary/Middle Schools.	same as above
AP	EL-3	The number of 3^rd grade students in Elementary/Middle Schools.	same as above
AQ	EL-4	The number of 4^th grade students in Elementary/Middle Schools.	same as above
AR	EL-5	The number of 5^th grade students in Elementary/Middle Schools.	same as above
AS	EL-6	The number of 6^th grade students in Elementary/Middle Schools.	same as above
AT	EL-7	The number of 7^th grade students in Elementary/Middle Schools.	same as above
AU	EL-8	The number of 8^th grade students in Elementary/Middle Schools.	same as above
AV	EL-9	The number of 9^th grade students in Elementary/Middle Schools.	same as above
AW	EL-Ungr	The number of Ungraded students in Elementary/Middle Schools.	[S_STU_NCEA_X]Ungraded_TF
B2. Enrollment by Grade Level (Secondary)
AX	Sec-5	The number of 5^th grade students in Secondary Schools.	[Students]Grade_Level
AY	Sec-6	The number of 6^th grade students in Secondary Schools.	same as above
AZ	Sec-7	The number of 7^th grade students in Secondary Schools.	same as above
BA	Sec-8	The number of 8^th grade students in Secondary Schools.	same as above
BB	Sec-9	The number of 9^th grade students in Secondary Schools.	same as above
BC	Sec-10	The number of 10^th grade students in Secondary Schools.	same as above
BD	Sec-11	The number of 11^th grade students in Secondary Schools.	same as above
BE	Sec-12	The number of 12^th grade students in Secondary Schools.	same as above
BF	Sec-Ungr	The number of Ungraded grade students in Secondary Schools.	[S_STU_NCEA_X]Ungraded_TF
C1. Staff Ethnicity (Race)
BG	NA-Cath	American Indian/Native Alaskan - Catholic	[TeacherRace]RaceCd [S_GEN_NCEA_X]RaceCodeMap [S_USR_NCEA_X]ReligiousAffilation
BH	NA-Non	American Indian/Native Alaskan – Non-Catholic	same as above
BI	NA-unk	American Indian/Native Alaskan - Unknown	same as above
BJ	Asian-C	Asian - Catholic	same as above
BK	Asian-NonC	Asian – Non-Catholic	same as above
BL	Asian-Unk	Asian - Unknown	same as above
BM	Black-C	Black - Catholic	same as above
BN	Black -NonC	Black – Non-Catholic	same as above
BO	Black -unk	Black - Unknown	same as above
BP	HawPI-C	Native Hawaiian/Pacific Islander - Catholic	same as above
BQ	HawPI-NonC	Native Hawaiian/Pacific Islander – Non-Catholic	same as above
BR	HawPI -unk	Native Hawaiian/Pacific Islander - Unknown	same as above
BS	White-C	White - Catholic	same as above
BT	White-NonC	White – Non-Catholic	same as above
BU	White-unk	White - Unknown	same as above
BV	MR-C	Two or More Races - Catholic	same as above
BW	MR-NonC	Two or More Races – Non-Catholic	same as above
BX	MR-unk	Two or More Races - Unknown	same as above
BY	Unk-C	Unknown – Catholic	same as above
BZ	Unk-NonC	Unknown – Non-Catholic	same as above
CA	Unk-unk	Unknown – Unknown	same as above
C2 Full and Part Time Staffing by Gender and Faculty Type
CB	FemRel-FT	Female Religious – Full-time	[UserCoreFields]Gender [S_SSF_NCEA_X]FTE [S_USR_NCEA_X]ReligiousClergyLay
CC	FemRel-PT	Female Religious – Part-time	same as above
CD	MalRel-FT	Male Religious – Full-time	same as above
CE	MalRel-PT	Male Religious – Part-time	same as above
CF	Clergy-FT	Clergy – Full-time	same as above
CG	Clergy-PT	Clergy – Part-time	same as above
CH	MalLay-FT	Lay, Male – Full-time	same as above
CI	MalLay-PT	Lay, Male – Part-time	same as above
CJ	FemLay-FT	Lay, Female – Full-time	same as above
CK	FemLay-PT	Lay, Female – Part-time	same as above
C3 Staff by Type
CL	President/Head of School	President/Head of School	[S_SCH_NCEA_X]Staff_Pres
CM	Principal	Principal	[S_SCH_NCEA_X]Staff_Princ
CN	Assistant Principals	Assistant Principals	[S_SCH_NCEA_X]Staff_Asst_Princ
CO	Guidance Counselors	Guidance Counselors	[S_SCH_NCEA_X]Staff_Guid_Cnslr
CP	Teachers	Teachers	[S_SCH_NCEA_X]Staff_Teacher
CQ	Teacher Assistant/ Instructional Aides	Teacher Assistant/Instructional Aides	[S_SCH_NCEA_X]Staff_Teacher_Asst_Aide
CR	Librarians	Librarians	[S_SCH_NCEA_X]Staff_Lib
CR	Other Staff	Other Staff	[S_SCH_NCEA_X]Staff_Other
C4 Teacher Retention
CS	Retained	The number of teachers who taught at the school both last year and this year.	[S_SCH_NCEA_X]Teacher_Both_Yrs
CT	Total	The number of of teachers who did not return in the Fall for reasons other than retirement.	[S_SCH_NCEA_X]Teacher_Not_Return
D. Government Funded Programs
CU	Title I-Y	School receives Title I services.	[S_SCH_NCEA_X]OffersTitleI_TF
CV	Title I-N	School does not receive Title I services.	[S_SCH_NCEA_X]OffersTitleI_TF
CW	Title II-Y	School receives Title II services.	[S_SCH_NCEA_X]ReceivesTitleII_TF
CX	Title II-N	School does not receive Title II services.	[S_SCH_NCEA_X]ReceivesTitleII_TF
CY	Title III-Y	School receives Title III services.	[S_SCH_NCEA_X]ReceivesTitleIII_TF
CZ	Title III-N	School does not receive Title III services.	[S_SCH_NCEA_X]ReceivesTitleIII_TF
DA	Title IV-Y	School receives Title IV services.	[S_SCH_NCEA_X]ReceivesTitleIV_TF
DB	Title IV-N	School does not receive Title IV services.	[S_SCH_NCEA_X]ReceivesTitleIV_TF
DC	Title 1-R	The number of students who receive Title I services.	[S_STU_NCEA_X]TitleI_TF
DE	Lunch-R	The number of students who receive reduced-price lunch.	[S_SCH_NCEA_X]OffersFedNutrition_TF [S_SCH_NCEA_X]FederalNutritionAll_TF [S_STU_NCEA_X]FederalNutrition_TF
DF	Lunch-E	The number of students who are eligible for free or reduced-price lunch.	[S_STU_NCEA_X]FederalNutrition_Elig_TF
DG	Parental Choice	The number of students accessing funding through a parental choice program.	[S_STU_NCEA_X]Parental_Choice_TF
E. Additional Information
DH	Board-A	Type of Board, Commission, or Council that assists with school governance: Advisory.	[S_SCH_NCEA_X]BoardType
DI	Board-C	Type of Board, Commission, or Council that assists with school governance: Consultative.	[S_SCH_NCEA_X]BoardType
DJ	Board-LJ	Type of Board, Commission, or Council that assists with school governance: Limited Jurisdiction	[S_SCH_NCEA_X]BoardType
DK	Board-FA	Type of Board, Commission, or Council that assists with school governance: Full Authority	[S_SCH_NCEA_X]BoardType
DL	Board - N	Type of Board, Commission, or Council that assists with school governance: No Board	[S_SCH_NCEA_X]BoardType
DM	ExDay-Y	The school has an extended day program.	[S_SCH_NCEA_X]ExtDayProgram_TF
DN	ExDay-N	The school does not have an extended day program.	[S_SCH_NCEA_X]ExtDayProgram_TF
DO	Wait-Y	The school has a wait list for one or more grade levels.	[S_SCH_NCEA_X]WaitList_TF
DP	Wait-N	The school does not have a wait list for one or more grade levels.	[S_SCH_NCEA_X]WaitList_TF
DQ	E-Rate-Y	The school received E-rate telecom discounts during the previous school year.	[S_SCH_NCEA_X]ERateReceived_TF
DR	E-Rate-N	The school did not receive E-rate telecom discounts in the previous school year.	[S_SCH_NCEA_X]ERateReceived_TF
DS	DL-Y	The school offers a dual-language immersion program.	[S_SCH_NCEA_X]Dual_Lang_Imm_TF
DT	DL-N	The school does not offer a dual-language immersion program.	[S_SCH_NCEA_X]Dual_Lang_Imm_TF
DU	IB-Y	The school offers an International Baccalaureate program.	[S_SCH_NCEA_X]IB_Prog_TF
DV	IB-N	The school does not offer an International Baccalaureate program.	[S_SCH_NCEA_X]IB_Prog_TF
DW	Disability	The number of students with a diagnosed disability from a Local Education Authority	[S_STU_NCEA_X]DiagnosedDisability_TF
DX	International	The number of students with international visas.	[S_STU_NCEA_X]Intl_Visa_TF
Combinations of School Location and Sponsorship
EG	Urb-1Par	Urban – Single Parish	[S_SCH_NCEA_X]Location [S_SCH_NCEA_X]Sponsorship
EH	Urb-InterPar	Urban – Inter-Parish	same as above
EI	Urb-Dio	Urban – Diocesan	same as above
EJ	Urb-Pri	Urban – Religious Congregation or Private	same as above
EK	IC-SP	Inner City – Single Parish	same as above
EL	IC-IP	Inner City – Inter-Parish	same as above
EM	IC-D	Inner City – Diocesan	same as above
EN	IC-P	Inner City – Religious Congregation or Private	same as above
EO	S-SP	Suburban – Single Parish	same as above
EP	S-IP	Suburban – Inter-Parish	same as above
EQ	S-D	Suburban – Diocesan	same as above
ER	S-P	Suburban – Religious Congregation or Private	same as above
ES	R-SP	Rural – Single Parish	same as above
ET	R-IP	Rural – Inter-Parish	same as above
EU	R-D	Rural – Diocesan	same as above
EV	R-P	Rural – Religious Congregation or Private	same as above
D. Schools with government funded programs
EW	Title 1	The school provides Title I services.	[S_SCH_NCEA_X]OffersTitleI_TF
EX	Nutrition	The school provides free or reduced-price lunch.	[S_SCH_NCEA_X]OffersFedNutrition_TF
B1a Students by Ethnicity and Religious Affiliation
EY	Y Stud Cath	Hispanic – Catholic	[Students]FedEthnicity [S_STU_NCEA_X]ReligiousAffiliation
EZ	Y Stud NC	Hispanic – Non-Catholic	same as above
FA	Y Stud unk	Hispanic – Unknown	same as above
FB	N Stud Cath	Non-Hispanic – Catholic	same as above
FC	N Stud NC	Non-Hispanic – Non-Catholic	same as above
FD	N Stud unk	Non-Hispanic – Unknown	same as above
B1(a) Ethnicity (Hispanic) - Staff
FE	Y Staf Cath	Hispanic – Catholic	[Users]FedEthnicity [S_USR_NCEA_X]ReligiousAffiliation
FF	Y Staf NC	Hispanic – Non-Catholic	same as above
FG	Y Staf unk	Hispanic – Unknown	same as above
FH	N Staf Cath	Non-Hispanic – Catholic	same as above
FI	N Staf NC	Non-Hispanic – Non-Catholic	same as above
FJ	N Staf unk	Non-Hispanic – Unknown	same as above
Virtual Schools and Schools with Parental Choice Programs)
FK	V-SP	Virtual - Single Parish	[S_SCH_NCEA_X]Location [S_SCH_NCEA_X]Sponsorship
FL	V-IP	Virtual - Interparish	same as above
FM	V-D	Virtual - Diocesan	same as above
FN	V-P	Virtual - Religious Congregation or Private	same as above
FO	PC-Schools	The school has parental choice funding.	[S_STU_NCEA_X]Parental_Choice_TF