Teachers Network
Translate Translate English to Chinese Translate English to French
  Translate English to German Translate English to Italian Translate English to Japan
  Translate English to Korean Russian Translate English to Spanish
Lesson Plan Search
Proud New Owners of teachnet.org... We're Very Flattered... But Please Stop Copying this Site. Thank You.
Our Lesson Plans
TeachNet Curriculum Units
Classroom Specials
Popular Teacher Designed Activities
TeachNet NYC Dirctory of Lesson Plans

VIDEOS FOR TEACHERS
RESOURCES
Teachers Network Leadership Institute
How-To Articles
Videos About Teaching
Effective Teachers Website
Lesson Plans
TeachNet Curriculum Units
Classroom Specials
Teacher Research
For NYC Teachers
For New Teachers
HOW-TO ARTICLES
TEACHER RESEARCH
LINKS

GRANT WINNERS
TeachNet Grant:
Lesson Plans
2010
TeachNet Grant Winners
2009
TeachNet Grant Winners
Adaptor Grant Winners
2008
TeachNet Grant Winners
Adaptor Grant Winners
2007
TeachNet Grant Winners
Adaptor Grant Winners
Other Grant Winners
Power-to-Learn
Math and Science Learning
Ready-Set-Tech
Impact II
Grant Resources
Grant How-To's
Free Resources for Teachers
ABOUT
Our Mission
Funders
   Pacesetters
   Benefactors
   Donors
   Sponsors
   Contributors
   Friends
Press
   Articles
   Press Releases
Awards
   Cine
   Silver Reel
   2002 Educational Publishers Award

Sitemap

Welcome to Mrs. Fonseca's Computer Class!: Tally Sheet for Favorite Cities

Tally Sheet for Favorite Cities

 

Cities

Boys

Girls

Total

Atlanta

lll

ll

5

Chicago

ll

l

3

Detroit

llll

llll ll

12

Los Angeles

llll

ll

6

Orlando

l

lll

4

Using the Tally Sheet above, you will create two graphs by following the directions below.

Total Graph

    1.      Open Microsoft Excel.

    2.      Click cell B1.

  Type Total.

    3.      Click cell A2.

Type Atlanta, press Enter.

Type Chicago, press Enter.

Type Detroit, press Enter.

Type Los Angeles, press Enter.

Type Orlando, press Enter

    4.      Click cell B2.

   Type 5, press Enter.

   Type 3, press Enter

   Type 12, press Enter.

   Type 6, press Enter.

   Type 4, press Enter.

    5.      Click File.

   Click Save.

   Click My Documents.

   Click 3 ½ Floppy (A:)

   Highlight Book1.xls.

   Type Graph #1.

   Click Save.

    6.      Click cell A1.

       Highlight cells A1 through B6.

    7.      Click Insert.

   Click Chart.

   Click Next.

    8.      Click Next.

   Highlight Total under Chart title.

   Type Favorite Cities.

   Type Cities under Category (X) axis.

   Type Number of Students under

   Value (Y) axis.

    9.      Click Legend tab.

   Click Show Legend to remove

   check mark.

10.      Click Data Labels tab.

      Click Show value.

      Click Next.

11.      Click Finish.

   New chart is added to document.

   New chart is selected.

12.    Drag upper left corner to column A,  

       line 7 (right below Orlando).

       Drag upper right corner to column I.

       Drag lower left corner to line 28.

13.    Click Format Chart Area.

Click Font tab.

Choose a Font.

Click OK.

14.    Click Favorite Cities.

Click Format Chart Title.

Click Bold for Font style.

Click 16 for Size.

Click OK.

15.    Click Cities.

Click Format Axis Title.

        Click Bold for Font style.

        Click 16 for Size.

        Click OK.

16.    Click Number of Students.

Click Format Axis Title.

Click Bold for Font style.

Click 16 for Size.

Click OK.

17.    Click Atlanta.

Click Format Axis.

Click 12 for Size.

Click OK.

18.    Click first bar.

Click Format Data Series.

Choose a color.

Click OK.

19.    Click Plot Area (gray area).

Click Format Plot Area.

Click the white box (under Area).

Click OK.

20.    Click 5 (on first bar).

Click Format Data Labels.

Click Bold for Font Style.

Drag 5 onto bar.

Drag 3 onto bar.

Drag 12 onto bar.

Drag 6 onto bar.

Drag 4 onto bar.

21.    Click 0.

Click Format Axis.

Click Scale tab.

Highlight Maximum number.

Type 12.

Highlight Major unit number.

Type 1.

Click Font tab.

Click 12 for Size.

Click OK.

22.    Click File.

Click Save.

You have completed Graph #1.

 

 

 

 

Boys/Girls Graph

1.      Open Microsoft Excel.

  2.  Click cell B1.

        Type Boys, press Tab.

        Type Girls, press Tab.

3.      Click cell A2.

Type Atlanta, press Enter.

Type Chicago, press Enter.

Type Detroit, press Enter.

Type Los Angeles, press Enter.

Type Orlando, press Enter.

4.      Click cell B2.

Type 3, press Enter.

Type 2, press Enter.

Type 5, press Enter.

Type 4, press Enter.

Type 1, press Enter.

5.      Click cell C2.

Type 2, press Enter.

Type 1, press Enter.

Type 7, press Enter.

Type 2, press Enter.

Type 3, press Enter.

6.      Click File.

Click Save.

Click My Documents.

Click 3½ Floppy (A:)

Highlight Book1.xls.

Type Graph #2.

Click Save.

   7.  Click cell A1.

Highlight cells A1 through C6.

 8.   Click Insert.

Click Chart.

Click Next.

9.      Click Next

Type Favorite Cities under Chart title.

Type Cities under Category (X) axis.

Type Number of Students under

Value (Y) axis.

10.        Click Legend tab.

Click Top.

11.        Click Data Labels tab.

Click Show value.

Click Next.

12.        Click Finish.

13.     Drag upper left corner to column

          A, line 7 (right below Orlando).

          Drag upper right corner to column I.

          Drag lower left corner to line 28.

14.   Click Format Chart Area.

  Click Font tab.

  Choose the same font you chose for   

  Graph #1.

     Click OK.

15.   Click Favorite Cities.

  Click Format Chart Title.

  Click Bold for Font style.

  Click 16 for Size.

  Click OK.

16.   Click Cities.

  Click Format Axis Title.

  Click Bold for Font style

  Click 16 for Size.

  Click OK.

17.   Click Number of Students.

        Click Format Axis Title.

       Click Bold for Font style

        Click 16 for Size.

        Click OK.

18.    Click Atlanta.

  Click Format Axis.

  Click 12 for Size.

  Click OK.

19.   Click first bar.

 Click Format Data Series.

 Choose a color.

 Click OK. 

20.   Click second bar.

 Click Format Data Series.

 Choose a color.

 Click OK.

21.   Click Plot Area (gray area).

 Click Format Plot Area.

 Click the white box (under Area).

 Click OK.

22.   Click 0.

 Click Format Axis.

 Click Scale tab.

 Highlight Maximum Number.

 Type 12.

 Highlight Major unit Number.

 Type 1.

 Click Font tab.

 Click 12 for size.

 Click OK.

23.   Drag all the numbers onto the bars.

24.   Center the Legend box under

       Favorite Cities.

       Click Format Legend.

       Click 14 for Size.

25.   Click File.

 Click Save.

 You have completed Graph #2. 

 

 

 

Come across an outdated link?
Please visit The Wayback Machine to find what you are looking for.

 

Journey Back to the Great Before