Project Includes

  • Teacher Guide
  • Student Workbook
  • Customizable Resources
  • Assessment Tools
  • Extension Activities
  • Sample Files
  • Templates
  • Parent Letters
  • Certificates

TechnoPlanner

Item Number: SNR-PLANNER
Technology Integration: Business Studies
Technology Skill: Database, Word Processing
Program: Access, Word
Includes: High School Database Lesson Plans, Teacher Guide, Printable Student Workbook, Paperless Worksheets, Review Questions, Extension Activities, TechnoPlanner Parent Letter, TechnoPlanner Certificate, Summary of Skills Checklist, Form Marking Sheet, Unconfirmed Events Marking Sheet, Upcoming Events Marking Sheet, TechnoPlanner Database (database includes customer and event records for a party planning business)

Session 1: About Databases
Gain an understanding of database structure by studying a sample database.
Session 2: Build Tables
Plan and create tables and field properties to improve data entry.
Session 3: Create Data Entry Forms
Create a subform to display client event history on the main form.
Session 4: Enter, Sort, and Filter Data
Locate customer records efficiently. Organize, sort, and filter data.
Session 5: Confirmation of the Event
Create a report for follow-up from a query of unconfirmed events.
Session 6: About Upcoming Events
Summarize upcoming events from a query. Create a report in Design View.

Optional High School Database Lesson Plans

  • Database Designer: Plan and design a database.
  • My Favorite Songs: Make a form to categorize music.
  • Mail Merge: Create a personalized advertisement.
  • Organize Movies: Build a table to organize a product.
  • Mailing Labels: Create address labels from a database.

High School Database Lesson Plans

Include TechnoPlanner in a computer application, marketing, or business studies course. Students operate a party planning business, building a database to organize clients and events.

  • Construct a database
  • Make a table in a database to store data
  • Set the field properties in a table
  • Establish a relationship between tables
  • Create simple data entry forms
  • Add a subform to a main form
  • Sort, find, and filter records
  • Produce a query to filter data
  • Design and format a report
  • Evaluate the design of database objects

I was really happy to use Planner for Access. It is very hard to find lessons that support Access and this is perfect. Thanks for all you do with the project based curriculum.

A. Vetter,
Napavine High School,
WA, USA

Customer Reviews

High school students start a business to plan occasions such as parties, proms, or weddings. Microsoft Access is used to create a database to organize information. TechnoPlanner high school database lesson plans teach advanced skills in an engaging, real world application.

I was really happy to use Planner for Access. It is very hard to find lessons that support Access and this is perfect. Thanks for all you do with the project based curriculum.

A. Vetter,
Napavine High School,
WA, USA