Activity: Grade 4 Census Using Microsoft Word & Excel

These are the technology skills we will be focusing on:

  • Demonstrate basic word processing skills: enter & edit text, using 5 Golden Rules.
  • Identify two uses for a spreadsheet.
  • Identify parts of a spreadsheet: column, row, cell, formula.
  • Use a spreadsheet to create a graph.
  • Use a spreadsheet to calculate.

These are the math skills we will be focusing on:

  • Collect and organize data and identify the best way to show your data.

  • Create, draw conclusions, and make predictions from different ways of showing data, including: tables, bar graphs, pictographs, and line graphs.

 

Word Processing Review

1) Open a new, blank page in Microsoft Word.

2) Type your answers to the census questions (also written on the white board). You can use any font/color/size that you want.

3) Save your file as "census4X".

4) Use the handout from Mrs. Davis to check your work! Did you follow the 5 Golden Rules of word processing?

5) Once you've checked your work, print to the HP 4050TN (black and white printer).

 

 

Fun With Spreadsheets!

Check out this example of the graphs you can create with a spreadsheet. You will create graphs like these, using your class's answers to the census questions and Microsoft Excel. Check out this rubric to see how your graphs will be graded.

1) Open Microsoft Excel.

2) Set up a data table for organizing the information on the ages of the students on your color team.

3) Create a formula for calculating the average age of your team. Here are the symbols you will need to create your formula:

  • Symbol Used to ...

    =

    Let Excel know that this is a formula; the equal sign must always be the first thing in your formula
    + Add
    - Subtract
    * Multiply
    / Divide

4) Create a graph showing the ages of the students on your color team.

 

 

More Fun With Spreadsheets

How many more graphs can you create, using your team's Grade 4 Census data. Don't forget that you will set up the data table differently for different types of questions.

 

Done Early?

Complete a lesson in Type to Learn.

Check out the games on Cool Math for Kids.


Return to the Tech Class Main Page.

Return to the John R. Briggs Elementary School Main Page.

Revised by Tiffany Davis on 1/03/08.