Give Sheets A Chance

I am a huge fan of Microsoft Excel.  It’s my second favorite application, after Photoshop.  However, I’ve been attempting to move all of my work to Google Apps for Education and I felt like Google Sheets was just not as robust a program as Excel.  That being said, I’ve been working with Sheets exclusively for several…

Read More

Dear TLT: How do I Combine Text from Two Columns into One (in Excel)?

Dear TLT, I’m working with a rather complex data set, and I need to combine text from two separate columns into one.  Is that possible? Sincerely, Professor James Moriarty Mathematics Dear Professor Moriarty, While it is not “elementary,” as some might say, it is definitely possible!  To get started, click on the first (empty) cell in…

Read More

Reversing Excel: Teaching Common Excel Procedures

Yana Wieckowski, a visiting assistant professor of Biology, discusses her experiences on targeting specifically challenging lessons that benefit from a “reversed” approach in the classroom. One of my teaching goals for this past school year, which led me to apply for the 2012 FTI, was to incorporate reverse learning into the classroom.  I teach BIO 211 (Biodiversity, Ecology, and…

Read More