140 likes | 155 Views
IQWST system for managing test distribution efficiently with web frontend and database backend, not recording actual test data. PHP and MySQL technology used for better organization. Provides secure login, project creation, and scheduling abilities. Accessible demo website available.
E N D
IQWST Everest Wu Juancarlos Aponte Chris Rogers Ashwin Vaidyanathan IQWST 1
Motivation • Horizon Research, Inc. (or HRI) • Research in math/science education • Standardized testing IQWST 2
Description • IQWST • “Investigating and Questioning of World through Science and Technology” • Follows students through middle school • Analyzes progress in science classes • Experimental curriculum FOR MORE INFO... http://www.horizon-research.com/ IQWST 3
Goals • System for assisting test distribution • Web frontend • Database backend • Manages scheduling, mailing, and contact info • Doesn’t record actual test data IQWST 4
Why? • Current system uses Microsoft Access • Access is clunky and obsolete • Database in need of redesign • Web access more efficient IQWST 5
Use Cases • Users • HRI employees • 2 levels of access • Normal user: views/edits authorized projects • Administrator: views/edits all projects, manages users IQWST 6
Technology • PHP 5 • MySQL 5 with phpMyAdmin • Microsoft Excel • Editors • WordPad, TextPad, NotePad, phpDesigner IQWST 7
Design Frontend Backend Jan Feb Mar Apr Schedule • Design • Frontend • Backend • Deployment Deployment IQWST 8
Design Database DB Frontend Printing Website IQWST 9
IQWST Database
Database • ~15 tables, largest about 1400 rows • Data mass import • phpMyAdmin imports CSV directly into database IQWST 11
Current Status • Website and database hosted on CS servers • Next step: Finish backend and connect to frontend IQWST 12
Website • Secure login • Create projects • Schedule test administrations • View/edit info for: • Districts • Schools • Teachers • Classes IQWST 13
Demonstration Current website http://wwwx.cs.unc.edu/Courses/comp523-s08/IQWST/project/login_page.php IQWST 14