2020 Year End Review

Many of us are ready for 2020 to end and to turn the page to 2021.  As our semester and 2020 come to a close, we feel that it is a great opportunity to reflect upon the fantastic technology tools and topics that we explored throughout the year.  A great resolution for 2021 is to integrate one new tool into your classroom environment.


Grammarly https://teachingandlearningtoolbox.wordpress.com/2020/02/

Remote Learning Tools for Successhttps://teachingandlearningtoolbox.wordpress.com/2020/03/


Go Soap Boxhttps://teachingandlearningtoolbox.wordpress.com/2020/05/

Improve Your Virtual Meetings & Classroom Presentationshttps://teachingandlearningtoolbox.wordpress.com/2020/06/

Accessibility Compliance Tools https://teachingandlearningtoolbox.wordpress.com/2020/07/31/

Futureproof Employees and Students with Data Analytics Training – https://teachingandlearningtoolbox.wordpress.com/2020/08/31/

Duet (Second Monitor Without a Cost)https://teachingandlearningtoolbox.wordpress.com/2020/09/30/


Krisp for Noise Free Meetings & Recordings https://teachingandlearningtoolbox.wordpress.com/2020/11/

We look forward to exploring more teaching and learning technology tools throughout 2021.

© 2020 Teaching and Learning Toolbox

Futureproof Employees and Students with Data Analytics Training.

“We always overestimate the change that will occur in the next two years and underestimate the change that will occur in the next ten.  Don’t let yourself be lulled into inaction.” ~Bill Gates~

Are you feeling a bit overwhelmed when you hear or read about disruptive technology changes coming to the field of Accounting?  If so, you are not alone.  We hear terms like AI (Artificial Intelligence), ML (Machine Learning), RPA (Robotic Process Automation), AR (Augmented Reality), VR (Virtual Reality), Mixed Reality, Blockchain, Big Data, Data Analytics, Data Visualization, 3-D Printing-Additive Manufacturing, and IoT (The Internet of Things). We are told that these disruptive technologies will impact the future of accounting, but do we really need to worry about this now?  The answer is yes!  Changes in technology is going to disrupt the future of the accounting workplace and the time to adapt is now.  The future is here!

Download to read the remainder of our article that was published in the July/August 2020 edition of the MOCPA Asset Magazine.

Integrating Data Analytics In Courses Across Your Curriculum To Raise The Learning Bar!

Today’s accountants find themselves performing more and more tasks that require data analytics skills.  Accounting fields such as audit, tax, financial and managerial accounting all use big data to find patterns that impact decision making and organizational strategy.  Data analytics can help accountants and management better understand their organizations from an external and internal perspective.  Data analytics helps answer what’s happened (descriptive analysis), why it happened (diagnostic) what the future may look like (predictive) and what direction should be taken next (prescriptive).  Accountants are accustomed to looking at problems that need recommendations or solutions.  Data Analytic skills enhance the accountant’s ability to quickly determine trends or irregularities in order to more rapidly identify potential problems and find solutions.

Markus and I feel it is important for students to develop data analytic competencies early in their educational coursework as well as reinforcing or “stepping up” these competencies throughout the curriculum.  So, the question we often hear is, “How do we get started incorporating data analytics into our courses and curriculum”?

Markus and I have created a “step-up” approach to data analytics that can help.  This approach has worked well with our students.  We have found that integrating data analytics into our courses has increased synergy, engagement, collaboration, attendance, as well as student interest in the potential of data analytics.  Additionally, this approach helps us prepare graduates with the required 21st-century skills.

Since Markus and I teach at different institutions and in different parts of the country, we believe our approach to incorporating data analytics is seamless and has a pedagogical purpose that can be replicated into many accounting courses, by any instructor. The first step in this model is to introduce students to Big Data concepts and problems looking for solutions.  Next students interpret already prepared data visualization reports from Power BI and/or Tableau. This gives students the opportunity to see the results of data analytics before they work with any raw data.  After students understand the big picture of data analytics, they begin working with data visualization modeling using Power BI  (https://powerbi.microsoft.com/en-us/downloads/) and/or Tableau (https://www.tableau.com/).  Finally, students are introduced to coding exercises. The Hour of Code (https://hourofcode.com/us, and Code Academy (https://www.codecademy.com/),  both offer free coding tutorials that expose students to the world of coding.  Introducing students to coding is not intended to replace information systems courses or create proficient coders. The goal of this activity is to expose students to the basic concepts of coding in order to increase student interest and a desire to learn more about coding on their own.  Ultimately, we have found that this approach improves critical thinking skills as it pushes students into higher levels of Bloom’s Taxonomy.

Technology and education are continuously evolving.  Integrating data analytics into accounting courses across the curriculum allow faculty and students to stay current with industry and educational trends.  In addition, data analytics integration allows us to address AAA/AICPA Pathways, AACSB Accreditation Standards and AICPA Technology and Tools Competencies.

To learn more about getting started with integrating Data Analytics into your courses, visit our February 2019 blog at https://teachingandlearningtoolbox.wordpress.com/2019/02/28/integrating-data-analytics-into-your-accounting-courses/.

©2019 Teaching and Learning Toolbox.com


Integrating Data Analytics Into Your Accounting Courses

Are you looking for an easy way to integrate data analytics into your accounting curriculum?  Programs like Tableau and Microsoft Power BI combined with free educator resources provided by the Big Four Accounting Firms can aid in this task.  The Big Four Accounting Firms have developed data sets, projects that utilize Tableau and Power BI and a variety of class assignments and cases.  Educators can start with exercises that have students analyze data visualization results.  This allows students to develop critical thinking skills when analyzing trends from the provided data.  After students master the interpretation of the data visualization sets, they gain a more wholistic approach to utilizing the data sets.  The resources provided by Microsoft Power BI, Tableau and the Big Four Accounting Firms allow first-time users with simple step by step resources.


Power BI - 3

Business intelligence encompasses the strategies and technologies used for data analysis of business information and Microsoft Power BI is a tool which allows non-technical users the ability to assemble, analyze and share data.  Many individuals who currently use Excel have discovered Power BI to be a natural fit.   The interfaces of Excel and Power BI are very similar and simple visuals are easy to create and import.  Power BI is a natural migration for analyzing data sets when they become too large for Excel’s capabilities.  In addition, many extra analysis tools are available in Power BI compared to Excel.  Power BI allows users to create relationships between data sources and create various visualizations.

Review the following links to learn how Power BI can fit your data analytic needs:

Power BI Introduction Video:  https://youtu.be/_OOyJfszJXY

Power BI Frequently Asked Questions:


Getting Started with Power BI:


PowerBI VideoTutorial Playlist:


The best part is that you can get started for free today with the Power BI single user version, which includes 1GB of storage.  Create your free account at:  https://powerbi.microsoft.com/en-us/


Tableau logo

You don’t have to be an expert to try Tableau.  To help you get started, Tableau provides free ready-made curriculum materials, including lecture notes, student handouts, and assignments.  Visit the Tableau Instructor Resource Page at https://community.tableau.com/community/teachers/overview

Benefits of Utilizing Tableau:

  • Free Instructor and Student Tableau Software
  • Free Start Up and Training Materials
  • Free Curriculum Materials
  • Free Learning Resources
  • Free Tutorial and On Demand Training Videos
  • Basic and Advanced Functionality for any Field of Study
  • Network Community for Tableau Academic Users
  • Allows for Cloud Based Document Sharing for Students and Instructors
  • Basic and Advanced Functionality for any Field of Study

Get started today with Tableau by completing the simple license request process at https://www.tableau.com/academic


Big Four Accounting Firm Resource Links

Deloitte  Deloitte – https://www2.deloitte.com/us/en/pages/about-deloitte/solutions/educator-resources.html#

EY  EY – https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=2ahUKEwiJ8duEg5ThAhWyZd8KHUFkBkIQFjAAegQICRAC&url=https%3A%2F%2Fwww.ey.com%2FPublication%2FvwLUAssets%2FEY_Academic_Resource_Center%2F%24FILE%2FEYARC-brochure.pdf&usg=AOvVaw1rfm6VonL418WH8-Tm0d9m

KPMG  KPMG – https://www.kpmguniversityconnection.com/search

PWC  PWC – https://www.pwc.com/us/en/careers/university-relations/data-and-analytics-case-studies.html


© 2019 Teaching and Learning Toolbox