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
Accompagnez vos élèves à l'orientation grâce aux MOOCFrance 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