Designed for
Students who have basic math knowledge and want to learn data analysis
Level
Beginner
Class format
One-on-one and small group (Max. 7 students/class)
Class Introduction
Data Analysis and Statistics are important tools to transform data into meaningful information and make better decisions. Many programs in colleges have classes that require data collection, statistical analysis, and storytelling with data, but freshmen often start their degrees unprepared in terms of these quantitative skills. This course is designed to bridge that gap by teaching high school students essential skills in statistics, data analysis and visualization with Excel software.
Outcome
- Explain how to calculate simple probability
- Calculate and interpret descriptive statistics, measures of dispersion, and conduct mean-variance analysis
- Understand distributions, quartiles, and outliers
- Perform hypothesis testing and calculate confidence intervals
- Apply the first 4 learning outcomes in MS Excel
- Visualize data with graphs, trends, histograms, charts, and bars in Excel
- Estimate simple linear models and interpret the output in Excel
Course Content
Texts: Students need MS Office installed on their devices. Lecture notes, datasets and exercises will be shared by the instructor.
Topics for this course include, but are not limited to: introduction to probability, descriptive measures, measures of central location, percentile, and boxplot; introduction to data analysis in Excel, exploring data in Excel, understanding data types, classifying data types; and more advanced topics like regression analysis and forecasting using Excel.
Schedule
1.5 hours per lesson, 10 lessons in total, 15 hours of lessons in total
