Want to learn how to write on your iPad to make lecture recordings? Join Tracie Miller-Nobles, Jennifer Cainas, and me on Thursday this week at 3 pm Eastern for a webinar where we cover how to use your iPad as a tool for online teaching.
Register at https://zoom.us/webinar/register/WN_UIHlUE09R3OP-BUZcXEzpQ
Hope to see you there!
Has your school converted all courses to online? Still scrambling to figure out what this means for your course? Jennifer Cainas (University of South Florida), Tracie Miller-Noble (Austin Community College) and me (Kent State University) will be hosting two 30-minute webinars this coming week. One will address the options for online office hours and the other will cover ideas for building online student engagement.
Details and registration links for each of the webinars are below.
Title: Options for online office hours
Date/time: Monday, March 16, 4 – 4:40 pm (Eastern)
Title: Ideas for online student engagement
We hope to see you online Monday and Tuesday!
Have a great day – and keep calm, it will all be okay.
Wendy, Jennifer, and Tracie
Has your university or college suddenly converted all in-person classes to be online? Wondering how you can give exams online and maintain some sort of integrity?
We (Wendy Tietz and Jennifer Cainas) are hosting a webinar on Friday, March 13, 2020, from 3:30 – 4:30 pm Eastern. Register at this link.
In this webinar, we will share some strategies for giving exams and quizzes online in this new environment we find ourselves in. We will also be asking participants to share their own strategies.
If time permits, we will discuss other strategies to engage students in an online environment.
In this case, students use a variety of pivot tables in Excel to summarize, sort, and aggregate more than 4,800 job cost records. All work is performed in Excel. This case is suitable for assignment after job costing been covered in managerial accounting. You can view this case at this link (this is the same link that you will use to assign to your students.)
To assign the case to your students, give them this link. All student instructions are included at that link – as are links for tutorial videos for Excel skills needed and accounting concept skills needed.
***You can obtain the teaching notes and solution for the Ivy Corporation Job Cost Analysis Excel case by requesting it at this link.***
You will need to fill out a brief form and then we will verify your instructor status prior to sending you the instructor materials. We generally send the Instructor Guide within a week after the request; we will contact you if we need additional information to verify your instructor status.
Be sure to add drwendytietz@gmail.com to your contacts. Check your spam folder if you have not received the materials from us within a week.
In this case, students use data found in a company’s financial statements in an Excel file to various ratios, including the current ratio, debt ratio, and gross margin percentage. All work is performed in Excel. This case is suitable for assignment after the basic ratios have been covered. You can view this case at this link (this is the same link that you will use to assign to your students.)
To assign the case to your students, give them this link. All student instructions are included at that link – as are links for tutorial videos for Excel skills needed and accounting concept skills needed.
Tip: To make sure your students have put in the correct formulas as you are grading, change a few numbers in the data in students’ completed worksheets and then check to make sure that the revised ratios are correct.
***You can obtain the teaching notes and solution for the Jubilee Company Financial Statement Analysis Excel case by requesting it at this link.***
You will need to fill out a brief form and then we will verify your instructor status prior to sending you the instructor materials. We generally send the Instructor Guide within a week after the request; we will contact you if we need additional information to verify your instructor status.
Be sure to add drwendytietz@gmail.com to your contacts. Check your spam folder if you have not received the materials from us within a week.
This blog post contains a data analytics project that is suitable for introductory managerial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned in the course once the concepts of contribution margin, contribution margin ratio, and segment margins reviewed.
This project uses sales and cost data for a fictitious cabinet hardware company, Cabinet Accessories Company (CAC.) In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, and create calculated columns. The student also needs to cleanse the data set by finding and correcting errors in the data set. In addition, the student will create a pivot chart.
The tutorial video has closed captioning; the annotated slides for the tutorial video have the same script. The tutorial data set is an Excel file containing a small subset of the full data set; I used this small data set in creating the tutorial video.
Anyone doing this project will need to have either Office 365 or Excel 2016. Updates Microsoft has made to Excel 2016 include the ability to automatically group dates by quarters and years (an integral part of this project), so if a student says that their pivot table does not have quarters or years (or any other issue), tell them to update their version of Office 365 and/or Excel 2016.
If you would like to have a copy of the Excel solution file, please fill out the request form. Once I verify your status as an instructor, I will email the file to you, usually within a week. Please do not post the solution file on the internet and please do not share the solutions file with your students. The Excel solutions file is for your own use only.
This project covers budgeting and performance evaluation in introductory managerial accounting and uses Excel.
This project uses the transaction data from the City of Somerville, Massachusetts, which posts its checkbook online for public use. In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, and create calculated columns. In addition, the student will create a pivot chart. The student will also prepare a budget variance report, using the information from a pivot table, and will analyze the variances.
The tutorial video has closed captioning; the annotated slides for the tutorial video have the same script. The tutorial data set is an Excel file containing a small subset of the full data set; I used this small data set in creating the tutorial video.
Anyone doing this project will need to have either Office 365 or Excel 2016. Updates Microsoft has made to Excel 2016 include the ability to automatically group dates by quarters and years (an integral part of this project), so if a student says that their pivot table does not have quarters or years (or any other issue), tell them to update their version of Office 365 and/or Excel 2016.
If you would like to have a copy of the Excel solution file, please fill out the request form. (There is a separate request form for each project.) Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions file with your students. The Excel solutions file is for your own use only.
This blog post contains a data analytics project that is suitable for introductory financial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned early in the course once the concept of gross profit is reviewed.
This project uses sales and cost data for a fictitious cabinet hardware company, Cabinet Accessories Company (CAC.) In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, and create calculated columns. The student also needs to cleanse the data set by finding and correcting errors in the data set. In addition, the student will create a pivot chart.
The tutorial video has closed captioning; the annotated slides for the tutorial video have the same script. The tutorial data set is an Excel file containing a small subset of the full data set; I used this small data set in creating the tutorial video.
Anyone doing this project will need to have either Office 365 or Excel 2016. Updates Microsoft has made to Excel 2016 include the ability to automatically group dates by quarters and years (an integral part of this project), so if a student says that their pivot table does not have quarters or years (or any other issue), tell them to update their version of Office 365 and/or Excel 2016.
If you would like to have a copy of the Excel solution file, please fill out the request form. Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions file with your students. The Excel solutions file is for your own use only.
This project uses fixed asset information from anonymized and modified data for a tax client from a public accounting firm. The data set includes 1,500 fixed asset records. In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, create calculated fields, use the slicer and timeline tool. In addition, students will be asked to analyze the data for errors. The students will prepare several different fixed asset schedules and also a pivot chart (column type) that depicts book value by asset category and region.
Anyone doing this project will need to have either Office 365 or Excel 2016. It is important that students update their version of Office 365 and/or Excel 2016.
If you would like to have a copy of the Excel solution file, please fill out the request form. (There is a separate request form for each project.) Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions files with your students. The Excel solutions file is for you own use only.
This project uses the transaction data from the City of Somerville, Massachusetts, which posts its checkbook online for public use. In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, and create calculated columns. In addition, the student will create a pivot chart. Essentially, the student is analyzing the transaction data from Somerville to answer several questions using pivot tables and charts in Excel.
The tutorial video has closed captioning; the annotated slides for the tutorial video have the same script. The tutorial data set is an Excel file containing a small subset of the full data set; I used this small data set in creating the tutorial video.
Anyone doing this project will need to have either Office 365 or Excel 2016. Updates Microsoft has made to Excel 2016 include the ability to automatically group dates by quarters and years (an integral part of this project), so if a student says that their pivot table does not have quarters or years (or any other issue), tell them to update their version of Office 365 and/or Excel 2016.
If you would like to have a copy of the Excel solution file, please fill out the request form. Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions file with your students. The Excel solutions file is for your own use only.
Accounting is Analytics 