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...
      • 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

Tables - Where's the Data

Facilitator: Rick Muir
Affiliation:

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.

©2012 PSUG of Michigan