Inventory Management System for Mid-Sized Retailer: A group of students developed a web-based inventory management system for a mid-sized retail store that sells clothing, accessories, and household items. The system allowed employees to track inventory levels in the warehouse and stores, place orders with suppliers, manage deliveries, and generate reports on best-selling products. It was built using PHP and MySQL and integrated with the retailer’s existing point-of-sale systems. This helped the retailer gain better visibility into inventory across locations and streamline the reorder process.
Customer Relationship Management Software for HVAC Company: Another team of CST students worked with a local HVAC installation and servicing company to build a Customer Relationship Management (CRM) system. The application allowed technicians to log service requests from customers, schedule appointments, track jobs, generate invoices and work orders. It helped office staff track communications with customers, manage billing and payments. The system provided insights into technicians’ performance, frequently serviced equipment types etc. which helped the company recognize opportunities and plan resource needs better. The students developed this system using Python, Django and PostgreSQL.
Online Booking System for a Salon Chain: For this project, students partnered with a salon chain that had five locations in Calgary. They developed a web-based booking system that let customers browse services offered, view stylist profiles and availability, and book appointments online. Stylists could log in to manage their schedules from any device. The administration module gave owners real-time visibility into bookings, revenue, top-selling services etc. The students built a robust, feature-rich system using PHP, JavaScript and MySQL which helped the salons reduce no-shows and improve customer experience.
Agricultural Equipment Monitoring Application: A group worked with a farm equipment manufacturer to create an IoT solution for monitoring inventory, usage and performance of farm vehicles and implements. Sensors were installed on equipment to track location, engine run-time, fuel levels etc. Real-time data was collected via edge gateways and synced to a central dashboard. Mechanics could now proactively service high-usage equipment before breakdowns. Owners got alerts for unauthorized usage, geo-fencing etc. The system utilized LoRaWAN, AWS IoT and other technologies to wirelessly connect diverse equipment across large areas.
Mobile App for Urban Horticulture Business: For their capstone, students developed a native iOS and Android app for an urban gardening company that designs and maintains green walls, rooftop gardens and other vertical garden setups in buildings. Key features included showing portfolio of projects, booking consultations, making payments, AR/VR guided tours of installations for clients. Employees could log maintenance tasks, receive work orders, upload before/after photos using the app. Integration with APIs for payments, GIS maps etc. provided a seamless experience. The app helped the company scale operations and engage more clients through a compelling digital presence.
As you can see from these examples, SAIT CST capstone projects are real-world, industry-driven solutions that address tangible business challenges. Students gain hands-on experience employing appropriate technologies and development methodologies to deliver functioning, production-ready applications. By collaborating directly with sponsor organizations, they comprehend user needs better and deliver solutions with tangible post-graduation impact. The in-depth projects help transition students smoothly into professional roles after graduation.
These were just a few high-level descriptions to illustrate the type, scope and impacts of capstone projects undertaken by SAIT’s Computer Systems Technology program. In reality, each project involves extensive planning, research, prototyping and iterations over 6-8 months before a polished product is delivered. More details on specific technical implementations, development workflows, testing processes, documentation practices etc. are usually not publicly disclosed or documented due to privacy agreements with sponsor partners. I hope this lengthy overview provides a good sense of how capstone projects help SAIT CST students gain real-world skills and foster industry connections through practical, client-focused application development experiences. Please let me know if you need any clarification or have additional questions.