BIS 155 COMPLETE WEEK LAB ASSIGNMENTS PACK-DEVRY
Visit Below Link, To Download This Course:
BIS 155 Complete Week Lab Assignments Pack-DeVry
BIS155
BIS 155 Week 1 DQ 1 Latest-DeVry
Special Course Preparedness (graded)
Please read the course announcements and the Syllabus in
particular. Pay particular attention to grading, attendance, discussion
requirements, and the last portion of the Plagiarism section (Using APA) of the
Syllabus. Address each of the items below:
Have you taken COMP100? It is a prerequisite to this course.
Do you have Microsoft Excel 2016 software?
If not, have you accessed the Virtual Lab – Citrix to use Excel
2016?
Discuss the Syllabus – what was one thing that stood out and
why?
Provide two examples of APA citations – one to cite a web
reference, and one to cite a book or journal. NOTE: a URL is not an APA
citation.
BIS 155 Week 1 DQ 2 Latest-DeVry
Getting Familiar With Excel (graded)
Excel was introduced in 1985. Since then, it has become a
standard business tool.
Discuss and explain at least six different (unique) features of
Excel that make it a valuable business tool.
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 2016 overview in the
Course Home section, there are many Excel resources in addition to your text on
the Web. For example, try an Internet search on “top ten Excel 2016 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.
BIS 155 Week 2 DQ Latest-DeVry
Formulas and Functions (graded)
One of the benefits of Excel is the ability to use formulas and
functions.
1. 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 or 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.
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. (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.
BIS 155 Week 4 DQ Latest-DeVry
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.
1. Are there limitations to the exchange process? Think of some
specific examples.
2. 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.)
BIS 155 Week 5 DQ Latest-DeVry
Specialized and Statistical Functions (graded)
1. Discuss and compare the specialized and statistical functions
in Excel. You may need to research your answer.
2. Under what circumstances would you use logical and lookup
functions? What financial and statistical functions exist for use? Give
examples of how each can be used.
Please include your research references in APA format.
BIS 155 Week 6 DQ Latest-DeVry
What-If Analysis (graded)
Life is full of questions and each question deserves a good
answer. Let’s explore the What-If Analysis tools available in Excel. Explain
how these tools are used to assist with solid decision making. Give examples of
how each of the What-If Analysis tools can be used practically. Please include
your research references in APA format.
BIS 155 Week 7 DQ Latest-DeVry
Expert Tools (graded)
1. Excel shares very well with other applications. Why does it
import data so easily from other external sources? What features make it easy
to manipulate this imported data?
2. Adding a macro to an Excel workbook is almost like clicking
the “Easy” button. They can automate very simple tasks. Why are people often
intimidated by macros?
Lab Overview
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.
Comments
Post a Comment