Module 4 – Case
ELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE
Assignment Overview
Module 4 introduces online presence for business and
information security policies. E-commerce can result in a radical change in the
manner business operate, but it needs to be integrated with the rest of the
business. Some of the integration includes, planning, competition of resources,
and interfaces to other internal systems. Sometimes companies join an alliance
or consortium of companies to explore E-commerce implementation. Most
electronic payment systems know who the buyers are, and it is therefore
necessary to protect their identity. Other private issues may involve tracking
of Internet user activities through cookies and in-house monitoring of web
services.
Everyday sales items purchased online have almost doubled
between the year 2006 and 2010 and it is expected that these figures will keep
doubling by 2020. A few years back, E-commerce was not expected to be what is
now. It is now clear that all businesses need to provide online services sooner
or later to remain in the market. The same is true for mobile commerce.
In order to identify what businesses need to do to start
their online presence, go over the background readings and any other elective
readings you find useful. When you have read the articles listed in the
background material and any other relevant reading you could find, imagine that
you want take advantage of the Internet and communication technologies for your
business. These include the tools, business strategies, and information
security needed to orderly implement electronic and mobile commerce.
In addition, E-policies typically include: ethical computer
use policy, information privacy policy, acceptable use policy, email privacy
policy, Internet use policy, and anti-spam policy.
Case Assignment
The final case in this course explores some of the concerns
manager face as they adapt to an increasingly technological environment. The
Case “How Starbucks is Changing to
a Digital and Social Enterprise” is a thought provoking case and may
challenge you to consider some of the actions to take if placed in similar
circumstances. The case can be found at
https://sites.google.com/site/efraimturban/online-files Chapter 1 or at
https://drive.google.com/file/d/0B01kmYbW3pyfbmlmNVNiOVowd1E/edit?pli=1
How is Starbucks changing to a Digital and Social
Enterprise? What are the drivers for this change?
In what ways you think Starbucks increases its brand recognition
with its E-Commerce initiatives?
Is the E-Commerce system bringing Starbucks closer to its
customers? Is it changing consumer behavior? Why and why not?
Note: this case study was selected from the book Electronic
Commerce
A Managerial and Social Networks Perspective by Turban, E.,
King, D., Lee, J,. Liang, T., & Turban, D. For more info see:
http://www.gallaugher.com/chapters
Assignment Expectations
The Case should be 4-5 pages for the answer, excluding cover
page and reference list.
Your assignments will be graded following these
expectations:
Precision: the questions asked are answered.
Clarity: Your responses are clear and show your good
understanding of the topic.
Breadth and depth: The scope covered in your paper is
directly related to the questions of the assignment and the learning objectives
of the module.
Critical Thinking: It is important to read the “required
readings” posted in the background material plus others you find relevant. Your
paper should include relevant concepts from these readings and incorporate your
reactions and examples that illustrate your reflective judgment and good
understanding of the concepts.
Your paper meets the page requirements, not counting the
cover page or the references pages.
Module 4 – SLP
ELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE
SLP 4 consists of two parts. In Part I, you will create an
Excel Pivot tables, and in Part II you will
and evaluating security measures to protect Internet consumers.
Refer to tutorials at http://www.gcflearnfree.org/excel2013
and watch the videos.
Track Change and Comments [Video 24]
Finalizing and Protecting Workbooks [Video 25]
Conditional Formatting [Video 26]
Pivot Tables [Video 27]
What-If Analysis [Video 28]
For this assignment, first watch the below videos by
clicking the links:
Pivot Tables:
https://support.office.com/en-in/article/Create-a-PivotTable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760?ui=en-US&rs=en-IN&ad=IN
IF functions
https://support.office.com/en-in/article/Advanced-IF-functions-17341cef-510d-4d60-a657-913f878fdacf?ui=en-US&rs=en-IN&ad=IN
Using PivotTables to answer questions
Suppose we wanted to answer the question: “What is the
amount sold by each salesperson?” for the sales data in the example below.
Answering this question could be very time-consuming and difficult—each
salesperson appears on multiple rows, and we would need to total all of their
different orders individually. We could use the Subtotal command to help find
the total for each salesperson, but we would still have a lot of data to work
with.
Fortunately, a PivotTable can instantly calculate and
summarize the data in a way that is both easy to read and manipulate. Perform
the following.
Use the PivotTable to calculate and summarize the data.
Once you have created a PivotTable, change the order amount
to currency.
What is the amount sold by each salesperson?
What is the total amount sold in each month?
Take a screenshot or use the Snipping tool to copy the
worksheet where the new pivot table and pivot table fields appear to show your
work. Paste the screen images into a Word doc.
Submit your answers for this assignment by pasting the
worksheet screenshots in 1- to 3-page Word document.
SLP Part II
For Part II, prepare a 1- to 2-page Word document paper
addressing the following question.
Research 2-3 security measures that are available to protect
customers shopping on the Internet. Define the measure and find the benefits
and limitations of each approach.
SLP Assignment Expectations
Your assignment will be graded following these expectations:
SLP Part I and II must be submitted in one combined Word
document containing 2-5 pages properly labeling each section.
Submit a Word document with screen copies of the Excel
worksheet by pasting them in 1-3 pages. Answer the security question in 1-2
pages.
Precision: the
questions asked are answered.
Clarity: Your answers are clear and show your good understanding
of the topic.
Breadth and depth: The scope covered in your paper is
directly related to the questions of the assignment and the learning objectives
of the module.
Your paper meets the page requirements not counting the
cover page or the references pages





