IQWST

1
IQWST
Everest Wu Juancarlos Aponte Chris Rogers Ashwin
Vaidyanathan
IQWST
1
2
Motivation

• Horizon Research, Inc. (or HRI)?
• Research in math/science education
• Standardized testing

IQWST
2
3
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
4
Goals

• System for assisting test distribution
• Web frontend
• Database backend
• Manages scheduling, mailing, and contact info
• Doesnt record actual test data

IQWST
4
5
Why?

• Current system uses Microsoft Access
• Access is clunky and obsolete
• Database in need of redesign
• Web access more efficient

IQWST
5
6
Use Cases

• Users
• HRI employees
• 2 levels of access
• Normal user views/edits authorized projects
• Administrator views/edits all projects, manages
  users

IQWST
6
7
Technology

• PHP 5
• MySQL 5 with phpMyAdmin
• Microsoft Excel
• Editors
• WordPad, TextPad, NotePad, phpDesigner

IQWST
7
8
Schedule

• Design
• Frontend
• Backend
• Deployment

Deployment
IQWST
8
9
Design
Database
DB Frontend
Printing
Website
IQWST
9
10
Database
11
Database

• 15 tables, largest about 1400 rows
• Data mass import
• phpMyAdmin imports CSV directly into database

IQWST
11
12
Current Status

• Website and database hosted on CS servers
• Next step Finish backend and connect to frontend

IQWST
12
13
Website

• Secure login
• Create projects
• Schedule test administrations
• View/edit info for
• Districts
• Schools
• Teachers
• Classes

IQWST
13
14
Demonstration
Current website http//wwwx.cs.unc.edu/Courses/c
omp523-s08/IQWST/project/login_page.php
IQWST
14