SESSION 5
Monday June 28th
8:30 - 10:00
Understanding TSDL
Facilitator: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Type: Lecture
Session: 3 & 5
Description: This session will provide instruction, tips, and tricks on getting ready for and reporting TSDL data to the state.
A Day in the Life of a Powerful Secretary - Part 1
Facilitator: Annelise Woitulewicz & Margie Holdren
Affiliation: Summit Academy
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 1)
Facilitator: Al Momrik
Affiliation: Waverly Community Schools
Category:
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 1
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.
Using Access with PowerSchool - ODBC
Facilitator: Doug Olson
Affiliation: Traverse Bay Area ISD
Type: Lecture
Session: 5
Description: Connect directly to your PowerSchool database from Microsoft Access using ODBC. If you are familiar with relational databases and want to put that knowledge to use mining data in PowerSchool, then ODBC is your ticket to the data and Access can be your toolbox. In this session, we will discuss setting up an ODBC connection from Microsoft Windows to the PowerSchool Oracle database and demonstrate creation of data queries inside Access.
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: Brent Johnson
Affiliation: Cherryland Software/Traverse Bay Area ISD
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.
Graduation Issues
Facilitator: Roberta Furina
Affiliation:
Type: Lecture
Session: 3 & 5
Description: This session will provide instruction, tips, and tricks on screens related to high school graduation. Screens included are Graduation Sets, Historical Grades, Course Groups, Graduation Progress, Cumulative Info, and Transcript Reports.
Tables and How They Relate To Each Other
Facilitator: Vicki Glowacki
Affiliation: Dexter Community Schools
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.
Importing Test Scores
Facilitator: Ray Kramer
Affiliation: Summit Academy
Type: Lecture
Session: 3 & 5
Description: Don't enter those ACT scores by hand -- import them! We'll begin with an overview of how PowerSchool stores information about tests. We'll talk about the unique nature of importing test scores and how to set up an import that will run right the first time. Finally, we'll consider some non-traditional uses of the student test features.
Make your data work for you... Troubleshooting thru data mining
Facilitator: Phil Bettendorf
Affiliation: Level Data
Type: Lecture
Session: 3 & 5
Description: Troubleshooting through data mining. Troubleshooting requires a methodical approach that will point the PowerSchool Administrator to one of several remediation processes. Some may be as simple as having a staff member correct something in the portal while others may require data management by the Administrator or Pearson. How do you determine which process to follow? This session will lead the way by presenting a methodical approach using data mining principles. Attendees will have knowledge of DDE, match function, exporting to Excel and pivot tables.
Monday June 28th
8:30 - 10:00
Understanding TSDL
Facilitator: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Type: Lecture
Session: 3 & 5
Description: This session will provide instruction, tips, and tricks on getting ready for and reporting TSDL data to the state.
A Day in the Life of a Powerful Secretary - Part 1
Facilitator: Annelise Woitulewicz & Margie Holdren
Affiliation: Summit Academy
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 1)
Facilitator: Al Momrik
Affiliation: Waverly Community Schools
Category:
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 1
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.
Using Access with PowerSchool - ODBC
Facilitator: Doug Olson
Affiliation: Traverse Bay Area ISD
Type: Lecture
Session: 5
Description: Connect directly to your PowerSchool database from Microsoft Access using ODBC. If you are familiar with relational databases and want to put that knowledge to use mining data in PowerSchool, then ODBC is your ticket to the data and Access can be your toolbox. In this session, we will discuss setting up an ODBC connection from Microsoft Windows to the PowerSchool Oracle database and demonstrate creation of data queries inside Access.
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: Brent Johnson
Affiliation: Cherryland Software/Traverse Bay Area ISD
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.
Graduation Issues
Facilitator: Roberta Furina
Affiliation:
Type: Lecture
Session: 3 & 5
Description: This session will provide instruction, tips, and tricks on screens related to high school graduation. Screens included are Graduation Sets, Historical Grades, Course Groups, Graduation Progress, Cumulative Info, and Transcript Reports.
Tables and How They Relate To Each Other
Facilitator: Vicki Glowacki
Affiliation: Dexter Community Schools
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.
Importing Test Scores
Facilitator: Ray Kramer
Affiliation: Summit Academy
Type: Lecture
Session: 3 & 5
Description: Don't enter those ACT scores by hand -- import them! We'll begin with an overview of how PowerSchool stores information about tests. We'll talk about the unique nature of importing test scores and how to set up an import that will run right the first time. Finally, we'll consider some non-traditional uses of the student test features.
Make your data work for you... Troubleshooting thru data mining
Facilitator: Phil Bettendorf
Affiliation: Level Data
Type: Lecture
Session: 3 & 5
Description: Troubleshooting through data mining. Troubleshooting requires a methodical approach that will point the PowerSchool Administrator to one of several remediation processes. Some may be as simple as having a staff member correct something in the portal while others may require data management by the Administrator or Pearson. How do you determine which process to follow? This session will lead the way by presenting a methodical approach using data mining principles. Attendees will have knowledge of DDE, match function, exporting to Excel and pivot tables.