|
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 |