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,…we took a look at how to set up a spreadsheet…in order to track student progress in a certain area.…In my case, I wanted to track student progress…in 21st Century Skills.…So, as you can see, I've added in students,…and here I have approximately 19, 18 different students.…And at the top, I have some different assignments.…It was a letter to our community partners,…a gallery walk, Group Project One,…the Genius Hour presentations,…veterans' invitations, and so on.…And below that, it's telling me…the category that they belong in,…in other words, this one is for soft skills, communication,…collaboration, another one for communication, and so on.…
So I wanna take a look at here, how we can add in…an equation or a formula to do some calculations…inside of a Microsoft Excel spreadsheet.…Now this could easily be used to give a student average.…If you were putting in percentages for assignments here,…you could use a formula to add up all of their assignments…and then divide it by the total possible to give you…
Author
Oliver Schinkten
Released
10/27/2016- Creating effective and engaging presentations
- Creating flipped classes with Office Mix
- Empowering students with PowerPoint
- Creating tutorials, newsletters, and flipped classes with Sway
- Tracking student progress in Excel
- Using Word templates
- Creating visual representations in Word
- Using OneDrive for collaboration and storage
- Creating modules and flipped classes using OneNote
- Using Outlook, Docs.com, Skype, and SharePoint
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome51s
-
What you should know1m 3s
-
-
1. Overview of Microsoft Office
-
What is Microsoft Office?1m 59s
-
Microsoft Office Online2m 1s
-
-
2. Microsoft PowerPoint for Educators
-
Link actions6m 9s
-
3. Sway for Educators
-
What is Sway?5m 55s
-
Create tutorials with Sway6m 26s
-
Empower students with Sway1m 42s
-
4. Microsoft Excel for Educators
-
Track student progress7m 36s
-
Filter results3m 18s
-
5. Microsoft Word for Educators
-
Use Word templates1m 46s
-
Create your own templates1m 31s
-
6. OneDrive for Educators
-
7. OneNote for Educators
-
8. Additional Microsoft Tools
-
Outlook1m 6s
-
Docs.com3m 2s
-
Skype3m 15s
-
SharePoint1m 13s
-
Conclusion
-
Next steps1m 37s
-
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