{"id":22090,"date":"2024-04-19T15:40:20","date_gmt":"2024-04-19T15:40:20","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/database-project-two-2-documents-will-need-to-be-submitted-deficiency-report-word-document-with-screenshot-data-dictionary-excel-document\/"},"modified":"2024-04-19T15:40:20","modified_gmt":"2024-04-19T15:40:20","slug":"database-project-two-2-documents-will-need-to-be-submitted-deficiency-report-word-document-with-screenshot-data-dictionary-excel-document","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/database-project-two-2-documents-will-need-to-be-submitted-deficiency-report-word-document-with-screenshot-data-dictionary-excel-document\/","title":{"rendered":"Database Project Two (2) Documents will need to be submitted.  Deficiency Report: Word Document with Screenshot Data Dictionary:  Excel Document"},"content":{"rendered":"<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">For this portion of the database project, students<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">will be comparing deficiencies among multiple healthcare facilities, and analyzing the data via a database program. Data will be presented in MS Access for manipulation into a<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><em style=\"cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Deficiency Report which will then require final screenshot submission via a Word Document<\/strong><\/em>.<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><em style=\"cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Students will then create a Data Dictionary for all columns as identified in the Deficiency Report. The data dictionary must be submitted via an Excel Spreadsheet.<\/strong><\/em><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><\/span><\/span>&nbsp;&nbsp;<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\" aria-level=\"2\"><span style=\"cursor: auto; color: inherit;\">Two<\/span><\/strong><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span>(2) Documents will need to be submitted.<\/p>\n<ul style=\"margin-right: 0px; margin-bottom: 6px; margin-left: 25px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Deficiency Report<\/strong>: Word Document with Screenshot<\/li>\n<li style=\"cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Data Dictionary<\/strong>:&nbsp; Excel Document<\/li>\n<\/ul>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">&nbsp;<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">You will be utilizing this database:<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><a style=\"cursor: auto;\" data-api-returntype=\"File\" data-api-endpoint=\"https:\/\/devryu.instructure.com\/api\/v1\/courses\/77075\/files\/11837095\">HIT226DB.accdb<\/a><\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">&nbsp;<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><span style=\"font-size: 14pt; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Deficiency Report: Access Database with 2 tables (40 points)<\/strong><\/span><\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">Identify 2 healthcare facilities to compare with 6 or more deficiencies<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Instructions<\/strong><\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><u style=\"cursor: auto; color: inherit;\">MS Access Steps:<\/u><\/p>\n<ol style=\"margin-right: 0px; margin-bottom: 6px; margin-left: 25px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Open database in MS Access<\/li>\n<li style=\"cursor: auto; color: inherit;\">Create new query using Query Design tool.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Add Providers and Provider Deficiencies tables to the query.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Add fields to query:<\/li>\n<ol style=\"margin-right: 0px; margin-left: 25px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">From Providers table: Federal Provider Number, Provider Name, Provider State<\/li>\n<li style=\"cursor: auto; color: inherit;\">From Provider Deficiencies table: Provider Deficiency ID<\/li>\n<\/ol>\n<li style=\"cursor: auto; color: inherit;\">Click Totals to change to an aggregate query<\/li>\n<li style=\"cursor: auto; color: inherit;\">Under Provider Deficiencies ID<\/li>\n<ol style=\"margin-right: 0px; margin-left: 25px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Change the Total setting to Count<\/li>\n<li style=\"cursor: auto; color: inherit;\">Change Sort to Ascending<\/li>\n<li style=\"cursor: auto; color: inherit;\">For Criteria, enter &gt;= 6<\/li>\n<\/ol>\n<li style=\"cursor: auto; color: inherit;\">Run the query.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Save the query as Provider Deficiency Counts.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Capture a screen shot of the first few rows of the query results and paste into a Word document.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Select 2 healthcare facilities from this list that you want to compare. Capture a screenshot including their Federal Provider IDs, Provider Names, Provider States and deficiency counts and then insert screenshot into a WORD document.<\/li>\n<\/ol>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">(Be sure your screenshot shows a minimum of 6 deficiencies per hospital)<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">&nbsp;<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><span style=\"font-size: 14pt; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Data Dictionary: Create a Data Dictionary (40 points)<\/strong><\/span><\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">Develop a data dictionary for all columns from your deficiency report in EXCEL. Your Data Dictionary must include the following data elements:<\/p>\n<ul style=\"margin-right: 0px; margin-bottom: 6px; margin-left: 25px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Data field<\/li>\n<li style=\"cursor: auto; color: inherit;\">Name<\/li>\n<li style=\"cursor: auto; color: inherit;\">Definition<\/li>\n<li style=\"cursor: auto; color: inherit;\">Data Type<\/li>\n<li style=\"cursor: auto; color: inherit;\">Format<\/li>\n<li style=\"cursor: auto; color: inherit;\">Field Size<\/li>\n<li style=\"cursor: auto; color: inherit;\">Data Values<\/li>\n<li style=\"cursor: auto; color: inherit;\">Data Source<\/li>\n<\/ul>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Please refer to Table 6.1 in Chapter 6 of your book for an example of a Data Dictionary.<\/strong><\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">&nbsp;<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Summary of Required Submissions:<\/strong><\/p>\n<ul style=\"margin-right: 0px; margin-bottom: 6px; margin-left: 25px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Deficiency Report: Word Document with Screenshots<\/li>\n<li style=\"cursor: auto; color: inherit;\">Data Dictionary: Excel Document<\/li>\n<\/ul>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\">&nbsp;<\/p>\n<p style=\"margin: 8px 0px; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">**REMINDER: You will be submitting 2 Documents **<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For this portion of the database project, students&nbsp;will be comparing deficiencies among multiple healthcare facilities, and analyzing the data via a database program. Data will be presented in MS Access for manipulation into a&nbsp;Deficiency Report which will then require final screenshot submission via a Word Document.&nbsp;Students will then create a Data Dictionary for all columns [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/22090"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=22090"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/22090\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=22090"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=22090"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=22090"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=22090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}