The Cookie Lady

The Cookie Lady

Statement Of Work

Team Orange

Statement of Work

TheCookieLadyHawaii.com

1.Purpose

The purpose of this project is to provide the client, The Cookie Lady Hawaii, with a secure, simple, low-cost, and easy to use website with the help of the Joomla content management system. It will be an informational website to help them spread the word about their product and business to all their existing and potential customers.

2.Background

a.Problem, opportunity, or directive statement

The Cookie Lady Hawaii has known of their need for an online presence. They knew that with a website they will be able to provide their existing customers and potential new customers with a new dimension of customer service. They want a website where they can provide information about their products and company updates. They would like the website to advertise their cookie products and different packaging options and company information (such as business background, directions to store, etc). We have to create a website that is cost effective, easy to maintain, and allows for future expansion. We will provide extensive documentation as well as a user manual for an easier transition of the product to its owners as they have limited IT knowledge.

b.History leading to project request

Living in the leeward side of the island, Kristen Nishihara and her family became a fan of the Cookie Lady Hawaii cookies when they first tried it. Wanting to learn more about the business and to help spread the word, Kristen asked if they had a website she could refer her friends and family to. The company informed Kristen that they have a Facebook page but unfortunately no website. They expressed their long-time desire to have a website and cited their limited technical knowledge and busy schedule to be a factor in the delay of its creation. Kristen offered them an opportunity for our team to create their business website and they gladly accepted.

c.Project goals and objectives

Our project goal is to deliver a website that is user friendly and implements the client’s most important requested features. Easy access to administrative features and administrative editing is a must. Objectively, we must work efficiently through the project within budget and within the given time frame. TheCookieLady’s expectations must be met or exceeded.

d.Product description

The Cookie Lady Hawaii is a humble family-owned business that offers an assortment of traditional and unique flavored cookies. This project will be to create an online portal for their business. It will provide their customers with information such as location, contact information, product descriptions, and calendar of events, newsletter subscription, price calculator, blog, as well as an online gallery where the Cookie Lady Hawaii faithful will be able to share and upload pictures of their cookie experience.

3.Scope

a.Stakeholders

i.Internal - Terri, Robert, Team Orange

ii.External - existing customers, soon-to-be customers

b.Knowledge

i.Minimum computer knowledge; they understand how to use Microsoft office but we will keep the admin aspects of the site as simple as possible to ease the transition to them. The owners both carry Apple IPhones, for which they may purchase the Joomla app that will give them the ability to edittheir site, among other tools.

c.Our team will be using a content management system (CMS).We will learn to use the CMS and we will train The Cookie Lady on how to use it when we transition control of the system to them.

d.Process

i.We will be using a variation of the agile method to build this information system. We have scheduled the system to be built in tight iterations (sprints) that we will review and present to Terri and Robert. We have scheduled four sprints though these next two months.

e.Communications

i.We will meet with the Cookie Lady team and discuss our progress as we build their system. Our usual meeting times will be on Sundays at 5 PM at the end of each phase that we complete. We have their email and phone numbers should we need to contact them. There will be four iterationswith two featured deliverables in each iteration. For each iteration, we will set meetings and work closely with them, applying an agile methodology.

4.Project Approach

a.Route

i.GoDaddy.com for domain/hosting site

ii.Joomla.com Content Management Software(CMS) & Development

iii.SDLC –Agile -Unified Process

b.Deliverables –

i.Website contained the design based on Family-oriented Logo and red/black with white background on the pages:

1.· Home/Cookie of the month,Newsletter subscription, Upcoming events, Facebook Link

2.· Products/ Pictures, Description, Price

3.· About Us

4.· Contact Us/Locations/Google maps

5.· Calendar/ Google Cal

6.· FAQs

7.· Site Map

8.· Privacy Policy

9.· Customer Blog

10.· Picture gallery w/Admin Control

11.· Order calculator including volume discounts, recurring orders, special marketing campaigns.

ii. Admin privileges, and Joomla tutorial

iii. Documentation: User documentations & tutorial, Site functionality report, and User/Admin Manual.

5.Managerial Approach

a.Team-building considerations

Each member of Team Orange is well-versed in System Analysis and Design. However, each member will be assigned to a specific task to complete for the CookieLadyHawaii’s web site according to the system owner’s specification.

-Ellison Uson – Project manager. Ellison will be in charge of the project management to complete “TheCookieLadyHawaii.com” by December 1, 2010, within budget, satisfying the Cookie Lady Hawaii’s specification.

  • -Jamey Lee – System Analyst. Jamey will be in charge of identifying and validating the Cookie Lady Hawaii’s business problems and its needs for the information system. Jamey will communicate with system designers and builders to ensure that the technical solution fulfills the business needs and the technical solution can be smoothly integrated into the business.
  • -Kyle Renio – Application Programmer/Webmaster and Trainer. Kyle will be in charge of converting the business requirements and statements of problems and procedures into PHP code. As a webmaster he will hold responsibilities of building the website itself. He will train the end-users how to trouble-shoot basic problems within the system.

-Craig Ponting – System Programmer/Webmaster and Trainer. Craig will work closely with Kyle to develop, test, and implement this information system. As a webmaster he will also hold responsibilities of building the website itself. He will also train the end-users to be web-masters for when we no longer providing direct support.

-Elvin Cortez – Database Programmer and Documentation/Testing and Training. Elvin will build, modify, and test database structures and procedures based on the business specifications, e.g., email list, customer review, product inventory. In addition to the database programming, he will document progress of the database development life cycle, test the outgoing newsletters per the email list, and sort out customer feedback. In addition to testing, he will be training the end-users with the end-product

-Kristen Nishihara – Network Administrator, Training and Document Repository Manager. Kristen will be in charge of optimizing and troubleshooting this project network connectivity, including training the system owner. In addition to the networking needs, she will be in-charge of managing documentation done by all members of the team. Training the administrators will also be a part of her duty.

-Paul Lemke – Security Administrator and Implementation/Testing/Training. Paul will be in charge of design, implementation, troubleshooting, and management of security and privacy control for this system. In addition to security, he will be in-charge of trainsitioning the final product into operation, and also assisting with testing and training.

-Vishal Hemlani – Trainer/ Tester and Automated Content Management. Vishal will train the users of the system and will test each task based on the schedule for the project’s smooth progress. In addition to this, Vishal will be partly responsible for the content management issues shared with the webmasters.

b.Manager and experience

-Ellison volunteered to take the position of this project manager. Not only for Ellison but also for rest of the members, this is our first commercial project meaning that Team Orange has fresh ideas, ethic, attitude, and enthusiasm about this project. Based on Professor Kazman’s lecture about project management and process management, the members of Team Orange will cooperate with Ellison to complete this project by December 1, 2010 within the budget satisfying The CookieLady’s specification.

c. Training requirements

-We anticipate that some of The Cookie Lady’sstaff may need to be trained to use the admin functions of the web-site. When the training requirements arise, the project schedule will be modified to accommodate these requirements within the project schedule as a whole. To do that, we are intentionallyallocating slack times in some of our project tasksthat we can useas training sessions. In this way the training would not delay the project schedule as a whole. However, there may be changes in the order of completion of tasks.

d. Meeting schedules

-We plan to meet with the client once every two to three weeks, or when a new feature is completed. This is so we can communicate effectively with the client, and they can let us know if they would like any changes to be made. Our group plans to meet, at a minimum, face to face once a week to discuss the schedule and project progress.

c.Reporting methods and frequency

-We will report the progress of our project to Professor Kazman through documentation and weekly updates to our GANTT chart.

d.Conflict management

-If conflict arises, the involved parties will work it out through collaborating to effectively solve problems. Handling conflict using the “avoiding” or “competitive conflict management style” would be least effective. If it is a conflict that affects the whole group, Ellison will moderate the discussion and ensure that everyone’s thoughts are heard out.

e.Scope management

-Any change from the scope defined in this statement of work requires documentation to identify and define the steps necessary to consider the change based on the expected impact of the change. Effective scope management is crucial to the success of our project; therefore we adopted the change management to protect Team Orange from being held accountable for schedule and budget overruns that will drive by the change in scope.

6.Constraints

a.Start Date

The start date will be September 27, 2010.

b.Deadlines

The given deadline is flexible, however Team Orange has to present this product on December 1, 2010 to identify further modification based on The CookieLadyHawaii’s specification. The completed product will be turned over to The Cookie Lady Hawaii for full time use by December 14, 2010. Thus giving us(Team Orange) roughly two and a half months till delivery.

c.Budget

The Cookie Lady Hawaii has given us a limited budget of $12 for the domain name,$150 for the server. In addition a limited amount of funds will be available for other necessities as they arise.

d.Technology

The technology implemented into the project will be a server and domain name through GoDaddy, the application Joomla, which is a content managementsystem, and through some custom-built PHP modules.

7.Ballpark Estimates

a.Schedule

i.Ending of September & first week of October - Planning and Familiarizing ourselves with GoDaddy/Joomla.

ii.Rest of October and beginning of November - Site development, programming, and small increments of site feature deliverables.

iii.Ending of November site complete, testing, and transitioning of development artifacts to Cookie Lady Hawaii personnel.

iv.December –Training: Familiarizing CookieLadyHawaii personnel with the site and admin features.

b.Budget

i.GoDaddy

1.Domain is a $12 annual fee (TheCookieLadyHawaii.com)

2.Hosting is $5 a month times 4 months of development, $20

3.Roughly $40 to $50

a.An extra $20 if client decides on purchasing Joomla templates

ii.CMS - Joomla -Free

1.PHP Development & Labor – Free

8. Conditions of satisfaction

a. Success criteria

i. We deliver a website that allows the customer to:

1. View products and descriptions

2. Post pictures of cookie designs and reviews of products

3. Subscribe to a monthly newsletter

4. View upcoming events

ii. We deliver a website that allows the administrator to:

1. Verify that comments and picture designs posted are appropriate

2. Upload pictures and text to pages on the website

3. Add information about upcoming events

iii. Create a website that meets the specifications provided by the employer.

b. Assumptions

i. That we will complete the project on time.

ii. Joomla will be easy to teach to our admin users.

iii. Optimistic duration time is accomplishable

iv. Scope changes will be minimal

v. Team members will operate efficiently

c. Risk

i. Project teams ability to meet up on a regular basis to coordinate efforts effectively

ii. Group may find it hard to maintain contact between clients and developers

iii. Some member’s have limited IT,programming, and testing experience

iv. Security risks

1