E-Commerce & E-Business
What is the difference between E-Commerce and E-Business?
E-Commerce involves buying and selling online, while E-Business includes all digital business operations, such as ERP and CRM.
Write an example of a formula.
=A1/B5
What are the three competitive strategies identified by Porter?
Cost Leadership, Differentiation, and Focus Strategy.
What does SDLC stand for?
Systems Development Life Cycle.
LAN is a type of network by coverage, what does it stand for?
Local Area Network
Give one example of a B2C e-commerce platform and one example of a C2C e-commerce platform.
B2C: Amazon.com, Walmart.com. C2C: eBay, Facebook Marketplace.
What is the purpose of the COUNTIFS function?
It counts the number of cells that meet multiple conditions (e.g., =COUNTIFS(A:A, "Apple", B:B, "January")).
Name the 3 components of Information Systems (IS).
Technology, People, Processes
What is the level of risk and cost of the direct cutover implementation methodology?
High risk, low cost
What is a website? Definition.
A website is a collection of related web pages stored on a web server and accessible through the Internet using a web browser.
What is social commerce and how does it differ from traditional e-commerce?
Social commerce is the use of social media platforms (e.g., Instagram, TikTok) to sell directly to customers, integrating shopping into the social experience.
What is a cell and give me an example.
A cell in Excel is the basic unit of a spreadsheet, where you can enter data, formulas, or functions. Each cell is identified by its column letter and row number (e.g., A1, B2, C3).
What are two primary activities in Porter’s Value Chain Model?
Inbound Logistics, Operations, Outbound Logistics, Marketing & Sales, or Service.
What are the 4 mapping basics of a Business Process Flow Diagram (PFD)?
Task, Decision, Terminator, Arrows
What is an example of conversational commerce, and how does it help businesses?
Chatbots, AI shopping assistants (e.g., using WhatsApp or Facebook Messenger for customer interactions). It improves customer engagement and automates sales interactions.
What Excel function would you use to find the highest sales amount in a dataset?
The MAX() function (e.g., =MAX(A2:A100)).
How does Bargaining Power of Suppliers impact businesses in Porter’s Five Forces Model?
If suppliers have high bargaining power, they can demand higher prices or limit resources, affecting business costs.
What is the purpose of prototyping in system development?
Prototyping allows developers to create an early working model to gather user feedback before full development.
What is the difference between the Internet and the World Wide Web (WWW)?
The Internet is a global network of interconnected computers, while the World Wide Web (WWW) is a system of web pages and content that is accessed using the Internet.
What is one risk and one benefit of businesses using social commerce instead of traditional websites?
Risk: Less control over platform rules and algorithms. Benefit: Higher engagement and direct interaction with customers.
You want to count how many times "Product C" was sold in the North Region. Write a COUNTIFS formula to calculate this. *You can write out what you are looking for
=COUNTIFS(A2:A25, "Product C", E2:E25, "North")
How do the "Threat of New Entrants" and "Bargaining Power of Buyers" affect Netflix’s competitive advantage? Explain the impact of these forces on Netflix's strategy in the streaming industry.
Threat of New Entrants (Moderate-Low): Challenges: High costs for licensing, content production, and brand recognition make it difficult for new competitors to enter.
Bargaining Power of Buyers (Moderate-High): Challenges: Consumers have many streaming options (Hulu, Disney+, Prime Video, etc.), making it easy for them to switch services.
Explain the Phased Implementation method in system deployment.
The system is introduced gradually, allowing sections to go live step by step instead of all at once.
What is the role of a router in a network?
It connects multiple networks and directs data packets between them.