Skip to main content

Posts

Showing posts from January, 2014

Tech Tip: Calculate Tutor Payroll

Today a customer came with a good question.  He was trying to calculate tutor payments from a student visit report.  However, if you export the report in Excel format, you will get the Period in HH:MM format:To calculate the total hours and the total payment amount, you will need to use the TIMEVALUE Excel formula.For example, the following will return the total hours worked:=TIMEVALUE([Cell])*24Then you can, round that number to have only 2 decimals:=ROUND(TIMEVALUE([Cell]) * 24, 2)For example, if the tutor has worked for 1 hour and 30 minutes (that would be displayed as 1:30), you will get 1.50 hours using the formula above.Or you can multiply the total hours worked (not rounded) by the hourly pay rate and then round the final amount.  If it were $20, then the final formula would be:=ROUND(TIMEVALUE([Cell]) * 24 * 20, 2)Being [Cell] the reference to the cell where the period is (eg, 01:30), and 20 is the hourly pay rate.

Make those courses available in your center!

As a support tech, you receive several times the same question.  This is about one of those things that many user usually forget: courses are not available by default to all centers.  When you create a new center, you need to assign the subject areas that can be taught in there. The same happens when you create a new subject area.To solve the problem, you need to import a file with 3 columns: Center Name, Subject Area Code Prefix and Subject Area Name.
For example:Center NameSubject Area Code PrefixSubject Area CodeMath CenterMAT101Math CenterALG201Writing CenterHIS101………And so on. In this case, MAT-101 and ALG-201 would be assigned to the Math Center and HIS-101 would be assigned to the Writing Center. If you want to assign all subject areas to all centers, you might want to use the export feature to get the list of subject areas.

Accudemia Receives Readers’ Choice Top Product Award

We are glad to announce that Accudemia has received the Readers’ Choice Top Product Award.Accudemia has been selected as the University Business 2013 Readers’ Choice Top Product. AccuTrack and AccuSQL, two of Engineerica’s other products, received an honorable mention.  Other award winners for 2013 include products by Apple, Amazon, Adobe, and Cisco. The award is based on nominations from campus leaders from across the US. Winners are selected based on both the quantity of nominations and the quality of testimonials describing how these products are used to astreamline operations and enhance student’s experience. UB included this sample nomination for Accudemia: “Accudemia has helped streamline our tutoring services. We are more efficient as a result of using this product and have had great success with their tech support. Accudemia also allows us to track data and statistics on our usage in a very user friendly way and without any delay.”       — Zoraya Betancourt, Assistant Director…

Happy New Semester: Copying tutor assignments

Most of you will need to copy semester information to start the new year.

Here's a quick guide on how to copy Tutor Assignments from one semester to another:

There are 2 ways to do that:

1) To copy only a couple of tutors:
   - Go to User Accounts -> Tutors
   - Select the user you want (or click on "MultiSelect" to select more than one tutor)
   - Click on Assignments
   - Click on "Copy assignments from another term"
   - Select source and destination terms and click Accept.

2) To copy several tutors at once:
   - Go to Advanced -> Export
   - Click on "Tutor Assignments" to export all the tutor assignments.
   - Delete the columns "Tutor Name" and "Subject Area Code"
   - Sort the data by "Semester" and remove the records from old semesters (only keep the data from the semester you want to copy from)
   - Change the semester column to the new semester. For example, rename all Fall 2013 with Winter 2014.
   - Re-import that data…