PSUG of Michigan
  • Home
  • PSUG Events
    • MI Events>
      • PSUG-MI Spring Conference
      • 2013 PSUG-MI Fall
      • 2012 Fall Conference>
        • Session Descriptions
        • Novi Schedule
    • National Conference>
      • 2013 National>
        • Why Las Vegas?
        • Sponsor/Exhibitor info
        • Airport Transportation
        • 2012 FAQ
        • Meet our Presenters!
        • Vegas Links
        • Freemont Street Experience
        • Downtown
        • Resorts
        • Resorts, Off Strip
        • Things to do in LV
        • Shows in Vegas!
        • All Stage Pass & Buffet of Buffets
    • Other PSUG Events>
      • PSUG-Southeast>
        • SE Documents
      • PSUG Colorado
      • European PSUG
      • PSUG New Jersey
    • Past Events>
      • Past MI Events>
        • Summer 2011>
          • Sessions
          • Session 1
          • Session 2
          • Session 3
          • Session 4
          • Session 5
          • Session 6
          • Session 7
          • Session 8
          • Secretarial Sessions
          • Call For Proposals-Fall
        • Summer 2010
        • Fall 2009
        • Sys Admin Fall 2009>
          • Schedule
        • Summer 2009
      • Past National Events>
        • 2012 National>
          • Vendors 2012
          • Course Catalog
          • 2012 Schedule
          • PRIZES & CONTESTS
          • Schedule
          • Coupons
          • 2012 National PSUG Blog
        • Vegas 2011>
          • Vegas 2011 Presentations
          • Exhibitors
          • Riviera Hotel
          • Call For Proposals
          • Vendors
          • Vegas Schedule
  • Training Material
    • PSUG-SE Files
    • Customization>
      • Customizations
      • Customizations - Must Have
    • Excel>
      • Excel - Beginning
      • Excel - Cool Tips and Tricks
      • Excel - Formulas
      • Excel - Functions
      • Excel - Pivot Tables
    • General>
      • End of Term Processes
      • I'm a Counselor - Where's my session
      • PowerSchool 101 - Intro to PowerSchool
      • Q & A for Newbies
      • Secretaries - A Day in the Life
      • Secretaries - A Year in the Life
    • Reporting>
      • Creating Standards Based Report Cards
      • Custom Reports Bundle
      • Custom Reports Made Easy Using the sqlReports Add-on
      • Intro to Object Reports
    • Scheduling>
      • Elementary Scheduling with Excel
    • State Reporting>
      • Understanding TSDL
      • Pupil Accounting - Tips and Tricks
    • SQL>
      • SQL Reports
      • SQL - Basic
    • Working with Data>
      • Data, Data, Data - What you can do with DDE...
      • Data Validation
      • DDE 101 - Exporting and Importing
      • Make your data work for you...
      • Tables - Where's the Data?
  • State PSUGs
    • PSUG Links
  • Our Partners
  • About Us
    • PSUG-MI Meetings
    • PSUG-MI Board
    • Discussion
    • Payment
    • Staff Files
    • 2012 Photos


SESSION 4
Monday June 27th
2:45 - 4:15


Advanced Excel - ODBC
Facilitator
: Dori Baldwin
Affiliation: Kent ISD
Type: Lecture
Session: 4
Description: Using Excel to access PowerSchool tables via ODBC.  This course will not cover setting up the ODBC derivers but how to use them once they are setup.


A YEAR in the Life of a PowerFul Secretary (Part 2)
Facilitator
: Margie Holdren and Annelise Woitulewicz
Affiliation: Summit Academy Schools
Category: Secretaries
Type: Sage on the Stage
Level: Newbies, Novice
Session: 3-4
Description: We will walk you through the tasks performed over the course of a year in the life of a secretary using PowerSchool. This session is not for the weary, nor will it be dreary. We will share our stories of how we have learned to manage tasks, what works, what didn't work. You will get a big stage look at everything from count day tips, to enrolling students, annual tasks, monthly, by term and more. You will leave with an excellent birds eye view in the sea of information of a powerful secretary using PowerSchool!


Conducting Student Searches
Facilitator
: Mary Savage
Affiliation: Traverse Bay Area ISD
Type: Lecture
Session: 4 & 7
Description: Do you want to know more about searching student records? This hands-on session will provide suggestions for performing basic searches, using search commands, compound searches and search codes. You will also learn how to save stored searches and selections and the difference between the two. Time will also be spent using special functions to search for GPA, grades/attendance, perfect attendance and log entries.


Intermediate Excel - Tips & Tricks
Facilitator
: Al Momrik
Affiliation: Waverly Community Schools
Type: Lecture
Session: 4 & 8
Description: Are you ready for some fast-paced Excel training?  We will cover a number of tips and tricks in this session.  Nearly all are related to PowerSchool.  We will cover absolute addressing, copy formats, format painter, special formats, text wrapping, custom lists & more.  Handouts will be provided.


Built in Reports
Facilitator
: Debbie Fox
Affiliation:
Type: Lecture
Session: 4 & 7
Description: This session will focus on the Built-in PowerSchool Reports.  We will cover Attendance, Discipline, Grades, Membership, and Student Listing reports. We will discuss the information provided on the report and how to run it.


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.


Beginning Access
Facilitator
: Doug Olson
Affiliation: Traverse Bay Area ISD
Type: Lecture
Session: 4
Description: Does Access frighten you? Participants will get a quick overview of MS Access and practical applications on how to use Access in your daily duties to make your life easier.


SQL Reports
Facilitator
: Laurie Kinney
Affiliation: Cadillac Area Public Schools
Type: Lecture
Session: 4 & 7
Description:


Pupil Accounting Tips & Tricks
Facilitator
: Kathy Romeyn
Affiliation:
Type: Lecture
Session: 4 & 6
Description: This session is designed for building level secretaries and pupil accounting staff. All participants will receive a "cheat sheet" that will help ensure your pupil count is error free and accurate.


GPAs, Honor Rolls and Class Ranks
Facilitator
: Ray Kramer
Affiliation: Summit Academy Schools
Type: Lecture
Session: 4 & 6
Description: Learn how to set up GPA calculation methods and use them for reports, honor rolls and class ranks. Note: if you intend to log in to your own PowerSchool system to make changes, you'll need District administrative access in addition to School administrative access.

PowerSchool System Admin Best Practices
Facilitator
: Eric Krebill
Affiliation: Montcalm ISD
Type: Lecture
Session: 3-4
Description:


PowerTeacher & Parent Connect Portals
Facilitator: Carl Hoffman
Affiliation:
Type: Lecture
Session: 4 & 8

Description: IT HAS FINALLY ARRIVED! Parent can now create one login to access all of their children. This session will provide a detailed review of the new parent portal. You will understand how it works for parents and office staff. We will also discuss ideas for rolling it out in your district.


Converting from PowerSchool 6 to PowerSchool 7.0
Facilitator
: Brent Johnson
Affiliation: Cherryland Software/Traverse Bay Area ISD
Type: Lecture
Session: 3-4
Description:


©2012 PSUG of Michigan