Sean O’Shea: Ideas for Paralegals and Litigation Assist Professionals – March 2021 | Affiliation of Licensed E-Discovery Specialists (ACEDS)

03/01/2021: Excel DSUM formula
Excel’s DSUM formula is a useful alternative to VLOOKUP. It reads the column headings of a data array and returns the total based on criteria entered in a separate set of cells.

March 2nd, 2021: Autoruns
A free utility from Microsoft shows you which programs run automatically when you start.

03/03/2021: Is your SMS an SMS?
SMS messages are sent over cellular networks. OTT messages (exaggerated) are sent over the internet.

March 4th, 2021: Don’t let ACE (or RCE) kidnap you
Arbitrary Code Execution (ACE) is a form of cyberattack that allows the attacker to execute code in software or on hardware. Remote Code Execution (RCE) is an exploit that allows code to be executed on a network.

03/05/2021: Exchange Server exploit detected
The hafnium exploit works by gaining access to an Exchange server using stolen passwords and then remotely controlling the server using a web shell.

March 6th, 2021: Failure to meet the detection deadlines is a lack of care and not a lack of sophistication
At the hearing, the plaintiffs ‘attorney alleged inexperience with the complexity of the ESI discovery and the need to coordinate with the other defendants’ attorney on counterclaims. Neither is an excuse. At each step, the court asked plaintiffs to set the pace. . . Plaintiffs cannot justify their habitual failure to comply with their own estimates of the time it takes to complete their discovery obligations as a lack of sophistication. Instead, it shows an unjustified lack of care. “Lunsford v JBL Communications, LLC, No. 19 CVS 3973, 2021 NCBC LEXIS 17, at * 17-18 (NC Super. March 3, 2021)

March 7th, 2021: Project Management – Overview
Click above for a rough overview of the content of project management knowledge.

March 8th, 2021: Remove rootkit
Your computer can be infected with rootkit software – malicious software that allows access to restricted areas of a computer or the legitimate software installed on it. If you’d like to complement your antivirus software’s search for rootkit, you can download the free Sophos Rootkit Removal Tool.

March 9th, 2021: Nymity Privacy Management Accountability Framework

March 10th, 2021: APEC’s cross-border data protection regulations
APEC has a CBPR (Cross Border Privacy Rules) system that confirms that the countries have complied with the data protection laws of the member countries.

March 11, 2021: Impact assessments on data protection
According to Article 35 of the General Data Protection Regulation, an impact assessment must be carried out for data processing that poses a high risk to personal data

03/12/2021: Field is missing in the “Add condition” list: Search for related fields in the theory of relativity
Note that some fields are related fields in relativity. When you do a relativity search, these fields are listed under the parent field. To perform a search in one of the related fields, select the parent field. This will open a new window in which you can set conditions for the associated fields.

03/13/2021: How to see if you have a hard drive or an SSD
You can use the defragmentation utility in Windows to check the media type of the PC and all connected drives.

03/14/2021: Mirror image when zooming
The default settings in Zoom show your video stream with the image reversed. Turn it over to view printed demonstrations.

03/15/2021: contradicting, admitting and authenticating evidence in motion
Quickly go through the steps required to turn evidence on or off with the Federal Evidence Applied app.

March 16, 2021: A red X does not mark any point in the cloud
After copying data to a new location in Windows 10, you may have noticed that some files have an X in a red circle next to them in a Status column. This is a sign that the files were not backed up to a OneDrive cloud account or other application like DropBox.

March 17, 2021: PXE Black Screen
If “Start PXE over IPv6” appears on a black screen, disconnect all external devices and drives, and restart the computer.

03/18/2021: FACTA – Law on Fair and Accurate Credit Transactions
FACTA is a federal law that requires credit reporting agencies to block all information used in a credit report within 4 days of receiving evidence that the information has been compromised as a result of identity theft.

March 19, 2021: ED Tex .: Definition of the encrypted digital information transmission for the Claim Construction Chart
The Court defined “encrypted digital information transmission” as “all digital information that has been encrypted and moved between at least two devices”, not as transmission containing only digital information.

March 20, 2021: FTC disposal rule
The FTC requires a company to proactively confirm that agents using consumer data that the company has collected are complying with the disposal rule.

03/21/2021: GLBA protection rule
Under the GLBA security rule, a financial services company can be fined up to $ 100,000 for disclosing non-public personal information (NPI).

March 22, 2021: Bivariate scatterplots
If the name is unknown, you will likely recognize this type of chart anyway. Bivariate scatterplots trace the relationship pattern between two variables. Each point on the plot is assigned a value on the X-axis and on the Y-axis.

03/23/2021: Center objects in PowerPoint
Don’t miss out on a simple little trick in PowerPoint to use when resizing objects. Typically, when you click and drag the corners of an object to zoom in or out, its center shifts. Holding down the Ctrl key will keep the center of the shape at a fixed point on the slide.

March 24th, 2021: Rotate ruler in PowerPoint
Use the mouse wheel to rotate the ruler used to draw lines in PowerPoint.

March 25, 2021: GPS and CSLI data
A GPS system uses signals from four satellites to triangulate the position of a cell phone. Location information systems for cellular sites use signals from cell phone towers.

March 26th, 2021: Theory of Relativity
The theory of relativity uses an interesting term, “escalation rate,” to describe how unresponsive custodians should be reminded of their obligation to comply with a freeze. I had never heard this term before, but it is obvious how important it is to get this right. These should be tailored to individual custodian banks and individual projects.

03/27/2021: CALEA – The law that allows the FBI to overhear
The Law Enforcement Communication Support Act (CALEA), Pub. L. No. 103-414, 108 Stat. 4279 (1994) (codified in 47 USC Sections 1001-1010) was passed to facilitate wiretapping by law enforcement agencies by requiring telecommunications companies to develop systems that included covert monitoring of telephone lines.

03/28/2021: Nevada Senate Bill No. 538
Nevada Senate Bill No. 538, passed in 2017, requires that websites that collect personal information notify Nevada residents of the steps they will take to ensure that information is kept securely confidential. Businesses that don’t have online sales as their primary source of income and that have fewer than 20,000 visitors per year are not required to comply with the law.

03/29/2021: California takes on the obligation to technological competence
This month California did what most states did, adopting Comment 8 on Model Rule 1.1 of the ABA. Rule 1.1 concerns the duty to competently represent a client and Comment 8 states that an attorney “must keep abreast of any changes in the law and its practice, including the benefits and risks associated with the relevant technology”.

03/30/2021: Search for words that show opposing parties in the worst case
Search a production for mundane words in documents in which people express their strongest feelings on important issues.

March 31, 2021: Westlaw’s drawing assistant
Thomson Reuters has an add-in for Word that automatically extracts all quotes in brief and allows you to jump to any instance of a particular quotation in full or short form.