Charts and Graphs

 

Introduction | Task | Process | Evaluation | Conclusion


Introduction 

Graphs are used every day by the media to help get the point of their story to the reader. Go to the USA Today to see what kind of a chart they are featuring on their home page today. Well-prepared graphs often make a point much clearer. Remember, a picture is worth a thousand words!

In this web based lesson, you will learn about reading, interpreting, and creating computerized charts and graphs. You will be using this site as a guide to your assignment. After learning the basics about business graphs from several sites, you will surf some destinations that will provide you with data you can then use to create your own graphs.

 

The Task 

After learning about graphs by reading some Internet sites, you will look at existing graphs and determine what they say about the data they represent. In other words, you will interpret the data into your own words to draw conclusions. Then your teacher will review some basics about creating graphs using Microsoft Excel. Then finally, you will be creating several graphs of different types using data gathered from the internet.


The Process 

Part 1:

First, visit the following 3 Internet pages to learn some of the basics about graphs. Answer the ten questions on the corresponding worksheet as you read these pages. Click to open a copy of Worksheet One in Microsoft Word. You will need to have the Internet and Word open at the same time to effectively work on this part of the assignment. Use the buttons on the taskbar (at the bottom of your screen) to move back and forth between applications. When you are finished answering the questions, save the document in your folder and print a hard copy for your instructor.

Part 2:

Next, you will need to click on the sites listed below and use them to answer the questions on worksheet two.   Click to open a copy of Worksheet Two in Microsoft Word.   Keep both Word and Netscape open at the same time.    Again, be sure to save the document in your folder and print a hard copy for your instructor.

Part 3:

Again, you will need to have the Internet and Excel open at the same time to effectively work on this part of the assignment. You will go between the two programs frequently. For this part, you will choose from the following set of links to gather numeric data to use to create graphs of your own. After finding a sight that has the kind of data you believe will make a good graph, type it into the Excel spreadsheet and use the Excel graph wizard to draw your graph. Make one each of the following types of graphs. Be sure to label your graphs and include the site you used to find the information.

Teach the class some of the basics of what you have learned and design a quick problem for a volunteer to practice (Don’t pick a goof ball).  DO NOT READ BORING PARAGRAPHS TO THE CLASS!  Discuss it like you know what you are talking about!  Use several visual aids to help the class understand the topic


Line Graph
 

Bar Graph


Pie Chart
 



Possible source sites:

U.S. Government Bond Interest Rates

 

National League Team Batting Statistics

The Week's Most Watched Television Shows

 

United States Census Bureau

 

Voting Statistics

 

National ACT Scores

 

CIA Factbook

 

 


Evaluation 

 Web Quest Evaluation Rubric         

 

Conclusion 

Congratulations, completing this lesson has made you proficient at creating computerized graphs that represent numerical data gathered from any source. You also are able to interpret existing graphs, weigh their validity, and draw conclusions concerning the data they represent. Finally, you've gotten some Internet experience and used a graphing application.


Credits & References