Skip to main content
Skip table of contents

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.

  1. On the Start Page, click State Reports. The State Reporting Dashboard page appears and displays a list of data collections for the school.
  2. Next to the Academically and Intellectually Gifted Collection, click Run.
  3. The system validates the data against the business rules set up for the collection and completes the process.
  4. 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

  1. Next to the Academically and Intellectually Gifted Data Collection, click Review.
  2. 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.

  1. From the Dashboard, click Review. The Review page appears.
  2. Select Exceptions from the Reviews drop-down menu. Exceptions associated with a data collection display.
  3. 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 a detailed list of AIG data and user interface validation checks that provide additional information and the necessary steps to correct exceptions, if applicable.

Back to Top

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

 

Back to Top 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.