Module 4 – SLP
ELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE
To continue in Excel you will apply analytics to the SLP. Review these lectures and quiz to prepare for this assignment.
View Module 4SLP video, Become a proficient Excel user, from ITM301 Principles of Information Systems in Business and Organization – SLP Resources from LinkedIn Learning.
SLP 4 Review Quiz: This quiz will not count toward your grade but allows you to assess your knowledge.
SLP Assignment
Cost Comparison of Web Conferencing
The two owners of Spinner Media Services Inc. wanted to cut travel costs and productivity losses (wasted time) and maintain the benefits of person-to-person collaboration. They decided to use Web conferencing internally for collaboration and externally for sales demonstrations to customers. Their options are per-user licensing plans based on the number of seats or participants. The decision would depend on cost comparisons based on these data estimates:
- Approximately 100 meetings per year
- An average of 12 participants per meeting
- Each meeting lasting about one hour, which takes into consideration the need to get the meeting set up at least 15 minutes in advance and meeting for 45 minutes
- 250 unique participants, consisting of 50 employees and 200 customers.
Here are two sites with pricing information for Zoom and WebEx. (Note these addresses can change so Google “zoom” or “webex” if necessary):
SLP Assignment Expectations
Prepare an Excel spreadsheet that fulfills the criteria for this SLP assignment. Be sure to use formulas and graphs within Excel so they can be reviewed. In a Word document, interpret the meaning of your analytical findings from the spreadsheet. The Word document should present the results to the owners of Spinner Media Services. Use analytics and graphs in your report and then describe the results. Remember you can copy spreadsheets and graphs into Word but you need to upload both the Word document and the Excel document to the SLP dropbox.