Capstone Graduating Class
MSRM Aquatic Information Branch
Project: Association for Co-operative Education Website Development
Group Members: Gail Copp, Janie Montgomery, Raquel Wang
The Association for Co-operative Education is a non-profit organization
made up of post-secondary co-op programs throughout BC and the Yukon.
ACE promotes co-operative education for students and prospective employers.
The Capstone development team consists of Gail Copp, Janie Montgomery and Raquel Wang,
all second year students in the Computer Systems Technology program at Camosun College,
graduating in December 2003.
ACE’s website was in need of an update to handle their current information search and
storage needs. The new website involved a total redesign of the existing interface,
with the addition of a back-end database. The main benefits associated with the completed
project are: improved site navigation, a search feature, additional information to site visitors,
innovative interactivity, and online storage of vital association data.
Program code was written in the scripting language PHP, which uses an application
interface to connect to a MySQL database.
Our Capstone team wishes to thank our Project Sponsor, Mr. Brad Erikson, our faculty
advisor, Dr. Marla Weston, our Project Manager, Mr. Ken Hartman, and the various other
members of the Camosun Computer Systems Technology faculty, who all helped to create
an inspiring learning environment while we achieved our Capstone goal.
Project: Avue Technologies Smart Card Reader
Group Members: Alex Yan, Nick Wood, Peter Lai
Avue Technologies is a 15-year-old company that mainly deals with Human
Resource departments for numerous United States Federal Government
Agencies. Avue creates software that automates the HR management
process, enabling HR Professionals and managers in governmental
organizations to shift their focus from processing HR paperwork to
Avue's current Applicant Intake System allows users to apply for US
Government positions via a web interface or by completing a paper
"bubble sheet" that is scanned into the system. Avue would like to
investigate adding a third data entry mechanism, a kiosk.
The purpose of this project is to implement the connectivity between a
smart card reader (using Java Card technology) and the PC-based kiosk,
as well as implement changes to Avue's Applicant Intake system to
optimize the process for the kiosk environment.
The project supervisor, Stephen Curran, will act as the team's liaison
and Julia Yan, an employee of Avue Technologies, will act as the team
leader on this project. The development team consists of Nick Wood,
Peter Lai, and Alexander Yan.
Avue will benefit in a number of ways after this project is implemented.
First, they will acquire the knowledge of how smart cards function, and
how to create software that utilizes them. Next, they will have the
ability to market smart cards with systems that they offer subscriptions
to. Lastly, they will gain market leverage with US Federal Government
Agencies that are purchasing these smart cards.
Project: Career Shop
Group Members: Clint Johnson, Kyle Goard, Ryan Graves, Paul Peterson
The Career Shop is a youth employment drop-in center that opened in September 1999.
They are a career service that offers computer and Internet access, one-on-one counselling,
job search strategies, labour market information, education and community resource information
and workshops. All of their services are aimed at youth aged 15-30. Their center is fully
funded by the government of Canada.
The CS team is developing a management system for the Career Shop. The software is written
in ASP.NET and C#, and will run on an IIS server with an underlying MySQL database. This management
system will encompass multiple modules: Client Sign-in, Case Management, and Administration.
Each module which comprises the system has multiple components. The core Case Management module
facilitates solutions such as managing clients, real time statistics of system usage, real time
Counsellor Reports, and a comprehensive online calendar scheduling system.
This management system, along with its management and scheduling modules, will automate tasks
which are currently being done manually; resulting in a minimum of 50+ person hours being freed up per month.
Project: CIPS Website Development
Group Members: Bob Gutierrez, Stuart Alleyn, Mindy Saroya
The Canadian Information Processing Society, or CIPS, was formed in 1958 as the Computing and Data
Processing Society of Canada. The CDPSC was formed to allow data processors to share ideas, knowledge,
practices, and technology with each other. In 1968, the organization changed its name to CIPS.
CIPS now represents over 8,000 Information Technology (IT) professionals in Canada.
The current CIPS website exists mainly as an events calendar and to take registrations for their
monthly events, annual golf tournament, and dinners. CIPS believes that their current website
has become obsolete, and that by updating to new technologies including content provided on-the-fly
by a dynamic front end, the website will better reflect CIPS Victoria as a cutting edge, high
The objective of the website and its function is to offer support, resources, online networking
opportunities, and industry information to high school, college, and university students,
employees and employers within the local IT community, and a password protected area for
the CIPS Victoria executive. The primary goal of the website is to encourage further growth of
CIPS Victoria in the form of new members who wish to become a part of the growing CIPS community.
CIPS Victoria wants to make their local site a hub for IT professionals and students alike in
Victoria, and encourage greater use of the provided online resources.
Project: Circuit Analyst
Group Members: James Jones, Stephen Harrigan, Adam Woo
The Circuit Analyst project was submitted by Dale Shpak to be bundled with future versions of MATLAB.
MATLAB is a command prompt program which solves logic and mathematical problems.
The target market are engineers.
The purpose of Circuit Analyst is to provide a graphical circuit designing interface for electrical
engineers. This will allow engineers to graphically connect components and test them without dealing
with tedious equations.
Upon completion Circuit Analyst will be packaged with MATLAB freely.
Fisheries Data Maintenance Application
Group Members: Jeff Dwyer, Andrew Duncan, James Gagan
DGD Consultants is a Camosun College Capstone team, consisting of
Jeff Dwyer, James Gagan, and Andrew Duncan. We have developed a software
project for the Aquatic Information Branch (AIB) of the Ministry of
Sustainable Resource Management (MSRM). This project is the Fisheries
Data Maintenance Application (FDMA).
The project involved
the migration of an existing web application to a format that complies
with current Ministry standards.
This project was necessary because the pre-existing application,
which was vital to Ministry biologists, was to be retired within
18 months if not brought up to MSRM application standards. This
task entailed redesigning the application and rewriting it completely,
utilizing the Jakarta Struts framework, a more modular architecture
that will make maintenance of the application much easier.
We have also added value to the application by:
- Configuring and implementing a web-mapping component, using
a tool called the Internet Mapping Framework (IMF).
- Redesigning the awkward user interface, while adhering strictly
to the Struts Model-View-Controller (MVC) framework.
Technologies used in development and deployment were: Jakarta Struts
1.0.2, log4j, OC4J Standalone, Oracle RDBMS 9.0.2, JDeveloper, Jakarta
Ant, and the Internet Mapping Framework (IMF).
The end result is that MSRM now possesses a completed, up-to-date
online data maintenance application, with minimal monetary outlay.
Project: Eisos Plug-in
Group Members: Jordan Marlatt, Colin Doak, Taro Gurney
The Team: The Eisos Plug-In project team consists of Taro Gurney, Jordan
Marlatt and Colin Doak. The faculty advisor is Tim Ayers.
The Client: The project is sponsored by PureEdge Solutions, a
Victoria-based software development company that specializes in secure
XML-based electronic forms.
The Project: The Eisos project will involve creating a plug-in for
PureEdge’s Designer application. The Designer allows users to create
XML-based forms in a graphical environment. The goal of Eisos is to
provide a seamless interface between the Designer and a remote repository
or Content Management System, and provide file-locking functions. The
advantage of this framework is that multiple users will be able to
collaboratively design forms without the fear of overwriting shared files.
Project: Danger Management Products Approvals System
Group Members: Jacob Martello, Drew Millen, Terry S. Martin
Siemens is a multinational conglomerate that manufactures and sells a
range of products; some of which are Fire and Security products. Because
sales representatives sell these products all over the world, they have
to ensure that before a product is sold, it has been approved for sale
in a country by that countries approval authority. CSA and ULC are two
such approval authorities in Canada.
Siemens has an application that keeps track of the security products and
their approval certificates. Due to the language it is written in, there
are limitations to the program. These limitations will cause the
application to be retired. Our team has been contracted to rewrite this
program using new technology. The new program, "Haven", provides greater
speed, improved functionality and better platform independence.
The team working on the Haven project consists of three members: Drew
Millen, Jacob Martello, and Terry Martin. The application we have
created is a web application, developed using a Jakarta Struts framework
and a Java Server Pages (JSP) interface. A secondary development goal
was to use assisting technologies such as eXtreme Programming, CVS, ant
Project: Thrifty Foods
Group Members: Ben Hornett, Jared Wong, May Trinh
Alex Campbell co-founded Thrifty Foods with one small store in 1977. With a
business philosophy of "look after the customers and look after your employees",
they have grown into a chain of 18 stores - and they are the largest private-sector
employer on Vancouver Island.
Thrifty Foods uses a database system to store and keep track of information on
customers who submit payment in the form of a cheque. As this database contains
important and confidential customer information, Thrifty Foods requires a database
system with enhanced security, as well as up to date information.
The Thrifty Foods Capstone team of Ben Hornett, Jared Wong and May Trinh are providing
Thrifty Foods with an updated non-sufficient funds (NSF) Database Application which
includes the following benefits:
- More accurate and up to date information on NSF customers
- A simplified user interface
- Enhanced security
- Improved efficiency