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
- Open the Word document Educational_Report, and then save the file as Lastname_Firstname_Educational_Report
- Add a cover page of your choice, and then complete the content controls on the cover page.
- In the report, format headings as Level 1 or Level 2, and then insert a table of contents on a new page.
- In the worksheet, hide all of the address fields and the processing fee column
- paste the Excel data into the Word document.
- Add an appropriate heading formatted as Level 1, and then update the table of contents.
- In each file, insert the your name as a field in the footer
The Prime National Properties Group is a member of the Educational Facilities Association, an association of the professionals involved in the planning, design, and construction of educational facilities across the United States.
Mission
The principal objectives and purposes of the association are as follows:
· To establish a means of exchanging ideas.
· To stabilize written communication between educational facilities.
· To stimulate professional growth.
· To promote research of new construction, new material, and new equipment to be used in educational facilities.
· To promote creativeness in planning and constructing educational facilities.
· To encourage the exchange of ideas between educators and facility planners in achieving a quality educational facility.
History
The Educational Facilities Association was started in the early 1950’s as a cooperative effort between a small group of educational facility managers and owners. The intent was to provide a forum for the exchange of ideas and promote cooperation between educational facilities. The association has evolved from its humble beginnings.
Conferences
Conferences, which were held once a year, focus on topics of interest to educational facility managers and owners. Early meetings were attended by approximately 50 people. In recent years summer conferences have been attended by over 1000 people. In 2003, the Educational Facilities Association expanded its activities with new programs:
Winter Conference
The Winter Conference highlights the excellent design capabilities of our Associate Members. It is held over a three day period in a southern state.
Summer Conference
The Summer Conference encourages qualified persons to choose a career of educational facilities management. It is a weeklong conference held in various locations throughout the nation.
Educational Facilities Association Presidents
We have been lucky to have great leaders in the role of President. Following is a list of past presidents.
· 1955-1969 Rae Gerhard
· 1970-1974 Alejandra Balentine
· 1975- 1978 Fernando Lopez
· 1979-1985Jamie Perrotti
· 1986-1999 Heidi Herrmann
· 2000-2006 Penny Rudder
· 2006-2007 Greta Myers
· 2007-Present Chandler Gaines
Educational Facility | Address | City | State | ZIP | Selling Price | |||||
---|---|---|---|---|---|---|---|---|---|---|
Leymons Test Prep Services | 730 S. Monte Park Pkwy. | Lake George | WI | 54501.0 | ¤ 435,000.00 | |||||
Patterson Testing Services | 10302 Heartfield Dr. | Oak Forest | IL | 60452.0 | ¤ 675,000.00 | |||||
Tanglewildd After School Services | 4591 Spinnaker Cove Way | Lincoln | NE | 68522.0 | ¤ 550,000.00 | |||||
Woodlake Daycare Center | 320 Lindon St. | Frankford | WV | 24938.0 | ¤ 895,000.00 | |||||
Miami | 4245 Carvine Dr. | FL | 33131.0 | ¤ 685,000.00 | ||||||
Coyote County Educational Services | 6921 1st Ave. W. | Brookfield | 53045.0 | ¤ 597,500.00 | ||||||
Maryland Mentoring Associates | 5491 Lynhurst Pkwy. | Coldwater | MS | 68618.0 | ¤ 713,500.00 | |||||
San Marcos Mentors | 412 Valencia St. | San Mateo | CA | 94401.0 | ¤ 651,200.00 | |||||
Service Computing Training | 900 Tech Dr. Suite 340 | Salt Lake City | UT | 84106.0 | ¤ 714,300.00 | |||||
University of Victory Outreach Center | 43 Educational Dr. | Tempe | AZ | 85282.0 | ¤ 385,000.00 | |||||
Douglas Training and Educational Center | 533 Lanceford St. | Dallas | TX | 75205.0 | ¤ 523,000.00 | |||||
Lexington | 68 Brittany Rd. | SC | 29072.0 | ¤ 643,300.00 | ||||||
Mickens Health Services Training | 4211 Cohen Dr. W. | Milwaukee | 53219.0 | ¤ 714,600.00 | ||||||
Indian Training Institute | 860 Brilliance Way | Evansville | IN | 47740.0 | ¤ 552,000.00 | |||||
Cherise Career Center | 9653 Jackson St. | Cincinnati | OH | 45221.0 | ¤ 399,900.00 | |||||
Allen Technical Training | 789 W. Main St. | Albuquerque | NM | 87110.0 | ¤ 604,500.00 | |||||
Zeno Centre for Health Occupations | 1111 Meadowbrook Rd. | Burlington | VT | 5401.0 | ¤ 479,000.00 | |||||
Test Prep Training Services | 2003 N. 14th St. | ¤ 708,000.00 | ||||||||
Basic Community Training Services | 176 Van Buren St. | Boulder | CO | 80026.0 | ¤ 848,900.00 | |||||
Crossroads Educational Partners | 690 Kings Highway Blvd. | Claremont | 91711.0 | ¤ 627,500.00 | ||||||