Microsoft Excel - A Teachers Guide to Creating Dynamic Gradebooks-E-Markbooks
Offered By: Mr Tompkins EdTech via YouTube
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
Learning Creative LearningMassachusetts Institute of Technology via Independent Blended Teaching of World Languages
Independent Foundations of Virtual Instruction
University of California, Irvine via Coursera Emerging Trends & Technologies in the Virtual K-12 Classroom
University of California, Irvine via Coursera Teaching Adult Learners
Central Institute of Technology via Open2Study