Transcript Project Poster - Senior Design

Project Team Information
Team Members
David Low, CprE
Laura Longoria, EE
David Schwenker, CprE
Robert Sailer, EE
Faculty Advisors
Project Client
Dr. John Lamont
Professor Ralph Patterson, III
Ames Community Schools
Abstract
Project Requirements
Ames Community Schools (ACS) has been concerned with the performance of
their students’ problem solving abilities on a nationally standardized exam. While
ACS traditionally scores in the 90+% on traditional math skills, results from the
problem-solving section were around 40+%. The purpose of this project is to
provide web-based software that supplements classroom learning, particularly in
the area of geography. By utilizing the software to extend classroom learning, the
students of ACS will be better prepared for standardized tests, resulting in higher
test scores.
Problem Statement
⋆
⋆
⋆
⋆
To develop software for 3rd-6th grade students
To be user-friendly and interactive
To provide updated U.S. geographical information
To include practice and performance exams
⋆
⋆
⋆
Program includes login with a username/password scheme
Students choose a state using an easily navigable map of the United States
Program displays state information upon request
Server stores software and database
Database contains geography data
Database has exercises, exams, results
Students operate from own client PCs
Server talks to clients via the Internet
Server generates a customized web
page based upon client input
Multiple platform use (PC, Macintosh)
User-friendly for 3rd-6th grade students
Basic instructions for new users
Measurable Milestones
⋆
⋆
⋆
⋆
response
PHP/MySQL education
Database population
Software coding
Testing
Proposed Approach and Considerations
client
Proposed Approach
⋆
search
query
server
data
Components include: database design and population, HTML design, graphic
design, and application code design
⋆ Components divided amongst team members
Technologies Considered
Operating Environment
⋆
⋆
⋆
⋆
Program must be accessible to students via the Internet
Results must be stored in database for teachers to retrieve and review
Program must be similar to Globey’s World (Ongo8b) but with US Geography
Functional Requirements
⋆
⋆
⋆
General Solution-Approach Statement
⋆
⋆
⋆
⋆
⋆
Design Constraints
General Problem Statement
⋆
⋆
⋆
⋆
Design Objectives
Program exists on LAMP (Linux Apache MySQL PHP) architecture
Application code written in PHP on Apache web server
Database backend written in MySQL
Program runs on Linux operating system
⋆
⋆
⋆
ASP.NET
SQL Server 2000
HTML
Intended Users
⋆ Students in grades 3-6
⋆ Instructors
⋆ School administrators
Sailer,
Robert
24%
Low, Li-Wei
26%
Intended Uses
⋆ Supplement classroom instruction
⋆ Improve standardized test scores
⋆ Monitor student progress
⋆ Development testing
⋆ Installation testing
⋆ Functional testing
Resources and Schedule
Personnel Effort
Intended Users and Uses
Testing Considerations
Schwenker,
David
26%
Longoria,
Laura
24%
Financial Resources
Copying
17%
Binding
8%
Poster
75%
Assumptions and Limitations
Assumptions
⋆ Computers have Internet Explorer
or Netscape 5+ browsers
⋆ Computers are connected to the
Internet
⋆ Supervision with computer
experience exists
⋆ Students have previously been
exposed to U.S. geography topics
Limitations
⋆ Students may not have much prior
experience using computers
⋆ Team members must learn PHP and
MySQL
⋆ Internet bandwidth can limit
performance
⋆ Computer/processor speed of the
client machines can limit performance
Expected End Product
⋆
⋆
⋆
⋆
⋆
⋆
Application supplements U.S. geography curriculum
Students will be able to log in
Teachers will be able to access student statistics
Teachers can create additional problems
Solution can be viewed on any platform
Students can work on problem solving skills at home
Summary
Test results and discussions with ACS teachers have shown that additional resources
are needed to boost the district’s performance in the problem solving sections of
standardized tests. This project will provide the supplementary instruction and drills
that ACS students need to meet and exceed the goals of the school and the
community.