This article presents statistical power analysis (SPA) based on the normal distribution using Excel, adopting textbook and SPA approaches. The objective is to present the latter in a comparative way within a framework that is familiar to textbook level readers, as a first step to understand SPA with other distributions. The analysis focuses on the…

This paper describes the process taken to develop a quantitative-based and Excel™-driven course that combines "BOTH" Management Information Systems (MIS) and Decision Science (DS) modeling outcomes and lays the foundation for upper level quantitative courses such as operations management, finance and strategic management. In addition,…

A simple, conceptual method is described for using the spreadsheet scroll bar to find the composition of a system at chemical equilibrium. Simulation of any kind of chemical equilibrium can be carried out using this method, and the effects of different disturbances can be predicted. This simulation, which can be used in general chemistry…

A printed module should consist of media elements, namely text and pictures, which are self-instructional and could cater to the needs of the user. However, the typical platform of such visualization frequently overloads the limited working memory causing split attention and redundancy effects. The purpose of this study is to design and develop a…

Software may be used in university teaching both to enhance student learning of discipline-content knowledge and skills, and to equip students with capabilities that will be useful in their future careers. Although research has indicated that software may be used as an effective way of engaging students and enhancing learning in certain scenarios,…

Students regularly are asked to solve Single Factor Analysis of Variance problems given only the sample summary statistics (number of observations per category, category means, and corresponding category standard deviations). Most undergraduate students today use Excel for data analysis of this type. However, Excel, like all other statistical…

A lot of people risk money with bets on sport events or other events. Bookkeepers that offer such bets earn a lot of money. We are making a proposal (more exactly: a concept for a part of a basic mathematics course) for learning mathematics behind the screen (internet bets are very popular). Learners should organize a "sports event"…

Physics education researchers have scientifically established the fact that the understanding of new concepts and interpretation of incoming information are strongly influenced by the preexisting knowledge and beliefs of students, called epistemological beliefs. This can lead to a gap between what students actually learn and what the teacher…

Many high school and introductory college physics courses make use of mousetrap car projects and competitions as a way of providing an engaging hands-on learning experience incorporating Newton's laws, conversion of potential to kinetic energy, dissipative forces, and rotational mechanics. Presented here is a simple analytical and finite element…

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource…

The objective of this article is to graphically illustrate to the students the physical phenomenon of motion of charged particle under the action of simultaneous electric and magnetic fields by simulating particle motion on a computer. Differential equations of motions are solved analytically and path of particle in three-dimensional space are…

Teacher knowledge in the area of educational technology has been a prevalent research focus over the past decade, with researchers examining the ways in which technologies may be applied in the classroom. Recently, there has been a shift in studies, and researchers have begun to look at the ways in which a teacher may integrate technology into…

Growing enrollment in distance education has increased student-to-lecturer ratios and, therefore, increased the workload of the lecturer. This growing enrollment has resulted in mounting efforts to develop automatic grading systems in an effort to reduce this workload. While research in the design and development of automatic grading systems has a…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

In this sequence 1/1, 7/5, 41/29, 239/169 and so on, Thomas notes that the sequence converges to square root of 2. By observation, the sequence of numbers in the numerator of the above sequence, have a pattern of generation which is the same as that in the denominator. That is, the next term is found by multiplying the previous term by six and…