One way for educators to use Microsoft Excel is to create spreadsheets that help track student progress, whether to track student grades or progress on something else such as returned forms, 21st-century skills, or additional certifications. Microsoft Excel allows you to format cells to follow certain algorithmic rules. You can set parameters that cause certain cells to appear yellow, or other customizations. This allows educators to quickly identify students who need additional support or are improving their performance.
- [Instructor] A spreadsheet like this…contains a lot of data.…And when you look at it,…it can be kind of confusing.…It'd be nice if we had a way to quickly identify…certain things inside of the spreadsheet.…And, we do!…So, we have a way to do this called conditional formatting.…In this video,…we'll take a look at how to do that.…So, in this case, what I want to do…is I want to find students who are either struggling…or students who are doing really well.…First of all,…I'm going to go ahead and select all of the student scores.…So, I'll select this area right here.…
Next, I'm going to go over to the Home tab.…And on the right hand side,…you'll see something titled Conditional Formatting.…From here, if I click on it,…I get several different options.…And you'll want to go in and check some of these out…to see which one works best for you.…I like the Highlight Cells Rules.…So, once here, in Highlight Cell Rules,…I can decide what I want to do.…Is it Greater Than, Less Than, Between?…In this case,…I'd like to find ones that are equal to four…
Author
Oliver Schinkten
Released
12/5/2018- Overview of Microsoft Office 365 for educators
- Creating effective and engaging presentations in PowerPoint
- Recording presentations for flipped classes
- Creating tutorials and flipped classes with Sway
- Tracking student progress with Excel
- Creating visual representations of data in Word
- Sharing resources with OneDrive
- Creating class notebooks with OneNote
- Communicating and collaborating with Microsoft Teams
Skill Level Intermediate
Duration
Views
-
Introduction
-
1. Overview of Microsoft Office
-
Microsoft Office Online2m 36s
-
2. Microsoft PowerPoint for Educators
-
Effective presentations3m 9s
-
Engaging presentations2m 52s
-
Link actions6m 10s
-
3. Sway for Educators
-
What is a Sway?5m 39s
-
4. Microsoft Excel for Educators
-
Track student progress7m 25s
-
Filtering results2m 39s
-
5. Microsoft Word for Educators
-
Use Word templates1m 46s
-
6. One Drive for Educators
-
7. One Note for Educators
-
OneNote Class Notebooks7m 59s
-
OneNote Web Clipper2m 59s
-
8. Microsoft Teams
-
Create a new class4m 44s
-
Create assignments5m 14s
-
Conclusion
-
Next steps1m 54s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Conditional formatting of cells