by Nathan Smith | Mar 28, 2017 | Daily-Class, Spring_2017, SQL
Coding Time . Washington Post Graphics Small Business Career Fair SQL Is Fun Really. What does SQL stand for? What is SQL and Why Do I Need It? Relational database....
by Nathan Smith | Mar 20, 2017 | Student_Work
I first tried to link the data to the zip code sheet. I copied and pasted the zip code info into the workbook with the crime data. I made sure all entries had a zip code so it would line up properly, and I then tried to be creative and copy the zip code into the...
by Nathan Smith | Mar 15, 2017 | Student_Work
This map is really hard to read but if you look closely there are two Arkansas maps and some teeeeeennnyyy tiny cities. Basically, I used vLOOKUP* to pull the zip code info for the Arkansas cities into the UCR sheet. Then I had to manually enter the zip codes for the...
by Nathan Smith | Mar 15, 2017 | Student_Work
This was a complete fail for me. I tried Option #1 and was actually able to link the databases together, until I tried to mess around with them and I kept getting an error message. It says something about the data not matching. I tried linking the crime data with...
by Nathan Smith | Mar 15, 2017 | Student_Work
Overall I think my attempt at the assignment was a failure. After many attempts at linking the cities and counties in the FBI data to the zip codes in the zip codes workbook and Excel closing itself at one point, I was ready to give up. None of the options I tried...
Recent Comments