CIS-110 Home http://www.c-jump.com/bcc/c110c/c110post.htm

Week 10 homework -- Microsoft Excel Doctor Appointments

1. Microsoft Excel Doctor Appointments
2. General Requirements
3. How to Submit

Microsoft Excel Doctor Appointments

• Here is your second Excel Spreadsheet Assignment, the Doctor Appointments worksheet.

• Your task is to create an appointment spreadsheet for a small doctor's practice as follows:

  1. Make spreadsheet title

     • using a different font;

     • using a different size;

     • using a colored background;

     • make it bold and italics;

     • the title should be centered;

     • the title should be in a merged cell.

  2. Next, there should be at least 4 doctors with the schedule of 20 minute visits. For example,

      

      

  3. Thus, the columns are for the 4 doctors.

  4. Each doctor should have the first and last name wrap in a cell (not shown in the sample.)

  5. Time slots for appointments are located in the leftmost column of the spreadsheet.

  6. The actual patient appointment times are entered on the resulting grid.

  7. Each entry for the patient's appointment must include patient's name and contact info. Both must fit in a single cell as shown in the sample above.

  8. Use a formula to count the number of patients that each doctor saw in a day.

     • Hint: Excel function COUNTA calculates the number of counting non-blank cells in a given range of cells. For example, the sample above uses formula =COUNTA(B3:B9) to compute the number of visits for doctor Scott.

  9. Highlight the doctor who saw the most patients with one color and the doctor that saw the least number of patients in another color. Try using Excel conditional formatting feature to make the highlighting work automatically.

  10. Based on the number of patients each doctor saw, use a formula to estimate how many patients they would see per week.

  11. If the cost of a visit is $100, how much will each doctor bring in over the week? (Again, use a formula to make your calculation.)

  12. Assuming the doctor saw this particular number of patients per week, use a formula to estimate how much would they bring in during a 50-week year.

   

General Requirements

• IMPORTANT:

• All computations must use formulas -- pre-calculated and hardcoded numbers will not be accepted for grading.

  That is -- I should be able to add or delete a visit in your grid schedule and see the changes instantly reflected in the total numbers of your spreadsheet.

• All dollar amounts should be formatted in currency.

   

How to Submit

• Attach your Excel file to the email and send it with the proper email subject line:

          CIS110 Homework 10 Lastname, Firstname
  

  Send your mail to the instructor: Igor Kholodov Igor.Kholodov@bristolcc.edu

• As always, your email must contain your last name (mandatory!) and first name (or at least first name initial.)