« Viewing PowerGrade Backups | Main | Changing the Default Student Screen »
Wanting Class Lists for Next Year?
We have had a few calls lately where customers who are using PowerScheduler want class lists for next year. There is not a built in report that will work for this before the schedule is committed and you cannot commit your schedule until the current school year is done so here is an idea for you.
Click on system and DDE.
Choose the schedule CC table.
Search for the term id >=1700. (This will give you the courses occuring in the 2007 school year!)
Click search all records in this table.
Click on export records and export the following:
[students]lastfirst
[courses]course_name
[teachers]lastfirst
Expression
Save this to your desktop and open it with Excel.
Click on any cell in the worksheet that contains data.
Choose data from the main menu and Pivot Table and Pivot Chart report.
Choose where the data is that you want to analyze.
Choose the pivot table radio button.
Click next. The range of data should be highlighted. Click next again.
Click on layout.
Drag the course, expression, teachers and students fields onto the row area
Drag the students field on the data area and click ok and finish.
This will produce a report in excel of the course, the period, the teacher and a list of students.
Posted by Melissa Bitz on May 7, 2007 12:28 PM | Permalink