Outreach for K-12
Electrical Technology Center, Rm. 136 · (570) 320-8003
Governor's Institute for Career Education and Work
Grades K-4
Grades 5-6 Grades 7-8
Grades 9-12
Governor’s Institute for |
|
| Title |
Problem Solving at Style City |
|---|---|
| Standards Addressed |
|
| Brief Overview | Students will analyze the problems of a small business owner (Style City) and find a database solution. |
| Grade Level | 11th |
| Content Area(s) | Computer Programming (Access Database) |
| Other Standards Supported | ASCA, PSCA, NCDC |
| Prep Time | 20 minutes |
| Implementation Time | 2 45-minute sessions |
| Learning Objectives | Students will work in pairs to brainstorm solutions and diagram solution. |
| Materials Needed | Worksheet containing description of the problem. (See attachment) |
| Detailed Activity Steps |
|
| Theory Basis | Trait and Factor Theory |
| Evaluation/Assessment | Diagrams will be analyzed for completeness, simplicity, and workability. |
| Comments | Students should have a complete understanding of the problem to be solved. |
| Enhancement Activities | Use Microsoft.com/office/access Web site. Find templates to help market Style City. |
| Adaptation for At-Risk Kids | Students will work in pairs for support. |
| Resources | Microsoft Access software and Web site. |
(Sample Problem for
13.2.11.C) Sara Welshans Style City |
|---|
|
Mimi Benson is a cosmetologist who has had her own business for four years. She offers her clients the following services:
She also sells products including shampoos, conditioners, and sprays for the hair as well as polish for the nails and skin creams. She sees approximately 150 different clients each month. She currently spends several hours each week keeping track of scheduling, income, and expenses (which she writes by hand in a notebook). She needs to generate a monthly report of income and expenses for her accountant. She would also like to know how much money each service generates and which clients are scheduled each day for which services. Your assignment is to design a database solution that will generate the report and schedules that Mimi needs. Draw a diagram showing the various entities needed for the database and indicating the relationships of those entities to each other (Entity-Relationship Data Model Diagram) |