BMGT301 Intro to Info Systems INFORMATION SYSTEMS IN THE NEWS NSA tracking phone calls e mails etc No more privacy IBM Watson computer system that beat two champs with Jeopardy questions being used to help health care Info systems key in supply chain goods left at port in NY because of computer problems What Google knows about us Pretty much everything Websites vary prices based on their knowledge of how much money each browser has to spend Amazon Cloud failure takes down website THE CONSUMER PERSPECTIVE Your Information Systems Your Ops My iPhone my Mac etc Retail Information Systems B2C business to consumer Commercial Information Systems B2B business to business What one business uses to interact with another business Using eBay to buy industrial construction equipment Industrial Information systems Business Ops Robots supply chain systems Internal systems within a business Embedded and Hidden Information Systems Computers that we don t see In our fridge in our car in our toaster they are everywhere HOMEWORK due next Wednesday 9 11 One page in less than 200 words double spaced List reasons why learning about info systems is important to me or why it isn t important to me Submit via Canvas In terms of my career goals if I know them and my major field of study Excel and Pivot Tables 9 10 13 Access plug ins http highered mcgraw hill com sites 0073376841 student view0 tech plug ins html CONDITIONAL FORMATTING Use in excel to sort lists by greater than less than put graphs in AUTO FILTER Data Filter Allows you to filter out pieces from a column you don t want to see Just highlight the column and click filter then a little dropdown arrow should appear in the top right corner SUBTOTAL Can sort by subtotal of whatever group we want Just click on the data tab on top of the page and then sort subtotal PIVOT TABLES Data Pivot table Powerful built in data analysis feature Analyzes summarizes manipulates data in Large lists Databases Worksheets Other collections COMPONENTS 1 Columns 2 Rows 3 Data Values a Totals b Averages Excel IF Statement Goal Seek 9 12 13 INTRODUCTION IF Function used to conduct conditional tests on values and formulas Value of cell can vary based on the condition Goal Seek Function we don t know the value but we want excel to figure it out IF STATEMENT IF logical function Returns one value if a condition is true Returns another value if condition is false Compares two items in workbook if logical test value if true value if false LOGICAL TEST Value or expression that can be true or false VALUE IF NESTED IF Formulas can include IF functions Allows for nested IF functions IF A10 A 4 C 3 IF A10 A 5 C 4 IF A10 A 6 C 5 C 6 B10 If value of A10 is less than the value in A4 then use the value in C3 The reason for the is to make sure that value in A4 always stays constant Translation if value in A10 is less than A5 use the value in C4 if A10 is less than value in A6 use the value in C5 otherwise use the value in C6 Whichever value you end up with C3 C4 C5 or C6 Plug in T2 GOAL SEEK Find a value in a cell that meets specified objective Example new house purchase I can pay 1500 per month in mortgage payment what kind of houses can I afford Data What If Goal Seek 9 17 13 Solver Function SOLVER Goal seek on steroids Can change more than one variable rather than goal seek which only changes one 1 Changes two or more variables within specified ranges 2 Finds closest solutions HOW TO Data Solver Fill in cells that have constraints and such SCENARIO MANAGER Scenario Set of input values and corresponding results from calculations Excel can save scenarios and reports The Data Asset 9 24 13 ANALYTICS To drive decisions and actions Uses Data Statistical and quantitative analysis Explanatory and predictive models DATA MINING mail to 1 Customer Segmentation who to sell expensive vs not expensive stuff to 2 Marketing and promotion targeting who will respond to emails vs who to 3 Market basket analysis 4 Collaborative filtering if I have other customers like you but you have yet to purchase a certain product I ll try to sell you that product you might like on Netflix 5 Customer Churn how many customers are leaving showing up 6 Fraud detection 7 Hiring and promotion 8 Financial modeling where are your investments how much are you saving do you have enough money Avoid Black Swan an event that happens which people previously thought couldn t be possible CAN TECHNOLOGY CURE US HEALTHCARE DATA RICH INFORMATION POOR GIGO garbage in garbage out Legacy Systems Mergers and Acquisitions Companies that buy other companies have M A teams that have marketing systems IT systems WHERE IS MY DATA Database single table or collection of related tables Database Management System DBMS sometimes referred to as database software Used for creating maintaining and manipulating data 10 1 13 ENTITIES RECORDS ATTRIBUTES Entity people places things transactions or events about which information is stored customers Instance one of an entity a customer Record a collection of data elements related to an instance of an entity Each row in a table is a record for an instance Attributes the data elements associated with an entity Columns in each table contain the entities attributes MULTI VALUED ATTRIBUTES Multi valued having potential to contain more than one value for attribute at given time Example dependents or children of an employee ENTITY RELATIONSHIP DIAGRAM A student can be a member of 0 or more clubs A club must have 1 or more members These are relationship descriptions sentence pairs between students clubs Three types 1 One to one 2 One to many or many to one 3 Many to many Student 1 m Club 0 m Member ONE TO MANY One instance of entity A can be related to zero one or more instances of entity B Each instance of entity B can only be related to one instance of entity A One customer can have zero one or many orders One order can only be for one customer MANY TO ONE Many instances of entity A are related to one instance of entity A Many items supplied by one distributer One distributer can supply many items ONE TO ONE One town has one mayor MANY TO MANY Have to break down many to many relationships into one to many ones WEAK ENTITY Can t be in table unless it has a corresponding entity Can t put an event in the table unless it has one or more sponsored clubs An order at restaurant can t be in table unless a customer ordered it RELATIONSHIP AND CARDINALITY Cardinality indicated by Shows specific number of entity
View Full Document
Unlocking...