 |
Group Activity 7 |
|
|
|
Group Activity 7 |
|
Please do the following at the beginning of every computer activity.
a. Open a new Word document. At the top of the document enter all group members names and last names, and Activity number.
b. Click on the Office Button in the upper left corner, then slide over "Save As". Choose either "Word Document" to save your document as a Word 2007 document or "Word 97-2003 document" to save your document in an early version of Word. If you are not sure which to choose, you should use "Word 97-2003 document". When you are working on your document in class, first save the document to the desktop by setting the "Save in" textbox to "Desktop". (Saving to the desktop makes it easy to retrieve your work when you are finished.) Your file name should be entitled something like "Group Activity 1". Last, confirm the save as type in the last box. (*.docx) is the suffix for a Word 2007 document. (*.doc) is the suffix for early versions of Word. When you are leaving the class, upload your saved document into your Group files folder in D2L. That way if you completed your activity you can submit it via d2l dropbox, and if you are not yet finished you can access the partially completed file via D2L to complete it later.
How to save your file: Always save your work as .doc or .docx format.
Where to save your file: When working in class, save it on your desktop. When leaving class, always save your activity in the Group Files under your Activity Group in D2L. All work must be saved here. Additional options of saving such as email or flash drives are only back up methods and should not be used as primary modes of saving.
How to submit your activity: Once you complete your activity you need to submit it through D2L's Dropbox, under the correct dropbox for your activity. To ensure that you get evaluated and get a grade, make sure you submit before the deadline.
Deadlines are strict, no exceptions. Late submissions are not accepted. Incorrect submissions, submissions which cannot be opened due to wrong file type, or corrupt files will not be graded and will receive a grade of zero. Plagiarism receives a zero as a grade and will be reported without exception.
Activity
|
|
Everyone shops, especially before the holidays!
It is common for stores
to offer items on sale at a certain percentage off. It is becoming
increasingly popular for stores to offer items at an additional percentage
off the sales price. This a copy of an ad from a Kohl's where
many items in the store were 50% off the original price. Senior Citizens
received an additional 15% of the sale price. |
1. a. Suppose you purchase an item from the
Trim-A-Tree shop for $75.00 (original price). What is the sale price?
b. Senior citizens (age 62 and older) were eligible for a senior discount. Assume someone over age 62 purchased the same item on sale (originally $75.00) and received an additional 15% off the sale price. What price do senior citizens pay for the same item from the Trim-A Tree Shop?
c. How much do senior citizens save in total on this item (absolute change)?
d. What was the senior citizen's total percentage savings (percentage change)?
e. As store manager, you are asked to make a list of sales items including their original price, the sale price (50% off) and price after the senior citizen discount (an additional 15% off after the 50% off). You are trying to attract more senior citizens to your store. Fill in the follow table in sample of savings.xls. Use formulas and fill the columns; don't just type in the answers. Paste the completed table in your word document.
f. Does the amount of savings depend on the price? Does the overall percentage of savings depend on the price? Explain.
2. a. Your boss says that the company is struggling and that he needs to cut your salary by 20%. He promises that in 6 months he will raise your new pay by 20%. Does this restore your original salary? Show your calculations.
b. If the salary was decreased by 20%, by what percent would it need to be increased in order to restore your original salary?
3. Last year, it was bad news: the value of your investment plunged by 50%. This year was much better: your investment increased in value by 75%. Over the two-year period, has your investment shown a gain or lost? Show your work.
4. The value of stocks can vary dramatically. Suppose a stock decreases in value by 50% one year. The next year it increases by 50%. By how many percent has the value of the stock changed over the two year period? Give your answer and briefly describe your reasoning.
