examples of capstone projects 2010 to 2012sacapstone.wdfiles.com/local--files/start/consolidated...
Post on 13-Mar-2018
216 Views
Preview:
TRANSCRIPT
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
HVAC System Solutions | Capstone Final Project 2
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
HVAC System Solutions | Capstone Final Project 3
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
Examples of Capstone Projects 2011
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
Examples of Capstone Projects 2012
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
Capstone 2012 2 | P a g e
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
Capstone 2012 3 | P a g e
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
top related