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.
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.
Students and their parents will receive brief feedback after each class regarding the student’s general participation in class. Students will also receive feedback on graded assignments via email.
1.5 hours per lesson, 10 lessons in total, 15 hours of lessons in total