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...

1 answer below »



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 (150-200 words) 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



Answered Same DayDec 04, 2022

Answer To: Part 1 - ExcelYour supervisor has asked you to research demand and profitability indicators to...

Mohd answered on Dec 05 2022
5 Votes
Sheet6
    Permit type    Count of Permit Group
    Non-Residential    12
    CRESTVIEW    3
    ELMHURST    3
    MINTO    3
    POLO PARK    3
    Res
idential    9
    CRESTVIEW    3
    ELMHURST    3
    MINTO    3
    Grand Total    21
Total    
CRESTVIEW    ELMHURST    MINTO    POLO PARK    CRESTVIEW    ELMHURST    MINTO    Non-Residential    Residential    3    3    3    3    3    3    3    
Sheet7
    Row Labels    Sum of Total Declared Construction Value
    2020    57146575
    Non-Residential    51666381
    Residential    5480194
    2021    16717597
    Non-Residential    13153997
    Residential    3563600
    2022    19673665
    Non-Residential    16044652
    Residential    3629013
    Grand Total    93537837
Total Declared Construction Value
by year and permit type
Total    Non-Residential    Residential    Non-Residential    Residential    Non-Residential    Residential    2020    2021    2022    51666381    5480194    13153997    3563600    16044652    3629013    
Total Value
Aggregate_building_permit
    Ward    Neighbourhood    Neighbourhood Id    Total Declared Construction Value    Year    Permit Group    Total Permits    Location    Point
    St. James    POLO PARK    2.125    12189589    2022    Non-Residential    63    (49.88711729343024, -97.19972521357494)    POINT (-97.199725213575 49.88711729343)
    Daniel McIntyre    MINTO    1.115    983598    2022    Non-Residential    19    (49.88791836327802, -97.1820918652862)    POINT...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here