30 points. Due November 21. Late submission deadline December 4
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 2007 - December 2007. A file should open with the 2007 data. Go to page 19 to see the identity theft victims 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 2007, 2006, 2005, 2004.
6. Starting in cell A3, enter the state names down the column.
7. Enter the data for 2007.
8. Go back to the list of PDF files for each year. Open the PDF file for 2006. Go to page 9 to see the identity theft data for the same 10 states.
9. Enter the data in the 2006 column of your worksheet.
10. Repeat to fill in the columns for 2005 and 2004. 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. (4 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) Describe 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?
Upload to Tasks, Tests and Surveys.