Tech skill area: Spreadsheet and charting

Project - Show statistics in a chart using graphing tools

7th grade birthdays:

1.  Create a new spreadsheet in your Google Docs

6

2. Rename your spreadsheet Birthday Spreadsheet

5

0

3. Lable column A Month and column B # of births

Now fill in the months and number of birthdays in each

vd

4. To create a chart, highlight the data you want to use and then from the insert menu, choose chart.

 

11

5. You will see a pie chart and chart editor. This is where you choose the type of chart, and customize it.

4

3D if you like

3

Add a title

Customize colors a

2

Final chart, when you are happy, click insert

1

 

Insert this spreadsheet with chart into your Google portfolio web site.

Insert>spreadsheet>choose your birthday spreadsheet

Answer these two questions at the top of your page.

Look at the chart, what does it tell you?

Where else could you use pie charts to show information?

 

 

NEXT>>>

 

 

 


Objectives
(Know)

• Students will:
_understand what data is

_understand the elements of a spreadsheet, cell, column, row, formula bar, headers

–Use the chart feature to create a graph of your data. 

_Explain how using the chart feature can help you to understand data trends

• Have a fellow student check your work


Project Examples

link



Glossary

Statistics -data that can be represented numerically

Chart -A chart is a visual representation of data,

Home page