Spend less time on repetitive tasks with Excel macros
Make mundane tasks easier by harnessing the power of automation.
This monthly e-newsletter brings you a roundup of the top stories affecting accounting education, ideas for innovation in the classroom, and resources from the AICPA to support educators.
Look your best during online classes
Improve the way you appear on camera with a few simple tweaks.
Lessen your stress heading into 2021
Try these suggestions from faculty and other experts for reducing the strain and taking better care of yourself and your students.
Get the most out of a guest speaker visit
Preparation can make the difference between a great experience and a mediocre one.
9 tips for teaching data analytics
Four professors offer insight and advice on this challenging subject.
Use VLOOKUP to help manage your gradebook
VLOOKUP is a formula that allows you to “look up” certain data and retrieve it into another table, by row. This function can be especially useful when you have a well-structured table with information organized by rows (such as a gradebook)!
Bring the remote work trend into your accounting classroom
Use this trend as a springboard into discussing the impact of technology on accounting.
Use the Quick Access Toolbar to increase your efficiency in Excel
Try this tip and have your most-used functions right at your fingertips.
Level up your accounting class with these tech tools
These teaching tools liven up both in-person and virtual classes.
Variety is the spice of online learning
Variety is the spice of not only life but also teaching and learning. Here are some simple ways to add some S-P-I-C-E to a classroom to break the monotony of an online lecture or hybrid class.
5 activities for the in-person or virtual classroom
Try these fun and engaging ways of teaching accounting topics.
Calculating depreciation using the SLN function
When teaching depreciation in Introduction to Accounting, faculty always cover a variety of different depreciation methods, including straight-line depreciation. Next time you teach this topic, build your students’ Excel skills by showing them how to use the straight-line (SLN) function in Excel.
Prevent cheating while teaching remotely
Faculty can take these motives into account when attempting to deter cheating in their courses.
What faculty will change about their remote teaching this fall
Amid the challenges of suddenly pivoting to online teaching midway through the semester, many accounting professors learned new techniques and principles that will inform their teaching this fall.
Best practices for teaching case studies
Keep these principles in mind when assigning and teaching case studies to increase your chances of success.
'Engagement triggers' help students learn and remember
Try these easy ways to create relatable lessons in accounting.
Use Excel’s sparklines to quickly show trends in data
Simple to create, sparklines are tiny graphs that help you make sense of data at a glance.
Motivate students to do the assigned reading
Design lessons and class participation so students arrive prepared.
View and edit 2 worksheets in the same workbook side by side
How to view and edit two worksheets from the same Excel workbook side-by-side.
Succeed at teaching no matter your temperament
You don’t have to be very outgoing to be an effective educator.
Do you have an article or news story idea?
To submit a news piece or contribute to an article for the Extra Credit newsletter, please email academicnews@aicpa.org
If you are interested in submitting a proposal or manuscript to the Journal of Accountancy, please click here to review the author guidelines and submission instructions.
