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
Excel Weekly ChallengeLinkedIn 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