Databases

  • Access Database Lessons from ...

    • 3 Ways to Learn (choose one or all):
      • Read and practice - MSOffice 2010 Text - Complete Ch. 1 Lessons (AC01-AC63).
      • Tutorials - Video and Reading - http://www.gcflearnfree.org/access2010
      • Just Video Tutorials - Youtube or Atomic Learning Tutorials (user:aldenstudents, pass: bulldogs)
      • Assignments
        • Lab 1, Lab 2, Lab 3 from MSOffice 2010 Text (AC66) [due May 15]
        • Grading = 10 points max each.
          • Complete, perfect formatting, perfect spelling, database works = 10
          • Complete, a couple careless mistakes, works ok = 8
          • Complete, many errors, works ok = 6
          • Mostly complete, many errors = 4
          • Started, some content added = 2
          • Nothing = you're fired = 0


    PROJECT - Access Database

    Project Background
    You are the owner or an employee in a business that uses databases to manage their data. This project is largely self-designed, meaning you will dictate the appropriate level of detail.  You are not expected to know all the details of running a business.  However, you are expected to make reasonable assumptions, collaborate with your fellow students, and ask questions to clarify your understanding.

    Create a folder titled DA106 – lastname – Access Biz and include the following information:

    Document Filename = DA106 – lastname – Access Biz
    Database Filename = DA106 – lastname – Access Biz


    Guidelines and Rubric

    Describe the business. [doc]
    What is the name of the company? (5)

    What goods do you manufacture and sell or what services do you provide? (5)

    Determine and briefly describe your position within the company. Include your title and primary responsibilities. Specify the number of employees in the business, who reports to you, and who you report to. (5)



    Plan the database. [doc]
    Describe, in general, what you intend to accomplish with the database. (5)

    Make a list of fields of data you will need. You will need 20 or more for this project. (10)

    Group the fields into categories for specific purposes. Briefly describe the purpose of each category. Think about the ways you will want to search or sort the data and plan the fields to support them. (10)

    You will need at least 3 categories which will become your datasheets in Access. You may and should use some fields in multiple datasheets. You will need relationships between each datasheet. (5)


    Assess the database. [doc]
    Evaluate your database design.  Describe the best and worst parts of your database.  (5)

    What changes did you make you your original database plan?  (5)

    What would you do differently next time? (5)

    What suggestions do you have to improve this project assignment for future students?

     

    Use the Database  [database/doc]

    Create a Query to sort and organize data for a specific purpose. (5)

    Explain why the query is beneficial and how you might modify it in the future. [doc] (5)

    Identify 2 or more aspects of your business that would benefit from a report. List the name of each report. [doc] (5)

    Explain the benefit of the report and describe how using access helped with the report. [doc] (5)

    Generate 2 useful reports for your business. Format it to look clear and easy to read. (10)

    Create a sheet of labels for a mailing list would count as one. One page only please. Print preview and make it look good. (5)

     

    Project Submission

    Include this rubric in the DA106 – lastname – Access Biz document. Type your info below each task (recommended). Place this document as a "cover Page" for your project and print the reports and staple it together.  Type your name here. (2)

    Put your Word and Access files into your folder and place both in the drop box, also. (3)

    Self-evaluate your project and assign a grade.  Note the points you have earned next to each parenthesis above. If your grade matches what I give you, you get +2 extra credit points. 

    My grade is: XX/100


    Lesson and Project Learning Objectives

    ISTE Standards - International Society for Technology in Education


    3. Research and information fluency

    Students apply digital tools to gather, evaluate, and use information.

    a. Plan strategies to guide inquiry

    b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media

    c. Evaluate and select information sources and digital tools based on the appropriateness to tasks

    d. Process data and report results

    4. Critical thinking, problem solving, and decision making

    Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources.

    b. Plan and manage activities to develop a solution or complete a project

    c. Collect and analyze data to identify solutions and/or make informed decisions

    d. Use multiple processes and diverse perspectives to explore alternative solutions


    6. Technology operations and concepts

    Students demonstrate a sound understanding of technology concepts, systems, and operations.

    a. Understand and use technology systems

    b. Select and use applications effectively and productively

    c. Troubleshoot systems and applications

    d. Transfer current knowledge to learning of new technologies