When you extract a large amount of data from a database, the first thing you may want to do is to clean the data and remove duplicates.
In this blog post, I will introduce you to two easy ways to remove duplicate values and get a list with unique records only in Excel. Continue reading
This guest post comes to us from Nicolette Tan, a junior in the College studying political science. She wrote this reflection essay during her participation in MGMT 353 Wharton Field Challenge in fall 2013. WIC staff assisted students in the seminar taught by Arjun Bhaskar and Samaira Sirajee with guidance from Professor Keith Weigelt in learning how to present Excel skills to small business owners in Philadelphia.
It’s one thing to know how to use Excel yourself; it’s another to be able to teach it. Today’s workshop definitely showed me that teaching is hard, and even more so when you’ve only met these people for the first time. The class got off on a high note, when Grace asked the class to “Raise your hand if you’re excited about learning Excel!” and people cheered and raised their hands enthusiastically. One thing that strikes me every time is the positivity that the students bring to the class, and how eager they are to improve themselves – regardless of age or background, and I have so much respect for that. Continue reading
George Hundt is getting his Masters of Environmental Studies. As an assignment for Yvette Bordeaux’s class on climate change, he had to create an infographic, and Dr. Bordeaux suggested using PowerPoint.
George wisely planned the entire graphic out on paper first (see his sketches below) and then came into the Vitale Digital Media Lab for assistance in translating his ideas into PowerPoint. (Having no prior PowerPoint experience, George had also watched the Lynda.com PowerPoint training videos that we make available to Penn students, faculty and staff.) He was here for several hours, but finished the entire thing in one day.
The final info graphic is included here, and you can see what high quality work can be achieved just with PowerPoint and a little elbow grease.
Thanks to George for letting me share his work in our blog!
The Vitale Digital Media Lab will be closed this Friday, August 15, while we do our semi-annual inventory and install new computers. We should have some exciting additions when we reopen on Saturday at noon!
If you need to borrow equipment that would be due on Friday, let us know and we’ll extend it to Saturday or Monday for you.
Throughout August, we’ll be holding Canvas office hours at the Education Commons for extra support in getting course sites up and running for the fall semester. Please see the Canvas at Penn blog post for more details and register on the EC’s workshop calendar.
The EC office hours are in addition to the many Canvas workshops and office hours being held at WIC throughout August. Please see the Canvas calendar to register for sessions happening at WIC.
When coming across Interlude’s well designed website, the first thing they’ll tell you is that we’re entering a new way of telling stories. I think they’re right, with more platforms on which to watch films, television shows, and everything in between, we’ve got to figure out better ways to tell the stories we want to tell. Continue reading
(From left: Pam Harris of Swarthmore College Libraries, and Illene Rubin and Mallika Sircar of Penn Libraries)
Back in June at PhillyDH@Penn, I presented a workshop called “Social Media Tech Tools,” which provided a show-and-tell of six different social media tools that we use here at WIC and some tips about using social media to engage our audiences. The workshop took place in Van Pelt Library’s new Collaborative Classroom, which encourages flipped classroom and active learning methods via the room setup and technology. The room is also conducive to socializing as folks are collaborating and moving around the room, making it an ideal space to discuss social media.