Using the Case Study below, determine the following:

. What criteria you would need to extract the data from the database?

. What the report would look like (data field titles) to best represent this case study?

. How should the user be able to sort the data (sort options) for further analysis?

Case Study: Dr. Bartlett is enrolled in a quality improvement initiative and has been collecting data for submission on the quality measures pertaining to

diabetes. He has asked you for a report that contains his patients who are over the age of 20 with a diagnosis of diabetes or gestational diabetes.

Using your knowledge of data storage and retrieval, and data mining techniques, design a report that will capture all pertinent information that Dr. Bartlett may

The design should include the following elements and can be turned in using Word or Excel:

. Define the criteria used to filter the information from the EHR (e.g. specific diagnoses)

. What data that would be displayed when the report is printed/displayed (e.g. patient name)

. Any sorting criteria that may be helpful (e.g. sort alphabetically by patient name