PulseExploreJournal ClubDebatesTrendingResearchersJournals
Instagram
HomeExploreJournal ClubTrending
Synapse
⌘+K
Synapse
March 15, 2024INFORMS Transactions on Education1 citationsOpen Access

Spreadsheet Modeling and Wrangling with Python

View Full Paper
MIMark W. Isken

Key Points

Key points are not available for this paper at this time.

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 .

Ask AI
Helpful
Bookmark
Share
View Full Paper

Cite This Study

Mark W. Isken (2024) studied this question.

synapsesocial.com/papers/68e73dc9b6db6435876b6fbehttps://doi.org/10.1287/ited.2023.0047
Ask AI
Helpful
Bookmark
Share
View Full Paper