SESSION 2
Monday June 27th
10:15 - 11:45
PowerSchool 7 - What's New
Facilitator: Jason Springel
Affiliation: Pearson
Type: Lecture
Session: 2, 4 & 7
Description: A look at the newest PowerSchool release covering all the bells and whistles.
A Day in the Life of a Powerful Secretary - Part 2
Facilitator: Annelise Woitulewicz & Margie Holdren
Affiliation: Summit Academy Schools
Category: Beg/Int, Secretaries
Type: Lecture
Session: 1-2 & 5-6
Description:
This session will provide training surrounding a typical day for a secretary using PowerSchool. We will take you through a typical day of a secretary and all the features used on a regular basis. We'll share tips on how PowerSchool works for us and what we do to manage the daily tasks in PowerSchool. Topics covered will include personalization, attendance, reports, daily bulletin, log entries, powerlunch and getting data out for daily inquiries.
DDE 101 - Exporting and Importing
Facilitator: Kathy Romeyn
Affiliation: Byron Center Schools
Type: Lecture
Session: 2 & 5
Description: This session will cover getting data into and out of PowerSchool using the DDE.
I'm a Counselor--Where's My Training? (Part 2)
Facilitator: Al Momrik
Affiliation: Waverly Community Schools
Type: Lecture
Session: 1-2 & 5-6
Description: This session will provide training on screens that counselors need to use on a daily or occasional basis. Included will be exports of data (rank, GPA, cumulative credits), reports of D's and F's, Walk-in scheduling, transcript entry, PDF creation of transcripts, class counts, and more.
Intro to Object Reports - Part 2
Facilitator: Debbie Fox
Affiliation: Oxford
Category:
Type: :Lecture
Session: 1-2 & 5-6
Description: In this session we'll cover the basics of creating object reports. Users are strongly encouraged to bring a laptop if they want some hands on experience; however, the topic is relatively fast paced (in order to cover the topic as completely as possible) with the goal of having time at the end for Q&A and demonstrations.
Custom Reports Bundle
Facilitator: Brent Johnson
Affiliation: Cherryland Software/Traverse Bay Area ISD
Type: Lecture
Session: 2 & 7
Description: A look at the custom reports bundle created by PowerDataSolutions.
Intermediate Excel - Formulas
Facilitator: Carl Hoffman
Affiliation:
Type:
Session: 2 & 5
Description: Formulas, Subtotal, Charts, Ranking, Unique Values, Sharing (Locking), Text to Columns
Basic SQL
Facilitator: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Type: Lecture
Session: 2 & 5
Description: This session will cover how to use SQL to get data out of the PowerSchool database. Topics include: Basic SQL queries, PowerSchool database tables and relationships, tools and methods used for querying PS data. It is recommended that users have a basic understanding of what SQL is for this session.
Standards Based Elementary Report Cards
Facilitator: Kathy Fandale
Affiliation: Macomb ISD
Category: Report Cards
Type: Lecture
Session: 2 & 7
Description: Interested in adding Elementary Standards Based Report Cards in your district? We will provide an overview, tool kit and step-by-step instructions to follow.
Tables and How They Relate To Each Other
Facilitator:
Affiliation:
Type: Lecture
Session: 2 & 5
Description: The first step to importing, exporting, creating reports and using DDE is to know where the data is kept. We will focus on the different PowerSchool tables, what data is in the table, how the tables relate to each other, which tables you will use the most, how to extract data from multiple tables, common table links, etc. We will discuss students, schedules, courses, teachers, stored grades, etc. Understanding these tables will help you find and extract the data you need.
Test Server and Backup/Restore
Facilitator: Ted Belej
Affiliation: REMC1
Category: System Admin
Level: New, Novice, Int
Type: Combo Lecture
Session: 2
Description: Backups - Using flashback, backup scripts and a test server for a bulletproof backup/test system. NOTE: This course is intended for PowerSchool System Administrators who have access to their servers for file import and editing.
DATA DATA DATA - DDA & DDE - Part 2
Facilitator: Phil Bettendorf
Affiliation: LevelData
Category: Data
Type: Lecture
Session: 1-2 & 7-8
Description: In this session we'll cover the basics of exporting data from PowerSchool for use in other applications. We will approach PowerSchool from the inside out learning about relational database and how to export information from multiple tables at the same time (without having to have an ODBC connection set up to pull the data.)
Setting up and Using PowerTeacher Grade book - Part 2
Facilitator: Tom Cleary & Carl Hoffman
Affiliation
Category:
Type: Lecture
Session: 1-2 & 5-6
Description:
Monday June 27th
10:15 - 11:45
PowerSchool 7 - What's New
Facilitator: Jason Springel
Affiliation: Pearson
Type: Lecture
Session: 2, 4 & 7
Description: A look at the newest PowerSchool release covering all the bells and whistles.
A Day in the Life of a Powerful Secretary - Part 2
Facilitator: Annelise Woitulewicz & Margie Holdren
Affiliation: Summit Academy Schools
Category: Beg/Int, Secretaries
Type: Lecture
Session: 1-2 & 5-6
Description:
This session will provide training surrounding a typical day for a secretary using PowerSchool. We will take you through a typical day of a secretary and all the features used on a regular basis. We'll share tips on how PowerSchool works for us and what we do to manage the daily tasks in PowerSchool. Topics covered will include personalization, attendance, reports, daily bulletin, log entries, powerlunch and getting data out for daily inquiries.
DDE 101 - Exporting and Importing
Facilitator: Kathy Romeyn
Affiliation: Byron Center Schools
Type: Lecture
Session: 2 & 5
Description: This session will cover getting data into and out of PowerSchool using the DDE.
I'm a Counselor--Where's My Training? (Part 2)
Facilitator: Al Momrik
Affiliation: Waverly Community Schools
Type: Lecture
Session: 1-2 & 5-6
Description: This session will provide training on screens that counselors need to use on a daily or occasional basis. Included will be exports of data (rank, GPA, cumulative credits), reports of D's and F's, Walk-in scheduling, transcript entry, PDF creation of transcripts, class counts, and more.
Intro to Object Reports - Part 2
Facilitator: Debbie Fox
Affiliation: Oxford
Category:
Type: :Lecture
Session: 1-2 & 5-6
Description: In this session we'll cover the basics of creating object reports. Users are strongly encouraged to bring a laptop if they want some hands on experience; however, the topic is relatively fast paced (in order to cover the topic as completely as possible) with the goal of having time at the end for Q&A and demonstrations.
Custom Reports Bundle
Facilitator: Brent Johnson
Affiliation: Cherryland Software/Traverse Bay Area ISD
Type: Lecture
Session: 2 & 7
Description: A look at the custom reports bundle created by PowerDataSolutions.
Intermediate Excel - Formulas
Facilitator: Carl Hoffman
Affiliation:
Type:
Session: 2 & 5
Description: Formulas, Subtotal, Charts, Ranking, Unique Values, Sharing (Locking), Text to Columns
Basic SQL
Facilitator: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Type: Lecture
Session: 2 & 5
Description: This session will cover how to use SQL to get data out of the PowerSchool database. Topics include: Basic SQL queries, PowerSchool database tables and relationships, tools and methods used for querying PS data. It is recommended that users have a basic understanding of what SQL is for this session.
Standards Based Elementary Report Cards
Facilitator: Kathy Fandale
Affiliation: Macomb ISD
Category: Report Cards
Type: Lecture
Session: 2 & 7
Description: Interested in adding Elementary Standards Based Report Cards in your district? We will provide an overview, tool kit and step-by-step instructions to follow.
Tables and How They Relate To Each Other
Facilitator:
Affiliation:
Type: Lecture
Session: 2 & 5
Description: The first step to importing, exporting, creating reports and using DDE is to know where the data is kept. We will focus on the different PowerSchool tables, what data is in the table, how the tables relate to each other, which tables you will use the most, how to extract data from multiple tables, common table links, etc. We will discuss students, schedules, courses, teachers, stored grades, etc. Understanding these tables will help you find and extract the data you need.
Test Server and Backup/Restore
Facilitator: Ted Belej
Affiliation: REMC1
Category: System Admin
Level: New, Novice, Int
Type: Combo Lecture
Session: 2
Description: Backups - Using flashback, backup scripts and a test server for a bulletproof backup/test system. NOTE: This course is intended for PowerSchool System Administrators who have access to their servers for file import and editing.
DATA DATA DATA - DDA & DDE - Part 2
Facilitator: Phil Bettendorf
Affiliation: LevelData
Category: Data
Type: Lecture
Session: 1-2 & 7-8
Description: In this session we'll cover the basics of exporting data from PowerSchool for use in other applications. We will approach PowerSchool from the inside out learning about relational database and how to export information from multiple tables at the same time (without having to have an ODBC connection set up to pull the data.)
Setting up and Using PowerTeacher Grade book - Part 2
Facilitator: Tom Cleary & Carl Hoffman
Affiliation
Category:
Type: Lecture
Session: 1-2 & 5-6
Description: