Applied Computing 1 Textbook

Contents

• Module A Preface

• Introduction To Visualizations
  • Introduction
  • Pie Chart
  • Table
  • Bar Chart
  • Example Visualizations
  • Checklist for Reading Visualizations
  • Checklist for Creating Visualizations
  • Histograms and Bar Charts
  • Summary
• Sheets Basics
  • Introduction
  • What is a Sheet?
  • What Is A Formula?
  • Errors
  • Summary
• Basic Descriptive Statistics
  • Introduction
  • What Is A Statistic?
  • Variables
  • Count and Sum
  • Minimum and Maximum
  • Measures of Center
  • Outliers and Skew
  • Measures of Spread
  • Summary
• Filtering and Grouping
  • Introduction
  • Filtering Data
  • Grouping Data
  • Summary

• Module B Preface

• Importing and Exporting Data
  • Importing Data
  • Exporting Data
  • Summary
• Scatter Plots and Correlation
  • Introduction
  • Motivating Scatterplots
  • Scatter Plots
  • Creating a Scatter Plot in Sheets
  • Describing Scatter Plots
  • Correlation
  • Example: Correlation and College Data
  • Correlation versus Causation
  • Correlation and Filtering
  • Summary
• Regression and “Line of Best Fit”
  • Introduction
  • Creating a Line of Best Fit
  • Equation of a Line (Refresher)
  • Interpreting Slope
  • Making Predictions with the Regression Line
  • Outliers
  • Non-Linear Regression
  • Summary
• Manipulating Data
  • Introduction
  • Pivot Tables
  • Joining Data
  • Summary

• Module C Preface

• SQL
  • Introduction
  • Selecting
  • Filtering
  • Sorting
  • Aggregating
  • Ifs and Cases
  • Joining
  • Summary
  • How to Run SQL Outside of This Textbook

• Projects
  • Module A
  • Module B
  • Module C

You have attempted of activities on this page