40 Points Due date: December 13. Ends December 16.
Reading:
In this assignment you will:
Log in to Etudes and click the link for Tasks, Tests and Surveys. Click Task 12 and begin the assignment. Follow the on-screen instructions to complete the assignment and quiz. Once you click Finish there is no way to go back and change it. If you realize you have made an error you need to email me about it. You may complete the parts of the assignment in any order. You can enter and exit as you wish.
Part 1 Online Class Worksheet and Chart (20 points)
Create a worksheet and chart from data on the Web using the skills learned in Excel Chapter 1 in the Office 2007 textbook.
1. Go to the Harbor College web site at http://www.lahc.edu/
2. Click Faculty/Staff near the top right.
3. Click the Institutional Research link.
4. Click the 2008 Factbook/Planning Resource Guide link.
5. Click the link for Online Students under Special Populations and Programs. Locate the Duplicated Enrollment section toward the bottom. This shows the number of students in online classes in various departments.
6. Use the information to create a an Excel worksheet that shows the enrollment for each department by year with the following features:
a. Worksheet title typed in cell A1
b. Your name typed in cell A2
c. The department names down column A. You can copy/paste these from the PDF file.
d. The years as column headings across row 3. Do not make column headings for the percents.
e. Enter the enrollment data from the web page. Do NOT include the percentages. Enter a 0 instead of n/a.
f. (2 points) Total each department by using the SUM function..
g. (2 points) Total for each year by using the SUM function. Do not just copy the totals from the web page.
h. Change the cell style of the title. If you are using an earlier version of Excel, then change the font color, font size and font style.
i. Merge and center the title and your name over the data columns.
j. Use cell styles to format the column titles and totals row.
k. Adjust column widths as needed so all of the data is displayed.
l. (7 points) Drag to select the row and column headings and data. Do NOT include the totals. Create a column chart following the example in Excel Chapter 1 in the Office 2007 textbook. The department names are long and it will look better if they appear in the legend. Click the Switch Row/Column button. Move the chart under the data. Make the chart larger both horizontally and vertically so that all of the data and legends appear.
Save the worksheet as Task12 and upload to Tasks, Tests and Surveys.
The following is from page 669 in Understanding Computers:
According to a study by the Missouri School of Journalism at Columbia's University of Missouri, many Internet users are willing to accept spam in return for a discount on their ISP bill, and the study found that the users paying the highest rates for Internet access were more willing to trade spam for monetary savings. With the amount of spam-blocking taking place at the ISP level and the proliferation of third-party software to block spam, pop-up ads, and other forms of onscreen marketing, it makes one wonder what the long-term effect will be on online advertising and the Web in general. If these types of marketing techniques eventually become unprofitable, will free Web content begin to disappear? Is paying Internet users to receive spam or other types of advertisements a viable option? Would you be willing to pay higher rates for Internet access or pay for an increasing amount of Web content if you were guaranteed an ad-free and spam-free environment? Just as with television, some amount of advertising is typically necessary in order to support free content. What do you think is the optimal balance for the Web?
1. Search for a web page that addresses the issue of what to do about spam or pop-up ads. It should be one that no one else has posted about yet.
2. (4 points) Start a New Topic in the Task 12 Internet Advertising discussion. Put the title of the page in your subject line. In the body of the message, include the following:
a. The URL pointing directly to the web page.
b. A one-paragraph summary of the ideas on the page
c. Another paragraph where you give your opinion about spam and pop-up ads.
3. (1 point) Reply to another student's post and comment on their article and opinion. Note down the name of the person you replied to and enter it in the answer box for this part in Tasks, Tests and Surveys.
Part 3 Quiz
Answer 15 multiple choice questions on Chapter 15