Data Analysis using Spreadsheets

* Home
* Description
* Overview
* **Syllabus**
* Resources *

* Modules
* Projects
* Grades
* Discussion *

**STAIR and data analysis**: Using the STAIR technique to solve data analysis problems, problem analysis, problem solving methods.**Spreadsheets and data analysis**: using spreadsheets to store and analyse data, various data manipulation methods using spereadsheets, advanced spreadsheet capabilities. Charting, scatter plots, histograms.**Descriptive Statistics**: Measures of central tendency (mean, median, mode), measures of dispersion (range, variance, standard deviation, skewness).**Relationship between data**: Correlation, Pearson's correlation coefficient.**Trends**: Regression analysis, trend lines, linear and quadratic curve fitting, interpolation and extrapolation.

*Jan 12*: Overview of course, initial student feedback, introduction to data analysis.

**Readings**: CSCI A113 web site, firstclass brochures, Excel manuals.

*Jan 14*: Introduction to data analysis (cont). STAIR technique, using STAIR to solve data analysis problems.

**Readings**: Text Sections 1-2 (p 1-8).

**Clas notes in powerpoint format***Labs*: Excel basics (if you need specific howto help, please sign up for the UITSS STEPS course on Excel - see The UITSS STEPS pages for more information.*Jan 19*: Spreadsheet programs, getting and entering data, data formats, data sources.

**Readings**: Text sections 4-6 (p 10-14)

**Clas notes in powerpoint format***Jan 21*: Spreadsheets for data analysis, spreadsheet techniques, data manipulation using spreadsheets.

**Readings**: same as above

**Clas notes in powerpoint format, and the Superbowl example file***Labs*: Module 1: Application of STAIR.*Jan 26*: Continuation of previous lecture. Same class notes and readings.*Jan 28*: Advanced spreadsheet techniques - formulas, macros, and charts.

**Readings**: Text sections 7-10 (p 14-21)

**Clas notes in powerpoint format***Labs*: Module 2: Spreadsheet techniques.*Feb 2*: Measurements and descriptive statics - mean, median and mode and their relationships. Measures of dispersion: skewness, variance, standard deviation.

**Readings**: Text sections 12-14 (p. 24-44)

**Class notes in powerpoint format**: UITS STEPS Excel Basics course.*Feb 3***Please take this course if you are behind or having trouble with Excel!***Feb 4*: Discussion on project ideas, continued topics from previous lecture.

**Same readings and class notes as last class.***Labs*: Module 3: Descriptive Statistics, mean, median, mode, measures of deviation.*Feb 9*: Continued correlation - Pearson's correlation coefficient, strong and weak, positive and negative correlation, computation of correlation coefficients.

**Readings**: Text section 15 (p. 49-59)

**Class notes in powerpoint format**: UITS STEPS Excel Advanced course.*Feb 10***Please take this course if you want to learn more about Excel to help in your project***Feb 11*: Introduction to regression, least squares method, trend lines.

**Readings**: Text section 17 (p. 62-67)

*Labs*: Module 4: Correlation.*Feb 16*: Project discussion*Feb 18*: Regression analysis

**Readings**: Text section 17 (p. 62-79)

**Class notes in powerpoint format***Labs*: Module 5: regression analysis, trend lines.*Feb 23*: Problems with statistics

**Readings**: optional - Abelson (the recommended text)

**Class notes in powerpoint format***Feb 25*: Project presentation - see the projects page for details.*Labs*: Module 6: Make-up module (Tuesday). No labs on Thursday.*Mar 2*: Exam review*Mar 4*:**Final Exam***Labs*: Labs do not meet this week. However, the instructors will be available during normal lab times and office hours to answer questions.