IDENTIFICATION by liuhongmei


    INSTRUCTOR: K. Parish
    UNIT TOPIC: Define Technology Operations
    LESSON TITLE: Explain the relationships between data fields, records, and files______
    CLASS: AGSC 376 /3rd Period (10th grade)       DATE BEST TAUGHT: Fall__ __
    TEKS: 119.45c 4A STEM INTEGRATION: BCIS 120.23c5A, B

    OBJECTIVES (TSWBAT---The student will be able to…)
          Def ine the terms: data fields, records, and files in writing with no errors.
          Explain the term, the importance, the relationship, and distinguish the difference
           between data fields, records, and files orally to a partner with 90% accuracy.
          Differentiate among the technology operations (data fields, records, and files) given
           a quiz with no errors.
          Construct a computerized document utilizing data fields, records, and files with 90%

    TEACHING MATERIALS AND RESOURCES (What do you need to bring?)
        Text Book entitled “Access 97 Bible”
        Phone Book
        Power point entitled “Datafields_Records_Files”
        Overhead Projector/ Projector Screen *
        Overhead Transparency of: Label A.B.C. *
        QUIZ: Technology Operations: Dat a Fields, Records, and Files *
        POST IT NOTE adhesive pad
        Permanent Markers (Black, Red, and Blue)
        Computers with (Database Software)

    TEACHING PROCEDURES---Preparation, Presentation, Application, Eva luation
    Preparation (Interest Approach/Motivator)
Key Points                                                    Methods                         5 minutes
    Show a page in a phone book
Motivation                                                    Teacher Led Discussion
    Q: “How many of you have used the phone book to
       look up information? What kind of information (phone
       numbers, addresses, yellow pages, etc.) will you find
       in a phone book? How helpful is this information? Is
       there a pattern to how the information is arranged?”
    Relate phonebook to data fields, records, and files.
    Technology operations such as data fields, records,
       and files help to sort and organize information in the
       most relevant and rational way. To understand each
       of the component’s functions, we must know
       something about each component and how they
       interrelate to formulate meaning.
Overvie w
Today we will ……
    Def ine the terms: data fields, records, and files       Review Objectives
    Explain the differences/ relationships among the terms
    Differentiate among the technological operations
    Construct a computerized document utilizing data
       fields, records, and files
    Presentation (The Meat!)
Key Points                                                         Methods                       25 minutes

We will start today by defining the technological operational      Does anyone know the definition of these
terms (data fields, records, and files) utilizing the text book    terms without looking the definition up in
and explain the relationships between these three                  the book?

      Def ine data field: A data field is a column in a table     Allow students 1-2 minutes to look up
       identif ied by the field name.                              each definition as the teacher discusses
      Def ine record: A record is a group of fields pertaining    each component and give examples of
       to the same entity used in file processing systems.         each term.
      Def ine file: A collection of records.
                                                                   On a power point slide, discuss and note
    DATA FIELD: A space allocated for a particular item of        the differences of each term.
     information. In database systems, fields are the                 o Note the blanks.
     smallest units of information you can access. In
     spreadsheets, fields are called cells. Most fields have             A tax form, for example, contains
     certain attributes associated with them. For example,                a number of fields: one for your
     some fields are numeric whereas others are textual,                  name, one for your Social
     some are long, while others are short. In addition,                  Security number, one for your
     every field has a name, called the field name. A                     income, and so on.
     collection of fields is called a record.

    RECORD: are composed of fields, each of which                       A record is the information
     contains one item of information. A set of records                   entered in a data field, and both
     constitutes a file. For example, a personnel file might              components collectively create a
     contain records that have three fields: a name field, an             file.
     address field, and a phone number field.

    FILE: A collection of data or information that has a                In order to create a file, one must
     name, called the filename. Almost all information                    first have data fields and records.
     stored in a computer must be in a file. There are many
     different types of files: data files, text files , program
     files, directory files, and so on. Different types of files
     store different types of information. For example,
     program files store programs, whereas text files store
                                                                   EXAMPLE: Show overhead
    Observing the overhead transparency, what does                transparency
     the A, B, and C represent?                                      A. Data Field
                                                                     B. Record
                                                                     C. File
    Application (What will they do with what you taught?)
Key Points                                                      Methods                     20 minutes

      Each student group will collectively think of 5
       examples of data fields, records, and files and write    Arrange students in groups of 4.
       their examples on a provided POST -IT NOTE adhesive      Provide one sheet of POST-IT NOTE
       Pad and then determine whether their example is a        adhesive pads and markers to each
       data field, a record, or a file. Afterwards, they will   group.
       post their adhesive paper on the wall for the other
       groups to view and discuss.

     COMPUTERIZED DOCUMENT: Create a one page
      computerized document utilizing data fields, records,
      and files and then print it out. Include name, class      Each student will create a computerized
      and date.                                                 document utilizing data fields, records,
   EX: A computerized phonebook database.                       and files. Limit to one page. Print
      o Data Field: Name, Address, Phone Number                 document when completed.
      o Record: Joe Smith, 1245 Brookshire St, 555-8944
      o File: (10 records of information)                       Provide Example

    Evaluation (How do you know t hey learned it?)
Key Points                                                      Methods                        5 minutes
    What is a data field? What is a record? What is a file?    Oral Questions
    Why is important that we recognize these different
       technology operations?
    Why is it important to create data fields, files, and
    Why might it be important to know the differences
       given between these components?

       QUIZ: Utilizing the terms: data fields, records, and     Quiz: Pass out Technology Operations
       files, students will answer Questions 1-10 in a          quiz to students
       True/False format, Questions 11-15 as Multiple
       Choice, and Questions 16-20 as Fill-in-the-Blanks.

Tomorrow you will f inish inputting data into your one page     Summary—Lead in for tomorrow
computerized document and we will begin talking about how
to locate, sort, and organize agricultural data.

        November 1999 Bryan/College Station Phonebook
        Access 97 Bible (IDG Books Worldw ide, Inc., Publishers)
        Database Processing: Fundamentals, Design & Implementation, 7th Ed.
         (Prentice-Hall, Inc. Publishers)
        ml

To top