This course is data-intensive. You will be downloading, manipulating, and analysing datasets with many thousands of observations. As a result, you need to be proficient in the use of software programs such as Microsoft Excel and basic statistics. We provide below a list of the minimum assumed knowledge to allow you to get the most out of the course. If you are not comfortable with these topics, please spend some time working through the online tutorials we have outlined below.
Sort and Filter Data: https://support.office.microsoft.com/en-au/article/Watch-onlineffb9fcb0-b9cb-48bf-a15c-8bec9fd3a472
Doing Calculations and writing formulas in Excel: https://support.microsoft.com/en-us/office/create-a-simple-formula-in-excel-11a5f0e5-38a3-4115-85bc-f4a465f64a8a
Averaging Data: https://support.office.microsoft.com/en-au/article/Watch-online-6cced0be-ca49-41c8-a3f2-cb89e566ab90
Plotting in Excel: https://support.office.microsoft.com/en-au/article/Watch-online-4d95c6a5-42d2-4cfc-aede-0ebf01d409a8
Pivot Tables: https://support.office.microsoft.com/en-au/article/Watch-online-7810597d-0837-41f7-9699-5911aa282760
Descriptive statistics - In particular, understanding the mean, standard deviation, standard error and the normal distribution. Many videos can be found here: https://www.khanacademy.org/math/probability/descriptive-statistics