Midterm I Study Guide
Midterm I Study Guide BADM 2301 - Management Information Systems Technology
Popular in BADM 2301 - Management Information Systems Technology
BADM 2301 - Management Information Systems Technology
verified elite notetaker
BADM 2301 - Management Information Systems Technology
verified elite notetaker
Popular in Department
This 9 page Study Guide was uploaded by Rachael Han on Thursday February 26, 2015. The Study Guide belongs to BADM 2301 - Management Information Systems Technology at George Washington University taught by Ho in Spring2015. Since its upload, it has received 340 views.
Reviews for Midterm I Study Guide
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/26/15
Midterm I Study Guide Chapter 1 Blockbuster founded in 1985 0 Acquired by Viacom for 84B in 1994 Reed Hastings was ned 40 in 1997 so founded Net ix in 1998 O Blockbuster refused to acquire for 50M in 2000 RedBox was founded in 2002 O entered online market in 2004 Hulu founded in 2008 Blockbuster introduced Blockbuster Express kiosk in 2009 0 added bymail video games service in 2010 o led for bankruptcy in 2010 Redbox Pros 0 Cheap 0 Convenience O Kiosks are placed near checkout line draw impulse purchases 0 low operational cost The Marketing 4 P s Impacts on Other Industries 0 Photography I Mistake slow shift to digital market cannibalization I Kodak declared bankruptcy in 2012 while it emerged from that in 2013 0 Software I Microsoft vs SalesForce 0 Music I Spotify Pandora amp iTunes 0 Marketing I Groupon livingsocial MrRebatescom amp eBates 0 Airlines Ground Travel I Uber Curb Lyft Impacts on modern businesses 0 Changing the rules of the game I Sharing economy relocate the resource and redistribute the resource and change the supply demand of the market 0 ex Uber I Crowdfunding 0 ex Kickstarter Prosper I Crowdsourcing 0 ex Threadless o Blurring industry boundaries I every company is an IT Company I built around smartphone ecosystem 0 Creating new forms of companies ex Ebates 0 IT itself is a tool but not a silver bullet 0 SaaS Software as a Service Lab 0 The cloud is a server using the storage space on one or many of these servers 0 Web 10 vs Web 20 0 Web 20 High interaction dynamic in nature booming social media user generated content and easy to understand I Popular technology used AJAX 0 popularized in 2005 by Google Google suggest 0 way of using existing standards I Examples of Web 20 FB Twitter Flipboard Information Techology IT computerbased tool that people use to work with info and to support info processing IT Performs 5 tasks 0 Capture input Cradle store Create produce Communicate among ITs Convey output Case Discussion 0 A Tool to Combat Terrorism and Fight Crime page 35 0 Problem fragmented data silos across organizations lack of an integrated info systems 0 Potential IT Solution Palantir from Lord of the Rings 0 Origins of Palantir I Serious fraudulent activities on Paypal 0 How this system helps organizations like Military units FBI Wall Street banks etc I ISIT Helps organizations respond to pressures national security bank fraud etc and provide competitive advantage over rivals Managing Business Processes 0 Business Process ongoing collection of related activities that create a product service of value to the org 0 Components inputs resources and outputs 0 Evaluating Business Process 0 Do the things right ef ciency 0 Do the right things effectiveness IS Role in Supporting Business Processes o Executing the process 0 Automating online booking vs phone agents 0 Semiautomating ex manager s approval required 0 Capturing and Storing Process Data 0 Monitoring process performance 0 ex online package tracking system or passengers boarding status Advantages of IS 0 reduce operational cost 0 save time o eliminate human errors 0 enhance data integrity maintain consistency of data BPI vs BPR 0 Business Process Improvement BPI approach to help an org to incrementally streamline its processes to achieve more ef cient results 00000 0 Change incremental Risk Low Time short Frequency high Approach bottomup Org Impact Quantifiable time money etc Business Process Reengineering BPR approach to help an org to fundamentally rethink its processes to achieve more effective results 00000 0 Change radical Risk high Time long Frequency low Approach topdown Org Impact hard to measure sometimes Market Pressures Globalization Changing Nature of Workforce Power il Customers Globalization 10 Flatteners Berlin Wall Falls Netscape Goes Public Development of Work ow Software Supply Chaining Offshoring Outsourcing Insourcing Uploading Web 20 Informing search engine The Steroids technologies that amplify other atteners wireless cloud video conferencing Strategic Management Michael Porter 0 O 5 Forces Competition in Industry Among Rivals Threat of Substitutes Bargaining Power of Customers Bargaining Power of Suppliers Threat of new Entrants Value Chain Model pg 61 Strategies for Competitive Advantage O 0000 Cost Leader lower price Differentiation different Innovation something new Operational Effectiveness more ef cient Customer Oriented Programming 101 VBA Visual Basic for Applications is a programming language that enables you to control everything in Excel My First VBA Program First of all let s do a socalled Hello World exercise using VBA Open Microsoft Excel and open a blank workbook Hold the Alt key and hit Fll Alt Fl 1 VBA editor will pop up automatically On the topleft comer locate panel VBAProject Bookl and double click on item Sheetl A new blank screen will pop up in the right panel Type the following code but Replace the text in by whatever you want to say 1 2 3 4 Sub MyFirstVBA MsgBox My rst VBA Program Woohoo AA End Sub 5 Click on the green play button right below the tab Debug Four Building Blocks in VBA Object Real life Think of an object in our real life Say a person Chad Or a classroom Duques 351 VBA An object could refer to many things a cell a worksheet or a predefined item Examples A5 AlClO Sheetl or a message box Suppose we have an object Chad Property Real life How do we describe an object say Chad Characteristics VBA We use properties to describe the characteristics of an object Examples Chad s accupation is professor his Q is too high to measure etc Method Real life What words do we use to describe an action Verbs VBA A method is a prede ned task that you want an object to perform Example Jump Chad Parameter Real life Often time we need extra words to clearly describe an action Like adverbs VBA A parameter is used along with a method to spe cy a task more precisely Example Jump 10 times Chad Basic Operators Symbols Dot Operator Real life A complete English sentence should look like Subject Verb O Adj Adv VBA When we write computer codes we also need to specify who what and how 0 We use dot operator to attach multiple building blocks 0 Dot operator is hierarchical We start with the block of the highest level and attach other of lower level one by one 0 In most cases we start with objects followed by propertiesmethods or parameters Example GWUBschoolISTMChadHairCut Single quotation Operator A single quotation mark is used to comment out a line in VBA code VBA will skip everything behind in the same line Double quotation Operator A pair of double quotation marks 99 is used to distinquish a string text from a number Location and Navigation Sheet and cell Reference To refer to a worksheet a cell or a group of cells in VBA we use the following 0 Worksheets SheetName the worksheet named SheetName ActiveCell the single cell where your cursor currently is 0 Range CellRange a cell or cells de ned by CellRange To refer to Sheetl we write Worksheets Sheetl To refer to cells from Al to C5 on Sheetl we write Worksheets Sheetl Range AlCS A use dot operator to attach objects Sheet and Cell Selection When you work with Microsoft Excel you usually rst select a cell or cells and then perform an action The method we use in VBA is Select To select A1 C5 in the current worksheet we write Range AlC5 Select To select BlDlO in Sheetl we write Worksheets Sheetl Range B l D l 0 Select Navigation Sometime we need to specify a new location based on where the cursor currently is ie We use the method Offset OffsetYX takes two parameters 0 Move Y rows down increase the row index 0 Move X columns to the right increase the column index Suppose the active cell is cell A1 1 To move 1 row down from ActiveCell Al and select the new cell we write ActiveCellOffsetl0Select The ActiveCell now becomes A2 2 To move 2 rows down and 3 columns to the right from A2 and select the new cell we write ActiveCellOffset23Select The ActiveCell now becomes D4 0 Negative value of YX indicates 3 To move 2 rows up 2 row index and select we write ActiveCellOffset20Select The ActiveCell now becomes D2 4 To move 1 row up 1 row index and 2 columns to the left 2 column index and select the new cell we write ActiveCellOffset12 The ActiveCell now becomes B1 1 a To move 3 row down row index and 2 columns to the left row index and select ActiveCellOffsetSelect b To move 4 row up row index and 1 columns to the right row index and select ActiveCellOffsetSelect TL39ck If you lose track of where the ActiveCell is use property Address Add the following code and run it MsgBox ActiveCellAddress As you ve already known Address is a property used to describe the active cell Attention Now put double quotation marks before and after ActiveCellAddress The code becomes MsgBox ActiveCellAddress Run the sub What do you get Attention Now put a single quotation mark in front of MsgBox The code becomes MsgBox ActiveCellAddress Run the sub What do you get VBA will skip everything in the same line after and code after will turn in green You are commenting out program code This feature allows programmer to add comments for hisher own information or to communicate with other programmers Variables Real life When you want to store something you may consider getting a box Apparently the size and the shape of the box depends on the content to be stored VBA A variable can be thought of a box in which you can store data for future use Data Types Like picking a right box for the content to be stored it is always a good idea to choose the right data type for the data you are going to store The most common variable types are Type Bytes Usage Byte l a small positive integer Integer 2 an integer 32768 32767 Long 4 an extreme integer 2 l47B 2 l47B Bbillion Single 4 a decimal number Double 8 an extreme decimal number Boolean 2 a Ture l or False 0 indicator String a set of characters 1 65400 in length Date 8 a time stamp with both date and time Operations Declaration Before we can store data we need to get a box by declaring a variable rst Through declaration a section of memory will be allocated exclusively for a declared variable We use Dim As Dim strName As String Dim intAge As Integer Dim IsMarried As Boolean Best Practice Always declare variables with the appropriate data type before you use them Question Why don t we declare every variable in double To save memory consumption Naming rules and conventions 0 Name the variables in a sensible way A good name should be selfexplained 0 It is good to add data type in front e g strName intAge and booIsMarrid 0 Must be in one word without spaces and periods 0 Use undercore if you wish to separate worlds e g TaxCalculator 0 Cannot start with numbers 0 Cannot use the following symbols amp and 0 Cannot use VBAreserved words like string integer boolean etc Assignment A variable contain no value once it is declared success llly just like a new empty box To store data in a variable we use the assignment operator strName Chad Ho intAge 21 booIsMarried False By using VBA will assign whatever on the right to the variable on the left 6 We can also assign the value stored in a variable to another variable Dim intNumber As Integer declar a new Integer variable called myNumber intNumber intAge 21 6 21 intNumber intNumber 5 26 6 21 5 26 Now what does intNumber store 26 If we use assignment operations along with cell reference we can assign value to a cell Do the following exercise to see how you can control excel Exercise Objective We want to create a small table by performing two tasks 1 putting Name Age and Is Married as heading in A1A3 and Range A1 Value Name Range A2 Value Age Range A3 Value Is Married Now set the ActiveCell to A3 This step is for practice purpose only Range A3 Select 2 Assigning the value stored in strName intAge and booIsMarried in B1B3 We can try using Offset and to navigate and assign values at the same time Question How to get from A3 to B1 Also A3 to B2 and A3 to B3 Answer Move 2 rows up 2 row index and move 1 column to the right 1 column index ActiveCellOffset2 1Value strName ActiveCellOffset1 1Value intAge ActiveCellOffsetO 1Value booIsMarried You can 1 make the font bold for heading and 2 set the color of data to red vaed by Range AA FontBold True Range BB FontColor vaed
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'