YoVDO

Microsoft Excel - A Teachers Guide to Creating Dynamic Gradebooks-E-Markbooks

Offered By: Mr Tompkins EdTech via YouTube

Tags

Microsoft Excel Courses Educational Technology Courses VLOOKUP Courses XLOOKUP Courses

Course Description

Overview

Learn essential techniques for creating dynamic and feature-rich gradebooks in Microsoft Excel with this comprehensive 30-minute tutorial. Discover how to construct an e-Markbook complete with a student summary page and flight paths. Master 10 crucial Excel tips tailored for educators, including the effective use of Named Ranges, VLOOKUP, and XLOOKUP functions. Gain step-by-step guidance on converting marks, grades, and levels to streamline your assessment process and enhance your classroom management skills.

Syllabus

10 Excel Tips for Making Gradebooks - Teachers Guide to Microsoft Excel.
Named Ranges in Excel - Teachers guide to Microsoft Excel - Range Naming [Tip 1/10].
VLOOKUP in Excel - Teachers guide to Microsoft Excel -Using VLOOKUP [Tip 2/10].
XLOOKUP in Excel - Teachers guide to Microsoft Excel - Converting Marks/Grades/levels [Tip 3/10].


Taught by

Mr Tompkins EdTech

Related Courses

Excel Weekly Challenge
LinkedIn Learning
Excel: Lookup Functions in Depth
LinkedIn Learning
Excel: Tracking Data Easily and Efficiently
LinkedIn Learning
Managing and Analyzing Data in Excel (Office 365/Excel 2019)
LinkedIn Learning
Excel Power User Challenge
LinkedIn Learning