Kritik Webinar Series Downloads

Thank you for your interest in our webinars

Excel, Gradebook &
Data Manipulation for Professors

COVID-19 has affected the way in which professors are providing grades and assessments to students. During this session, we will review common data and text manipulation essential for managing student lists and grading in Excel.

If you are using any new tools or methods to assist you with transitioning to online classrooms, it is essential to understand the basics of excel, gradebook and data manipulation.

During this session, we will cover a variety of topics to help educators manipulate data for managing students.

Topics include:

  • General overview of basic excel functions and formulas
  • Separating students First Name and Last name in two columns
  • Creating student emails if only given their username
  • If using an external tool, determine who in your student roster has no yet registered (using VLOOKUP function in excel)
  • Understanding how to drop a student’s lowest quiz/homework mark in excel
  • Q&A session for specific use cases with our expert data analysts
Download Slide Deck

The Human Element of
Remote Learning

As colleges and universities pivot quickly towards online learning, buzzwords like "social distancing" and "self-isolation" have emerged as part of a new language of loneliness.

The new reality of higher education has also brought a new set of challenges to educators and students: How do you facilitate a social-academic community when you can’t see anyone face-to-face?

During this session, we will cover a variety of topics to help educators uncover the human element of remote learning.

Topics include:

  • Practical ideas to create an intimate, engaging, enjoyable learning environment
  • Discussion and Q+A with Dr. Alissa Pencer (Senior Instructor and Registered Psychologist)
  • Discussion with Dr. Mohsen Shahini (co-Founder of Kritik and Top Hat)
  • Tips on maintaining relationships from a distance: both peer-to-peer and student-professor
  • Students' needs from a students' perspective
Download Slide Deck