Dear TLT
Dear TLT, Productivity, Research

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 the new column (C2 in the example below).

Screenshot_12_17_15__2_40_PM

Click on Formulas > Insert > Text > CONCATENATE.

Screenshot_12_17_15__3_09_PM

Click on cell A2 then type [, space“,].  Click on cell B2 and press enter.

Screenshot_12_17_15__3_11_PM

Cell C2 should now include text from cells A2 and B2, but not R2D2 🙂

Screenshot_12_17_15__3_13_PM

Use the fill handle to copy the formula to the rest of the cells in the new column.

Screenshot_12_17_15__3_14_PM

Please contact your instructional technologist, if you have additional questions or concerns, and check out our upcoming training sessions at http://tlt.eventbrite.com.

Best regards,

TLT

 

Have a question for Dear TLT?  

Submit the following form to see it featured on our blog:http://goo.gl/n1N2tq.

Professor James Moriarty is from what literary series? The first faculty member to email tlt@cofc.edu, with the correct answer, will receive a TLT flash drive!

adobe icon
Productivity, TLT, Video

New Adobe Licenses Available

Great news!  IT just announced that they have secured two fabulous Adobe products for use by CofC faculty and staff.

For Free – Adobe Acrobat Pro

Adobe Acrobat Pro will allow faculty to view and create PDFs.  This is a critical piece of software if you are preparing for tenure and promotion.  You can also use it to:

  • combine multiple PDFs into one
  • make your PDFs accessible
  • annotate a PDF
  • shrink the file size  of a PDF
  • digitally sign a PDF
  • convert some PDFs to Microsoft Word format

This is a free license for faculty and staff for use on CofC owned computers.

How do you get it?

Easy!  Just contact the Helpdesk (helpdesk@cofc.edu or 953-3375) and indicate that you would like to have Adobe Acrobat Pro installed.  Make sure to indicate the type of computer you have as well as your computer’s name.  The Helpdesk folks can help you figure out this information.  Just give them a call.

Adobe Creative Cloud

While not free, IT has secured an amazing price on this comprehensive software bundle.  For CofC computers, your department can purchase a license of Creative Cloud for only $165/year.  Creative Cloud includes Photoshop, InDesign, Illustrator, and Premiere.  Be advised that this suite is not needed for basic video or photo editing.  There are easier, free versions of software that can help you meet basic needs (contact your instructional tech for help with the free versions.)  Also be advised that, currently, CofC does not offer training on these applications.

How do you get it?

  1. Contact IT Financial by phone at (843) 953-3989 or by email at ITFinancial@cofc.edu and indicate that you would like to purchase Adobe Creative Cloud.
  2. IT Financial will walk you through the steps to submit an IDT in the amount of $165.00 per year per copy. Please know that this will be automatically renewed at the end of the fiscal year. If you wish to cancel your subscription, you’ll need to inform IT Financial.
  3. Once the IDT has been received, IT Financial will arrange for a technician to contact you for installation. Please note that classroom installations will have first priority.
screenshot of my symbaloo page
Productivity

Organize Your Digital Life

There are a plethora of fantastic resources and applications online that many of us use everyday.  As for me, I use Google Drive, Asana, Remember the Milk, OAKS, My Charleston, the TLT blog and the TLT Tutorials blog, Pinterest, and Twitter, just to name a few.  I also like to keep a running list of applications that I’d like to research when I have time.  I’ve tried everything to try to make it easy for me to access these sites quickly but nothing works well.  I like Diigo but the interface is clunky.  I’ve used browser bookmarks but I don’t like those either.  Most of time I can’t find what I want because all the links look just the same.  Recently I’ve found SYMBALOO and I think I’ve found something that will finally allow me to create the one-stop-shop I’ve been looking for.

My Symbaloo page

Symbaloo allows you to create icons for each of your links then group them on a page.  You’ll notice above I have all of the sites I use constantly on the left (including links to specific Google Docs) and TLT’s social media on the right.  I can create a link to anything on the web.

With Symbaloo you can create groups, called Markers, and add a colored background to create a visual barrier for the group (above you can see the markers on the left, one is orange and one is black).  You can also add multiple tabs.  In the image you’ll see I have a tab for WORK links and one for RESEARCH links.  You can have as many tabs as you need.  Lastly, you can even create folders of links.  This is great for those links you don’t access as often but want to still have available to you.  Reorganizing the links is as easy as dragging and dropping them into a new space.

BEST PART…

Once you’ve created your Symbaloo page(s) you can easily make this your browser’s homepage.  So as soon as you open a web browser your Symbaloo page automatically comes up, giving you quick and easy access to the links and web-based files you use everyday!

 

 

Accessibility, Best Practices, Distance Ed, Pedagogy, Productivity, Teaching Advice, TLT

TLT’s Top Tips for Time Management

What are instructors spending time on?

Below are the five most mentioned teaching behaviors identified in the research and from the feedback of online instructors. The ranking begins with the teaching activity that involved the highest time commitment, and descends from there. This is not a scientific analysis, but I included the list to provide an overview of the most prevalent online teaching activities (Van de Vord & Pogue, 2012).

  • Interacting with students: moderating discussion forums, responding to student emails
  • Evaluating student work: assignments, papers, discussion forums
  • Recording grades
  • Modifying and making changes to course materials and/or course home page
  • Addressing technical issues/course administration (not including grading)

 

Tips for Time Management

  1. Handle it once.

Following the principles of the GTD (Getting Things Done) Methodology, manage items as soon as you can.  For online teaching, this means doing things in a regimented format.  When emails come in, if an answer or action can be done in less than 5 minutes…do it now.  If It needs deeper thinking and reflection, mark it in a follow up folder or category before closing it.  While reading discussion boards, keep a spreadsheet open so that you can grade as you go and make notes while reading to help keep your students straight. Grade as items arrive and space out due dates to cut down on last minute or end of term grading.  Create blocks of time during each day to work on a particular item.  For example, Mondays from 10-11 am I work on items strictly for the mentors.  Everyday from 830-930 am I answer emails from participants about course related issues.  Thursdays from 1-4 are spend grading specified assignments.  Making this set schedule for yourself will make sure that you are allowing ample time to focus.

 

2.   Respond to students efficiently.

If a student asks a great question via email, reply to them and ask them to post their question and the response to the class, but if more than one student has emailed about the same issue or set of instructions, then address the group as a whole with a news item, whole class email, or something else that will make sure that all students see the information.  For example, if there is a procedural problem (students not knowing how to do something in a class) create a short video or screencast to walk them through the process.

 

3.   Make Time Count.

If it’s something that a student won’t notice…don’t do it!  If it’s something the students can do for themselves or with each other…delegate or provide opportunity to do it.  For example, a Course Lounge or question forum will allow students the ability to answer each other.  You can back this up by adding an “ask 3 before me” type policy so that you know they’ve tried to find help on their own first.  To make this efficient, you need to mindfully not engage in what one professor called “Whack a Mole” facilitation, where as soon as a discussion post or a question comes up the professor logs in to answer it or replies immediately.  Make sure you give your students that time to help each other or they will become accustomed to that immediate feedback and you’ll spend all your time responding to email.

 

4. Get Organized:  Location, Location Location

Have your course follow a logical path so that not only you but your students also know exactly where to go and what to do.  The easier it is to find something, the less time you spend looking for it!  This is especially applicable to the syllabus.  The more text heavy and exhaustive your syllabus, the less likely your students will be able to find what they need in the process.  Try breaking your syllabus up into sections and bulleting information rather than using paragraph texts.  Have your students engage in a scavenger hunt or quiz to show that they understand the key pieces of the document before the class gets too far underway.  This will lead to less questions and less time emailing “it’s in the syllabus”.

5. Get Organized: Me, Myself, and I

Make sure that your workspace is organized and ready to go.  This includes your computer!  If you have a hard time finding files or folders on your machine, take some time to organize your files so that you can easily grab an item when it is needed.  Keep a list handy of places you can go to for help.  Obviously TLT is going to be number one (:)) but make sure that you add your librarian, CDS, CSL, and other campus resources and how to contact them.

 

6. Develop a routine and electronic minions

There are a lot of moving parts in an online classroom.  Some can be automated, some cannot.  First, make a list of all items that you need to do (that you know of) and due dates prior to the course starting. Identify any weekly activities and blocks of time you’ll need to answer emails, grade, respond to discussions, etc.  If an item can be automated (for example, a news item reminder about a test that you want to go out on a certain date) go ahead and create the wording and release conditions before the class starts.  In the immortal words of Ronco…set it and forget it!  For those items that can’t be automated, create calendar reminders or use a task management tool that contains reminders like Asana.

 

7. #Unplugged

In honor of the TLT Lifetime DE Mentor award recipient Lancie Affonso, we bring you this most important tip.  Unplug every now and again!  Take some time away from the screen and technology to engage in the world.  It is tempting to want to be logged in 24/7 when your students are in session, but taking some time to take care of yourself (and your eyes, back, and wrists) will benefit you in the long run as an instructor.

 

8.  Use the right tools for the job.

Technology can do so much to help with time and task management, as well as automating parts of your responses without losing that personal touch.  Talk to your instructional technologist about some of the options to help you with time, task, grading, and communication management for your online class.  Check out this article on how to go about choosing the right tool for your situation:  http://blogs.charleston.edu/tlt/2014/03/05/plan-attack-implementing-technology-instruction/

 

9.  To Thine Own Self Be True

“Each person has a daily cycle when he or she is most alert; schedule that time for online work. Determine the best time of day to check and respond to email. Flag and prioritize emails.  Realize that what is an overload for some instructors is not for others. Before accepting teaching assignments, look at the other assignments already accepted for that semester and consider whether the workload is too heavy. Factor in family obligations and planned vacations when considering personal work capacity.  When planning for the future record notes each week in a teaching journal identifying thoughts about revisions for the next semester. Some fixes like broken links can be done on the fly during the current run, but others, like the rewriting of a section, need to wait until the students are no longer present. At the end of the semester, reflect on the notes and adjust as needed.”

 

10.  Practice your online writing

Because writing is a major channel of communication in an online class, the importance of clear and concise writing of the course materials cannot be over-emphasized. If one student finds a sentence unclear, the instructor will need to spend valuable additional time responding to clarify. Five or ten minutes of additional time for polishing a message or task instructions before distributing or publishing may save hours in clarifying later.  Have someone who is not familiar with an assignment read the instructions and see if it makes sense or if they could do the assignment with the information you provided.  Keep a list of frequently asked questions and your responses.  You can then copy and paste your responses or keep a running list published in a Google Doc that would get updated in real time for your students and would be easy to search for keywords.

 

11.  Design with Accessibility in Mind

Too often faculty members will design an online course and then realise a semester later that they have a student with a disability in their courses that require accommodations (screen readers, subtitles, alternative formats, etc.)  While it may take more time as you build the course, designing your course to be as accessible as possible from the start will save you more time (and you will reach more students) than trying to scramble after you get an accommodation request letter.  Remember, it is easier to construct than to retrofit a class!

 

Collaboration, Productivity, TLT, Web 2.0

Easy Brainstorming and Voting with Tricider

There have been many times during my teaching career that I’ve wanted to gather my students’ input to make decisions.  Would they be amenable to a due date change on their upcoming paper?  What resolution would they like to research for their next in-class debate?  Would they like to meet in the library or the classroom to work on their group projects?

In some cases, a student may be hesitant to express their opinion in front of others (who wants to be the one person who opposes a due date extension?).  Other times, I simply want a quick and easy way to “take the pulse” of my class without counting raised hands or scraps of paper.

Tricider has provided a simple and free solution to all my brainstorming, crowdsourcing, and voting needs.

tricider_logo

 

 

 

 

A user initiates a poll or brainstorming session simply by proposing a question.  Then, participants can contribute their own ideas, up-vote other’s contributions, provide arguments for their votes, even upload images.  Tricider can be used to help make both large and small decisions, such as where to eat lunch!

Screen Shot 2015-02-06 at 3.46.33 PMClick Here to see Tricider in action!

Uses:

  • Collaborative brainstorming
  • Idea ranking
  • Making decisions

Benefits:

  • Free
  • Can be used without registering
  • Synchronous or asynchronous collaboration
  • Share a poll via email, Facebook, Twitter, LinkedIn, or embedding on a website
  • Set deadlines
  • Export to Excel

Application: http://tricider.com

Top Ten Tech Tools
Innovative Instruction, instructional technology, Productivity, TLT

TLT’s Top Ten Tech Tools

In TLT, we are continually conducting research, starting trials, and experimenting with a variety of technology applications to find the best and most useful tools for our faculty. It makes sense that faculty and staff often ask me about apps and other tools I use in my courses, training sessions, and typical day-to-day activities. During iPad training, instructional technologists are nearly always asked some variation of “What’s the most popular app?” or “What’s your favorite app?” After technology sessions or presentations, I usually get questions from faculty expressing curiosity as to whether there are other faculty members using the tool or technology.

Through the new ranking feature in Poll Everywhere, your instructional technologists ranked nearly 30 of the most popular tools. I asked my colleagues to rank these technologies based on frequency of personal use and overall impression of the tool, while also considering the usefulness of the tool for faculty at College of Charleston. Listed below are the top 10 tools ranked by your instructional technologists in TLT. Please contact us with any questions.

 

  1. Google Drive: We use this for everything – meeting minutes, tutorials, brainstorming, group work, etc. It’s great for real-time collaboration.
  2. Poll Everywhere: This is one of the most popular tech tools on campus. We love it so much, it’s how we came up with this list.
  3. SMORE: You might be familiar with this tool if you have paid close attention to the flyers in our emails. We use it because it’s very easy to put together a great looking flyer in just a few minutes, and it tracks our views. Faculty could use it to brighten up weekly announcement emails or for introductions at the beginning of the semester.
  4. Screencasting: We use Screencast-o-matic to make quick how to videos rather than writing out tedious step-by-step instructions in emails. This program allows you to record your voice and your screen for up to 15 minutes with a free account. I use this technology frequently in my online courses.
  5. Skitch: All I have to say is Mac users, get this now! Take a screenshot, crop it, add arrows or text, and then drag the file into an email or presentation. The best part is that you can set it up to sync between all your devices.
  6. Kahoot!: We’re addicted. We love this fast and interactive quizzing game. I use it as an alternative to Jeopardy for in class review sessions.
  7. Canva: This is the best free graphics tool we have tested that offers professional-quality design options. It’s a lot of fun to experiment in Canva.
  8. EdPuzzle: Make an existing YouTube video more instructional or relevant to your class by adding in audio comments and quiz questions. You can track student views too.
  9. Haiku Deck: Make beautiful presentations in a jiffy on your iPad or computer. The image finder is fantastic and the formats are striking.
  10. Twitter: Stay up-to-date with news and interact with students and colleagues.
instructional technology, Productivity

Top 10 EdTech Tools for 2015

Welcome back, faculty! Whether you’re new to the classroom or a veteran professor, the beginning of a new semester is a busy time for all of us in academia. Between planning and preparing courses, attending faculty meetings, and getting to know new students, you may feel that there is little time for seeking out or implementing new technology.

With your busy schedule in mind, the folks at Top Hat have put together a list of the Top 10 EdTech tools for 2015. These tools can be used in your courses to increase collaboration, improve organization, and encourage participation. Many of these tools are also relatively simple and can help set up your classes for success this semester.

To view the complete list on the Top Hat blog, click here.

As always, if you find a tool that you may be interested in using this semester, you can contact your Instructional Technologist for ideas or assistance.

 

screenshot of two peoples edits
Collaboration, Distance Ed, Google, Google Apps, instructional technology, Productivity, Share

Google Docs Now Has a “Track Changes” Feature

I love Google Docs for sharing and reviewing documents but I do miss the features of Microsoft Word’s track changes.  Well, Google Docs has recently added that feature.  Now when you open a Doc you will see a new item in the toolbar entitled Editing.  This gives you the choice of “Editing” as you normally would, “Suggesting” which turns on the track changes, and “Viewing” which views the original document or the accepted changes.   This long awaited feature elevates Google Docs into an even better collaborative tool than it was before. If you are interested in using this feature just open a Google Doc and, under the Editing menu choose Suggesting then make your changes.

 

As of the writing of this post it appears that this feature is only available in Docs and not in Spreadsheets or Presentations.

Dear TLT, Portfolio, Productivity, Research

Dear TLT: How do I Merge Multiple PDFs into One File for T&P?

Dear TLT,

I do not have Adobe Acrobat XI Pro, and I need to merge multiple PDFs into one file for my Tenure and Promotion (T&P) packet.  Are there any FREE solutions that will produce the same results?

Sincerely,

Professor C.F. Xavier

[hr]

Dear Professor Xavier,

Thank you for this very timely question!  There are FREE solutions available.  Since you did not mention if you are a Mac or Windows user, we will provide applications for both (see table below).

[table id=1 /]

Please contact your instructional technologist, if you have any questions or concerns, and do not forget to check out our upcoming training sessions at http://tlt.eventbrite.com.

Best regards,

TLT

CellyNewLogoTransparent2
1-1-1, Collaboration, Faculty Showcase, Faculty Technology Institute, Innovative Instruction, instructional technology, Mobile, Productivity

Faculty Guest Post: Paul Collins Talks about Students Helping Students with Celly

Our guest poster this week is Paul Collins, Assistant Professor in the Department of Theatre and Dance.  Paul attended the Spring 2013 FTI.

As part of the Scenery and Lighting Design and Production concentration in the Theatre major, students are required to take a course in which they learn Computer Aided Drafting and Design. The software on which the students learn is brand new to nearly all of them, and very complicated. We spend time in class going over the necessary skills and tools, but the students are then expected to complete exercises in the computer lab as homework. Because of the complexity of the software and the lack of experience that the students have with it, struggles are very real and frequent, and I spend a lot of time with individual students working through the process.

While I work closely with each of the students, I have also noticed in previous semesters that the students do a great job helping each other. Sometimes while I am working with an individual in class, another student has a question about something, but by the time I get to this student, a neighbor has helped to solve the problem. I encourage the students to work on their homework in the lab together so that they can take advantage of what I call ‘the collective wisdom of the class’.

During the Faculty Technology Institute (in Spring 2013), I was introduced to a tool that has allowed me to expand this ‘collective wisdom’ beyond the walls of the classroom. Celly (simply http://cel.ly/ in your web browser) is a kind of online discussion board, similar to other discussion boards that you may be familiar with (including the tool available in OAKS). However, the advantage that Celly has over traditional discussion boards is the ability for the user to receive and send messages in a number of different ways: via email, mobile app, online web portal or text. The text feature is what makes this tool truly powerful- by connecting the discussion to a cell phone, posts to the board are more immediately available both to the students and to me. A question can be put up on the Celly, and be responded to almost immediately by whoever gets to it first. Here is an example of one of the conversations (note… read the conversation from bottom to top)

 

 

In this situation, a student asked for clarification about a handout. Within a minute, another student joined the conversation to try to help, as well as giving advice on how to create the shape in question. I also was available to help at this time, and checked the handout so that I could answer the question. Within 8 minutes, I had the problem figured out, and posted a clarification to OAKS to clear things up for the whole class. This is only one example of what is a relatively easy question, but would likely have caused this student to either be unable to continue, or at the very least have to go back and make significant revisions. If the message had gone to a discussion board or email, the response time would not have been nearly as quick as the text message allowed.

There are a few things that I’d like to mention, though: First, this is a small class. With a larger group of active users, receiving the messages via text could quickly become overwhelming (especially if you do not have an unlimited texting plan). There is an online web portal which updates immediately, and you can receive the messages via email or mobile device, but this also brings you back to the response time issue that traditional discussion boards have. Each individual user (student and faculty alike) has the ability to set notification preferences to whatever combination of methods desired.

Celly also allows me to contact the class via text message without sending from my personal phone (and thus sharing my cell number with the whole class). I will send out a ‘how is the homework going?’ reminder message around Friday or so, as the homework is due on Monday. However, if this ‘reminder’ feature is the primary reason for using a service such as this, Remind101 is probably a more appropriate tool (as this service allows ‘outgoing’ text messages from teacher to student, but not vice versa).

Celly also has a ‘private messaging’ feature that allows users within the ‘cell’ to send messages to individuals rather than the group.

When this tool was initially introduced to me during the FTI, I did not think that it would be one that I would wind up using, but I’m glad that I gave it a shot this semester. I think that it is a powerful tool for those students who have chosen to participate, and I will continue to use it in the future.

And the best part: I get to be a robot.