Week 7 Assignment
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
Upload the completed assignment files in the Assignment area.
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-Danish Employment Training Services 4245 Carvine Dr. Miami FL 33131.0 685,000.00
Coyote County Educational Services 6921 1st Ave. W. Brookfield WI 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 Professional Outreach and Training 68 Brittany Rd. Lexington SC 29072.0 643,300.00
Mickens Health Services Training 4211 Cohen Dr. W. Milwaukee WI 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. Miami FL 33131.0 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 CA 91711.0 627,500.00