This is the sixth and final step in the REDCap training series. In this training we won't use REDCap at all. Instead, we will cover ways to view and manage your exported REDCap data in Microsoft Excel and Sublime Text such as:

Populating data from one Excel sheet to another with vlookup()

Seeing specific data with column sorting and filtering

Ensuring data is cohesive by creating tables

Looking at how data relates to other data by creating pivot tables

Transforming unusable data to a usable format...

"Crystal Engineering for the Design of Functional Metal-Organic Materials"

LIB 3083

The general audience will be invited to leave after the presentation and Q & A session.

Title: Quantifying Early-Season Miscanthus × giganteus Spatiotemporal Patterns Using High-Resolution UAS LIDAR

Abstract: Perennial bioenergy crops are increasingly important for sustainable biomass production, with Miscanthus x giganteus (M×g) standing out for its high yield potential. Unlike annual row crops, perennials regrow each year from belowground rhizomes and spread unevenly across a field...

7/17: 10:00AM - 1PM, 231 TH (Trowbridge Hall)

Title: Ordovician trilobite communities: End-Ordovician mass extinction beta diversity collapse, habitat occupancy dynamics, and insights from the Eleanor River Formation (Floian) fauna of Canada

Abstract: Trilobites (extinct marine arthropods) reached peak diversity during the Ordovician, when the group was divided into the Ibex and Whiterock evolutionary faunas. During the Early to early-Middle Ordovician, species of these faunas occupied habitats...

"Structure and Dynamics of Irradiation Induced Species in MgCl2-KCl Molten Salts"

231 TH

The general audience will be invited to leave after the presentation and Q & A session.

Title: Stable Isotope and K-Bentonite Geochemistry of the Ireviken Biogeochemical Event from Gotland, Sweden

Abstract: The Silurian Period (approximately 444 to 419 million years ago) contains at least seven major biogeochemical events in Earth history that consist of an extinction event and perturbation to the global carbon cycle. The most extensively studied of these events known as the Ireviken...

"Understanding the Structure, Dynamics, and Transport Properties of Ionic Liquids: A Molecular Dynamics Simulations Approach"

Join Prairie Lights bookstore for a special faculty reading of the inaugural "Authors at Large" Iowa City Rogue Workshops! (You can learn more about this program and the faculty here.)

Xu Xi will read from her new collection of short stories, Horizon Hong Kong.

Kelly Dwyer will read from her recent novel, Ghost Mother.

Robin Hemley will read from his latest essay collection, How to Change History.

Mary Allen and Hugh Ferrer will read from works in progress.

Note: To accommodate these writers and...