90 likes | 106 Views
2005 CONFERENCE. April 5th & 6th. Proofing the Class Schedule with Schedule Helper by Adam Howard North Orange County CCD. Agenda. What is Schedule Helper? History Uses How does it work? Schedule Helper in action Questions?. 3CBG Conference - April 5th & 6th 2005.
E N D
2005 CONFERENCE April 5th & 6th Proofing the Class Schedule with Schedule Helperby Adam HowardNorth Orange County CCD
Agenda • What is Schedule Helper? • History • Uses • How does it work? • Schedule Helper in action • Questions? 3CBG Conference - April 5th & 6th 2005
What is Schedule Helper? A Microsoft Word template file with embedded VBA-coded user-interface 3CBG Conference - April 5th & 6th 2005
History • Developed for SCE Schedule Coordinator to produce schedule document • Access expanded to all SCE Program Coordinators for proofing • Adapted to fit format of Fullerton and Cypress college schedules 3CBG Conference - April 5th & 6th 2005
Possible Uses • Proofread course offerings • Produce department fliers (printed or PDF) • Produce course schedule (well, maybe part of process, anyway) 3CBG Conference - April 5th & 6th 2005
How does it work? Behind the scenes • SQL queries via Microsoft ADO / ODBC • Loads course, section info to program variables • Writes info formatted to Word document 3CBG Conference - April 5th & 6th 2005
How does it work? User perspective • Log in • Choose courses to pull into document • Click a button • Proofread on-screen or print out 3CBG Conference - April 5th & 6th 2005
Schedule Helper in action To the Desktop! 3CBG Conference - April 5th & 6th 2005
Questions? (besides “why not a catchier-sounding name?”) Interested? Email me at ahoward@sce.cc.ca.us 3CBG Conference - April 5th & 6th 2005