Graduate Data Verification (Also Called Graduate Survey) Data Collection
Contents
Introduction
The Graduate Data Verification Collection contains demographic information, Diploma Type, and post-graduate intentions of North Carolina high school graduates. This collection provides data needed for state and federal reporting and also provides the LEA's statewide an authoritative list of their graduates. The data is used for the annual North Carolina Public Schools Statistical Profile as well as the State Archives, which occasionally has become the only existing record of an individual's graduation.
Classifications of Graduates are as follows:
- Summer School Graduates - must have a diploma issue date BETWEEN July 1 and the DAY BEFORE the 1st instructional day (based on the school calendar) and they are in a grade level greater than and/or equal to 12 or Grade = GR (99 in PS) and MUST have taken a summer school course entered in PowerSchool historical grades with school name = LOCS. The classification for these students will be shown as '20xx Summer School Graduate' e.g., 2012 Summer School Graduate. There could potentially be 10th or 11th graders who have enough credits to graduate. These graduates should be shown as '11th Grade Homeroom/Other Grade'. Other possible graduate classification are '12th Grade Extended Day', 13th Grade Mid-Year" and 13th Grade Regular Program'.
- Mid-year/Early Graduates - must have a diploma issue date within the following range: beginning the 1st instructional day of school and the DAY BEFORE the last instructional day of school (based on the school calendar). The classification for these students will be shown as 'XX Grade Mid-Year Graduates' where the XX represents their grade level, e.g., 12th grade Mid-Year Graduate. There could potentially be 10th or 11th graders who have enough credits to graduate. These graduates should be shown "11th Grade Homeroom/Other Grade'. Other possible graduate classifications are '12th Grade Extended Day, 13th Grade Mid-Year; and 13th Grade Regular Program'.
- Regular Program Graduates - must have a diploma issue date ON or AFTER the last instructional day of school (according to the school calendar) and ON or BEFORE June 30, xxxx. The classification for these students will be shown as 'XX Grade Regular Program Graduate' where XX represents their grade level. There could potentially be 10th or 11th graders who have enough credits to graduate. These graduates should be shown as '11th Grade Homeroom/Other Grade'. Other possible graduate classifications are '12th Grade Extended Day', '13th Grade Mid-Year' and '13th Grade Regular Program'.
Report Input
Run Data Collection
This report collection is run at the School level. The LEA can choose to run this collection at any time for all schools that have not yet approved their data.
Use the following steps to generate the Graduate Data Verification Collection.
- On the Start Page, click State Reports. The State Reporting Dashboard page appears and displays a list of data collections for the school.
- Next to the Graduate Data Verification Collection, click Run.
- The system validates the data against the business rules set up for the collection and completes the process.
- Users have 24 hours to approve their data collection. If approval is not done within the 24 hours, the users must re-run the collection.
Review Data Collection
- Next to the Graduate Data Verification Collection, click Review.
Select one of the following GDV data collection views from the Data View drop-down menu. The Results section displays the data collection results specific for the selected data view.
Data Collection View
Description
Student Detail - All Classifications report
Collect the student IDs, demographic information, course of study and post-graduation intentions of high school graduates.
Certificates by Post Graduate Intention
Collect the demographic information and post-graduate intentions of high school graduates with certificates.
Certificates by Course of Study
Collect the demographic information and course of study of high school graduates with certificates.
Diplomas by Course of Study
Collect the demographic information and course of study of high school graduates with diplomas.
Diplomas by Post Graduate Intention
Collect the demographic information and post graduate intentions of high school graduates with diplomas.
- To narrow your search, select one or more filters, if available.
- Click Refresh. The Results section displays the filtered data collection results specific for the selected data view.
Note: Click Export to export the data collection results to an Excel spreadsheet.
Review Exceptions
Use the following steps to review exceptions for a data collection.
- From the Dashboard, click Review. The Review page appears.
- Select Exceptions from the Reviews drop-down menu. Exceptions associated with a data collection display.
- Select the exception type from the Choose exception drop-down menu. The Business Rule and Steps to Correct for the selected exception type appear on the page.
The Results section displays detailed information associated with the selected exception.
4. To narrow your search, select one or more filters, if available.
5. Click Refresh.
The Results section displays the filtered exception results specific for the selected data view.
Note: Click Export to export the data collection results to an Excel spreadsheet.
PowerSchool provides data validation to promote data integrity by preventing invalid data from being entered or imported into PowerSchool. Refer to the Validation Reports section for detailed list of GDV data and user interface validation checks that provide additional information and the necessary steps to correct exceptions, if applicable.
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Student Detail - All Classifications (School View)
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Student ID | The student state number. | [Students]State_StudentNumber |
Last Name | The student’s last name. | [Students]Last_Name |
First Name | The student’s first name. | [Students]First_Name |
Gender | Identifies male and female students Valid values: M or F. | [Students]Gender |
Ethnicity | The student’s ethnic/race code based on the Scheduling/Reporting Ethnicity value. | [Students]Ethnicity |
Course of Study | The student’s graduation plan. (Diploma Type) | [S_NC_Academic]Diploma_Type_Code |
Graduation Documentation | The student’s graduation documentation. Valid values:
If DIPLOMA_TYPE_CODE is "GCER" or "CERT" then display "Certificate", otherwise display "Diploma" | Derived based on [S_NC_Academic] Diploma_Type_Code |
Classification | The student’s classification is one of the following: Summer School Graduates - must have a diploma issue date AFTER the last instructional day of the previous school year and BEFORE the beginning of the current year; and they are in a grade level greater than and/or equal to 10 and MUST have taken a summer school course entered in PowerSchool historical grades with school name = LOCS. Mid-Year/Early Graduates - must have a diploma issue date that is PRIOR to the last instructional day of school year according to the 20xx-20xx school calendar. Regular Program Graduates - must have a diploma issue date ON or AFTER the last day of school according to the school calendar. | Derived This field is derived if the Diploma_Type is "GCER" then display "Certificate", otherwise display "Diploma" |
Post Graduate Intention Code | Indicates where the student plans to go after graduation (work, community college, university, etc.). | [S_NC_Academic]Bound_For_Code |
Student Detail - All Classifications (LEA View)
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
School Number | The school number. | [Schools]School_Number |
SchoolName | The school name. | [Schools]School_Name |
Student ID | The student state number. | [Students]State_StudentNumber |
Last Name | The student’s last name. | [Students]Last_Name |
First Name | The student’s first name. | [Students]First_Name |
Gender | Identifies male and female students Valid values: M or F. | [Students]Gender |
Ethnicity | The student’s ethnic/race code based on the Scheduling/Reporting Ethnicity value. | [Students]Ethnicity |
Course of Study | The student’s graduation plan. (Diploma Type) | [S_NC_Academic]Diploma_Type_Code |
Graduation Documentation | The student’s graduation documentation. Valid values:
If DIPLOMA_TYPE_CODE is "GCER" or "CERT" then display "Certificate", otherwise display "Diploma" | Derived based on [S_NC_Academic]Diploma_Type_Code |
Classification | The student’s classification is one of the following: Summer School Graduates - must have a diploma issue date AFTER the last instructional day of the previous school year and BEFORE the beginning of the current year; and they arein a grade level greater than and/or equal to 10 and MUST have taken a summer school course entered in PowerSchool historical grades with school name = LOCS. Mid-Year/Early Graduates - must have a diploma issue date that is PRIOR to the last instructional day of school year according to the 20xx-20xx school calendar. Regular Program Graduates - must have a diploma issue date ON or AFTER the last day of school according to the school calendar. | Derived This field is derived if the Diploma_Type is "GCER" then display "Certificate", otherwise display "Diploma" |
Post Graduate Intention Code | Indicates where the student plans to go after graduation (work, community college, university, etc.). | [S_NC_Academic]Bound_For_Code |
Certificates by Post Graduate Intention
Report Output Format: Excel spreadsheet
Data Element | Description | [Table]FieldName |
Gender | Identifies male and female students who graduate with a certificate and have a post graduate intention classification. | [Students]Gender |
Post Graduate Intention | The post-graduation plan for male and female students who graduate with a certificate. | [S_NC_Academic] |
American Indian | The total number of male and female American Indian students who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
Asian | The total number of male and female Asian students who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
Black | The total number of male and female Black or African American students who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
White | The total number of male and female White students who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
Native Hawaiian/Pacific Islander | The total number of male and female Pacific Islander students who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
Hispanic | The total number of male and female Hispanic students who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
Two or More | The total number of male and female students with two or more ethnicity/race codes who graduate with a certificate and have a post graduate intention classification. | [Students]Ethnicity |
Total Males/Total Females | The total number of male and female students who graduate with a certificate and have a post graduate intention classification. | Calculated |
TOTAL | The data collection adds the values in each column. | Calculated |
Certificates by Course of Study
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | Identifies male and female students with a course of study (Diploma Type) code of GCER. | [Students]Gender |
Course of Study | Identifies students with a course of study (Diploma Type) code of GCER. | [S_NC_Academic]Diploma_Type_Code |
American Indian | The total number of male and female American Indian students with a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Asian | The total number of male and female Asian students with a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Black | The total number of male and female Black or African American students with a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
White | The total number of male and female White students with a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Native Hawaiian/Pacific Islander | The total number of male and female Pacific Islander students with a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Hispanic | The total number of male and female Hispanic students with a course of study (GCER) classification. | [Students]Ethnicity |
Two or More | The total number of male and female students with two or more ethnicities with a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Total Males/Females | The total number of male and female students with a course of study (Diploma Type) code of GCER. | Calculated |
TOTAL | The data collection adds the values in each column. | Calculated |
Diplomas by Course of Study
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | Identifies male and female students who graduate with a diploma and have a course of classification. | [Students]Gender |
Course of Study Code | Students with a course of study classification. | [S_NC_Academic]Diploma_Type_Code |
American Indian | The total number of male and female American Indian students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Asian | The total number of male and female Asian students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Black | The total number of male and female Black or African American students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
White | The total number of male and female White students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Native Hawaiian/Pacific Islander | The total number of male and female Pacific Islander students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Hispanic | The total number of male and female Hispanic students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Two or More | The total number of male and female students with two or more ethnicities who graduate with a diploma and a course of study (Diploma Type) code of GCER. | [Students]Ethnicity |
Total Males/Females | The total number of male and female students who graduate with a diploma and a course of study (Diploma Type) code of GCER. | Calculated |
TOTAL | The data collection adds the values in each column. | Calculated |
Diplomas by Post Graduate Intention
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | Identifies male and female students who graduate with a diploma and a post graduate intention classification. | [Students]Gender |
Post Graduate Intention Code | Identifies post graduate intentions for students who graduate with a diploma. | [S_NC_Academic]Diploma_Type_Code [S_NC_Academic]Bound_For_Code |
American Indian | The total number of male and female students American Indian students who graduate with a diploma and a post graduate intention classification. | [Students]Ethnicity |
Asian | The total number of male and female students Asian students who graduate with a diploma and a post graduate intention classification. | [Students]Ethnicity |
Black | The total number of male and female students Black or African American students who graduate with a diploma and a post graduate intention classification. | [Students]Ethnicity |
White | The total number of male and female students White students who graduate with a diploma and a post graduate intention classification. | [Students]Ethnicity |
Native Hawaiian/Pacific Islander | The total number of male and female students Pacific Islander students who graduate with a diploma and a post graduate intention classification. | [Students]Ethnicity |
Hispanic | The total number of male and female students Hispanic students who graduate with a diploma and a post graduate intention classification. | [Students]Ethnicity |
Two or More | The total number of male and female students with two or more assigned ethnic types and a post graduate intention classification. | [Students]Ethnicity |
Total Males/Females | The total number of male and female students who graduate with a diploma and a post graduate intention classification. | [Students]Gender |
TOTAL | The data collection adds the values in each column. | Calculated |