Solution equilibria diagrams are excellent tools for understanding chemical speciation in multireaction chemical systems. They are usually plotted using software packages that efficiently perform advanced calculations, giving the possibility to graphically visualize thermodynamic and composition information. However, this approach frequently…

Background/purpose: This study addresses the lack of statistical thinking skills among Applied College students, a key requirement for professional success. Traditional statistics education focuses on procedural and computational methods rather than conceptual understanding, leading to misconceptions and difficulties in data organization,…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

Microsoft Excel and Access are widely used in introductory courses designed to teach the fundamentals of spreadsheet and relational database modeling skills in various disciplines. To achieve the targeted learning outcomes, instructors of these courses strive to provide students with guided, frequent, and incrementally fruitful practice with the…

In the modern, information driven society managing and handling data is unavoidable. The most common form of data handling is to organize data into tables and complete operations on them in spreadsheets. Sprego (Spreadsheet Lego) is a programming-oriented methodology focusing on schemata construction and authentic problem-solving working with only…

This study aimed to examine the effect of using Excel in teaching fractions in a 6th grade mathematics course on students' academic achievement and attitudes. To achieve this, a quasi-experimental design with a pretest-posttest control group was implemented. The research involved 62 students from a public secondary school in a central province of…

The article uses dynamic visualizations in Excel to examine a variety of ways in which students can attain a much greater depth of understanding of optimization problems in introductory calculus. The topics discussed include a variety of common optimization problems that appear in virtually every calculus textbook that can all be enhanced…

In this paper the authors present a unique approach to teaching introductory statistics at both the undergraduate and graduate levels. The approach uses a feature in Excel called "spinners" to dynamically adjust key variables, such as sample size, confidence levels, and probabilities, among others, to enable an expanded discussion of…

The authors' objective was to uncover the difference in competency when teaching Excel to undergraduate students on two distinct and discrete operating platforms. The authors calibrated competency by comparing scores of MOS-EXCEL Certification Test results. The authors conclude that the null hypothesis indicating no difference in mean scores of…

It has become increasingly important for future business professionals to understand statistical computing methods as data science has gained widespread use in contemporary organizational decision processes in recent years. Used by scores of academics and practitioners in a variety of fields, Monte Carlo simulation is one of the most broadly…

Since motivation is known to be a critical factor, approaches, methods, techniques, and materials that would affect motivation positively are utilized in learning and teaching processes. Gamification is used by including game components into teaching processes to enhance students' motivation, attract their attention to the lesson and boost…

Data-handling, processing, and analysis skills are an integral part of a chemist's skill set and, more generally, are highly sought by employers. We report a self-directed workshop to develop and advance these key skills using the popular spreadsheet program Microsoft Excel. Making use of its accessible user interface, various contextualized…

The ways teachers converse about their work in relation to information and communications technologies (ICTs) are worth studying. We analyse how a teacher converses about her local practices in relation to two spreadsheet algebra programs (SAPs) on variables. During the conversations we noticed that the teacher keeps different policy documents --…

This paper presents the usage of an Excel spreadsheet for studying charged particle dynamics in the presence of uniform electric and magnetic fields. The equation of motion of the charged particle is developed under different conditions and the data is obtained in an Excel spreadsheet under variation of parameters such as the velocity of charged…

A bachelor's degree program in chemistry typically starts with basic concepts in mathematics, physics, and chemistry. Those principles are very important because they pave the ground for future advanced studies and, therefore, one needs to present them in a clear but rigorous way. One example is provided by the mathematical notion of an iterative…