A staple of many spreadsheet-based management science courses is the use of Excel for activities such as model building, sensitivity analysis, goal seeking, and Monte-Carlo simulation. What might those things look like if carried out using Python? We describe a teaching module in which Python is used to do typical Excel-based modeling and…

This research examines the application of students' computational thinking (CT) in solving numerical method problems through computer software. Data collection involved observing their learning process and conducting tests to evaluate their CT skills within the context of the root approach material using Newton-Raphson method. The results indicate…

In today's global economy, the origin of the food we eat is becoming more and more difficult to identify. Verifying the authenticity of products to protect supply chains is a complicated problem that requires a multidisciplinary approach. Chemical authentication of foodstuffs often includes a mass spectrometer detector; however, they are costly…

Spreadsheets help businesses run effectively and efficiently. However, many spreadsheets contain errors. Research provides taxonomies and guidance on preventing spreadsheet errors; this information often is not incorporated into training. Training students to use Excel functions and good spreadsheet practices is critical. This instructional…

As the use of data in courses that incorporate statistical methods has become more prevalent, so has the need for tools for working with such data, including those for data creation and adjustment. While numerous tools exist that support faculty who teach statistical methods, many are focused on data analysis or theoretical concepts, and there…

We present a complete, soup to nuts, modeling activity of a falling column of water. Many colleagues have used this material in teaching applications of first order separable differential equations. We describe how the material can be presented with students collecting their own data from online videos. One can then either offer the differential…

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,…

The statistical package chosen to aid in teaching quantitative methods is at the instructor's discretion, but little research has investigated student attitude toward these different packages. This study compared Google Sheets, a spreadsheet package similar to Microsoft Excel, and a traditional package, SPSS, to determine which of the two programs…

Relative quantification is a popular analysis in gene expression studies using quantitative real-time PCR (qPCR). However, the calculation steps using the major algorithms for this analysis are rather complicated. In this study, we developed an easy-to-use spreadsheet-based method for relative quantification. The inputs from end-users are the…

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…

The drive in computational methods and more intuitive software has seen a rise in the number of publications in this area in recent years. Computational simulations can be found in many areas of science from computational biology and chemistry to fundamental physics. These may help synthetic chemists in their drug discovery endeavors and…

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…