The SchoolCounselor.com e-Newsletter is an
electronic publication designed to advance counselors' level of technological
literacy, application, and integration. You will find practical solutions and
answers to technology related problems, especially as they apply to your job as
counselor. If you would like to share a tip or trick, or if you would like to
ask a question, e-mail Russ Sabella at firstname.lastname@example.org
Thursday, May 16, 2013
The Time Elapsed Analysis & Reporting System (T.E.A.R.S.)
The Time Elapsed Analysis & Reporting System (T.E.A.R.S.) is a Microsoft Excel add-in that automatically calculates the total amount of time that you have spent in different aspects of your work. After exporting your calendar data from Microsoft Outlook to Excel, this add-in extracts elapsed time, sums up the number of hours in each category, and then produces both a table and a chart. If you ever wondered where your time goes, you will want to use T.E.A.R.S. to learn more.
For those who use Microsoft Office (Outlook and Excel), you don't have to learn any other software.
You can access your Outlook Calendar on your iPad, other tablet, or mobile device using Outlook Web Access (OWA) and keep track of your appointments or tasks in real time. Then, when you get back to your office, you can easily access the updated information to generate your time and task analysis results with your desktop or laptop.
You can easily compare time/task time data across people in an organization.
Using TASK is pretty simple and includes only three steps:
Make sure your Microsoft Outlook calendar appointments/tasks are each assigned a category;
Export your Outlook calendar data to Excel; and
Click on the TEARS add-in to automatically generate your chart and table.
NOTE: TEARS extracts the amount of time that you spend in different categories of your work using Microsoft Outlook and Excel. If you are a school counselor and need more sophisticated software such as for student record keeping as well as tracking time, I recommend either EZAnalyze Time Tracker orHallways.