itm 301 module 4 slp latest trident n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
ITM 301 MODULE 4 SLP LATEST-TRIDENT PowerPoint Presentation
Download Presentation
ITM 301 MODULE 4 SLP LATEST-TRIDENT

Loading in 2 Seconds...

play fullscreen
1 / 3

ITM 301 MODULE 4 SLP LATEST-TRIDENT - PowerPoint PPT Presentation


  • 6 Views
  • Uploaded on

\nVisit Below Link, To Download This Course:\n\nhttps://www.tutorialsservice.net/product/itm-301-module-4-slp-latest-trident/\n\nOr \nEmail us on\nSUPPORT@TUTORIALSSERVICE.NET\n\nITM 301 Module 4 SLP Latest-Trident\nITM301\nITM 301 Module 4 SLP Latest-Trident\nModule 4 – SLP\nELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE\nSLP 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.\n• Refer to tutorials at http://www.gcflearnfree.org/excel2013 and watch the videos.\n• Track Change and Comments (video 24)\n• Finalizing and Protecting Workbooks (video 25)\n• Conditional Formatting (video 26)\n• Pivot Tables (video 27)\n• What-If Analysis (video 28)\n

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'ITM 301 MODULE 4 SLP LATEST-TRIDENT' - tutorialsservicesnet


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
itm 301 module 4 slp latest trident

ITM 301 MODULE 4 SLP LATEST-TRIDENT

Visit Below Link, To Download This Course:

https://www.tutorialsservice.net/product/itm-301-module-4-slp-latest-trident/

Or

Email us on

SUPPORT@TUTORIALSSERVICE.NET

ITM 301 Module 4 SLP Latest-Trident

ITM301

ITM 301 Module 4 SLP Latest-Trident

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

https://support.office.com/en-in/article/Advanced-IF-functions-17341cef-510d-4d60-a657-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

Your paper meets the page requirements not counting the cover page or the references pages

Download now