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…

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…

The recent works of oscillators are mainly focused on underdamped oscillation. Therefore, the writer proposes an experimental apparatus to demonstrate all types of damped harmonic oscillation. The apparatus utilizes an Arduino for data acquisition and an Excel spreadsheet for data analysis. By using this apparatus, the type of damped harmonic…

As educational systems move from onsite to online due to the COVID-19 pandemic, teachers face the difficulty of designing online examination formats which minimize opportunities for dishonesty. In this paper, we expose our design of such a format: a protected Microsoft Excel spreadsheet containing short-answer questions, which was implemented in a…

It's not surprising that rainbows have received a great deal of attention: in textbooks, in magazines, and on the web. They are, after all, beautiful, fascinating, occasionally awe-inspiring, even a little mysterious. They are an almost perfect blend of natural beauty and simple physics. Has everything that can be said about rainbows already been…

A spreadsheet plotting assignment of real-life data from a racecar is employed to help students master the relationships among speed, acceleration, and distance. The racecar application will capture the imagination and interest of the student. The data is obtained by reading speedometer values from a YouTube video for 40 s as a racecar accelerates…

The benefits of using Microsoft Excel built-in functions in an undergraduate Multistage Separations course are analyzed based on 15 years of experience teaching mass transfer in Chemical Engineering programs at both the Bachelor's and Master's levels. Eight reasons for using spreadsheets in a Mass Transfer virtual course are given. Through the…

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…

In this teaching case, we describe an experiential learning project that allows students to perform sentiment analysis on a set of tweets (posts made on the social media platform, Twitter) by collecting and analyzing posts that include key words selected by the students. Sentiment analysis refers to the process of identifying and categorizing…

Biological systems exhibit strong dynamic variations; for example, a system may have a tendency towards either a steady state, periodic behaviour or chaotic oscillations. These findings, explained by dynamic systems theory, have allowed researchers to formally relate a wide variety of systems, such as the theory of rumour propagation, glucose…

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…

At state and local levels, home visiting programs may use one of several mechanisms to collect and store data from families and clients who participate in home visiting services. States that are interested in integrating home visiting data with other early childhood data must often navigate the different ways in which home visiting data are stored…

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…

Extant research has demonstrated that problem-posing and problem-solving mutually affect one another. However, the exact nature and extent of this relationship requires a detailed elaboration. This is especially true when adidactical problem-posing arises within a problem-solving context. In this study, we analyze the scripting journey used by two…

Segmentation reduces learners' cognitive load by inserting system-controlled pauses into instructional animations and video. However, many previous studies focus on conceptual knowledge, and do not allow users control over the pacing of instruction. This two-part experiment attempted to validate segmentation in the context of procedural software…