A straightforward 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 create equations that automatically calculate overall student progress, average progress, and more, as you enter new information.
- [Instructor] In the previous video,…I created a spreadsheet to track…student progress on 21st-century skills.…Now, as you can see, I filled out the spreadsheet,…including students, as well as several assignments,…and the correlating scores.…So, the next thing I want to do in this video…is to show you how we can use simple formulas…to do calculations inside of our spreadsheet.…Now, one feature that's neat, inside of the Excel…spreadsheets is that you can select a group of numbers.…So, let's say, for instance, for the Gallery Walk,…I want to see what the average score is.…
What I can do is I can click on the first one…and drag it down, so that I highlight this whole column.…And, when I do this, on the bottom,…we get a bunch of information.…It's telling me that the average score there is a 2.68.…We have 19 grades that are in there,…and they add together for a sum of 51.…Well, in this case, the average would be important.…It's telling me that my students got an average of a 2.68,…which isn't even quite proficient,…
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: Add equations to make calculations