Academically and Intellectually Gifted (AIG) Data Collection
Contents
Introduction
Academically and Intellectually Gifted (AIG) data for all actively enrolled students in grades Kindergarten through 13 who have been identified with an AIG Program. There are four AIG Programs in PowerSchool:
- Academically Gifted Math
- Academically Gifted Reading
- Academically Math and Reading
- Intellectually Gifted
Only students that do not have an exit date for the AIG Program prior to the data collection run date are counted.
Report Input
Run Data Collection
This data collection is run at the LEA and School level. Use the following steps to generate the Academically and Intellectually Gifted 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 Academically and Intellectually Gifted 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 Academically and Intellectually Gifted Data Collection, click Review.
- Select one of the following AIG data collection views from the Data View drop-down menu. The Results section displays the data collection results specific for the selected data view.
Notes:
- Click Export to export the data collection results to an Excel spreadsheet
- The AIG Data Collection can be run for students who transfer between LEAs.
Refer to Student Transfer Cheat Sheet, Transferring Out of School, and Transfer Student Record Process documentation located on http://www.nc-sis.org/admit_withdraw.html for more information on transferring students.
Data Collection View | Description |
---|---|
AIG Program Student Detail (Student List) | The listing of the students that are in the data collection. |
AIG Students by Grade Level in School | The total active AIG students by Grade Level. |
AIG Totals by Race and Gender in School | The total number of active AIG students identified by race and gender. |
AIG Totals by Race and Gender (masked) in School | Reporting information to the Federal Government, you can never identify 1 or 2 students; therefore, the user must use less than 5. |
Total AIG Students by Gender and Race in School | The total number of active AIG students by gender and race. |
Total Students with Dual Exceptionality (AIG and other EC) by Gender and Race in School | The total number of active AIG students with dual exceptionality (AIG and other EC) identified by gender and race. |
Total Students Enrolled by Gender and Race in School | The total number of students enrolled by gender and race. |
Percentage of Ethnicity Identified as AIG in School | The total percentage of active AIG students by ethnicity. |
Total AIG Students Percentages, by Gender and Total in School | The total percentage of active AIG students by gender and total in school. |
Dual Exceptionality (AIG and other EC) Percentage by Race and Gender in School | The total percentage of active AIG students with dual exceptionality (AIG and EC) identified by race and gender. |
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. - To narrow your search, select one or more filters, if available.
- 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 a detailed list of AIG 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.
Note: This data review is available aggregated for all schools at the LEA level.
AIG Program Student Detail (Student List)
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Student Name | Concatenated Student Last Name, First Name, Middle Initial | [Students]First_Name [Students]Last_Name [Students]Middle_Name |
Student ID | The student state number. | [Students]State_StudentNumber |
Gender | AIG students enrolled by gender (male and female). | [Students]Gender |
Birthdate | The AIG student’s date of birth. | [Students]DOB |
Grade Level | Grade level for the school year reported. | [Students]Grade_Level |
AIG Identification | The AIG membership in one of the Special Programs. | [S_NC_AIG]AIG_Exceptionality_AM [S_NC_AIG]AIG_Exceptionality_AR [S_NC_AIG]AIG_Exceptionality_AG [S_NC_AIG]AIG_Exceptionality_IG |
AIG Start Date | The AIG Start Date. | [S_NC_AIG]Start_Date |
Ethnicity | The student’s ethnic/race code based on the Scheduling/Reporting Ethnicity value. | [Students]Ethnicity |
EC Exceptionality | The student's Primary SPED Exceptionality, if applicable. | [S_NC_EC]EC_Primary_DIS |
Total Students Enrolled by Gender and Race
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | Students enrolled by gender (male and female). | [S_NC_AIG]Student_Gender |
Asian | The total number of male and female Asian students. | [Students]Ethnicity |
Black | The total number of male and female Black or African American students. | [Students]Ethnicity |
Hispanic | The total number of male and female Hispanic students. | [Students]Ethnicity |
American Indian | The total number of male and female American Indian students. | [Students]Ethnicity |
Pacific Islander | The total number of male and female Pacific Islander students. | [Students]Ethnicity |
White | The total number of male and female White students. | [Students]Ethnicity |
Two or More | The total number of male and female students that are of two or more ethnicities. | [Students]Ethnicity |
Grand Total | The Grand Total of males and female students. | Calculated |
Enrolled Total | The data collection adds the values in each column. | Calculated |
Total AIG Students by Gender and Race
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | AIG students enrolled by gender (male and female). | [S_NC_AIG]Student_Gender |
Asian | The total number of AIG male and female Asian students. | [Students]Ethnicity |
Black | The total number of AIG male and female Black or African American students. | [Students]Ethnicity |
Hispanic | The total number of AIG male and female Hispanic students. | [Students]Ethnicity |
American Indian | The total number of AIG male and female American Indian students. | [Students]Ethnicity |
Pacific Islander | The total number of AIG male and female Pacific Islander students. | [Students]Ethnicity |
White | The total number of AIG male and female White students. | [Students]Ethnicity |
Two or More | The total number of AIG male and female students that are of two or more ethnicities. | [Students]Ethnicity |
Grand Total | The Grand Total of AIG males and AIG female students. | Calculated |
Enrolled Total | The data collection adds the values in each column. | Calculated |
Total AIG Students Percentages, by Gender and Total in School
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Percentage of Total Students Identified as AIG | The Grand Percentage Total of AIG male and AIG female students. | [S_NC_AIG]Student_Gender |
Percentage of Females Identified as AIG | The total number of AIG male and female Black or African American students. | [S_NC_AIG]Student_Gender |
Percentage of Males Identified as AIG | The total number of AIG male and female Hispanic students. | [S_NC_AIG]Student_Gender |
Percentage of Ethnicity Identified as AIG in School
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | AIG students enrolled by gender (male and female). | [S_NC_AIG]Student_Gender |
Asian | The total percentage of AIG male and female Asian students. | [Students]Ethnicity |
Black | The total percentage of AIG male and female Black or African American students. | [Students]Ethnicity |
Hispanic | The total percentage of AIG male and female Hispanic students. | [Students]Ethnicity |
American Indian | The total percentage of AIG male and female American Indian students. | [Students]Ethnicity |
Pacific Islander | The total percentage of AIG male and female Pacific Islander students. | [Students]Ethnicity |
White | The total percentage of AIG male and female White students. | [Students]Ethnicity |
Two or More | The total percentage of AIG male and female with two or more ethnicities. | [Students]Ethnicity |
AIG Totals | The data collection averages the percentage values in each column. | Calculated |
Total Students with Dual Exceptionality (AIG and other EC) by Gender and Race in School
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Gender | Students with dual exceptionality (AIG and other EC) enrolled by gender. | [S_NC_AIG]Student_Gender |
Asian | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are Asian. | [Students]Ethnicity |
Black | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are Black or African American. | [Students]Ethnicity |
Hispanic | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are Hispanic. | [Students]Ethnicity |
American Indian | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are American Indian. | [Students]Ethnicity |
Pacific Islander | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are Native Hawaiian/Pacific Islander. | [Students]Ethnicity |
White | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are White. | [Students]Ethnicity |
Two or More | The total number of AIG male and female students with dual exceptionality (AIG and other EC) that are of two or more ethnicities. | [Students]Ethnicity |
Grand Total | The grand total AIG students (male and female) with dual exceptionality (AIG and other EC). | Calculated |
Dual Totals | The data collection adds the values in each column. | Calculated |
AIG Students by Grade Level in School
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Grade | The AIG grade level. | [Students]Grade_Level |
Students | The number of AIG students per grade level. | Calculated |
Percentage | The percentage of AIG students per grade level. | Calculated |
Total | The data collection adds the values in each column. | Calculated |
Dual (AIG and other EC) Percentage by Race and Gender in School
Report Output Format: Excel spreadsheet.
Data Element | Description | [Table]FieldName |
Gender | Students with dual exceptionality (AIG and other EC) enrolled by gender. | [S_NC_AIG]Student_Gender |
Asian | The total percentage of AIG male and female students with dual exceptionality (AIG and other EC) that are Asian. | [Students]Ethnicity |
Black | The total percentage of AIG male and female students with dual exceptionality (AIG and other EC) that are Black or African American. | [Students]Ethnicity |
Hispanic | Total percentage of AIG students (male and female) with dual exceptionality (AIG and other EC) that are Hispanic. | [Students]Ethnicity |
American Indian | Total percentage of AIG students (male and female) with dual exceptionality (AIG and other EC) that are American Indian. | [Students]Ethnicity |
Pacific Islander | Total percentage of AIG students (male and female) with dual exceptionality (AIG and other EC) that are Native Hawaiian/Pacific Islander. | [Students]Ethnicity |
White | Total percentage of AIG students (male and female) with dual exceptionality (AIG and other EC) that are White. | [Students]Ethnicity |
Two or More | Total percentage of AIG students (male and female) with dual exceptionality (AIG and other EC) that are of that are of two or more ethnicities. | [Students]Ethnicity |
Grand Total | The Grand Total percentage of AIG males and AIG females with dual exceptionality (AIG and other EC). | Calculated |
Total Percent | The data collection averages the percentage values in each column. | Calculated |
AIG Totals by Race and Gender in School
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Exceptionality | The Exceptionality code. | [S_NC_AIG]AIG_Exceptionality_AM [S_NC_AIG]AIG_Exceptionality_AR [S_NC_AIG]AIG_Exceptionality_AG [S_NC_AIG]AIG_Exceptionality_IG |
Total | TotalAIG students by exceptionality code. | Calculated |
Asian (F) | Total female Asian AIG students by exceptionality code. | [Students]Ethnicity |
Asian (M) | Total male Asian AIG students by exceptionality code. | [Students]Ethnicity |
Black (F) | Total female Black or African American AIG students by exceptionality code. | [Students]Ethnicity |
Black (M) | Total male Black or African American AIG students by exceptionality code. | [Students]Ethnicity |
Hispanic (F) | Total female Hispanic AIG students by exceptionality code. | [Students]Ethnicity |
Hispanic (M) | Total male Hispanic AIG students by exceptionality code. | [Students]Ethnicity |
Two or More (F) | Total female AIG students by exceptionality code with two or more ethnic codes. | [Students]Ethnicity |
Two or More (M) | Total male AIG students by exceptionality code with two or more ethnic codes. | [Students]Ethnicity |
American Indian (F) | Total female American Indian AIG students by exceptionality code. | [Students]Ethnicity |
American Indian (M) | Total male American Indian AIG students by exceptionality code. | [Students]Ethnicity |
Pacific Islander (F) | Total female Pacific Islander AIG students by exceptionality code. | [Students]Ethnicity |
Pacific Islander (M) | Total male Pacific Islander AIG students by exceptionality code. | [Students]Ethnicity |
White (F) | Total female White AIG students by exceptionality code. | [Students]Ethnicity |
White (M) | Total male White AIG students by exceptionality code. | [Students]Ethnicity |
Dual Total |
| Calculated |
Totals | The data collection adds the values in each column. | Calculated |
AIG Totals by Race and Gender (Masked) in School
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Exceptionality | The AIG Exceptionality code. | [S_NC_AIG]AIG_Exceptionality_AM [S_NC_AIG]AIG_Exceptionality_AR [S_NC_AIG]AIG_Exceptionality_AG [S_NC_AIG]AIG_Exceptionality_IG |
Total | TotalAIG students by exceptionality code. | Calculated |
Asian (F) | Total female Asian AIG students by exceptionality code. | [Students]Ethnicity |
Asian (M) | Total male Asian AIG students by exceptionality code. | [Students]Ethnicity |
Black (F) | Total female Black or African American AIG students by exceptionality code. | [Students]Ethnicity |
Black (M) | Total male Black or African American AIG students by exceptionality code. | [Students]Ethnicity |
Hispanic (F) | Total female Hispanic AIG students by exceptionality code. | [Students]Ethnicity |
Hispanic (M) | Total male Hispanic AIG students by exceptionality code. | [Students]Ethnicity |
Two or More (F) | Total female AIG students by exceptionality code with two or more ethnic codes. | [Students]Ethnicity |
Two or More (M) | Total male AIG students by exceptionality code with two or more ethnic codes. | [Students]Ethnicity |
American Indian (F) | Total female American Indian AIG students by exceptionality code. | [Students]Ethnicity |
American Indian (M) | Total male American Indian AIG students by exceptionality code. | [Students]Ethnicity |
Pacific Islander (F) | Total female Pacific Islander AIG students by exceptionality code. | [Students]Ethnicity |
Pacific Islander (M) | Total male Pacific Islander AIG students by exceptionality code. | [Students]Ethnicity |
White (F) | Total female White AIG students by exceptionality code. | [Students]Ethnicity |
White (M) | Total male White AIG students by exceptionality code. | [Students]Ethnicity |
Dual |
| Calculated |
Totals | The data collection adds the values in each column. | Calculated |
AIG Program Student Detail (Student List)
Report Output Format: Excel spreadsheet, CSV
Data Element | Description | [Table]FieldName |
Student Name | Concatenated Student Last Name, First Name, Middle Initial | [Students]First_Name [Students]Last_Name [Students]Middle_Name |
Student ID | The student state number. | [Students]State_StudentNumber |
Gender | The student’s gender. Valid values: M or F. | [Students]Gender |
Grade Level | The grade level for the school year reported. | [Students]Grade_Level |
Ethnicity | The student’s ethnic/race code based on the Scheduling/Reporting Ethnicity value. | [Students]Ethnicity |
AIG Program | The AIG program for the student. | [S_NC_AIG]AIG_Exceptionality_AM [S_NC_AIG]AIG_Exceptionality_AR [S_NC_AIG]AIG_Exceptionality_AG [S_NC_AIG]AIG_Exceptionality_IG |
AIG Start Date | The AIG Start Date. | [S_NC_AIG]Start_Date |
Admission Status | The Student Admission Status. | [S_NC_STUDENTINFO]Admission_Status_Code S_NC_REEnrollments[Admission_Status_Code |
EC Exceptionality | The Exceptional Child status. | [S_NC_EC]EC_Primary_DIS
|