PowerSchool TechNote:

PowerSchool Export Template: Current_Year_GPA_Projected_Q1_Q2_M1_Q3


This export includes projected GPA data for reporting terms Q1 Q2 M1 Q3, using the calculation of ((Q1 X 2) + (Q2 x 2) + M1 + (Q3 x 2)) divided by 7.
You can run this PowerSchool Export Template whenever needed, as long as stored data exists in these four reporting terms (Q1 Q2 M1 Q3).

Directions for using this Export Template:

1. Login to PowerSchool using FireFox.

2. Set Your Term at the top of the PowerSchool screen to the Full Year Term, such as 09-10 Year to filter output. Most of the time, you should use the full year, since that will cover full year, as well as semester and marking period length courses.

3. Browse Students, and narrow your selection based on grade level, select by hand, etc.

4. Select Special Functions ---> Importing & Exporting ---> Export Using Template, or in the Functions pull down manu, select Export Using Template

5. Type of Export: Students

6. Export template? Current_Year_GPA_Projected_Q1_Q2_M1_Q3

7. For Which Records? The selected XX students

8. Click Submit

9. After a few minutes, you will see the "Opening..." dialog box appear in FireFox, choose Save File, and pick the destination of your computer's Desktop.
The file will be named student.export.text or student.export(1).text and so on, so be sure to rename to something more specific, such as mast_export_5-21-10.text

10. Launch Excel, and head to the File menu and select Open.

11. Select "All Files" in the Enable area, then choose the file you renamed above, then click the Open button.

12. You can click Next through each of the Text Import Wizard steps or simply click Finish to accept Excel's default settings.

13. You can now sort the data as desired.

 

If there are any questions, please contact the Tech Group.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Need help from the Tech Group? Use the Online
MCVSD "Information Technology Help Request" form
https://tg.mcvsd.org/techhelp/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

Back to the MCVSD Tech Tips site