Scenario No

Subject:ManagementPrice: Bought3

Share With

Scenario No. 1 

Trisha George is a college English professor and an author who has written novels and books of poetry. She does not have a website but wants one. She will provide with content such as her professional resume, information about her writings, and details she wants her students to know about her classes. She would also like at least one page that highlights her college and department and asks that the information is gathered from her school. A shopping cart for her novels and poetry will be necessary. You have been hired as the IT Consultant and must have a project proposal for the website.

Scenario No. 2

Baxter's Ticket Sales is a small sports-ticketing venue. The company has decided to move to a new location in a neighboring community to take advantage of lower sales and property taxes. A network must be developed in the new building. There are 10 workers in one large room who each use a desktop computer to facilitate sales. There is an office staffed by two people who each need their own desktop computers. Additionally, the "mail room" requires another computer for the staff to access the database and fulfill orders. The project will need to include the development of the topology, network security, connection to the Internet, etc. You have been hired as the IT Consultant and must have a project proposal for the network.

Scenario No. 3 

North Music Warehouse is a wholesale establishment that sells student-grade musical instruments to both music stores and individuals. The president of the company realizes that workers in "the warehouse" - which is several buildings - are slowed by having to return frequently to the main office to retrieve printed orders. Efficiency would be heightened with a mobile application designed to access the sales database and log the movement of instruments, so these workers may locate instruments in the warehouse buildings and prepare them for shipping without having to spend the time returning to the office. You have been hired as the IT Consultant and must have a project proposal for this application.

Scenario No. 4

Angie Smith is a new business owner and has just opened Angie's Antiques. She needs a database to be developed to hold information about her varied inventory and sales. She intends to develop a customer list to be able to advertise specials. Three employees have been hired to run the store, so the database will also need to include employee data and payroll information. You have been hired as the IT Consultant and must have a project proposal for the database.

Instructions

Part 1

Module 5 Assignment includes preparing a Gantt Chart from two software options: you will have a Gantt chart for one of the above chosen scenarios using MS Project or MS Excel. If you choose Option 1, Microsoft Project, then make sure you have the software loaded and ready to use. Alternatively, you can complete the assignment with Option 2, using the MS Excel.

For creating the Gantt chart in MS Excel, several tutorials are available on the Internet. One good tutorial that can help you getting started is "How to have a Basic Gantt Chart in Excel 2016".

Minimum Submission Requirements

MS Project (Option 1) or MS Excel (Options 2)

You will choose from one of the above Scenarios for creating a Gantt Chart using MS Project (Option 1) or using MS Excel's Project Planning Template (Option 2) from a Free Project Management Template.

• Choose just one of the scenarios above to use for either choices. 
• Assume that you have a team of 3-5 people to help you complete the project.
• Do not use outside sources for this Assignment; this is to be developed from your understanding of the scenarios
• Submit as part of the assignment the Project file (MS Project or MS Excel).

You may need to perform additional research on the topic of Gantt Charting using MS Project and/or MS Excel for the successful completion of this assignment.

Follow all instructions below carefully, including the length requirements where stated.

Option 1: MS Project Gantt Chart

Develop a Gantt Chart using Microsoft Project for your given scenario. Please note that it is necessary to submit the MS Project file to earn credit points in this assignment.

Assignment Requirements

1. Chart shows a least 12 tasks and subtasks having reasonable durations. The project may extend many days, weeks, or months depending on what you need to do for your client.
2. Chart shows the total duration of the complete project on the first line of the chart.
3. The Duration, Start, and Finish dates are appropriate for all tasks.
4. Tasks are orderly established (e.g., requirements before testing).
5. Predecessors and Successors (dependencies) are established.
6. Tasks are properly linked in the chart's time table.
7. A minimum of 3 Milestones are included.
8. Name of the Resources (job roles) are listed on the time table.
9. Tasks do not show overallocation of resources.
10. Recurrent activities are included.

 

 

Option 2: MS Excel Gantt Chart

Create the Project Plan and Gantt Chart for your chosen scenario using MS Excel Project Planning Template.

Assignment Requirements

1. Chart shows a least 12 tasks and subtasks having reasonable durations. The project may extend many days, weeks, or months depending on what you need to do for your client.
2. Chart shows the total duration of the complete project on the first line of the chart.
3. The Duration, Start, and Finish dates are appropriate for all tasks.
4. Tasks are orderly established (e.g., requirements before testing).
5. Predecessors and Successors (dependencies) are established.
6. Shows dates under the Baseline Plan and Current Plan columns for each task.
7. Includes resources under the Primary Responsibility column, using job roles.
8. Uses formulas for assigning dates to tasks.
9. Uses conditional formatting.

Part 2

MS Word document

 

Provide a suitable title for the project and complete the rest of the information shown on the page. Make up any information not already given to you (such as the name of your IT consulting company).

Executive Summary

Have a paragraph of that explains (1) the problem, (2) the recommendation, and (3) the justification for your recommendation.

Objectives

Provide a bulleted list of project objectives. There must be at least three objectives listed.

Strategies/Methods

Have a paragraph or two that explains the project scope and how you plan to execute the project.

Human Resources

Provide a list or table of the people needed to have this project. Include names and their job titles. There must be at least three people in addition to you; remember that you are the consultant, and you are going to hire an IT team. Your project might require testers, legal, or other services. It is acceptable to invent names.

Schedule

Provide a Gantt chart using either the MS Project or MS Excel Project Planning Template that shows at least 12 major milestones, the specific human resources needed for each milestone, and the timing. Since embedding is not possible, take a screenshot of your Gantt chart to place in your Word document, and submit both the Word document (project proposal) and the Project document (Gantt chart).

Costs

Provide the following information in separate tables in this section:

• Objects: hardware, cabling, software, or any other tangible items needed, the cost per item, quantity, and total cost. Include hyperlinks (URLs or text links) to the sources that provided this information.
• Services: Internet hosting or other services not included as labor costs. This section may not apply to all projects.
• Labor: people, cost of labor per hour, estimated number of hours, and total cost. Make sure you include yourself and all others listed in the Human Resources section. Either above or below your tables, provide a total of all costs.

Methods of Communication                      

Have a paragraph that explains all methods of communication (email, phone, written reports, etc.) you intend to use with the client for this project.

Approvals

This section is provided for you. Make sure to sign and date [by typing] in both places.

 

Appendix: Read Part 3 below.

Part 3

MS Visio

Use Microsoft Visio to create the item or items below that matched your choice of scenario and embed your work in the Appendix page. Please note that you do not need to submit the MS Visio file. Provide appropriate detail as follows.

• Website mockups of an index page and another primary page.
• Network diagram and separate building schematic.
• Database ER diagram showing entities, attributes, relationships, and primary keys. There is more than one way to create ER diagrams.
• Software flowchart using standard shapes/symbols.

Note: Never assume the client will know how to double-click your diagram to find additional tabs. Always show all content in the project document itself. This means that if you have two items to display, you will need to embed them separately in the Word document.

For more information on A P A style formatting, go to A P A Style Central under Academic Resources of this course or visit the Writing Center.