10 Ways Excel can Improve Your Speed and the Quality of Feedback: Speed up Marking with Excel

Save time when marking by using Excel to speed up grading. When I grade this way I do not need to worry about repetitive tasks or a slow learning management system. This sheet took me an hour and a half to set up but will save me many more hours in the future. It was done in Excel 2019 on a PC. Using command instead of control should work on Mac computers.

In this video:
0:00 Introduction
0:28 Step 1 Convert the data to a table.
2:29 Step 2 Color.
2:53 Step 3 Sum and percentage formulas.
4:04 Step 4 Hide distracting information.
4:51 Step 5 Freeze the top row and specific columns.
5:39 Step 6 Conditional formatting.
6:54 Step 7 Keep everything in one document.
7:18 Step 8 Fancy formulas.
7:55 Step 9 Data validation.
8:49 Step 10 Improve Motivation.

Need Help?
Comment below!

Direct from Office

Step 3: Add Formulas.

Step 4: Hide Potentially Distracting Information.

Step 5: Freeze the top row and specific columns.

Step 7: Keep Everything in one Document.

Step 8: Fancy Formulas.

Step 10: Improve Motivation.

Reuse
Please share #Excel #Microsoft #MicrosoftExcel
Please feel free to use any of my videos as long as they are cited. I am happy to share. If you need anything to support using or remixing them please email me.

~~~~~~

Connect with me on

[tareqa]

Hi! I’m from one of your classes I love the amazing edits on your videos keep up the good work!

[dinakhentigan]

I love your videos, especially the ones on nursing research since I am enrolled in a DNP program.

[pagalShyamPremi]

फ्रेंड्स अब आपको राज्य के नीति निदेशक तत्व याद करने के लिए कोई कहानी नहीं सुननी पड़ेगी ना ही कहानी रटनी पड़ेगी सिर्फ देखते ही याद हो जाएगा मैं विश्वास दिलाता हूं आपको
आप देखते ही झूम उठेंगे
0000

[pagalShyamPremi]

फसल याद करने में परेशानी अब और नहीं🤣🤣 गुदगुदी करो 🤣🤣और याद करो 👇👇👇👇