1 / 24

Customization From an ISD Perspective

Customization From an ISD Perspective. Presented by Tim Howard Calhoun ISD howardt@calhounisd.org. Why customization?. District Requests State Requirements Data Transfers Data Warehouse Special Education Career Centers Food Service Transportation Alert/Calling. Available Tools.

thelma
Download Presentation

Customization From an ISD Perspective

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. Customization From anISD Perspective Presented by Tim Howard Calhoun ISD howardt@calhounisd.org

  2. Why customization? • District Requests • State Requirements • Data Transfers • Data Warehouse • Special Education • Career Centers • Food Service • Transportation • Alert/Calling

  3. Available Tools • Data Mining • Custom Reports • Skycoder • Custom Forms • SkyBuild Imports and Exports

  4. Data Mining • What is Data Mining? • “Create customized reports of information not otherwise collected in a standard report” • Why use Data Mining? • Powerful tool for building more complex queries • Mailing or information labels for specific groups • Processing lists (for use in other areas of Skyward) • Empower users with training

  5. Custom Reports • What are Custom Reports? • Crystal Reports® • Offers more complex reporting options • Aggregate functions (Sum, Average, Count, etc.) • Formatting (fonts, colors, images, etc.) • Sub-reports • Are Custom Reports for me? • Maybe...

  6. You need: • Licensed copy of Crystal Reports® • Understanding of SQL language • Knowledge of Skyward table structures • View Tables (WS\CR\VD) • Database Design (SkyDoc)

  7. View Tables:

  8. Database Design:

  9. And once you know the tables, you can write the query:

  10. Sample Custom Report:

  11. Skycoder • What is Skycoder? • Allows modifications to web page elements within the structure of the application by inserting JavaScript directly into the served page Blah, blah, blah...

  12. Skycoder turns this...

  13. ...into this!

  14. Use built-in functions or write your own JavaScript code...

  15. Custom Forms • What are Custom Forms? • Allows the addition of whole pages to the Student Profile or Families • Add user-defined fields that can also be accessed in Data Mining and Skybuild • Custom Forms can also be added to virtually any screen through Skycoder • Can also create HTML version

  16. Just set up the Custom Form (WS\ST\PS\CF\CF)...

  17. ...and it become available for every Student (or Family)!

  18. SkyBuild • What is SkyBuild? • Imports and Exports: • Allows export of data for specific applications • Allows import of student data • File formats can vary (.txt, .csv, etc.) • Fields selected individually and can be formatted or used to filter data selection • Can be scheduled as a recurring job • Audit Reports and Job Notifications available

  19. Things to remember: • This is Student data, not District data • Not all fields are available for export/import • Skyward templates are available • Interfaces are entity-specific • Lots and lots of options – think it through

  20. But the MOST important thing is: Have a secure place to hold the data!

  21. Skyward Database Network Server Secure FTP Connections File Server Dist A Dist B Dist C Share Drive(s) Mounted on Servers Dist D Dist E SFTP Server Skyward Server Basic Configuration

  22. Questions? • Most of the tools discussed here are subjects of other sessions • Round Table Discussion • Planetarium – 4:15 to 5:05 PM (Tuesday) • Encore Presentation • Ballroom D – 10:45 to 11:35 AM (Wednesday)

More Related