Video tutorials for students

CamcorderEasy, short guides for the busy student!

So you have to do a data project! A step-by-step student guide to finding data

Icon of the video Tutorial 1: Choosing a topicTutorial 1: Choosing a topic (4:38 min.)
Discover resources for data projects from the Statistics Canada Students page.

Icon of the video Tutorial 2: Searching for data using Browse by subjectTutorial 2: Searching for data using Browse by subject (5:01 min.)
Start broad by choosing the subject, then select subtopics to narrow down your search. Find articles, Summary tables and detailed CANSIM tables related to your subject.

Icon of the video Tutorial 3: Searching for data using The DailyTutorial 3: Searching for data using The Daily (5:24 min.)
Use Search by topic within The Daily to see articles that have been written about your topic by Statistics Canada. You will find data links at the end of each article.

Icon of the video Tutorial 4: Searching for CANSIM data in E-STATTutorial 4: Searching for CANSIM data in E-STAT (5:40 min.)
Search for CANSIM data in E-STAT using the Table of contents, or search by topic or table number. CANSIM data comes from over 250 on-going surveys in Canada.

Icon of the video Tutorial 5: Searching for census data in E-STATTutorial 5: Searching for census data in E-STAT (7:50 min.)
E-STAT will let you search from more than 400 years of Census data, from the most recent Canadian census back to 1665. You can look at characteristics like the age of marriage, occupations, languages spoken and the gender balance in the population.

Icon of the video Tutorial 6: Creating tables and graphs in E-STATTutorial 6: Creating tables and graphs in E-STAT (9:51 min.)
Use E-STAT to create tables or graphs which you can copy and paste into your project.

Icon of the video Tutorial 7: Downloading data from E-STAT into software programsTutorial 7: Downloading data from E-STAT into software programs (9:14 min.)
Download data from E-Stat into other programs to analyse it, create graphs and find trends.

Using spreadsheet and dynamic data analysis software

Watch our videos on Facebook: an experienced teacher will guide you through each topic below.

Link to Video on Facebook for Episode 7.Episode 7 (9:22 min.) — Excel basics — Importing the data and editing the spreadsheet (transcript)

Link to Video on Facebook for Episode 8.Episode 8 (8:03 min.) — Using Excel to create bar graphs and circle graphs (transcript)

Link to Video on Facebook for Episode 9.Episode 9 (5:11 min.) — Using Excel to create scatter plots (transcript)

Link to Video on Facebook for Episode 10.Episode 10 (9:36 min.) — Graphing in Excel using pivot charts (transcript)

Link to Video on Facebook for Episode 11.Episode 11 (3:22 min.) — Using formulas in Excel to find the Mean, Median and Mode (transcript)

Link to Video on Facebook for Episode 12.Episode 12 (5:47 min.) — Importing the class results with TinkerPlots (transcript)

Link to Video on Facebook for Episode 13.Episode 13 (10:56 min.) — Analysing the class results with TinkerPlots (transcript)

Link to Video on Facebook for Episode 14.Episode 14 (6:10 min.) — Getting a random sample from the international site (transcript)

Link to Video on Facebook for Episode 15.Episode 15 (2:23 min.) — Importing an international random dataset into Fathom (transcript)

Link to Video on Facebook for Episode 16.Episode 16 (10:55 min.) — Analysing an international random dataset in Fathom (transcript)