Sunday, February 21, 2010

Define database management software and describe how you might use it to help you in teaching responsibilities

Database management software (DBMS) is that which allows the user to collect, to organize, and to retrieve related data. This software is ideal for managing large amounts of data. The different parts of the database management system are important to the utility of the program. The field is the smallest information unit, and it contains a single data attribute. Fields make up a record. The record is the set of field values. The combination of all the records is called a table. All of this information is used to determine relationships within the database. The great part of this program is the ease of use. Do not let the terms befuddle you.

 Once the information is entered into the database the operations that can be performed are: archiving, sorting, queries, reports, and forms. This is different from a spreadsheet; this program focuses on relationships between data, and not performing mathematical functions. Think about organizing library books – in a single sweep, the DBMS can organize a report on the inventory. The report can be based on any part of the information entered in the table I require. The time it takes is miniscule.

This is a great tool to help students understand relationships with data. An easy start for students in understanding databases is to start with information on the class. You may need to get them started, but the class will need to develop their own fields and records. To get them going, ask them what they would like to know about their classmates. Some good start questions, how many siblings, favorite football team, birthing order, etc. Once all the data is entered, the fun begins. Now, it will be easier for them to see just how many people with whom they have things in common! This exercise helps demonstrate the concept of relationships.

Once the class has sorted, performed a query, and completed a report containing the names of the middle child of each family (or some other record of information), move on to a class project. The class should decide on the project, and the length of time it will run. It will be simple enough to think global, once all subjects are considered. It would be simple enough to find another school, in another city, state, or country, with which you could exchange information.

3 comments:

  1. I love the idea of using data base management software to form relationships in the class. Students are always interested in learning about one another. That is a good way to spark their interest into wanting to particpate in the lesson. I thought that class project was innovative and very useful to teach students about DBMS. I remember in a class I was in this summer, with you Adele always started with a relationship builder excercise. It was always a fun way to start the class and become closer with our peers. Great way to incorporate it into a technology lesson.

    ReplyDelete
  2. Its about time you got with the program. For awhile there I thought you had thrown me to the wolves. Who you calling old? I am still waiting to hear about the job. I was sorry to hear that Cindy dropped the class.

    ReplyDelete
  3. I enjoyed reading your reflection and comments. Great job

    ReplyDelete