bis 155 week 1 lab 1 latest devry n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
BIS 155 WEEK 1 LAB 1 LATEST-DEVRY PowerPoint Presentation
Download Presentation
BIS 155 WEEK 1 LAB 1 LATEST-DEVRY

Loading in 2 Seconds...

play fullscreen
1 / 8

BIS 155 WEEK 1 LAB 1 LATEST-DEVRY - PowerPoint PPT Presentation


  • 1 Views
  • Uploaded on

\nVisit Below Link, To Download This Course:\n\nhttps://www.tutorialsservice.net/product/bis-155-week-1-lab-1-latest-devry/\n\nOr \nEmail us on\nSUPPORT@TUTORIALSSERVICE.NET\n\nBIS 155 Week 1 Lab 1 Latest-DeVry\nBIS155\nBIS 155 Week 1 Lab 1 Latest-DeVry\nLab Overview\nListen\nScenario/Summary\nYou are new to the staff of Summit Ridge Mountain Resort. One of the benefits to your employment is a free mountain ski pass. You are anxious to complete your work and enjoy a run down the mountain but know management is looking to you for important details and analysis for the ski resort overall. This week, management has asked that you begin to prepare a report for the Village Shop sales. The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook, create formulas, and format your work professionally.\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 'BIS 155 WEEK 1 LAB 1 LATEST-DEVRY' - 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
bis 155 week 1 lab 1 latest devry

BIS 155 WEEK 1 LAB 1 LATEST-DEVRY

Visit Below Link, To Download This Course:

https://www.tutorialsservice.net/product/bis-155-week-1-lab-1-latest-devry/

Or

Email us on

SUPPORT@TUTORIALSSERVICE.NET

BIS 155 Week 1 Lab 1 Latest-DeVry

BIS155

BIS 155 Week 1 Lab 1 Latest-DeVry

Lab Overview

Listen

Scenario/Summary

You are new to the staff of Summit Ridge Mountain Resort. One of the benefits to your employment is a free mountain ski pass. You are anxious

to complete your work and enjoy a run down the mountain but know management is looking to you for important details and analysis for the ski

resort overall. This week, management has asked that you begin to prepare a report for the Village Shop sales. The report will summarize all sales

of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook,

create formulas, and format your work professionally.

listen

Listen

Deliverables

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step

instructions.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week1_Lab. xlsx.

Example: If your name were Jane Doe, your workbook would be Doe_J_Week1_Lab.xlsx.

When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

Make certain you compare your finished work with the Grading Rubric included here.

Lab 1 – Village Shop Sales

StepTask

Points Possible

Points Received

Comments

1

Documentation sheet

1a

Insert new worksheet

1

1b

Rename worksheet tab

1

1c

Enter identifying information

2

1d

Format with text wrapping & color formatting

2

2

Calculations

2a

Calculate Net Selling Price for each item

3

Calculate the Total Sales for each item

3

calculate the total profit per item

Calculate the Total Profit per item

3

Calculate the Average Profit % for each item

3

2b

Calculate Total Profit to Date

3

2c

Calculate the Remaining Profit Need to meet the Goal

3

3

Formatting

3a

Center the spreadsheet title rows across the selection A – R

4

3b

Apply text wrapping to column headings

4

3c

Change Font size and color

2

3d

Change shading and borders

2

3e

Format currency and percentages

3

4

Professional Appearance (Cleanup)

4a

Tab color and names

4

4b

Hide columns D-M

4

4c

Custom header: Professor Names and Student Name

5

4d

Page orientation

3

Comment in Dropbox: What you learned from completing this Lab

5

TOTAL POINTS

60

0

Week 1 Lab Grading Rubric

Listen

Lab Resources

Microsoft Office: Excel 2016

options for accessing microsoft excel 2016

Options for Accessing Microsoft Excel 2016

1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course

Resources page. Instructions – How to get your copy of Office 2016

2. If you are a MAC user, click to read the MAC User Information.

3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section,

and click the Virtual Lab Citrix icon.

Listen

Lab Steps

Listen

Preparation

You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin

the lab.

Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples walking you through

the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete.

For example, your final assignment file should include two worksheets (Documentation and Sales-Data).

Listen

Begin: Opening and Saving

Download the spreadsheet Week 1 Lab – Summit Ridge Mountain Resort Student.xslx. You will be prompted to save the file. Click yes.

Open the saved file from your Download folder on your computer.

note if you are using the remote lab environment

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found

on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name

open the workbook in Excel 2016; and

in Excel, click File then Save as and rename it as lastname_first initial_Week1_Lab.xlsx (Jane Doe would save the file as

Doe_J_Week1_Lab.xlsx).

Listen

Step 1: Adding a Documentation Sheet

1. Insert a new spreadsheet into the workbook.

2. Change the tab name from sheet 2 to Documentation. The documentation sheet should be moved to the first sheet in the workbook.

3. Include your name, the date, and the purpose of the spreadsheet.

4. Make sure you include block color formatting and text wrapping as needed. Your documentation sheet should look something like the one

below.

Documentation Sheet

Listen

Step 2: Adding Calculations (Formulas)

Now we need to begin working on the worksheet with all of the data.

1. Create the formulas needed to calculate the following for each item.

Column N: Total Quantity Sold = Sum of all Daily Sales

column o net selling price selling price 1 sales

Column O: Net Selling Price = Selling Price * (1 – Sales Discount)

Column P: Total Sales = Total Quantity Sold * Net Selling Price

Column Q: Total Profit = Total Sales – (Cost per item * Total Quantity Sold)

Column R: Average Profit % = Total Profit / Total Sales

1. Create a Grand Total for the Total Profit column and place it in cell B21.

2. Create a formula to calculate the Remaining Profit needed and place it in cell B22.

Remaining Profit = The Profit Goal – Total Profit (all items)

One of the strengths of Excel is its ability to make tedious and repetitious calculations for speed and to reduce errors. Like all tools, there is always

the possibility that you could use it incorrectly, so with formulas, it is important to verify the formulas you enter are correct. Notice that the daily

sales columns between columns C and N are hidden in the picture below.

Click on Image to Expand

Listen

Step 3: Formatting

Apply formatting to your spreadsheet.

Your goal is to take into consideration readability, reliability, and reusability. Remember that presentation has an impact on the viewer, and

professional appearance is important for reporting data, just as personal appearance impacts perception. The goal is to make the data more

readable and possibly to highlight data that might otherwise be lost in many numbers.

The minimum formatting requirements (per the Grading Rubric) are the following.

1 title rows formatted as titles centered across

1. Title Rows formatted as titles, centered across all columns A–R

2. Apply text wrapping to the column headers.

3. Make professional font size and color changes.

4. Make use of shading and borders.

5. Format for currency, percentage, and numeric formatting.

Click Image to Expand

Listen

Step 4: Professional Appearance (Cleanup)

Cleanup the formatting of your report, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

1. Apply a color and assign a descriptive name to each tab (sheet) in the workbook.

2. Hide the Daily Sales columns (D–M).

3. Create a custom page header with your professor’s name and your name.

4. Set the page orientation to landscape.

Remember, professional appearance doesn’t only promote better readability of your report, it represents you as a professional.

Click Image to Expand

Listen

Finish: Save and Submit

Save your Excel file. Saving your file often is good practice (Ctrl + s).

your excel file should contain two worksheets

Your Excel file should contain two worksheets.

Documentation

Sales-Data

Remember to provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. Submit your

completed Excel file to the Dropbox (see the Deliverables above).

Keep this finished work, because you will be using it to begin the lab for Week 2.

Download Now