How to use Poll Everywhere in Your Online Class

This week we (Wendy TietzJennifer Cainas, and myself) are hosting “how-to” webinars to take a deeper dive into specific tools for online teaching. Our first webinar will be on using Poll Everywhere in your online class.

Tuesday, March 24, 5-5:30pm EST

How to use Poll Everywhere in Your Online Class

Interested in creating student engagement in your online courses? Join us for a “how-to” session on using Poll Everywhere. We will provide you with information on how to sign up for an account, create polls, and embed polls into your PowerPoints. Also, we’ll feature the Poll Everywhere competition feature. This session will provide everything you need to be up to speed using Poll Everywhere.

Register here: https://zoom.us/webinar/register/WN_ZuR52EzMTFeskde_UopiQA

Webinar: Options for Writing on Your Screen

Do you want to be able to write on your screen for your online videos and webinars? Wendy Tietz (Kent State University), Jennifer Cainas (University of South Florida), and Tracie Miller-Nobles (Austin Community College) will be hosting a 30-minute webinar on Friday, March 20, 11-11:30 am (Eastern) to discuss different options for writing on your screen.

Title: Options for Writing on Your Screen

Date/time: Friday, March 20, 11 – 11:30 am (Eastern)

  • Description: Do you want to be able to write on your screen for your online videos and webinars? Join us for a 30-minute webinar on Friday, March 20, at 11 am (Eastern) to learn about different types of options for writing on your screen. Join Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles as we talk about how to write on your screen during webinars and videos.

Stay calm and teach on!

Wendy, Jennifer, and Tracie

Webinar: Polling Options for Online Classes

Want to create student engagement in your online classes? Consider creating polls for your students to participate in. Wendy Tietz (Kent State University), Jennifer Cainas (University of South Florida), and Tracie Miller-Nobles (Austin Community College) will be hosting a 30-minute webinar on Thursday, March 19, 3-3:30pm (Eastern) to discuss different polling options for online courses.

Title: Polling Options for Online Classes

Date/time: Thursday, March 19, 3 – 3:30 pm (Eastern)

  • Registration link: https://zoom.us/webinar/register/WN_KkBhpPB6Q7m09GFSU7LxeA
  • Description: Looking to increase student engagement in your online courses? Consider creating polls. Join us for a 30-minute webinar on Thursday, March 19, at 3 pm (Eastern) to learn about different types of polling options. Join Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles as we talk about how to create polls for your online courses.

Stay posted for more webinar announcements – we will be hosting one webinar each day this week.

Wendy, Jennifer, and Tracie

Webinar: Video Recording Options

Need help in creating video recordings for your course? Interested in learning about different video recording options? Wendy Tietz (Kent State University), Jennifer Cainas (University of South Florida), and Tracie Miller-Nobles (Austin Community College) will be hosting a 30-minute webinar on Wednesday, March 18, 11-11:30am (Eastern) to discuss different video recording options. 

Title: Video Recording Options

Date/time: Wednesday, March 18, 11 – 11:30 am (Eastern)

  • Registration link: https://zoom.us/webinar/register/WN_Dim13bxJT_ugzEbJSs6Uvw
  • Description: Need help in creating video recordings for your “new” online courses? Join us for a 30-minute webinar on Wednesday, March 18, at 11 am (Eastern) to learn about different types of video recording options. Join Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles as we talk about how to create videos for your courses.

Stay posted for more webinar announcements – we will be hosting one webinar each day this week.

Wendy, Jennifer, and Tracie

Data analytics project: Fixed Asset Analysis for Hula Hut Burgers

Overview of this project

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.

Project resources

Learning Objectives

  1. Create a pivot table in Excel
  2. Format a pivot table
  3. Apply filters to a pivot table
  4. Create sum columns in a pivot table
  5. Create a calculated field
  6. Use the slicer tool in a pivot table
  7. Analyze data for errors
  8. Use the timeline tool in a pivot table
  9. Create a pivot chart in Excel

Office 365 or Excel 2016 (newest version)

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.

Solution

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.