SESSION 1
Monday June 27th
8:30 - 10:00
Advanced Excel - Pivot Tables
Facilitator: Dori Baldwin
Affiliation: Kent ISD
Category: Int/Adv
Type: Lecture
Session: 1 & 6
Description: In this session you will learn how to take data pulled from your own server and create meaningful pivot tables and charts. To be successful in this course, you must have an understanding of DDE/DDA, exporting data from PowerSchool and basic Excel. The focus will be on using Excel and NOT exporting data.
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
Room:
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.
PowerSchool 101
Facilitator: Mary Savage
Affiliation: Traverse Bay Area ISD
Category: Beg
Type: Lecture
Session: 1 & 6
Description: This session is designed for those who are recently new to PowerSchool. Users are strongly encouraged to bring a laptop if they want some hands on experience and to follow along. This will cover the overall structure of PowerSchool, using the interface, understanding how powerful the searches are and beginning to look at student information.
I'm a Counselor - Where's My Training (Part 1)
Facilitator: Al Momrik
Affiliation: Waverly Community Schools
Category: Counselors
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.
PowerSchool Resources
Facilitator:
Affiliation:
Type: Lecture
Session: 1 & 6
Description: In this session you will be introduced to existing PowerSchool resources and help sites. You will learn how to setup accounts, post questions and search for helpful information to assist in supporting and using PowerSchool. The PowerSchool users community is a powerful resource and continually growing. This session will help you learn how to navigate through some of the most commonly used sites.
Resources and Networking 2010.pdf Resources and Networking 2010.doc
Q & A for Newbies
Facilitator: Doug Olson
Affiliation: Traverse Bay Area ISD
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description: Round table session for our newest PowerSchool users. Spend some time with an experienced PowerSchool user and get some answers to questions you may have.
Beginning Excel
Facilitator: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description: In this session you will use the basics of using Excel including: Opening PS exports, Filtering, Sorting, Page Setup, Formatting, Find and Replace, Auto fill, Save as, and Sheets
Implementing Standards
Facilitator: Kathy Fandale
Affiliation:
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description:
.Learn about Standards from a curriculum and technology point of view. Participants will learn about the components of school based standards, conversion scales, identifiers and how to build a spreadsheet to allow standards to be imported into PowerSchool. Learn some tips and tricks from years of experience.
A look at the Functions Menu
Facilitator:
Affiliation:
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description: In this session we will review in detail the various items in the Functions Menu. We will discuss Absentee Report, Daily Bulletin, Enrollment Summary, etc. We will also review the Special Functions menu including Group Functions such as Exporting; Mass Enroll; Re-Enroll in School; Searching by GPA, Grades and Attendance; Student Field Value, etc.
Must Have Customizations
Facilitator: Eric Krebill
Affiliation: Montcalm ISD
Category: Int/Adv
Type: Lecture
Session: 1 & 7
Description: Lists of our favorite customizations, demonstrations of what they offer, and links to where they can be found..
DATA DATA DATA - DDA & DDE
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 1
Facilitator: Tom Cleary & Carl Hoffman
Affiliation
Category:
Type: Lecture
Session: 1-2 & 5-6
Description:
Monday June 27th
8:30 - 10:00
Advanced Excel - Pivot Tables
Facilitator: Dori Baldwin
Affiliation: Kent ISD
Category: Int/Adv
Type: Lecture
Session: 1 & 6
Description: In this session you will learn how to take data pulled from your own server and create meaningful pivot tables and charts. To be successful in this course, you must have an understanding of DDE/DDA, exporting data from PowerSchool and basic Excel. The focus will be on using Excel and NOT exporting data.
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
Room:
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.
PowerSchool 101
Facilitator: Mary Savage
Affiliation: Traverse Bay Area ISD
Category: Beg
Type: Lecture
Session: 1 & 6
Description: This session is designed for those who are recently new to PowerSchool. Users are strongly encouraged to bring a laptop if they want some hands on experience and to follow along. This will cover the overall structure of PowerSchool, using the interface, understanding how powerful the searches are and beginning to look at student information.
I'm a Counselor - Where's My Training (Part 1)
Facilitator: Al Momrik
Affiliation: Waverly Community Schools
Category: Counselors
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.
PowerSchool Resources
Facilitator:
Affiliation:
Type: Lecture
Session: 1 & 6
Description: In this session you will be introduced to existing PowerSchool resources and help sites. You will learn how to setup accounts, post questions and search for helpful information to assist in supporting and using PowerSchool. The PowerSchool users community is a powerful resource and continually growing. This session will help you learn how to navigate through some of the most commonly used sites.
Resources and Networking 2010.pdf Resources and Networking 2010.doc
Q & A for Newbies
Facilitator: Doug Olson
Affiliation: Traverse Bay Area ISD
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description: Round table session for our newest PowerSchool users. Spend some time with an experienced PowerSchool user and get some answers to questions you may have.
Beginning Excel
Facilitator: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description: In this session you will use the basics of using Excel including: Opening PS exports, Filtering, Sorting, Page Setup, Formatting, Find and Replace, Auto fill, Save as, and Sheets
Implementing Standards
Facilitator: Kathy Fandale
Affiliation:
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description:
.Learn about Standards from a curriculum and technology point of view. Participants will learn about the components of school based standards, conversion scales, identifiers and how to build a spreadsheet to allow standards to be imported into PowerSchool. Learn some tips and tricks from years of experience.
A look at the Functions Menu
Facilitator:
Affiliation:
Category: Beg/Int
Type: Lecture
Session: 1 & 6
Description: In this session we will review in detail the various items in the Functions Menu. We will discuss Absentee Report, Daily Bulletin, Enrollment Summary, etc. We will also review the Special Functions menu including Group Functions such as Exporting; Mass Enroll; Re-Enroll in School; Searching by GPA, Grades and Attendance; Student Field Value, etc.
Must Have Customizations
Facilitator: Eric Krebill
Affiliation: Montcalm ISD
Category: Int/Adv
Type: Lecture
Session: 1 & 7
Description: Lists of our favorite customizations, demonstrations of what they offer, and links to where they can be found..
DATA DATA DATA - DDA & DDE
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 1
Facilitator: Tom Cleary & Carl Hoffman
Affiliation
Category:
Type: Lecture
Session: 1-2 & 5-6
Description: