Differences

This shows you the differences between two versions of the page.

--- powerschool:powerschool:quickexport [2023/08/16 16:24]
lokes created
+++ powerschool:powerschool:quickexport [2023/08/16 16:42] (current)
lokes
@@ Line 1: / Line 1: @@
+====== 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.
@@ Line 41: / Line 43: @@
 ------------------------------------------------
-- Find the students with a missing STI with this search string
+  * Find the students with a missing STI with this search string
         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)
-- 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
+  * 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)
-- Navigate to the Filter-Sort option to sort all highlighted columns
+  * 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
+  * Navigate to the Filter-Sort option to sort all highlighted columns\\
 Now, you can FILTER on the blank values in each column separately to find the missing data.
 Remember, the Responsible Div, School, Serving Div, Schools should be BLANK -- that is GOOD
 HINT: I created this file for VIES while creating these instructions. They are only missing the Ethnicity / Race. You can start looking at those first.
-Remember:
+**Remember**://With the Student number in your export file, you can also have us import the missing data for you! Fill it in and send it to me or Jennifer.
-With the Student number in your export file, you can also have us import the missing data for you! Fill it in and send it to me or Jennifer.
+//\\
 Thank you for all your hard work. Let us know how to help you.

Knowledge Base

User Tools

Site Tools

Differences

Page Tools