Mathematical Modeling of Electrical Circuits and Practical Works of Increasing Difficulty with Classical Spreadsheet Software

Abstract

This paper presents a modeling practical works project of electrical engineering, proposed to the first-year students of the University Institute of Technology in France, during the COVID-19 pandemic. The objective of this paper is twofold. The first objective is to present to the students the opportunities of modeling and calculation development of a spreadsheet software in their professional lives. The second objective is to create a file that automatically calculates all the current and voltage values at each point of any alternative electrical circuit. The aim of this paper, geared toward students, is to bring them to build their own numerical remote lab, autonomously. Therefore, pedagogical keys are given along the reading of this document to help them to progress, both on electrical circuits conceptual understanding with series and parallel RLC circuits and on their computation in a spreadsheet software. As a conclusion, this paper can be used as a base to develop remote modeling practical works of many and different devices, as well as a database starting point of such analytical models.

Keywords

• mathematical modeling
• analytical models
• remote teaching
• spreadsheet computation
• electrical circuits
• student autonomous work