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
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more