Milstone 1 help due in 7 hours

IT 200 Milestone One Guidelines and Rubric

Scenario: A new owner has purchased Swagger Distribution Company, a company that distributes clothing and apparel. She does not have experience with IT- related problem solving, so she is contracting you, as an IT consultant, to help. For Milestone One, you will submit a document summarizing the human-computer interface (HCI) and information management/database (IMD) using appropriate IT terminology. Take a moment to read the Final Project Guidelines and Rubric to see how the following information applies to the final project, and then proceed to do the following for Milestone One: Human-Computer Interface (HCI): On a daily basis, Swagger Distribution’s employees log in to the company’s network and utilize many different types of software and the internet. They use Microsoft Word and Microsoft Visio daily. For this area of the assignment:

 Summarize the human-computer interface (HCI) of these two software applications. Explain the importance of HCI and usability of the software.

 Be sure to note any commonalities between the applications and note any metaphors that are utilized.

 Suggest one enhancement to one of the two applications that would improve HCI, supported by at least two examples for the suggestion.

 Create a one-page tutorial for Microsoft Visio, including component screenshots, for new employees who are familiar with Microsoft Word but have never used Microsoft Visio. Cover at least two basic functions and/or menu options.

 Using circles or arrows and text to label them, point out five different components within Visio within an additional screenshot and briefly describe these components.

Databases: Swagger Distribution’s partners/customers include a variety of clothing companies. Swagger Distribution utilizes a database to store information on the partner companies and the orders that are received. You will review the provided database for Swagger Distribution and summarize what the tables contain and what the queries do. Be sure to apply key terms that you have learned such as “metadata.” Based on information provided, you will change one data type in one of the tables. For this area of the assignment:

 Open up each table in the database to look at the data and examine its formatting. Be sure to open each table in regular view and design view. Describe each table, the information it stores, and any data types present other than text.

 Open up the table “Clothing Products” in design view. Change the data type of the “Retail Price” field from “text” to “Currency.” Now reopen the table “Clothing Products” in design view and notice the change. Provide a description of your actions and the results.

 Run the query “Retail Purchases” by double-clicking on the query. Make note that it is an empty query and you will see no results. Open up the query in design view. Make note of the actions it is taking and how the tables are linked. Why does the query provide no results? Describe how the tables are linked together and what the query is doing.

 Open up the table “Retail Stores.” Make selections for each retailer in the “Clothing Item” field. Now close the table. Re-run the query “Retail Purchases.” Describe what these results represent. Add a screenshot of your results to your final submission for this milestone (Note: This screenshot should also reflect the changes you made when changing the “text“ data type to “currency”).

Rubric Guidelines for Submission: Written components of the project must follow these formatting guidelines when applicable: double spacing, 12-point Times New Roman font, and one-inch margins. The paper should be 1 to 2 pages in length, not including cover page and resources, and written in paragraph form, accompanied by screenshots. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions.

Critical Elements Exemplary Proficient Needs Improvement Not Evident Value

Human-Computer Interface Consult -

Summary

Meets “Proficient” criteria and explains their importance to the usability of the software (100%)

Accurately summarizes aspects of the human-computer interface (HCI) for MS Word and Visio in the company’s existing IT system (85%)

Attempts to summarize the aspects of the human- computer interface (HCI) for MS Word and Visio in the company’s existing IT system; however, information is missing or inaccurate (55%)

Does not summarize the aspects of the human- computer interface (HCI) for MS Word and Visio in the company’s existing IT system (0%)

16

Human-Computer Interface Consult - Recommendation

Suggested enhancement and the rationale for it is well- justified with multiple examples (100%)

Suggests one enhancement to one of the two applications that would improve HCI, supported by an example for the suggestion (85%)

Suggests one enhancement to improve HCI; however, recommendation is unclear or inaccurate (55%)

Does not suggest one enhancement to improve HCI (0%)

16

Human-Computer Interface Consult -

Illustration

Creates a tutorial for Microsoft Visio by covering the two basic functions and/or menu options (100%)

Creates a tutorial for Microsoft Visio but may not cover the two basic functions and/or menu options or covers them incorrectly (55%)

Does not create a tutorial for Microsoft Visio (0%)

10

Human-Computer Interface Consult -

Identification

Labels at least five elements of the tutorial appropriately (100%)

Labels elements of the tutorial incompletely or incorrectly (55%)

Does not label elements of the tutorial (0%)

10

Information Management/

Database Consult – Summary

Meets “Proficient” criteria and demonstrates professional understanding of the database structure and contents (100%)

Accurately describes the information management/database, including the tables, query, and data types (85%)

Describes the information management/database, including some aspects of the tables, query, and data types, with some errors or omitted information (55%)

Does not describe the database (0%)

16

Information Management/

Database Consult - Data Types

Meets “Proficient” criteria, and the description of the resulting changes demonstrates fluency in IT terminology (100%)

Correctly changes a data type and describes the action and the impact on the table (85%)

Attempts to change a data type and describe the action and impact; however, there are major errors (55%)

Does not change the data type or describe the impact (0%)

16

Information Management/

Database Consult – Queries

Meets “Proficient” criteria, and the detailed descriptions of the actions and consequences on the query outputs demonstrate expertise (100%)

Runs the query “Retail Purchases,” identifies the actions and table linkages, and describes the results of the two different queries using a screenshot (85%)

Attempts to run the query “Retail Purchases,” identify the actions, table linkages, and the results of the two queries using screenshots, but information is missing or inaccurate (55%)

Does not run the queries, or description is significantly limited or erroneous (0%)

16

Total 100%