Title:TexasIndependence Timeline

Developed byKimberly Wellborn and Mary Adamcik

Sample

Objective:

Students will create a database of dates important to the Texas Revolution.
Students will create a query of specific dates.
Students will create a timeline form showing the dates.

Timeline:Two class sessions (45 minutes or more)

Content Area: Social Studies / Grade Level: 4
Materials/Resources:Microsoft Access, Important Dates of the Texas Revolution (textbook or other source) / Technology Focus:
Database
TEKS:
Subject Area - §113.6.4.3 (A, C, E)
Technology Applications - §126.3.7 (B)

Procedures:
First Lesson

1.Students should come to the lab with a list of dates and facts from the Texas Revolution (Suggested Dates and Events).

2.Open Microsoft Access.

3.Select Blank Database under New from the task pane on the right side of the screen.

4.In the dialog box that appears, save the file as: TexasIndependence.

5.Discuss Tables, Queries, Forms, and Reports andselect Tables from the Objects box.

6.Select Create in Design View.

7.Discuss fields and data types and create the following fields:

8.Click on the View icon to change to the Datasheet view.

9.Click Yes to save the table.

10.Name the table:Timeline.

11.Click No when asked about a Primary Key.

12.Enter the dates and events into the fields in the datasheet view, editing as needed.
(Suggested Dates and Events)

13.When all records have been completed, have students enter the order of the events in the Order field and Sort the records by Order (Click in any cell containing an order number. Click on the Sort Ascending icon .)

14.Navigate through each record to proofread and save.

Second Lesson

  1. Open the existing database file name TexasIndependence.
  2. Select Query from the Objects menu.
  3. Double-click to select Create query in Design View.
  4. Click Add in the Show Table box.
  5. Close the Show Table box.
  6. Click on the word Month and drag it to the first Field box.
  7. Drag Day to the second column.
  8. Continue until all five fields have been moved.
  9. In the criteria box under Year, type: 1836 and press Enter.
  10. Close the box.
  11. Click Yes to save the query.
  12. Name the query: 1836.
  13. Double click on 1836 to view the results.
  14. You may want the students to sort the results by order.
  15. Close the query results.
  16. Select Reports from the Objects list.
  17. Select Create report by using the wizard.
  18. Under Tables/Queries, click the small arrow to select Table: Timeline.
  19. Click the > icon to select all fields.
  20. Click Next.
  21. Click Next again.
  22. On the Sort screen, click the arrow in the window next to Ascending and select Order.
  23. Click Next.
  24. Select Justified under Layout and then click Next.
  25. Select a style and click Next.
  26. On the last screen in the wizard, name your report: Timeline and click Finish to view the report.
  27. Go to File>Print.

Note: The Table and Query can also be printed, if needed.

Assessment:

Skill / Points Possible / Points Earned
Database has correct fields / 25
Information added correctly / 25
Query contains correct dates / 15
Timeline Report correctly done / 15
Sorting done correctly / 10
Spelling/grammar correct / 10
Total / 100
Modifications:Omit the Timeline Report.
Require fewer records.
Extensions:Have studentsadd one more field named: Rank.
Rate each event in the database in order of importance to the Texas fight for Independence.
Add another memo field to explain the reasons for each ranking.
Sort the records according to their ranking choices.
Additional Resources:
Texas Timeline:
Texas History Timeline:
TexasIndependence Timeline:

Skills:

Database
Manage a database / skills utilized in the project
Identify parts of a database (field, record, form) / I / X
Create a blank database / I / X
Enter data in a consistent form / I / X
Create a table / I / X
Add/Delete records / I / X
Move through records / I / X
Edit data / I / X
Change Column Width / I
Query data
Find data / I / X
Write any additional skills taught in the project