D2L - Encrypt Exported Grade Book using Office 2010 on Windows

Last Updated: 05/06/2014
Layout:
One Column
Two Column

Overview

Encrypting the data in a downloaded Gradebook helps protect the privacy of student grades. This tutorial shows how to do so using Excel from Office 2010 for Windows.

This tutorial is operating system independent.

Step 1

Open the file either by double clicking on the file or opening the file in Microsoft Excel.

Visual representation related to step 1

Step 2

In the Windows Home drop-down menu select Prepare. From the Prepare side menu select Encyrpt Document.

Visual representation related to step 2

Step 3

Enter a password and click the OK button.

Visual representation related to step 3

Step 4

Reenter the password and click the OK button.

The document is now protected.  Please remember that the document cannot be recovered if you lose your password.  If you need to keep a list of passwords store the list in a secure location such as a lock box or locked cabinet.

Visual representation related to step 4

Step 5

Next you must permanently delete the original file downloaded from Desire2Learn.  To permanently delete a file, click the file, press SHIFT, and then press DELETE.  Be certain that you are deleting the correct file.  This step for deleting files is not sufficient for deleting old gradebooks which contain Social Security Numbers. Please contact the IT Security Office for help securely deleting files containing Social Security Numbers.

Visual representation related to step 5

Was this helpful?

Back to top