EXCEL spreadsheet algorithms were developed at Villanova University to efficiently and consistently retrieve information from ASPEN® flowsheets and used for grading work in senior design. The challenge is to take a large volume of data that is in the stream and unit operations reports and quickly and consistently calculate a list of key grading…

Teachers' technological experiences are constrained by limitations in reflective decision-making and theoretical frameworks. Challenges with the technological pedagogical content knowledge framework (TPACK) are often associated with deficits in self-regulation. To effectively develop TPACK, it is recommended that educators focus on enhancing…

This pilot study within an online teacher-education course required pre-service teachers to develop self-videotaped microteaching lessons which were posted in a private YouTube. Analysis of the students' YouTube lessons, course postings, and peer interactions found that students learned the technology requirements quickly, were able to develop…

Spreadsheets can be a powerful tool when it comes to teaching physics. From data analysis and graphing to animated simulations, Excel[R] is a very versatile program for the educator and learner alike. This paper describes and supports another use for Excel through Reflective Formative Assessment Spreadsheets (RFAS). To illustrate the use of RFAS,…