Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
powerschool:powerschool:quickexport [2023/08/16 16:33] lokes |
powerschool:powerschool:quickexport [2023/08/16 16:42] (current) lokes |
| ====== Using Quick Export to Analyze Data for Missing STI's ====== |
| |
Data preparation for growth assessments is scheduled to be pulled mid August. Student STI's along with other required data need to be in PowerSchool before the end of this week. STI's, state testing identifiers, are used statewide for growth assessments and testing purposes. They are normally assigned automatically through a program called SIF. But before this process can happen the required fields (below) must be entered in PowerSchool. | Data preparation for growth assessments is scheduled to be pulled mid August. Student STI's along with other required data need to be in PowerSchool before the end of this week. STI's, state testing identifiers, are used statewide for growth assessments and testing purposes. They are normally assigned automatically through a program called SIF. But before this process can happen the required fields (below) must be entered in PowerSchool. |
| |
------------------------------------------------ | ------------------------------------------------ |
| |
- Find the students with a missing STI with this search string | * Find the students with a missing STI with this search string |
State_StudentNumber = | State_StudentNumber = |
- Go to the Group Functions at the bottom right and click the down arrow to select the QUICK EXPORT | * Go to the Group Functions at the bottom right and click the down arrow to select the QUICK EXPORT |
- Use these fields (copy/paste because every letter counts) to create an export file with all the values recorded in PowerSchool: | * Use these fields (copy/paste because every letter counts) to create an export file with all the values recorded in PowerSchool:\\ |
Student_Number// | Student_Number\\ |
lastfirst// | lastfirst\\ |
entrydate// | entrydate\\ |
entrycode// | entrycode\\ |
grade_level// | grade_level\\ |
S_VA_STU_X.Responsible_Division// | S_VA_STU_X.Responsible_Division\\ |
S_VA_STU_X.Responsible_School// | S_VA_STU_X.Responsible_School\\ |
S_VA_STU_X.Serving_Division// | S_VA_STU_X.Serving_Division\\ |
S_VA_STU_X.Serving_School// | S_VA_STU_X.Serving_School\\ |
dob// | dob\\ |
S_VA_STU_X.Virginia_Ethnicity_Race_Code// | S_VA_STU_X.Virginia_Ethnicity_Race_Code\\ |
fedethnicity// | fedethnicity\\ |
ethnicity// | ethnicity\\ |
Gender// | Gender\\ |
S_VA_STU_X.Military_Connected// | S_VA_STU_X.Military_Connected\\ |
| |
| |
- Open MS Excel and then navigate to the Download folder to open the text export file (choose to display All Files not only Excel Files) | * Open MS Excel and then navigate to the Download folder to open the text export file (choose to display All Files not only Excel Files) |
| |
- Click Next, next, next, finish to import the text file into the MS Excel file | * Click Next, next, next, finish to import the text file into the MS Excel file |
| |
- Click to top left corner of the Excel file to highlight the entire spreadsheet | * Click to top left corner of the Excel file to highlight the entire spreadsheet |
| |
- Navigate to the Filter-Sort option to sort all highlighted columns\\ | * Navigate to the Filter-Sort option to sort all highlighted columns\\ |
| |
| |