TeamMate Analytics has been designed from the ground up to be a tool for every auditor on an audit team, regardless of their IT skill level. With no coding required to run TeamMate Analytics, auditors can spend more time doing what they were hired to do - audit. A built-in test library and guided UI for creating custom tests allow auditors to quickly run the test that they want to. Unlike many analytic tools available, TeamMate Analytics was design specifically for auditors and uses familiar audit-friendly terminology.

Most importantly, TeamMate Analytics is based in Microsoft Excel. As the world's most common analytics tool, Excel is used by almost every student and professional which makes learning TeamMate Analytics second-nature. TeamMate Analytics is a fully fledged, incredibly powerful Data Analytics package with all the audit analytics capabilities found in expensive difficult to use software packages.

Computer operating system and TeamMate Analytics

TeamMate Analytics only runs with MS Excel on PC-based operating systems. If your students have Mac computers, you have two options: 1) your students can run Windows emulation software on their Mac, or 2) you will need to have TeamMate Analytics installed in a PC computer lab that your students can use. TeamMate Analytics will run only on supported versions of Microsoft Excel – currently Excel 2010 and newer. TeamMate Analytics supports both 32- and 64-bit versions of MS Windows and MS Office.

Accessing TeamMate+ software

Our preferred approach to making TeamMate Analytics available to your students is to have it installed on your school’s computers. We can then provide a site license for the software, simplifying the management of license keys, etc.

If necessary, and if your students have PC computers, they can download a Trial version of TeamMate Analytics software from this location: click here. We will then need to work with you to provide software license details for your students.

To participate in the TeamMate Analytics in the Classroom program, please reach out to Ken Petersen at 440-796-3241, and provide the following information: 1) Instructor name, institution phone number, and institution email address, 2) Name of educational institution, and 3) the name of your course, when the course session starts, and the number of students likely to be in the session. We will then get back to you to discuss your options for making the software available to you and your students.

TeamMate+ and the textbook

We have prepared both Instructor and Student materials for the following list of exercises, chapters and cases in the textbook.

  • Exercise 1: - Chapter 11, “Data Analytics and Audit Sampling,” Case 1.
  • Exercise 2: – Chapter 11, “Data Analytics and Audit Sampling,” Case 2.

The exercises request that the student review a video. However, the URL for the video provided in the textbook is incorrect. The correct URL is https://youtu.be/RU1p7FhjNDo. The correct URL has also been provided in the Instructor and Student materials below. In addition, the exercises provided on this site have been updated and we encourage you to use them.

TeamMate Analytics Instructor Materials

Please email theThe Internal Audit Foundation at [email protected] to request access to the TeamMate Analytics Supplemental Materials, which, with the exception of the accompanying videos, will include the following documents:

  • F9-TeamMate Analytics Case 11-1-Instructor-Final
    • Supports Exercise 1: Chapter 11, “Data Analytics and Audit Sampling,” Case 1.
    • Includes a link to the video for the exercise
    • Includes the text of the Exercise, plus answers to the questions.
    • Important – the materials included in the textbook for this exercise are incorrect. Please have the students use the materials available on the accompanying Student webpage. The Instructor version of these materials are provided below.
     
  • F9.1-TeamMate Analytics Case 11-2-Instructor-Final2
    • Supports Exercise 2: Chapter 11, “Data Analytics and Audit Sampling,” Case 2.
    • Includes a link to the video for the exercise
    • Includes the text of the Exercise, plus answers to the questions.
    • Important – the materials included in the textbook for this exercise are incorrect. Please have the students use the materials available on the accompanying Student webpage. The Instructor version of these materials are provided below.
     

TeamMate Analytics student materials

Here is a link to the TeamMate Analytics student materials, which include cases, exercises, a video, and a dataset for use in Case 2. We have taken the dataset identified in the textbook and reduced its size somewhat to make it more manageable. The link to this dataset is included in the student materials.

Support for TeamMate Analytics

Support for TeamMate Analytics can be obtained by sending an email to Chris Ryley or Caroline Singletary with the following information: a description of what feature/function (e.g., Column Statistics, Quick Visualizer) of TeamMate Analytics the issue occurred in, details on the actions performed including the desired outcome, and details on the resulting outcome or error experienced. If the issue is critical, please phone Chris Ryley (1.800.461.5308 x6820) or Caroline Singletary (561-598-9665).