Sparks Fly
[Home] [PBS VideoDatabase] [Social Studies] [TSU] [UVA]

 

Databases for Instruction

Course Syllabus

 

1)     Introduction (1/2 hour)

a)     Course objectives and Virginia Standards of Learning

b)     Software terminology/Hardware terminology

c)      Examples of Databases

2)     Introduction to Databases (3 hours)

a)     Definition—What is a Database?

b)     The software window—menu bars and tool bars

c)    Creating a New Database
   i)       Saving, viewing, and printing
   ii)      Creating and saving a table
         (1)  Design view
         (2)  Datasheet View
   iii)     Creating a form
   iv)     Entering data
   v)      Printing a table
   vi)    Setting a Primary Key

3)     Modifying a Database (3 hours)
a)     Filter
        i)        Sort Records
        ii)      Find Records
b)     Query a Database
        i)        Query vs. Filter
        ii)      Query a Relational Database

4)     Reports (1 hour)

a)     Creating with Wizard

b)     Design View

5)     Field Types (1 hour)

a)     Calculation fields

b)     Radio Buttons

c)      Check boxes

d)     Number fields

e)     Others

6)     Expanding a Database (1 hour)

a)     Cut, Copy, Paste

b)     Inserting and deleting

7)     Printing large Databases (1 hour)

8)     Integrating Databases into other applications (1/2 hour)
a)     Working with multiple files
b)     Copying data between files
c)      Copying text between word documents and databases

9)     Classroom Activities (2 hours)
a)     Creation of databases for use in specific classroom applications
b)     Discussion of ideas for introduction of database creation to students

10) Development of Student Activities (2 hours)
a)     Designing lesson plans that incorporation databases into instruction

Final Activity—Lesson Plan

Final Hands-on activity—last thirty minutes of class.  Test is hands-on and will require demonstration of skills learned in the course.

***This class meets some of the requirements for the Technology Standards for Instructional Personnel.  Any class that addresses these standards must include a concluding activity where the individual must demonstrate the skills taught in the class.

This page was updated on:  04/10/02