How to Create a Gradebook in Excel
A 10-part course with Todd McLeod
Start Free Preview Start CourseCourse Overview
Teacher
My education includes a Bachelor’s degree in Economics from UC Santa Cruz and an MBA from CSU Fresno. My academic honors include: UCLA Alumni Scholar, UCSC Graduating Honors, CSUF Phi Kappa Phi, CSUF Beta Gamma Sigma, CSUF Dean’s List all semesters,... View ProfileDetails
- Total Time 45 min
- Lessons 10
- Attachments 20
- Exercises 20
-
27 CQ
10 Lessons in This Course
-
4 minFREEMicrosoft Office lesson 1Free3 CQ
Managing student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.
with Todd McLeodManaging student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.
-
7 minMicrosoft Office lesson 24 CQ
In this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.
with Todd McLeodIn this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.
-
2 minMicrosoft Office lesson 32 CQ
In this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.
with Todd McLeodIn this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.
-
2 minMicrosoft Office lesson 42 CQ
Learn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!
with Todd McLeodLearn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!
-
3 minMicrosoft Office lesson 52 CQ
Add Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!
with Todd McLeodAdd Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!
-
2 minMicrosoft Office lesson 62 CQ
In this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!
with Todd McLeodIn this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!
-
5 minMicrosoft Office lesson 73 CQ
In this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.
with Todd McLeodIn this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.
-
3 minMicrosoft Office lesson 82 CQ
Learn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.
with Todd McLeodLearn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.
-
2 minMicrosoft Office lesson 92 CQ
You’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.
with Todd McLeodYou’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.
-
9 minMicrosoft Office lesson 105 CQ
In this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.
with Todd McLeodIn this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.
-
56378 min56-part Microsoft Office course216 CQ
Teachers, business professionals, and anyone else who needs to organize large amounts of data—this complete guide (for beginners!) to data analysis and visualization in Microsoft Excel is for you.
with Todd McLeodTeachers, business professionals, and anyone else who needs to organize large amounts of data—this complete guide (for beginners!) to data analysis and visualization in Microsoft Excel is for you.
-
17183 min17-part Basic Computing course98 CQ
Computers are essential tools that can increase your productivity and boost your quality of life. Improve your understanding of technology and basic computer skills with this beginner-friendly course.
with Todd McLeodComputers are essential tools that can increase your productivity and boost your quality of life. Improve your understanding of technology and basic computer skills with this beginner-friendly course.
-
10115 min10-part Basic Computing course62 CQ
Understanding how a computer stores data is an essential computer skill. In this course, computer expert Todd McLeod shares everything he knows about computer data storage and how to manage memory.
with Todd McLeodUnderstanding how a computer stores data is an essential computer skill. In this course, computer expert Todd McLeod shares everything he knows about computer data storage and how to manage memory.
-
17130 min17-part Hardware course74 CQ
If you’re looking for a course that covers the basics of computer hardware in plain language, this is it! Learn everything from drives to ROM with technology and computer expert, Todd McLeod.
with Todd McLeodIf you’re looking for a course that covers the basics of computer hardware in plain language, this is it! Learn everything from drives to ROM with technology and computer expert, Todd McLeod.
-
1484 min14-part Basic Computing course49 CQ
Want to learn the basics of how computers work? In this course, tech expert Todd McLeod demonstrates essential computer skills—including how to use keyboard shortcuts and customize your desktop.
with Todd McLeodWant to learn the basics of how computers work? In this course, tech expert Todd McLeod demonstrates essential computer skills—including how to use keyboard shortcuts and customize your desktop.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.