Video tutorials for students

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

NOTE: These videos were prepared when the Census at School Canada Project was managed by Statistics Canada. Apart from references to navigation on the former website, most of the information is still relevant.

Using spreadsheet and dynamic data analysis software

Episode 7: Excel basics: Importing the data and editing the spreadsheet
9:23 min.

This episode focuses on importing your Census at School class dataset with the spreadsheet program Microsoft Excel and editing it for classroom use.

Episode 8: Using Excel to create bar graphs and circle graphs
8:04 min.

This episode will cover creating basic graphs like bar graphs and circle graphs in Microsoft Excel using a frequency table.

Episode 9: Using Excel to create scatter plots
5:12 min.

This episode will cover creating scatter plots in Microsoft Excel.

Episode 10: Graphing in Excel using pivot charts
9:37 min.

This episode will demonstrate how to graph data in Excel with just a few quick steps, using the Pivot Chart function.

Episode 11: Using formulas in Excel to find the Mean, Median and Mode
3:23 min.

This episode will show you how to use spreadsheet formulas to find the three measures of central tendency: mean, median and mode.

Episode 12: Importing the class results with TinkerPlots
5:48 min.

In this episode, I'll show you how to import your Census at School data into TinkerPlots.

Episode 13: Using the class results with TinkerPlots
10:57 min.

In this episode, we'll look at how to use TinkerPlots to create various sorts of graphs and find the mean, median and mode.

Episode 14: Getting a random sample from the international site
6:11 min.

This episode will demonstrate how to obtain a random dataset using the International Census at School random data selector.

Episode 15: Importing an international random dataset into Fathom
2:24 min.

In this episode, I'll show you how to import a download of international Census at School data into Fathom.

Episode 16: Using an international random dataset in Fathom
10:56 min.

In this episode, we will look at how to use the statistical program Fathom, to analyse a dataset taken from the International Census at School database.