Election time database

After using various methods of researching information, students will create a database and use it to answer questions about the current election. At the conclusion, students will create a poster or Hyperstudio presentation of their findings.

A lesson plan for grade 5 Computer/Technology Skills and Social Studies

By Lee Yahnker

Learn more

Related pages

• Election time using a database: Students, working in groups, use various resources to answer prepared questions about the candidates. Students will enter their data into a prepared database. With teacher guidance, students will learn to use the database to find information.
• The 2004 presidential election in historical context: Historian William E. Leuchtenburg talks about past presidential elections and how the 2004 election fits or defies precedents.
• There's more out there than just Democrats and Republicans!: Students will use the internet to research minority political parties and interest groups. Students will create a PowerPoint presentation (or other type of presentation), write a paper, and create a commercial advertisement for their group using a propaganda technique.

Related topics

• Learn more about Democratic Party, Republicans, candidates, databases, elections, political parties, social studies, and technology skills.

Help

Please read our disclaimer for lesson plans.

Legal

Learning outcomes

Teacher will direct a class discussion on the candidates for the current election. Class will suggest a list of facts to be researched on each candidate. Using various methods of research, students will find answers. Students will create a database and use it to answer questions. At the conclusion, students will create a poster or HyperStudio presentation of their findings.

Teacher planning

Time required for lesson

3+ days

Materials/resources

• List of candidates for public office
• Newspapers, news magazines
• Optional: TV news
• Paper and pencil
• Database program
• Poster Board and/or HyperStudio

Technology resources

Computer with database software, Internet (optional), HyperStudio (optional)

Pre-activities

Students will need a knowledge of the election process and which candidates are running for public office.

Students will need to know how to skim articles for specific information.

Activities

Day 1: Research Preparation

1. Make a list of candidates that you want students to research. They can be national, state, or local candidates. Assign students to groups.
2. Tell students that they will be researching two types of information about their candidates: demographic information and positions on issues. List these responses on the board or chart paper. Demographic information includes facts such as age, party, occupation, education, gender, ethnic background, marital status, children, etc. Issues are the candidates’ positions for or against specific issues in the election, such as increasing school funding, cutting taxes, etc.
3. Direct a class discussion on what students would like to learn about the candidates in terms of demographic information and positions. Ask students to rate the importance of each category of information in deciding whom to vote for.
4. Either have students list the information you want them to research on paper or the teacher (or student) could type list in a word processor and make copies for each group.

Day 2: Researching candidates

5. Have students use a variety of ways to search for information: Internet, newspapers, news magazines, TV news, etc. (This could be done as a homework assignment).

Day 3: Creating an election database

6. After students have completed research, as a class create an election database. Show students how to set up the database using the categories they researched as their fields.

Databases can be created in Microsoft Works or Microsoft Excel. Instructions for creating a database using Microsoft Works:

• From the Task Launcher Window, Choose Works Tools, and Choose Database.
• In the Field Name Box, type a field name up to 15 characters.
• Continue clicking the ADD button and typing a name for your field until you have all your fields.
• Click the DONE button.
• For each record, enter the data, pressing the TAB key to move between fields.

Day 4: Finding Specific Information

7. Sort the candidates by Last Name
   
   • Go to Record
   • Choose Sort
   • Use the drop down box to choose your field: Last Name
   • Choose ascending or descending
   • Click OK

   Note: These directions are only for those using a database created in Microsoft Works. Users of databases created on other software would need to be familiar with their software.

8. Answer the following questions:
• How many candidates are Republican?:
  • Go to Tools
  • Filter
  • Name Filter 1: Republican
  • For Field Name, use the drop down box and choose Party.
  • Type in the compare to box: Republican.
• How many candidates are Democrat?
  • Go to Tools
  • Filter
  • Name the filter: Democrat
  • For Field Name, use the drop down box and choose Party.
  • Type in the compare to box: Democrat.
• Create other questions based on the criteria your students researched.

Have the most computer literate group go first; then they can assist other groups. Save work after each group finishes.

9. Final Product: Have each student select the 3-5 most important categories for choosing a candidate. Students will then create a poster, Hyperstudio, or Powerpoint presentation comparing the candidates in these categories.

Assessment

Assessment: Each group will be graded on 4 criteria:

1. Did students complete all the research correctly on their candidate?
2. Did each group successfully enter and save their data into a database?
3. Were students able to answer questions correctly?
4. Final Product: Are the important facts about the candidates clearly and accurately depicted?