Skip to main content

Easily deactivate students not in the roll (and keep current Students Active)

This is definitely a great week for Accudemia, it’s the 3rd update we've published!

This time the update was to make data administrators’ lives easier.  Whether for software security or licensing purposes administrators have to deactivate students that are not longer in the current enrollment data for the semester.  If you have a list of active students, now you can check this checkbox option in the Accudemia Data eXchange (or ADX - our import tool) that will inactivate any student that is not in that import CSV file.  This option states “Inactivate students not being imported” and is disabled by default so that you'll have to enable it to use this feature.

Import options

As an example:
  • In the first import CSV file for the semester you have four students (A, B, C and D) and you upload it to Accudemia all those students will be active.
  • And the next CSV file you’re uploading only has A, C and D which will keep them active.
  • The end result using this option will have B become inactive in Accudemia.
Please note that the students you are uploading will not get activated automatically however unless you specify it in the CSV file.  To make the students you upload active you still need to add an “Active” column in your CSV file with the value “Yes”, "True" or “1” on each record.  Here you have an example of how to do so:

StudentID,Active
123123,Yes
849848,Yes
266484,Yes
...

Comments

Popular posts from this blog

Accudemia 7.0 Released

We are happy to announce that, as we have previously announced, we have released Accudemia 7.0 to all our customers. Here are the resources you can use to get started: User Manual: https://www.attendance-tracking.com/docs/doku.php/accudemia Knowledge Base: https://desk.zoho.com/portal/engineerica/kb/engineerica/accudemia-faq Videos: https://www.youtube.com/playlist?list=PLYq4Bcd5ZvTJ38RwysgP3X6lpSbNm5uHf Upcoming webinars: https://www.engineerica.com/accudemia/webinars/#sign-up Or watch the recorded webinar:

Did you know? You can create groups from filtered reports

On reports: when you create and filter a report it "automatically" creates a User Group. After creating a report that you need, where you have filtered all of the students with " MATH "(Subject Areas), selected only the " Freshman "(Student Demographic) who have visited the center for " Tutoring "(Service Type) more than 3 times on a Visitor History report you decide you want to save that group and call them " Freshman needing Math Help ." You can do this after you run that report by visiting the User Accounts > Groups section on the left-side navigation panel. Once there simply click on the Report Generated Groups tab, then click on the report you just ran, and click edit .  At this point you can name the group and hit save changes and the group will now be available for you to use as a group filter in future reports.

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])*24 Then 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.