IS480 Team wiki: 2009T1 Sentinels
Contents
Team Sentinels
Team Members
Chng Soon Yeong, Kelvin | [1] |
Chan Pui Foong, Kevin | [2] |
Ong Shio Woon | [3] |
Tan Yi Zhuang | [4] |
Nyeow Siew Hui | [5] |
Sim Mong Cho, Jaryl | [6] |
Team Supervisor
Zheng Baihua | [7] |
Project Overview
Project Description
Team Sentinels is developing a prototype for the Coupon Promotion System, called Sight'd , that will allow merchants to launch, manage and track coupon promotions through the use of social media. The project will revolve around a web portal, which exposes a web service that is consumed by a mobile application that merchants will use, for tracking purposes. Further development will include other forms of promotional marketing like membership programs and stamp cards, which are designed to boost customer loyalty.
The objective for the project is to develop an easy-to-use platform that enables retail merchants to deliver coupons to consumers in an innovative and cost effective way. The scope of the project involves the brainstorming for viable business solutions for distribution of coupons and other promotion collaterals, designing and implementing a web solution, and deploying the beta product online for our clients to host their promotions online in the form of electronically distributed coupons. In addition, the developed prototype will simulate the coupon redemption process as proof-of-concept for Sight’d team during the business’s BETA testing phase. The planned project duration is scheduled for 15 weeks from 17 Aug 09 to 29 Nov 09. The development of the web-based system would be primarily based on open source resources and thus, the budget requirement for the development of the project is kept minimal.
The main technical highlight of the project is to develop the coupon promotion system using Ruby on Rails which uses REST routing to serve up pages. This routing system would also be further developed into an API as a web service for consumption within social media sites and future implementation on mobile technology.
Motivation
The motivation for development of CPS began from an IS426 Technopreneurship project headed by a team consisting of Jaryl Sim, Nyeow Siew Hui, Luong Thanh Khanh and Hedren Sum under the supervision of Professor Desai Arcot Narasimhalu. As a continuation to the technopreneurship idea, our FYP team was formed to further develop the idea and to develop a prototype system.
Today, merchants rely heavily on coupon promotions to drive traffic to their physical stores. However, the resources required to launch promotions consumes too much resources (time, money and material for printing). Our proposed solution for this issue is to enable coupons to be launched on the internet, where marketers can reach out to a potentially larger crowd at a lower cost, making it less resource intensive to test and fine-tune their promotions.
Objectives
The Coupon Promotion System will help merchants:
- Launch and manage coupon promotions through a single portal
- Enable merchants to handle redemption of coupons
- Aid critical decision making for promotional acitivites with built-in analytical tools
The Coupon Promotion System will help consumers:
- Keep updated with the latest promotions
- View and manage their coupons
Stakeholders
Stakeholder | Name | Designation | Project Involvement |
---|---|---|---|
Sponsors |
Paul, Ernest James |
Mentor |
|
Clients (Merchant) | Screme, Cottage Waffle Place, |
Café / Restaurants |
|
Clients (Consumers) |
Friends, Relatives |
End Users |
|
Supervisors | Zheng Baihua | SIS Lecturer, SMU Office: SIS Lvl 4 Room 04-39 |
|
Project Documentation
Milestone and Deliverables
Version | Date | Description | File |
---|---|---|---|
V1.0 | 14 May 2009 | Initial Draft | document |
V1.1 | 17 May 2009 | Updated Milestones To reflect new use cases into schedule: |
Project Proposal and Reports
Version | Date | Description | File |
---|---|---|---|
V1.0 | 17 Aug 2009 | Final Project Proposal | Proposal |
V1.0 | 28 Sept 2009 | Midterm Reflection report Project Demo: YouTube Link |
Midterm |
Project Management
Team Sentinels uses Unfuddle - a secured site that provides a one-stop solution to Project Management, Subversion Hosting and bug issuing and tracking for software development team - for the management and tracking of time and project milestones.
With Unfuddle, better collaboration is ensured and the team is able to work at the comfort of our home to develop the system.
Bug Tracking
Unfuddle also provides solutions for bug tracking and ticket management. Our team uses tickets to keep track of bugs, feature requests, or future enhancements for our project. These tickets are a fundamental tool for prioritizing and managing ownership of tasks. Upon creation of a ticket, Unfuddle will notify the team via email and anyone in the team can accept the ticket(s) and resolve the bugs accordingly. Upon resolving of a bug, the debugger can flag it in Unfuddle and another member of the team has to verify the ticket before closing it.
Project Status
Weekly Progress Summary
Week 0
10 August 2009 to 16 August 2009
- Meeting with Baihua for final proposal update and review [minutes]
Week 1
17 August 2009 to 23 August 2009
- Designed and created the GUI for the Coupon Promotion System
- Created the User Profile with Register and Login/Logout function.
- Attended the FYP class conducted by Prof Ben
Week 2
24 August 2009 to 30 August 2009
- Team meeting to follow up on progress on FYP[minutes]
Updates for the week:
- Created User Profile for Merchants
- Creating account verification in Profile Management
- Preparing proposal for Screme
- Preparing rake task to populate database for testing purposes
Week 3
31 August 2009 to 6 September 2009
- Supervisor meeting - Project Updates & final proposal review [minutes]
Updates for the week:
- Drafted client proposal to Screme
- Completing Profile Management use case and embarking on Merchant Management use case
- Prepared rake task for database populating
Week 4
7 September 2009 to 13 September 2009
- Project team meeting [minutes]
- Delegate task to prepare for sponsors meeting on Wednesday.
- Delegate task to prepare for sponsors meeting on Wednesday.
- Sponsor meeting (Wednesday 7pm) [minutes]
- Special guest, Lawrence, to give team advise on a third-party perspective on Sight'd
- Received feedback from Ernest on how to improve Sight'd
- Shared with Ernest and Lawrence the direction of Sight'd and plans for deployment
- Special guest, Lawrence, to give team advise on a third-party perspective on Sight'd
Week 5
14 September 2009 to 20 September 2009
Updates for the week:
- Project Schedule to adopt iterative approach instead of waterfall approach
New assignment of tasks.
- Yi Zhuang > outlet management use case
- Kelvin Chng > campaign and coupon use case
- Marilyn > Contacting Screme to discuss on participation in Sight'd Beta testing
Week 6
21 September 2009 to 27 September 2009
Updates for the week:
- Supervisor and Sponsor meeting (Wednesday 3.30pm)[Presentation]
- Provide updates on the project progress and midterm reflection
- Solicit feedback from sponsors on areas for improvement on current site
- Prepare Midterm Reflection *Done*
Week 7
28 September 2009 to 4 October 2009
Updates for the week:
- Completed Midterm Reflection
- Download Midterm Reflection [Midterm Reflection v1.0]
Week 8
5 October 2009 to 11 October 2009
Plans for the week:
- Studies for Midterm
- Continue codes on coupon management system
- Fix bugs and code validation
Notice: Recently fixed ruby Passenger bug > Sightd.com is up for testing now. For merchant account testing, please use user: bessie, pw: 123456.
Week 9
12 October 2009 to 18 October 2009
Updates for the week:
- Change of Sight'd user interface
- Reasons:
- Improve look and feel of Sight'd website
- Improve content management
- Improve website usability
- Improve look and feel of Sight'd website
- Reasons:
- Functions for Coupon Management almost completed.
- Helena from Cottage Waffle Place has agreed to be Sight'd Beta Tester
Week 10
19 October 2009 to 25 October 2009
- Project team meeting [minutes]
Updates for the week:
- Redesign UI for Sight'd
- Preparing test plan and test cases
Master Test Plan and Test Cases
Version | Date | Description | File |
---|---|---|---|
V0.1 | 26 Oct 2009 | Master Test Plan | Test Plan |
V2.0 | 29 Oct 2009 | Test Case Summary | Test Case Summary |
V1.0 | 17 Oct 2009 | Test Case for Profile Management | Test Case |
V2.0 | 29 Oct 2009 | Test Case for Merchant Management | Test Case |
V2.0 | 29 Oct 2009 | Test Case for Outlet Management | Test Case |
V2.0 | 17 Oct 2009 | Test Case for Campaign Management | Test Case |
V2.0 | 17 Oct 2009 | Test Case for Coupon Management |
Test Case |
Week 11
26 October 2009 to 1 November 2009
Updates for the week:
- Meeting with Supervisor (Presentation Slides)
- Beta Testing (Postponed)
- Cottage Waffle owner not back from Oversea
- Deploy project into production server.
- Prepare UAT survey. [[8] Survey]
Week 12
2 November 2009 to 8 November 2009
Updates for the week:
- Treehouse is has agreed to be Sightd Beta Tester. They have requested for the system to help support an event, Starry Night next Friday (13 Nov)
- The team is working on enhancing the security of Sight'd website to ensure the safeguard of users information.
- There 7 security features that will be implemented into Sight'd [Security tips from Railcasts ]
- Mass Assignment *Partial Completion*
- File Uploads *Validation done, proceed to protect Apache setting to void scripting*
- Filter Log Params *Done*
- Cross-Site Request Forgery (CSRF) Protection *Done*
- Authorizing Ownership *Done*
- SQL Injection *Done*
- HTML Injection(XSS)*Done*
- There 7 security features that will be implemented into Sight'd [Security tips from Railcasts ]
Week 13
9 November 2009 to 15 November 2009
Updates for the week:
- sightd.com is up and running now! Go take a look!
- Sight'd is supporting Treehouse promotion for Starry Night [Click here to view the promotion]
- Sight'd is supporting Cottage Waffle promotion also [Click here to view the promotion]
Week 14
16 November 2009 to 22 November 2009
Updates for the week:
- Exam break ... mugging like mad
- Fixing bugs reported by merchants and consumers
- Collecting website usability feedbacks and update Sightd based the feedbacks from sponsors and clients
Week 15
23 November 2009 to 29 November 2009
Updates for the week:
- Completed Final Reflection!
Deliverables can be found here:
Version | Description | File |
---|---|---|
V1.0 | Project Proposal | Proposal |
V1.0 | Midterm Reflection | Midterm Reflection |
V1.0 | Final Reflection | Final Reflection |
V3.0 | Appendix A - Use Cases | Use Cases |
V3.0 | Appendix B - Flow Charts | Flow Charts |
V1.0 | Appendix C - Data Documentation | Data Documentation |
V1.0 | Appendix D - Web Architecture | Web Architecture |
V1.0 | Appendix E - Deployment Plan | Deployment Plan |
V3.0 | Appendix F - Gantt Chart | Gantt Chart |
V1.0 | Appendix G - Bug Tracking Report | Bug Tracking Report |
V1.0 | Appendix H - Website Usability Report | Website Usability Report |
Week 16
30 November 2009 to 6 December 2009
Updates for the week:
- Going for final papers!
- Final Presentation