Civil War
Nancy Slonneger - Technology Integration Specialist

Integrating Technology into Today's Home, Office & Classroom

Home
Up
Services
Personal Info
ROE Classes
Internet
How E-Mail Works
Microsoft Office
Resources
Savvy Searching
Online Safety
Multimedia
Digital Imaging
Class Projects
Scavenger Hunts
Windows
Palm Training
Excel
DVD-Productions

Creating a Database of Civil War Battles

The following Excel skills will be covered:

bulletUsing Excel as a Database
bulletTips to designing an efficient database
bulletSetting up a database
bulletFreeze panes/Split window
bulletData forms
bulletFiltering a list
bulletUsing AutoFilter
bulletCustomizing an AutoFilter
bulletRemoving AutoFilter
bulletDatabase functions

Database Basics

INTRODUCTION - click here to learn more about using Excel as a database

Practice Using Excel as a Database - a Word file to download (right-click and choose Save Target As)

Civil War Links

bulletA Divided Nation: Causes of the U.S. Civil War
bulletCivil War and Reconstruction
bulletCauses of the Civil War - Encarta Online Encyclopedia
bulletCivil War Flash Map Animation
bulletCivil War Map of Battles
bulletwww.civilwar.com 
bulletTime Line of The Civil War - from the Library of Congress

From the following link,

bulletCivil War Battle Summaries - from the National Park Service

 find information about each of the following battles:

bulletAntietam
bulletChancellorsville
bulletChickamauga
bulletFirst Bull Run
bulletSecond Bull Run
bulletFort Sumter
bulletFort Henry
bulletGettysburg
bulletShiloh
bulletVicksburg

Then, create an Excel database with the following fields:

Battle State StartDate EndDate NorthLeader SouthLeader Casualties Outcome

Once you have started your database in Excel, and created the fields, you may start entering the records for each of the battles listed above.  (Example Civil War Database)

Extension Activity

From the Excel database file which can be downloaded here, find the answers to the following questions:  (The Worksheet can be downloaded here.)

  1. How many battles were fought in Virginia?
  2. What is the first battle won by the Confederates?
  3. What battles took place in New Mexico?
  4. In what battles was Ulysses S. Grant the Union Commander and US casualties at least 13,000?
  5. How many battles was Robert E. Lee the Confederate Commander and Confederate casualties at least 10,000?
  6. What is the only battle fought in the Pacific Theater?
  7. In what Theater were the most battles fought?
  8. This battle took place in the Eastern Theater in North Carolina. The Confederate Commander was Maj. Gen. Robert Hoke.  The US Commanders were Rear Adm. David D. Porter and Maj. Gen. Benjamin Butler.  The date of the battle was Dec. 7-27, 1864.  What was the name of the battle and what was the result of the battle?
  9. What was the Campaign name? - Find the following information to find out:
    1. Location is North Carolina
    2. Date at least May 5, 1864
    3. Confederate Commander is Cdr. JW Cook
  10. What battle had the most Total Casualties?

Resources

Using Excel as a Database - pdf file to download (you must have Adobe Acrobat Reader to open this file) Get Acrobat Reader

Using Excel as a Database - pdf file to download (you must have Adobe Acrobat Reader to open this file) Get Acrobat Reader

Adapted from a lesson plan by Dorene Bates available http://www.learnnc.org/LearnNC/lessonp.nsf/all/4B2DD3230FDAF4248525687900563A38?openDocument 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(The Answer Key can be downloaded here.)  
(The Specific Instructions for using Excel as a Database Answer Key can be downloaded here.)
(The Example Civil War Database using Excel for the main lesson can be downloaded here.)

[ Home ] [ Up ]


Copyright © 1999 - 2006 Keyboard Connections
Last modified: May 15, 2008