# CSCI A113 Data Analysis using Spreadsheets

* Home  * Description  * Overview  * Syllabus  * Resources *
* Modules  * Projects  * Grades  * Discussion *

### Topics summary

• STAIR and data analysis: Using the STAIR technique to solve data analysis problems, problem analysis, problem solving methods.
• 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.

### Class-by-class Topics

The following is a tentative list of topics to be covered in the course. Note that this list is subject to changes.
• 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
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.
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
• Feb 3: UITS STEPS Excel Basics course. 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
• 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.