40 points. Due November 16. Late submission deadline November 30
Reading:
In this assignment you will create a worksheet showing the number of occurrences of identity theft for the top ten states for 2006 through 2003. Then you will examine rival causes.
1. Go to the Federal Trade Commission's Identity Theft data at http://www.ftc.gov/bcp/edu/microsites/idtheft/reference-desk/national-data.html . This site provides data about identity theft on a state by state, year by year and metropolitan area basis.
2. Click the PDF link under the heading FTC Compliant Data, ID Theft Clearinghouse Data January 1-December 31, 2006. A file should open with the 2006 data. Go to page 9 to see the identity theft data by state. Print the page or write down the state names and numbers of victims per 100,000 in the top 10 states.
3. Open a new Excel workbook.
4. Click in cell A1 and enter a descriptive title for the worksheet. The worksheet will show the number of ID Thefts per 100,000 people in the top ten states.
5. Starting in cell B2, enter the years 2006, 2005, 2004, 2003.
6. Starting in cell A3, enter the state names down the column.
7. Enter the data for 2006.
8. Go back to the list of PDF files for each year. Open the PDF file for 2005. Locate the identity theft data for the same 10 states.
9. Enter the data in the 2005 column of your worksheet.
10. Repeat to fill in the columns for 2004 and 2005. Be careful not to get the Fraud data per state instead.
11. Save this worksheet as Task11. You will work with it again in the next Task using formulas, formatting and charting techniques.
Upload to Tasks, Tests and Surveys.
Answer the following questions in a Word document called Task11.
1. (2 points) Look at the worksheet you just created about identity theft. Describe the general trend over the years. Refer to specific data from your worksheet in your answer. Your answer should be a few sentences, not one word.
2. (6 points) Give three possible causes for this trend. Use evidence you find on the Internet or from your personal life.
3. (4 points) Do you think this trend will continue? Why or why not?
Read "Dropouts: A real problem for U.S."
4. What is the issue? It should be a question that the conclusion answers.
5. What is the conclusion?
6. (5 points) What are the reasons?
7, 8 and 9. (4 points each) This article doesn't present an explanation of WHY dropout rates are high. Search the Internet to find 3 different causes for the high dropout rate. For each, provide the following:
a. The title of the page
b. The URL
c. (2 points) A brief description of the cause
Upload to Tasks, Tests and Surveys.