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

Accompagnez vos élèves à l'orientation grâce aux MOOC
France Université Numerique
Increase Reading Comprehension with Actively Learn
Coursera Project Network via Coursera
Adult Education Essentials: Student-Centred Delivery for Adult Learners
Waikato Institute of Technology via FutureLearn
Advanced Google Classroom for Education
Coursera Project Network via Coursera
Introduction to HyFlex Learning and Teaching
University of Southern Queensland via FutureLearn