BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
BIS 155 COMPLETE WEEK LAB ASSIGNMENTS
PACK- DEVRY
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.
,BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
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.
BIS 155 Week 3 DQ Latest-DeVry
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)
,BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
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?
BIS 155 Week 1 Lab 1 Latest-DeVry
Lab Overview
, BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
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
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
Step Task Points Possible Points Rece
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
BIS 155 COMPLETE WEEK LAB ASSIGNMENTS
PACK- DEVRY
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.
,BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
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.
BIS 155 Week 3 DQ Latest-DeVry
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)
,BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
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?
BIS 155 Week 1 Lab 1 Latest-DeVry
Lab Overview
, BIS 155 Week 7 Lab Exercise: Text Import and Xgame Calculator Macro
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
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
Step Task Points Possible Points Rece
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
