Difficulties arise in the teaching of control concepts applicable to thermal systems in buildings because these systems are large and respond slowly. Also, traditional control system analysis does not easily accommodate the examination of real scenarios. In this paper, spreadsheet-based techniques are described that allow students to simulate thermal responses using real and hypothetical data. Controller tuning can be simulated and alternative designs can be simultaneously examined and compared. The spreadsheet models are routinely used by distance-learning students, but have proved useful also in teaching full-time students on campus.
FiskD. J., Thermal Control of Buildings (Applied Science, London, 1981).
2.
LevinI., ‘Behavioral simulation of an arithmetic unit using the spreadsheet’, Int. J. Electrical Enging. Educ., 31(4) (1994), 334–341.
3.
EliahuM. and RonenM., ‘A spreadsheet macro as a teaching and learning aid for solving electrical networks’, Int. J. Electrical Enging. Educ., 32(2) (1995), 133–140.
4.
YamaniA. and KharabA., ‘Use of a spreadsheet program in electromagnetics’, IEEE Transactions on Education, 44(3) (2001), 292–297.
5.
HeyenG. and KalitventzeffB., ‘Spreadsheet based teaching aids in chemical engineering education’, Computers and Chemical Engineering, supplement23 (1999), S629–S632.
6.
RussellM. B. and SurendranP. N., ‘On the use of IT to study and teach transient conduction using finite difference techniques’, CIBSE National Conference, London, 18 October 2001.
7.
MokheimerE. M. A. and AntarM. A., ‘On the used of spreadsheets in heat conduction analysis’, Int. J. Mech. Enging. Educ., 28(2) (2000), 113–139.
8.
AntarM. A. and MokheimerE. M. A., ‘Spreadsheet modelling of transient three dimensional heat conduction with various standard boundary conditions’, Int. J. Mech. Enging. Educ., 30(1) (2002), 17–34.
9.
FraserC. J. and ThorpeJ. R., ‘Spreadsheet applications for modelling and analysis in mechanical engineering’, Int. J. Mech. Enging. Educ., 24(2) (1996), 124–136.
10.
ThiriezH., ‘Improved OR education through the use of spreadsheet models’, European Journal of Operational Research, 135(3) (2001), 461–476.
11.
GreasleyA., ‘An example of a discrete-event simulation on a spreadsheet’, Simulation, 70(3) (1998), 148–166.
12.
UreyG., ‘A critical look at the use of computing technologies in planning education — The case of the spreadsheet in introductory methods’, Journal of Planning Education and Research, 21(4) (2002), 406–418.
13.
PenmanJ. M., ‘Second order system identification in the thermal response of a working school’, Building and Environment, 25(2) (1990), 105–110.
14.
HanbyV. I. and DilA. J., ‘Error prediction in Markov models of building/HVAC systems’, Applied Mathematical Modelling, 20 (1996), 608–613.
15.
UnderwoodC. P., HVAC Control Systems (E & F. N. Spon, London, 1999).
16.
ZieglerJ. G. and NicholsN. B., ‘Optimum settings for automatic controllers’, Transactions of the American Society of Mechanical Engineers, 64 (1942), 759–768.
17.
LjungL. and GladT., Modeling of Dynamic Systems (Prentice Hall, New Jersey, 1994).
18.
ChenT. Y. and AthienitisA. K., ‘Investigation of practical issues in building thermal parameter estimation’, Building and Environment, 38 (2003), 1027–1038.
