Devry BIS 155 Final Exam Latest

Devry BIS 155 Final Exam Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-155-final-exam-latest/

Devry BIS 155 Final Exam Latest

Devry BIS 155 final

Page 1

Question 1.1.(TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:

Note: This is a one part question.

• Each employee could have a standard hourly rate between $10.00 and $30.00 per hour.
• Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours.
• Each employee will have a standard 7.65% deduction for social security
• Each employee will have a standard 14.00% deduction for Federal Taxes
• Each employee will have a standard 5.33% deduction for State Taxes

Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine “Net Pay” including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of “Total Hours” using a conditional formula.

In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within “1” workbook but has allowed you to decide if you would rather keep the payroll running on one worksheet or by assigning a new worksheet for each week.Using your knowledge learned in this class, descriptively explain whether you would keep all weekly payrolls in one worksheet or assigned to new worksheets by week. Defend the approach you take based on what you have learned in this course.

(Points : 40)

Question 2.2.(TCO 3) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state. Each parts supply store carries inventory in four categories. You have been presented with the sales figures for the last three years for each location and inventory category by store. Based on this information, you’re tasked with analyzing current sales for each store by category and overall total sales by store and category.

Note: This is a four part question.

1.) Explain your approach to setting up your worksheets and organizing the data.

2.) Explain how you will visually represent the data for the total sales of the individual inventory categories for each location for the time periods shown.

3.) Explain how you will visually represent the consolidated data for the sales of all stores and all inventory categories for all time periods in one chart or graph.

4.) Once you have finished the above tasks, you plan to send the Excel workbook to your manager for evaluation. Your manger is presenting your findings to the Board of Directors for justification for additional capital expenditures. The visual representations need to be concise and clearly able to support the requested expenditures. Explain how you would use the integration features of MS Office to incorporate the Excel information into other presentation media.

(Points : 40)

Question 3.3.(TCO 4) You are given a spreadsheet with daily sales numbers ordered by date from January 1st to December 31st. You have been tasked with finding the average sales of each month, then to reorder the months so they are listed in order from highest to lowest average sales. Give a step-by-step explanation of how you will rearrange the data so you can analyze the best and worst months.

Note: This is a one part question.

(Points : 40)

Question 4.4.(TCO 5) You’ve just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures only one product, the gizmo. It comes in two sizes, the mini-gizmo and the magna-gizmo. Both are difficult to manufacture, and consequently, the company closely monitors rejected units. The company has three locations, each of which produces both the mini and the magna-gizmos. You are automating the weekly production reports so that you can easily calculate total production for the entire company each week.
The mini-gizmo is priced at $3.25 per unit. The magna-gizmo is priced at $7.00 per unit. The unit cost for a reject mini-gizmo is $1.75. The cost for a reject magna-gizmo is $3.50. Respond fully to the following questions regarding this task:Note: This is a two part question.

1.) The managers will e-mail their weekly reports to you on Monday of the following week. You will then produce the summary report. Explain the process for doing this. Give a sample formula to total the number of mini-gizmos produced by the entire company in a week.

2.) Each week, you will present the combined report to your boss, who wants to see both the summary and the individual sheets for each location. You want to add a header with the date and your name to each page. What is the easiest way to do this? Explain the process.

(Points : 40)

Question 5.5.(TCO 9) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.

Note: This is a one part question. (Points : 40)

Download File Now


Devry BIS 155 Course Project Latest

Devry BIS 155 Course Project Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-155-course-project-latest/

Devry BIS 155 Course Project Latest

Course Project: Excel Project

.equella.ecollege.com/file/48f5c15a-c5f4-4033-9efe-6a84ed9f94b8/1/BIS155_CH_CourseProject.html#1″>Objectives| .equella.ecollege.com/file/48f5c15a-c5f4-4033-9efe-6a84ed9f94b8/1/BIS155_CH_CourseProject.html#2″>Guidelines| .equella.ecollege.com/file/48f5c15a-c5f4-4033-9efe-6a84ed9f94b8/1/BIS155_CH_CourseProject.html#3″>Grading Rubrics

OBJECTIVES

.equella.ecollege.com/file/48f5c15a-c5f4-4033-9efe-6a84ed9f94b8/1/BIS155_CH_CourseProject.html#top”>Back to Top

The general instructions for this project can be found in the Week 6 Lecture material. The Week 6 Lecture describes the assignment and provides an overview of the project as a whole. There are no step-by-steps for the course project. The following are grading criteria for this project.

GUIDELINES

.equella.ecollege.com/file/48f5c15a-c5f4-4033-9efe-6a84ed9f94b8/1/BIS155_CH_CourseProject.html#top”>Back to Top

Organize the Data

  • Data imported from SalesData.csv text file located in Course Project Materials in DocSharing.
  • Professional formatting follows the formatting guidelines we studied during the first week of class.
  • Documentation sheet added to provide author, purpose, and date and provide information about each of the sheets you will create as you analyze the data.
  • At least one calculated field added and copied to all cells in the worksheet.

Analyze the Data

Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, comments, and explanation. Remove any extra sheets so your workbook is as compact as possible when you turn it in. Go back and review your labs for assistance in completing the different types of analysis.

The following are some examples of analysis you might wish to do:

  • Sort by discount level.Have discounts increased sales volumes? Is there any discount level that appears to be more effective than others?
  • Graph sales over time to see trends.Are there any peaks and lows in sales? Is there any time of year in which sales are highest? Lowest?
  • Pivot the data to see total sales by quarter, country, category, and salesperson.Are there any highs? Are there any lows that need to be addressed?
  • Subtotal the data.How are quarterly sales totals? Sales totals by salesperson? By Country?
  • Challenge Option: Perform What-If Analysis.What if prices were raised by a certain percentage with a slight decline in sales? What combination of price increases and decline in sales makes most sense?

Present your Conclusions in a Memo

Use the integration techniques we worked on in the course to develop a Memo (Word document) that includes data and graphs copied and pasted from your spreadsheet. You will turn in both your Recommendation Memo and your spreadsheet. (To help you formulate your report, there is a Word document named “ExcelProjectMemoTemplate” located in DocSharing – Course Project Materials. The yellow-lined information provides an explanation of what should be included in each section of the Memo.)

Your Memo will focus one paragraph on each of the Data Analysis sheets in your workbook. Explain the type of analysis you completed, the conclusions you drew, and a recommendation based on the analysis. (45 points)

You should include a final paragraph that explains three things you learned about using Excel for data analysis. (15 points)

GRADING RUBRICS

.equella.ecollege.com/file/48f5c15a-c5f4-4033-9efe-6a84ed9f94b8/1/BIS155_CH_CourseProject.html#top”>Back to Top

Category Points % Description
Organize the Data 40 25% Include imported data, professional formatting, a document sheet, and one calculated field.
Analyze the Data 60 37.5% Data is analyzed in at least three different ways.
Present your Conclusions in a Report 60 37.5% Integration techniques are used, explain the type of analysis, and include a final paragraph.
Total 160 100% A quality paper will meet or exceed all of the above requirements.

Download File Now


Devry BIS 155 ALL Week Discussions Latest

Devry BIS 155 ALL Week Discussions Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-155-all-week-discussions-latest/

Devry BIS 155 ALL Week Discussions Latest

Devry BIS 155 Week 1 Discussion Latest

Getting Familiar With Excel (graded)

Excel was introduced in 1985. Since then, it has become a standard business tool.

  1. Discuss and explain at least six different (unique) features of Excel that make it a valuable business tool.
  2. Discuss what type of Excel skills would be important in today’s job market and why. Be specific.

Note: In addition to the Microsoft Excel 2013 overview in the Course Home, there are many Excel resources, in addition to your text, on the Web. For example, try an Internet search on “top ten Excel 2013 features” and sift through some of the resources. Be sure to read your classmates posts, and see how many features you can find that haven’t been listed yet.

Devry BIS 155 Week 2 Discussion Latest

Formulas and Functions (graded)

One of the benefits of Excel is the ability to use formulas and functions.

Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Review your classmates posts to make sure that you’re not duplicating formulas/functions already discussed. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.Be specific!

  • You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
  • You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40–50 hours, and double time for hours over 50.
  • You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due.

Please feel free to add other, unique mathematical challenge questions to the discussion, and let us work together to figure out how you might calculate it.

Devry BIS 155 Week 3 Discussion Latest

Data Analysis Tools (graded)
  1. Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet. That is, try an Internet search for “data analysis with excel” or use some of the methods you learned in this week’s lesson. P.S. Please don’t use the same methods. Show your research and creativity skills.
  2. Assume the role of a regional manager for a retail organization looking at ways to analyze the large amounts of sales data you have. Give some examples.

Note: As you answer these questions, a recommended approach would be to attach a sample Excel spreadsheet that you can use to illustrate your answers.

Devry BIS 155 Week 4 Discussion Latest

Excel Data Exchange (graded)

Excel 2013 provides the capability to exchange data with other applications. Discuss the different types of ways to exchange data between Excel and other Microsoft applications.

  • Are there limitations to the exchange process? Think of some specific examples.
  • How can you exchange data with other applications that are not part of the Microsoft Office Suite? Discuss how you would exchange data with external data sources, such as websites. (Be certain to include your references from your research.)

Devry BIS 155 Week 5 Discussion Latest 

Data Consolidation and What-If Analysis (graded)
  1. Discuss and compare the group summations and What-If analysis (Consolidation) Excel tools. You may need to look up (research) the group summations.
  2. Under what circumstances would you use each of these features? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.

Please include your research references in APA format.

Devry BIS 155 Week 6 Discussion Latest

Bringing It All Together (graded)

This week will be an opportunity to share ideas and approaches to the Excel course project due this week.

  1. 1.What are some spreadsheet features you will use to make your spreadsheet professional, readable, reliable, and repeatable?This is an opportunity to show your creativity and depth of understanding of what you have learned up to this point.
  1. 2.Which spreadsheet functions and data analysis types do you think will be the most challenging to implement in this project?You will need to have reviewed the project requirements prior to answering this question.You might want to look at how you responded to the above question, and from that list, identify implementation challenges, and state why you feel that way.

Devry BIS 155 Week 7 Discussion Latest

Uses and Applications of Statistics (graded)

More than 100 years ago, H.G. Wells commented that “statistical thinking will one day be as necessary as the ability to read and write.” If you were to google “statistics for managers”, you will see a list of all sorts of books on this topic, followed by thousands of articles and resources.

Provide a detailed application for the use of some of the many forms of statistics in business. As you perform this analysis, be sure to describe the scenario in detail, why you will need the use of statistics, and explain which type of statistics you will use to solve your scenario question. Two-hundred-word minimum, well formatted and referenced.

Download File Now


Devry BIS 155 ALL Quiz Latest

Devry BIS 155 ALL Quiz Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-155-all-quiz-latest/

Devry BIS 155 ALL Quiz Latest

Devry BIS 155 Quiz 1 Latest

 

Question 1. Question : (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)?

Student Answer: Displays the name of a worksheet within a workbook

Is at the intersection of a column and a row

Identifies the address of the current cell

Displays the content of the active cell

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 2. Question : (TCO 1) In Excel 2010, a sheet tab ________.

Student Answer: displays the content of the active cell

conceals the applicable formulas for the workbook

identifies the address of the current cell

displays the name of a worksheet within a workbook

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 3. Question : (TCO 1) Which of the following best describes the AutoComplete function?

Student Answer: Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 4. Question : (TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?

Student Answer: Includes letters, numbers, and spaces

Controls the sequence in which Excel performs arithmetic operations

Is a software application used to create and modify business communications

Includes formulas, functions, and formatting

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 5. Question : (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?

Student Answer: Cannot complete a sequence of dates in a column

Changes the background color of the selected cells to yellow

Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula

Has two or more sub-commands related to the command

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 6. Question : (TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?

Student Answer: Just type longer or taller formulas in some of them

Click and drag across the cells to select them and use any sizing method you choose

Drag the fill handle across the cells

Type A1 in the “Go To” dialog box

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 7. Question : (TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a:

Student Answer: workbook.

ledger.

document.

journal.

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 8. Question : (TCO1) In Excel, a border ________.

Student Answer: is data from another cell that is only temporarily residing in the active cell

is a line that surrounds a cell or a range of cells

never prints

is preset and weight cannot be adjusted

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 9. Question : (TCO 3) A chart can be defined as ________.

Student Answer: a group of related data points

a visual representation of numerical data

a numeric value that describes a single value on a chart

text that describes a collection of data points in a chart

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 10. Question : (TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole.

Student Answer: column chart

pie chart

bar chart

line chart

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 11. Question : (TCO 3) When creating a chart in Excel, a single data series _____.

Student Answer: compares values for one set of data

groups or clusters similar data in columns to compare values across categories

is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

compares two or more sets of data in one chart

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 12. Question : (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:

Student Answer: stacked column chart.

pie chart.

3-D column chart.

box diagram.

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 13. Question : (TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart.

Student Answer: expanded

exploded

displaced

clustered

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 14. Question : (TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs:

Student Answer: Design, Layout, and Format.

Home, Insert, and Page Layout.

Chart, Type, and Formulas.

Data, Review, and Data.

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 15. Question : (TCO 3) Which of the following best describes a trendline?

Student Answer: A line used to depict trends and forecast future data

Text that describes a collection of data points in a chart

A group of related data points

Displays data comparisons vertically in columns

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Devry BIS 155 Quiz 2 Latest

 

Grade Details – All Questions

Question 1. Question : (TCO 2) A formula in Excel begins with a(n):

Student Answer: *.

$.

=.

/.

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

Question 2. Question : (TCO 2) In Excel, a function can be defined as a _____.

Student Answer: predefined formula that performs a calculation

cell reference or a value

list of values and defined names as you enter data into a spreadsheet

set of rules that govern the structure and components for a formula

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

Question 3. Question : (TCO 2) =$E2-G$4 contains examples of _____ cell references.

Student Answer:

Question 4. Question : (TCO 2) In Excel, an Argument would be best described by which of the following statements?

Student Answer: Calculates the total of values contained in two or more cells.

Displays a list of functions and defined names as you enter a function.

Is an input, such as a cell reference or a value needed to complete a function.

Is a small pop-up description that displays the results of the cell.

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

Question 5. Question : (TCO 2) The _____ function returns a result based on a condition.

Student Answer:

Instructor Explanation:

Question 6. Question : (TCO 2) Which of the following best describes the COUNT function?

Student Answer:

Question 7. Question : (TCO 2) The NOW function would perform which of the following?

Student Answer

Question 8. Question : (TCO 2) If you enter an = and the first few letters of a function in the formula bar, Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.

Student Answer:

Question 9. Question : (TCO 2) Which of the following best describes the HLOOKUP function?

Student Answer:

Question 10. Question : (TCO 2) To simplify entering ranges in formulas, you can use _____.

Student Answer:

Question 11. Question : (TCO 2) The PMT function is best described by which of the following?

Student Answer:

Question 12. Question : (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.

Student Answer

Question 13. Question : (TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.

Student Answer:

Question 14. Question : (TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.

Student Answer

Question 15. Question : (TCO 7) Users must click _____ Content to use the workbook and run the macros in the workbook.

Student Answer:

Devry BIS 155 Quiz 3 Latest

Grading Summary

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: 7/26/2015

Time Spent: 26 min , 08 secs

Points Received: 28 / 30 (93.3%)

Question Type: # Of Questions: # Correct:

Multiple Choice 15 14

Grade Details – All Questions

Question 1. Question : (TCO 4) In Excel, a dataset would be which of the following?

Student Answer:

Comments:

Question 2. Question : (TCO 4) Which of the following best describes a page break?

Student Answer:

Question 3. Question : (TCO 4) To create a table from an existing range of data, _____.

Student Answer:

Comments:

Question 4. Question : (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.

Student Answer:

Comments:

Question 5. Question : (TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.

Student Answer:

Points Received: 2 of 2

Comments:

Question 6. Question : (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____.

Student Answer:

Question 7. Question : (TCO 4) When data is grouped, the margin area displays the _____.

Student Answer:

Comments:

Question 8. Question : (TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group.

Student Answer:

Question 9. Question : (TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?

Student Answer:

Comments:

Question 10. Question : (TCO 4) A faster way to expand all categories at one time is to click _____.

Student Answer:

Points Received: 2 of 2

Comments:

Question 11. Question : (TCO 4) Data displayed in the PivotTable will be updated _____.

Student Answer:

Points Received: 2 of 2

Comments:

Question 12. Question : (TCO 4) What are the areas of a PivotTable Report where fields can be placed?

Comments:

Question 13. Question : (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.

Question 14. Question : (TCO 4) Click the _____ to sort or filter the chart representation based on the values.

Comments:

Question 15. Question : (TCO 4) Pivot Charts look best when they use basic charts, such as a _____.

Devry BIS 155 Quiz 4 Latest

Grading Summary

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: Time Spent: 59 min , 18 secs

Points Received: 28 / 30 (93.3%)

Question Type: # Of Questions: # Correct:

Multiple Choice 15 14

Grade Details – All Questions

Question 1. Question : (TCO 8) Which of the following is one of the most common file types imported into Excel?

Student Answer:

Question 2. Question : (TCO 8) Which of the following is NOT a text file?

Student Answer:

Question 3. Question : (TCO 8) Which of the following is NOT a method for refreshing data?

Student Answer:

Comments:

Question 4. Question : (TCO 8) Text to Columns command splits text in one column into separate ________.

Student Answer:

Comments:

Question 5. Question : (TCO 8) Which of the following is an example of a text string?

Student Answer:

Comments:

Question 6. Question : (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.

Student

Comments:

Question 7. Question : (TCO 8) Which of the following will produce the same result as the CONCATENATE function?

Student Answer: =

Points Received: 2 of 2

Comments:

Question 8. Question : (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon.

Student Answer:

Comments:

Question 9. Question : (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?

Student Answer:

Comments:

Question 10. Question : (TCO 8) If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need:

Student Answer:

Points Received: 2 of 2

Comments:

Question 11. Question : (TCO 8) The ________ command displays all comments in the entire workbook.

Student Answer:

:

Question 12. Question : (TCO 8) An Excel file saved as a .pdf does all the following EXCEPT:

Student Answer:

Question 13. Question : (TCO 8) The ________ command displays additional document properties such as Company.

Student Answer:

Question 14. Question : (TCO 8) Which function is similar to the Find and Replace feature?

Student Answer:

Comments:

Question 15. Question : (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.

Student Answer:

Devry BIS 155 Quiz 5 Latest

Grading Summary

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: Time Spent: 13 min , 35 secs

Points Received:

Question Type: # Of Questions: # Correct:

Multiple Choice 15 15

Grade Details – All Questions

Question 1. Question : (TCO 5) The tabs of grouped worksheets are displayed with a ________ background.

Question 2. Question : (TCO5) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets:

Student Answer:

Comments:

Question 3. Question : (TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window.

Student

Question 4. Question : (TCO 5) In Excel, which of the following is NOT a method for removing a split window?

Student Answer: Drag a split bar to the edge of the worksheet.

Double-click a split bar.

Click Split in the Window group on the View tab.

Right-click in the active cell and click Remove.

Instructor Explanation: Textbook Chapter 8

Points Received: 2 of 2

Comments:

Question 5. Question : (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?

Student Answer:

Question 6. Question : (TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT:

Student Answer:

Question 7. Question : (TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)?

Student Answer:

Question 8. Question : (TCO 6) When creating a range for the substitution values in a one-variable data table, it is best to arrange them in a(n) ________ orientation.

Student Answer:

Question 9. Question : (TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?

Student Answer:

Question 10. Question : (TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?

Student Answer:

Question 11. Question : (TCO 6) The value you want to achieve in Goal Seek needs to be entered in the ________ box in the Goal Seek dialog box.

Student Answer:

Question 12. Question : (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

Student Answer:

Question 13. Question : (TCO 6) Which of the following is NOT one of the three parameters in Solver?

Student Answer:

Question 14. Question : (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?

Student Answer:

Question 15. Question : (TCO 6) The maximum number of scenarios Scenario Manager can handle is:

Student Answer:

Download File Now


Devry BIS 155 All Ilabs Latest

Devry BIS 155 All Ilabs Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-155-all-ilabs-latest/

Devry BIS 155 All Ilabs Latest

Devry BIS 155 week 1 Lab 1 of 7: Saddle River Marching Band

ILAB OVERVIEW

Scenario/Summary

You are the assistant to the band director for the Upper Saddle River Marching Band, and you must prepare a report showing the status of the marching band fundraising event for presentation to the board of trustees. 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, format for presentation to the board, and add charts to graphically depict the sales over time and by product.

Deliverables

After completing the steps below, turn in one Excel 2010 workbook. The workbook should be named Lab1_yourLastName.xlsx.When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity

ILAB STEPS

STEP 1: Open the workbook and add a documentation sheet (5 points)

.equella.ecollege.com/file/7795734d-3edb-4141-b267-d85b867906fc/1/BIS155_W1_iLab.html#top”>Back to Top

Begin the lab by locating the spreadsheet, chap1_cap_fundraising.xslx, in Doc Sharing (Lab Materials). Open the workbook in Excel 2010, and rename it Lab1_your lastname.xlsx (Mary Jones would save the file as Lab1_jones.xlsx).

  • .equella.ecollege.com/file/7795734d-3edb-4141-b267-d85b867906fc/1/documents–Opening_a_Document_in_the_iLab_Environment.pdf”>Step-by-Step Guide:Opening a File in the iLab Environment

Insert a new spreadsheet into the workbook. Create a Documentation Sheet. Include your name, the date, and the purpose of the spreadsheet. Your documentation sheet should look something like the one below:

Upper Saddle River Marching Band – Fundraising Event

Creator Your Name
Date Date
Purpose Board of Directors Presentation on Fundraising Sales to date

Need help? Click here for a .equella.ecollege.com/file/7795734d-3edb-4141-b267-d85b867906fc/1/documents–Creating_a_Documentation_Sheet.pdf”>Step-by-Step Guide: Creating the Documentation Sheet.

How to Use The Lab Videos
Please donot rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions, and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step-By-Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you, by showing operations that are similar to, but not exactly the same as, those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

STEP 2: Calculate Values (10 points)

.equella.ecollege.com/file/7795734d-3edb-4141-b267-d85b867906fc/1/BIS155_W1_iLab.html#top”>Back to Top

You are to create the formulas needed to calculate the total sales for each item, the profit per item, and the profit based on the number of items sold to date. You will also create a formula to calculate total profit-to-date and the remaining profit needed to make the Marching Band goal for the fundraising campaign.

NOTE: In the data provided, there is no column for sales on 7/6/2006. The band did not do fundraising on that date due to bad weather. You do not need to adjust the dates or add a column for the skipped date; just use the sales data as given. The skipped date will not cause any problems.

  1. A.In cell C5, enter a formula to calculate profit per item.Profit per item is 50%. Format the cells that hold profit as Currency with two decimal places.

In column N, enter a formula to calculate the total sales for each item.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 1, Step 2B Instructions.

In column O, calculate the profit per item, which will be the total sales for each item multiplied by the profit per item.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 1, Step 2C Instructions.

In cell D15, calculate Total Profit-to-Date. In cell D16, calculate the remaining profit needed to reach the goal.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 1, Step 2D Instructions.

Create a formula to calculate the percentage of profit contributed by the sale of each item. All of the other calculations were based on “relative references.” For example, in cell O5, you created a formula N5 * C5. When you copied the formula to the next row, Excel automatically changed the reference to cell N6 and C6. In this instance, we want to divide the total profit from each item (O5 through O14) by the total profit overall (cell D15). The reference to the item will change, but the reference to the total profit to date will remain the same. We can use an absolute reference to do this. In cell P5, we will enter =O5/$D$15. The dollar signs tell Excel to always reference column D and row 15. Next week, we will learn more about relative and absolute cell referencing.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 1, Step 2E Instructions.

STEP 3: Format the Worksheet (15 points)

Back to Top

Now that you have finished the formulas, you must format the worksheet in a professional manner so that it is suitable for presentation to the board of trustees for the college. Remember to focus on readability and reusability.

Insert a comment in cell D16 to explain the formula underlying this cell.

Download the Lab 1, Step 3A Instructions.

Format the spreadsheet as depicted below:

Download the Lab 1, Step 3B Instructions.

STEP 4: Layout the Worksheet (5 points)

Back to Top

Now that you have finished the major formatting, you must lay out the worksheet to further define and separate the areas of the worksheet. This step makes the worksheet easier to read and prepares for printing.

Change the color of the first tab to a shade of brown.

Rename the second tab Fundraising, and change the color to orange.

Create a custom header with your name on the left and your instructor’s name on the right.

Change the page orientation to landscape.

Download the Lab 1, Step 4 Instructions.

STEP 5: Create Charts (15 points)

Back to Top

Create charts based on the data in your worksheet. The charts provide information visually and help you analyze the information.

Create a 3-D pie chart on a separate sheet that displays the percentage of profits for each item. Include descriptive titles and labels and a graphic pointer to the highest profit item. Your chart should look something like this:

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 1, Step 5A Instructions.

For the next chart, you will need to calculate the total profit per day. Here are the steps:

Copy the daily profit data to a new sheet, and name the sheet Total Sales Data.

In a new section of the worksheet, copy the Items in Column A and the Days.

Then calculate the profit per day for each item

Calculate the total profit per day.

Your data will look something like this:

Create a trend line chart on a separate sheet that shows the total profit by day. Include a descriptive title and labels. Include a callout that indicates the top profit day and label it “Kick Off Event.” Your chart will look something like this:

Make certain that all worksheets in the workbook have meaningful names. Upload the file to the Dropbox. Make sure you post a comment about what you learned when submitting the file.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 1, Step 5 Data Instructions (constructing the data set)

and Lab 1, Step 5B Instructions (creating the line chart).

*Note: The video incorrectly refers to “Sales Per Day”, when it should state “Profit Per Day”. Assume that you are working on Profit Per Day – thank you!

Devry BIS 155 Lab 2 of 7: First National Bank New Loan Report

iLAB OVERVIEW

Scenario/Summary

You are an intern at First National Bank working in the loan department, and your boss has asked you to prepare the monthly “New Loan Report” for the Board of Directors. This analysis report will clearly list and summarize all new loans for residential housing in the past month. The summary area includes the loan statistics as labeled data in the data file. The format of the report is appropriate for the Board of Directors for the First National Bank.

Deliverables

Submit one workbook title Lab2_YourName.xlsm to the Dropbox. (Note that files containing macros have the extension, .xlsm rather than .xlsx.) When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

iLAB STEPS

STEP 1: Open, Save, and Document the Workbook (3 points)

Back to Top

Locate the file chap2_cap_housing.xlsx in Lab Materials in Doc Sharing. Open the file in Excel, and save it as Lab2_yourlastname.

Add a documentation sheet that provides a spreadsheet title, author, date, and purpose. Format the documentation sheet. The Bank’s logo is dark blue, so use a color scheme that reflects that logo. Select complementary Font and Fill colors for the documentation sheet. Ensure that the sheet tab is named Documentation and that the documentation sheet is the first sheet in the workbook.

(To get help on creating a documentation sheet, refer to Lab 1, Step 1.)

How to use the lab videos

Please do not rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step-By-Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you by showing operations that are similar to, but not exactly the same as, those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

STEP 2: Create Calculations (10 points)

Back to Top

Functions are used to calculate the interest rate, down payment, monthly payment, and average selling price for each residential home in the worksheet. You need to create a formula to determine the down payment. Finish the calculations by using the appropriate functions to complete the Loan Statistics summary area of the worksheet.

Use a VLOOKUP function to determine the interest rates in column D.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2A Instructions.

Calculate the down payment by multiplying the results of a VLOOKUP function by the selling price. Enter the formula in column E.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2B Instructions.

Calculate the amount financed by subtracting the down payment from the selling price. Enter the formula in column F.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

No detailed written instructions are necessary for the Lab 2, Step 2C. The only written instruction needed is already listed after the outline letter C, above the Step 2C box.

Use a PMT function to determine the monthly payments in column G.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2D Instructions.

Use appropriate formulas and functions to calculate over loan statistics for the month:

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2E Instructions.

Number of Loans, Highest Amount Financed, Lowest Amount Financed, Total Amount Financed.

STEP 3: Format the Worksheet (9 points)

Back to Top

Now that you have finished the calculations, you must format the worksheet in a professional manner suitable for delivering to the Board of Directors. Your final worksheet will look something like the worksheet below:

Format all money figures as currency with two decimals and all percentages as percents.

Adjust columns sizes to fit the data.

Merge and Center titles and size appropriately.

Change Font color to dark blue.

Add a small graphic appropriate for the purpose of the worksheet.

Separate sections of the worksheet and provide borders as appropriate.

STEP 4: Create an Excel Application with Macro and Macro Button (28 points)

Back to Top

NOTE: At the end of this step, you will save the file as an xlsm file rather than an xlsx file. This is the filetype that allows you to save a file that includes a Macro.

Add a new worksheet to the workbook, and name it Loan calculator.

Devry BIS 155 Lab 3 of 7: Alice Barr Realty Analysis 

iLAB OVERVIEW

Scenario/Summary

You are an intern at First National Bank working in the loan department, and your boss has asked you to prepare the monthly “New Loan Report” for the Board of Directors. This analysis report will clearly list and summarize all new loans for residential housing in the past month. The summary area includes the loan statistics as labeled data in the data file. The format of the report is appropriate for the Board of Directors for the First National Bank.

Deliverables

Submit one workbook title Lab2_YourName.xlsm to the Dropbox. (Note that files containing macros have the extension, .xlsm rather than .xlsx.) When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

iLAB STEPS

STEP 1: Open, Save, and Document the Workbook (3 points)

Back to Top

Locate the file chap2_cap_housing.xlsx in Lab Materials in Doc Sharing. Open the file in Excel, and save it as Lab2_yourlastname.

Add a documentation sheet that provides a spreadsheet title, author, date, and purpose. Format the documentation sheet. The Bank’s logo is dark blue, so use a color scheme that reflects that logo. Select complementary Font and Fill colors for the documentation sheet. Ensure that the sheet tab is named Documentation and that the documentation sheet is the first sheet in the workbook.

(To get help on creating a documentation sheet, refer to Lab 1, Step 1.)

How to use the lab videos

Please do not rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step-By-Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you by showing operations that are similar to, but not exactly the same as, those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

STEP 2: Create Calculations (10 points)

Back to Top

Functions are used to calculate the interest rate, down payment, monthly payment, and average selling price for each residential home in the worksheet. You need to create a formula to determine the down payment. Finish the calculations by using the appropriate functions to complete the Loan Statistics summary area of the worksheet.

Use a VLOOKUP function to determine the interest rates in column D.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2A Instructions.

Calculate the down payment by multiplying the results of a VLOOKUP function by the selling price. Enter the formula in column E.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2B Instructions.

Calculate the amount financed by subtracting the down payment from the selling price. Enter the formula in column F.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

No detailed written instructions are necessary for the Lab 2, Step 2C. The only written instruction needed is already listed after the outline letter C, above the Step 2C box.

Use a PMT function to determine the monthly payments in column G.

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2D Instructions.

Use appropriate formulas and functions to calculate over loan statistics for the month:

Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

Download the Lab 2, Step 2E Instructions.

Number of Loans, Highest Amount Financed, Lowest Amount Financed, Total Amount Financed.

STEP 3: Format the Worksheet (9 points)

Back to Top

Now that you have finished the calculations, you must format the worksheet in a professional manner suitable for delivering to the Board of Directors. Your final worksheet will look something like the worksheet below:

Format all money figures as currency with two decimals and all percentages as percents.

Adjust columns sizes to fit the data.

Merge and Center titles and size appropriately.

Change Font color to dark blue.

Add a small graphic appropriate for the purpose of the worksheet.

Separate sections of the worksheet and provide borders as appropriate.

STEP 4: Create an Excel Application with Macro and Macro Button (28 points)

Back to Top

NOTE: At the end of this step, you will save the file as an xlsm file rather than an xlsx file. This is the filetype that allows you to save a file that includes a Macro.

Add a new worksheet to the workbook, and name it Loan calculator.

Devry BIS 155 Lab 4 of 7: Fundraiser Letter 

ILAB OVERVIEW

Scenario/Summary

You work with the XYZ Corporation Charitable Trust allows you to demonstrate your expertise with Excel. The trust is sponsoring an auction, and you have received a list of all donors who have contributed to this auction. The list was pulled from the Corporation’s database as a comma separated text file. You have been asked to create a letter that will go out to each of the contributors that will accept their donation. Tickets to the event will be enclosed. The letter requires that you provide the following pieces of information:

  • Full Name and Address
  • First Name
  • Donated Item
  • Value
  • Number of tickets requested

Deliverables

Your will turn in one Excel spreadsheet and two Word documents. You will locate the following files in DocSharing (Lab Materials folder): wk4_trust.txt and wk4_trust_letter.docx. You will submit the following three items: one Excel spreadsheet (Lab4_yourlastname.xlsx), one Word document showing 25 letters (Lab4_yourlastname.docx), and one Word document showing 25 labels (Lab4_yourlastname_labels.docx). When submitting the Excel workbook and the Word documents, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

ILAB STEPS

STEP 1: Import text file into a spreadsheet and clean up data (20 points)

.equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/BIS155_W4_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/documents–BIS155_W4_Lab4_Instruction_Step1.pdf”>Lab 4, Step 1 Instructions.

  1. A.Import the text file into Excel and save as lab4_yourlastname.xlsx.Import only the data you will need for your letter.
  2. B.Separate the first and last names into two columns so that you may use the first name in a Mail Merge.Make sure the fields are named LastName and FirstName.
  3. C.Check the accuracy of all data by using the Spelling tool in the Proofing group.
  4. D.Add a documentation sheet that provides a spreadsheet title, author, date, and purpose.Format the documentation sheet by applying a professional color scheme to the text. Ensure that the sheet tab is named Documentation and that the documentation sheet is the first sheet in the workbook.(To get help on creating a documentation sheet, refer to Lab 1, Step 1.)
How to use the lab videos
Please donot rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions, and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step-By-Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you, by showing operations that are similar to, but not exactly the same as, those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

E.

F. STEP 2: Create Merge Document (15 points)

.equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/BIS155_W4_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/documents–BIS155_W4_Lab4_Instruction_Step2.pdf”>Lab 4, Step 2 Instructions.

  1. A.Open the wk4_trust_letter document in Word.Make sure that the document is in the same folder as the Excel spreadsheet. This will make it easier to work with the two documents during the Merge process.
  2. B.Merge information from your Excel spreadsheet into the Word document.Your completed Merge will look like the following when complete:

9/27/2007
XYZ Corporation Charitable Trust
123 Adams Street
Pittsburgh, PA 15697

Shelly Martin
123 North Street
Pittsburgh, PA 15697

Dear Shelly,

Thank you for your generous donation to the XYZ Corporation Charitable Trust Fundraiser. We are delighted to accep the following donation:

Item: Massage

Item Value: $50.00

Enclosed you will find the 2 tickets you requested for this Fundraising event, which will take place on Friday, October 24, 2007. We will be looking forward to seeing you and giving your personal thanks.

Thank you again for you support of the fund. The proceeds will support international annual rescue efforts.

With Special thanks,

Jeoffrey McMillan
Charitable Trust President
XYZ Corporation

Accept all spelling suggestions in the document, and save document as Lab4_yourlastname.docx.

.equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/BIS155_Week4_iLab_Step2.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

STEP 3: Create Address Labels (15 points)

.equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/BIS155_W4_iLab.html#top”>Back to Top

Create labels for the letters. The XYZ Corporation wishes to use mailing labels to address the envelopes. They own 8 1/2 x 11″ sheets of label paper with 1″ by 4″ labels, which they purchased from Office Depot.

Download the .equella.ecollege.com/file/3a0374ef-e280-4eab-914b-3802e2923c02/1/documents–BIS155_W4_Lab4_Instruction_Step3.pdf”>Lab 4, Step 3 Instructions.

  1. C.Create a new file for printing labels.
  2. D.Merge data from your Excel spreadsheet into the new label document.

Submit your completed workbook and the two Word documents (merged letters and merged labels) to the Dropbox. Make sure you post a comment about what you learned when submitting the files.

Devry BIS 155 week 5 Lab 5 of 7: Bruno’s Pizza Analysis

.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_W5_iLab.html#1″>Lab 5 of 7: Bruno’s Pizza | .equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_W5_iLab.html#6″>Lab 6 of 7: Day Care Center

Lab 5 of 7: Bruno’s Pizza Analysis (50 Points each)

ILAB OVERVIEW

Scenario/Summary

The owner of Bruno’s Pizza, Joe Bruno, wants to evaluate the profitability of his three restaurants before he expands further. He is particularly interested in the comparative results of three dining categories, dine-in, pickup, and delivery. Joe has asked for your help in doing this analysis in return for a small stipend and all the pizza you can eat. You have already prepared a template and distributed it to each restaurant manager, who has entered the sales data for last year. Your next task is to consolidate the data into a single workbook that shows the total sales for each quarter and each dining category. The information should be shown in tabular, as well as graphical formats. You will also create a documentation sheet so that Joe will know exactly what you have created.

Deliverables

Turn in one workbook, titled Lab5_yourlastname.xlsx. When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. IMPORTANT: There are two iLabs this week, and there is a separate Dropbox basket for each one. Be sure to submit your work for this iLab (Lab 5) to the Dropbox basket labeled simply Week 5: iLabnotto the basket labeled Week 5: iLab – 6.

ILAB STEPS

STEP 1: Open all Worksheets and consolidate into a summary worksheet. (10 points)

.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_W5_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/documents–BIS155_W5_Lab5_Instructions_Step1.pdf”>Lab 5, Step 1 Instructions.

You must open four workbooks–the partially completed Summary worksheet and the completed Westside, Eastside, and Downtown workbooks. Consolidate the data from the three completed worksheets into the Summary worksheet.

  1. A.From Doc Sharing, Lab Materials, open the chap7_cap files: Summary, Eastside, Downtown, and Westside.
  2. B.Copy the data from the Eastside, Downtown, and Westside workbooks into the Summary workbook so that the Summary workbook has four worksheets.
  3. C.Rename the Summary file lab5_yourlastname.xlsx.
  4. D.Close all files except the Summary Workbook.
How to use the lab videos
Please donot rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions, and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step-By-Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you, by showing operations that are similar to, but not exactly the same as, those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

E.

.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_Week5_iLab_Step1.html”>Transcript

This video will demonstrate how to complete the current step(s) of this week’s Lab.

The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guide.

** Please be patient when loading these videos as they can be large.

STEP 2: Summarize Dining Categories by Quarter (15 points)

.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_W5_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/documents–BIS155_W5_Lab5_Instructions_Step2.pdf”>Lab 5, Step 2 Instructions.

You must provide a summary report of the dining category sales by quarter for the year so that Joe Bruno knows exactly what each location is doing.

  1. A.Create formulas to calculate sales by dining category and quarter on the Summary Sheet.
  2. B.Group the worksheets and add Grand Totals by Dining Category and by Quarter.
.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_Week5_iLab_Step2.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

STEP 3: Create Graph (15 points)

.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_W5_iLab.html#top”>Back to Top

Joe Bruno is more of a visual person, and you want to present your data in an alternate way. You will create a Chart to summarize your data.

  1. A.Create a Chart on a separate sheet.Your chart should show the amount of income from each of the dining categories displayed by Quarter. A trend line might help him to see the area of highest growth.
  2. B.Include a title, legend, and data labels on your chart.
  3. C.Format the chart to coordinate with your summary table, using the same colors, fonts, titles, and clip art.

Need help? Review Week 1 Step-by-Step instructions for Charting. Hint: Select Clustered Columns as your basic Chart Type. The following is a suggested format (your answers may vary):

STEP 4: Create Scenarios and a Scenario Summary (10 points)

.equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/BIS155_W5_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/24a84389-f506-4908-bb3c-a38d4f1aa487/1/documents–BIS155_W6_Lab6_Instructions_Step4.pdf”>Lab 6, Step 4 Instructions.

Jane wants to look at three scenarios.

Scenario Teacher Salary Supplies Number Tuition
Economy 15,000 25 15 35
Midrange 26,000 60 8 50
High 38,000 100 6 100

She wants to see the Net Income that would be achieved in each Scenario and compare this to her original assumptions.

  1. A.Name the cells that will be used in the Scenario.
  2. B.Create the three Scenarios.
  3. C.Create a Scenario Summary.
  4. D.Move the Scenario Summary to the end of the workbook.

Devry BIS 155 Lab 7 of 7: Home Inventory 

ILAB OVERVIEW

Scenario/Summary

Hopefully you will find this week’s lab activity fun and useful. If you have never created a database, you will be able to tell all of your friends and family that you are now a database designer! You will walk through the steps of creating and populating an Access database to keep a record of items in your home. The database will have a table, a form, a query, and a report. You will need to use Microsoft Access 2010. In the event you do not have Access, you can use the iLab environment. Make sure to copy your files down to your pc and upload to the Dropbox. The following videos will refresh you with the use of the iLab environment and transfer of files.

.next.ecollege.com/default/launch.ed?ssoType=DVUHubSSO2&node=3640″>https://hub2.devry.edu/node/3640

.next.ecollege.com/default/launch.ed?ssoType=DVUHubSSO2&node=CopyingFilesFromCitrix”>https://hub2.devry.edu/CopyingFilesFromCitrix

Deliverables

Turn in one database named Lab7_yourlastname.accdb to the Dropbox. When submitting the database, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

ILAB STEPS

STEP 1: Create a Table (10 points)

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_W7_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/documents–BIS155_W7_Lab7_Instructions_Step1.pdf”>Lab 7, Step 1 Instructions.

NOTE: For this lab, you will not have a starter file. You will create a database from scratch.

In this step, you will create a blank database and add one table to the database. The table should contain at least the following fields:

  • ID: Autonumber field to provide a unique identifier for each item in your table
  • Item: Text field to store the Item name
  • Description: Memo field to store a description of the item
  • Condition: Lookup field to store the condition the item is in (Good, great, etc.)
  • Acquired Date: Date field stored in “Short Date” format (M/DD/YYYY)
  • Purchase Price: Currency Field to store the price you paid for the item
  • Location: Lookup field to store the names of the rooms in your house
  • Manufacturer: Text field
  • Model: Text field to store information about the model of the item
  • Comments: Memo field to store any comments you might wish to add
  • SerialNumber: Text field to store the serial number of the item (where applicable)
  • Warranty: Boolean field (Yes/No) that will record whether the item has a warranty
  • ManufacturerURL: Hyperlink field with the support website for the item (optional)

You may add other fields if you wish.

How to use the lab videos
Please donot rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions, and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step-By-Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you, by showing operations that are similar to, but not exactly the same as, those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_Week7_iLab_Step1_Part1.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_Week7_iLab_Step1_Part2.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_Week7_iLab_Step1_Part3.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

STEP 2: Create a Form for data entry and add at least 10 records (15 points)

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_W7_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/documents–BIS155_W7_Lab7_Instructions_Step2.pdf”>Lab 7, Step 2 Instructions.

Entering data in Datasheet View requires a large amount of scrolling. It also exposes the table design to users, which means that users can make changes to the database design that you don’t wish them to make. Create a form to enable easy entry of data. Use the form to enter at least 10 records.

  1. A.Create the form.Select an AutoFormat and modify the form to make it more user friendly by adding a descriptive title and making minor modifications to the form layout.
  2. B.Enter 10 records.For at least one of these records, select Office as the Location.
.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/Wk7_ilab_Step2.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

STEP 3: Create a Query to Select Records (10 points)

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_W7_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/documents–BIS155_W7_Lab7_Instructions_Step3.pdf”>Lab 7, Step 3 Instructions.

Once data have been entered into a database, you will want to be able to select and retrieve data. The Query object allows you to select data from your database tables that will answer questions you might have. For example, suppose you had a small fire in your office and you wish to make an insurance claim. Using a query, you will be able to select only those records in the database that have the Location equal to “Office.” Write a query that will allow you to select records based on a room you select.

  1. A.Use the Create Tab and select Query Wizard.Create a Simple query that selects Item, manufacturer, Model, Serial Number, Purchase Price, Acquired Date, and Location.
  2. B.In Design View, add the Condition field to the query.Add a Selection Criteria to the Location field so that only those records with the Location equal to Office are displayed.
  3. C.Save the query as qryItemsbyRoom.
.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/Wk7_ilab_Step3.html”>Transcript

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

STEP 4: Create a Report Showing All Items Grouped by Room (15 points)

.equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/BIS155_W7_iLab.html#top”>Back to Top

Download the .equella.ecollege.com/file/50ee4da9-3754-433b-bddf-fc4334d01ba4/1/documents–BIS155_W7_Lab7_Instructions_Step4.pdf”>Lab 7, Step 4 Instructions.

Reports allow us to create “printable” documents based on the data in our database. Create a report of your entire Inventory, grouped by room. Show only the Item, Manufacturer, Model, and Purchase Price.

  1. A.Use the Report Wizard to create the report.
  2. B.Modify the design so that the title is “Inventory by Room Report” and all data and labels are sized appropriately.
  3. C.Add totals by room and a grand total to the report.Add Labels to the totals.

Your final report should look something like the following (the Style may differ):

Download File Now