Information Systems Deliverable 5 – Resource Assignment Matrix
yoko@3074
2 years ago
40
files (2)Deliverable5ResourceAssignmentMatrix.docx
Deliverable05RAM.xlsx
Deliverable5ResourceAssignmentMatrix.docx
Assignment Content
1.
Top of Form
Competency
· Analyze resource capacity and allocations supporting information technology projects.
Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.
Scenario
The Project Manager of GDS asked you to use an Excel spreadsheet to create a Resource Assignment Matrix specifying cost and availability. Then update the Microsoft Project file by assigning resources and costs to resource sheet and tasks identified in the previously created WBS. You must identify and address all over-allocation issues using the leveling tools within the project management software. The Project Manager identified the following resources for this project: Project Manager, System Administrator I, System Administrator II, Network Administrator and IT Technician.
Instructions
With the resources identified in the scenario, use an Excel spreadsheet to create the Resource Assignment Matrix (RAM). Update the Microsoft Project file created for Deliverable 4 by assigning resources and costs to resource sheet and work packages (subtasks). Resolve any over allocation issues with assigned resources.
· Using the Excel template provided, create the Resource Assignment Matrix (RAM) using the resources identified in the scenario.
Deliverable 05 RAM.xlsx
· With the completed RAM, update the previously created Microsoft Project file by assigning the resources and cost to the resource sheet and then assigned the resources to the appropriate work packages (subtasks).
· Resolve all the over allocation issues using the leveling tools in Microsoft Project.
Resources
· If you need software tools such as Microsoft Word, Excel, Project or Visio, downloads are free to students at this website:
· Need help with Business Writing, this website can help:
Bottom of Form
Deliverable05RAM.xlsx
RAM
| Resource Assignment Matrix | ||||||||||||||||||||
| Project | Project # | |||||||||||||||||||
| Project manager | Sponsor | 0 | ||||||||||||||||||
| Project artifacts | Updated | |||||||||||||||||||
| Project Task | Business End Users | Business Sponsor | IS Sponsor | Business Driver | Business Project Lead | Project Manager | Business Sys. Analyst | Data Modeler | DBA | Data Staging Designer | Educator | Appl'n Developer | Tech/Security Architect | Tech Support Specialist | Data Staging Programmer | Data Steward | QA Analyst | |||
| Project Management and Requirements | ||||||||||||||||||||
| Initiation | ||||||||||||||||||||
| 1 | Develop preliminary project scope | |||||||||||||||||||
| 2 | Identify business need | |||||||||||||||||||
| 3 | Develop preliminary budget | |||||||||||||||||||
| 4 | Identify preliminary return on investment | |||||||||||||||||||
| 5 | Complete project charter | |||||||||||||||||||
| Planning | ||||||||||||||||||||
| 1 | Establish project identity | |||||||||||||||||||
| 2 | Identify project team/resources | |||||||||||||||||||
| 3 | Conduct stakeholder analysis | |||||||||||||||||||
| 4 | Prepare draft project schedule | |||||||||||||||||||
| 5 | Conduct project kickoff meeting | |||||||||||||||||||
| 6 | Gather detailed user requirements | |||||||||||||||||||
| 7 | Define current business processes (as is) | |||||||||||||||||||
| 8 | Revise project schedule | |||||||||||||||||||
| 9 | Develop project communication plan | |||||||||||||||||||
| 10 | Develop project organizational structure | |||||||||||||||||||
| 11 | Identify training plan | |||||||||||||||||||
| 12 | Develop project quality plan | |||||||||||||||||||
| 13 | Develop scope management plan | |||||||||||||||||||
| 14 | Develop risk management plan | |||||||||||||||||||
| 15 | Develop change management plan | |||||||||||||||||||
| 16 | Develop cost management plan | |||||||||||||||||||
| 17 | Develop schedule management plan | |||||||||||||||||||
| 18 | Develop technical specifications | |||||||||||||||||||
| 19 | Develop technical architecture | |||||||||||||||||||
| 20 | Conduct project procurement | |||||||||||||||||||
| 21 | Finalize project budget | |||||||||||||||||||
| 22 | Finalize return on investment | |||||||||||||||||||
| 23 | Ongoing project management | |||||||||||||||||||
| Execution | ||||||||||||||||||||
| 1 | Develop training materials | |||||||||||||||||||
| 2 | Execute communication plan | |||||||||||||||||||
| 3 | Develop software | |||||||||||||||||||
| 4 | Develop new business processes (to be) | |||||||||||||||||||
| 5 | Deploy new software | |||||||||||||||||||
| 6 | Conduct training | |||||||||||||||||||
| Closing | ||||||||||||||||||||
| 1 | Get deliverable acceptance | |||||||||||||||||||
| 2 | Close out contracts | |||||||||||||||||||
| 3 | Finalize budget | |||||||||||||||||||
| 4 | Finalize return on investment | |||||||||||||||||||
| 5 | Conduct closure survey | |||||||||||||||||||
| 6 | Conduct/document lessons learned | |||||||||||||||||||
| 7 | Archive project | |||||||||||||||||||
| Legend | ||||||||||||||||||||
| Creates the deliverable | C1: primary creator; C2: contributor | |||||||||||||||||||
| Input required | I | |||||||||||||||||||
| Reviews the deliverable | R | |||||||||||||||||||
| Approves the deliverable | A | |||||||||||||||||||
| Notified when the deliverable is complete | N | |||||||||||||||||||
| Owns the deliverable upon completion | O | |||||||||||||||||||
- Earthquakes in Chile
- LSTDWK2
- Best Accounting Expert
- Dwright
- I have the resources I need (e.g., tools, equipment, supplies, personnel) to do my job effectively. (RESOURCES)
- Business Law - Discussion Board
- What is Imagined Communities
- Your task is to compare the views – and the reasons explicitly given or implied or suggested for these views – presented in at least two of the following texts by at least two different authors: Plato's (1) Euthyphro, (2) Apology, (3) Crito; (4) King's “L
- helpfor assignment
- Tripple One Writter- Part 4
