Overview

In this all hands-on project course, students get their first real experience of data science by playing the role of a professional data scientist. The course starts off with a couple of hands-on spreadsheet table assignments to get students equipped with basic skills on working with data, using Google Sheets (or Excel). We then jump right into the independent data science student project--Data Science Project: Understanding My Community Better--in which the students aim to study how their chosen local community compares to everyone else, with respect to a chosen topic. They will do the work involved in every stage of data science: problem statement and research, setting up online surveys, raw data collection, data organization and cleaning, data analysis using formulas and charts, and finally identifying and presenting results.

Highlights

• School computer curriculum ready - Suitable for a 20-week middle or high school term

  • For teacher curriculum bundle see Termeric Education website.

• Classroom-tested -This course was taught in a 20-week semester for 9th graders in a real school. The content level and volume is appropriate and suitable for a typical 20-week school semester, for all junior or high school grades. Each unit below could span 1-2 weeks in a real classroom setting.

• Practice working with data in Google Sheet or Excel spreadsheets

• For Grade 8+ or Adults!

• 11 units (~20 Weeks)

• 2 assignments

• 1 independent student data science project

• Lecture slides and other resources

Sections

• Section 1: Lectures

  • Unit 1

    • Role of Data in Digital World

    • Use Cases of Data Science

    • Stages of Data Science

  • Unit 2

    • Spreadsheet Table Basics

    • Types of Data

    • Homework 1: Create Excel Table: Nutrition Data of Your 5 Favorite Fruit Picks

  • Unit 3

    • Spreadsheet Formulas

    • Spreadsheet Charts

    • Homework 2: Analyze Your 5 Favorite Fruits Data

• Section 2: Data Science Student Project

  • Unit 4

    • Data Science Project Overview

    • Research Area Selection

    • Research Topic Selection

    • Problem Statement Selection

  • Unit 5

    • Select 2 Questions for Online Polls

  • Unit 6

    • Set Up Online Polls

  • Unit 7

    • Collect Raw Data

    • Organize Data in a Table

  • Unit 8

    • Clean Data

    • Sort Data

  • Unit 9

    • Analyze Data

    • Use Formulas and Charts

  • Unit 10

    • Identify Results

  • Unit 11

    • Present Results