### Abstract

Original language | English |
---|---|

Title of host publication | International Conference on Engineering Education 2012 Proceedings |

Place of Publication | Turku, Finland |

Publisher | Turku University of Applied Sciences |

Pages | 954-959 |

Number of pages | 1108 |

ISBN (Print) | 9789522163196 |

Publication status | Published - 1 Aug 2012 |

### Fingerprint

### Keywords

- Ultrasonics
- complex angles
- spreadsheets

### Cite this

*International Conference on Engineering Education 2012 Proceedings*(pp. 954-959). Turku, Finland: Turku University of Applied Sciences.

}

*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).

Research output: Contribution to Book/Report types › Chapter

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 -