Study Guide Exam 2
Study Guide Exam 2 INFO 1010
Popular in Analytics 1: Data Management and Analysis
verified elite notetaker
Popular in Business
This 7 page Study Guide was uploaded by Alexandra Tilton on Saturday October 24, 2015. The Study Guide belongs to INFO 1010 at University of Denver taught by Professor Gisella Bassani in Fall 2015. Since its upload, it has received 156 views. For similar materials see Analytics 1: Data Management and Analysis in Business at University of Denver.
Reviews for Study Guide Exam 2
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/24/15
INFO 1010 Data Management and Analysis Study Guide Exam 1 ProsCons and Examples of 39 Infrastructure 0 Human IT Infrastructure the human resources required to con gure operate and maintain the IT components and applications 39 Sustainable MIS Infrastructure 0 Grid Computing Group of computers geographically dispersed designed to solve the same problem 0 Virtualised Computing Multiple virtual machines on a single computing device Uses a Data Centre facility used to house information systems and associated components reduces emissions space needed and you can choose the geographic location 0 Cloud Computing Ondemand network access to a shared pool of con gurable computing resources requires minimal management Multitenancy single instance of a system serves multiple customers Single tenancy each customer or tenant must purchase and maintain an individual system Cloudfabric The software that makes possible the bene ts of cloud computing 39 Infrastructure as a Service 0 Offers computer hardware and networking equipment on a payperuse bases Example Amazon EC2 Alexandra Tilton Page 1 of 7 39 Sustainable Technologies 0 A lot of our technology is causing a lot of wast 0 Moore s Law Computer chip performance per dollar doubles every 18 months 0 Sustainable MIS production management use and disposal of technology in a way that minimises damages to the environment 0 Corporate responsibility businesses have a responsibility to the community and environment 0 M18 disposal Safe disposal of M18 assets at the end of their lifecycle 0 When left on continuously desktop computer can consume at least 100 watts of power per hour 39 Database including Primary and Foreign Keys 0 Databases process data far far faster than spreadsheet 0 Databases are relational they relate tables together 0 DBMS allows users to create read update and delete data in a relational database 0 Primary key the unique attribute that helps identify you in a system 0 Foreign Key A primary key showing up in a different table 39 Business Intelligence 0 Any information that pertains to anything related to the business for strategic decision making 0 Collected through research studies surveys experiments etc 0 Collection of tools include reporting data warehouse analytics data mart knowledge management decision support etc 0 In visual form infographics data visualisation Alexandra Tilton Page 2 of 7 39 Ethics 0 Some things are not illegal but are immoral 0 Companies need to abide by the ethical rules in the company s country of origin 0 Government can create laws to guide ethics 39 Security 0 IT department C10 C50 and anyone dealing with data needs to maintain security 0 Risks include hacking data breaches etc 39 Privacy 0 CPO Chief Privacy Of cers 0 If privacy is violated companies need to do a lot of damage repair 0 Employees give up a lot of privacy by bringing their computer to work it now is the companies 39 Cyber Security 0 Spearphishing An email that appears to be from an individual or business that you know but it isn t Hackers that want bank account info and other private info 0 CryptoLocker A ransomeware trojan that locks les on your computer and then displays a message telling you that you have to pay an amount of money to get everything unlocked 0 Malware Any software used to disrupt computer operation gather sensitive information or gain access to a private computer 0 Botnets a number of internet computers that without consent of the owner have been set up to forward spam or viruses to other computers 0 Spoofed email compromise The forgery of an email header so that the message appears to have originated from somewhere other than the actual source Alexandra Tilton Page 3 of 7 0 Hactivists The subversive use of computers and computer networks to promote political agendas or ideology 0 Internet Criminal Complaint Centre Mechanism to report fraudulent online activity 0 lnfraGard Government and private sector alliance developed to promote the protection of US critical infrastructure 0 Membership is free 0 Access to threat information on secure website 0 Free or discounted seminars and conferences 0 Before an intrusion occurs 0 Maintain as much log information as possible 0 Back up often 0 Keep different backup versions 0 Turn on rewalls 0 Maintain intrusion detection software 0 Use STRONG passwords 0 Best Practices 0 Be suspicious of unsolicited content 0 Pay attention to the URL of a website 0 If you are unsure if an email request is legit verify by contacting company 0 Install and maintain antivirus software firewalls and emails filters De ne Give ExampleCalculateCreate 0 Variable Scale 0 Categorical Nominal No intrinsic ordering to the categories example gender 0 Ordinal Similar to nominal categorical but have a clear ordering Can be numerical or notexample low medium high Alexandra Tilton Page 4 of 7 0 Interval The interval between values is important example SAT score 0 Ratio The ratio between values and there is an absolute zero example K scale of temperature 0 Histograms 0 Used to show frequency distribution for quantitative data over a set of class intervals 0 Example from project on how to create histogram 1 Select one indicator one year all your countries 2 Copy paste to new worksheet 3 Create a pivot table 4 Put Year in Rows 5 Put Country Name in Values 6 Select Count for Country Name 7 Right click and select Group 8 Sturges Rule llt133LOGCount of xxx 2 8 bins 9 Starting at 0unless it doesn t make sense for your indicator 10 Cannot have gaps in pivot table 11 If you need to add an extra bin you copy paste as values and then edit you cannot edit a pivot tablequot 12 Insert a 2D Column Chart 13 Add necessary titles formatting etc 14 Each column should have a boarder 0 Bar Graph 0 A chart that presents grouped data with rectangular bars with lengths proportional to the values they represent Alexandra Tilton Page 5 of 7 Alexandra Tilton 0 Histograms have gaps between columns whereas bar charts typically do not Scatter Plot 0 Shows each data point as a dot on a graph 0 Easy to see correlation from scatter plot 0 Use insert scatter plot 0 Then select the data you want to use Pie Chart 0 Shows data as a part of a whole circle 0 Sometimes not as easy to read as histograms due to angle of the pie chart 39 Use insert pie graph 0 Then select data Timeline 0 Shows how a variable has changed over the years 0 xaxis should be years of time 0 yaxis is the variable you re showing Frequency Distribution 0 A table that shows how frequently a value occurs 0 Use pivot table to create these 0 Choose count of rather than sum of to show how often a value occurs Pivot Tables as a tool for above 0 See above frequency distribution Pivot Table for a crosstab data 0 A pivot table can have multiple levels to show various combinations of data 0 Example what we did in class when we wanted to see how many homes were both above the sale price AND had a number of bedrooms or bathrooms above the average Population vs Sample Statistics 0 Population contains all the elements from a set of data Page 6 of 7 0 A sample is one or more data sets from the population 0 Mean 0 The average of the data 0 Use AVERAGEdata 0 Median 0 The middle number of the data 0 Use MEDIANdata 0 Mode 0 The most frequently occurring number in a data set 39 Use MODESNGLE Alexandra Tilton Page 7 of 7