Reference no: EM131977171

The New Century Health Clinic for SLP 3 was also selected from the Shelly & Rosenblatt (2014) textbook, but it was copied below for convenience.

There is no need to look for the textbook as the assignment and questions are given here. For SLP3, you will develop mock-up report layouts and answer the analysis questions as necessary.

New Century Health Clinic

The associates at New Century Health Clinic approved your recommendations for a new computer system. Your next step is to develop a design for the new system, including output and user interface issues.

To complete the output and user interface design for the new information system at New Century, you should perform the following tasks and make assumptions as necessary.

Reports Requirements

1. Dr. Jones has asked you to create a monthly Claim Status Summary report. He wants you to include in the report layout the insurance company number, the patient number and name, the procedure date, the procedure code and description, the fee, the date the claim was filed, the amount of the claim, the amount of reimbursement, and the amount remaining unpaid.

2. He wants you to group the data by insurance company number, with subtotals by company and grand totals for each numeric field. When you design the report, make sure to include a mock-up report and write a short report analyzing how the information will be gathered and stored.

3. The second report is to design a layout including fields such as the daily appointment list and a monthly statement to make it readable and visually attractive. Include a mock-up report and a report analysis for each report.

4. The third report is to determine the data required for a new patient. Design an input source document that will be used to capture the data and a data entry screen to input the information.

5. What data validation checks would the clinic need for the new patient data entry screen (GUI design)? Write a brief memo with your recommendations.

Note: there are various medical report examples on the Internet that could be used to develop the SLP.

The SLP must be delivered in MS Word and consist of 2-4 pages displaying the proposed report mock-ups, layouts, and analysis questions, excluding cover page and references. You could use Excel for the mock-ups and layouts and copy the worksheets into MS Word.