Proposed+Sessions

The agenda is still a work in progress. We are trying to work on this to make this as beneficial as possible for all that attend. Below are some of the topics we are considering:

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**

Half-day topic - covers how to build a page with a submit button on it that refreshes with new data, main focus is passing data to the url with javascript and then using gpv commands to use the data.
 * How to Build Dynamic Pages**

Covers the basics to SQL using Oracle SQL Developer and sqlReports (a handy customization for ASP customers) to help get people ready to use it in tlist_sql or the reporting engine.
 * Basic SQL**


 * Advanced SQL**

How we can use JSON to increase the amount of information and the flexibility of information within PowerSchool's parameters.
 * Intro to JSON**

How to use PHP with PowerSchool (Oracle) information.
 * Extending PowerSchool with PHP**

Attendees ask a panel how to do different things in PS during our networking time on Tuesday evening.
 * STUMP THE CHUMP!!!**