Brian's+Track

=Brian Andle's Sessions:=

Ever wanted to make a Dashboard that actually contained useful information for your District? PowerSchool provided an excellent example of what a Dashboard can be. The PS version however is a multi-step process just to add a single Portlet. In this session we will use a custom Dashboard System that I created. It allows for the direct Portlet creation right from within PS Admin. We will create simple SQL Portlets entered via PS Admin and we will look at making external Portlets that can be used for more advanced SQL queries.
 * Dashboards Made Easy**

Ever wanted to know how to get information out of PowerTeacher Gradebook using ODBC? This session will explore the Gradebook PSM tables also known as the Milan Tables. In PowerSchool 6.0 Pearson enabled ODBC view access to the Gradebook PSM tables, we will look into the linking of the PSM tables which are much more complicated then Legacy Tables.
 * PSM Tables, getting info out**

Ever wanted to know some of the cool codes that the Advanced PowerSchool Users know? We will look into some the top codes that can help get you around certain issues you may run into when creating custom web pages.
 * Cool PS web page codes**

sqlReports is a custom built reporting tool completely within PowerSchool that allows you to build and save sql queries for ad-hoc reports. This session will walk through the complete process from installation to building a library of reports. sqlReports is like the List Students function on steroids. Great option for ASP customers.
 * sqlReports Customization**