Part 1 - ExcelYour supervisor has asked you to research demand and profitability indicators to decide if this idea is worth considering. Is it more profitable to remain in non-residential...

Part 1 - Excel

Your supervisor has asked you to research demand and profitability indicators to decide if this idea is worth considering. Is it more profitable to remain in non-residential construction, or are there missed opportunities in residential construction?

Using the City of Winnipeg'sopen data website(use aggregate data), you will compare the frequency (#) and total value ($) of residential construction permits vs non-residential permits that have been issued in the following neighborhoods between the years 2020 to 2022:

• Crestview


• Elmhurst


• Minto


• Polo Park

Transfer the relevant data into an Excel spreadsheet, and ensure you:

• Download the raw data into a separate worksheet and use your name_raw in the label


• Sort the relevant data using a structured table and format it into a table of your choice.


• Use accounting format with zero decimal places.


• Create properly formatted title and table elements on a separate worksheet with your name_table in the label.


• Insert at least one mathematical/statistical function(s) into the spreadsheet.


• Create a chart or graph of your choice to help visualize your information on a separate worksheet with your name_graph in the label.


• Save as: Firstname_Lastname_Project.xlsx

Part 2 - Word

Your report will contain a total of 5 pages (title page, report pages (2 pages), flyer page, bibliography page).

Report layout:

• 12-point Calibri font, double spaced in Portrait orientation.


• Insert a left footer displaying your name (FirstName LastName) on all pages except on title page and flyer page.


• Insert a right footer (on the same line and left footer) displaying page numbers on all pages except the title page and flyer page.


• Apply narrow margins

Report content:

• Create a logo for Claw Construction to use throughout your document
  
  
  • Use Office 365 to create a logo of your own design
  
  
  
  


• Create atitle page(Using Word function) for your report (include your new logo)


• Create areport pagewhich includes these three elements:
  
  
  • An introductory paragraph XXXXXXXXXXwords) describing the problem you are trying to solve, and a summary of your research citing one at least one reference (using the reference function in APA)
  
  
  • One table and one chart from your Excel file
  
  
  • Conclusion paragraph with your recommendation(s)
  
  
  
  


• Create amarketing flyer(include your new logo) that targets residential construction using at least four layout/design techniques found inWord Module 4: Enhancing Page Layout and Designon a separate page in Landscape (for this page only) and no footer.


• Create abibliography pageusing the Word function in APA style on the last page.
  
  
  
  


• Save as: Firstname_Lastname_Project.docx

Part 3 - PowerPoint

• Prepare a PowerPoint presentation (no more than 5 slides) to help explain your findings to your supervisor


• Slides should contain a footer with the students name (except on the title slide)


• Title slide contains logo and student name


• Introduction slide to use bullets list of your choosing


• Data slides from Word/Excel


• Conclusion/Recommendation slide to include student name in Notes section.


• Use animation/transitions of your choice


• Title fonts to be 36-44 point, body fonts 28-32 points


• Ensure background contrasts with text/images


• Narrate and record your presentation (no more than 5 minutes) using the Record Slide Show feature in PowerPoint to create a self-running presentation.


• Save As: Firstname_Lastname_Project.pptx