Introduction to Data Literacy

Learn how to understand and work with data using Excel.

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.

• Introductory
• 4 Weeks
• Expert Instructor
• Tuiton-Back Guarantee
• 100% Online
• TA Support

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.

Course Syllabus

Introduction: Data Collection and Storage

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

Variable and Data Types

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

Some Basic Analysis

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

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

2024

01/26/2024 to 02/23/2024
Instructors: Ms. Veronica Carlan
08/16/2024 to 09/13/2024
Instructors: Ms. Veronica Carlan

2025

01/24/2025 to 02/21/2025
Instructors: Ms. Veronica Carlan
08/15/2025 to 09/12/2025
Instructors: Ms. Veronica Carlan

None

Register For This Course

Introduction to Data Literacy

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

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.

Literacy, Accessibility, and Dyslexia

At Statistics.com, we aim to provide a learning environment suitable for everyone. To help you get the most out of your learning experience, we have researched and tested several assistance tools. For students with dyslexia, colorblindness, or reading difficulties, we recommend the following web browser add-ons and extensions:

Chrome

Firefox

Safari

• Navidys (for colorblindness, dyslexia, and reading difficulties)
• HelperBird for Safari (for colorblindness, dyslexia, and reading difficulties)

Register For This Course

Introduction to Data Literacy