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.

Select an offering Date
Aug 19th 2022 to Sep 30th 2022 (43 Days)
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

Loading...
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

No classes scheduled at this time.

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

Loading...

What Our Students Say​

Loading...

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

Loading...
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: 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, Jul 7, 2023, Aug 4, 2023, Sep 1, 2023, Oct 6, 2023, Nov 3, 2023, Dec 1, 2023, Jan 5, 2024

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)

Course Fee & Information

Enrollment
Courses may fill up at any time and registrations are processed in the order in which they are received. Your registration will be confirmed for the first available course date unless you specify otherwise.

Transfers and Withdrawals
We have flexible policies to transfer to another course or withdraw if necessary.

Group Rates
Contact us to get information on group rates.

Discounts
Academic affiliation?  In most courses you are eligible for a discount at checkout. Use promo code ACADEMIC where prompted during registration.

Invoice or Purchase Order
Add $50 service fee if you require a prior invoice, or if you need to submit a purchase order or voucher, pay by wire transfer or EFT, or refund and reprocess a prior payment.

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