Posted in Contact Angle, Critical Solution Temperature, D L Williams, DSC, Education, Forensics, FTIR, Hansen Solubility Parameters, LIF, Physical Chemistry, Raman, RER, Science Education, Solubility, Solvent Blending, Spectroscopy, Thermal Analysis, UV-VIS-NIR, XPS

PCHEM and Forensic Chem Lecture Videos

I frequently have seniors who want to revisit the concepts in pchem sit in my 8AM lectures the year after they have had my course. It’s a privilege to have them and an encouragement to see their natural curiosity in action. They seek to firm up their understanding of the quantum world and how we interact with it (i.e. spectroscopy).

In the fall of 2017, I put these students to work videoing the lectures and posting them on the Physical Chemistry at Sam Channel. These videos are essentially raw footage of lecture. The videos could have been greatly improved by adding in the PowerPoint Slides, captioning, cleaning up the audio, and cutting out my “ums” and “uhs”. But these volunteers did not have time to do that, nor did I. I had a CLEANING WORKSHOP to plan and execute!

CHEM 4448 – Physical Chemistry 1
– Quantum Mechanics and Spectroscopy

CHEM4448-Playlist-Snip

CHEM 4449 – Physical Chemistry 2 -Thermodynamics

4449Lecture-Playlist-Snip

CHEM 4380 – Forensic Chemistry

The students appreciated the fall lecture videos so much, there was a great amount of interest in capturing the Forensic Chemistry Lectures. So we created a Forensic Chemistry at Sam Channel, too.

CHEM4380-Playlist-Snip

The lecture playlist is only one piece. Jessy also created other playlists of videos on the Forensic Chemistry at Sam Channel that should interest Forensic Science and Forensic Chemistry students and enthusiasts. She performed these tasks as an SHSU Honors Contract for the course – an activity that supplements the material for the student and enhances the skills that they take away from the course.

Thanks to the Student Team!

Even raw footage must be stitched together, uploaded, described, tagged, and set up on YouTube. This takes TIME and time is a valuable commodity for our chemistry majors.

I thank William Fernandez for videoing CHEM 4448 and CHEM 4449. His videos were so well-received by the students that Jerome Butler decided to sit in and video my Forensic Chemistry course CHEM 4380. Thanks Jerome!

I thank Matthew Peavy for producing the videos for CHEM 4448 and CHEM 4449, and for uploading them. I thank Jessy Stone for producing and uploading the CHEM 4380 videos for Forensic Chemistry.

You students who are willing to go beyond the minimum give us hope for the future.

You people in industry and in graduate programs, hire these students! You won’t be sorry!

-DW

Advertisements
Posted in Spectroscopy

Excel Roller Coaster – Yes, my hobby is Excel

If you have FUN programming Excel, on a SATURDAY…You MIGHT be a Redneck I mean, you might be a PCHEMIST.

DLWilliamsExcelRollerCoaster1

Years ago, I was at home on a Saturday fiddling with a wave function problem in Excel. The plot on the screen was of a couple of cosines, and my 8-year-old son said, “Hey that looks like a roller coaster”.

“It sure does.” I said. “Do you want to make a roller coaster in Excel?”

“Yes!”, he said.

So over the next four hours we had some quality father son time making a roller coaster in Excel. He learned something about cosine functions, and how to put custom backgrounds on a chart. Some of the finer details he did not care much for were anchoring cells, negative error bars, or the mod() function. But he really appreciated the custom look of a white wooden roller coaster and the looping macro that made the coaster run along the track.

You can download the macro-enabled (.xlsm) workbook file from my curiosities page to see how these functions and settings were used. Here is a time-lapse video of my creating the page from scratch. There are some fun tricks so I hope you enjoy it. the background loop is a bit annoying. Sorry.

The coaster uses an infinite loop. To kill it just click Ctrl+Break, and it will stop.

What Excel awesomeness to you have to share? What questions do you have about these functions and settings in this fun application?

Ask in the comments field, and subscribe for more fun in the future (like my Sudoku solving spreadsheet).