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.
Microsoft Excel - A Teachers Guide to Creating Dynamic Gradebooks-E-Markbooks
Mr Tompkins EdTech via YouTube
Overview
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
Related articles
Reviews
5.0 rating, based on 1 Class Central review
-
A NMy MS Excel teacher was incredibly knowledgeable and patient. They were able to clearly explain complex concepts and provide examples to help us better understand. They also provided helpful tips and shortcuts that made working with Excel much more efficient. They were always available to answer questions and provide additional support. Overall, I greatly appreciated their expertise and dedication to helping us excel in our understanding of Excel.
