Solving a Mystery/Creating an Access Database
Author: Patricia Janann Nicholson
Curriculum Area: Instructional Technology
Subject Area: M/J Introduction to Computers
Sunshine State Standard Benchmark:
  • Demonstrate awareness of computer systems, i.e., input, process, and
    output.
  • Identify the functions of basic computer hardware and software and
    peripheral devices.
  • Operate a computer for varied educational purposes.
    • LA.B.2.3.4 use electronic technology including databases and software to gather information and communicate new knowledge.
    • MA.E.1.3.3 analyze real-world data by applying appropriate formulas for measures of central tendency and organizing data in a quality display, using appropriate technology, including
      calculators and computers.
  • Analyze varied tasks and problems to determine when technology is
    useful and select the appropriate tool(s) and technology resource(s) to
    address those tasks and problems.
    • MA.B.4.3.2 select and use appropriate instruments, technology, and techniques to measure quantities in order to achieve
      specified degrees of accuracy in a problem situation.
    • SC.H.3.3.7 know that computers speed up and extend people’s ability to collect, sort, and analyze data; prepare research reports;
      and share data and ideas with others.
Grade Level: 7th MYP & 7th/8th Grade Wheel
Lesson Title: Solving a Mystery/Creating an Access Database
Resources: Nicholson's Lesson Plan Blues
http://pjnicholson.com/mjcomapp/accessassign.htm
Learning Objective:

Students will:

  • create a table which include the assigned fields.
  • choose the correct data type for assigned fields.
  • provide a description for fields entered into table.
  • create a form from the saved table using the form wizard and all fields are present.
  • arrange fields in form so that they are easy to read in design view.
  • all forty records are entered correctly.
  • queries are created in design view, and query results return the correct data.
Instructions: Students will follow the instructions provided at Nicholson's Lesson Plan Blues Website.
Assessment http://pjnicholson.com/mjcomapp/lp/accessrubric.htm