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.
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.
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