You are currently employed by the Government of Ontario and your job is to promote this Province to International investors to bring jobs and money to Ontario. Recently Ontario has, specifically in the GTA (greater Toronto Area), grown significantly in the Information Technology sector and over the years real estate has also grown. To show the investors you understand Ontario you need to do some background research. The chart provided is part of Ontario’s growth with employment and population projections. Part of the research involves the following:

THE FOLLOWING MUST BE COMPLETED IN A REPORT FORM.

Choose a region in the GTA and calculate the indexes of growth for 2021-2041 with base year 2016. Complete this for Population and employment (Complete this by hand writing the calculations).

2021

2026

2031

2036

2041

Choose a different region and calculate the percent changes for 2021- 2041 for Population and Employment with base year 2016. (Complete this by hand writing the calculations)

2021

2026

2031

2036

2041

Select GTAH total and make a scatter plot with the use of Excel/Sheets. Copy the table to Desmos and create a regression analysis. Make a line of best fit, State the slope, y-intercept, equation and r values. (Print screen and paste your results in the assignment).

Is there a strong relationship between the two variables? Explain?

What trends do you notice (write 250 words)?

Can this information be used attract investors? How would you use this data to promote the GTA and Hamilton?

Line of Best fit Equation _____________________

Slope ____________________

Y-intercept _______________

R value ______________

Would it be effective to create a survey for the investors? What kind of survey would your create? What are ways in which you can make the survey effective. Make an effective survey containing 5 questions with a variety of methods (True/false, Multiple choice, open ended etc.)

Given that your project was a success and you manage to secure a few of this international companies what would the year 2031 employment for the Greater Golden Horseshoe (GGH) look like with a 20% increased projection of employment. How many more jobs did you create? How many jobs are there now in total for 2031?

Conduct research to determine how data management is used in other careers.

List three additional careers that require knowledge and use of data management.

How would another province like British Columbia use this to increase their employment and job prospects.

Check-Bric

Knowledge & Understanding

All of the calculations are clearly and properly stated based on the 2016 base year

● 1 mark per question

Each question has a solution with the correct answer

● 1 mark per solution

Calculating a 20% increase with

● Calculations clearly stated 4 marks

o Increase in jobs 2 mark

o Total jobs 2 mark

□□□□□

□□□□□

□□

□□

/14

Application

Scatter plot

● 1 mark for slope of line

● 1 mark for y intercept

● 1 mark for r value

● 1 mark for equation

Relationship of variable

● R value discussed 1 mark

● Explanation of r value and where it falls in strength 2 marks

Trends Stated and properly explained

● Stated a max value 1 mark

● Stated a min value 1 mark

● Explained what is happening over time (increase/decrease) 2 marks

● Extrapolating future numbers 1 mark

Survey Made and properly explained based on lessons from the unit.

● Effective survey strategy 2 marks per question

● Effective Multiple choice question in survey 1 mark

● Effective True/false question in survey 1 mark

● Effective Multiple choice or True/false 1 mark

● Effective Multiple choice or True/false 1 mark

● Effective Open ended question 1 mark

□

□

□

□

□

□□

□

□

□□

□

□□□□□

□□□□□

□

□

□

□

□

/27

Communication

The worksheet with solutions is visually appealing and easy to follow, illustrations are included

● -0.5 marks per mistake

Title page is included

□□□□□

□

/6

Thinking & Inquiry

How Data management is used in other careers properly explained

● Career 1 -2 marks

● Career 2 -2 marks

● Career 3 – 2 marks

Use of this information and how it applies to other provinces elaborated

● Thesis/argument- 1 mark

● Example 1 – 2 marks

● Example 2 – 2 marks

● Conclusion – 1 mark

□□

□□

□□

□

□□

□□

□

/12

Total

/59