Information Systems & Strategy
What is the difference between Information Technology (IT) and Information Systems (IS)?
IT focuses on hardware, software, and networks, while IS includes people, processes, and technology.
Which Excel function counts the number of non-empty cells in a range?
COUNTA
What does DNS stand for, and what is its function?
Domain Name System; it converts domain names into IP addresses.
What is a Process Flow Diagram (PFD)?
A visual representation of a workflow or business process.
How did Netflix start before becoming a streaming service?
As a DVD rental-by-mail business.
Which competitive strategy does Amazon primarily use by offering low-cost products and fast delivery?
Cost Leadership
What Excel feature allows users to freeze the top row to keep it visible while scrolling?
Freeze Panes
What type of network covers a small geographical area, such as an office or school?
Local Area Network (LAN)
What is one risk of implementing a new information system?
User resistance, data migration issues, or high costs.
Which force in Porter’s Five Forces Model is impacted by Netflix’s investment in original content?
Bargaining Power of Suppliers - in the streaming industry, movie studios, production houses and networks hold the power because they license their movies and shows to platforms like Netflix. Netflix making their own content reduces that reliance on external licensing.
OR
Bargaining Power of Buyers - customers have many streaming options meaning the customers have high bargaining power and can easily switch services. Netflix creating their own content reduces the customers bargaining power by increasing customer loyalty.
What does Porter’s Five Forces Model help businesses analyze?
The competition and profitability of an industry.
What’s the difference between a formula and a function in Excel?
A formula is user-defined (e.g., =A1+B1), while a function is built-in (e.g., SUM()).
What does HTTP stand for?
Hypertext Transfer Protocol
What is the difference between Waterfall and Agile development methodologies?
Waterfall is a structured, step-by-step process; Agile is iterative and flexible.
What is one major competitive advantage of Netflix over traditional cable TV?
On-demand streaming, personalization, or original content.
What force in Porter’s Five Forces Model refers to how easily customers can switch to competitors?
Threat of Substitutes → Refers to how easily customers can switch to an alternative product or service that meets the same need.
OR
Competitive Rivalry → Refers to the level of direct competition between existing businesses in the same industry.
What does the COUNTIFS function do? Provide an example.
It counts the number of cells that meet multiple conditions (e.g., =COUNTIFS(A:A, "Apple").
Explain how data is transmitted across the Internet.
Data is broken into packets, which may take different routes before being reassembled.
Explain what the Parallel Implementation Method is.
Run old and new systems together during the implementation phase.
Suggest a new technology-driven strategy that Netflix could implement to stay competitive.
AI-driven recommendations, cloud gaming, or interactive content.
What is digital transformation, and how does it impact businesses?
The use of technology to change business operations, improving efficiency and customer experience.
Write the SUMIFS function to total Units Sold for "Product A" in January? Use absolute and partial absolute references to move the function down and right.
=SUMIFS($G$2:$G$25,$A$2:$A$25,$I3,$B$2:$B$25,J$2)
Identify five parts of this URL: https://athletics.lmulions.com/sports/womens-basketball
(Protocol, Subdomain, Domain Name, TLD, SLD)
What are the 5 Systems Development Life Cycle Phases?
Planning, Analysis, Design, Implementation & Maintenance
Explain how companies use personalization in their IT-based business strategies.
By using data analytics to customize user experiences (e.g., Netflix’s recommendation algorithm).