Qrb 501 quantitative reasoning for business final exam

QRB/501 Quantitative Reasoning for Business

Copyright ©2017 by University of Phoenix. All rights reserved.

SYLLABUS

Course Description This course applies quantitative reasoning skills to business problems. Students learn to analyze data using a variety of analytical tools, graphs, tables, and charts. Other topics include formulas, visual representation of quantities, time value of money, and measures of uncertainty.

Course Dates Jul 14, 2017 - Aug 24, 2017

Faculty Information

• Academic Policies University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality.

Academic Resources • Links Library

Instructions Review the Links Library.

• Writing and Style Guidelines (APA) Instructions Review the Writing and Style Guidelines (APA).

• Statistics Tutoring Review the Statistics Tutoring lab.

Get Ready for Class • Familiarize yourself with the textbook used in this course.

Instructions Cleaves, C., Hobbs, M., & Noble, J. (2017). Business Math (11th ed.). New York City, NY: Pearson Education.

• Student Strategic Textbook Reading Instructions Do not read each assigned chapter and article word for word. Instead, take a strategic approach to reading by doing the following:

1. Starting with the assignment(s) you need to complete each week, you should identify the key concepts you need to complete your deliverable(s). 2. Locate the key concepts in the reading. 3. While highlighting the key concepts in each chapter and article, take notes. To help you quickly understand the concept, write the notes in your own words. Make sure you record the citation for later application in your deliverable

Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents (both located on your student website):

Policies

Eric Godat (PRIMARY)Name : Email Address : eric.a.godat@uscis.dhs.gov Phone Number : (213) 337-6158

https://ecampus.phoenix.edu/secure/aapd/gbam/libraries/gbamlinks.htm
https://ecampus.phoenix.edu/secure/aapd/cwe/style.htm
(s). 4. Look for opportunities to discuss the concepts with your team members, classmates, colleagues, and friends. 5. Apply the concepts in your deliverable(s).

Course Materials All electronic materials are available on your student website.

Week1 Jul, 14 - Jul, 20 Fundamental Quantitative Concepts for Managers

Tasks

1.1 Understand the order of operations to evaluate expressions. 1.2 Use equations to solve problems. 1.3 Evaluate formulas. 1.4 Use Microsoft Excel® to convert percentages to decimal numbers, decimal numbers to percentages, and increase/decrease digits after the decimal point. 1.5 Use Microsoft Excel® to evaluate amounts of increase/decrease (absolute change) in percent problems. 1.6 Use Microsoft Excel® to evaluate percentages of increase/decrease (relative change) in percent problems. 1.7 Use Microsoft Excel® to evaluate the amount of increase/decrease from a percentage. 1.8 Use percentages for evaluating, comparing, and analyzing two numbers.

Objectives/Competencies

Required Learning Activities • Business Math, Ch. 5: Equations

Read Ch. 5 of Business Math. Consider the following as you read:

• How to use order of operations to evaluate an expression.

Instructions

• Business Math, Ch. 6: Percents

Read Ch. 6 of Business Math. Consider the following as you read:

• How to use Excel® to convert a decimal number to a percent and vice-versa. • How to determine absolute changes (increase or decrease) and relative changes (percentage change).

Instructions

• Week 1 Most Challenging Concepts

Recall the readings and activities you have completed this week and describe the one or two points that were least clear to you. What questions do you have that would help you understand these points better?

Instructions

• Live Math Tutoring

Join a Live Math Tutoring session if you experience difficulties with a homework problem.

While you are in the session, familiarize yourself with the whiteboard environment and the tools used in the

Instructions

• Getting Started with VitalSource eBooks • Learning Team Overview • Microsoft® Excel® Video

whiteboard. Discuss any questions you may have with a tutor. Tutors can only help you with homework exercises. Tutors cannot help you with Quizzes or the Final Exam.

Assignments See the student website for additional recommended learning activities that may help you learn this week's concepts.

Title Type Due Points

Week 1 Participation Instructions: Participate in class discussion.

Individual Jul 20, 2017 05:59 PM 4

Fundamental Quantitative Concepts Exercises Instructions: Purpose of Assignment The purpose of this assignment is for students to learn how to use Microsoft Excel® for solving formulas. Managers and staff need to work with percentages daily in professional settings. Skills such as finding the percentage increase/decrease and using Excel® to convert from decimals to percentages and vice versa have become necessary. This assignment provides students with the practice of such fundamental quantitative concepts. Assignment Steps Resources: Fundamental Quantitative Concepts Exercises Excel® Template Save the Fundamental Quantitative Concepts Exercises Excel® Template to your computer. Read the instructions on the first tab. Complete the ten Excel® exercises. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Fundamental Quantitative Concepts Exercises Excel® TemplateFundamental Quantitative Concepts Exercises Grading Guide

Individual Jul 20, 2017 05:59 PM 6

Week2 Jul, 21 - Jul, 27 Mathematics of Buying and Selling

2.1 Mathematics of buying – trade and cash discounts. 2.2 Single trade discounts. 2.3 Trade discount series. 2.4 Cash discounts and sales terms. 2.5 Mathematics of selling – markup and markdown. 2.6 Markups based on cost and selling price. 2.7 Conversion of markups based on selling price to markups based on costs and vice versa. 2.8 Markdowns and perishables.

Objectives/Competencies

Required Learning Activities • Business Math, Ch. 8: Trade and Cash Discounts

Read Ch. 8 of Business Math. Consider the following as you read:

• Understand discounting and invoicing terms.

Instructions

• Business Math, Ch. 9: Markup and Markdown

Read Ch. 9 of Business Math. Consider the following as you read:

• How to evaluate markups based on cost and selling price. • How to evaluate markdowns. • How to evaluate the unit selling price of perishable goods.

Instructions

• Week 2 Most Challenging Concepts

Recall the readings and activities you have completed this week and describe the one or two points that were least clear to you. What questions do you have that would help you understand these points better?

Instructions

Assignments See the student website for additional recommended learning activities that may help you learn this week's concepts.

Title Type Due Points

Week 2 Participation Instructions: Participate in class discussion.

Individual Jul 27, 2017 05:59 PM 3

Learning Team Charter Instructions: Overview In this course, your team will work together to complete a few assignments. This chartering assignment is designed to help you apply your project management skills to understand the scope of your project, then break the project into goals, tasks, responsibilities, resources, and milestones. The assignment also asks you to discuss and answer some questions that will lay the foundation for developing your project. Beyond the Standard Charter You will notice that this chartering process goes beyond your standard University of Phoenix Charter by helping your team create a project plan for team success by providing you with opportunities to define your deliverables, recognize the connections between the deliverables and other classroom activities, determine your timelines and milestones, identify each team member's expected contribution, and answer questions that lay the foundation for building your projects. Putting "I" in "Team" Important to note is the section for defining learning team expectations related to participation, collaboration, communication, team contributions, assignment deadlines, and other considerations. Please take the time to discuss and document how your team will address each area and any challenges that may arise. It is important to understand that we are "Putting 'I' in 'Team'". In short, we will recognize and reward individuals according to their contributions to team output, not according to their team membership. This means that individual grades may be different from the team grade depending on each individual's contribution to each team deliverable. Completing This Assignment Do the following to complete this assignment:

• Review the Charter and Project plan. • Review the weekly Learning Team deliverables. • Complete the provided Learning Team Charter and Project Plan, including the following: team member contact information, project by week, learning team expectations, team discussion questions. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Learning Team Charter and Project Plan

Learning team

Jul 27, 2017 05:59 PM 2

Equations and Percentage Cases Instructions: Purpose of Assignment The purpose of this assignment is to provide students an opportunity to apply the concepts of equations and percentages covered in Ch. 5 and 6 to integrated case studies. Assignment Steps Resources: Equations and Percentage Cases Excel® Template, Excel® 2016 Essential Training Save the Equations and Percentage Cases Excel® Template to your computer. Read the instructions on the first tab. Complete the two Excel® cases located in the template. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Equations and Percentage Cases Excel® TemplateEquations and Percentage Cases Grading GuideExcel® 2016 Essential Training

Individual Jul 27, 2017 05:59 PM 6

Week3 Jul, 28 - Aug, 03 Introduction to Data Analysis (Statistics)

3.1 Understand the types of data: qualitative and quantitative. 3.2 Read the bar, pie, and line charts and analyze information to make decisions. 3.3 Use Microsoft Excel® pivot tables to create frequency distributions and charts for qualitative data – bar and pie. Interpret information and make decisions. 3.4 Use Microsoft Excel® to create charts for quantitative data – time-series chart. Interpret information and make decisions. 3.5 Use Microsoft Excel® pivot tables to create frequency Distributions for quantitative data. Analyze information. 3.6 Introduction to descriptive statistics. 3.7 Evaluate and interpret measures of center – mean, median, and mode. 3.8 Evaluate and interpret measures of variation – range, standard deviation, and variance.

Objectives/Competencies

Required Learning Activities • Business Math, Ch. 7: Business Statistics

Read Ch. 7 of Business Math. Consider the following as you read:

• How to read bar, pie, and line graphs. • Understand and interpret mean, median, mode, standard deviation, and variance.

Instructions

• Excel® 2013: Pivot Tables in Depth

Watch the instructional videos by clicking on the Lynda.com® link. Type the titles "Excel 2013: Pivot Tables in Depth" or "Excel 2016: Pivot tables in Depth" in the Search Bar to find the video. Consider the following as you watch:

• Understand how to use pivot tables to summarize, sort, count, and chart your data in Microsoft® Excel® 2013 and 2016.

Instructions

• Week 3 Most Challenging Concepts

Recall the readings and activities you have completed this week and describe the one or two points that were least clear to you. What questions do you have that would help you understand these points better?

Instructions

Assignments See the student website for additional recommended learning activities that may help you learn this week's concepts.

Title Type Due Points

Week 3 Participation Instructions: Participate in class discussion.

Individual Aug 03, 2017 05:59 PM 3

Trade and Cash Discount Cases Instructions: Purpose of Assignment The purpose of this assignment is to provide students an opportunity to apply the concepts of trade and cash discounts covered in Ch. 8 to integrated case studies. Assignment Steps Resources: Trade and Cash Discount Cases Excel® Template Save the Trade and Cash Discount Cases Excel® Template to your computer. Read the instructions on the first tab. Complete the two Excel® cases located in the template. Click the Assignment Files tab to submit your assignment. Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Each Learning Team member receives a grade based upon his/her contributions to the team assignment. Not all students may receive the same grade for the team assignment.

SupportingMaterial:Trade and Cash Discount Cases Excel® TemplateTrade and Cash Discount Cases Grading Guide

Learning team

Aug 03, 2017 05:59 PM 6

Mathematics of Buying and Selling Exercises Instructions: Purpose of Assignment The purpose of the assignment is to provide students an opportunity to use Microsoft Excel® to practice the concepts of trade discounts, invoicing, markups, and markdowns. Assignment Steps Resources: Mathematics of Buying and Selling Exercises Excel® Template, Excel® 2016 Essential Training Save the Mathematics of Buying and Selling Exercises Excel® Template to your computer. Read the instructions on the first tab. Complete the ten exercises located in the template. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Excel® 2016 Essential TrainingMathematics of Buying and Selling Exercises Excel® TemplateMathematics of Buying and Selling Exercises Grading Guide

Individual Aug 03, 2017 05:59 PM 6

Create Excel stats data set part 1 assemble data for statistics use- An Excel spreadsheet Instructions: Collect data related to signature assesment. Observations should be 80-100 observations with 3-4 variables identified

SupportingMaterial:A Sample real Estate dataset

Learning team

Aug 03, 2017 05:59 PM 2

Week4 Aug, 04 - Aug, 10 Quantitative Techniques in Financial Valuation

4.1 Evaluate and analyze simple interest using the simple interest formula. 4.2 Find the maturity value of the simple interest loan. 4.3 Find the principal, rate, or time using the simple interest formula. 4.4 Evaluate ordinary and exact interest. 4.5 Promissory notes. 4.6 Compound Interest and difference between compound and simple interest. 4.7 Compounding frequency. 4.8 Understand, evaluate, and analyze effective and quoted interest rates. 4.9 Use Microsoft Excel® to evaluate future values, present values, rates, and time periods.

Objectives/Competencies

Required Learning Activities • Business Math, Ch. 11: Simple Interest and Simple Discount

Read Ch. 11 of Business Math. Consider the following as you read:

• Evaluate simple interest. • Be cautious about the units of rate and time in simple interest problems. They must match. • Difference between simple interest and simple discount.

Instructions

• Business Math, Ch. 13: Compound Interest, Future Value, and Present Value

Read Ch. 13 of Business Math. Consider the following as you read:

• How to use Excel® to evaluate future values, present values, rates, and time periods. • Use Excel® to convert quoted rate to effective rate.

Instructions

• Week 4 Most Challenging Concepts

Recall the readings and activities you have completed this week and describe the one or two points that were least clear to you. What questions do you have that would help you understand these points better?

Instructions

Assignments See the student website for additional recommended learning activities that may help you learn this week's concepts.

Title Type Due Points

Week 4 Participation Instructions: Participate in class discussion.

Individual Aug 10, 2017 05:59 PM 3

Data Analytics Problem Set Instructions: Purpose of Assignment The purpose of this assignment is to provide students opportunities to reinforce the fundamental topics in data analytics. Through this assignment, students will learn how to read information from bar charts, pie charts, line charts, and frequency distributions. Students will also use Microsoft Excel's pivot table functionality to create frequency distributions, bar charts, and pie charts. The assignment also includes evaluating basic descriptive statistics using Microsoft Excel®. Assignment Steps Resources: Data Analytics Problem Set Excel® Template, Excel® 2016 Essential Training Save the Data Analytics Problem Set Excel® Template to your computer. Read the instructions on the first tab. Complete the twelve exercises located in the template and record your answers in the highlighted spaces. Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Data Analytics Problem Set Excel® TemplateData Analytics Problem Set Grading GuideExcel® 2016 Essential Training

Individual Aug 10, 2017 05:59 PM 10

Week5 Aug, 11 - Aug, 17 Annuities and Financial Investments

5.1 Introduction to annuities. 5.2 Differentiate between ordinary annuities and annuities due. 5.3 Use Microsoft Excel® to evaluate and analyze future and present values of ordinary annuities and annuities due. 5.4 Use Microsoft Excel® to evaluate annuity payments and periods of annuity. 5.5 Understand stock, bond, and mutual fund listings. 5.6 Calculate and distribute stock dividends. 5.7 Calculate price of bonds and current bond yield. 5.8 Calculate ROI for mutual funds.

Objectives/Competencies

Required Learning Activities • Business Math, Ch. 14: Annuities and Sinking Funds

Read Ch. 14 of Business Math. Consider the following as you read:

• The difference between ordinary annuities and annuities due. • How to use Excel® to evaluate annuities.

Instructions

• Business Math, Ch. 15: Building Wealth through Investments

Read Ch. 15 of Business Math. Consider the following as you read:

• How to read stock and bond prices. • Evaluate stock dividends, bond prices, and ROI of mutual funds.

Instructions

• Week 5 Most Challenging Concepts

Recall the readings and activities you have completed this week and describe the one or two points that were least clear to you. What questions do you have that would help you understand these points better?

Instructions

Assignments See the student website for additional recommended learning activities that may help you learn this week's concepts.

Title Type Due Points

Week 5 Participation Instructions: Participate in class discussion.

Individual Aug 17, 2017 05:59 PM 3

Financial Valuation (Time-Value of Money) Cases Instructions: Purpose of Assignment The purpose of this assignment is to provide students an opportunity to apply the concepts of time value of money covered in Ch. 13 to integrated case studies. Assignment Steps Resources: Financial Valuation (Time-Value of Money) Cases Excel® Template Save the Financial Valuation (Time-Value of Money) Cases Excel® Template to your computer. Read the instructions on the first tab. Complete the three cases located in the template. Click the Assignment Files tab to submit your assignment. Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Each Learning Team member receives a grade based upon his/her contributions to the team assignment. Not all students may receive the same grade for the team assignment.

SupportingMaterial:Financial Valuation (Time-Value of Money) Cases Excel® TemplateFinancial Valuation (Time-Value of Money) Cases Grading Guide

Learning team

Aug 17, 2017 05:59 PM 5

Quantitative Techniques in Financial Valuation Problem Set Instructions: Purpose of Assignment The purpose of this assignment is to provide students an opportunity to practice and learn the time-value of money concepts covered during Week 4. Students will understand how to evaluate future values, present values, interest rates, and time periods for financial investments. Assignment Steps Resources: Quantitative Techniques in Financial Valuation Problem Set Excel® Template Save the Quantitative Techniques in Financial Valuation Problem Set Excel® Template to your computer. Read the instructions on the first tab. Complete the twelve exercises located in the template and record your answers in the highlighted spaces. Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Quantitative Techniques in Financial Valuation Problem Set Excel® TemplateQuantitative Techniques in Financial Valuation Problem Set Grading Guide

Individual Aug 17, 2017 05:59 PM 5

Optimization formulation Submit an individual optimization formulation Instructions: . Individual Analysis Optimization assignment Bonus points for exam possible You will undertake a business information systems optimization formulation. The goal here is to make you think through the steps that a manager must take to translate a business requirement into quantifiable statements for a staff. You may well find yourself assigned with a talented staff that could execute this problem formulation below and could translate into a spreadsheet formula at your direction. Business managers guide a staff to the solution, but must be familiar with the process to guide them! . The format for this is expected to be one page ( Math equations may be hand written if desired)

1. Problem description paragraph: Include a general description of the objective to be optimized. What are the cost coefficients? What are the variables that can be listed? 2. Format outline for remaining write up. Each item must be addressed. A. Declared variables in x or y terms with definitions. OR if you more comfortable you can use the declared variable "cells" in the spreadsheet. B. Variable index (subscript) use and range ( number expected) C. Given data to support- user defined D. Objective equation E. Constraint equations F. An estimate (guess ) at the solution in conclusion G An attachment of an Excel spreadsheet "set up" Note 1. this formulation may attempt solutions in Excel, However there are 5 bonus points for turning in a working solution. Usually a 3-4 variable problem is sufficient and enough of a challenge for a working model. Note 2: During Workshops 1-3 this modeling process will be learned. This is a good key to understand your company allocations in the future. To survive in profitably in business, the best profit margins available must be considered. The goal is to get you familiar with the concept, not experts in 5 weeks. Many of the " MBA" bosses get a deeper aspect of this subject. The realization here is to give you a " leg up" on your peers so you can suggest this. Note 3: Collaboration is allowed on the assignment to help understand the concepts. However once you decide what you are doing and do your write-ups, then individual effort is required. Good Luck! There are bonus points on exam for the best models. The first hour of WS-6 your team will select the best model from the group and that person will outline what they did.

SupportingMaterial:Optimization Research

Individual Aug 17, 2017 05:59 PM 4

Week6 Aug, 18 - Aug, 24 Financial Statements and Ratios for Decision-Making

6.1 Create, evaluate, and analyze the balance sheet. 6.2 Perform vertical and horizontal analysis of the balance sheet. 6.3 Create, evaluate, and analyze the income statement. 6.4 Perform vertical and horizontal analysis of the income statement.

Objectives/Competencies

Required Learning Activities • Business Math, Ch. 21: Financial Statements

Read Ch. 21 of Business Math. Consider the following as you read:

• Difference between balance sheet and income statement. • Horizontal and vertical analyses of each statement. • Use financial ratios to make investment decisions.

Instructions

• Week 6 Most Challenging Concepts

Recall the readings and activities you have completed this week and describe the one or two points that were least clear to you. What questions do you have that would help you understand these points better?

Instructions

Assignments See the student website for additional recommended learning activities that may help you learn this week's concepts.

Title Type Due Points

Week 6 Participation participation in class and online posting Instructions: Participate in class discussion. This also includes the significant posting per instructors policy examples , nd includes over weeks 2-6 discussion added to team and class activities

Individual Aug 24, 2017 05:59 PM 7

Signature Assignment Instructions: About Your Signature Assignment This signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The signature assignment may be graded with an automated rubric that allows the University to collect data that can be aggregated across a location or college/school and used for program improvements. Purpose of Assignment The purpose of this assignment is for students to synthesize the concepts learned throughout the course, provide students an opportunity to build critical thinking skills, develop businesses and organizations, and solve problems that require data. Assignment Steps Case 1: Scenario: Cloud Data Services (CDS), headquartered in Memphis, provides information technology services, specifically application hosting services in the cloud for several clients in the southern United States. CDS hosts software applications on their network servers. While CDS has achieved great success and customers rate CDS's services highly, lately, some customers have been complaining about downtime on one of the primary network servers. The given dataset, found in the Signature Assignment Excel® Template, contains the downtime data for the month of November. Use the data analytics skills learned in Week 3 and analyze the downtime data. Make a short presentation to CDS's management including the following:

1. Using used Microsoft® Excel® Pivot Tables, construct a frequency distribution showing the number of times during the month that the server was down for each downtime cause category. 2. Develop a bar chart that displays the data from the frequency distribution in part 1. 3. Develop a pie chart that breaks down the percentage of total downtime that is attributed to each downtime cause during the month. 4. Evaluate the mean, median, standard deviation, and variance of the downtime minutes for the month of November. Case 2: Note: Although you will be studying the concept of CPI in more detail in your ECO/561 class; for the purpose of this case, you need to use the concepts of percentages, percentage increase/decrease, and creating and interpreting line charts to compute the inflation rate in the US economy and determine which time period experienced the highest inflation rate. Follow the steps below to complete this signature assignment:

1. Search for the Federal Reserve Bank of St. Louis (FRED). 2. On the home page of the website, you will see a search box. 3. Type in CPI- AUCSL in the search box and press the return key. 4. The first result of the search will be "Consumer Price Index for All Urban Consumers: All Items." Click on this result link. 5. Click on the Download link and download the data in Excel®. 6. On the Excel® file, the second column gives you the CPI values for each period starting from 1947. 7. Go to the last row and notice the last date and the CPI value. Go back 6 years from this last date. For example, if the last date is 2016- 11-01, then the date 6 years ago would be 2010-11-01. 8. Copy and paste this six years data into a separate Excel® tab. 9. Using Excel®, calculate the percentage change in CPI from a year earlier for each observation, beginning with the observation one year later than the first observation. To make this calculation, click on the blank cell next to the observation corresponding to that date and then use Formula 1, located in the Signature Assignment Excel® Formulas document (note that in Excel®, the symbol for multiplication is *), where t-1 is the first observation and t is the observation one year later. For example, to find the percentage change in CPI from 2010-11-01 to 2010-10-01, refer to Formula 2 located in the Signature Assignment Excel® Formulas document. Convert this value to a percentage in Excel®. Repeat this process for the remaining observations (you can

Individual Aug 24, 2017 05:59 PM 10

use the copy and paste functions to avoid having to retype the formula). 10. This new column contains the national inflation rate. 11. Create a line graph of the percentage changes (inflation rates) from a year earlier. 12. Which period experienced the highest inflation rate? What was the inflation rate during that period? Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment.

SupportingMaterial:Signature Assignment Excel® FormulasSignature Assignment Excel® TemplateSignature Assignment Grading Guide

Final Exam Instructions: Click the link to the Final Examination available from the end of Week 5 through the end of Week 6. Complete the Final Examination. You are allowed one attempt to complete the examination, which is timed and must be completed in 3 hours. Results are automatically graded and sent to your instructor. Note: The automated final exam was designed in Google Chrome and is best viewed in the latest version of the browser. If you do not use the latest version of Google Chrome to view and complete the automated final exam, you may not be able to view the entire exam content. If you do not have the most current version of Google Chrome, download the browser before you enter the exam.

Individual Aug 24, 2017 05:59 PM 15

All trademarks are property of their respective owners. Trademark