Answered: The following tasks are designed to…

Information Technology Project Management

9th Edition

ISBN:9781337101356

Author:Kathy Schwalbe

Publisher:Kathy Schwalbe

Chapter5: Project Scope Management

Section: Chapter Questions

Problem 4T

See similar textbooks

Related questions

Question

The following tasks are designed to test your resourcefulness and your communication skills. It was designed to take less than one hour. Please submit the assessment even if you did not fully complete it in the time allocated. If you were unable to fully complete it, please include a brief explanation of where you had the most difficulty/ what took the most time.

Please complete the following tasks within this worksheet and return the excel file to us via email within 1 hour.

1)The 'member names' and 'membership information' tabs contain (fictitious) member information. For context, we distinguish members by their location (local to LA or non-local) and the sector in which they work (for profit or non-profit).

In Sheet 1, please count (using a formula) the number of 'local' and 'non-local' members we have based on the 'membership information' tab, and enter a chart that shows the proportion of one to the other. Choose the chart type that you think is best suited.

2)Create another sheet named 'chart training' in which you explain to a colleague how to create a chart like the one you created from a similar list of membership information, so they could repeat the process independently later.

3)The 'member names' tab contains 500 names and corresponding member ID; 'membership information' contains the membership descriptor and birthdates for 250 of those members, also with corresponding IDs.

In Sheet 2, please create a list that matches member names with their membership information & birthdates using the Membership IDs provided.

2)Leave the formulas you used intact in Sheet 2 and copy the information as values into Sheet 3. (There should be a list of 250 members with IDs, names, birthdate, and membership information in Sheet 3 when you are done).

3)Create another sheet named 'matching training' in which you explain to a colleague how to match based on ID like you did in sheet 3, so they could repeat the process independently later.

Please note:

We expect you to use excel formulas to provide the most accurate result, but we do not expect you to know these formulas off the top of your head. You are encouraged to use online resources to find the formula to best provide the desired results. In your description of the process, please communicate as if the instructions are meant for a person with only basic excel skills.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions