How can you use spreadsheet software

Assignment Help Operation Management
Reference no: EM131840667

What tools do you find most helpful for managing projects?

The tools that I have used for managing projects have been ones that I was exposed to through school for the most part. I learned how to use Microsoft Project during PM620 and it seemed like it was a very powerful but finicky tool. Everyone in class would perform the same steps and sometimes end up with different results.

In PM600 we used a tool called Thrive which performs many of the same functions of Microsoft Project but with a fresh perspective. The projects that I manage at work are very small scale and I do not use all of the standard forms and charts so Microsoft Excel works fine for me. It helps that I am fairly proficient with the program and have numerous coworkers to talk to if something comes up that I am unable to solve on my own.

Additionally, we utilize a secure form of Confluence which is "content collaboration software that changes how modern teams work" (Confluence, n.d.). We are able to create individual pages for projects and then everyone can post documents, powerpoint briefings, spreadsheets, and chat messages. It is very helpful in keeping everyone aware of each other's progress on the project even though we do not have a lot of face-to-face discussions.

How can you use spreadsheet software, such as Microsoft Excel, within the various project management processes?

Microsoft Excel can be used for many aspects of a project. Obviously, any document, list, or chart that is a table can be created in Excel. Also, templates are available online for Status Report, Project and Task Tracking, Risks Tracking, Issue Tracking, Project Budget, Timesheet, and Project Management Dashboard (The Ultimate Guide to: Excel for Project Management, n.d.). With some time, effort, and know-how I think that Microsoft Excel could be used in some manner for almost everything a project manager would need.

How can you use scheduling tools, such as Microsoft Project, within the various project management processes?

Microsoft Project can be used to create, manage, and display Gantt and PERT charts which are absolutely necessary for some projects (Bram, 2015). The PERT chart is valuable because it "presents a graphic illustration of a project as a network diagram" so that tasks can be identified as dependent, serial, parallel, or concurrent (Rouse, 2007).

A Gantt chart is "a type of bar chart that shows the start and finish dates of several elements of a project that include resources, milestones, tasks and dependencies" (Gantt Chart, n.d.). Both of these charts, created through Microsoft Project, can be used effectively with each of the processes related to Project Time Management such as Plan Schedule Management, Define Activities, Sequence Activities, and so on.

What tips can you offer for using either of these types of products?

The best tip I can provide for using Microsoft Project and the tools contained within is to practice and find someone that is skilled with the program. By working through an established set of procedures to create different products you will quickly find that your output does not match what is expected.

This may require you to start over or to retrace some steps. Regardless, it will require additional work on steps that will familiarize you with the process more.

Having a Microsoft Project guru on hand to answer questions or walk you through some of the steps will help to increase your knowledge. I was able to learn more than I expected by trying to help other classmates and seeing how they performed the steps and deducing how and why their output was different than mine. Really though, it boils down to practice, practice, practice.

Briefly describe 2 other types of project management tools.

Two important areas that I have been told that Microsoft Project falls short in are with regard to collaboration and a macro project view with easy drilling.

As mentioned before, I believe that a tool like Confluence allows for collaboration in a busy environment where people may not be located together, may not be available to meet face-to-face, and where the work on the project may be sporadic. The ability to share documents is very helpful and the blog-like comment portion keeps track of discussions.

One of the reasons that my professor in PM600 wanted to use Thrive was for the dashboard perspective that allowed a quick look at the project from a macro perspective with easy and fast access to the details that made up that view. A quick search of dashboard tools turned up quite a lot of programs that seek to fill this function so there are many options out there.

How do these 2 types of tools differ from the tools you have previously used?

I have actually used both of the tools I mentioned. I would say that they differ from Microsoft Project because they were developed with the thought of how Microsoft Project and other tools have fallen short of needs and expectations.

Each tool I researched seems to be backed by the belief that their tool is an improvement on past tools and replaces the need for most, if not all, other tools. After watching a few videos of different tools like Trello, Asana, Podio, Wrike, and Clarizen it seems like each tool has value and it might be a matter of whether the project manager wants a single solution or is willing to use multiple tools and what tool is most familiar to the project manager or team.

References

A Guide to the Project Management Body of Knowledge (PMBOK Guide) (5th ed.). (2013). Project Management Institute.

Reference no: EM131840667

Questions Cloud

Normal freezing point of water : 1) The normal freezing point of water, H2O is 0.00 °C and its Kfp value is 1.86 °C/m.
Normal freezing point of ethanol : 1) The normal freezing point of ethanol (CH3CH2OH) is -117.300 °C and its Kfp value is 1.99 °C/m.
What approaches yielded additional valuable information : How did participating in discussions help your understanding of the subject matter? Is anything still unclear that could be clarified?
Normal freezing point of benzene : The boiling point of ethanol, CH3CH2OH is 78.50 °C at 1 atmosphere and its Kbp value is 1.22 °C/m. A nonvolatile, nonelectrolyte
How can you use spreadsheet software : What tools do you find most helpful for managing projects? How can you use spreadsheet software.
Mole fraction of component of a solution : 2. The mole fraction of each component of a solution prepared by dissolving 2.00 g of nicotine, C10H14N2 , in 77.5 g of CH2Cl2
What is the volume of air per breath : Assume a certain adult requires 2.7 × 102 mL of pure oxygen per minute and assume inhaled air contains 20.0 percent oxygen by volume and exhaled
Equimolar mixture of propane : Consider a fuel which is an equimolar mixture of propane (C3H8) and natural gas (CH4). Write out the complete stoichiometric combustion
Compare and contrast three business strategies : How do leaders capitalize on the potential advantages that diversity brings to the workplace?.Compare and contrast three business strategies

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd