1 / 15

Pinnacle SIS Query/Reports Training

Pinnacle SIS Query/Reports Training. Training Agenda. Overview The user interface (UI) Using a query from the Pinnacle support website http:// accountability.leeschools.net/tc/psis.html Creating your own queries Using Excel to sort/filter results. Overview – What and why?.

dinah
Télécharger la présentation

Pinnacle SIS Query/Reports Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Pinnacle SISQuery/Reports Training

  2. Training Agenda • Overview • The user interface (UI) • Using a query from the Pinnacle support website • http://accountability.leeschools.net/tc/psis.html • Creating your own queries • Using Excel to sort/filter results

  3. Overview – What and why? • Pick the data you want • Specify conditions and sorting • View the results in your browser • Save the process for next time • Export the results into Excel

  4. Overview – The SIS application

  5. The UI – Selecting your columns (Option 1)

  6. The UI – Selecting your columns (Option 1)

  7. The UI – Selecting your columns (Option 2)

  8. The UI – Specifying the sort order

  9. The UI – Specifying the selection criteria

  10. The UI – Previewing the results

  11. The UI – Loading a custom query

  12. Using a query from the Pinnacle Support website • Download the query as a file to… • My Documents • Desktop • New folder somewhere (recommended) • Login to Pinnacle.SIS • Load the query • Please refer to the Using Existing Queries tutorial • http://accountability.leeschools.net/tc/psis.html

  13. Creating your own queries • Login to Pinnacle.SIS • Open the Query tab • Select the fields • Specify a sort order • Select data to display • Run the query • Please refer to the Create Your Own Query tutorial • http://accountability.leeschools.net/tc/psis.html

  14. Using Excel to sort/filter results • Freezing the top row • Sorting data by columns • Filtering the data by columns • Auto-sizing your columns • Please refer to the Managing Data in Excel tutorial • http://accountability.leeschools.net/tc/psis.html

  15. Questions?

More Related