Bis 155 advanced pc applications week 1 to 8 discussions

BIS 155 Advanced PC Applications (Devry)

Don't use plagiarized sources. Get Your Custom Essay on
Bis 155 advanced pc applications week 1 to 8 discussions
Just from $13/Page
Order Essay
Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Week 1-8 Discussion Questions

 

 

 

Week 1

Getting Familiar with Excel (Graded)

Excel was introduced in 1985. Since then, it has become a standard business tool. In this thread, discuss the different features of Excel that make it a valuable business tool. In addition, discuss why Excel skills are so important in today’s job market

 

Week 2

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. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.

  • 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.

Week 3

Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet. Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amounts of sales data you have. What are some of the ways Excel can be used to analyze this data? What are some examples of reports you might want to review? Using the concepts from this week, how will you determine where to start and what tools can you use within Excel to help you organize everything and make decisions?

Week 4

Excel Data Exchange (Graded)

Excel 2010 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? 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.

Week 5

Data Consolidation and What-if Analysis (Graded)

Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.

Week 6

Bringing It AllTogether (Graded)

This week will be an opportunityto share ideas and approaches to the Excel course project. What are some spread sheet features you will use to make your spreadsheet professional, readable, reliable, andrepeatable? Which spreadsheet functions and data analysis types do you think will be the most challenging to implementin this project? What questions do you have about those functions and types of data analysis

Week 7

Database Decisions (Graded)

Discuss the differences between storing data in Access and Excel.Why would you use a spreadsheet over a database? At what point does it become more efficient to store your data in a database rather than a spreadsheet? If you are deciding whether to use a spreadsheet or database, what questions should you consider?

Week 8

Looking Ahead (Not – Graded)

Class,looking back over the Terminal Cours eObjectives for this course, what are you looking forward to learning more about throughout your education and career?

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our Guarantees

At Myrestlab.com, we always work diligently to provide our customers with high-quality nursing assignment help services. We ensure that all papers by our writers possess 100% originality. We also guarantee all students of 100% privacy and confidentiality when working with us.

Money-Back Guarantee

At Myrestlab.com, our mission is to provide quality services to all students. We, therefore, guarantee money-backs for the rare occasions of satisfaction. Your satisfaction is our goal.

Read more

Zero-Plagiarism Guarantee

All our nursing assignment help services are 100% original. Each of our professional writers develops custom papers from scratch to reduce the chances of plagiarism. In addition to this, we always run completed papers through advanced anti-plagiarism checkers for 100% originality.

Read more

Free Revision Policy

Our free revision guarantee is a courtesy service by Myrestlab.com to ensure that we achieve 100% customer satisfaction rates. In case you feel unsatisfied with the outcome of your paper, you can always request for free unlimited revisions. We recommend a revision request within 14 days after the delivery date for short papers and 30 for dissertations.

Read more

Privacy Policy

Myrestlab.com also guarantee 100 privacy and confidentiality. We do not share any of our customers’ personal details with third parties. We have also fitted our websites with security features to ensure secure connections. Our security features also prevent damages that might occur through attacks by outsiders.

Read more

Fair-Cooperation Guarantee

By ordering a paper through My Rest Lab, you agree to receive nursing assignment help services offered by our nursing assignment writers. Our assignment help experts will always endear to provide quality services as promised. We always expect maximum cooperation from our students to help us achieve our mission and vision.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency