K201 Lecture Exam 1 Study Guide
K201 Lecture Exam 1 Study Guide BUS-K201 Computers in Business
Popular in BUS-K201 Computers in Business
Popular in Department
One Day of Notes
verified elite notetaker
verified elite notetaker
CSCI A110: Intro to Computers and Computing
verified elite notetaker
verified elite notetaker
This 17 page Study Guide was uploaded by Meghan Anand on Sunday February 1, 2015. The Study Guide belongs to BUS-K201 Computers in Business at Indiana University taught by George Telthorst in Fall2014. Since its upload, it has received 3005 views.
Reviews for K201 Lecture Exam 1 Study Guide
If Meghan isn't already a tutor, they should be. Haven't had any of this stuff explained to me as clearly as this was. I appreciate the help!
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 02/01/15
MIS Vocab Study Guide TERM DEFINITION REAL WORLD EXAM PLEDIAGRAMS Data WHAT Recorded Phone numbers of all customers facts gures Good Data Accurate Timely Relevant Just suf cient Worth cost Information WHAT data EX Averages presented in meaningful context Database WHAT Database 1 TablesFiles 1 Tables Employees transactions customers 2 Relationships 2 Relationships between customers and their among tables39 transactions and which employees took care of rows which transactions 3 Metadata 3 Data about the data how many employees are there PURPOSE keep track ofmultiple themes m 39 39 L r Employees transactions etc i V lelationshlps Selfdescribing 39 collection of gt3 39nte rated records s 39 g ows In Tables Metaat Spreadsheet WHAT Data w 1 theme Database WHAT Users employees Application 1 User Database Application Access provides application for System 2 Database employees to utilize for their needs Application DBMS Microsoft Access 3 DBMS Database Company s database containing tables 4 Database regarding employees customers transactions etc Sy5tem that makes Database Tablesi database data more QueriesJ Management 4 D lationshil successfuluseful quotREPWF39W System i Programs mmetadat j User ilDatabase Application lDBMS Database DBMS WHAT Program DBMS Products Database used to DB2 IBM Management 1 Create Access Microsoftpersonal DBMS System 2 Process SQL Server Microsoft 3 Administer Oracle Database Oracle a database MySQL licensefree a i Queries 39 cense from Application Code DB vendors g E I Microsoft Access I MW DBMS and Application Development Personal DBMS for small companies fewer than 100 users usually 15 SQL WHAT Standard lang for processing database Structured Query Language Database WHAT Tools for Administration Administratio admin Security which users are allowed access How n Development much access to the database Operation Saving to cloudhard drive BackupRecov Adding additional data ery Cleansing data Adaption Form USED TO Recordings of each employees personal info Read Insert Modify Delete data Report Query data using List of all products grouped by categories DBMS and display results in structured context Enterprise Process large DB2 SQL Server Oracle DBMS organizationalworkg roup databases Support 1000 users Personal Small applications Access there were others but Access put them out of DBMS Less than 100 users business like a bitch usually 15 LostUpdate When two users due to lack of version management Problem update a le but one s updates get lost once the other uploads his or her changes Database WHAT Collection of Collection of tables queries forms reports on Application formsreportsquerie transaction information sapp programs that process database Can have multiple appsusers Data Model Blueprint of the ER Data Model database Entity WHAT tool for constructing data models Relationship De nes entities and relationships Data Model Transform to Database ER Data Model Transforming 1 Entity tabes ER Data 2 Identi er Primary key eld model into Database 4 Normalize data 5 Represent relationships foreign keys 6 Add additional tables for NM one to many relationships Identi er Used in ER data models EX ID 5 Equivalent to primary key in the database the unique identi er Entities Component of ER Employees Data Models Customers Become Tables in Database Design Maximum Max of entities 1N one to many Cardinality required in NM Many to many relationship 11 one to one Minimum Part of ER Data Vertical bar on line least 1 entity required Cardinality models Oval on line entity is optional Minimum of entities required in relationship Attributes Component of ER Employees TableEntity Data Models Similar to Fields Phone Number Address lD AttributesFields Data Change made in Accounting changed to Accounting in Finance in one Integrity some rows but not row not all Problem all shows need for normalization see normalization def Crow s Feet Used in ER Data Studentmum bef Diag ra m M 0d 939 i 9 Student Name Shows 1N one to Him many or NM many Him to many Midl39erm relationships in ER modeling V Normalizing Converting poorly Data StrUCturEd table to Feb 1 EH JDHESGUFEDW IIEHIF IELD W 1E 2 good tables 7 Eh Dec 3121312 Ernithelovircom anacom 2E WHY Eliminate I I I IE U V p y I Redundancy U MalVF 3mg Ch au DUrC mPenyaegm 1E Bane July 391 F 2011 Ereenlet lourcomlpanymm H Department ll 95 iii El 31 if 1 rl it il emanating I goo Marketing I I EDD Information System51 SDLC WHAT Systems 1 De ne System Development Life 2 cyCIe 3 Design components 4 Implement System Traditional process 5 Ma39nta39n SYStem used to develop systems IEIIIEH 5 Phases of SDLC 1 De ne System 2 Determine requirements 3 Design system components 4 Implement System 5 Maintain System item ij Plan Appmved Requirements Proli cm EM Naml fizz Shange L Dal3955 pmnmmm businesspmcm lhereasnee edl it uvsetinfemnatlen western I nimmaii ui Egretem l 91 System User SDLC Step 1 De ne B39UEEHFES39H De ne Scope 1 M System Feasibility Pm CESS 39 39 5 em EBquot a sch e39d UI e goals and ampe te C h n i C a I l aeeas feasibility least acnedule organizational V technical Proiect team b arganraatlenall n Farm gprajlett team Plan praieet Technical Part of de ning Testing new cloud technology w prototype Feasibility system SDLC Whether existing IT is likely to be able to meet needs of new system Organization Part of de ning Will the technology work w the audience al Feasibility system SDLC Will new system t within the organization39s customs culture charter or legal requirements SDLC Step 2 Requirement 5 Analysis User interviews Evaluate existing systems Determine new formsreportsquerie 5 Identify new app featuresfunctions Consider security Make data model Con derS components hardware software data people procedures I l ll tl l pmth F39llan Appraised Chandiuet Lieer interviews 8 REM FEW Evaluate eeating ayatkema ietermine new tarmafreaertaftmeriea ldenti r new applieatien features and funetiena a Cenaider aeeurity Create the data matlel Cmnsider all ve campenema amperage nt De gn 1quot 39I39muaquot ll SDLC Step 3 Determine I Appmyed USEF Component hardwareprogram R V iEiiiiLlIFPi iiEthE DeSIgn speCI catIons x depends on source a V i a a Eern inherit lDesm I1 Design database P g Des39gn Proce jures Determine hardware creatle 10b SpECi C t i nS dE n39t39ons w eterrnine pregrarn Implementat Speei ieatiens depends en seereel a eeign the database a Deeign pr eeedures w Create jel e de nitiene Prototype WHEN requirement analysis Assess usability Provide evidence of technicalorganizational feasibility Create more data that can determine costs can be expensive but worth cost often Phased Part of implementation Installation Integrate new system into phases New systembusiness process installed in phases Pilot Type of system conversion part of implementation Installation New systembusiness process installed on Imtd portion of business Parallel Part of expensive running 2 systems more work Installation implementation New system runs parallel with old system until new system is tested and fully operational Plunge Type of system rislql bc new stuff can fail should be avoided Installation conversion part of implementation Shut off old systembusiness process and start new one System Part of TYPES Pilot phased parallel plunge Conversion implementation Changing from quotoldquot to quotnewquot Test Plan Part of implementation Formal description of system39s response to usemisuse scenarios SDLC Step 4 Build system Fpssnentg SHE EEI T I lmplementati components esigin on Conduct unit test V Integrate components Conduct integrated s Emilia semen tCESt t t enmpenents onver 0 new Eenduet ILH39IIt test system V m Integrate Implement IS Eimllj mi components Eenduet intrated test ltwp39bemlent 395 and u Ceneert39td HEW e usmess system processes that use that system Eietennine Selectedthe l Design IE39ElQIII39II userand Beeelep use hardware shelf anagrams 1 database aperariians and GPEI EIIEEE spesifieatidns Design and related preced39ures jeb deseriptl 139 allteratiens and ETFLJIETLJ FEE easternI parag rams as HEEEHEIIWE i stain License an Create esument Hire and trai installl Install effthe database preeedmes pe rsannel and test shelf anagrams IFiIlwith Ereatefraining hardware Write data Fragrarns an 1m alteratiens and l quotfestdata Hesiewandtest custard prdeedruires pregrams Test dregrams Work WHAT Break project into smaller tasks until each task is small enough to Breakdown estimatemanage Structure WBS Deliverables Products of individual tasks broken Documents prototypes data models down from WBS database designs Gantt Chart Shows tasks dates dependencies in WBS Critical Path In WBS the sequence of activities that determine the earliest date by which the project can be compIeted considers the longest path and compresses tasks Can be analyzed by Microsoft Project Critical Path Project managers compress schedule by moving resources usually people Analysis from noncriticaI path tasks to critical ones TradeOff Balance 3 critical factors 1 Requirements 2 Costs 3 Time Diseconomie WHEN adding more resources More workers more people to pay 5 of Scale creates inef ciencies Brook39s Law States that adding more ppl to late project makes it even later Baseline WBS Shows planned tasks dependencies durations resource assignments Con guration Set of management policies practices and tools that developers use to Control maintain control over the project39s resources Bl Business COMPONENTS OPERATONAL DATA not in data warehouses Intelligence WHY dirty data System Wrong granularity too ne not enough Missing information inconsistent Misspellings Too much dataattributesdata points Primary Activites Operational Dam Q Q Q Social Data 39 Obt oooooo0 00 am I v v Knewledgi Cleanse39 Pu1chased ata 1 O O O Worker39s organize Q Q Q 0 a 39 Business 0 Intelligence Em lo ee Knewled e l a 1533 o 0 go 0 O l i x Pr1mary Act1v1t1es in the BI Process report automation Automation Push pUShpU M andle I if published to be 333ij actionable Data FUNCTIONS Purpose Warehouse 0 Obtain o CIeanse operational OrganizeRelat Employees shouldn39t have direct access to data Mistakes w queries D operation shut down Designed for quickaccurate processing not analytics Analytics D high processing power affects customer expedence o D Catalog jomponenta of a Data Warehousr r s a I Production Dita Databases are ous Data Extractioruti Data Business cleaning Warehouse Intelligence Preparation DBMS Tools 1 Programs Eusiness Iintelil i gence Users Commit mott Pearson Eduta un Data Mart WHAT smaller than data warehouse addresses needs of particular department functional area of business 53 Data 7 Weh 39 t 39 g Larehou A 7 J39 r 39 small design fee etaioaseg Dalia quot Web Saies Data Mart Store Sales 39ata Mart 51mm r bl gangs 3H 1 gt777 analyslsfo Data 5 training lg inventory VEWEEWUW I layout LE Heme foroptima Data item pickir Intrantory Data Mart Data Mining TYPES Supervised regression analysis neural networks Unsupervised cluster analysis market basket analysis decision trees Supervised Data Mining WHAT Model developed prior to analysis TYPES Regression Analysis Neural Networks Regression Analysis measures the effect of a set of variables on another variable predict cell phone usage based on age and of months on phone plan Neural Network predict values and make classi cations of prospective customers Unsupervised Data Mining WHAT Apply app to data observe results create hypothesis AFTER analysis TYPES Cluster Analysis Decision Trees Market Basket Analysis See what items are bought together Market WHAT Type of See what is the probability that customer will buy Basket Analysis unsupervised data mining used to determine sale patterns TERMS TO KNOW support con dence crossselling product X if heshe has bought product Y already looking at customers and transaction history CrossSelling Noticing that those who buy X will also buy Y People who buy shampoo tend to also buy conditioner crossselling opportunity Support WHAT In market basket analysis the probability that 2 items will be purchased together There is a 10 that milk and eggs are bought together out of all customers Con dence WHAT In market basket analysis the probability that a customer who bought item A will also buy item B If someone has bought milk there is a 20 chance that they will also buy eggs Lift Ration of con dence to the pase probability of buying an item Decision Tree WHAT hierarchal arrangement of criteria that predict a classi cation or value unsupervised Used to classify loans Shown in hierarchal arrangement Neural Type of Supervised Data Mining Networks predict values and make classi cations of prospective customers Regression Type of Supervised Data Mining Analysis measures the effect of a set of variables on another variable predict cell phone usage based on age and of months on phone plan Knowledge WHAT creating value fr Intellectual TYPEs Hyper Social Knowledge Management capital and sharing w those who Management expert systems Systems need it Content Management Systems Expert WHAT type of Information on performing surgery gives classi ed Systems knowledge detailed procedure management system ruIe based system purpose is to directly capture employee expe ences Terms to know IfThen rules FAILURES Dif cultpricey High labor hours interviewing experts High maintenance Didn t live to expectations lfThen rules WHAT Used in Medical expert system for diagnosing heart disease expert system statements that specifyif particular condition exists then take action Expert WHAT Programs that System process a set of Shells rules process rules until no change in value Content WHAT type of KM IS WHO Companies who sell complicated products that Management that support the need to have knowledge readily available to System management amp customersemployees delivery of docs EX Toyota including reports web pages Challenges expressions of HUGE databases employee Dynamic knowledge Docs not isolated must manage connections Need to be constantly updated Need to provide in many langs Hyper Social WHAT Application of social media for organizationdelivery of organizational Knowledge knowledge resources rich directory FROM WHERE Blogs wikis surveys directories social media RESISTANCE employees don39t want to seem ignorant don39t want to compete Rich Employee directory Microsoft Active Directory Includes standard personal info organizational structureexpertise Static WHAT Fixed time Printed reports Reports of creation Dynamic WHAT Updated time they are requested Reports Push WHAT Set to Facebook noti cations Publishing automatic delivery to user Pull WHAT Users must Going into email account instead of getting email Publishing pullrequest info noti cation Moore39s Law WHAT of transistors per inquot2 on integrated chip doubles every 18 mo NOT speed SIGNIFICANCE Cost of data communicationstorage virtually free Tradable Job WHAT Not location Technical Comp programmer database admin dependent can be outsourced Nontechnical sales support management MIS Managemen t Information Systems WHAT Use of IS to help organizations achieve strategies ELEMENTS 1 Manage amp Use 2 IS 3 Strategy System WHAT Group of components that interact to achieve purpose Information System WHAT Component groups interact to produce info I l 5 Component WHAT Components l etruetiehe System of IS 7 a 1 Hardware Erldg 2 Software l I 3 Data I If 1 4 Procedures ardwere Date I Preeeduree I eeele 5 PeopeMost important v r a r 1 T Eemputer Side lHlurrrerI Side ltuturrlel39irrl meuee werk frerrl human elde te eemputer Sir nereesirlg degree efdif eulty ef change Information WHAT Products CAN be bought Technology methods inventions Information Systems CANNOT be bought IT and standards used for the purpose of producing information Hardware Software Data Byte WHAT Character of EX quotaquot Data Fields WHAT Column Employee39s phone number in the employees table Record WHAT Row Single employee and hisher info Table WHAT le of similar Employees contains info about each employee such rowsrecords as hire date fulltime or not etc Primary Key WHAT What Randomly generated D columngroup or columns that identi es unique row in table In every table Order of Organization in Database Bytes D Fields D Records D Table Ietters Employee Phone 5 l Individual39s Employees Table Foreign Key WHAT Keys of different table than one in which they reside Relational WHAT carry their data in tables and represent relationships using foreign database keys Metadata WHAT data about Design View eld size data type data Cooperation WHAT Group of Group of painters each painting diff wa people working together doing same type of work to accomplish job SIGN Will getjob done quickly but not better in quality most often used in student groups Collaboration WHAT Group of people work together to achieve common goal via FEEDBACK and ITERATION Create draft someone reviews draft etc Iterations stages SIGN Diff perspectives high result quality 3 CRITERIA FOR SUCCESSFUL COLLABORATION 1 Successful outcome 2 Growth in team capability create better work processes 3 Meaningful experience 4 PRIMARY PURPOSES 2 Make decisions 3 Solve problems Manage projects Types of Decisions 1 Operational 2 Managerial 3 Strategic iructu red tructu rad Operational Managerial Strategic Operational Decisions WHAT Support operational dayto day activities Structured Process How many widgets should we order from vendor A Should we extend credit to vendor B WHAT about allocationutilization of resources Unstructured and Structured processes Managerial Decisions How much should we budget for computer hardware How many engineers should we assign to project B Strategic Decisions WHAT support broadscope organizational issues Almost always collaborative Unstructured process Should we start a new product line Should we acquire company A Decision 1 Unstructured Processes 2 Structured ll iruttured E ll quot l l I ll l 2gvg I E trutturEd cii ha iv a0 l l D articmal Managerial Strategic Structured WHAT there39s There is a given formula to record the quantity of a Decision understoodaccepted product Process method for making the decision Don39t usually involve collaboration Unstructured WHAT No agreed Predicting the future direction of economystock Decision upon decision market Process making method not How well suited employee is for a job standardized collaboratio n is CRUCIAL Problem WHAT Perceived Poorly de ned difference between Need to reduce operational expenses what is and what ought to be Well de ned probems Reduce operational expenses by 10 perceptionsD people can have diff problem de nitions Important for collab group to DEFINE problem Project 1 Starting 1 Set scope budget roles rules Management 2 Planning 2 Determine taskstask dependency sched Phases 3 Doing revise budget create list of alternatives and 4 Finalizing evaluate proj data needs to 3 Perform tasks solve problems report progress be stored throughout 4 Determine Collaboration WHAT IS that supports collab System Have same components hardware software data procedures people Hardware the cloud Types of 1 Project data Collaboration 2 Project metadata Data subject to feedback and iteration Project Data WHAT part of collaboration39s work product Design documents of new product Project Metadata WHAT used to manage project Docs of scheds tasks budget Collaboration Tool WHAT Program component of collaboration system The softwa re Synchronous Communicati WHAT when all team members meet Conference calls Facetoface meetings on same time Asynchronou WHAT team Email discussion forms team surveys 5 members do NOT Communicati on meet same time WHY employees work diff shifts time zones Virtual WHAT Ppl don39t Email discussion team surveys conference call Meetings meet at same webinar multiparty text chat screensharing placesometimes time Screen WHAT Lets users Of ce 365 ync sharing view the same Applications whiteboardappdispl ay Webinar WHAT virtual WebExused for virtual sales presentations meeting attendees view another39s computed screen Videoconfere ncing WHAT used when everyone on team as camera more intrusive than text chat Microsoft Lync Discussion Forums WHAT 1 member posts entry others respond better than email bc less likely to get offtrack but easy for some members to not participate Team Surveys WHAT 1 creates list of s others respond Obtain opinions Easy to complete Most will participate Easy to determine who didn39t respond Surveymonkey File Server WHAT computer that stores les A collaboration tool probem member A and B can download doc edit and reupload wo FTP other knowing Version Management WHAT Track changes to docs and provide featuresfunctions to accommodate concurrent work GoogIeDrive Windows Live SigDrive Google Drive WHAT free version management tool virtual drive in cloud Google account and gmail different Windows Live WHAT free version management tool can share Of ce les SkyDrive Offers quotOf ce Web Appsquot licensefree Web application Need Windows Live ID or HotmailMSN email account 7 GB storage Only 1 user time can open for editing Version WHAT process when Activity description in respective order Control the collab tool lmts or directs user Members assigned speci c permissions read activity lacking in only permission version When checked out doc cannot be edited by management anyone else systems w iteration will try to keep track of diff versions manage activities in prede ned process Types of Activities Permission Lmtd activity Document checkout Version History Work ow Control Library WHAT shared docs placed in shared directories Sets of 1 Minimal Collaboration Collaboration 2 Good Collaboration Tools Comprehensive Collaboration Minimal WHAT minimal set School group projects Collaboration of tools IittIe Tool Set software support COMMUNICATION Email text chat collaboration via text CONTENT SHARING only free easy to TASK MANAGEMENT learn little value for LMTS All text no tool integration professional business Good WHAT more COMMUNICATION skype Collaboration sophisticated tooIs CONTENT SHARING google drive Tool Set can have multiparty TASK MANAGEMENT google calendar audvid meetings LMTS tooIs not integrated can39t share docs Iive support concurrent le access NO support for surveys wikis etc free Imtd value to professional biz Com prehensi ve Collaboration Set WHAT provides content managementcontrol work ow control online meetings programs integrated not free takes time to learn COMMUNICATION Microsoft Lync CONTENT SHARING SharePoint TASK MANAGEMENT SharePoint lists integrated W email LMTS cost learning required Power Curve WHAT Shows relationship of power utility gained fr Software product as a function of the time using that product Flat line investing time wo power increase Ideal curve starts positive value when time is zero has no at spots Bl application Software component of BI Work ow Collaboration tool manage activities Group wants docs to be Control in predefined process reviewsapproved by team members in particular sequence Relational Tables that represent relationships Database using foreign keys
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'