140 likes | 506 Views
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”
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