Notes for Week of 3/24
Notes for Week of 3/24 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 4 page Class Notes was uploaded by Rachael Han on Tuesday March 24, 2015. The Class Notes belongs to BADM 2301 - Management Information Systems Technology at George Washington University taught by Ho in Spring2015. Since its upload, it has received 253 views.
Reviews for Notes for Week of 3/24
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: 03/24/15
Chapter 1 RedBox Secret for success Impacts on other Industries Tuesday 01 20 2015 Blockbuster founded in 1985 O Acquired by Viacom for 84B in 1994 Reed Hastings was fined 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 O added bymail video games service in 2010 O filed for bankruptcy in 2010 Redbox Pros O Cheap O Convenience O Kiosks are placed near checkout line draw impulse purchases 0 low operational cost The Marketing 4 P s 0 Product 0 Place 0 Price 0 Promotion 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 O Software I Microsoft vs SalesForce 0 Music I Spotify Pandora amp iTunes O Marketing I Groupon livingsocial MrRebatescom amp eBates 0 Airlines O Ground Travel I Uber Curb Lyft Impacts on modern businesses 0 Changing the rules of the game I gtkSharing economy relocate the resource and redistribute the resource and change the supplydemand 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 O 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 O 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 Tuesday 012715 Information Techology IT computerbased tool that people use to work with info and to support info processing IT Performs 5 tasks 0 Capture input 0 Cradle store 0 Create produce 0 Communicate among ITs O Convey output Tuesday 020315 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 O Origins of Palantir I Serious fraudulent activities on Paypal Q 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 O Components inputs resources and outputs 0 Evaluating Business Process O gtkDo the things right efficiency 0 gtkDo the right things effectiveness IS Role in Supporting Business Processes Q Executing the process 0 Automating online booking vs phone agents O Semiautomating ex manager s approval required 0 gtkCapturing 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 Q 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 efficient results 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 000000 achieve more effective results Change radical Risk high Time long Frequency low Approach topdown Org Impact hard to measure sometimes OOOOOO Market Pressures Globalization Changing Nature of Workforce Powerful 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 O 5 Forces Competition in Industry Among Rivals Threat of Substitutes Bargaining Power of Customers Bargaining Power of Suppliers Threat of new Entrants O Value Chain Model pg 61 Strategies for Competitive Advantage Cost Leader lower price Differentiation different Innovation something new Operational Effectiveness more efficient Customer Oriented OOOOO Week of 3232015 Most common jobs You need Excel O Most commonly required skills are also basic ones Microsoft Word and Excel 0 Learning Objective Fully understanding the knowledge you have learned in VBA and Macro Applying the knowledge to perform simple data visualization analysis and manipulation 0 Background Go to Blackboard Individual Assignments Assignment 1 and save Assignmentlxlsm to your computer This workbook has two worksheets Exercisel and Assignmentl Enable all yellow warning messages appearing on the top if any Exercise 1 contains the example we have walked through in the VBA session 0 Open VBA editor ALTFl l to see the code as well as linebyline explanations Get yourself familiarize with ow of the program You will find those comments very useful You are asked to work on Assignment 1 worksheet and complete the requirements listed below 0 Requirements There are three tasks to complete in this assignment A Data Visualization and Analysis 6 pts Given the players statistics provided you are asked to perform the following visualization and analysis jobs similar to exercise 1 l 0 Determine Foul Strategy for each player in column D according to the rule below a Never foul him if FT gt 85 b Don t foul him if FT gt 65 and lt 85 c Foul him if FT gt 50 and lt 65 d HackaShaq if FT lt 50 O FYI HackaShaq is a clever basketball defensive strategy used to hinder the scoring ability of the opponent by intentionally committing fouls and sending an opposing player with the worst FT to the free throw line The strategy gets its name since NBA coaches love to implement it against Shaq the nickname of the greatest center Shaquille O39Neal who is known for terrible FT Note Obviously 85 and 85 have distinct meanings O 2 Change the color of a player s name according to the rule below e Red if FT gt 85 f Green if FT lt 50 O 3 For players whose FT lt 50 highlight the corresponding column A and B name and position by filling the background color in yellow BADM 2301 Spring 2015 2 B Data Manipulation 3 pts Write a VBA program in the sub PartB to perform the following task Once the sub is executed a MsgBox will pop up and show the sum of the first five positive integers ie l2345 Grading You MUST use a DoWhile loop to implement the task instead of hardcoding it e g MsgBox l2345 No credit will be given without using a loop Why What if you need to calculate the sum of first 10 integers What if you want to know the sum for even integers only The goal here is to develop the problemsolving ability instead of solving a particular problem Hint 1 How could we get started The operation l2345 can be split into 5 steps 1 0 l 2 l 3 3 3 6 4 6 10 5 10 15 Notice that in each step we repeat the same operation adding a new increasing positive integer by the number calculated in the previous step Hint 2 Hint 1 suggests that you will need TWO integer variables one for the Integer index and one for the sum C Recording and Assigning Macro 2 pts Insert three Button Controls Name and assign macros to those three buttons by following the requirements below 0 1 For button 1 name it as Part A and assign sub PartA to it Q 2 For button 2 name it as Part A and assign sub PartA to it 3 Record a macro which performs the following tasks a Reset font color for column A to Black b Reset background color for column A and B to empty c Clear contents in cells from D2 to D18 Assign the recorded macro to button 3
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'