automated-integrated registration william j. obermeyer b.s. computer science/mathematics, puc
DESCRIPTION
Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC. Web-Based Application Solutions. Applicability : Redundant/Repetitious Minimize : Duplication of Work Effort. Integrated Automation. Automation. Considerations. Current Process - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/1.jpg)
Automated-Integrated RegistrationWilliam J. Obermeyer
B.S. Computer Science/Mathematics, PUC
![Page 2: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/2.jpg)
Web-BasedApplication Solutions
Automation
IntegratedAutomation
Applicability: Redundant/Repetitious Minimize: Duplication of Work Effort
![Page 3: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/3.jpg)
Considerations
Current Process
MailMyForm
Email to Excel (copy/paste)
Excel to Database (import)
Generated by NeedEmail
SQL Reports
Excel Spread Sheets
Proposed Process
Registration Form
Data Validation
Automated Reporting
![Page 4: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/4.jpg)
Current Process
http://education.calumet.purdue.edu/sciolympiad/2009registrationform.html
![Page 5: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/5.jpg)
<!-- Start of Mail My Form.com Error Display --><script type="text/javascript">
var str = location.search.substring(1, location.search.length);var recup =
'<scr‘+‘ipt language=JavaScript src="http://errors.mailmyform.com/‘+'?mailmyform_username=trekles‘+str+'"></scr' +'ipt>';
document.write(recup); </script>
<!-- End of Mail My Form.com Error Display -->
MailMyForm Script
![Page 6: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/6.jpg)
Copy and Paste Email
School: G.R. Clark High SchoolPhone: 219 659-3522County: LakeSchool_Address: 1921 Davis Ave.City: WhitingSchool_ZIP: 46394Individual_Name: School City of HammondDivision: Div C2008Compete-YES: onMorethanone-NO: onCoachName: Joanne OrosCoachPhone: 219 947-5981CoachAddress: 672 Quail DriveCoachCity: HobartCoachState: INCoachZip: 46342CoachEmail: [email protected]: 4AddCoaches: Michele ParsleyRegion-PUC: onMemberFee: 225.00LateFee: ManualFee: 2GrandTotal: 225.00
MailMyForm email data
![Page 7: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/7.jpg)
Excel Spread SheetData Management
![Page 8: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/8.jpg)
Proposed Process
http://sciolympiad.calumet.purdue.edu/sciolympiad/stateregistration
![Page 9: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/9.jpg)
PHP DrivenMySQL Database
![Page 10: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/10.jpg)
Customized Reports
![Page 11: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/11.jpg)
Excel Data Import/Export
![Page 12: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/12.jpg)
ProposedIntegrated System
Data VerificationEmail ValidationData Integrity
Science OlympiadRegistrationDatabase
On PUC Server
Registration Entry Form Email Data Verification
Live User Data Updates
Coordinator Data Access
Standardized Reports
Excel Table Data Export
Data Integration/Security
![Page 13: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/13.jpg)
Proposed System Future
Longevity
PHP-MySQL Available Expertise Reliable Equipment Data Security Data Integrity
Service
Maintenance Enhancement Documentation
![Page 14: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/14.jpg)
Registration Entry FormEmail ValidationData Integrity ChecksEmail NotificationUser Data AccessCoordinator Data AccessCoordinator Reports
Team Registration ListRegional Teams List
Batch Email Facility
Total 100 Hours
Budget/Contract
![Page 15: Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC](https://reader036.vdocuments.us/reader036/viewer/2022070402/56813929550346895da0d24e/html5/thumbnails/15.jpg)
Questions
?