What you'll learn
- Understand the role and fundamentals of data and data science and gain experience in all stages involved in data science
- Rack up your technology skills when it comes to working with data and spreadsheets such as Google Sheets and Excel
- Learn how to utilize data formulas and charts inside a spreadsheet table
- Complete a hands-on, personalized, and real-world data science project that involves all stages of data science
- Practice designing your own data science project and creating online surveys to collect your data
- Practice working with data like a professional data scientist, from collecting raw data to analyzing it and delivering results
Requirements
- Basic computer and internet browser usage skills
- Computer connected to the Internet
- Google account to use Google Sheets, or Excel or similar spreadsheet application
- Social media account (Facebook, Twitter, or similar) to share invites to participate in online survey (Optional)
Description
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
Who this course is for:
- Grade 7 or higher students, as well as any adults, who want to learn about data, data science, and working with spreadsheets
- Students who want a hands-on course on data, and to gain experience with a real-world data science project
- Educators who are interested in teaching a classroom-tested course on data and data science
Instructor
- 4.3 Instructor Rating
- 269 Reviews
- 16,792 Students
- 5 Courses
Hesam (Sam) Samimi is a programming languages expert and software developer, who has more recently turned to teaching of computer science and software development at the secondary school level and beyond.
He's currently a teacher and curriculum developer in computer science, as well as an instructor of software development, teaching and developing project-based curriculums for the secondary school level and career prep level, in schools as well as online educational platforms, since 2017. He's also an ESL English teacher, a web and mobile app developer, and a yoga and meditation instructor.
He has recently launched Termeric Education, which is an online buy-and-sell marketplace for school subject curriculums.
Before discovering his passion at the crossroads of computers and teaching, Hesam spent seven years during and after his Ph.D. studies at UCLA as a programming languages researcher, focusing on the application of artificial intelligence in programming and software development.