This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed teams, please answer the following questions:

1. How do geographically dispersed teams collaborate effectively?
2. Please find at least three tools on the market that teams can use to collaborate on a geographically dispersed team.  Please note the pros and cons of each tool. 
3. Based on the research above, note which tool you would select if you were managing the geographically dispersed team and why.

3 pages total in length (not including title page or references)

In 500 words or more, consider this statement: For cloud computing to become multi-jurisdictional, it must be separated from politics.

Use at least three sources. Use the Research Databases available from the Danforth Library not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.   Stand alone quotes will not count toward the 3 required quotes.

On the Internet, there are many websites who support and provide responsible stewardship. Please find a unique website who’s article you find interesting but also follows Saint Leo’s core value of responsible stewardship.

Describe the website and provide a URL [this site must be unique and not used by other students]. Tell us why you chose this site, and why you believe they support or provide responsible stewardship. Also, tell us why responsible stewardship is important.

Saint Leo Core Value

Saint Leo’s core value of responsible stewardship is described as follows: “Our Creator blesses us with an abundance of resources. We foster a spirit of service to employ our resources for University and community development. We must be resourceful. We must optimize and apply all of the resources of our community to fulfill Saint Leo University’s mission and goals.”

Exp19_Excel_Ch05_Cap_Apartments

#Exp19_Excel_Ch05_Cap_Apartments

Exp19 Excel Ch05 Cap Apartments

Project Description:

You manage several apartment complexes in Phoenix, Arizona. You  created a dataset that lists details for each apartment complex, such as  apartment number, including number of bedrooms, whether the unit is  rented or vacant, the last remodel date, rent, and deposits. You will  use the datasets to aggregate data to analyze the apartments at the  complexes.

Start   Excel. Download and open the file named Exp19_Excel_Ch05_Cap_Apartments.xlsx. Grader has automatically added   your last name to the beginning of the filename.

Before subtotalling the data,   you need to sort the data.
 

  Select the Summary sheet. Sort the data by Apartment Complex in  alphabetical   order and further sort it by # Bed (the number of  bedrooms) from smallest to   largest.

You want to use the Subtotal   feature to display the average total deposit by number of bedrooms for each   apartment complex.
 

  Use the Subtotal feature to insert subtotal rows by Apartment  Complex to   calculate the average Total Deposit. Add a second subtotal  (without removing   the first subtotal) by # Bed to calculate the  average Total Deposit by the   number of bedrooms.

Use the outline symbols to   display only the subtotal rows. Create  an automatic outline and collapse the   outline above Total Deposit.

You want to create a PivotTable   to determine the total monthly rental revenue for occupied apartments.
 

  Display the Rentals sheet and create a blank PivotTable on a new  worksheet to   the left of the Rentals sheet. Change the name of the  worksheet to Rental   Revenue. Name   the PivotTable Rental Revenue. 

Display the Apartment Complex   and # Bed fields in Rows and the Rental Price field as Values.

Format the Sum of Rental Price   for Accounting Number Format with zero decimal places and enter the custom   name Total   Rent Collected.

Select the Occupied field for   the filter and set the filter to Yes to display data for occupied apartments.

You want to calculate the total   monthly rental revenue if the rates increase by 5% for the occupied   apartments.
 

  Insert a calculated field to multiply the Rental Price by 1.05. Change the name to New Rental   Revenue. Apply   Accounting Number Format with zero decimal places.

Select the range B3:C3 and apply   these formats: wrap text, Align Right horizontal alignment, and 30 row height. Select column B and   set 9.29 column width. Select column C   and set 14.43 column   width.

Apply Light Orange, Pivot Style   Medium 10 to the PivotTable and display banded rows.

Insert a slicer for # Bed so   that you can filter the dataset by number of bedrooms. Change the slicer   caption to # of Bedrooms. 

Change the slicer height to 1.4 inches and width to 1.75 inches. Apply Light Orange,   Slicer Style Light 2. Cut the slicer and paste it in cell E2.

Insert a timeline for the Last   Remodel field. Change the time  period to YEARS. Apply Light Orange, Timeline   Style Light 2. Change  the timeline height to 1.4 inches and with to 3.75 inches. 

The Databases sheet contains two   tables. You will create a relationship between those tables.
 

  Display the Databases sheet. Create a relationship between the  APARTMENTS   table using the Code field and the COMPLEX table using the  Code field.

You want to create a PivotTable   from the related tables.
 

  Create a PivotTable using the data model on a new sheet. Change the sheet   name to Bedrooms.   Name the PivotTable BedroomData.

Select the Apartment Name field   from the COMPLEX table for Rows,  the # Bed field for Columns, and the # Bed   field as Values. This will  display the number of apartments with the   specified number of bedrooms  per apartment complex. Display the values as a percentage   of row  totals.

Create a Clustered Column   PivotChart. Cut the chart and paste it in cell A13 using the Destination   Theme.

Select the 3-bedroom data series   and apply the Black, Text 1,  Lighter 50% solid fill color. Apply Black, Text   1 font color to the  vertical axis and category axis. Change the chart height   to 3 inches  and the   width to 5 inches, if necessary. Hide the field buttons in the  PivotChart.

Create a footer on all   worksheets with your name in the left, the  sheet name code in the center, and   the file name code in the right.

Save and close Exp19_Excel_Ch05_Cap_Apartments.xlsx.   Exit Excel. Submit the file as directed

Complete a 8 page report on a virtual lab.

Please prepare a 250 word paper on Constitution and why it is important. 

Please include a cover page.

Please include 2 – 3 references in APA style.

Week Fourteen Assignment

Research the Dark Web.Write a brief paper on the following topics: What is the Dark Web? How is it accessed? How is it used by criminals? How can it be used in a positive way? How can be used by law enforcement and the intelligence services. How can be used by private individuals.

Write between 200 and 300 words.  Use your own words. 

Harry the CEO was pleased with your earlier work estimating and interpreting the demand function for QuickKits™, so he is asking you to complete another time‐sensitive project.

Harry explains that BioMed has a manufacturing plant that produces a prescription topical cream called DermaPlus™, which is used for treating certain skin conditions. Hospitals and pharmacies are the main buyers of DermaPlus™.

A number of other firms produce creams that are almost identical to DermaPlus™ and the market for these creams is extremely competitive. In fact, BioMed’s current share of the market for this type of topical cream is small, so it has no ability to influence the market price. On the other hand, because Biomed is relatively small compared to the size of the market, it can sell as much of the cream as it likes at the prevailing market price.

The plant producing DermaPlus™ has been operating for a little over three years with the same manufacturing equipment. Currently there are no plans for upgrading or adding to this equipment.

Over the last three years, the price of DermaPlus™ and related creams has been quite volatile and BioMed has tried to react to the changing price by varying its output level to constantly maximize its monthly profit. To date, BioMed has been able to vary monthly production quite easily by taking advantage of a flexible, non‐union workforce with a large number of part‐time workers. However, the workforce at the DermaPlus™ plant is just about to be unionized. Once that happens, it will become much more difficult to vary the amount of labour used in the short run and therefore much more difficult to vary the monthly production of DermaPlus™.

A former employee had been asked to estimate the short‐run cost functions for the DermaPlus™ manufacturing plant (data collected on the variables he thought would be needed to estimate the short‐run cost functions for DermaPlus™ and the firm’s profit‐maximizing output level provided on data spreadsheet attached). The goal was to use this information to determine the profit maximizing output level and use that information to estimate the optimal size for the new unionized workforce.

Harry tells you that DermaPlus™ and related products are just about to come under the umbrella of a new reference‐based pricing scheme. Under the new scheme, the government will set the price of DermaPlus™ and competing creams, and review that price every two years.

Once the price has been set, BioMed and other manufacturers simply have to decide how much of the cream, if any, they want to produce and sell.

Unfortunately, although the workforce will be unionized in just over a week, the referenced-based price for DermaPlus™ will not be announced for another two months. Consequently, BioMed has to choose the size of its workforce (and therefore its production capacity) before it knows the price it will get for its product. To reduce the uncertainty about this decision, Harry recently hired a consultant with expertise in the pharmaceutical industry and reference‐based pricing to estimate the price that will be announced for DermaPlus™. The consultant estimates that there is a 5% chance that the price will be $50 per unit, a 20% chance that the price will be $100 per unit, and a 75% chance that the price will be $150 per unit. This is the best estimate the consultant can provide given the lack of information coming from the government about the issue.

Complete the following tasks:

1. Determine the profit‐maximizing average monthly production capacity for DermaPlus™ for each of the possible reference‐based prices identified by the consultant. Estimate the expected monthly profit in each case.

2. Recommend an average daily production capacity for the next 12 months given the uncertainty about the price of DermaPlus™. Your recommendation will be used to set the size of the manufacturing plant’s unionized workforce. (Note: You simply have to determine the best daily production capacity for the next 12 months, not the number of workers required.)

3. Write a short report summarizing the results of your analysis and any recommendations. 

 Week 1: Discussion

After you review Chapter 1 in your textbook and review all course materials in Module 1, please answer the following two questions:

Assignment Question :

1A)- What is the difference between a database and a DBMS?
1B) – What is data, metadata, and information? What are the differences?

2- Go to: https://www.niche.com/k12/search/best-public-elementary-schools/s/virginia/
Convert the school data found on this page into a row-column format (Click on the link below for hints)

You are required to make at least two comments on the responses posted by your classmates with a minimum of 50 words. Make sure you design your response with your own words. 

 Looking for the excel spreadsheet for:

Exp19 Excel AppCapstone Intro Collection 

Raymond’s Art Collection