# Video tutorials for students

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

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