Reference no: EM131052776
Maximizing Communications Human Networking
Ms. Sapper, this year's annual partner meeting coordinator for a global accounting firm, faced an interesting challenge. With 400 high-powered partners gathering from all around the world, she wanted to arrange meal seating in a way that maximized diversity at each table. She hoped that this seating would encourage partners to open up new lines of communication and discourage old cliques from re-forming. The banquet facility included 50 tables, each seating eight guests. Sapper had all the necessary partner data, but she found herself stumped about how to maximize diversity at each table. Let's walk her through the process.
Download and save "partners.xls" from the MIS 10e OLC. Open the file and note that in addition to partners' names, it also contains industry, region, and gender information. The Table No. column has been left blank.
a. In Excel's menu, select "Data" and then "Sort" and then press the "F1" key for help. Read through each of the topics. How would an ascending sort arrange the list "Smith; Jones; Zimmerman"?
b. What feature allows users to sort month lists so January appears before April?
c. Sort the partner data first on Gender, then by Industry, and then by Region, and save the file.
d. Examine the sorted results from the previous step. Notice that assigning the first eight partners to the same table would minimize diversity. This result should also provide a clue about how to maximize diversity. Using this insight, assign a table number in the range from 1 to 50 to each partner in your sorted list so to maximize diversity. Save the file as "partners_sorted.xls" and explain your logic.
|
Create a version of the temp converter application
: Create a version of the Temp Converter application
|
|
Describe the ethical concerns that have arisen
: Write a critical analysis essay based on the above topics. It is expected that student to write approximately 1,000 words. A minimum of 10 reference lists from reputable sources are required.
|
|
Network uptime to sustain business operations
: With 22,000 customers, 48,800 cataloged parts, and 150 employees working in five U.S. locations and an office in Germany, the last thing John Bellnier needs is an unreliable network. Yet that's exactly what he contended with for years as IT manage..
|
|
Develop a logical and congruent research proposal
: Develop a logical and congruent research proposal to answer this question. Present the proposal and the justification discussion under the following headings: Introduction / Background and Problem statement &Research question / Hypotheses
|
|
Maximizing communications human networking
: Ms. Sapper, this year's annual partner meeting coordinator for a global accounting firm, faced an interesting challenge. With 400 high-powered partners gathering from all around the world, she wanted to arrange meal seating in a way that maximized..
|
|
Famous psychological experiments
: The Stanford Prison Experiment is arguably one of the more famous psychological experiments of the past several decades. Discussed in most introductory psychology textbooks, this experiment evaluated the psychology of prison life.
|
|
Fill all necessary information and tax returns for 2013
: Douglas Plastics Co. filed all other necessary information and tax returns for 2013, including Form 1096 and Form(s) 1099.
|
|
Benefits of residential sprinkler systems
: Write a brief essay discussing the benefits of residential sprinkler systems, in particular, water mist and water spray systems.Your response must be at least one page in length, double-spaced, and 12-point Times New Roman font.
|
|
Can extrinsic motivations be internalized
: What was the most useful instructional theory or strategy you encountered in this course? How might its application be extended to atypical learners and topics?
|