All resources in Intro to Statistics (Chattanooga State)

Course Syllabus

(View Complete Item Description)

The attached file is our syllabus for the Introductory Statistics course that we are teaching as an OER course. The summary of the syllabus is as follows.This course uses MyOpenMath for testing students' knkowledge via homework and quiz assessments. MyOpenMath is an open platform for students to use without any additional access fees like the one for our other statistics courses which charge an extra fee to use a different online platform.This course uses MS Excel as the statistical tool. We have created templates for students to use to evaluate statistics for a given data. Students have access to all Microsoft products via their college account without any extra charge. Using Excel also eliminates the need for buying a calculator.A big part of the course is the project, which is based on real world data. Students are provided with data in a spreadsheet by the instructor. Data is mined from public domains. Students are to submit their input using MS Word and MS Excel.We are also using MS Teams to record additional video resources on using Excel for statistics.

Material Type: Syllabus

Author: Hersh Patel

Excel Templates as a Statistical Tool

(View Complete Item Description)

As mentioned in the syllabus, we are using MS Excel for statistical analysis in our OER stats course. We have, therefore, created three templates, one for each of the three units that the course is divided into, in order to help students make necessary calculations. Creating templates was a necessary steps since students are not expected to know how to use Excel functions for statistics and these templates are to guide students into getting relevant stats for their data, such as average, median, histograms, etc. Each template is divided into separate spreadsheets according to the topics. These templates help cut down the tedious work of evaluating statics and help students focus more on the concepts and analyse the results.

Material Type: Teaching/Learning Strategy

Author: Hersh Patel

Lesson Summaries

(View Complete Item Description)

As a supplement to the OpenStax textbook, we have also created lesson summaries for our OER course. Attached are some instructor created notes on the following topics.Introduction to StatisticsSampling MethodsBias in SamplingOrganizing Data using Frequency Distributions and HistogramsMeasures of CenterMeasures of Dispersion and Empirical RuleMeasures of Position, Fences and Outliers5-Number Summary and Boxplots

Material Type: Lecture Notes, Reading, Student Guide

Author: Hersh Patel

Video Tutorials

(View Complete Item Description)

Along with the Excel templates, we are also creating video tutorials for our students to help them become familiar with spreadsheets. These videos are recorded using MS Teams, then posted under course content page on the D2L course site (eLearn). Students have access to these videos wherever they have internet access. Students may also download and save these videos if need be. Following are the first two video tutorials (also attached with this section).Excel BasicsFrequency Distributions

Material Type: Interactive

Author: Hersh Patel