Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
plsis:pft_submissions [2017/02/16 18:56] max |
plsis:pft_submissions [2019/02/12 18:04] (current) max |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{tag>testing pft admin}} | + | {{tag>testing pft admin video webinar_wednesday pre_id}} |
| - | ====== PFT Submissions Manual 2016-2017 ====== | + | ====== PFT Submissions Manual 2018-2019 ====== |
| + | |||
| + | {{ :plsis:2017-03-15_14.03_pft__student_data_testing_template_creation.mp4?nolink&700 |}} | ||
| + | |||
| + | ---- | ||
| {{ :plsis:pft_submissions1.png?nolink&700 |}} | {{ :plsis:pft_submissions1.png?nolink&700 |}} | ||
| ====Step #1==== | ====Step #1==== | ||
| - | * Create a “PFT 2016-17” folder on your desktop: \\ {{:plsis:pft_submissions2.png?nolink&200|}} \\ | + | * Create a “PFT 2018-19” folder on your desktop: \\ {{:plsis:pft_submissions2.png?nolink&200|}} \\ |
| ====Step #2==== | ====Step #2==== | ||
| - | * Next, go to www.pftdata.org. Look for “Resources” and click on the words **__“PFT Resources”__** \\ {{:plsis:pft_submissions3.png?nolink&400|}} \\ | + | * Next, go to www.pftdata.org. Look for “Resources” and click on the words **__“PFT Resources”__** \\ {{:plsis:pft_submissions3.png?nolink&400|}} \\ \\ \\ |
| - | * Under **Data Submission** download the **__2016-17 Excel Template and Instructions__** file to the **PFT 2016** folder you made on your desktop. | + | * Under **Data Submission** download the **__2018-19 Excel Template and Instructions__** file to the **PFT 2018-19** folder you made on your desktop. \\ |
| - | * <wrap tip>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.</wrap> \\ {{ :plsis:pft_submissions4.png?nolink&700 |}} \\ | + | * <wrap tip>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.</wrap> \\ \\ {{ :plsis:pft_submissions4.png?nolink&700 |}} \\ |
| - | * <wrap important> Read the Instructions BEFORE creating the 2016-17 Excel Template detailed below. </wrap> | + | * <wrap important> Read the Instructions BEFORE creating the 2018-19 Excel Template detailed below. </wrap> |
| ====Step #3==== | ====Step #3==== | ||
| - | * Now, create a file from the SIS to put into your desktop PFT 2016-17 folder. In the SpSIS, follow this path: **__Admin>Test Module>PreID in Common Format__** \\ {{:plsis:pft_submissions5.png?nolink&600|}} \\ | + | * Now, create a file from the SIS to put into your desktop PFT 2018-19 folder. In the SpSIS, follow this path: **__Admin>Test Module>PreID in Common Format__** \\ {{:plsis:pft_submissions5.png?nolink&600|}} \\ \\ \\ |
| * On the Pre-Id page only complete numbers 1-3. | * On the Pre-Id page only complete numbers 1-3. | ||
| - | * #1 Pick “Science CST Pre-ID” from the dropdown list | + | * #1 Pick **“Science CST Pre-ID”** from the dropdown list |
| - | * #2 Enter the date that your PFT testing starts | + | * #2 **Enter the date** that your PFT testing starts |
| - | * #3 Check only grades 5, 7 & 9 \\ {{:plsis:pft_submissions6.png?nolink&500|}} \\ | + | * #3 Check only grades **5, 7 & 9** \\ \\ {{:plsis:pft_submissions6.png?nolink&500|}} \\ \\ |
| * Go to the bottom right-hand corner of the page and click the **Next** button. | * Go to the bottom right-hand corner of the page and click the **Next** button. | ||
| - | * Choose to **“Download”** the resulting Txt file and save it to the **PFT 2016-17** folder on your desktop. \\ {{:plsis:pft_submissions7.png?nolink&700|}} \\ | + | * Choose to **“Download”** the resulting Txt file and save it to the **PFT 2018-19** folder on your desktop. \\ {{:plsis:pft_submissions7.png?nolink&700|}} \\ |
| ====Step #4==== | ====Step #4==== | ||
| - | * Now, go back to www.pftdata.org and login to the **District Portal**: \\ {{:plsis:pft_submissions8.png?nolink&600|}} \\ | + | * Now, go back to www.pftdata.org and login to the **District Portal**: \\ {{:plsis:pft_submissions8.png?nolink&600|}} \\ \\ |
| - | * You will now be at the **Welcome** page of the PFT where you will click on **TEMPLATE GENERATOR** \\ {{:plsis:pft_submissions9.png?nolink&700|}} \\ | + | * You will now be at the **Welcome** page of the PFT where you will click on **TEMPLATE GENERATOR** \\ {{:plsis:pft_submissions9.png?nolink&700|}} \\ \\ |
| - | * Click on the Template Data Generator (1 file version) file \\ {{:plsis:pft_submissions10.png?nolink&700|}} \\ | + | * Next, click on the **Template Data Generator (1 file version)** \\ {{:plsis:pft_submissions10.png?nolink&700|}} \\ |
| * On the next screen: The **File Type** to choose from the drop-down is **Science CST Pre-Id (txt)** | * On the next screen: The **File Type** to choose from the drop-down is **Science CST Pre-Id (txt)** | ||
| - | * Now browse for the Pre-id text file from your **PFT 2016-17** folder on your Desktop and choose it. \\ {{:plsis:pft_submissions11.png?nolink&500|}} \\ | + | * Now browse for the Pre-id text file from your **PFT 2018-19** folder on your Desktop and choose it. \\ {{:plsis:pft_submissions11.png?nolink&700|}} \\ |
| - | * Now click the Upload File button to the San Joaquin County Office of Ed and wait for a return email. | + | * Now click the **Upload File** button to the San Joaquin County Office of Ed and wait for a return email. |
| * The email will say you are ready for the next step. \\ {{:plsis:pft_submissions12.png?nolink&600|}} \\ | * The email will say you are ready for the next step. \\ {{:plsis:pft_submissions12.png?nolink&600|}} \\ | ||
| ====Step #5==== | ====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 2016-17** folder on your Desktop. \\ {{:plsis:pft_submissions13.png?nolink&700|}} \\ | + | * 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. \\ {{:plsis:pft_submissions13.png?nolink&700|}} \\ |
| - | * After saving the file, open the Excel doc in your **PFT 2016-17** folder. | + | * 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) | * Click to **“Enable editing”** (your worksheet may already be ready for this) | ||
| - | * Choose data/tab/external data: from txt \\ {{:plsis:pft_submissions14.png?nolink&700|}} \\ | + | * On your spreadsheet, click on the **Data tab** then choose **From Text...** \\ \\ {{:plsis:pft_submissions14.png?nolink&700|}} \\ |
| - | * Choose to import the ‘STAR’ file you just received from the PFT group (it is in your **PFT 2016-17** folder) \\ {{:plsis:pft_submissions15.png?nolink&600|}} \\ | + | * Choose to import the ‘STAR’ file you just received from the PFT group (it is in your **PFT 2018-19** folder) \\ {{:plsis:pft_submissions15.png?nolink&600|}} \\ |
| - | * // Note that you will need to “tell” the importer which cell to begin with (see below) // \\ {{:plsis:pft_submissions16.png?nolink&700|}} \\ | + | * <html><span style="color:red"><i><b> Note that you will need to “tell” the importer which cell to begin with (see the RED cell indicated below)</b></i></span></html> \\ {{:plsis:pft_submissions16.png?nolink&700|}} \\ |
| * Choose that same cell on your Excel spreadsheet and then click “OK”. | * 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.) | + | * You have now filled in all **__Basic Student Demographics__**. <html><span style="color:red"><b><i>(Note: Remember to populate column D (Charter School Code) all the way down the column. This info is not in the SpSIS.)</i></b></span></html> |
| ==== Preparing your Spreadsheet ==== | ==== Preparing your Spreadsheet ==== | ||
| * By highlighting and right-clicking you can “hide” cells you don’t need to work with. | * 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) | + | * 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) | + | * **Hide all other cells until you get to column AI** **(PFT Start Date Month)** |
| - | * Now “freeze” panes by noting where you want to start the “freeze” (see below) \\ {{:plsis:pft_submissions1.png?nolink&700|}} \\ | + | * Now click on the **View** tab to “freeze” panes by noting where you want to start the “freeze” (see below) \\ {{:plsis:pft_submissions17.png?nolink&700|}} \\ |
| - | * You are now ready to fill in PFT Test Results for individual students. The “Frozen Frames” will make this job easy. | + | * You are now ready to fill in PFT Test Results for individual students. The **“Frozen Frames”** will make this job easy. |
| - | === Ready to enter Student Data Results in your Spreadsheet === | + | ===== #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 2016-17 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!! | + | 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!! |
| * When you are finished with testing, sign back into your District Portal and upload your results! | * When you are finished with testing, sign back into your District Portal and upload your results! | ||