c. Can you make your watermark “invisible” so that it can be used to detect whether a
document containing sensitive information has been copied to an unauthorized
location? How? How could you use that “invisible” watermark to detect violation of
copying policy?
9.5 Create a spreadsheet to compare current monthly mortgage payments versus the
new monthly payments if the loan were refinanced, as shown (you will need to enter
formulas into the two cells with solid borders like a box: D9 and D14)
a. Restrict access to the spreadsheet by encrypting it.
In Excel 2007, choose Prepare and then Encrypt Document.
Then select a password, and be sure to remember it:
Further protect the spreadsheet by limiting users to only being able to select and enter data
in the six cells without borders.
To protect the two cells that contain the formula (shown below with red boxed borders):
a. Select the cells that users are allowed to change (cells D6:D8 and D11:D13)
b. Under the Format drop-down menu, select format cells
Then uncheck the box next to “Locked” as shown below, because these are going to be the only
cells we do not protect in the next step.
9.6 Visit Symantec.com or any other security software vendor assigned by your
instructor and download a trial version of encryption software.
a. Use the software to encrypt a file.
b. Send the encrypted file to your instructor and to a friend.
c. Try to open an encrypted file you receive from your friend or from your instructor.
Print a screenshot to show what happens.
d. List all the options for importing the key needed to decrypt an encrypted file you
receive from your friend or instructor. Which do you think is most secure?
Easiest? Explain why.
e. Import (or install) the key needed to decrypt an encrypted file you receive from
your friend or instructor. E-mail the decrypted file to whomever sent it to you
and obtain verification that it is the plaintext version of the encrypted file they
sent you.
9.7 The principle of confidentiality focuses on protecting an organization’s intellectual
property. The flip side of the issue is ensuring that employees respect the intellectual
property of other organizations. Research the topic of software piracy and write a report
that explains:
a. What software piracy is.
b. How organizations attempt to prevent their employees from engaging in software
piracy.
c. How software piracy violations are discovered.
d. The consequences to both individual employees and to organizations who commit
software piracy.
9.8 Practice encryption using both any encryption capabilities provided by your
computer’s operating system and by using third-party encryption software.
Required:
a. Use your computer operating system’s built–in encryption capability to encrypt a
file.
In Windows, if you are working with an open document, you can encrypt it by
choosing that option under the “Prepare” menu:
Clicking on the Advanced button brings up this dialog box:
Select the box “Encrypt contents to secure data” and follow the directions.
Create another user account on your computer and log in as that user.
In Windows, there are two ways to create new user accounts. One way is to open the
Control Panel and select the option “User Accounts”. This brings up the following
screen:
Method 2: Open the Control Panel, choose “Administrative Tools and then select
“Computer Management”:
Double-click on Computer Management and then click on the Users and Groups:
Now, click on the “Users” folder in the left pane, and then click on the “Action”
menu item at the top and select the option “New user”:
