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…

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…

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…

This paper presents the results of an exploratory case study that examined a veteran secondary teacher's knowledge for teaching non-routine mathematical problem-solving with digital technologies. Data was collected through the observation of a veteran mathematics teacher, in real time, solving a mathematical problem with the digital tools of his…

Data literacy has become a much sought after skill by organizations as the importance of data driven decision making continues to rise in importance. This study explores the teaching of Tableau as a supplement to Excel to enhance the data literacy skills of students. Twenty-eight students taking an introductory course in Business Analytics and…

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…

Technological Pedagogical Content Knowledge (TPACK) is defined as the teacher knowledge needed for effective technology integration. This study aimed to investigate preservice elementary mathematics teachers' TPACK development. TPACK survey was administered to 33 preservice teachers (PSTs), and six of them were selected via maximum variation…

Addressing societal issues in civil and environmental engineering increasingly requires skills in data science and programming. To date, there is not much known about the extent students are learning these skills in current civil and environmental engineering curricula. We conducted a survey of accredited civil and environmental engineering…