Get the most out of the Teacher Learning Community. Sign in now. Not a member? Click here to get started for free!

COURSE - Analyzing Data With Spreadsheets

Buy Now


This course covers analyzing data with spreadsheets. It discusses charts, including which charts are best suited for displaying certain data, how to create charts using spreadsheet data, and how to change the chart type of an existing chart. The course also covers how to apply conditional formatting to data that meets certain criteria, and demonstrates how to filter data to see only the data that meets certain criteria.


Subject: Integrating Technology In The Classroom
Duration: 1 hour
Credit Hours: 1


  • COURSE - Analyzing Data With Spreadsheets
Introduction - Analyzing Data With Spreadsheets
Contains a course description and a brief overview of the objectives covered in this course.more... 
Understand Charts
Explores how charts help illustrate data.more...
Explains various chart types.
Discusses why certain chart types are appropriate for certain types of information. 
Create Charts Using Spreadsheets
Shows how to quickly create a chart from existing data.more...
Illustrates how to use existing data to generate a chart with the Chart Wizard.
Teaches how to add labels and titles to a chart created with the Chart Wizard. 
Change Chart Types
Looks at changing the chart type for an existing chart.more...
Shows how to use the Chart Wizard to change an existing chart.
Examines changing the data series range in a chart. 
Enter Formulas
Illustrates how to enter formulas into a spreadsheet.more...
Shows how to use formulas to calculate weighted grades.
Discusses performing calculations in a spreadsheet. 
Apply Conditional Formatting
Explains how to apply conditional formatting to spreadsheet data.more...
Teaches how to employ multiple conditions in a single set of data.
Shows how to use color to emphasize spreadsheet data. 
Filter Spreadsheet Data
Examines utilizing the AutoFilter feature to show only the data that meets certain criteria.more...
Teaches how to apply custom criteria for an AutoFilter.
Looks at deactivating the AutoFilter feature so that all data is visible. 
Workbook - Analyzing Data With Spreadsheets
Contains a printable workbook that includes a list of the lesson names and objectives covered in this course; a variety of real-life examples showing how the ideas and concepts discussed in this course could be used in a classroom, either as teaching tools or administrative aids; and exercises that provide additional practice and reinforcement of the skills and concepts covered in the course.more... 
Quiz - Analyzing Data With Spreadsheets
Assesses the user's knowledge of the concepts covered in the Analyzing Data With Spreadsheets course.more... 
Feedback - Analyzing Data With Spreadsheets
This survey contains six brief questions pertaining to your educational role and computer experience, as well as to how you would rate your knowledge of this subject before and after this course.more...

Reviews (1)

Basic Member
Not bad. This was pretty useful.
more reviews ...