Instructions to move ISBE current PARCC 2016 settings into PowerSchool (based on last year's PARCC PNP)

Please remember this is a process in flux as ISBE keeps changing and PowerSchool attempts to keep up.
  • Go to ISBE SIS > Batch Files > Request File
  • Select Assessment PARCC Pre-ID
You will receive an email when the file is ready to be downloaded from Batch Files > Download File
  • Download the PARCC ISBE to PS Template below - to use to create the import file for PowerSchool.
  • Open the PARCC ISBE to PS Template.xlsx  and save with a new name. (So you can use this again.)
  • Open the ISBE Download in a text editor. (I use TextWrangler).
  • Select ALL and copy from the ISBE download.
  • Switch to the PARCC ISBE to PS Template and click in cell A15 (just below the green header row) and paste.
  • Select the data you just pasted and go to your Menu bar and Select Data > Text to Columns.
  • Choose Delimited, then choose Comma.
  • Click Finish
  • now Delete row 15 -  That starts with Parcc Pre-ID  (We don't need that row for PowerSchool)
  • Now Delete the columns we don't need. (Because we should never import unnecessary data)
state_studentnumber
IL_Legal_Last_Name (just change this to Last)
IL_Legal_First_Name (just change this to First)
DOB
IL_RCDTS_Home_School
IL_RCDTS_Serving_School
IL_RCDTS_Testing_School
NA
----- and at the very end you can also remove
Administration    
Enrolled in Home School On or Before May 1    
Enrolled in Home District On or Before May 1

Now comes the tricky part. 
ISBE lists some fields as if they were the same, but they are specific to each test subject.
PowerSchool recognizes that they are distinct for each subject and so has separate fields.
eg
ISBE - Accommodation IEP
PS -  ELA - Accommodation IEP, Math - Accommodation IEP
PS Field Names - S_IL_STU_X.PARCC_ELA_ACCOM_IEP, S_IL_STU_X.PARCC_MATH_ACCOM_IEP
So we have to work with One Subject Group at a time.

Let's start with ELA.
  • Sort by Test Code
  • Since you are going to upload ELA info - delete ALL Math rows. 
  • Now you need the corrected header row for Powerschool.
We are still working with ELA remember.
Row 1 is the ELA field names.
  • Delete the rows between Row 1 and your data. You probably won't be able to delete the green header row. That was created as a Table that allows us to keep the formatting. This is not a huge issue. PS will ignore the line since their is no corresponding student_number.
  • Save as a Tab Delimited file
  • Quick Import into Students

When you get back to doing the Math fields, Row 7 is the Math Header row for PS. Delete the rows above and below to your data.
Save as a Tab Delimited file
Quick Import into Students

Now you can work with the info in PowerSchool until you are ready to upload back to ISBE.
Files:

Plan to join us for our Fall 2015 PSUG-IL User Group meeting on Tuesday, November 17th!!  Meet our new Illinois PowerSchool reps and hear what's new with PowerSchool 9 (and beyond).  Get the latest on IL State Reporting in PowerSchool. 

Do you need to "clean up" the customizations on your system?  Do you have old customizations installed and want to update or install new customizations?  Attend part 1 of our "PowerSchool Modernization" workshops to help bring your system up-to-date.

Our meeting will be a full-day event (9AM - 3PM) and lunch details are forth-coming.  Please sign up if you plan to attend to help us with food planning.  We look forward to seeing you there!!

PSUG-IL Info Exchange Planning Committee

TENTATIVE AGENDA:
8:30:  Continental Breakfast (sponsored by PowerSchool)
9:00:  Welcome/Introductions
9:15:  Illinois State Reporting/PowerSchool Resources & Training/Future Workshops
10:30:  PowerSchool Update
11:45:  Lunch & Learn (sponsored by Bright Arrow)
12:30:  PowerSchool Modernization (Part I)

A HUGE thank you to our meeting sponsors:

  • PowerSchool (continental breakfast)
  • Bright Arrow Technologies (lunch & learn)

Materials/Resources from the meeting:

Congratulations to WILLIE STEVENS from Bloom Township High School District 206 on winning the free tuition raffle for the PSUG-Midwest Conference in March 2016!!!


POWERSCHOOL CONTACTS:


Jim Swaney, Account Executive
james.swaney@powerschool.com
Mobile:  (573) 289-8841

Steve Rutledge, Account Executive
steve.rutledge@powerschool.com
Mobile:  (612) 237-0582

Brad Kerst, Sr. Global Solution Engineer
bradley.kerst@powerschool.com
Mobile:  (906) 202-0993

        

Here are the links to the customizations that were talk about during the meeting.

Nick Peronti's PARCtastics for Illnois - http://nicktech.org/powerschool#Powerschool-page_with_page_title_1-9
New CPM editor - Blue Steel CPM
Nick Peronti's Today's Bus Screen - http://nicktech.org/powerschool#Powerschool-page_with_page_title_1-12

SSO Slide show https://docs.google.com/presentation/d/1u_glnru1pKqaQ64lzu99DmVo9Bq6cab3GLVOjV-s32M/edit?usp=sharing
Also vote up this Enhancement, it will make you feel good  https://powersource.pearsonschoolsystems.com/ers/view.action?enhancement.id=6022&fromSearchResults=true

Roger Sprik's Database Extensions Page - A good overview of DB extensions

Marcia Brenner Associates "Enhancing the Power of PowerSchool" flyer can downloaded under Files below.
 

PEARSON SCHOOL SYSTEMS CONTACT INFORMATION:

Eric Zorr, Account Executive
(920) 562-4601
eric.zorr@pearson.com

Katie Koning, Inside Sales Account Executive
(916) 288-1602
katie.koning@pearson.com

Brad Kerst, Senior Global PowerSchool Specialist
(906) 202-0993
bradley.kerst@pearson.com
 
Files:

Pages

Subscribe to Front page feed