• Home
  • Search
  • Spreadsheet Modeling and Wrangling with Python
  • Cite Icon1
  • https://doi.org/10.1287/ited.2023.0047Copy DOI Icon

Spreadsheet Modeling and Wrangling with Python

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

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 data-wrangling tasks. In addition, students are exposed to basic software engineering principles, including project folder structures, version control, object-oriented programming, and other more advanced Python skills, creating deployable packages and documentation. The module is supported with Jupyter notebooks, Python scripts, course web pages that include numerous screencasts, and a few GitHub repositories. All of the supporting materials are permissively licensed and freely accessible. Supplemental Material: The supplemental files are available at https://doi.org/10.1287/ited.2023.0047 .

Similar Papers
  • Research Article
  • Citations28

Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach

  • Sep 01, 2006
  • INFORMS Transactions on Education
  • Thomas A Grossman
  • Research Article
  • Citations2

A Teaching Supplement on Sensitivity Analysis for Linear Programming in Undergraduate Business Programs

  • Sep 01, 2015
  • INFORMS Transactions on Education
  • Jomon Aliyas Paul +1
  • Research Article

Effectiveness of flipped classroom model for teaching management subject to the under-graduate students.

  • Jun 11, 2025
  • International Journal on Science and Technology
  • B.Prathyusha -
  • Research Article
  • Citations100

Cyber Dimensions: On-Line Education in a Management Science Course—Effectiveness and Performance Factors

  • Sep 01, 2000
  • Journal of Education for Business
  • Scott A Dellana +2
  • Research Article
  • Citations6

The Revolution in Management Science Instruction: Implications for Teaching Public Affairs Students

  • Apr 01, 1999
  • Journal of Public Affairs Education
  • Jonathan P Caulkins
  • Preprint Article

Supplemental Material: Insights into Caribbean tectonics from a detrital zircon U-Pb provenance study of siliciclastic strata in western and central Cuba

  • Nov 21, 2023
  • Patricia Ascanio-Pellon +1
  • Conference Article
  • Citations12

Developing integrated Web and database applications using JAVA applets and JDBC drivers

  • Mar 01, 1998
  • Andrew Yang +2
  • Preprint Article
  • Citations9

Interfacing FORTAN Code with Python: an example for the Hydrus-1D model

  • Mar 23, 2020
  • Raoul Collenteur +2
  • PDF
  • Research Article
  • Citations5

Predicting the effect of variants on splicing using Convolutional Neural Networks.

  • Jul 06, 2020
  • PeerJ
  • Thanyathorn Thanapattheerakul +2
  • Supplementary Content
  • Citations14

User guide for Social Determinants of Health Survey data in the All of Us Research Program

  • Aug 27, 2024
  • Journal of the American Medical Informatics Association : JAMIA
  • Theresa A Koleck +8
  • Research Article

Empirical Modeling Approach to Course Material Delivery of the IGNOU's Management and Computer Science Course Material: A Case Study

  • Jan 01, 1998
  • Paradigm: A Management Research Journal
  • Pankaj Khare +1
  • Preprint Article

DePSI: An Open-Source Python Software Package for PS-InSAR Analysis

  • Mar 14, 2026
  • Ou Ku +9
  • Single Book
  • Citations1

Financial Data Science with Python: An Integrated Approach to Analysis, Modeling, and Machine Learning

  • May 16, 2025
  • Haojun Chen
  • Preprint Article

The use of the Unidata Science Gateway as a cyberinfrastructure resource to facilitate education and research during COVID-19

  • Mar 28, 2022
  • Mohan Ramamurthy +1
  • Research Article
  • Citations12

TEACHING AND LEARNING DATA-DRIVEN MACHINE LEARNING WITH EDUCATIONALLY DESIGNED JUPYTER NOTEBOOKS

  • Jul 04, 2022
  • STATISTICS EDUCATION RESEARCH JOURNAL
  • Yannik Fleischer +2
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.