Why do you need to know how to analyze data? When you can analyze data, you can learn almost anything about any topic that interests you. Charts are a common way to make data easier to understand. Charts are all around us—on television and the Internet, and in books, magazines, and newspapers. You used a spreadsheet application to create a workbook and enter your polling data into a worksheet. Learn how to analyze your data with formulas and functions, and represent your data visually with charts.
In this module:
Activity 1: Formulas and Functions >
Now you are ready to unleash the real power of spreadsheet applications! You are ready to analyze your polling data. Learn how to use formulas and functions to summarize your data in different ways. Use critical thinking skills to analyze your polling data and draw conclusions.
Activity 2: Chart Basics >
Have you ever heard that a picture is worth a thousand words? Some ideas are easier to show than they are to explain. A chart is a visual representation of the meaning of a set of data. Learn to read and interpret charts by recognizing their main parts.
Activity 3: Chart Types >
Did you know that many different kinds of data exist? Different types of charts are used to represent different kinds of data. Learn what types of charts are best for representing particular kinds of data. Read and interpret the four main types of charts.
Activity 4: Data Representation >
What is the best way to represent your polling data visually? Spreadsheet applications have features that make it easier to create charts. You are responsible for making your charts represent your data effectively. Choose what data to represent and what types of charts to create.
Activity 5: Data Formatting >
Congratulations! You are now a data analyst. Are you ready to share the conclusions you have drawn from your data analysis? Learn how to format your worksheets so they are easier to read and interpret. Share the results of your data analysis and what you learned about your topic.
Look Back >
Reflect on what you learned in this module. Are you ready to publish the results of your data analysis? Use the checklist to make sure your tasks are complete. Use the rubric to assess your worksheets, charts, and analysis. Talk about what you learned and how you did your work.
Checklist: Before you begin, review the checklist for this module. Use the checklist to make sure that you complete all the tasks for each activity.
See the checklist (doc) >
Rubric: Before you begin, review the rubric for this module. Use the rubric to help you understand what is important to know and do.
See the rubric (doc) >