Write about the Joseph Schumpeter’s concept of creative Destruction For example, many think that the introduction of self-driving cars will disrupt the job market for drivers.  

please check the file 

Excel Chapter 1 Mid-Level 2 – Real Estate Sales Report 

Exp22_Excel_Ch01_ML2_Sales

Exp22 Excel Ch01 ML2 Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price.

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

The owners of the house on 640 North Oak Drive took their house   off the market. You want to delete that row since it did not sell.
 

  In the April worksheet, delete row 10, which has incomplete sales data.

The listings are organized by   date listed. The 973 East Mulberry Lane   listing needs to be moved up in the list.
 

  Select and cut row 13 and insert cut cells on row 10.

You want to assign a property ID   to each listing. The code will have the year 2024 with a sequential number.
 

  Type 2024-001 in cell A5 and use Auto Fill to   complete the series to assign a property ID to each property in the range   A6:A13.

Real estate agents study the   number of days houses are on the market. In some cases, the longer a house is   on the market, it might indicate the asking price is too high.
 

  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C13.

Monetary values look better when   they are formatted to display the dollar signs. Because all monetary values   are whole numbers, you will decrease the decimal points to avoid columns   where all the data ends in .00.
 

  Format the list prices and sold prices in the range F5:G13 with Accounting   Number Format with zero decimal places.

To analyze the real estate   market, it is helpful to calculate the selling prices as a percentage of the   list price. For example, the second house was listed for $500,250, but it   sold for only $400,125. Therefore, the sale percentage of the list price is   .7999 or 79.99%.
 

  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H13.

The calculated percentages need   to be formatted with the percent symbol rather than displaying the values as   raw numbers.
 

  Format the values in the range H5:H13 with Percent Style with two decimal   places.

Currently, the labels on row 4   are hard to read. You will wrap the headings within each cell to improve   readability.
 

  Center horizontally and wrap the headings in the range A4:H4.

For better sequencing of   columns, you want to display the Days on Market column after the two columns   containing the dates.
 

  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C13 to F4:F13. Delete column C.

You notice the list contains a   wrong date and wrong list price that need to be corrected.
 

  Edit the date sold of the 41 Chestnut   Circle house to be 4/22/2024.

Increasing the height of the   rows of data and centering the data vertically between the top and bottom   cell margins will make it easier for the other agents to review the data.
 

  Select the property rows (rows 5:13), set a 25 row height, and apply Middle Align.

Displaying borders helps separate   the property listings.
 

  Apply the All Borders border style to the range A4:H13.

You want to improve the   alignment of number of days on market below the column label.
 

  Apply Align Right and increase the indent two times on the days on market formula   results in the range E5:E13.

You noticed some misspelled   words in the worksheet.
 

  Use Excel to check the spelling and correct misspelled words.

You don’t need the data on the   Properties sheet but you do want to copy the April worksheet to create a   template for May.
 

  Delete the Properties sheet. Insert a new sheet named May. Make sure the May sheet is the   second sheet tab.

You want to copy the original   data to the new sheet so that you can modify the duplicated data.
 

  Use the Select All feature to select all data on the April worksheet and copy   it to the May worksheet. Use the paste option to Keep Source Column Widths.

After copying data from the   April worksheet to the May worksheet, you want to prepare the May worksheet   for data.
 

  In cell A2, change April to May. Select the ranges A5:D13 and   F5:G13 and clear cell contents but keep the formatting In cell F5, type 1. In cell G5, type 1. Copy the values to the range   F6:G13.

The property listings dataset is   small. To improve readability on the printed copy for the other real estate   agents, you will increase the scaling.
 

  Select both worksheets and apply 120% scaling.

You want to apply page setup   options to both sheets, so you need to group the sheets first.
 

  Select both worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.

With both worksheets still   selected, insert a footer with the text Exploring Series on the left side, the sheet   name code in the center, and the file name code on the right side.

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

Case Study 2.1

Case Study:

You have just been hired to perform digital investigations and forensics analysis for a company. You find that no policies, processes, or procedures are currently in place. Conduct research to find information, and then create a policy and process document (3 to 4 pages in length) to provide the structure necessary for your lab environment. Be sure to cite your online sources and follow APA formatting.

Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• At least two peer reviewed sources that are properly cited and referenced
• APA format, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.

CASE: PepsiCo
“Take PepsiCo, for example. As one of the leading soft drink makers and bottlers, PepsiCo turned to IoT for the most basic of reasons and found an efficient solution. Like many enterprises, the company had inefficient and ineffective IT and OT infrastructure, as well as limited IT and OT resources available inside its plants. It also suffered from server sprawl, where each server supported a very small portion of the production load. PepsiCo essentially incurred high costs to purchase and support an ever-expanding infrastructure of underutilized servers, operating systems, and networking assets. The result: highly inefficient use of capital—at a minimum. Even worse, its inefficient network hindered the collection of data that would ordinarily drive plant productivity.”

What were the paybacks to PepsiCo after implementing IoT? Elaborate.

 Please a topic from the below list and create a one-page answering the question noted below.    

• Define the IT organizational structure and how the IT organizational structure impacts culture and change management practices.  Additionally, how does the organizational structure impact competitive advantage?
• How do you define operational excellence?  What factors are involved in achieving operational excellence?  Who (within an organization) is responsible for operational excellence and why is this important?

** Please note you have minimal space and time to complete the assignment, do not write an introduction, rather just answer the selected question noted above. This is a test of both knowledge and your ability to be succinct in messaging** 

Please choose a topic from the attachment

Propose and defend a topic for your final project.  Write  500 words or more explaining why this topic is important for your peers to understand. Be focused and specific. Look into the general topic provided in the list below to find something new and interesting to write about. You should do a deep dive into a topic. Do not do a survey. Make use of academic references such as you can find in the Danforth Library research databases  

Use at least five sources. 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. 

Write in essay format, not in bulleted, numbered, or another list format. 

The proposal must be in your own words and not written directly from the PowerPoint Presentations or papers that you completed with your group. You can include the network diagram. cost-benefit- analysis, and budget that you worked on with your group.Your paper will include a detailed proposal including the following: 

• Part I: Planning the Network
• Part II: Building the Network
• Part III: Securing and Maintaining the Network
• Include the diagram of the network and cost-benefit- analysis that you would recommend from Part II.
• Include the budget from Part III.

See the attached document for complete instructions and grading rubric. Submit your completed Project Management Networking Business Plan: Presentation to Stakeholders to the above submission link by 11:59 p.m. EST, Sunday of Unit 7.  

Chapter 9 – Read the Running Case.
Each team member will complete tasks 1, 2 and 3 and submit individually here.

Chapter 9 – Read the Running Case:

Several people working on the Global Treps Project are confused about their responsibilities for

providing content for the new website. Recall that the team members include you, the project

manager, Bobby, the IT guy, and three people who will run shark-tank-like events in Vietnam,

India, and Ethiopia (Kim, Ashok, and Alfreda). Recall that the activities in the WBS for the

in-house development include the following:

1.3.2.1 Guidelines and templates for events

1.3.2.2 Acceptance of ideas for needed new products or services

1.3.2.3 Custom site for 20 events

You and your team also need to provide information for the videos that you are outsourcing.

Recall that the purpose of these short videos is to show people how to use the site and provide

suggestions for holding the events. That activity is 1.3.1.3 Video creation for website in the

WBS. You have selected the company that will do the outsourced video creation, and their main

contact person is Angela.

Task-1. Prepare a RACI chart for the four WBS activities listed. You decide that one person should

be accountable for each of these four activities, spreading the work between you, Kim,

Ashok, and Alfreda. Bobby will be informed on each activity, and you will be consulted on

the ones you are not accountable for. Document key assumptions you make in preparing

the chart.

Task-2. You realize that all of your team members have different personality types, and you believe

you could work better as a team if you understood each other better. You asked everyone

to take an MBTI-based assessment (a free one you found at www.humanmetrics.com).

You are an ENTJ, Bobby is an INTJ, Kim is an ISFP, Ashok is an ESTJ, and Alfreda is an

ISFJ. Find information about each of these MBTI types and summarize their traits as well as

suggestions for improving teamwork.

Task-3. Angela, the person in charge of the company preparing the short videos for you website,

has suggested that you work together to prepare a detailed list of resources available to

help prepare scripts and edit the videos they will create. You decide to use animations

instead of real people in the videos, and Angela’s company has a lot of experience in that

area. Together, you decide that you will need someone to take on the roles of script writers, 

script editors, animators, sound experts, content editors, and technical editors. Angela and

her team will do all of the animating, sound, and technical work and will provide guidance

for you and your team to do the other work. To keep costs down and stay on schedule, you

decide to plan for all of the video work to be done in 20 days, using no more than 240 total

hours of effort, with about half of the effort from Angela’s company. Prepare a resource

histogram to estimate the number of hours by role for each of the 20 days. Document key

assumptions you make in preparing the histogram.

Chapter 10 – Read the Running Case.
Each team member will complete tasks 1 and 2 only for this case project and submit individually here. 

Chapter 10 – Read the Running Case:

Several issues have arisen on the Global Treps Project. Ashok, your team member in India,

broke his wrist playing tennis yesterday and cannot work on the project at all for three weeks.

His work, which involves helping to edit the videos, starts in one week, so you need to

reassign it to others.

Bobby suggests you use kanban boards to list all of the tasks for editing the videos and to

track where they are in the work flow. Bobby, a techie and not known for being a good communicator,

is the only person who’s ever used kanban boards. You have not yet broken down the tasks

into much detail and need more information from Angela, the contractor in charge of creating the

videos.

Alfreda is having difficulties communicating with her main contact in Ethiopia, Dr. B.

He is very busy all the time and does not use texting, Alfreda’s preferred communications

medium. He has also not communicated key information with students who could be

candidates for their event, which is only a month away. Alfreda is not sure if he booked a

room for the event yet.

Task-1. Describe how you would communicate to Ashok and the rest of the team about Ashok’s

injury. What actions would you take? What communications medium would you use with

different stakeholders?

Task-2. Prepare a partial communications management plan to address some of the challenges

mentioned in Part 7 of the case.

***I attached text book for reference. Question is from Chapter-9 & Chapter-10*****

#Exp19_Access_Ch01_CapAssessment – Latte Delights Inventory 1.0

#Exp19 Access Ch01 CapAssessment Latte Delights Inventory 1.0

#EX19_AC_CH01_GRADER_CAP_AS

#Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory 

#Access Chapter 1 Capstone Assessment – Latte Delights Inventory 

Project Description:

In this project, you will open a database containing the inventory of a coffee shop, create a new table in which to store sales representatives (reps) information, and then add the sales rep records. You add a new product using a form and print a report. You apply a filter by selection and sort a query, and then you apply a filter by form to a table. You save both filters.

Start   Access. Open the downloaded Access file named Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb. Grader has automatically added your   last name to the beginning of the filename.

Add   the following records to the Sales Reps table, letting Access assign the   SalesRepID:

LastName

FirstName

Address

City

State

ZIP

Eissler

Karean

13 Oak Lane

Montgomery

PA

17752

Rai

Namrata

1000 Ogden Blvd

New Castle

DE

19720

Pellum

Katryn

286 Bergen Rd

Salford

PA

18957

Close   the table.

Open   the Customers form in Form view. Use Search to locate the record for Baker Auto Supply. Modify the record so that the   Address1 field displays 4508 N.W. 7 Avenue.   Save and close the form.

Open   the Products form in Form view. Add a new product (Access will automatically   add the Product ID): Coffee-Arabica Premium.   The Description is 24/Case, Pre-Ground   1.75 Oz Bags, the Cost is $13 (just type 13, no $), the Markup   Percent is 100%,   the Brand is Premium,   and the Year Introduced is 2017.   Save the new record and close the form.

Open   the Products report and check that the report contains the new product P0026,   Coffee-Arabica Premium. View the layout of the report in Print Preview and then   change the page layout to Landscape. Save the report and close Print Preview.

Open   the Customers table. Sort the table by Customer Name in ascending order. Save   the changes and close the table.

Open   the Revenue Stats query and sort the City field in ascending order. Apply   Filter by Selection to display only stats for which the LastName field Equals   “Pellum”. Save and close the filtered query.

Open   the Products table. Use Filter by Form to create a filter that will identify   all premium brands in the Brand field that were introduced after 2017. Apply the filter and preview the   filtered table. Close the table and save the changes.

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.