Teaching ultrasonics using spreadsheets

Philip Picton, Jerker Bjorkqvist (Editor), Mikko-Jussi Laakso (Editor), Janne Roslöf (Editor), Raija Tuohi (Editor), Seppo Virtanen (Editor)

Research output: Contribution to Book/Report typesChapter

Abstract

Whenever an ultrasonic wave encounters a boundary between two media it is partially reflected and refracted, as any acoustic wave would be. Unlike light, the wave also undergoes mode conversion so that in the general case a single incident wave could produce two reflected waves and two refracted waves. The angles which define the path of the wave are determined by Snell’s law and are easily calculated. The relative amplitudes, on the other hand, require quite complicated formula when the angle of incidence is anything other than 0 degrees. This problem gets compounded when the angle of the incident wave goes beyond the first critical angle. At this point the angle of the refracted wave becomes imaginary and the equations to calculate the relative amplitudes become complex. This paper describes a tool that has been developed, using a spreadsheet, which performs the calculations for all incident angles. The user selects the media and the type of incident wave and the resulting waves are shown graphically as well as numerically. The tool was developed primarily as part of an undergraduate course on ultrasonic testing, but could be used more widely.
Original languageEnglish
Title of host publicationInternational Conference on Engineering Education 2012 Proceedings
Place of PublicationTurku, Finland
PublisherTurku University of Applied Sciences
Pages954-959
Number of pages1108
ISBN (Print)9789522163196
Publication statusPublished - 1 Aug 2012

Fingerprint

spreadsheets
education
ultrasonics
refracted waves
Snells law
reflected waves
ultrasonic radiation
encounters
incidence
acoustics

Keywords

  • Ultrasonics
  • complex angles
  • spreadsheets

Cite this

Picton, P., Bjorkqvist, J. (Ed.), Laakso, M-J. (Ed.), Roslöf, J. (Ed.), Tuohi, R. (Ed.), & Virtanen, S. (Ed.) (2012). Teaching ultrasonics using spreadsheets. In International Conference on Engineering Education 2012 Proceedings (pp. 954-959). Turku, Finland: Turku University of Applied Sciences.
Picton, Philip ; Bjorkqvist, Jerker (Editor) ; Laakso, Mikko-Jussi (Editor) ; Roslöf, Janne (Editor) ; Tuohi, Raija (Editor) ; Virtanen, Seppo (Editor). / Teaching ultrasonics using spreadsheets. International Conference on Engineering Education 2012 Proceedings. Turku, Finland : Turku University of Applied Sciences, 2012. pp. 954-959
@inbook{c3e0b15883ff43e19fb95b3d584122e4,
title = "Teaching ultrasonics using spreadsheets",
abstract = "Whenever an ultrasonic wave encounters a boundary between two media it is partially reflected and refracted, as any acoustic wave would be. Unlike light, the wave also undergoes mode conversion so that in the general case a single incident wave could produce two reflected waves and two refracted waves. The angles which define the path of the wave are determined by Snell’s law and are easily calculated. The relative amplitudes, on the other hand, require quite complicated formula when the angle of incidence is anything other than 0 degrees. This problem gets compounded when the angle of the incident wave goes beyond the first critical angle. At this point the angle of the refracted wave becomes imaginary and the equations to calculate the relative amplitudes become complex. This paper describes a tool that has been developed, using a spreadsheet, which performs the calculations for all incident angles. The user selects the media and the type of incident wave and the resulting waves are shown graphically as well as numerically. The tool was developed primarily as part of an undergraduate course on ultrasonic testing, but could be used more widely.",
keywords = "Ultrasonics, complex angles, spreadsheets",
author = "Philip Picton and Jerker Bjorkqvist and Mikko-Jussi Laakso and Janne Rosl{\"o}f and Raija Tuohi and Seppo Virtanen",
year = "2012",
month = "8",
day = "1",
language = "English",
isbn = "9789522163196",
pages = "954--959",
booktitle = "International Conference on Engineering Education 2012 Proceedings",
publisher = "Turku University of Applied Sciences",

}

Picton, P, Bjorkqvist, J (ed.), Laakso, M-J (ed.), Roslöf, J (ed.), Tuohi, R (ed.) & Virtanen, S (ed.) 2012, Teaching ultrasonics using spreadsheets. in International Conference on Engineering Education 2012 Proceedings. Turku University of Applied Sciences, Turku, Finland, pp. 954-959.

Teaching ultrasonics using spreadsheets. / Picton, Philip; Bjorkqvist, Jerker (Editor); Laakso, Mikko-Jussi (Editor); Roslöf, Janne (Editor); Tuohi, Raija (Editor); Virtanen, Seppo (Editor).

International Conference on Engineering Education 2012 Proceedings. Turku, Finland : Turku University of Applied Sciences, 2012. p. 954-959.

Research output: Contribution to Book/Report typesChapter

TY - CHAP

T1 - Teaching ultrasonics using spreadsheets

AU - Picton, Philip

A2 - Bjorkqvist, Jerker

A2 - Laakso, Mikko-Jussi

A2 - Roslöf, Janne

A2 - Tuohi, Raija

A2 - Virtanen, Seppo

PY - 2012/8/1

Y1 - 2012/8/1

N2 - Whenever an ultrasonic wave encounters a boundary between two media it is partially reflected and refracted, as any acoustic wave would be. Unlike light, the wave also undergoes mode conversion so that in the general case a single incident wave could produce two reflected waves and two refracted waves. The angles which define the path of the wave are determined by Snell’s law and are easily calculated. The relative amplitudes, on the other hand, require quite complicated formula when the angle of incidence is anything other than 0 degrees. This problem gets compounded when the angle of the incident wave goes beyond the first critical angle. At this point the angle of the refracted wave becomes imaginary and the equations to calculate the relative amplitudes become complex. This paper describes a tool that has been developed, using a spreadsheet, which performs the calculations for all incident angles. The user selects the media and the type of incident wave and the resulting waves are shown graphically as well as numerically. The tool was developed primarily as part of an undergraduate course on ultrasonic testing, but could be used more widely.

AB - Whenever an ultrasonic wave encounters a boundary between two media it is partially reflected and refracted, as any acoustic wave would be. Unlike light, the wave also undergoes mode conversion so that in the general case a single incident wave could produce two reflected waves and two refracted waves. The angles which define the path of the wave are determined by Snell’s law and are easily calculated. The relative amplitudes, on the other hand, require quite complicated formula when the angle of incidence is anything other than 0 degrees. This problem gets compounded when the angle of the incident wave goes beyond the first critical angle. At this point the angle of the refracted wave becomes imaginary and the equations to calculate the relative amplitudes become complex. This paper describes a tool that has been developed, using a spreadsheet, which performs the calculations for all incident angles. The user selects the media and the type of incident wave and the resulting waves are shown graphically as well as numerically. The tool was developed primarily as part of an undergraduate course on ultrasonic testing, but could be used more widely.

KW - Ultrasonics

KW - complex angles

KW - spreadsheets

M3 - Chapter

SN - 9789522163196

SP - 954

EP - 959

BT - International Conference on Engineering Education 2012 Proceedings

PB - Turku University of Applied Sciences

CY - Turku, Finland

ER -

Picton P, Bjorkqvist J, (ed.), Laakso M-J, (ed.), Roslöf J, (ed.), Tuohi R, (ed.), Virtanen S, (ed.). Teaching ultrasonics using spreadsheets. In International Conference on Engineering Education 2012 Proceedings. Turku, Finland: Turku University of Applied Sciences. 2012. p. 954-959