Complete the “Forensic Design Assessment” exercise located at:Data Representation 

• On this page, click the “Exercise” tab

• Complete: (1) Forensic Design Assessments exercise, then

• Click the “Write Submission” link below to paste your results.

• After pasting your results (when finished), remember to click Submit

APA Style Formatting

DATA REPRESENTATION

(1). FORENSIC DESIGN ASSESSMENTS

This task relates to a sequence of assessments that will be repeated across Chapters 6, 7, 8, 9 and 10. Select any example of a visualisation or infographic, maybe your own work or that of others. The task is to undertake a deep, detailed ‘forensic’ like assessment of the design choices made across each of the five layers of the chosen visualisation’s anatomy. In each case your assessment is only concerned with one design layer at a time.

For this task, take a close look at the data representation choices:

1. Start by identifying all the charts and their types

2. How suitable do you think the chart type choice(s) are to display the data? If they are not, what do you think they should have been?

3. Are the marks and, especially, the attributes appropriately assigned and accurately portrayed?

4. Go through the set of ‘Influencing factors’ from the latter section of the book’s chapter to help shape your assessment and to possibly inform how you might tackle this design layer differently

5. Are there any data values/statistics presented in table/raw form that maybe could have benefited from a more visual representation?

Context: 

The assessment of this subject supports students in developing their skills and knowledge in topics that include environmental assessment, problem diagnosis, strategy development, and cultural and ethical contexts. Stakeholder meetings are a critical element in strategic management. This assessment task provides experience and immersive understanding of the complex interactions involved in the development of strategic choices, and the need to take an integrative approach to problem solving. The increasing pace of technological change and the increased impact of social media provides many challenges for businesses attempting to navigate towards growth and increased profitability. Rapid cycle times for new products can lead to decisions being made that are not always in the best interests of the long-term survival of the firm. Disruptions to the everyday course of business come from anywhere and need to be responded to often in short time frames. 

Introduction 

Assessment 2 Part B continues from the scenario in Part A. In Part B, a disruption is introduced which necessitates re-consideration of the white paper done in Part A of the Assessment. Here is a recap of the scenario. 

Scenario Recap 

Pro-Go Pty Ltd is a privately-owned manufacturer of small, high-quality action cameras based in Geelong, Victoria. Founded in 2004 it has enjoyed continuous year-on-year growth until the last 

Page 1 of 7 MGT604 Assessment 2B Brief – this brief supersedes all previous MGT604 Assessment 2 Part B briefs 

financial year. Pro-Go has a track record of innovation, and technology that provides excellent quality results in a small package able to operate with small batteries for extended periods of time. The video files these cameras produce are known for having superior colour, and operate effectively in lower lighting conditions than competitor’s cameras. They are also marketed on the basis of their extreme ruggedness, and reliability. Much of the technology used in its devices has been patented by Pro-Go and is not currently available to other manufacturers. 

The Pro-Go management team has recognised that the ability to capture videos is now a feature of most phones. It suggests to them that the future of the stand-alone camera may be limited. Pro-Go’s CEO has requested the executive team meet independently to develop a strategy to guide the company over the next five years. 

Instructions: 

The COVID19 pandemic has presented a substantial disruption and challenge to companies and communities around the world. In an environment being shaped by self-isolation lockdowns and social distancing, Pro-Go has identified an opportunity to work with a technology partner/integrator to address a pressing community need. 

The COVIDSafe app uses Bluetooth enabled smart phones to identify when a user is near another COVIDSafe user and records close contact between these users. This allows State and Territory health officials to contact any user if they have been in contact with someone who has tested positive for the virus. Leveraging the COVIDSafe technology, Pro-Go’s state-of-the-art cameras together with an innovative software solution, Pro-Go has identified an opportunity for custom-built Pro-Go camera units to be fitted to dashboards of National Police Force vehicles to enable real-time tracking and mapping of hot spots throughout the community where COVID19 is present. 

Page 2 of 7 MGT604 Assessment 2B Brief – this brief supersedes all previous MGT604 Assessment 2 Part B briefs 

The Pro-Go management team has tasked the team to develop a modified strategic plan/white paper that will articulate the way forward to provide an effective solution to this emerging community need. It is expected that Pro-Go will go out to market via a competitive tender arrangement to find suitable strategic partners to develop and market the new solution. 

In the same way that other specialty camera companies have forged partnerships with car manufacturers, technology companies and end-to-end service providers like DXC Technology to deliver next-generation technology solutions, the Pro-Go management team envision a new direction for the company through strategic partnerships that will drive innovation and create a lasting legacy for the community (Statt, 2016). 

Re-convene the (emergency) stakeholder meetings to address the disruption scenario and associated concerns. The stakeholder meetings must discuss this disruption and develop a modified strategic plan/white paper. Please return to your groups immediately to discuss these events and adjust your strategic approach accordingly. 

Suggested format 

Your 2000 word, individual, White paper should be structured as follows: 

• Executive Summary – Summarise the entire report – for example, don’t tell the reader that the report discusses the external/internal environment, summarise the points the report makes about the external/internal environment.
   
• Table of Contents – Make it look good. Include page numbers and ensure the layout looks balanced on the page.
   
• Introduction – Provide background and context to the report. Tell the reader what has happened in the past that has led to this report being needed.
   
• Aim – State in a single sentence what this report is seeking to achieve.
   
• Discussion – Cover the content you wish to address.
   
• Conclusion – Restate the aim and sum up the discussion to demonstrate to the reader that the aim has been satisfied. There should be no new content in the conclusion.
   
• Recommendations – What are the next steps? What is required to progress into the future? Evaluate/justify your recommendations?
   
• References – Please ensure you use the correct APA referencing style throughout. Remember EVERY factual statement requires a reference.
   
• Appendices – Additional material to substantiate or add greater depth to the material presented in the report, and your Teamwork log.
  The white paper is to be completed individually by each member of the team reflecting the impact of the proposed strategy on their particular part of the business after the disruption and should be completed to the professional standard that would be required if the below scenario were real. Below is a recap of the scenario and the requirements of the Five-year strategy white Paper which was outlined in Assessment 2 Part A.
  Deliverables
  The stakeholder meeting will discuss and agree on three strategy options for Pro-Go. In doing so,
  the Stakeholder meeting may consider strategy options that exist in adjacent markets or with
  Page 3 of 7 MGT604 Assessment 2B Brief – this brief supersedes all previous MGT604 Assessment 2 Part B briefs
   

related but different products or technologies. Remember to apply strategy concepts in your stakeholder meeting discussions to identify strategy options (strategy planning). 

The deliverables required of each student are to produce a white paper covering the following: 

1. Nominate the preferred strategy option and apply a strategy framework(s) to analyse and justify why you believe it is the best strategy option; and
    
2. Discuss the implications specifically relating to your part of the business, and what challenges these might represent. Separate the discussion into short-term and long-term issues.
    

Students are to address the assessment task from the perspective of their own functional area of responsibility. Integrate theory in your white paper. 

Shelly      Cashman Excel 2019 | Modules 1-3: SAM Capstone Project 1a

                    Ensight Healthcare Consultants

CREATE FORMULAS WITH FUNCTIONS 

GETTING STARTED

· Open the file SC_EX19_CS1-3a_FirstLastName_1.xlsx, available for download from the SAM website.

· Save the file as SC_EX19_CS1-3a_FirstLastName_2.xlsx by changing the “1” to a “2”.

o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

· With the file SC_EX19_CS1-3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

1. Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around the world. Carla has created a workbook summarizing the status of the consulting project for Everett Hospital. She asks for your help in completing the workbook.
 

Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.

2. In cell J1, enter a formula using the NOW function to display today’s date. Apply the Short Date number format to display only the date in the cell.

3. Format the worksheet title as follows to use a consistent design throughout the workbook:

a. Fill cell B2 with the Dark Red, Accent 6, Lighter 40% shading color.

b. Change the font color to White, Background 1.

c. Merge and center the contents of cell B2 across the range B2:H2.

d. Use AutoFit to resize row 2 to its best fit.

4. Format the billing rate data as follows to suit the design of the worksheet and make the data easier to understand:

a. Italicize the contents of cell I2 to match the formatting in cell I1.

b. Apply the Currency number format to cell J2 to clarify that it contains a dollar amount. 

5. Format the data in cell A4 as follows to display all of the text:

a. Merge the cells in the range A4:A13.

b. Rotate the text up in the merged cell so that the text reads from bottom to top.

c. Middle-align and center the text.

d. Remove the border from the merged cell.

e. Resize column A to a width of 4.00.

6. Format the data in row 4 as follows to show that it contains column headings:

a. Change “Description” to use Service Description as the complete column heading.

b. Apply the Accent 6 cell style to the range B4:H4.

c. Use AutoFit to resize column D to its best fit.

7. Carla wants to include the actual dollar amount of the services performed in column E. Enter this information as follows:

a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell J2) to determine the actual dollar amount charged for general administrative services. Include an absolute reference to cell J2 in the formula.

b. Use the Fill Handle to fill the range E6:E13 with the formula in cell E5 to include the charges for the other services.

c. Format the range E6:E13 using the Comma number format and no decimal places to match the formatting in column F.

8. Carla needs to show how much of the estimate remains after the services performed. Provide this information as follows:

a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.

b. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services.

c. Format the range G6:G13 using the Comma number format and no decimal places to match the formatting in column F.

9. Carla also wants to show the remaining amount as a percentage of the actual amount. Enter this information as follows:

a. In cell H5, enter a formula that divides the remaining dollar amount (cell G5) by the estimated dollar amount (cell F5).

b. Copy the formula in cell H5 to the range H6:H14, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total.

10. Calculate the project status totals as follows:

a. In cell D14, enter a formula using the SUM function to total the actual hours (range D5:D13).

b. Use the Fill Handle to fill the range E14:G14 with the formula in cell D14.

c. Apply the Accounting number format with no decimal places to the range E14:G14.

11. Carla also wants to identify the services for which Ensight has billed more than the full estimate amount.
 

In the range H5:H13, use Conditional Formatting Highlight Cells Rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text. 

12. Carla imported data about the consultants working on the Everett Hospital project and stored the data on a separate worksheet, but wants to include the data in the Project Status worksheet.
 

Copy and paste the data as follows:

a. Go to the Consultants worksheet and copy the data in the range B2:G12.

b. Return to the Project Status worksheet. Paste the data in cell J3, keeping the source formatting when you paste it.

13. Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows:

a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to 4.

b. If the consultant has four or more years of experience, display “Lead” in cell N5.

c. If the consultant has less than four years of experience, display “Associate” in cell N5.

d. Copy the formula in cell N5 to the range N6:N13, pasting the formula only.

e. Use AutoFit to resize column N to its best fit.

14. Carla wants to include summary statistics about the project and the consultants. Include this information as follows:
In cell D16, enter a formula that uses the AVERAGE function to average the number of years of experience (range M5:M13).

15. Make the 3-D Clustered Column chart in the range B17:H31 easier to interpret as follows:

a. Change the chart type to a Clustered Bar chart.

b. Use Actual Project Hours as the chart title.

c. Add a primary horizontal axis title to the chart, using Hours as the axis title text.

d. Add data labels in the center of each bar.

16. Delete row 33 since Carla has reformatted the clustered column chart.

17. Go to the Schedule worksheet. Rename the Schedule worksheet tab to Project Schedule to use a more descriptive name.

18. Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining services as follows:

a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell C6.

b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6.

c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6.

d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6.

19. Copy the formulas in Phase 2 to the rest of the schedule as follows:

a. Copy the formula in cell D6 to the range D7:D9.

b. Copy the formula in cell E6 to the range E7:E9.

c. Copy the formula in cell F6 to the range F7:F9.

d. Copy the formula in cell G6 to the range G7:G9.

20. In cell C11, enter a formula that uses the MIN function to find the earliest date in the project schedule (range C6:G9).

21. In cell C12, enter a formula that uses the MAX function to find the latest date in the project schedule (range C6:G9).

Your workbook should look like the Final Figures on the following pages. The value in cell J1 has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. 

Final Figure 1: Project Status Worksheet

Final Figure 2: Project Schedule Worksheet

 Primary Task Response: Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

Discuss the following for this post:

• What was your most significant learning in this course?
• How did participating in discussions help your understanding of the subject matter? Is anything still unclear that could be clarified?

 3 Page Minimum

Please Organize in the following sections listed below under the bold outline in the  2nd paragraph 

IN THE LINKS PROVIDED ARE SOME TOPICS THAT CAN BE USED IN MY FIELD OF STUDY WHICH IS DIT PLEASE SELECT SOMETHING FROM IT !!!

INCLUDE A MINIMUM OF 10 CURRENT SCHOLARLY OR PROFESSIONAL RESOURCES!!!!

• Analyze existing project risk management literature.
• Provide context for an analysis of information project risk management mechanisms for an organization.
• Identify a research problem in project risk management.
• Summarize the purpose and scope of the research project, methods used, and questions addressed.
• Identify key constructs and/or a theoretical foundation, as well as key relationships among the constructs.
• Describe the target population.
• Describe the participants’ eligibility criteria.
• Explain ethical considerations such as participants’ right to privacy, informed consent, and protection from harm. 
• Identify gaps in knowledge in the literature (PhD) or gaps in practice (DIT).
• Cite any scholarly or professional resources used.

Organize your topic definition statement into the following sections!!

• Research Topic.
  • Analysis of Existing Project Management Literature.
  • Research Problem Background.
• Research Problem Statement.
• Purpose and Scope.
• Research Question.
• Methods (i.e., generic qualitative inquiry or quantitative regression).
• Theoretical Foundation.
• Target Population.
  • Eligibility Criteria.
  • Ethical Considerations.
• Gaps in the Literature (PhD) or Gaps in Practice (DIT).