Introduction to Data Literacy

Learn how to understand and work with data using Excel.

$649 | Enroll Now
Alert me to upcoming courses
Group Rates

Overview

This course covers how to read, understand, manipulate, and use data. There is no prerequisite knowledge for this course, but it does require access to Excel.

Online Course
Flexible Schedule

Learning Outcomes

After taking this course, you will have the ability to make meaningful information from data. From this information, you will also be able to make decisions scientifically. In particular you will be able to:

  • Identify and understand what data is
  • Understand how data is collected and stored
  • Collect, store and analyze data in Excel
  • Understand and appropriately use variable types (quantitative, qualitative)
  • Understand and appropriately use data types
  • Depict basic displays of data in Excel
  • Understand and apply rates and ratios
  • Produce and analyze summary statistics
  • Identify and correct common problems with data and data visualization
  • Perform basic data cleaning

Who Should Take This Course

Those wishing a brief introduction to key data entry and analysis concepts, and anyone considering taking a course at Statistics.com who needs to learn Excel, or wants to know how our courses operate.

Instructors

Veronica Carlan

Ms. Veronica Carlan

Ms. Veronica Carlan holds a Masters of Science in Mathematics and Statistics from Georgetown University. She was previously a professor at Northern Virginia Community College where she taught calculus, differential equations and statistics both online and in person. She is currently a data scientist at Elder Research, where she focuses on text analytics, anomaly detection and app development and maintenance.  

See Instructor Bio

Course Syllabus

Week 1

Introduction: Data Collection and Storage

  • Introduction
  • What is data?
  • Data collection
  • Data storage
  • Datasets, databases and datapoints
  • Introduction to variables
  • Introduction to Excel

Week 2

Variable and Data Types

  • Variables: quantitative and qualitative
  • Data types
  • Visual displays of data
  • Excel data manipulation
  • Excel charts

Week 3

Some Basic Analysis

  • Rates and ratios
  • Summary statistics
  • Comparison of data points
  • Calculation of statistics in Excel

Week 4

Cleaning Data and Fixing Errors

  • Common problems with data
  • Common data visualization and analysis errors
  • Basic data cleaning practices
  • How data cleaning and fixing data errors can improve analysis

Class Dates

2022

Aug 19, 2022 to Sep 16, 2022

2023

Jan 27, 2023 to Feb 24, 2023

Aug 18, 2023 to Sep 15, 2023

2024

No classes scheduled at this time.

Send me reminder for next class

Prerequisites

None

What Our Students Say​

Frequently Asked Questions

Can I transfer or withdraw from a course?

We have a flexible transfer and withdrawal policy that recognizes circumstances may arise to prevent you from taking a course as planned. You may transfer or withdraw from a course under certain conditions.

  • Students are entitled to a full refund if a course they are registered for is canceled.
  • You can transfer your tuition to another course at any time prior to the course start date or the drop date, however a transfer is not permitted after the drop date.
  • Withdrawals on or after the first day of class are entitled to a percentage refund of tuition.

Please see this page for more information.

Are Statistics.com courses certified?

The Institute for Statistics Education is certified to operate by the State Council of Higher Education for Virginia (SCHEV). For more information, go to https://www.schev.edu/

Are the Certificate Programs accredited?

The Institute for Statistics Education is certified to operate by the State Council of Higher Education for Virginia (SCHEV).

In addition, many of the courses at The Institute for Statistics Education have been recommended for credit by The American Council on Education (ACE), INFORMS, and can be used as CEUs in many programs.

The American Council on Education (ACE) approved credit for many of the required courses for our Certificate Programs and can be transferred to another educational institution that accepts ACE credit.

Visit our knowledge base and learn more.

FAQs + Knowledge Base

Related Courses

Introductory Statistics for College Credit

Introductory Statistics for College Credit

This course will teach you the equivalent of a semester course in introductory statistics.
Topic: Statistics, Introductory Statistics | Skill: Introductory | Credit Options: ACE, CEU
Class Start Dates: Jun 3, 2022, Jul 1, 2022, Aug 5, 2022, Sep 2, 2022, Oct 7, 2022, Nov 4, 2022, Dec 2, 2022, Jan 6, 2023, Feb 3, 2023, Mar 3, 2023, Apr 7, 2023, May 5, 2023, Jun 2, 2023

Additional Course Information

Time Requirements

About 15 hours per week, at times of your choosing.

Homework

Homework consists of weekly practical exercises with Excel

Course Text

All materials will be provided online.

Software

Excel (Google Sheets, which has similar structure, may be used for submissions, but instructional materials will illustrate Excel)

Register for This Course​

Introduction to Data Literacy
$649 | Enroll Now
Get Notified

Have a Question About This Course?

Janet Dobbins

Sales and Business Development

Phone

(571) 281-8817

Send Us A Note

We like to hear from you.

Name*

Email*

Phone

Company

Message*

 

Send