behind the scenes data coordination - scott ardill and steve sandifer
TRANSCRIPT
![Page 1: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/1.jpg)
![Page 2: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/2.jpg)
BEHIND-THE-SCENES DATA COORDINATION
Scott Ardill & Steve Sandifer – The John Cooper School
![Page 3: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/3.jpg)
#BBK12UC
Welcome
One of the most powerful features of Education Edge is the ability to augment the basic structure of the database with attributes. Further, the ability to globally edit and/or update standard database fields and attributes allows the user to tailor the database to better fit their needs.
![Page 4: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/4.jpg)
#BBK12UC
Data-In-Data-Out • Personal Data• Basic Data Tools
– Attributes, Global Changes, CSV Files, Queue• Data Out
– Queries, Queries from Reports, Exports• Data In
– Imports• Data Between• Data Exchange (Q&A)• Data about onSuite Transition• Parting Data
![Page 5: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/5.jpg)
#BBK12UC
Personal Data
The John Cooper School
1180 Students in Prekindergarten - 12Private, Nonsectarian
The Woodlands Texas (north of Houston)
Scott Ardill
Webmaster
Steve Sandifer
Database Coordinator
![Page 6: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/6.jpg)
#BBK12UC
Attributes
• Don’t Overlook the Unique option
• Using the academic year in the name – thoughts?
![Page 7: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/7.jpg)
#BBK12UC
Global Change – Add Attribute• Add the attribute first• Use Replace for
dates along with a “+”• Attributes come with
their own dates• Look for blank import
ids
![Page 8: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/8.jpg)
#BBK12UC
Comma Separated Values (CSV)
Last,first,gender,grade,advisorSample,Ima,Male,12,LaranceSample,Youra,Female,8,Tasgen
Record
Field
Delimiter
Header
![Page 9: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/9.jpg)
#BBK12UC
Queue ModuleAutomatically Schedule Global Changes and ore
![Page 10: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/10.jpg)
#BBK12UC
Queries• Cntrl-A• Email a query
• Multiple rows per student
![Page 11: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/11.jpg)
#BBK12UC
![Page 12: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/12.jpg)
#BBK12UC
Queries from Reports
![Page 13: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/13.jpg)
#BBK12UC
Exports• One row per record• The first option you
choose “fixes” the subsequent exports
• To keep things in order, export the same field multiple times
![Page 14: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/14.jpg)
#BBK12UC
Imports – Tabs• Export to Import• Delimited with
![Page 15: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/15.jpg)
#BBK12UC
Imports – Fields Tab
![Page 16: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/16.jpg)
#BBK12UC
Registrar’s Office External Text Alert System
Folder on Network/Shared web folder
Student Billing
Cafeteria Software (Counterpoint) Website (BBNC)
• Export dates of physicals and import dates into attributes• Export contract attributes from web-forms to student billing• Do global changes based on imported attributes• Where do YOU move/want to move data?
Administration
Parent Groups
Data Between
![Page 17: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/17.jpg)
#BBK12UC
Admission Office Local Computer Applicants
• Place decisions on EE (AO) records manually• Export a CSV file with the decisions and email addresses• Open Word mail-merge and create letters• Switch to email-merge and create emails• Run a global change to put the letter dates on attributes
Admission Letters
![Page 18: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/18.jpg)
#BBK12UC
Data Exchange
Questions? Answers? Thoughts?
![Page 19: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/19.jpg)
#BBK12UC
onSuite Data
Questions? Answers? Thoughts?
![Page 20: Behind the Scenes Data Coordination - Scott Ardill and Steve Sandifer](https://reader035.vdocuments.us/reader035/viewer/2022062406/55be78c9bb61ebf8738b45eb/html5/thumbnails/20.jpg)
#BBK12UC
Parting Data
[email protected] ext. 2396
The John Cooper SchoolOne John Cooper DriveThe Woodlands, Texas 77381