{Visual}: (An animated red line weaves it’s way through a series of images of houses and apartment building exteriors that appear one after the other on screen. The red line ends up forming the CMHC logo, alone on screen on a white background.)
{Visual}: (Computer screen with Housing in Canada Online landing page on CMHC website. Screen zooms in toward upper left corner of page.)
Welcome to CMHC’s Housing in Canada Online Quick Start Video. Housing in Canada Online, also called "HiCO", is an interactive web-based tool that allows you to create your own tables using a selection of housing conditions data. Today we are going to look at how to get started.
{On-Screen Text}: (Average Shelter Costs for Senior Households in Core Housing Need Living in the City of Stratford)
As an example, we are going to make a table that shows the average shelter cost for senior households in core housing need living in the City of Stratford.
{Visual}: (Computer screen with Housing in Canada Online landing page on CMHC website. Cursor moves to Launch Data Table link on right side of screen.)
Let’s launch HiCO.
{Visual}: (Computer screen changes to Housing in Canada Online Data Table.)
You will see that there is a lot of information. HiCO is a powerful tool that allows you to arrange the data to suit your needs. To make our table, we will need to rearrange the data.
{Visual}: (Cursor moves to top left corner of screen directly below the Reports tab and clicks on the “Select Items to View” icon.)
First, let’s click on the “select items to view” icon below the Report Tab at the top left.
{Visual}: (A dropdown list appears. The cursor clicks on the word “Geography” at the top of the list.)
From the dropdown list we select “Geography”.
{Visual}: (A large white box with a list of locations appears on screen. The cursor clicks on the “x” in the box diagonally opposite the word “Canada”. )
We can deselect all of the geographies by clicking on the “Clear all — x" diagonally opposite Canada.
{Visual}: (The cursor moves directly upwards to the white rectangular box left of the blue Search button. The cursor clicks in the box and then types the word “Stratford” then moves to the Search button to the right and clicks on Search.)
Move the mouse up to the text field to the left of the Search button and type in Stratford. Click on the Search button.
{Visual}: (The cursor moves directly upwards to the rectangular text field left of the blue Search button. The cursor clicks in the field and then types the word “Stratford”, then moves to the Search button to the right and clicks on Search.)
The name Stratford appears below, beside a blank checkbox.
{Visual}: (The cursor moves to the blank checkbox and clicks in it.)
Check the checkbox to select it. We can add additional geographies by repeating this process.
{Visual}: (The cursor moves up to the “Show Table” button at the top of the page.)
Click on Show Table. This will show data for Stratford only.
{Visual}: (A data table for Stratford appears onscreen.)
Next, let’s replace the column header titled “Year” with a tab from above called “Age”.
{Visual}: (The cursor moves to point directly under the YEAR column, which is the second gold column. Then it moves directly up and slightly to the right to the white rectangular box that starts with AGE. The cursor clicks and holds in the white area of the box.)
We move the mouse to Age and only on the white area in the box click and hold. We can see that the Age tab shrinks and becomes yellow.
{Visual}: (The AGE tab shrinks and becomes a yellow box. With the mouse key still being held down, the cursor drags the yellow AGE box completely over the YEAR box below. The YEAR box turns completely yellow. The mouse key is released and the software swaps out the data.)
Drag the yellow box over the “Year” column header and when it appears completely yellow, release the mouse button.
{Visual}: (The cursor moves diagonally upwards to the left icon under the tab Reports and clicks on the dropdown box, then selects Age from the list that appears.)
Next, let's return to the “select items to view” icon under the Reports tab and this time, let's select “Age”.
{Visual}: (The cursor moves diagonally down and to the right to the X in the blue area and clicks to deselect the options. All options will show as deselected. The cursor moves down and to the right to select Senior Households and clicks on the white box to the left of Senior Households. The cursor then moves to the SHOW TABLE button at the top of the screen and clicks on it.)
We deselect all and then select only Senior Households. It is important that we ensure that the subcategories under non-senior households are also deselected. Click on Show Table.
{Visual}: (The cursor moves diagonally upwards to the left icon under the tab Reports and clicks on dropdown box, then selects Year. The cursor moves diagonally to the right and deselects all years and then selects only 2011. The cursor again moves to the SHOW TABLE button at the top of the screen and clicks on it.)
Let's set the year to 2011 like this. Click on Show Table.
Finally let’s replace the Aboriginal Households tab with Core Housing Need.
{Visual}: (The cursor moves to the white Core Housing Need (Cor) tab above the blue boxes and clicks and holds on the white area of the Cor Box to make it change to yellow.)
We click and hold on the white “Core Housing Need” tab to make it turn yellow. Depending on the width of your screen this title may show up in a shorter form such as "Cor".
{Visual}: (The cursor drags the box down between the blue Aboriginal Households and Household Data boxes to show a yellow line. Then continues dragging the box down and to the right between Age and Household count. A vertical yellow line appears. The cursor then drags the box back up to Aboriginal Households which turns all yellow and the mouse is released.)
Then we drag and drop the tab on Aboriginal Households. Note we can also make this an extra row by moving the box to find a horizontal yellow line or, if we prefer to make it a column, we would move the yellow box between columns until a yellow vertical line appears. For now we will simply replace Aboriginal Households.
{Visual}: (The cursor moves to point to the Senior Households box. It then moves to the left to show the yellow Stratford box, then up to the blue Core Housing Need box and continues right to the Household in the Core Housing Need box. The cursor then moves directly below to the blue Average Shelter Cost and points to $797.)
Now we can look at our table to see that Senior Households living in Stratford who are in core housing need, pay on average $797 per month on shelter costs.
As you explore this tool further, you will see that there are a variety of ways you can display your information.
{Visual}: (Screen transitions back to Housing Information in Canada Online landing page on CMHC website. Screen zooms in toward list of links on right side of page.)
To learn more, consult the “Getting Started with HiCO" page as well as the tutorials.
{On-Screen Text}: (observer@cmhc.ca)
For questions or technical help please contact us at observer@cmhc.ca.
{Visual}: (CMHC logo.)
{Visual}: (Canada wordmark.)
