Reference no: EM132209190

Question: In this assignment, you will use Excel to sort spreadsheet content in ascending order.

Part 1: Download and open the Excel spreadsheet below:

• File: Patient Fasting Blood Glucose Results Spreadsheet

The results you see in the spreadsheet are from blood sugar tests done on patients at Clinic XYZ in Tampa, FL, during the month of March, 2016.

1. Review the column headings and become familiar with the contents of the file. This is known as a "flat file," since there is just a single table.

2. Use Excel to perform a Data Sort on the field Glucose mg per dl, in ascending order.
Note: Be sure you avoid "scrambling" your data -- make sure you select the entire range as shown in the video. If you only select the column of data that you want to sort by, then only that data will be sorted and it will likely become disassociated from the rest of the data for that person. (Excel will even try to warn you if you try to sort but neglect to include adjacent data.)

3. After you have performed the Sort, double-check to make sure you did not "scramble" the records (make sure the Glucose values are sorted but that the same people are still associated with their original values).

4. Save your sorted Excel spreadsheet

Part 2: Use your sorted version of the Patient Fasting Blood Glucose Results Spreadsheet (from Part 1) to answer the following:

1. Which patient had the highest blood sugar?

2. Which patient had the lowest blood sugar?

3. Our medical director decided that all patients who have blood sugar of at least 110, but less than 120, should be sent a letter asking them to return in one month for a recheck lab test on blood sugar. What are the full names of all patients who should receive letters?

4. Patients with blood sugar level of 120 or greater should be called to make a clinic appointment within the next 3 weeks. What are the full names of these patients?

5. Patients who had blood sugar higher than 125 and already have diagnosed diabeteswill be referred to a dietitian. What are the full names of these patients?

6. Do you notice anything on this data sheet that might complicate follow-up plans for any of the patients flagged for follow-up? What is it? How could we help these patients? Assume the full street addresses is contained in a separate, patient demographics database.

Information related to above question is enclosed below:

Attachment:- Result.rar