40 points due November 30. Late deadline December 14
Reading:
In this assignment you will examine evidence about textbook prices and create a worksheet showing where the textbook for this class can be purchased.
1. Read "Textbook costs puts students in a bind" at http://www.pjstar.com/features/x1031722317/Textbook-costs-puts-students-in-a-bind
1. Identify a statistic they use to support their argument
2. (2 points) Research the internet for more information related to this statistic. Provide the URL and a brief description
3. Identify another statistic used in the argument
4. (2 points) Research the internet for more information related to this statistic. Provide the URL and a brief description.
2. (3 points) Textbook rentals are a new trend.
a. Search the Internet for a textbook rental site. What is the name of the vendor and URL?
b. Locate a textbook that you had to buy for Fall on the site. What is the name of the textbook and rental price for the semester?
c. Would you use this option? Why or why not?
3. Online books are another way of combating high textbook prices. "Read Electronic books slow to catch on" at http://orient.bowdoin.edu/orient/article.php?date=2008-10-03§ion=1&id=5 . Would you like to use e-books for your classes? Why or why not?
Part 2 Database Worksheet (25 points)
You will research the cost of a textbook. You can choose the Asking the Right Questions textbook or any textbook you are interested in. Shop for the textbook online and create a database of your findings using Excel. Excel can be used as a simple database program as long as you have a limited number of records (rows) and do not need to print complicated reports.
a. Start Excel. Enter the textbook title in cell A1
b. Put your name in cell A2
c. (2 points) Enter the column labels below across row 3. Make the column wider or wrap the text (press Alt+Enter while typing) so all text shows.
| Seller | Price | Shipping | URL | Edition | Condition |
d. (5 points) Use online textbook sellers to find 10 different copies of the textbook for sale (new or used). Enter the data into the worksheet.
e. (2 points) Sort the rows of book information (records) in descending order by price.
f. (4 points) Use a function to calculate the Average for the Price and Shipping
g. (2 points) Use a function to calculate the Median for the Price
h. (4 points) Format the worksheet to look attractive.
Merge and center the title
Use appropriate number formats.
Add at least one border.
i. (4 points) A filter is used to display only those rows (records) that meet criteria you specify. Select the Tuition values. Click the Filter button in the Data tab of the Ribbon. Click the drop-down arrow that appears next to the first value. Click the Number Filters option in the menu. Click Below Average. Save the workbook as Task13 (with the filter still applied).
Upload the workbook to Tasks, Tests and Surveys.
Part 3 College Textbook Statistics Discussion 5 points
Write a short argument about college textbook prices in a couple of paragraphs. Answer the issue: "What should be done about the high cost of college textbooks?" or "Who is responsible for doing something about the high cost of college textbooks?" Make sure you have a clear conclusion and provide evidence to support your conclusion. Use at least one statistic from your research for this assignment.
Go to the Task 13 College Textbook Statistics discussion and start a new topic.
Make a title for your argument in the subject.
The body of the message should contain your argument.
Read another student's argument and respond to it. Do not just say "Good job" or "I agree." Say why you agree or disagree or why you think their argument is good or bad.
Type the name of the student you replied to in the answer box Etudes Tasks, Tests and Surveys.