NCEA School Summary
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, seeHow 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. |
Students to Include* | Indicate which students to include in the report by selecting one of the following options:
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:
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:
|
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 | |
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 | |
NCEA Membership ID (if applicable) RECENT UPDATE | The NCEA School Membership ID. This field is left blank if the membership ID is not updated. | [S_SCH_NCEA_X]NCEAID | |
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:
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?
| [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 1st grade students in Elementary/Middle Schools. | same as above |
AO | EL-2 | The number of 2nd grade students in Elementary/Middle Schools. | same as above |
AP | EL-3 | The number of 3rd grade students in Elementary/Middle Schools. | same as above |
AQ | EL-4 | The number of 4th grade students in Elementary/Middle Schools. | same as above |
AR | EL-5 | The number of 5th grade students in Elementary/Middle Schools. | same as above |
AS | EL-6 | The number of 6th grade students in Elementary/Middle Schools. | same as above |
AT | EL-7 | The number of 7th grade students in Elementary/Middle Schools. | same as above |
AU | EL-8 | The number of 8th grade students in Elementary/Middle Schools. | same as above |
AV | EL-9 | The number of 9th 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 5th grade students in Secondary Schools. | [Students]Grade_Level |
AY | Sec-6 | The number of 6th grade students in Secondary Schools. | same as above |
AZ | Sec-7 | The number of 7th grade students in Secondary Schools. | same as above |
BA | Sec-8 | The number of 8th grade students in Secondary Schools. | same as above |
BB | Sec-9 | The number of 9th grade students in Secondary Schools. | same as above |
BC | Sec-10 | The number of 10th grade students in Secondary Schools. | same as above |
BD | Sec-11 | The number of 11th grade students in Secondary Schools. | same as above |
BE | Sec-12 | The number of 12th 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 |