MS Excel: Password Protecting Sensitive Information

Guide Topic

When sensitive information is disseminated, such as student-level data that identifies an individual student, the data should be encrypted in some way. The easiest way to protect Personally Identifiable Information (PII) is to password-protect the file prior to sending.

The protected file and the password for the file should always be separate.  Never send the two together in the same email.  Send the protected file in one email and then another email with the password for the protected file.

Microsoft Excel will most likely be the file format used to send student information that needs encrypting, i.e. password protecting.

Instructions

  1. Open the Excel file you wish to password-protect.  (example file below)

2. Click on File in upper left-hand corner.

   3. In the File menu, click on Info

4. In the Info section, click on the Protect Workbook tile.

5. Then click on Encrypt with Password.

6. Then an Encrypt the contents of this file pop-up dialog box will appear.  This box provides instructions for creating a password to protect the document.

7. Once you enter a password, a second pop-up dialog box will appear asking for password confirmation.  Reenter the password created in step 6.

8. Your file is now password-protected.  To test this, close the file and then reopen it. The screen below should appear.

9. Enter the password you created in step 6. Click OK. The file will open.

REMEMBER:  When sending a password-protected Word document within TCC, send the protected file in one email and the password for the protected file in another email.

Personal Data that is sent to a third party, such as Fort Worth ISD, is done under a restrictive legal agreement.  Data transfer utilizes Secure File Transfer Protocol (SFTP) which is a protected and encrypted portal.

Individual employees should rarely or never send student-level data to an outside agency or individual.  To do so could be a FERPA violation and possibly a criminal violation without the proper authorization or authority.

Details

Article ID: 680
Created
Fri 9/23/22 1:02 PM
Modified
Thu 10/12/23 10:16 AM