ITCC WK7

· Assignment List

 

· Week 7 Assignment

Week 7 Assignment

DUE: Jun 23, 2019 11:55 PM

Grade Details

Grade	N/A
Gradebook Comments	None

Assignment Details

Open Date	May 6, 2019 12:05 AM
Graded?	Yes
Points Possible	100.0
Resubmissions Allowed?	No

Top of Form

Assignment Instructions

The scenario:

The Prime National Properties Group is considering selling some of its educational facilities. The facilities have been tracked in an Access database. Shelly Williams, the President of the company, has asked you to prepare a report. Import the Access data in the file Facilities_Data as a table into Excel. Using the PMT function, calculate the monthly payments the company could expect. The company would charge an 8% rate over 10 years. The result should be a positive number. Mr. Williams also asked you to calculate an extra processing fee for monthly loan payments using the IF function. If a monthly loan payment is less than $6000, the company would charge a processing fee of $150; otherwise, there would be no processing fee. Filter the rows to display only those facilities where there is a $0 processing fee. Hide all of the address fields and the processing fee column. Save the Excel file as Lastname_Firstname_Educational_Facilities

For this assignment, you will need the following files:

    New blank Excel workbook

    Facilities_Data

    Educational_Report

You will save your files as:

    Lastname_Firstname_Educational_Facilities

    Lastname_Firstname_Educational_Report

1. Open the Word document Educational_Report, and then save the file as Lastname_Firstname_Educational_Report

2. Add a cover page of your choice, and then complete the content controls on the cover page.

3. In the report, format headings as Level 1 or Level 2, and then insert a table of contents on a new page.

4. In the worksheet, hide all of the address fields and the processing fee column

5.  paste the Excel data into the Word document.

6. Add an appropriate heading formatted as Level 1, and then update the table of contents.

7. In each file, insert the your name as a field in the footer

Upload the completed  assignment files in the Assignment area.  

· Special Instructions: Use the Supporting Materials below to complete the project.

· Grading: Please review the rubrics for particulars.

Grading Rubrics
Performance Level	Exemplary	Accomplished	Developing	Beginning	Points
Performance Element	You consistently applied the relevant skills.	You mostly applied the relevant skills.	You sometimes, but not always, applied the relevant skills.	You rarely or never applied the relevant skills.	10/10
Import data into Educational Facilities workbook, insert PMT and IF functions, and filter data	Worksheet table is created, functions are inserted, and data is filtered accurately	Worksheet table is created, functions are inserted, and data is filtered, but there are two or fewer errors	Worksheet table is created, functions are inserted, and data is filtered, but there are more than two errors	One or more items was not complete	Exemplary 10 Accomplished 7-9 Developing 4-6 Beginning 0-3   Points:
Insert cover page and table of contents in Educational Report	Cover page and table of contents are both created, table of contents is updated with new content	Cover page and table of contents are both created, but there are two or fewer errors	Cover page and table of contents are both created, but there are more than two errors	One or more items was not complete	Exemplary 10 Accomplished 7-9 Developing 4-6 Beginning 0-3   Points:
Copy and paste Excel data into Educational Report	Excel data is pasted into the Word report, Level 1 title is added	Excel data is pasted into the Word report with two or fewer errors	Excel data is pasted into the Word report with more than two errors	Excel data is not pasted into Word report	Exemplary 10 Accomplished 7-9 Developing 4-6 Beginning 0-3   Points:

Supporting Materials

·   Facilities_Data.accdb  (476 KB)

·   Educational_Report.docx  (14 KB)

Bottom of Form