PFT Submissions Manual 2018-2019
Step #1
Create a “PFT 2018-19” folder on your desktop:
Step #2
Next, go to
www.pftdata.org. Look for “Resources” and click on the words
“PFT Resources”
Under Data Submission download the 2018-19 Excel Template and Instructions file to the PFT 2018-19 folder you made on your desktop.
Note: This is a “zipped” file. Unzip it then save the Excel file to your folder, or drag the zipped file and drop it in the folder to open there.
Read the Instructions BEFORE creating the 2018-19 Excel Template detailed below.
Step #3
Step #4
Step #5
Sign into your
PFT District Portal again and you will find the file from San Joaquin ready to be downloaded and save it to the
PFT 2018-19 folder on your Desktop.
After saving the file, open the Excel doc in your PFT 2018-19 folder. (This is the excel file that came from the PFT Resources in Step 2 above)
Click to “Enable editing” (your worksheet may already be ready for this)
On your spreadsheet, click on the
Data tab then choose
From Text…
Choose to import the ‘STAR’ file you just received from the PFT group (it is in your
PFT 2018-19 folder)
Note that you will need to “tell” the importer which cell to begin with (see the RED cell indicated below)
Choose that same cell on your Excel spreadsheet and then click “OK”.
You have now filled in all Basic Student Demographics. (Note: Remember to populate column D (Charter School Code) all the way down the column. This info is not in the SpSIS.)
Preparing your Spreadsheet
By highlighting and right-clicking you can “hide” cells you don’t need to work with.
Keep cells E, F & G (Grade, Student Last Name and Student First Name)
Hide all other cells until you get to column AI (PFT Start Date Month)
Now click on the
View tab to “freeze” panes by noting where you want to start the “freeze” (see below)
You are now ready to fill in PFT Test Results for individual students. The “Frozen Frames” will make this job easy.
#6 Ready to enter Student Data Results in your Spreadsheet
You have just prepared the Student Data Template Spreadsheet for capturing each student’s PFT results. Be sure you refer back to the 2018-19 PFT Student Data Template Instructions (which were in the original zip file you downloaded) should you have any questions at all about how to enter your data!!