29 Jan • The writing in Speaker

Database Project Final Report

Assignment #3

Purpose

The purpose of this assignment is to present the results of the database project.

Course Outcomes

Through this assignment, the student will demonstrate the ability to:

(CO#1) Utilize critical inquiry and judgment to evaluate the design, development, implementation, and outcomes of strategies for managing healthcare-related information (PO#4)

REQUIREMENTS:

Submit a PowerPoint presentation of the database project (12-15 slides).

Use the database plan as a guide, updating as needed. All work done during this course, including discussion threads, assignment papers, appendices, and references, may be used to develop this report. Corrections and updates based on feedback are expected.

Providethe reason(s) for the database, including any supporting evidence. Describe the database developed for the course, showing or narrating the three models: conceptual, logical, and physical. Showthe relationaltables. Include 3 questions that guided database design.Report the results of testing the database and any revisions needed to the database as a result of testing. Conclude with a recap of the database project and insights gained from working on this project. The presentation and speaker notes must follow APA guidelines.

PREPARING THE PAPER

Criteria for Content:

• Introduction establishes topic and organization of presentation

• Reason for database is provided, including supporting evidence

• Structure of the database developed for this projectis described, including conceptual, logical, and physical models; can be presented as text, graphics, or a combination

• Relationaltables are presented in standard format, with primary keys identified, any secondary keys identified if used, attributes with one data characteristic for each attribute, and normalization issues identified and resolved

• Three questions developed for database plan

• Description of how database was tested

• Results of testing, including any needed changes

• Recap of entire project

• Insights on information management developed from working on project

• Speaker Notes are provided for each slide, except for title and references slides, and provide sufficient depth to allow someone else to take over the presentation.

Criteria for Format and Special Instructions

1. Grammar, spelling, and punctuation are consistent with formal academic writing.

2. APA format is used correctly for citations and references

3. Create 12 – 15 slides, not counting title or references slides

4. Citations are not included in slides but are part of Speaker Notes

Category Points % Description

Introduction 10 6.7 Introduction establishes topic and organization of presentation

Reason 20 13.3 Reason for database provided, including supporting evidence

Database structure 20 13.3 Structure of student’s database described, including conceptual, logical, and physical models

RelationalTables 20 13.3 All relation tables shown, with primary and secondary keys, attributes with data characteristics, and identification and resolution of normalization issues

Questions/Queries 10 6.7 Three questions developed for database plan in week 3, with any updates

Testing 15 10 Description of how database was tested, with results and any necessary changes

Conclusion 15 10 Recap of project and conclusions on success of project and insights on information management developed from working on the project

Speaker Notes 10 6.7 Speaker notes are present on each required slide and are sufficient to allow someone else to take over the presentation

Number of Slides 10 6.7 Presentation uses 12 – 15 slides

APA Format/References 10 6.7 Presentation uses APA correctly for citations and references; citations are present only in Speaker Notes

Writing Mechanics 10 6.7 Grammar, spelling, word usage, and punctuation are consistent with formal written work.

Total 150 100

A quality assignment will meet or exceed all of the above requirements.

GRADING RUBRIC

Assignment Criteria Exceptional

(100%)

Outstanding or highest level of performance Exceeds

(88%)

Very good or high level of performance Meets

(80%)

Competent or satisfactory level of performance Needs Improvement

(38%)

Poor or failing level of performance Developing

(0)

Unsatisfactory level of performance

Content

Possible Points = 120 Points

Introduction 10 Points 9 Points 8 Points 4 Points 0 Points

Introduction is thorough and establishes the topic and organization of the presentation Introduction includes basic information about the topic and the organization of the presentation Introduction includes information about the topic OR the organization of the presentation but not both Introduction does not include information about the topic and the organization of the presentation Introduction is not present

Reason 20 Points 18 Points 16 Points 8 Points 0 Points

Reason for database is provided in depth, including supporting rationale(s) Reason for database isprovided including supporting evidence Reason for database is provided and only partially supported by evidence Reason for database is provided. Supporting evidence NOT included No reason for database is provided

Database Structure 20 Points 18 Points 16 Points 8 Points 0 Points

Database structure is described in depth, including conceptual, logical, and physical models. Description can be narrative or a combination of narrative and graphics Database structure is described simply, including conceptual, logical, and physical models. Description can be narrative or a combination of narrative and graphics Database structure is described

Only 2models are included Database structure is described

Only 1 model is included Database structure is not described

OR

no models are included

Relation Tables 20 Points 18 Points 16 Points 8 Points 0 Points

All of the following are present

• All relation tables, after resolution of normalization issues, are shown in correct format with primary and secondary keys

• All attributes with data characteristics are shown in each table.

• Normalization , process and issues identified and resolved are narrated in Speaker Notes Two of the following are present:

• All relation tables, after resolution of normalization issues, are shown in correct format with primary and secondary keys

• All attributes with data characteristics are shown in each table.

• Normalization , process and issues identified and resolved are narrated in Speaker Notes

One of the following is present

• All relation tables, after resolution of normalization issues, are shown in correct format with primary and secondary keys

• All attributes with data characteristics are shown in each table.

• Normalization , process and issues identified and resolved are narrated in Speaker Notes Some but not allrelation tables are not shown

OR

• All relation tables, after resolution of normalization issues, are shown BUT keys are not shown

AND

• Normalization , process and issues identified and resolved are not narrated in Speaker Notes No relation tables are shown

Questions/Queries 10 Points 9 Points 8 Points 4 Points 0 Points

All of the following are present

• Three appropriate questions developed for the database plan are presented.

• Updates, if any, are includedand discussed in Speaker Notes

• Updates are not required, but consideration of updates is discussed in Speaker Notes Two of the following are present:

• Three appropriate questions developed for the database are presented.

• Updates, if any, are includedand discussed in Speaker Notes,

• Updates are not required, but consideration of updates is discussed in Speaker Notes. One of the following is present

• Three appropriate questions developed for the database are presented.

• Updates, if any, are included and discussed in Speaker Notes,

• Updates are not required, but consideration of updates is discussed in Speaker Notes Two appropriate questions developed for the database are present No questions for the database are present

Testing 15 Points 13 Points 12 Points 10 Points 0 Points

• Detailed description of how database was tested

• Results and any necessary changes presented • Simple description of how database was tested

• Results and any necessary changes presented • Database testing described

OR

• Results and necessary changes presented • Database testing not described

BUT

• Results and necessary changes are presented • Database testing not described

AND

• Results and changes not presented

Conclusion 15 Points 13 Points 12 Points 10 Points 0 Points

All of the following are present:

• Thoroughly recaps the database project

• Provides conclusions on success of project

• Provides insights on information management developed from working on the project All of the following are present:

• Simplified recap of the project

• Provides conclusions on success of project

• Provides insights on information management developed from working on the project 2 of the following are present:

• Recap of the project

• Provides conclusions on success of project

• Provides insights on information management developed from working on the project 1 of the following is present:

• Recap of project

• Provides conclusions on success of project

• Provides conclusions on insights on information management from working on the project None of the following are present:

• Recap of project

• Provides conclusions on success of project

• Provides conclusions on insights on information management from working on the project

Speaker Notes 10 Points 9 Points 8 Points 4 Points 0 Points

• Speaker Notes are thorough and present on each required slide

• Sufficient depth on 100% of the slides to allow someone else to take over the presentation • Speaker Notes are present on each required slide

• Notes on 75% of the slides have sufficient depth to allow someone else to take over the presentation. • Speaker Notes are present for each required slide slides but are not of sufficient depth on more than 75% of the slides to allow someone else to take over the presentation Speaker Notes are provided for fewer than 75% of the required slides Speaker Notes are not provided for any slides

Format

Possible Points = 30 Points

Number of Slides 10 Points 9 Points 8 Points 4 Points 0 Points

Presentation uses a minimum of 12and a maximum of 15 slides Presentation uses a no more than 11 slides or uses 16 slides Presentation uses no more than 10slides or uses 17slides Presentation uses no more than 9slides or uses 18 slides Presentation uses fewer than 7 slides or more than 19 slides

APA Format/References 10 Points 9 Points 8 Points 4 Points 0 Points

• 0 – 1 APA errors in the slide content, citations, or references

AND

• Aminimum of 3 references that are not textbooks are provided • 0 – 1 APA error in the slide content, citations, or references

AND

• A minimum of 3 references with a course text as one of those 3 references • 2-3 APA errors in the slide content, citations, or references

AND

• A minimum of 3 references • 4-5 APA errors in the slide content, citations, or references

OR

• Fewer than 3 references • 6 or more APA errors in the slide content, citations, or references

Writing Mechanics 10 Points 9 Points 8 Points 4 Points 0 Points

• There are no errors in spelling, grammar, punctuation, and syntax

• The writing in Speaker Notes and slides is consistent with formal written work. • 1 – 2 errors in spelling, grammar, punctuation, and syntax,

• The writing in Speaker Notes and slides is consistent with formal written work • 3 – 5 errors in spelling, grammar, punctuation, and syntax

OR

• The writing in Speaker Notes and slides is not consistent with formal written work. • 6 errors in spelling, grammar, punctuation

• 7 or more errors in spelling, grammar, punctuation

___Format 30 Points

Total Points 150 _____of 150 Points