2015
Spring Users Conference
March 30—April 1, 2015
Manhattan Conference Center
Hilton Garden Inn
410 S 3rd St
Manhattan KS 66502
(785) 532-9116
THE CONFERENCE AT A GLANCE
Monday, March 30th—Admin Users
7:30 AM—8:30 AM Registration, Networking & Breakfast
8:30 AM—8:50 AM Welcome
9:00 AM—12:20
Concurrent Breakout Sessions
12:20 PM—1:20 PM Lunch & Vendor of the Day
1:20 PM—1:50 PM
Visit the Vendors
2:00 PM—5:20 PM
Concurrent Breakout Sessions
Tuesday, March 31st—Secretaries
7:30 AM—8:30 AM
Registration, Networking & Breakfast
8:30 AM—8:50 AM
Welcome
9:00 AM—12:20 PM Concurrent Breakout Sessions
12:20 PM—1:20 PM Lunch & Vendor of the Day
1:20 PM—1:50 PM
Visit the Vendors
2:00 PM—5:50 PM
Concurrent Breakout Sessions
Wednesday, April 1st—State Reporting
7:30 AM—8:00 AM
Registration, Networking & Breakfast
8:00 AM—8:30 AM
Welcome
9:00 AM—11:50 PM
Concurrent Breakout Sessions
11:50 PM—12:50 PM Lunch & Vendor of the Day
1:00 PM—2:00 PM
Concurrent Breakout Sessions
Meet the Kansas PowerSchool Board
Vice President— Dave Clapham was born and raised in Larned, KS. Graduated from Larned High School,
Barton County Community College, and Christ for the Nations Institute. After spending some years in the
business world, I came to education in 2002 after graduation from CFNI.
Pawnee Heights School is a class 1A school in Rozel, Kansas. Population175. We started with Powerschool
in 2005-2006 school year. I quickly became the Powerschool admin and State reporting person (not that I
wanted the second one). At Pawnee Heights I serve as the Technology Director,and assist Ness City
School District with their needs which also includes Powerschool. In addition, I provide occasional Powerschool support to some neighboring school districts.
Cathi and I have been married for 40 years and are the proud parents of 3 boys and 2 girls. We are the
grandparents of 6 wonderful grand kids, 5 boys and 1 girl! Cathi and I spend are spare time attending the
Southern Baptist Church in Larned and playing with technology.
Webmaster— Ken Clay is in his 15th year as the Student Information Systems Coordinator at USD 264
Clearwater. Starting as a SASIxp district, Ken led the transition over to PowerSchool in 2010. Ken is
the KIDS coordinator and uploads all of the state files for KIDS, EDCS and KCCMS. He has been certified
by the Kansas Data Quality Certification – Data Coordinator since 2008. Ken is married with two children, a daughter-in-law, one grandson and one grandchild on the way in July.
Mike Liby – was raised and graduated High School from Abilene, and graduated from Kansas Wesleyan
in Business Administration. Mike has worked at USD 435 for the past 17 years as Technology Director for
Abilene Public Schools for the past 10 years and with Powerschool for the past 12 years. Mike and his
wife have 2 children, one a daughter in 6th grade and a son in 11th.
He enjoys meeting powerschool users from across the state and finding many users who
have created great ways to make it work. Mike has attended every conference since 2004.
Treasurer— Chris Rogge - I have been with the Kansas PowerSchool User Group for the past 14 out of 15
years since it was formed. As the Executive Director of the organization, my duties include the financial
aspect of the organization and working with the committee in putting on the Annual and Fall conference
each year. I have been a presenter every year at our Annual Conference. Outside of the organization I
work for the Abilene School District as a Technology Assistant where I work with PowerSchool training
teachers, staff and administration about the many functions of PowerSchool. My experience with PowerSchool spans over the past 15 years.
Bonnie Saranko— Bonnie has served on the KSPUG Board for two years; last year as an Advisor and this
year as a full member of the Board. She worked with Chris Rogge in finding a new venue for the Fall
KSPSUG Conference this last fall. She is the Database Specialist for the Andover Public School District.
Carrie Whalen—I am the Technology Coordinator for Remington School District and have been using PowerSchool for 7 years. I am our PowerSchool administrator, Test Coordinator, and I do all the state reporting submissions but have a second tech person who does all of the computer fixing.
I have been married to Patrick for 15 years and have 2 sons, Braedyn (20) and Jacob (14). We live in
Whitewater but I love spending time at our cabin in Cassoday floating on my raft in the sun or reading.
Secretary—Davonna Willits– I have been on the board for 4 years now and have enjoyed meeting and
working with so many great people. I schedule all of the great sessions for our conferences. If you would
like to be a presenter just let me know. We rely on your knowledge of PowerSchool to share with the organization through these sessions. In my regular life I work as a Registrar in Winfield and have done many
PowerSchool duties for the district since 2003.
Presenters Bios
Featured Presenter - Matt Freund
Matt is an independent consultant/contractor who has been using PowerSchool since 2005 and who has literally
trained thousands across the country on PS via workshops, inservices, and PSUG conferences. He's a regular contributor on the state listserv and Yahoo PSUG forum and has provided free custom pages and reports for years via his websites, mainly sisresources.com. In 2008, Matt started working as an independent consultant/contractor, helping districts across the country who needed custom pages and reports. His main focus these days is SIS Resources and sqlReports 4.
Brian A. Bell has been in Information Technology since the 80's in various functions. The past 12 years he has been the
Technology Facilitator for the Ell-Saline USD307 District. Brian likes to say "If it has a power source then I am responsible for it." Ell-Saline has used PowerSchool as the District’s SIS since 2006.
Janay Blome- School Counselor – USD 365 Garnett/Anderson County High School
This is my first year to present at the KSPSUG. I am excited, but willingly admit I have very little formal training in technology. Before going into to counseling, I was a biology/chemistry teacher. I like to think it’s my science training in
problem solving and my sense of humor that allow me to survive as a counselor and PowerSchool junkie. My husband
and I enjoy attending K-State football games and watching our kids participate in sports and other school activities.
Ken Clay is in his 15th year as the Student Information Systems Coordinator at USD 264 Clearwater. Starting as
a SASIxp district, Ken led the transition over to PowerSchool in 2010. Ken also is the KIDS coordinator and uploads all
of the state files for KIDS, EDCS and KCCMS. He has been certified by the Kansas Data Quality Certification – Data Coordinator since 2008. Ken is married with two children, a daughter-in-law, one grandson and one grandchild on the way
in July.
Tammy Dreiling is in her 5th school year as elementary school secretary at USD 432. Along with all the secretarial duties, I am responsible for all of the KIDS uploads for the building, Kansas Course Code and I help with the EDCS. I have
been working with Excel for 10+ years. I love working with Excel and until recently I preferred it over Microsoft Word. I
may not always know how all the puzzle pieces fit together, but I sure enjoy trying to figure it out.
Steve Horn is the Technology Director/PowerSchool Administrator for Centura Public School in Cairo, NE, where some
of his responsibilities include managing the local network and over 700 computers, the phone system and security camera's K-12 district, he has been at Centura since the summer of 2009. Prior to this position, he worked for Saint Francis
Hospital in Grand Island NE in the Information Systems department.
Wanda McGuire - I have been a secretary in USD 506 for the last 17 years. I have been the district PS Admin since
2005. Currently I am at the high school in the attendance office and responsible entering discipline for the high school
students and then uploading to KAN-DIS. I also have district wide duties which include being the PS Admin, KIDS Data
Coordinator uploading the files for our 6 schools, linking courses to the district teachers in the EDCS, responsible for the
KCCMS course info, and collect and enter data into CRDC .
Karla Murray is the Student Data Coordinator for Shawnee Heights USD 450. She has been a PowerSchool Administrator since 2002.
Presenters Bios
Karen Piper - I'm the Technology assistant for the District 243 Lebo/Waverly. I have a BS from the University of New
Hampshire. This is my 12th year working with PowerSchool I also am in charge of all the KIDS, KCCMS, EDCS and anything that has to do with the state reports. I also teach grades 1-6 computer skills at Lebo elementary.
I am the Afterschool Coordinator for the Lebo elementary grades K-6. I have worked with Database management and
programming in various employments including at USD243 for 20 plus years.
Dave Potts - I have been the Technology Director and PowerSchool Administrator for Conway Springs for 9 years. I am
responsible for many PowerSchool customizations and self-hosting our server. We have been using PowerSchool and
PowerLunch since we started using PowerSchool in 2008. I am also responsible for providing end user support for all
KIDS state reporting.
Karla Renteria - received an MMIS degree from Friends University. She has worked for the Catholic Diocese of Wichita
for 11 years as a technology teacher and school technology coordinator. For the last 10 years she has used PowerSchool
at the School level. In the past year she became the PowerSchool Administrator for the 39 Catholic School in the Diocese of Wichita.
Chris Rogge – I have worked for two school districts in the state of Kansas. I spent 27 years working for the Riley County School District. I had various jobs from working in the classroom, to Technology Coordinator and PowerSchool Administrator. The past 3 years I have been working at the Abilene School District. I am a technology assistant where I
work extensively with PowerSchool and help with ipads throughout the district. Since I have been involved in PowerSchool, I especially enjoyed training others about PowerSchool. My training involves working with schools, presenting
at workshops and conferences across Kansas, Nebraska and the National PowerSchool User Conference. My greatest
satisfaction is helping kids, staff, and teachers, with technology and PowerSchool.
Bonnie Saranko has worked at Andover Public School since 1997 and has been their Database Specialist for the past 10
years. She started as the Registrar at Andover High School and in 2004, moved to the Technology Department. Her
many duties include PowerSchool District Administrator and District KIDS Data Coordinator.
Ellie Schroeder is the newest member of the ESU 10 (Kearney, NE) Powerschool Support Team. She is coming from
Kearney Public Schools where for the last 5 ½ years she was the District Registrar. At KPS she was responsible for NSSRS
state reporting for about 5,300 students as well as maintaining the data and supporting school staff with Powerschool
use. She feels very comfortable with the “user side” of Powerschool, as well as the correlation of the fields on the reports submitted to Nebraska Department of Education.
Wayne Wiens is a Technology Integration Specialist for Educational Service Unit #10 in Kearney, NE, where his main
responsibility is PowerSchool support. Prior to this position, he taught math and technology and coached at Colby High
School for 12 wonderful years before moving back to his home state of Nebraska. In Nebraska he taught for three more
years then became a technology director for a school district for three years before moving into his current position.
Session Descriptions
Monday—AM Session 1
Photo Management This session will cover the basics of creating a MAP file for the Photographer base on grade level or Home Room teacher.
Demonstrations of resizing the photos, making zip files, making the map file and importing the photos as a batch for both students and teachers. We
will also demonstrate ways to match files with missing ID’s.
Object Reports - We will go over the different parts of Object Reports showing how to create a new report, adjust an existing object report, and
import object reports from other users.
Using the Enhanced Parent Portal by PDS - This customization, created by Power Data Solutions, greatly increases the amount
of information that can be displayed and gathered on the public portal. Graduation progress, demographic updates, honor roll and discipline log are
a few of the pages you can add to the portal. Besides the new pages, this customization gives you the ability to hide or display any page on the public
portal.
Custom Pages 101-this session is for those who are brand new to custom pages in PS or have very little experience with them. The custom
page structure in PS will be covered, as well as the two basic ways to customize pages (server vs CPM), as well as basic customization information
and when using the Language Translation Toolkit may be a better alternative. Customization resources will also be covered.
Fee Management - Need help with understanding the Fee Module?
Monday—AM Session 2
Implementing Standards This session will cover how to enter standards manually, importing standards, and setting up a Conversion Scale.
You will need District Level Access to setup standards.
Scheduling - Over view of using PowerScheduler and Scheduling Q & A
Custom Pages 102 - this session is for those who have some experience with customizing pages but are looking to learn more. Things covered
will include built-in user interface examples, plugins, PS specific html coding, and common errors and how to fix them.
Security, Groups & Page Permissions - If you haven't setup security groups yet, you will see how to create groups for your admin, secretaries and tech helpers. Once you setup these groups, you will be able to drill down and restrict access to certain pages for a group. You will also
see something that many schools forget to change and it will make the hair on the back of your neck stand up!
Monday—AM Session 3
Honor Roll, GPA & Class Rank - Are you confused by all the GPA formulas and setups, or are you just not sure if things are right? This
session will go through the setups and show ways to validate the calculations.
Creating Page Fragments - Page fragments are a relatively new customization feature that allows you to leave the built-in page untouched,
but add some customizations to it using another file called a page fragment. The main advantage to this approach is when you upgrade PS, your
pages don't become outdated and cause issues because an older, customized version of the page is still in place. This session will cover the basics of
creating a page fragment and provide several examples of their use.
Single Sign-on - This session will cover the process of implementing Single Sign On for your parents. We will take a look at preparing your parents, training your staff for troubleshooting, and then selecting a date to implement Single Sign On. We will discuss what worked and did not work,
and troubleshooting tips that I found helpful when helping parents and staff through the implementation.
Monday—PM Session 1
Custom Fields & Screens built into PowerSchool - This session covers how to add custom fields to PS and how to use the built-in
custom screen maker to make screens for use in PowerSchool. We will look at an enrollment screen and go through the steps to include all the fields
onto one screen.
Help Desk - Pearson Rep
ReportWorks Introduction - Target Audience - Anyone who wants to get started using the new ReportWorks to create reports. This is a VERY
basic session that plans to be an hands-on session for beginners who have not used ReportWorks at all. This hands-on session on how to get started
with ReportWorks. This session is intended for people who have not started using ReportWorks and would like to get started building reports using
ReportWorks. It is suggested that attendees need to configure ReportWorks (before leaving for the conference) so you can participate in the projects.
Database Extensions - This session will cover the database extensions area of PowerSchool that was introduced in 7.9. Database extensions
replaces the current custom field approach in PowerSchool for those who decide to use it, plus it also allows one to create new tables in PowerSchool. How to migrate fields, set up new fields, and set up new tables will be covered.
Backups & Test Servers - This session will show you how to install a test server or multiple test servers for your district in a step-by-step
process from building up a new server to installing PowerSchool. Test servers can be useful for testing new versions of PowerSchool, and more.
Don’t have an extra server to install it on? No problem. We will touch on other options that may be available to you. One of those options, running it
on your own laptop, external enclosure or thumb drive.
Session Descriptions
Monday—PM Session 2
Using DDE, Exports and Excel PowerSchool holds and tracks all of the data entered. It also provides several ways for you to get the data
out to analyze and create reports. This session will cover the basics of DDE, tables, exporting into Excel and Export Templates.
PowerSchool 101 for Counselors/Newbies to the Admin Side - This session is designed for individuals fairly new to PowerSchool.
We will cover some of the more common screens used by counselors, registrars and secretaries. For example: Start Screen – tips for searching, Quick
Look Up Screen - how to add/edit/remove alerts, Historical Grades Screen – how to update/back fill transcripts, How to use the Special Functions
Search for common things (failing grades, log entries)
ReportWorks Beginner Reports - Target Audience - Anyone who has been introduced to ReportWorks previously or attended the ReportWorks Introduction session. We will build several projects in this session including labels, form letters and award certificates. Attendees need to
configure ReportWorks (before leaving for the conference) so you can participate in the projects.
Historical Grades - This sessions is for new users or users who need a refresher. I will go over the various ways to enter historical grades. Template for importing grades for new students and how to make changes to existing historical grades.
Monday—PM Session 3
Graduation Planner - Track the graduation progress of your students using the Graduation Planner built into PowerSchool. Have you previously
used the graduation sets? They can easily be converted to the new Graduation Planner. If you are starting from scratch, we will go through the process
from the beginning step by step to setup plans for your students. High school graduation plans to post-secondary plans can be setup.
PowerSchool Q&A End of Year - We will discuss what should be done in PowerSchool to prepare to run the End of Year Process and what state reports need to be
completed prior to running the End of Year Process. We will also discuss running the End of Year Process and Post End of Year.
KSPSUG Spring Planning Session - Have suggestions or questions regarding the conferences? This is the time to share them.
Tuesday—AM Session 1
Using Pivot Tables - We will pull data from PowerSchool and then use Pivot Tables to view the data. By using Pivot Tables in Excel you can save
so much time. But keep it your secret and your colleagues will think you spent hours on the reports.
Basic Excel This session cover getting started with Excel. Basic ideas such as formatting cells & columns, formulas and working with data.
End of Year - We will discuss what should be done in PowerSchool to prepare to run the End of Year Process and what state reports need to be
completed prior to running the End of Year Process. We will also discuss running the End of Year Process and Post End of Year.
PowerLunch - This session will provide all the information needed to use PowerLunch and how to expand it to use a custom pages for al la carte
and custom lunch counts. We will cover the lunch checkout process and manager screens. We will also cover lunch ID entry methods such as barcodes, key pads, and finger print scanning.
Learning SQL - structure query language (SQL) is a way to search for data by writing out what you're searching for versus using the drop-down
structure approach of DDE. It allows one to retrieve data from any table in PS and it can be run in SQL clients, sqlReports, or embedded in custom
pages. This session will cover the basics of sql up to joining tables together and pulling data from more than one table. We will be using a sql client
called Oracle SQL Developer, so if you wish to follow along, please download and install it before hand. Feel free to contact Matt Freund prior to the
conference for more information about installing it.
Tuesday—AM Session 2
Secretary Tips & Tricks-Do you want super secretary powers?? I can help with that!! We will cover problems/questions/requests that come
up every day at school and best practices to get your staff answers. We will cover the basics of searching, attendance, and clean data.
How to “Recreate” Your Health Data Using Custom Pages and Database Extensions - Target Audience – Anyone who is
interested in enhancing PowerSchool with Database Extensions. This session will be a demonstration of how to use database extensions and custom
pages to enhance PowerSchool. Although health will be the area of demonstration, these techniques could be used to enhance another area of PowerSchool. The focus will not be a “hands-on” type of session, but more of a demonstration of what is possible. Previous attendance in a database
extensions will be helpful, but not necessary.
Honor Roll, GPA & Class Rank - Are you confused by all the GPA formulas and setups, or are you just not sure if things are right? This session will go through the setups and show ways to validate the calculations.
Exporting data using Templates - In this session we will learn to setup a template that can be used to export data from PowerSchool into
other software programs in order to keep Student data clean and accurate across all programs.
Session Descriptions
Tuesday—AM Session 3
Preparing for the Auditor - I will share my tips for pulling data, using Pivot Tables, printing reports and saving to a notebook for the auditor. Keep everything together in one place so when the auditor does visit you can just give them the notebook and breath a little easier.
ReportWorks Advanced Projects - Target Audience - Anyone who has been introduced to ReportWorks previously or attended the ReportWorks Introduction session. We will build several projects in this session including a current report card, a historical report card and other advanced reports. Attendees need to configure ReportWorks (before leaving for the conference) so you can participate in the projects.
Functions and What They Do- - Special Functions will cover all the area under special functions: assign ids & passwords, attendance functions,
shows who is currently singed on to Powerschool, Bulletin setup, enrolling a new student, Fee Functions, Group Functions, basics of importing and exporting data, incident management, Searches by GPA, Grade/Attendance, Perfect Attendance, log entries and special program enrollment. I will just
touch on the basics of each. This is for new users or user who need a refresher.
PowerTeacher the Gradebook and You - A look at how what you did as an admin effects the gradebook and your teachers.
Getting to Know sqlReport 4 - sqlReports 4 is a free customization that allows you to build reports or charts based on SQL. As a reporting tool
you can create reports or charts that do not exist in PS and make them interactive by asking admins for input. As an export tool you can build simple or
complex reports and users can save the information in comma or tab format. No need to use DDE, quick export, or report templates - admins can run
reports you create and export the results on the screen or filter the results before exporting. You can also build student based reports that have a 'Make
Current Selection' button to easily use the results of the report as the current selection. How to install it and import, edit, and run a report will be covered.
Tuesday—PM Session 1
Health Management Tips & Tricks - Tried using the Health Module in PowerSchool?
Beginning CSS & jQuery - Target Audience – Anyone who customizes pages in PowerSchool or will be customizing pages in the future. This
session will discuss what is CSS and jQuery and how it can be helpful in customizing pages in PowerSchool. Although the session will be mostly discussion, there will be some hands-on to get attendees started on CSS and jQuery. Also, free online resources will be shared to help develop learning of CSS
and jQuery for attendees.
Using DDE, Exports & Excel - PowerSchool holds and tracks all of the data entered. It also provides several ways for you to get the data out to
analyze and create reports. This session will cover the basics of DDE, tables, exporting into Excel and Export Templates.
PowerSchool 101 for New Staff - 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 searches, built in reports, and the many features of PowerSchool.
Getting to Know sqlReport 4 - - sqlReports 4 is a free customization that allows you to build reports or charts based on SQL. As a reporting
tool you can create reports or charts that do not exist in PS and make them interactive by asking admins for input. As an export tool you can build simple
or complex reports and users can save the information in comma or tab format. No need to use DDE, quick export, or report templates - admins can run
reports you create and export the results on the screen or filter the results before exporting. You can also build student based reports that have a 'Make
Current Selection' button to easily use the results of the report as the current selection. How to install it and import, edit, and run a report will be covered.
Tuesday—PM Session 2
Searches and Getting Started - Your principal walks in and says “Who is that student whose mother came in yesterday? I remember she was
from Kearney and her name was Anne or Anna or Anna something”?? I can show you how to find this!! There is A LOT of data housed in PowerSchool,
but if you don’t know how to search and find it, it is useless.
Excel, PS and State Reporting This session will cover manipulating data in Excel for state reporting. How to upload from the Excel file and
basic importing and exporting from PowerSchool.
sqlReports 4 Teachers - this session will look at the the teacher version of sqlReports 4, which is actually part of a paid subscription
to sqlreports4.com. However, anyone who attends the session will receive a free copy of sqlReports 4 Teachers. If you attend the conference but cannot attend the session, please contact Matt Freund to make arrangements for a free copy. sqlReports 4 Teachers allows you to make reports you create
in the admin version available for teachers, thus allowing you a way to have powerful reports, charts, and exports available to teachers without having
to build custom pages in the teacher portal.
Tuesday—PM Session 3
sqlReports 4 Help Desk - this session is for those who are looking for help with sqlReports 4, either in installing it or using it.
Session Descriptions
Wednesday—AM Session 1
State Reporting With KIDS—Jessica Noble-DGSR, Lori Adams (EDCS), Jeannette Nobo (KCCMS), Kimberly Wright (STCO), Angela Feyh
(Pathways)
ISV Partnerships - Pearson Rep Michael Pietrzak
Help Desk With Matt Freund - the help desk sessions on Wednesday will only provide help regarding topics Matt covered on Monday and
Tuesday - customizations, sql, sqlReports 4, and database extensions.
Wednesday—AM Session 2
State Reporting With KIDS—Jessica Noble-DGSR, Lori Adams (EDCS), Jeannette Nobo (KCCMS), Kimberly Wright (STCO), Angela Feyh
(Pathways)
Help Desk With Matt Freund - the help desk sessions on Wednesday will only provide help regarding topics Matt covered on Monday and
Tuesday - customizations, sql, sqlReports 4, and database extensions.
Wednesday—AM Session 3
State Reporting With KIDS—Jessica Noble-DGSR, Lori Adams (EDCS), Jeannette Nobo (KCCMS), Kimberly Wright (STCO), Angela Feyh
(Pathways)
Help Desk With Matt Freund - the help desk sessions on Wednesday will only provide help regarding topics Matt covered on Monday and
Tuesday - customizations, sql, sqlReports 4, and database extensions.
Wednesday—PM Session 1
Incident Management - We will go over the different parts of Incident Management, from creating the incident, searching within Incident Management, and how to export and then upload the file to KAN-DIS for state reporting.
Massaging Data For State Reporting - Stressed about STCO, EXIT, or other collection cycle reporting? Learn to work
smarter, not harder, when it comes to State reporting and Excel. In this session, I will share with you, some of the tips
and tricks I’ve learned, for successful data uploads.
State Reporting Upcoming Changes - Pearson’s Dawn Colon
Mandatory Fields For State Reporting - KIDS now mandate multiple fields to have data when uploaded to KSDE. This session will explain
and demonstrate how to mass change required fields in PowerSchool. We will cover where to find the list of required fields, how to identify what
needs to be entered and how NOT to overwrite existing data. Documents matching PowerSchool fields to KIDS fields will be provided.
CRDC - Civil Rights Data Collection - This session will look at the different areas in PowerSchool that you can complete pertaining to the
CRDC. We will look at the report to pull the data. This report cannot be uploaded, but it will give you the information needed to complete the CRDC
online. We will look at the state site where the information that you pulled will be submitted.
Help Desk With Matt Freund - the help desk sessions on Wednesday will only provide help regarding topics Matt covered on Monday and
Tuesday - customizations, sql, sqlReports 4, and database extensions.
PM Session 3 (4:20-5:20)
PM Session 2 (3:10-4:10)
PM Session 1 (2:00-3:00)
Break
Break / Vendor Visits (1:20-1:50)
Lunch 12:20-1:20
AM Session 3 (11:20-12:20)
AM Session 2 (10:10-11:10)
Break
AM Session 1 (9-10)
Break
Registration 7:30-8:30 Welcome
8:30-8:50
MONDAY
ReportWorks Introduction - Ken Clay
PS Q & A - Michael Petrzak
End of Year - Karla
Renteria
Database Extensions-Matt Freund
Visit Our Vendors
PowerSchool 101
ReportWorks Beginfor Counselors &
ner Reports - Ken
Newbies-Janay
Clay
Blome
Custom Fields &
Screens Within
Help Desk - MiPowerSchool- Chris chael Pietrzak
Rogge
Graduation Planner
-Chris Rogge
Custom Pages 102Matt Freund
Honor Roll, GPA &
Creating Page FragClass Rank-Wayne
ments-Matt Freund
Wiens
Using the Enhanced
Parent Portal by
PDS- Wayne Wiens
Custom Pages 101Matt Freund
LightSpeed
School Messenger
eFunds
IMS
Learnsprout
KSPSUG Spring
Planning SessionDave Clapham
Historical Grades Karen Piper
Backups & Test
Servers-Steve Horn
Single Sign-on Implementation and
TroubleshootingSteve Horn
Security/Group Management-Steve Horn
Fee Management Terry Morrow
Big Basin East Alcove/Vendors Tuttle/McDowell
Sponsor of the Day - School Messenger
Implementing
Scheduling - JaStandards- Bonnie nay Blome & Mike
Saranko
Liby
Photo Management Object Reports- Brian Bell
Wanda McGuire
Using DDE, Exports and ExcelBonnie Saranko
Kaw Nation
Dispealing the Rumors - Michael Pietrzak
Flint Hills/Kings Konza Prairie
Monday, March 30th
PM Session 3 (4:15-5:50)
PM Session 2 (3:10-4:10)
Break
PM Session 1 (2:00-3:00)
Break / Vendor Visits (1:20-1:50)
Lunch 12:20-1:20
AM Session 3 (11:20-12:20)
Break
AM Session 2 (10:10-11:10)
Break
AM Session 1 (9-10)
Registration & Breakfast 7:308:30 (Welcome 8:30-8:50)
TUESDAY
End of Year - Karla
Renteria
PowerLunch-Dave
Potts
Lightspeed
Big Basin East Alcove/Vendors
Welcome
Kaw Nation
Searches and Get- Excel, PS & State
ting Started - Ellie Reporting-Tammy
Schroeder
Dreiling?
Health Managment
Tips & Tricks Beginning CSS &
Nurse Tabitha
jQuery - Ken Clay
Clark
Using DDE, Exports and ExcelBonnie Saranko
PowerSchool 101/
New Secretaries in
Their First Year Chris Rogge
Visit Our Vendors
Sponsor of the Day - IMS
Preparing For The ReportWorks Ad- Functions and What PowerTeacher the
Auditor-Wanda vanced Projects - They Do - Karen Gradebook and You
MGuire
Ken Clay
Piper
-Terry Morrow
eFunds
IMS
LearnSprout
How to “Recreate”
Your Health Data
Secretary Tips &
Honor Roll, GPA & Exporting Data UsUsing Custom
Tricks - Ellie
Class Rank - Wayne ing Templates-Chris School Messenger
Pages and DataSchroeder
Wiens
Rogge
base Extensions Ken Clay
Using Pivot Tables
Basic Excel-Wanda McGuire Tammy Dreiling
Flint Hills/Kings Konza Prairie
sqlReports 4 Help
Desk-Matt Freund
sqlReports 4
Teachers-Matt
Freund
Getting to Know
sqlReport 4 Continued-Matt
Freund
Getting to Know
sqlReport 4 -Matt
Freund
Learning SQLMatt Freund
Tuttle/
McDowell
Tuesday, March 31st
PM Session 1 (1:002:00)
Lunch 11:50-12:50
AM Session 3 (10:5011:50)
Break
AM Session 2 (9:4010:40)
Break
AM Session 1 (8:309:30)
Registration 7:30-8:00
Welcome 8:00-8:30
WEDNESDAY
Kaw Nation
State Reporting with Jessica Noble-(DGSR), Lori
Adams (EDCS), Jeannette
Nobo (KCCMS), Kimberly
Wright (STCO), Angela
Feyh (Pathways)
Massaging Data For
State Reporting-Karla
State Reporting UpMurray
Incident Reportcoming Changes Wanda McGuire
Dawn Colon
Cleared for State Reporting Presentation
Mandatory Fields
For State Reporting
- Brian Bell
Big Basin East
Alcove/
Vendors
CRDC - Chris
Rogge
PowerSchool
Help - Michael
Pietrzak
ISV Partnerships Michael Pietrzak
What's New in PowerSchool and Road Map - Michael Pietrzak
Flint Hills/Kings Konza Prairie
Help Desk with
Matt Freund
Help Desk with
Matt Freund
Help Desk With
Matt Freund
Tuttle/McDowell
Wednesday, April 1st
KSPSUG 14th Annual Spring Vendor Sponsors
GOLD SPONSOR
GOLD SPONSOR
BRONZE SPONSORS
Conference Map
Rooms A & B—Flint Hills/Kings
Room C— Konza Prairie
Room D—Kaw Nation—(Lunch)
Room E— Big Bason East
Room F—Alcove (Vendor Sessions)
To Hotel
Rooms G & H—Tuttle/McDowell
Restrooms
Restrooms
Parking Garage