Teaching Business Statistics with Microsoft Excel

Bell, Peter C.

doi:10.1287/ited.1.1.18

Cited by 25 publications

(28 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Still, the notable difference between the two groups suggests that flowcharts may prove a useful tool in the introductory statistics teacher's arsenal. Previous research has also shown that students' analytical reasoning skills can be enhanced by the inclusion of more projects and cases that present statistical analysis as a process of inquiry with practical applications (see, e.g., Bell 2001, Cochran 2010 The results of this study also indicate that teaching practices appear to play an important role in student achievement in introductory statistics. A preliminary review of instructors in Cluster A determined that they conduct well-organized classes, have high expectations of their students, give frequent and informative feedback, and generally have considerable teaching experience as well as in-depth knowledge of the subject area.…”

Section: Addressing Problems With Inferentialsupporting

confidence: 56%

Identifying Addressable Impediments to Student Learning in an Introductory Statistics Course

Stevens

Palocsay

2012

INFORMS Transactions on Education

View full text Add to dashboard Cite

palocssw@jmu.edu} U sing performance data on a common test instrument administered to more than 4,000 business statistics students studying under 16 different instructors over a period of 6.5 years, we identify areas of consistent student weakness. In addition to verifying difficulties found by earlier researchers, we document a fundamental problem in students' ability to reason with cumulative probabilities, a problem with implications for solving problems with both discrete and continuous distributions. Our performance data also suggest that it may be useful to view statistics problems using a taxonomy based more on solution procedure than on traditional statistics topics. We employ a new methodology based on cluster analysis to identify areas where the observed student difficulties may be particularly addressable. Finally, we offer some preliminary findings on how these problems may be addressed with practical teaching suggestions based on the approaches employed by our more successful instructors.

show abstract

Section: Addressing Problems With Inferentialsupporting

confidence: 56%

Identifying Addressable Impediments to Student Learning in an Introductory Statistics Course

Stevens

Palocsay

2012

INFORMS Transactions on Education

View full text Add to dashboard Cite

show abstract

“…The study presented some ideas for using spreadsheets that may be appropriate in teaching statistics in the business school. The study concluded that the use of Excel together with realistic business examples and exercises can contribute greatly to students understanding of both business and statistics [10].…”

Section: Literature Reviewmentioning

confidence: 99%

Spreadsheets: A Tool for e-Learning — A Case of Matrices in Microsoft Excel

Chaamwe¹,

Shumba²

2016

IJIET

View full text Add to dashboard Cite

Abstract-Spreadsheets made their first appearance for personal computers in 1979 in the form of VisiCalc, an application designed to help with accounting tasks. Over the years the application area for spreadsheets has multiplied. One application that is becoming more pronounced is in the teaching and learning of pupils and students. A Spreadsheet can be used as a powerful learning tool for both primary and secondary school pupils. Spreadsheets offer concrete ways to explore abstract concepts in mathematics and other subjects.Mathematical ideas are conveyed in several different ways using pictures, colored squares, and number lines. A spreadsheet can be a helpful tool for visual learning. Using spreadsheets also promotes higher order thinking skills.Spreadsheets contain a variety of formulas, which can be used in teaching mathematics. These formulas can be generalized, so that students can see how the outcome is changed when one of the variables in the formula is altered. The spreadsheet tool also promotes the development of problem solving skills and supports "What if..." type questions. Apart from using ready-made formulas pupils can make up their own formulas to manipulate numbers. This paper proposes the use of Ms Excel in the teaching and learning of Algebra in secondary schools. The paper gives a specific example on how a topic such as matrices can be delivered using Ms excel.

show abstract

“…He includes communication of results using PowerPoint in all assignments, with the final integrative assignment including "communication of the model assumptions, structure, and usefulness to management." Bell (2000) suggests that "students' ability to effectively communicate ideas can be supported by including student presentations" in a business school statistics course, and that instructors develop business students' "ability to communicate technical material to a general audience." Carraway and Clyman (2000) frame the importance nicely: "Recommendations that cannot be sold are seldom implemented.…”

Section: The Importance Of Communicating Analytical Workmentioning

confidence: 99%

Managerial Communication of Analytical Work

Grossman

Norback

Hardin

et al. 2008

INFORMS Transactions on Education

View full text Add to dashboard Cite

W hen business and management science students graduate and have a job, they give many managerial communications about analytical work, but typically they are not taught how to give presentations in their undergraduate courses. We describe the characteristics of the "managerial presentation" and contrast them with characteristics of the "narrative presentation" that is given to technical peers and focuses on process. We then use the business analysis lifecycle to describe and contrast the real world and the model world. Implications for instruction build upon empirical data gathered at Georgia Tech for the presentation skills identified through interviews with engineers, managers, and senior executives in the workforce. We conclude by reviewing processes already used effectively for teaching the relevant presentation skills at Georgia Tech.

show abstract

Teaching Business Statistics with Microsoft Excel

Cited by 25 publications

References 1 publication

Identifying Addressable Impediments to Student Learning in an Introductory Statistics Course

Identifying Addressable Impediments to Student Learning in an Introductory Statistics Course

Spreadsheets: A Tool for e-Learning — A Case of Matrices in Microsoft Excel

Managerial Communication of Analytical Work

Contact Info

Product

Resources

About