Data Journalism Backup Site

Here is my optional tagline

Feb 14 Class

by | Feb 14, 2017 | Daily-Class, Spring_2017

All Fulbright faculty and staff have been blind-copied on this message from Teresa Waddell, Director of Technology for the J. William Fulbright College of Arts & Sciences.


twaddel@uark.edu

arscsup@uark.edu              

http://askit.uark.edu

 


Subject: Phishing Scam Targets Campus. Details, and How You Can Help.

 

As many of you are aware, the university has been the target of a new phishing scam. The scam email contains a link to a fake login web page, for either the Office 365 Web App, or the Google Apps interface.

 

The scam is getting past our usual protections because the scammers are using stolen UARK accounts and logging directly into our email system, thus bypassing some of the usual protections applied to external mail. 

 

The information security team has responded by scrambling the passwords of several accounts that have been used by the scammers. We are also coordinating with our Microsoft Exchange team on a technical response. A new security awareness program is also on the horizon.

 

When you login to any site, always check the web address in your browser’s URL bar to be sure it’s what you expect. If the web address in the URL bar isn’t what you expect, do not enter your password, and report the issue to the help desk or information security.

 

You will never receive unsolicited email from the University of Arkansas, Microsoft, or Google, asking for your account to be validated, or asking for other personal information. We never ask you to divulge your password; that’s only for logging into services.

 

If you think you may have accidentally given your UARK login information to any fraudulent site, change your password immediately by logging into the security site at password.uark.edu. If you receive suspicious spam or phishing email in your UARK account, forward it to abuse@uark.edu, and then delete it. You can learn more from our tech article on phishing scams.

Compare 2014-2010 Crime in Arkansas

This exercise will involve downloading, cleaning and comparing FBI crime data from 2010-2014

You will use a new command, VLOOKUP, to compare the cities in the two years sop you have an accurate comparison
—=vlookup is “find and replace” on steroids
You will use Text to Columns as a way to match disparate data sources
Step 1: Download FBI UCR Crime Data, one year, all Arkansas localities and all categories, 2014 and 2010
Step 2: Combine the 2010 data in the same workbook as the 2014 Data
Create Data Biography
Save as an Xlsx workbook
Step 3: Four Corners Test on the 2010-2014 data.
Do they match? How are they different?
Step 4: Fill in missing population data on 2014 Crime Data
Video: =vlookup and text to columns to insert population data
–Copy population data, 2014 Census Figures, into a new tab from this table:
–Filter population to blanks in 2014 Crime data
Use =vlookup to replace missing population values
A) Make sure the names match
B)TEXT TO COLUMNS: Split the names out in columns.
        DATA: TEXT TO COLUMNS. How many columns? Column per word. Create four new columns
        Clean up Fort Smith
     —DEFINE MATERIAL TO SPLIT UP
     —DATA | TEXT TO COLUMNS
     —DELIMITED then select SPACE
     —Replace contents with selected cells
Repeat for 2010 crime data
Step 5: Use Vlookup to compare the lists of cities in 2014 and 2010.
    –=vlookup Select City cell
     –Select range for search on other data table
      –Select the numbered column to search
      –False for an exact match
Bring the formula down, see which cities don’t match
Step 6: Edit the 2010 and 2014 crime data so they have the same cities
Create copies of the 2010 sheet. Edit it
Create copy of the 2014 sheet, edit it.
Step 7: Copy the 2010 heading and violent crime rate into a new tab
Copy the 2014 headings and violent crime rate into a new tab
Run =vlookup to make sure both match
Step 8: Calculate the absolute difference in the 2014 and 2010 violent crime rates
Sort desceding
Crime went up in which area since 2010?

Homework

Continue to work with the =vlookup exercises above. Look at both videos and follow along.

Read Ch. 6, Chapter6TheTruthfulArt