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. 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. Research the internet for more information related to this statistic. Provide the URL and a brief description.
Upload the document with your answers to Tasks, Tests and Surveys.
You will research costs at different universities 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.
1. Start Excel. Enter a title in cell A1: University Statistics
2. Put your name in cell A2
3. 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.
| Name | Tuition | Mandatory Fees | Room and Board | Number of Undergraduates | High School GPA |
4. Go to http://education.yahoo.com/ and click on College & Grad School. Locate the information above for 10 different universities and type it into Excel. You can do this part with another person to make the research faster.
5. Sort the rows of college information (records) in descending order by tuition.
6. Use a function to calculate the Average for columns B through F in row 14
7. Use a function to calculate the Median for columns B through F in row 15
8. Format the worksheet to look attractive.
Merge and center the title
Use appropriate number formats.
Add at least one border.
9. 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.
10. Save the worksheet as Dec5 (with the filter still applied).
Upload to Tasks, Tests and Surveys.