Session Catalog

Downloadable PDF of Session Schedule

Session 1 (Day 1)

Scheduling (Prepare to Build/Load)  – Greg Satterwhite
Comprehensive PowerScheduler training over two full days! Join Greg for a complete run-through of the PowerSchool schedule building and loading process from beginning to end.  If you sign up for this you are committing to attending the full two day workshop.

Customization 1: Introduction to Customization – Roger Sprik
Want to start customizing PowerSchool? Learn the basics about Language Translation, Database Extensions, Custom Screens, and Custom Pages. We’ll demonstrate some beginner examples using the Custom Page Manager.

Advanced Customization: Beginning Angular JS – Eric Schaitel
Angular JS is a JavaScript framework which is becoming more prevalent throughout PowerSchool. The framework provides tools that allow developers to more easily and quickly develop complex applications using a Model-View-Controller (MVC) architecture. This course will explore the basics of Angular JS including Modules, Controllers, Directives, and the Angular JS scope service. Attendees should have some pre-existing familiarity with JavaScript to get the most from this course.

Accounts & Security  – Jason Springel
This session will bring you up to speed on field level security, user access roles, document attachment security, PT Pro read-only access, Single Sign-On, and more. Come learn critical information for keeping your system secure and managing user accounts properly.

Session 2 (Day 1)

Scheduling (Prepare to Build/Load)  – Greg Satterwhite
Comprehensive PowerScheduler training over two full days! Join Greg for a complete run-through of the PowerSchool schedule building and loading process from beginning to end.  If you sign up for this you are committing to attending the full two day workshop.

Must-Have Customizations  – Romy Backus
How to look like a genius with little effort. We will look at commonly available plugins and other simple customizations using what is available on PowerSource, PowerDataSolutions, and other resources. This is a good course to take if you are unable to take Roger’s customization track or delve deeply into learning to write your own code, but would still like to enhance your system with some great plugins.

Advanced Customization: Intermediate Angular JS – Eric Schaitel
We will expand upon the concepts covered in the beginning Angular JS session.  Attendees will learn the basics of data retrieval (AJAX) using the Angular JS framework.  We will also cover the use of custom directives and services to develop clean and reusable code.  

Graduation Plans – Jason Springel
How can a counselor or administrator know if a student is on track to fulfill graduation requirements? In this session we’ll review the setup and usage of Graduation Plans in PowerSchool, including recent enhancements.

DDE/DDA & Data Export Manager (part 1) – Carla Dancz
In this session we will cover the basics of exporting data from PowerSchool using DDE/DDA and Data Export Manager. Using real life scenarios we will focus on various PowerSchool tables, understanding the data in each table, how tables relate to each other, how to extract data from multiple tables and common table links. We will focus on the students, schedules (cc), courses, sections, teachers and stored grades tables. Understanding these tables will help you find and extract the data you need.

Session 3 (Day 1)

Scheduling (Prepare to Build/Load)  – Greg Satterwhite
Comprehensive PowerScheduler training over two full days! Join Greg for a complete run-through of the PowerSchool schedule building and loading process from beginning to end.  If you sign up for this you are committing to attending the full two day workshop.

Customization 2: Getting started with SQL and sqlReports – Roger Sprik
Learn the power of Structured Query Language (SQL) for accessing your PowerSchool data. This session will introduce writing basic SQL queries. We will introduce some options for directly testing your queries in PowerSchool, including Oracle SQLDeveloper and SQL Studio. Once you have a working SQL query, we will discuss ways to embed that inside PowerSchool, including the popular sqlReports plugin. We will demonstrate how to find and import existing sqlReports that have been shared by others.

Schoology Overview – Adam Larsen (remote)
PowerSchool’s new Learning Management System (LMS). A general introduction and functionality overview with tips for system settings, best practices and areas to be aware of.

PowerSchool API and PowerQueries – Chris Walberg, intellimedia (remote)
Accessing data in a structured manageable way: learn about the capabilities of the PowerSchool API including the addition of PowerQueries to access the PowerSchool data in a maintainable way.  A common documented approach for external data access, integrations and customizations. This is an advanced class.

DDE/DDA and Data Export Manager (part 2) – Carla Dancz
Part 2 of the double session.

Session 4 (Day 2)

Scheduling (Prepare to Build/Load)  – Greg Satterwhite
Comprehensive PowerScheduler training over two full days! Join Greg for a complete run-through of the PowerSchool schedule building and loading process from beginning to end.  If you sign up for this you are committing to attending the full two day workshop.

Final Grades: Pieces of the Puzzle – Romy Backus
Understand the key pieces of the PowerSchool puzzle that lead to the grade results you see in Historical Grades and on transcripts. Learn how terms, grading periods, course structure, grade scale setup, gradebook configuration and the storing process all come together.

Customization 3: Coding Basics in PowerSchool – Roger Sprik
PowerSchool uses web-standards such as HTML and CSS. This session will teach you the basics of HyperText Markup Language (HTML), and how its appearance is altered with Cascading Style Sheets (CSS). This session also covers the roles of tables in structuring data and how to use forms to make updates. We’ll introduce PSHTML, the codes specific to PowerSchool that populate the pages with data. Along the way we’ll equip you with tools like the built-in Custom Page Manager editor and other resources that will help you customize PowerSchool.

Advanced Customization: Intermediate SQL – Eric Schaitel
Topics will include selection of distinct results, result concatenation, and aliasing. The primary focus will be querying related tables using SQL joins.  We will dive deep into the differences between inner and left joins.

intellimedia SchoolEngage – Ahmad Jawad (sponsor session)
SchoolEngage is a comprehensive solution that facilitates interaction and communication, including exchange of information between key stakeholders within Schools and School Districts. Users including students, parents, as well as multiple types of staff each have a unique profile and account managed through a secure online interface. SchoolEngage enables schools and districts to publish Forms and Applications that can be completed and submitted online. Upon approval data integrates seamlessly with SIS through the write-back process, eliminating duplicate keying into multiple systems.

Session 5 (Day 2)

Scheduling (Prepare to Build/Load)  – Greg Satterwhite
Comprehensive PowerScheduler training over two full days! Join Greg for a complete run-through of the PowerSchool schedule building and loading process from beginning to end.  If you sign up for this you are committing to attending the full two day workshop.

Advanced Customization: Advanced SQL – Eric Schaitel
This session will cover more advanced SQL functions including aggregate functions: avg, count, min, max, and sum. Conditional logic (case statements), subqueries, the WITH clause, and pivots will also be discussed.

Data Access Tags and Codes – Carla Dancz
Ever wanted to know some of those undocumented PowerSchool codes or where you can use some codes you may already know? We’ll dive into some of the more common PS codes and what you can do to get data out in a way you might not have even know possible.

PowerTeacher Pro – Teachers (Jason Springel)
Come to this session to learn how teachers use and interact with PowerTeacher Pro and their grading data, including assignments, student view, running reports, and the student metrics and progress areas.

Session 6 (Day 2)

Scheduling (Prepare to Build/Load)  – Greg Satterwhite
Comprehensive PowerScheduler training over two full days! Join Greg for a complete run-through of the PowerSchool schedule building and loading process from beginning to end.  If you sign up for this you are committing to attending the full two day workshop.

Customization 4: jQuery and Page Fragments – Roger Sprik
Websites are made dynamic and interactive with Javascript. jQuery is a fast, small, and feature-rich library that simplifies Javascript and is used by millions of web developers. jQuery is included in PowerSchool and this session will examine many examples of how it can be used to add rich interactivity to your web-pages and help you discover how to leverage jQuery for its most popular PowerSchool use – to code your customizations as Page Fragments and avoid directly modifying the stock pages. With Page Fragments you avoid the pain of missing out on PowerSchool updates and minimize conflicts with other customizations that affect the same screen.

Object Reports – Carla Dancz
Object reports are PowerSchool’s built-in paginated PDF reports tool. In this session, we will build an object report transcript, covering the transcript object, credit and GPA DATs, and test scores. We will also talk about some other projects that object reports can be used for, such as form letters and student photo directories, and show where there are some pre-made ones on Exchange and how to install them.

PowerTeacher Pro: Administrators – Jason Springel
In this session, we will learn about the admin-side usage and setup for PowerTeacher Pro. This includes setting up district categories, creating and applying traditional and standards grade calculation methods, locking reporting terms, and accessing PowerTeacher Pro in a read-only way.

Standards Setup and Implementation – Romy Backus
Learn the basics of setting up and implementing standards on your server! We will cover grade scales, calculation methods in depth, importing standards from scratch, and how standards grades data is inputted and viewed by administrators, teachers, parents, and students.

intellimedia Plugins and Services – Ahmad Jawad
Learn about the plugins and PowerSchool services offered by intellimedia, one of our conference sponsors.

Marcia Brenner Associates Sponsor Session – Carla Dancz & Eric Schaitel
Learn about the plugins and PowerSchool services offered by MBA, one of our conference sponsors.

PowerSchool Products Roadmap – Sam Eilert
In this sponsor session by PowerSchool, LLC, hear an update on suite products available internationally, what integrations with the SIS are already built out, and the high-level roadmap for the future.

Session 7 (Day 3)

Course Prerequisites, Teacher Recommendations and Student Course Selection – Greg Satterwhite
Come to this session to learn how to set up course prerequisites, train teachers to enter course recommendations for students, and finally how all these pieces fit together in allowing students to select and submit their course requests from the student portal in preparation for scheduling season.

GPAs – Romy Backus
There are a lot of moving parts to a properly-calculated GPA in PowerSchool. We will look at the source data building blocks, the differences in various calculation methods, troubleshooting when something doesn’t seem quite right, and finally how to use and export GPAs in various parts of the system.

Customization 5: Beyond One-to-One – Roger Sprik
Custom fields that are “one-to-one” are straightforward when you have just one piece of information to store for each student. Learning how to implement one-to-many fields introduces a whole new level of complexity. You may want to store multiple AP scores, track equipment, manage post-graduate plans, or manage any other type of data where each student will have more than one record. This is implemented with “one-to-many” database extensions and requires more advanced coding to create, edit, and list them. Discover tools to search for, export and report on this type of data. We’ll cover the basic tlist_child and tlist_standalone tags, but focus on the more flexible DirectTable.Select tag. We’ll work within the context of working examples so that the application can be seen immediately.

Advanced Customization: PowerQueries – Eric Schaitel
PowerQueries are SQL queries that, when bundled properly, are embedded as part of the PowerSchool API.  The results of these queries can be retrieved and scheduled in PowerSchool’s Data Export Manager.  The queries can also be accessed in custom pages as a more secure alternative to tlist_sql, and exposed to select third-party applications to facilitate integration.  We will discuss the process of creating and installing PowerQueries as PowerSchool plugins, and then explore their use in custom pages and Data Export Manager.

Session 8 (Day 3)

Scheduling Lab – Greg Satterwhite
Apply everything you’ve learned in Prepare to Build and Load to your own schedule, with Greg’s expert help.

Log Entries – Carla Dancz
Log entries are a way of keeping track of text-based information for a student in PowerSchool, whether that be discipline, counseling, parent communication, or more. This is an interactive discussion focusing on different types of student logs and various uses for them. We will also look at how to search logs, export and report log entry information.

Customization: Putting it All Together – Eric Schaitel and Roger Sprik
Live feats of daring coding! Bring your ideas for customizations (small to medium) and Eric and Roger will attempt to accomplish them together, applying the concepts taught and learned in the customization sessions.

Enterprise Reporting – Jason Springel
Enterprise Reporting is the most exciting reporting and data extraction tool you have ever seen! This session will cover everything there is to know about Enterprise Reporting. We will show all of the features that are available to users who run reports, and then learn how to build your own custom Enterprise Reports.

Panel Q & A (Day 3)

Our excellent presenters will be ready to address your burning PowerSchool questions and topics in a large-group discussion setting.

Open Lab (Day 3)

Open Lab is unstructured time for anyone who would like to meet 1-1 or in a small group to do so – whether that be with a presenter to address a specific question or problem, or with job-alikes from other schools to share tips and tricks.