Creating a Spreadsheet to Organize Data

Learning Target:

• I can create a spreadsheet to organize and sort data.

You will make a spreadsheet listing the first 10 U.S. presidents
including several facts about each president.

File Name: Presidents Your Name

Part 1: Setup Spreadsheet

1. Open Microsoft Excel.
   Mac [Click Excel icon in Dock]
   Windows [Start > Programs > Microsoft Office > Microsoft Office Excel 2003]
2. Type the following into each CELL listed:
   • A1: Last Name
   • B1: First Name
   • C1: Years Served
   • D1: Number of Years in Office
   • E1: State Born
   • F1: Age Elected
   • A2: Washington
   • B2: George
   • C2: 1789-1797
   • D2: 8
   • E2: VA
   • F2: 57

Part 2: Collect Data

Fill in the information for the first 10 presidents following the format started in Part 1.
Use the Internet to do your research.

Do a keyword search or try one of these websites:
http://en.wikipedia.org/wiki/List_of_Presidents_of_the_United_States
http://www.ipl.org/div/potus/
http://www.whitehouse.gov/history/presidents/index2.html

Part 3: Format Spreadsheet

1. Center all of your columns.
2. Adjust the column widths to "fit" the information. No data should be "cutoff."
3. Place a border around the spreadsheet of information.
4. Create a Header with the title “First 10 Presidents”, Your Name, Date, and Class. [View > Header and Footer > Custom Header > write in your information]

Part 4: Sort Data

You will COPY & PASTE your table to create a total of 4 identical tables, then sort each according to the following criteria:

• List 1: Years Served, ascending (Chronologically)
• List 2: Last Name(1), then First Name(2), ascending (Alphabetically)
• List 3: State Born, descending
• List 4: Age Elected, ascending

Printing Guidelines:

• All content must fit to ONE PAGE.
• Remember to include the HEADER (see Part3 #4).
• Do a PRINT PREVIEW to assure that you do not print more than one page!

Early Finishers

Fill in your spreadsheet with the rest of the presidents.