Best practices for teaching case studies
Keep these principles in mind when assigning and teaching case studies to increase your chances of success.
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.
'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.
Make the last day of class meaningful
Ending a course on a bright note can leave your students with a positive impression of your class and reinforce key concepts they’ve learned.
Redesign your final exams to truly promote learning
Try these tips to put together a final exam that helps students retain more, improves their study habits, and encourages them to practice critical thinking.
Use Excel PivotTables to quickly analyze grades
Use Excel PivotTables to quickly analyze grades Want to quickly sort the data in your Excel gradebook by category, such as section number or teaching assistant’s name? PivotTables let you view this data with ease.
Use Excel’s AutoSum button to add up rows and columns with just one click
Want to quickly add up rows or columns of data in your gradebook (or elsewhere)? The AutoSum function makes it easy.
How to get started making videos for your classes
Video-savvy faculty present their best tips and techniques for shooting your own educational videos.
An online pivot can be an opportunity
A faculty member reconfigured her finance class in the wake of the COVID-19 crisis to teach soft skills.
Finding the fun in entry-level accounting
These creative approaches show students accounting is not that intimidating.
Sort by color to group highlighted cells in Excel
Highlighting cells with different colors can help you quickly identify information in a spreadsheet. Excel also lets you sort by color to easily group all the information you’ve highlighted with a given color. Learn how.
How (and why) to write for practitioner journals
By writing for these publications, you can introduce your research to a wide audience and have a large impact upon the accounting profession.
Mental health concerns on campus: What faculty can do
There are steps you can take even if you’re uncertain about the best response.
Use Excel’s Flash Fill to automatically fill in data quickly
How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.
Get started teaching blockchain
Experts offer best practices for helping students and faculty get up to speed.
Use IFS function to calculate letter grades in Excel
Added by Microsoft in 2016, the IFS function replaces the need for multiple nested IF statements. You can put all your conditions (percentage grade cutoffs in this example) in one function, making it easier to follow.
Improve your teaching evaluations
Here are some practical ways to improve your teaching evaluations, without lowering your standards or becoming an easier grader.
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.
