One hundred thirty-seven CPA candidates received the AICPA’s 2019 Elijah Watt Sells Award, which was established in 1923 to recognize outstanding performance on the CPA Exam.
Accounting education
5 activities for the in-person or virtual classroom
Try these fun and engaging ways of teaching accounting topics.
Prevent cheating while teaching remotely
Faculty can take these motives into account when attempting to deter cheating in their courses.
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.
Make the first day of your online class count
Your first remote class of the semester is your chance to let students know what to expect, start building connections with them, and help them get comfortable with the technology. Try these tips for getting a remote semester off to a great start.
Use conditional formatting in Excel to visualize letter grades
Highlight different letter grades with different colors so you can see at a glance how your students performed.
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.
CPA licensure model transformation will proceed after NASBA board vote
The transformation of the CPA licensure model will continue after the National Association of State Boards of Accountancy’s board of directors voted unanimously on efforts to design and implement a new approach to CPA licensure.
‘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.
Best practices for teaching case studies
Keep these principles in mind when assigning and teaching case studies to increase your chances of success.
Succeed at teaching no matter your temperament
You don’t have to be very outgoing to be an effective educator.
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.
Motivate students to do the assigned reading
Design lessons and class participation so students arrive prepared.
AICPA Council supports advancement of new CPA licensure model
The AICPA governing Council voted to support advancement of a new CPA licensure model that is designed to maintain the credential’s relevance long into the future.
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.
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’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.
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.
Features
SPONSORED REPORT
Smart Strategies in Data Security and Risk Management
In an increasingly digital profession, data security has become one of the most critical challenges facing finance and accounting professionals today. Stay up to date with practical guidance to help you mitigate these risks and strengthen your security posture.