examples of capstone projects 2010 to 2012sacapstone.wdfiles.com/local--files/start/consolidated...

Examples of Capstone Projects 2010 to 2012

Examples of Capstone Projects 2010

Clear Choice Business Suite For Ragno Electric

Stemstudios Ltd. Anthony Lombardo – Developer

Phillip Couto – Project Lead

The Problem at Hand When selecting the client Ragno Electric was of great interest. Ragno Electric is a small to medium sized company that has been around for over a decade. After reviewing their current system and understanding what Ragno Electric was looking for it was evident that their current system lacks integration, data integrity, automation, and a true multiuser solution.

The Solution The solution that was agreed upon by both Stemstudios and Ragno Electric is a client application that interacts with a central database server and a Web Portal to display information to Ragno Electric’s clients. This system needs to handle the storage and organization of job site data, billing data, time sheet data, and inventory data while still providing a way of generating reports and gathering critical information required by Ragno Electric.

System Architecture

Realization The system has been developed to be deployed on Windows Server 2003, Windows XP workstations and newer with the requirement of .NET Framework 4 to be installed. This system will be accessible only within the Ragno Electric’s local network except for the web portal. The system will be using MySQL 5.5 as the RDBMS and also Microsoft’s Internet Information Services 7 for the web hosting. The system will only support the English language.

System Hierarchy

Project Name

Crystal Memories

Client Organization

Sheridan Elder Research Centre (SERC)

Team Name

4 Fold IT

Team members and their respective roles

Yacoub Husseini – Team Lead, Client Relations and Testing Mathieu Gosbee – Developer (Cross-Platform) Graham Wright – Developer (DBA, Administration, and Security) Brennan Gregoris – Hosting and Deployment

Project Synopsis

Client Overview:

The Sheridan Elder Research Center (SERC), opened in September 2003, is a unique environment for the conduct of applied research into areas of practical concern and immediate relevance to older Canadians. SERC develops innovative approaches and creative interdisciplinary partnerships to focus on enhancing the lives of Canadian seniors.

The goal of SERC is to identify, develop, test and support implementation of innovative strategies that improve the quality of life for older adults and their families, and to do this through applied research.

Objective:

Memories are precious, especially to someone suffering from Alzheimer’s disease or Dementia. One way to help hang onto them is to create “memory boxes” containing objects—letters, photos, souvenirs and knick-knacks—that can trigger important recollections.

Solution:

Provide a system where individuals, along with the help of family and friends, can create a “Virtual Memory Box” that is accessible at any time, from any device.

Technologies Used:

Microsoft SQL Server 2008 Microsoft MVC 2 Framework C# ASP.Net 4.0 AJAX jQuery JO (HTML5 Mobile Framework)

System Hierarchy Chart:

Justin Pereira, Project Manager Jesse Pereira, Developer Joshua Veira, Developer

GeoAccess Reports.com By Senex for Geoff Hogan of Osnium Software

The Problem: Obtaining GeoAccess reports A GeoAccess report is a document outlining the distance relationship between two sets of locations. Such a report is used by organizations as a decision making aid when choosing a service provider. One example is that of a company choosing a fitness or health care provider for their employees as part of a benefits package. These providers would be required to submit a GeoAccess report as a part of their Request for Proposal. GeoAccess reports are often expensive, costing $500 per report or more if the report is required within one business day. Typically, a customer would send a list of individual locations and a second list of provider locations to a third party who would create the report over several days. The Solution: GeoAccess Reports.com GeoAccess Reports.com is a web-based application that allows a user to generate their own GeoAccess report in minutes using location information that they upload to the site. Once created, reports can be purchased using a credit card or PayPal account. This process cuts the time to generate, purchase, and download a report to 30 minutes or less. Because the process is automated, reports can also be priced much more competitively at a base rate of $200. Simplified System Architecture

Technologies Utilized

• C#, ASP.NET 4.0 • Microsoft SQL Server • Microsoft Server 2008 Virtual Machine • Koogra Excel parsing library • Open XML SDK for creating Microsoft Word documents • JQuery JavaScript library • Exchangerate-api.com for currency conversion • PayPal API for purchase processing • Google GeoCoding API for longitudes, latitudes, and driving times

System Hierarchy

HVAC System Solutions | Capstone Final Project 1

H V A C M A I N T E N A N C E R E C O R D S Y S T E M S

Capstone Final Project

HVAC Industry HVAC System Solutions

Norman Aspe Eddie White Kevin Nguy

Brennan D’Aguilar

Project Manager QA & System Analyst Web Application Developer Mobile Application/Web Service Developer


INTRODUCTION

In any other high technical field, you have validation of work done; in the HVAC industry, it seems that this is erratic at best. Most if not all paperwork is stored off site or in several locales and finding it when it is required is always a problem. Sharing this valuable information with onsite techs and remote offices can cause breakdowns in communication that can cost money and lost time in solving these problems. This type of communication between service office, onsite tech and customers’ office has improved with advent of the cell phone but a complete closing of the circle is required with new technology and proper up keep of highly sophisticated energy saving equipment.

The main idea is to eliminate “drive-by”

maintenance services by creating accountability. There will be a QR code at each client location which will store the information required by the contractor. The contractor will be able to pull all the data required from the QR code to his Blackberry and upload it to the centralized server. This will prevent mistyping of serial numbers and other user errors. By automating the process it will allow all maintenance to be easily documented saving time and money. Clients will also be able to access their service information online, so they can determine what technician has worked on which piece of hardware, how much work was done and when.

REALIZATION

The system was designed to use open source and multi platform languages and tools. The website is built atop a lightweight custom PHP MVC framework created specifically for this application. A WSDL based web service that also runs on the framework allows for external applications to connect and interact with the data.

The BlackBerry application is written in Java based on the BlackBerry 5.0 API and relies

on a J2ME based web service connection. To allow easy implementation on other platforms, the web service connection was designed specifically to not rely on the BlackBerry API.

SYSTEM ARCHITECTURE


SYSTEM HIERARCHY CHART

WE B AP P L I CAT IO N SC HE MA TI C

B LA CKB E R RY MO B I LE AP P LI CA TIO N S CHE MA TI C

Login

Query Selection

Manual Scan

Equipment Info

Add Maintenance

Record

View Mainenance

History

QR Code Scan

Equipment Info

Add Maintenance

Record

View Mainenance

History

Login

Equipments

Add Equipment

Modify Equipment

Add Warranty

Add Maintenance

Schedule

Add Maintenace

Record

Add Part

Alerts

Add Alert

Modify Alert

Clients

Add Client

Modify Client

Contractors

Add Contractor

Modify Contractor

Users

Add User

Modify User

Parts

Add PartModify Part

Reports

Alert Lists

RestaurantManagementSystem

Client: Brasas

Matthew Lemos – Project Leader Marco Da Silva – Programming Lead

Konstantin Kourteev – Database Admin Bradley Budhu – QA & Documentation Specialist

Introduction

TheProblem:Our Client Antonietta Da Costa had a very specific problem that is very common among small businesses. All paper work at Brasas is handwritten and stored in countless folders. This includes weekly schedules, inventory, purchase orders, and so on.

TheSolution:We have created an all‐in‐one web solution to help Antonietta at Brasas manage her employee scheduling, inventory levels, catering schedule, and sales. This will create substantial business value for our client as she no longer has to rely on paper and huge amounts of storage; everything is now in one convenient location. Also because it is all web based employees can check their schedule from their homes, and the owner can do all of her restaurant management from home.

Architecture:

Realization:All web modules are based off the ASP .NET framework with C# running the logic in the background and HTML and CSS controlling the layout and styling. The point of sale system is simply a C# windows form application. Everything is connected to Microsoft SQL Server 2008 to keep everything in the Microsoft .NET family. This system is designed to have a back office computer/server hosting the database and web platform and then computer at the front of the restaurant running the point of sales application that connects to the database.

LoginScreen

MainScreen

Catering Scheduling Reports

View/Edit Order

Add Customer

View Customers

View Schedule

Book Off

Employee Availability

Inventory

Catering Customers

Catering Schedule

Vendor Order

Sales

Scheduling

Vendor

<<Employee Login>>

ProjectName:Aqua

Client:TheWaterStoreMilton

TeamName:BoltSoftwareSolutions

TeamMembersandRoles:

ReinerBata ‐ ProjectManager,DBA,LeadDeveloper

FelipePantos ‐ SystemsAnalyst,TestingLead,Developer,DocumentationLead

Introduction

Problem:The Water Store Milton’s paper based system poses a slew of problems. For instance, Customer

Information is stored on two physical locations: a stack of index cards for Prepaid Bottle Customers and

filing cabinets for Service Work Customers. The result of this system is slow data retrieval and

duplication of information for the same customer. Another problem is that Product Information is not

readily available. This problem pertains to scenarios when a Customer wishes to know about

replacement parts for a particular Water Treatment Equipment System. The clerk currently relies on the

Store Owner to provide information which in turn reduces productivity on both the employees.

Solution:Our Application handles the problems of our client. Customer Information (including Prepaid Bottle

Balance, Service Work. .etc) will be stored in a central location and can be easily retrieved. Product

Information will also be easily accessible thereby allowing clerks to provide immediate feedback on any

customer questions regarding products. In addition, our Application is able to produce reports based on

the data that has been captured and tracked.

ArchitectureWeb Based System

RealizationIDE used: Visual Studio 2010 Tools: ASP.NET Web Forms 3.5, C#, ADO.NET, SQL Server 2008, Crystal Reports, MS Chart Control, Ajax Control Toolkit, CSS, and Elmah Error Logging.

SystemHierarchyChartWe currently employ 3 access roles to our application and they are as follows:

Web Admin‐ contains the highest privilege including Store Admin privileges Store Admin‐ can access Employee Mgmt, Product Mgmt, User Mgmt, and Reports as well as ALL clerk functions Clerk – access only to basic functionality

Login

Home

Accounts Sales ServiceProduct Search

Store Admin Reports Web Admin

Search

Create New

View

Search

Create New

Employee MgmtCreate New Search

Product Mgmt

User Mgmt

User Role Mgmt

The page contains features such as:Updating Personal InformationAdding Water Treatment EquipmentManaging Prepaid Bottle BalanceAdding Service Work Adding Water analysis

Clerk Priviliges

Store Admin Priviliges

Web Admin Priviliges

View

Survey Management System

Discovernet

Cyber Phoenix

Peter Wilson – Project Manager Stephen Caine – Developer

Joseph Chamoun – Technical Writer Indumini Weerawansa – QA Analyst

The Problem Replacing a site survey system where the information was largely taken down on paper with a digital camera for pictures. Employees might complete 25 to 50 of these surveys in a single day and then would need to input this data back into the spreadsheet. With such a large amount of surveys the danger of mixing up data was always prevalent.

Our Solution Our goals are to simplify the creation, management, and retrieval of site surveys. To that end we created an ASP.Net website which allowed us to centralize the whole process. The surveys created using the website are accessed by employees onsite on their smart phones. This removes the possibility of user errors inputting data and streamlines the whole process to improve efficiency.

Architecture

Realization

Website – ASP.Net application written in C#, running on IIS 7.0, utilizing AJAX and JQuery

Web Socket Server – C# windows application Hybrid App – HTML 5 and JavaScript utilizing PhoneGap API

System Hierarchy Web Site

Mobile App

SpectrumAirwaysFlightSchoolManagement

Muhammad Jilani – Lead Application Tester & UI Specialist

Adam Rush – Project Manager & Programing and Database Design Support

Wael Salo – Lead Programmer & Database Designer

Introduction

Spectrum Airways current operation, with exception to the accounting, relies solely on a paper based

system for flight scheduling and recording. The paper based system is an inconvenience to clients and

staff. Data is processed by hand to populate a number of logs required to maintain a fleet of aircraft.

Human errors and inconsistences could jeopardize the safety of the flight operation. The Spectrum

Airways Flight School Management system, developed by Fly High Tech, provides the mean to eliminate

the paper system by digitizing the operation. The system provides convenience to clients and staff alike

by providing a web portal to the operation, increasing productivity, accuracy and customer satisfaction.

Architecture

MySQLDatabase

CakePHP Framework

Spectrum Airways Flight School Management System

Model

GWT, HTML, jQuery

Business Logic, PDF EngineView

Controller

Realization

The Spectrum Airways Flight School Management system was developed using popular open‐source

technologies. The server side system was developed using PHP along with CakePHP rapid development

framework technology with a MySQL database. Complex client side interfaces were developed using

Google Web Toolkit which uses the Java technology.

SystemHierarchy

Capstone Project Synopsis An online dating service

‘Online Match’ will allow individuals to communicate and interact with each other over the internet. The website will require a potential user to provide subjective information in the form of a questionnaire, and with that data our website will compute a list of prospective matches through the use of matchmaking algorithms that our team will be responsible for developing and integrating with the rest of the website

12/3/2012

Siddharth Sharma Project Manager

Neil D’Souza UI Designer

Sanjovin Singh Developer

Eric Guo QA Analyst

December 3, 2012 CAPSTONE PROJECT SYNOPSIS

Systemic Solutions

1

Introduction Our client wants us to develop an Online Dating Service in the form of a comprehensive website. ‘Online Match’ will allow individuals to communicate and interact with each other over the internet.

Problem Our client wants to expand in the online dating business and has a requirement for an intuitive and stable web platform that would appeal to the targeted consumer base. Our team was recruited to realize this venture.

Solution The website will require a potential user to provide subjective information in the form of a questionnaire, and with that data our website will compute a list of prospective matches through the use of matchmaking algorithms that our team will be responsible for developing and integrating with the rest of the website. Along with the unmediated matchmaking the website will allow users to send messages to other users, maintain an online profile, look up other users through our website’s search tools or just be able to browse other people’s profiles.

Realization Online Match is developed in Microsoft’s ASP .Net framework 3.5 using Microsoft Visual Studio 2010 as the IDE, with Java script and JQuery along with ASP.Net acting as the presentation (interface) layer and C# as the logic layer (code-behind). MS SQL Server 2008 R2 is the standard relational database management system (Data layer) and will be used extensively to store and query all the user’s as well as the website’s relevant data. The application is hosted on Windows Server 2008 R2.

Architecture

December 3, 2012 CAPSTONE PROJECT SYNOPSIS

Systemic Solutions

2

System Hierarchy Chart

Home

Login

Register

Profile

Search

Messages

Reports

Edit Profile

Search Criteria

Sent Items

Inbox

User Report

User Activity

User Statistics

User

Admin

Capstone 2012 1 | P a g e

Ryan Egan

Lead Developer and Project Manager

Patrick Colangelo Developer and DBA

Andrew Toole Lead QA and Systems Analyst

Brandon Brooks QA and Documentation

Event Management System

December 2012


The Client Creative Style Event Design Inc. is the parent

company of two event design companies, Wedding

Wows – Floral and Décor Designs and One of a Kind

Weddings & Events. They are a full scale event design

and coordination company serving Toronto and the

surrounding area.

The Problem The current system setup at Creative Style is a loose

paper-based system that could be described as a

nightmarish attempt at organization. Excel

spreadsheets are the driving technology for

invoicing and there are various templates made up

for contracts and packages but that’s about it, in

terms of automation. The event dates and payment

information is jotted down on a single paper

calendar that could at any time be lost, stolen, or

destroyed which would result in absolute chaos.

The Solution Our solution is a rich web application to handle their client information, scheduling of events,

invoicing & payments, as well as adding the ability to run reports and analyze customer data. The

web application has also been designed to adapt to any sized layout, ranging from a 4.3”

smartphone to a 27” desktop PC. This allows the client to access their information on the fly from

anywhere using any device; all they need is an internet connection.

The Technology • Responsive Web Design • ASP.NET MVC w/ Razor views • SQL Server 2008 R2 • Entity Framework


The Overview

Eric Park – Project Manager Lucas Lomnicki – Lead Developer/Database

Justin Abeto – Developer/UI Design

Capstone Project Synopsis - December 6, 2012

1

Introduction

Sheridan College is a post-secondary institution with approximately 50,000 students. Founded in 1967, the college has 3 campuses located in Oakville, Brampton, and Mississauga. Our primary client, Mark Orlando is a former Academic Advisor of the Faculty of Applied Sciences and Technology.

The Problem

The current Student Advisement System relies on a paper-based manual environment that is highly resource intensive offering little to no security and reporting capabilities. The business involves Academic Advisors managing a maximum of 15 student appointments per day while keeping track of hundreds of student issues across 3 campuses. The current system is plagued with data entry errors and duplicates as a result of the manual entry of data. Due to the amount of overhead required, a more streamlined and accessible solution is needed for the client.

Our Solution

We have developed a web-based system designed to cater the business model of the client. The centralized system offers a more accessible option to multiple Academic Advisors and its staff in 3 different campuses. The integration of appointment scheduling, issues handling, comment threading, and attachable web based action forms have contributed to a more streamlined business process. Data integrity has also improved due to validation controls implemented throughout the system. The digital conversion of the business’s data has also promoted a more secure solution while eliminating redundancy. Furthermore, the utilization of a centralized data repository have made report and statistic generation possible.

Architecture

Realization

The application was designed using ASP.NET MVC 3 architecture with Razor View Engine as the front-end. Web technologies such as JavaScript, jQuery and AJAX were utilized to implement client side validation and dynamic content. Database design was accomplished using Microsoft SQL Server 2012 and was mapped using Entity Framework 4 due to its ease and integration with MVC. Microsoft’s SQL Server Reporting Services were also used to generate reports. Other 3rd party open source technologies were used to implement specific dynamic content. Telerik’s Kendo UI was applied for the Grid interface and Arshaw’s Full Calendar was used to generate the intuitive Calendar UI.

2

System Hierarchy Chart

Login Screen New User Account

Home Students Issues Advisors Appointments Reports About

Student Search

Student DetailsNew Student

Modify Student

New Issue

New Appointment

Issue Details

Search Issues

New Probationary Contract Form

New Part-time and/or Additional Course Registration Form

New Request for Late Enrolment Form

NewApplication for Term or Complete Program Withdrawal Form

New Application for Readmission Form

Modify Issue

Search Advisors

Appointment Index

New Appointment

Appointment Details

Modify Appointment

Advisor Report

Campus Report

Student Issue Report

Advisor Details

Modify User

Update Password

Accessed from layout only

Probationary Contract Form Details

Part-time and/or Additional Course Registration Form Details

Request for Late Enrolment Details

Application for Term or Complete Program Withdrawal Form Details

Application for Readmission Form Details

Modify Probationary Contract Form

Modify Part-time and/or Additional Course Registration Form

Modify Request for Late Enrolment

Modify Application for Term or Complete Program Withdrawal Form

Modify Application for Readmission Form

examples of capstone projects 2010 to 2012sacapstone.wdfiles.com/local--files/start/consolidated...

Documents