Become a Member
Next Event: Jan 8
Next Event: Jan 8

SIS Supports & Data

ProLearn is...Professional Learning @ATLE.ca

ATLE SIS/Data Administrator PLN - SQL Series

Mark your calendars for January 15: ATLE SIS/Data Administrator PLN - SQL Series Part 1 - This session is the beginning of a multi-part series.

ATLE is offering to help school division IT and SIS staff gain some background understanding and capabilities with SQL.  SQL is the language used by PowerSchool and many other programs to extract information directly out of the database - as such, while we will focus on PowerSchool, knowledge of this language is broadly applicable.

The session will be delivered online via ATLE Zoom on January 15, 2025 from 1-4 pm by Brian Wynder, the data coordinator at Elk Island Catholic Schools.

You will be emailed a calendar invitation with the session details after this registration is received and processed. Read more about it and sign up here

 

Description:

In this foundational session we will cover the following topics:

  1. How you get started writing an SQL query in PowerSchool

    1. Option 1: getting set up with ODBC access through an external tool such as SQL Developer

    2. Option 2: using a program such as Aurora SQL Studio inside PowerSchool to run SQL queries

  2. Writing basic single table queries to pull data from tables such as the students table, the schools table, the users table, etc.

  3. Exploring case statements to decode and interpret your data

  4. Using aggregate functions like “SUM”, “AVG”, “LISTAGG”  and others to perform calculations in your queries

Note: future sessions in this series will be offered later in the year, by Brian and other experienced community programmers, and will build on the concepts introduced here.

 

School Information Systems Supports & Data Analysis

Webinars and workshops will be built around the idea of collecting, managing, and analyzing school data using platforms such as: 

  • PowerSchool
  • Looker Studio
  • Google BigQuery
  • Microsoft PowerBI

And others as identified by the community.

Our PLNs are custom-tailored to best meet identified topics and PL models identified by our ATLE members.

Our team is currently contacting those who identified as being interested in leading or co-leading a PLN group. If you are interested in being part of our SIS Supports & Data PLN, please indicate that on the survey or reach out directly to ProLearn.

Our annual conference for division-level SIS Administrators across the province. 

At this conference we will:

  • work with PASI data (collection, submission, management best practices within PASI or when linked with PowerSchool SIS).
  • interact with key vendors of SIS related products and services across the province, including representatives from Red Tape Reduction at Alberta Education.
  • develop professional skills relating to managing SIS systems, managing/designing data collection processes, performing data analysis, etc.
  • have sessions for beginners as well as seasoned veterans.
  • feature software specific focus groups for PowerSchool SIS, SchoolEngage, and a variety of other software packages.