Create a spreadsheet that will itemize the details of the training

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Budget for Professional Development for the year 2022:

 

You have been asked by the owners of the clinic to prepare a budget for the funds you would like to spend on your employees for Professional Development in 2022. 

Create a spreadsheet that will itemize the details of the training and total each type of training include a grand total for all professional development budget for 2022.

There are 3 different types of training: 1-In-service Sessions, 2-Continuing Education and 3-Block conferences. Your job is to enter all details for each category and total the cost f each category and then a grand total for all of them. 

Open the spreadsheet: ProfDeveopBudget, and save it as: ProfDeveopBudget_YourName.

Create a documentation sheet explaining why you are creating this spreadsheet and include the date, your name and student number. Add a header with the file name code in the middle; and a footer with your name and student number. 

Make sure you have 2 sheets: 1-Documentation and 2-Data. (you will need to rename the sheets from --Sheet1 and Sheet2)

On a new sheet called: Data Sheet, enter the details, (some of the details are entered for you):

1. There are 15 in-service sessions to be run throughout the year, and they cost $60.00 per session

2. The continuing education courses are: 

(1) 18 for doctors at $350.00 per course

(2) 30 for nurses at $295.00 per course

(3) 12 for respiratory therapists at $185.00 per course

(4) 14 for anesthesiologists at $192.00 per course

(5) 11 for radiologists at$195.00 per course

(6) 10 for physical therapists at $160.00 per course

(7) 10 for management staff at $150.00 per course

(8) 10 for support staff at $135.00 per course

 

3. The hospital buys block registrations for the following conferences:

1) AMA annual conference $6,500.00

2) Nursing conference $5,750.00

3) Respiratory Conference $4,100.00

4) Radiological Society conference $2,250.00

5) Anesthesiologists conference $3,700.00

6) Physical Therapy conference $1,775.00

7) Hospital association conference $1,950.00

You will need to use simple functions, such as SUM to create a total for each category of training, then a grand total at the bottom of the sheet for all 3 categories. For the grand total: be careful to add only the totals from each category not the details. 

Formatting:

Format the data sheet the way you like, but it must contain: 

• Use cell borders; fill colour; different font styles, size and colour of fonts; cell alignments and any other formats that you would like

• Make sure all dollar amounts are formatted as currency (using $, not foreign currency) 

• Insert the clinic logo in the upper left corner of the data sheet – size it to make it fit and look professional, be sure to keep the “aspect ratio”

• The heading can be formatted as you like; but it must be centred, line by line over the spreadsheet

• Insert an appropriate picture or graphic from the internet and be sure to cite where you found it

• Apply conditional formatting to the price of the conferences to show graphically the cost of the conferences

• Don’t forget to check your Spelling 

• Review how each sheet will print out, making sure to use the proper paper size, NOT A4

• You can decide to use either Portrait or Landscape Orientation

• Keep the Data sheet to fit to one page

Final:

• The final workbook should contain 2 sheets: Documentation Sheet and Data Sheet

• Remember to save it as: ProfDeveopBudget_YourName and upload it to e-Conestoga

 

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of