Topic Search

Google
 

Saturday, July 19, 2008

10+ legal terms you should know if your company is involved in a lawsuit

  • Author: Calvin Sun

If your company gets caught up in a lawsuit, you’ll probably need to work with lawyers — even if the matter doesn’t involve something IT did or failed to do. Here are 10 legal concepts that are likely to come into play.


Let’s face it: We live in a society that loves to sue. Because much evidence is created or stored on computers, lawsuits involving companies invariably require work by its IT staff. I understand that most of you are IT pros, not lawyers. However, if your company becomes involved in a lawsuit, chances are you will have to work with lawyers, even if the matter doesn’t involve something you personally did or failed to do. Below are 10 terms that you might encounter during that process, along with their meanings.

To help put these terms in the proper context, let’s say that as part of a “reduction in force” initiative at your company, Stan, a manager there, laid off John, one of his employees. Convinced that his layoff was unlawful, John now has retained an attorney and has filed a suit against the company.

Note: This information is also available as a PDF download.

#1: Discovery (electronic discovery, e-discovery)

Discovery is the process by which parties to a lawsuit (i.e., the sides in conflict) show each other the evidence they have and identify the witnesses they’re going to call. You know how, when playing poker, everyone lays down their cards after they’re all finished with their bets? The same principle applies with discovery, except it occurs at the beginning rather than at the end. In other words, that stuff you see in the movies or on television about the “surprise witness” is a total myth.

In our example, John might be seeking copies of his performance reviews, e-mail messages between managers in your company (including Stan) that discussed him, and other information. Because much of this information exists in electronic form, the discovery process is also called “electronic discovery” or “e-discovery.”

#2: Litigation hold

Most companies have a policy regarding retention and destruction of documents. Their IT departments have policies and practices regarding how often they back up computer data and the amount of time before backup tapes are reused, thus destroying data already on that tape.

A litigation hold is a notice to the company that these normal policies should be suspended because litigation is reasonably expected. Continuing our earlier example, suppose a backup tape contained an e-mail from Stan to the director of human resources, and it discussed John’s firing. Suppose that the tape was scheduled to be recycled, thereby erasing that e-mail. The attorney for your company might issue a litigation hold specifying that that particular tape be set aside and kept separate from the normal backup cycle.

A major objective of a litigation hold is to prevent spoliation (see below).

#3: Spoliation

What did we say when we were in grade school about why we didn’t have our homework? “The dog ate it.”

Spoliation refers to the loss of or damage to information that was requested via discovery or that was subject to a hold. Suppose John has asked for particular electronic document. However, for whatever reason, that document can’t be produced, even though everyone knows it existed at one time. As you can imagine, the judge and John will be upset if you tell them that spoliation has occurred. If the spoliation was done in bad faith (that is, a party destroyed evidence despite knowing it wasn’t supposed to), a judge could take even more severe measures, such as imposing sanctions (see below).

#4: Sanction

A sanction is an action that a judge takes (such as imposition of a fine) to punish a side that fails to comply with that judge’s orders. During the O.J. Simpson murder trial, Judge Lance Ito issued a sanction against prosecutors Marcia Clark and Christopher Darden, and immediately afterward, both of them were seen opening their checkbooks and writing checks payable to the court.

Another sanction is the “adverse inference instruction,” which a judge can give to a jury in certain cases where spoliation has occurred. In such an instruction, the judge tells the jury that it may infer that that evidence did exist, and that it can make decisions based on such an inference. This type of instruction is adverse to one side because it goes against that side’s interests.

Suppose that in the earlier example, Stan kept a diary as a Word document, and it contained an entry that said, “Great! I can use the reduction in force as an excuse to get rid of John next week. I know it’s illegal to do so, but I want to fire John because I don’t like his kind.” Stan then learns of the litigation hold but successfully deletes the diary before John’s attorney can get it. Suppose further that there are no backups and no way to recover the diary electronically — in other words, there’s no “smoking gun.”

Even under these circumstances, John might be able to establish the existence of the diary, using legal rules and principles. For example, John’s former co-worker or a peer of Stan’s could testify that he or she saw the diary entry (and such testimony is admissible because the diary itself is no longer in existence). They could also testify that Stan talked to them about this diary entry. Because such a statement is an “admission by a party-opponent,” it is considered by definition to be “not hearsay” — an important factor because hearsay generally is inadmissible.

John also could introduce e-mail or other documents that referred to this diary — for example, an e-mail from the human resources director to Stan that said, “Don’t delete that diary entry in which you wrote you were going to fire John.” Under these circumstances, if the judge believed the testimony and evidence, and if the judge also believed the spoliation of the diary occurred in bad faith, he or she could give the jury an instruction such as the following:

Even though you never saw the diary, you can infer that it did exist, and you can infer that it said that Stan knew that firing John was unlawful.

Having the jury receive an adverse inference instruction like this one would be the proverbial kiss of death for the company. In this case, the company often will simply settle, rather than have the jury actually proceed to deliberations with such an instruction. To use an analogy from sports: if I commit goaltending while playing basketball, the referee will call it and give the other side the points they would have scored had I not been goaltending.

#5: Attorney-client privilege

Under certain conditions, communications between an attorney and the attorney’s client are privileged. Those conditions are the following: There actually must be communications, the communications must be made for purpose of giving or receiving legal advice, and the communications must have been intended to be confidential and must in fact have been kept confidential. If those conditions exist with regard to the communication, a court can’t compel its disclosure, meaning that the opposing party is not entitled to see it.

Suppose that prior to writing his diary entry, Stan sent an e-mail to the company attorney (and no one else) to ask whether this entry was a good idea. Suppose the attorney responded to Stan that this diary entry, from a legal standpoint, was a horrible idea. Under these conditions, the two e-mails are probably privileged.

If you are responding to a discovery request, be sure to consult with the attorneys for your company as you are doing so. The last thing you want to do is send privileged material to the other side.

#6: Clawback

Sometimes, privileged communications do unintentionally get sent to the other side. One way of addressing this issue is for the parties and their attorneys to enter into a clawback agreement. The parties agree that if one discloses information inadvertently, the other will return or destroy the information and provide verification of the latter. In addition, the receiving party agrees that the disclosure does not constitute a waiver of attorney client privilege.

Consider the e-mail example from the previous section, in which Stan and the company attorney exchange messages regarding the diary. Suppose that even though these two e-mails are privileged, the company inadvertently sent those e-mails to John as part of his discovery request. If a clawback agreement existed between John and the company, John would need to return the e-mails.

Even though you might have such an agreement, you still need to be careful about what you send to the other side. In other words, don’t say to yourself, “Well, if we mess up, it’s no big deal, because we can just use the clawback to get it back.” A judge might rule that because you were careless in what you sent, the clawback doesn’t apply.

#7: Electronically stored information (ESI)

Electronically stored information (ESI) exists within a computer or on storage media associated with a computer (e.g., a CD, DVD or a jump drive). It is distinguished from hardcopy information, that is, information that appears on paper.

Be aware that ESI can exist in at least two forms: native format and image format. The key difference lies in the underlying information about the document, known as “metadata” (see below).

#8: Metadata

Metadata are “data about data,” such as details about when a file was created, who created it, and when the last modification was made. In the case of an Excel spreadsheet, for example, the underlying formula of a cell would constitute metadata. When reviewing files with Windows Explorer, the file properties are also metadata.

#9: Native format

Suppose John has requested a report, as ESI, that was created using Microsoft Word. This document, in native format, would probably be a file with a “.doc” extension, that is, one that a person could modify using Word.

Be careful when sending native format documents to the other side or to the court. Those documents could contain more information than you realize, such as earlier revisions and corrections to a document. Suppose Stan sent a softcopy Word document to the company lawyer regarding the layoff, and the lawyer inserted a comment: “This argument is really weak, but our judge is so stupid he might just believe it.” If the lawyer then sent that document in native format to the judge, and the judge (or his clerk) knew how to view comments and actually saw that comment, it might hurt the company’s case.

#10. Image format

The other alternative for this document would be image format, such as a PDF or TIFF. In this format, the document still could be stored on a computer. However, changes to such a file would be significantly harder to make. In addition, documents in image format generally contain less metadata than documents in native format.

But even in image format, metadata may still exist. As with native format documents, you should be aware of what else you might be sending to the other side. Also, the other side might be dissatisfied with getting files in image format. For example, if you sent them a PDF of a spreadsheet, chances are they would see only the actual numbers, rather than any underlying formulas. They might argue that in this case, you should give them native format rather than image format.

#11: FRCP 34 and the “usual course of business” requirement

Suppose that John’s company used spreadsheets to keep track of employees, and Stan used such a spreadsheet to determine which employees to lay off. Let’s say that this spreadsheet had, for each employee, information about salary, years of service, performance rating, and other data. Furthermore, this spreadsheet contained certain formulas that used this information to produce a ranking of employees. Do you think John would want to see this spreadsheet? Of course. John would want to review the formulas to see whether they made sense and whether they really did justify his layoff.

On the other hand, the company probably would prefer that John not be able to see the formulas. What if the company converted the spreadsheet file to a TIFF file and sent that TIFF instead? Or what if the company printed out the spreadsheet and sent the information as hardcopy? If the company tried either of these methods, John would object, and most likely the court would agree.

Trials in federal courts are governed by the Federal Rules of Civil Procedure (FRCP). One particular rule, Rule 34, governs how ESI is to be “produced” in response to a discovery request. Under this rule, ESI generally must be produced “as they are kept in the usual course of business.” John would cite this rule, arguing that because it’s unlikely the company keeps spreadsheets as hardcopy and TIFF files, he should not have to receive the information that way. Rather, he should be receiving the files in native format.

Understanding these concepts and working closely with your own attorneys is essential when dealing with electronic discovery.


Quickly copy a column and row in Word table

  • Blogger: Susan Harkins

Word tables are great tools for listing and comparing values. I use them a lot because they’re so easy to create and manipulate. In addition, I’m always learning new tricks to use with them. For instance, I recently learned that you can copy an entire row or column to create a new row or column, already filled with values. Now, you’ll seldom want to reproduce an entire column or row, but occasionally the data is so similar that it’s quicker to copy all of the values from a row or column and then change a few. Here’s how to copy a column or row in a table:

  1. Quickly select the column or row you want to copy. To select a column, move the insertion point to the column’s top border. When it turns into a thick arrow pointing down (to the column), click to select the entire column. To select a row, click in the margin, just to the left of the first cell in the row.
  2. Press and hold down the Ctrl key.
  3. Click anywhere inside the selected column or row until the insertion point appears.
  4. Continue to hold down the Ctrl key and drag the column or row to where you want to insert the new column or row. Usually, that will be just before the existing value in the first cell of the row or column.
  5. Release the mouse button.

june2008blog8fig1r.jpgjune2008blog8fig2r.jpg

june2008blog8fig3r.jpg

This technique won’t write over existing data. Instead, it inserts data to create a new column or row.



Compiled by Amresh Anjan

How to keep others from printing an Excel worksheet

Blogger: Susan Harkins

It’s common to share a worksheet with others, but for many reasons you might not want them to print it. Perhaps you’re concerned about data theft or security. Maybe the data is confidential and you don’t want to risk a worksheet lying around on someone’s desk. Whatever your reason, Excel doesn’t offer a built-in feature that inhibits a print request.

The simplest way to inhibit printing of a worksheet is to cancel the print job before it starts using the following macro:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
  Cancel = True
  MsgBox "You can't print this worksheet", vbOKOnly, "Error"
End Sub

If someone tries to print the worksheet by any means, this macro automatically cancels the request. All print options are still visible and available, they just appear not to work. That might be a bit confusing, hence the MsgBox function. A message isn’t strictly necessary, but it certainly is helpful.

To create the macro:

  1. Press Alt + F11 to open the Visual Basic Editor (VBE).
  2. Display the Project Explorer (if necessary) by pressing Ctrl + R.
  3. Select This Workbook to launch the worksheet’s module.
  4. Enter the macro as shown above.

After entering the macro, return to the worksheet and try to print it. Excel will display the following message:

july2008blog4fig1.jpg

Depending on your needs, you might also refer the user to a particular person by providing an in-house phone number or e-mail address if they need help. Of course, this won’t stop the truly savvy user from printing the worksheet. Anyone who knows just a little about Excel will know how to bypass a macro, so this isn’t a powerful security measure.

Colorize your Outlook messages to identify e-mail from specific senders

  • Author: Susan Harkins

A simple but highly useful way to stay on top of important e-mail is to have Outlook display messages from different people in different colors. Here’s a quick rundown of how to set this up.


Expecting important mail? Identify it as soon as it comes in by displaying it in a distinctive color. Start by select an existing message from the sender in question, if you have one. If you don’t, that’s okay; you can enter the sender’s name manually in a minute. Now follow these steps:

  1. In Mail, choose Organize from the Tools menu.
  2. In the Ways To Organize Inbox pane, click Using Colors on the left side (Figure A).

Figure A

  1. In the first condition statement (we won’t use the second), choose From in the first drop-down list (Figure B).

Figure B

  1. If you chose a message before starting, the sender’s name will appear in the text box to the right. If it’s the wrong name, enter the right name or the person’s e-mail address.
  2. Choose a color from the second drop-down list (Figure C).

Figure C

  1. Click Apply Color and close the pane.

Afterward, Outlook will display all messages, existing and new, from the person you specified in the color you selected.

Seven keyboard shortcuts to help make your PowerPoint slide shows glitch-free

  • Author: Jody Gilbert

You don’t need to get distracted by the mechanics of presenting a slide show. Learn just a few shortcuts and you can focus on your audience and your message instead.


Remembering keyboard shortcuts is tough enough when you’re working on some no-pressure project at your desk. Get in front of an audience, and your mind may go totally blank. Your focus needs to be on the material you’re presenting and how you’re connecting with your audience — not on ” How do I back up to the previous slide?” That’s why it’s a good idea to pick a handful of the most useful shortcuts and make them second nature. When you find yourself delivering a presentation via the keyboard, these shortcuts will see you through.

Action Shortcut
Start a presentation from the first slide F5
Run the next animation or advance to the next slide Enter or Spacebar
Return to the previous slide Backspace
End a slide show Esc or - (hyphen)
Jump to the first (or last) slide Home (or End)
Jump to a particular slide Type the slide number and press Enter
Go to a black (or white) screen or resume the slide show from a black (or white) screen B (or W)
Compiled by Amresh Anjan

Create a custom Flags toolbar in Outlook 2003

  • Author: Susan Harkins

Outlook 2003’s Quick Flags feature is a handy tool — if you can develop a logical system for using it. One solution: A custom toolbar that makes it easy to flag and organize messages.


Quick Flags help you categorize your messages, usually by some level of importance or by task. For instance, you might use a red flag to mark messages that need a quick response and a blue flag to mark messages on which you’ve acted and are waiting for a response.The problem with Quick Flags is that there’s no way to customize their descriptions. Outlook identifies them only by color. You can’t change the name of Red Flag to Critical. Remembering what each color represents can become burdensome.

An easy way to remember what each flag represents is to create a custom toolbar that displays each flag with text that means something to you. Fortunately, the process is easy:

  1. From the Tools menu, choose Customize.
  2. On the Toolbars tab, click New (Figure A).

Figure A

  1. Name the new toolbar appropriately — for instance, you might name it Flags, as shown in Figure B — and click OK.

Figure B


  1. Still in the Customize dialog box, click the Commands tab.
  2. Select Actions from the Categories list box (Figure C).

Figure C

  1. Scroll down through the Commands list box to find the flag entries. Then, drag the appropriate flag color buttons onto your custom toolbar. (If you can’t find the toolbar, look behind the dialog box.)
  2. After adding all the flags you want, change the text for each flag button. Right-click a flag button on the toolbar and replace the Name setting, e.g., &Red Flag (Figure D), with something more helpful, such as Critical. Select the Image And Text option so that Outlook will display the button’s name on the toolbar (Figure E).

Figure D

Figure E

  1. Complete steps 6 and 7 for each flag button in your new toolbar.

Figure F shows an example of the finished toolbar.

Figure F


Compiled by Amresh Anjan


Build related tables with the Access 2007 Lookup Wizard

Author: Mary Ann Richardson

The Access 2007 Lookup Wizard makes it easy to create a related table. This walk-through demonstrates how it works.


You’ve just created an Employee Records table for your Employees database that lists personal information (such as Address, Phone Number, and Birth date) for each employee. Now you need to create a second table that lists each employee’s work location and job title. This new table will use the Employee ID field in the Employee Records table as its foreign key field, a field that refers to the primary key field in another table. Follow these steps to create the related table:

  1. Click the Create tab and then click the Table Design button in the Tables group.
  2. Enter the Location and Job Title fields as text fields with a Field Size of 20.
  3. Switch to Datasheet View.
  4. Click Yes.
  5. Enter Job Assignments as the table name and click OK.
  6. Click No to create a primary key.
  7. Display Tables in the Navigation pane.
  8. Click the Datasheet tab under Table tools and click the Add Existing Tools button from the Fields & Columns group.

Figure A

  1. Click + to display the field names for the Employees table in the Field List.
  2. Click and drag the Employee ID field to the left of the Location field in Datasheet View.

Figure B

Figure C

  1. Click Next
  2. Click Next twice moreand then click Finish.

To add a record, the user selects the Employee ID number from the list and then enters his or her location and job title.

Figure D


Compiled by Amresh Anjan

When Excel’s AVERAGE function doesn’t give true results, try AVERAGEA

Author: Mary Ann Richardson

If your data includes text values, Excel’s AVERAGE function won’t give you an accurate picture. See how AVERAGEA can solve this problem.


Sometimes, the AVERAGE function does not give a true picture of your data. AVERAGE can only find the average of a range of numerical values; it skips any text values. For example, the results of a monthly mailer for donations to a nonprofit organization are listed below. If you want to know the amount of the average donation that came in, you would use the AVERAGE function, as shown in B20. The results would not include those who received the mailing but did not send a donation.

If you want a better picture of how your donors responded to the mailing, you would use the AVERAGEA function, as shown in B21. AVERAGEA evaluates the text value None as 0 and includes that value in its calculation.

Figure A

Thus, of those who responded to the mailing, the average donation was $145.45. However, if we are to count those who gave $0, the overall average response to the mailing was $106.67.

Figure B


Compiled by Amresh Anjan