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's open 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.

Part 2 - Word

Your report will contain.

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 a title page(Using Word function) for your report (include your new logo)

Create a report page which includes these three elements:

An introductory 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 a marketing 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 page using the Word function in APA style on the last page.

Part 3 - PowerPoint

Prepare a PowerPoint presentation 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

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.