Giants of the century

1900–1999 was a period of unparalleled achievements in science, medicine, human rights, and more. In this activity, students will identify key figures in 20th-century progress and then document the life and times of each in a searchable database.

Objectives

  • Students will be exposed to 20th-century history and to the people who shaped it.
  • Students will be introduced to database tools and organizing techniques.

Learning outcomes

  • Students will use the Internet to research five 20th-century history makers from around the world.
  • Students will find information in articles to populate the database.
  • Students will compose a brief biography of five influential figures and a short paper on the historical context in which they lived.
  • Students will create, save, and retrieve individual records in a database. They will then enter and link all appropriate information (text, documents, hyperlinks, and pictures).

​Lesson procedure

Introduction

  1. Launch Office Access. In the opening window dialog box, select Create a new database using blank Access database. In the File New Database window, name your database "Giants of the Century," and save it to a location accessible to all of your students.

  2. In the Database window, double-click Create table in Design view.

  3. Create fields for Name, Nationality, Area of Influence, Decade, Contribution, Picture, and Sources.

  4. Click in the Data Type cell for the Picture field. Click the drop-down button and select OLE Object from the list.

  5. Click in the Data Type cell for the Name field. Click the drop-down button and select Hyperlink. Do the same for the Decade field. The students will connect these links to their proper destinations later.

  6. By default, text fields hold only 50 characters but you'll want more room than that for the Contribution and Sources fields. To increase the field size, click the field to display Field Properties, and select the General tab. Increase the Field Size value to 255.

  7. Close the table. You'll be prompted to assign a primary key. However, you don't need to because the database will contain only one table.

  8. Design a form for entering information into the table. In the Database window, in the Objects column, click Forms, and then double-click Create form by using wizard.

  9. In the sequence of Form Wizard dialog boxes, select all available fields in your table, and then choose columnar layout and a style for your form.

  10. In the final Form Wizard dialog box, confirm a title for your form, select Modify the form's design, and then click Finish. The form will appear in Design view.

  11. To prevent the images that you have imported from being clipped or distorted, click the Picture field, and on the View menu, click Properties. Select the All tab, click in the Size Mode field, and select Zoom from the drop-down list box. Close the Properties window.

  12. Make any additional changes you want to in the form in Design view. You can do this either by selecting and dragging objects to different locations or by editing properties (as in Step 11).

  13. Close and save the database. Now students can create records (like the sample shown in the Student Activity section) for the individuals they've chosen and link them to biographical and historical information as described in the Student activity section.

 

​Student activity

One exciting way to look at history is to study the people who shaped it. In this activity, you and each of your classmates will choose five individuals who made the world a better place during the 20th century. Then, in a single database, you'll combine information about their lives, accomplishments, and the historical events that influenced their work.

Follow the steps below to guide your students through this lesson plan. See student handout links at right.

Step 1: Giants research

What to do: Gather pictures and basic information about your five history makers.

  1. Think about the greatest achievements of the 20th century, in any field of human endeavor. Who made them happen? What names come to mind? Thomas Edison? Madame Curie? John Lennon? Mother Teresa? Pick five people whose accomplishments you admire most or about whom you would like to learn more.
  2. Using bing.com or other online encyclopedia, search for images and information about the men and women you've chosen. The sites listed above will help you get started on the web. Request permission to reproduce images if permission is not explicitly given in the source. Cite all of the sources that you use.
  3. Use the Office Access form that your teacher has created to collect information about each person, including area of influence, and the decade and nature of his or her major contribution(s).
  4. When you enter information in the Name and Decade fields, it will appear blue and underlined. These are hypertext links, but they won't work properly until you connect them to their appropriate destinations in Step 4 (below).
  5. Find a picture of each of your chosen history makers and include it the Office Access record. To insert the image into the form take the following steps:
    1. Click in the Picture frame to select it.
    2. Go to the Insert menu, and choose Object.
    3. In the Insert Object dialog box, select Create from File. Then use the Browse button to locate the image you have saved so that the path to that image appears in the File box.
    4. Click the Link check box, and then click OK.

Step 2: Get personal

What to do: Research and write short biographies of your history makers.

  1. As a class, create a list of all the people represented in your database. Your teacher will help you divide the list evenly among all the students in your class.
  2. Use bing.com or other online encyclopedia to research and write short biographies on the individuals assigned to you (no more than one page each). Each biography should be a separate Word document.
  3. Make sure that you use the same margins, font, and other formatting as your classmates so that all of your biographies will have a common look.
  4. Use the subjects' last names for your file names, and save them to a shared directory that your teacher will set up. 

Step 3: Research the historical context

What to do: Write a paper on the period of history in which your history makers worked.
 
  1. Your teacher will divide the class into 10 teams and assign each team a decade to document.
  2. Using bing.com or other online encyclopedia, and additional web resources as needed, research and write a one-page document highlighting the major events of your assigned decade.
  3. Keep in mind that the purpose of this document is to provide a historical context for the achievements of the men and women you and your classmates have chosen. The scope of your history document must be broad enough to encompass events that may have influenced all of the "giants of the century" who made their major contributions during your assigned decade.
  4. When you are done with your history document, save it in a shared directory (that your teacher will set up) with the name of the decade it represents (for example, 1900-1909.doc).

Step 4: Pull it all together

What to do: Link your records to your biographies and history documents.
 
  1. Open a new spreadsheet in Excel.
  2. Open the "Giants of the Century" database. In the Database window, in the Object column, click Forms, and then double-click the form name to open it.
  3. Go to each of the records you created in Step 1 (Giants research). Click the person's name, and then cancel any dialog boxes that appear. The name will then be highlighted. Go to the Insert menu and select Hyperlink to open the Insert Hyperlink dialog box. Browse to the location of the biography document for that person, and click OK.
  4. Repeat this procedure with the decade you've entered in the Decade field, but link to the document that contains history for the corresponding period.
  5. Your "Giants of the Century" database is complete. Browse the records and discuss them in class. What does it tell you about the 20th century? 

Conclusion

  • Students will learn about the giants of history who shaped the 20th century.
  • Students will gain an understanding of creating and building a database of content.