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.
Introduction to Data Literacy
Introduction to Data Literacy
Learn how to understand and work with data using Excel.
Menu
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
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
2021
No classes scheduled at this time.
2022
No classes scheduled at this time.
2023
No classes scheduled at this time.
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 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.
Related Courses
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: Feb 5, 2021, Mar 5, 2021, Apr 2, 2021, May 7, 2021, Jun 4, 2021, Jul 2, 2021, Aug 6, 2021, Sep 3, 2021, Jan 7, 2022, Feb 4, 2022, Mar 4, 2022, Apr 1, 2022, May 6, 2022
Class Start Dates: Feb 5, 2021, Mar 5, 2021, Apr 2, 2021, May 7, 2021, Jun 4, 2021, Jul 2, 2021, Aug 6, 2021, Sep 3, 2021, Jan 7, 2022, Feb 4, 2022, Mar 4, 2022, Apr 1, 2022, May 6, 2022
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)
Have a Question About This Course?
Janet Dobbins
Sales and Business Development
Phone
(571) 281-8817