Rules for a successful college career.

grad

.

I was lucky to have a very odd and very liberal college English professor my freshman year in a very conservative college.  He was obviously used to students’ unproductive attitudes towards his class.  So, he started the semester by giving us two rules for success in his class and college in general.

1) Complete and turn in all homework assignments–on time.

I learned to think of homework assignments as free points.  Exams are more of a crap shoot, but you can look up every question assigned as homework.  If you gather as many points as possible with homework,you can afford to miss some on the exams.

2) Cooperate and graduate.

As you might imagine, a lone liberal professor at a conservative college faces mean spirited opposition, from time to time.  I remember one particular essay that infuriated many of the students.  I was one of the few who got a good grade on my reaction paper.  I got a good grade by understanding the professor’s position, being sensitive to his position, then clearly explaining my position (as Steven Covey puts it seek first to understand, then to be understood).  In short, I cooperated.  Notice, I did not tell the professor what I thought he wanted to here.  It is too easy to see through that type of nonsense.  Telling an instructor they are stupid is a sure path to a poor grade.

In a lot of ways that English class was the foundation of my college and professional career.  There is nothing more important than to be able to think critically, and to be able to communicate your thoughts.

Posted on August 25, 2009 at 5:25 pm by Brian R. Nichols · Permalink · Comments Closed
In: Uncategorized

Poka-yoke Outlook with a macro to prevent missing attachments and empty subject lines.

outlook_logoI had a bad day last week.  I forgot the subject in one e-mail and an attachment in another.  Finally tired of feeling like an idiot (although, as a colleague of mine pointed out, If that’s the biggest problem I have . . .), I snooped around the internet and found two reminder macros.  The first is an attachment reminder, posted by Mark Bird, that pops-up when the word “attach” is in the e-mail body, but no attachment.  The second is a subject reminder, posted at Gang’s Wavelength, that pops-up when the subject line is empty.  I merged the two into one macro to do both.  Here are the directions:

1. Go to Tools>Macro>security and make sure “Warnings for all macros” or “No security check for macros” is checked

2. Open your Outlook

3. Press Alt+F11. to open the Visual Basic editor.

4. Press Ctrl+R to open a Project.

5. On the Left Pane, expand the headings until you see “ThisOutLookSession”.

6. Double click on “ThisOutLookSession” to open code pane.

7. Copy and Paste the following code in the code pane and save it (all of the following text).

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim m As Variant
Dim strBody As String
Dim intIn As Long
Dim intAttachCount As Integer, intStandardAttachCount As Integer

On Error GoTo handleError

‘Edit the following line if you have a signature on your email that includes images or other files. Make intStandardAttachCount equal the number of files in your signature.
intStandardAttachCount = 0

strBody = LCase(Item.Body)

intIn = InStr(1, strBody, “original message”)

If intIn = 0 Then intIn = Len(strBody)

intIn = InStr(1, Left(strBody, intIn), “attach”)

intAttachCount = Item.Attachments.Count

If intIn > 0 And intAttachCount <= intStandardAttachCount Then

m = MsgBox(”It appears that you mean to send an attachment,” & vbCrLf & “but there is no attachment to this message.” & vbCrLf & vbCrLf & “Do you still want to send?”, vbQuestion + vbYesNo + vbMsgBoxSetForeground)

If m = vbNo Then Cancel = True

End If

handleError:

If Err.Number <> 0 Then
MsgBox “Outlook Attachment Reminder Error: ” & Err.Description, vbExclamation, “Outlook Attachment Reminder Error”
End If

Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) = 0 Then
Prompt$ = “Subject is Empty. Are you sure you want to send the Mail?”
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, “Check for Subject”) = vbNo Then
Cancel = True
End If
End If
End Sub

Posted on July 13, 2009 at 8:03 pm by Brian R. Nichols · Permalink · Comments Closed
In: Uncategorized · Tagged with: , ,

All you wanted to know about ASQ Certification Exams: Courtesy of ASQ section-402

fyiASQ Toronto Section-402 has an in depth review of everything you want to know about ASQ certification exams.  For instance there was a 42% pass rate for the June 2009 CQE exam.  I have been asked these questions many times. They even detail a preparation strategy that is very similar to mine (I wrote about it here).  Section-402’s post will be interesting for everyone who has taken, or is interested in taking an ASQ exam

Also check out Section-402’s FREE web-based e-learnig program.  I haven’t tried it, so let me know your thoughts in the comments.

Posted on July 5, 2009 at 6:06 pm by Brian R. Nichols · Permalink · Comments Closed
In: Quality Engineering & CQE Exam

Rant: ASQ Exam Questions and Ignoramuses.

rantIt’s easy to spot someone who has not studied for the CQE exam, even those that pass it.  They always complain about the wording of the questions.  The correct answer, they say, was not an option.  Or, there were multiple correct answers depending on the situation.  The slackers are projecting their ignorance into the exam.

ASQ exam questions are created by some of the brightest minds in the quality field.  The questions have been thoroughly vetted.

If  a question doesn’t make sense to you, you are ignorant in that area of the body of knowledge (BOK).  When you complain about the questions, you prove your ignorance to those who have put in the time required to diligently study the BOK.

This is a good thing for hiring managers.  In my experience, the more ignorant a CQE is, the louder and more often he complains about the exam questions.  Just ask your potential hire what he thought about the exam and you’ll have a good a good gage of the candidate’s ignorance.

Note, lest you think me unfair:  Ignorance does not equil stupidity.  Ignorance means an absence of knowledge regarding a specific subject.  I, for instance, am ignorant of the mating habits of gilla monsters.

Posted on June 21, 2009 at 5:17 pm by Brian R. Nichols · Permalink · Comments Closed
In: Quality Engineering & CQE Exam · Tagged with: 

The CQE Exam is Easy.

testamaleA coworker of mine just found out he passed the CQE exam.  He started studying 4 days before the exam.  Two days before the exam, he was feeling a bit nervous.

What advice did I give him?  With two days to go before the exam, there is no time for learning.  I focused emergency exam taking tactics.  I gave him the glossary linked here, my copy of Thomas Pyzdek’s Quality Engineering Handbook, and my TI-30XS Calculator (you don’t want to take the exam without it). Then, I went through a bit the test taking advice I posted here.

My coworker credits his passing score to the glossary, which he used to look up about half of the questions.  And, the Pyzdek book’s index, which made it easy to quickly find the right equation for math/statistics questions.

I do not recommend this approach, but if you are a good test taker (and you know it), you may find the exam much easier than it’s reputation.

Posted on June 16, 2009 at 5:23 pm by Brian R. Nichols · Permalink · Comments Closed
In: Quality Engineering & CQE Exam · Tagged with: 

Lean Production Simplified by Pascal Dennis

leansimplified1. What new insights were gained as a result of reading the book (article, essay, post, etc.)?

Having never used them in practice, I am fascinated by Toyota’s A3 reports described on page 134.  The A3 methodology is a template for completely documenting a problem and solution on one A3 size piece of paper (A3 is the metric equivalent of Tabloid or 11″ X 17″ paper).  8D, DMAIC, and other problem solving methodologies have always seemed overly complex, tedious, and prone to send the user down many different trains of thought.  The A3 report seems to strike a balance between detail and brevity.  I am anxious to try it out.  Here is an Excel template created by someone that has never used one before (me).

My favorite new Japanese word is nemawashi.  Dennis describes it asan “elegant word [that] means ‘to prepare a tree for transplanting’ and connotes the process of consensus building that creates alignment” (p. 130).

2. What old insights were confirmed, abolished, or questioned as a result of reading the book?

Lean Production Simplified has the best description of Deming’s PDCA (Plan Do Check Act) cycle I have read (p. 146).  Interestingly, Dennis adds an axile as the first step to the cycle called “Grasp the Situation.”  In the PDCA cycle Dennis separates strategic planning in the “Grasp the Situation” phase from tactical planning in the “Plan” phase.  I always thought of the PDCA cycle as a tactical tool, but Dennis applies it globally.  In fact he says, “A manager’s job is to practice and teach PDCA” and “PDCA thinking must inform all our activities from day-to-day kaizen, to problem solving, to strategic planning” (p. 146).

A former boss of mine stressed the importance of visual management, so I thought I knew what visual management was.  To my boss, visual management was posted work instructions and SPC .  I was under the impression that visual management meant making sure the operator had visual job aides.  Reading Lean Production Simplified, I had an epiphany.  “Visual management means managing by exceptions.  In a visual workplace out-of-standard conditions are immediately obvious and can be quickly corrected” (p. 46).  Dennis says this type of workplace “talks to you.”  Things like posted pictorial work instructions, 5s, and error proofing are ways to ensure a workplace talks not only to operators, but supervisors, manager, and others too.  Now I realize what the 10 foot 2 second rule is about.  2 seconds should be long enough for anyone to understand the status of a workplace that is within 10 feet.  This can only happen if the workplace “talks.”

3. How does the book compare/contrast with other books or current events?

I like that this book was written in 2007.  The other books and articles I have read on lean production are 20 plus years old.  This is a fresh explanation of lean production with the beneficial experience of 20 plus years germination.

Reading Lean Production Simplified reminded me of The Memory Jogger II.  Each Lean Tool is reviewed and described in detail.  But, Lean Production Simplified provides a detailed analysis of each tool, not merely a memory jog.  It instills confidence in the reader.  Lean Production Simplified is the handbook for lean practitioners.

4. Are there any other points of interest not already mentioned?

There are many typos in this book.  Modern spell-check type errors, the kind that replaces a misspelled word with the wrong correctly spelled word.  These errors are worse because the brain can usually overlook a misspelled word, but the wrong word causes the reader to take a time out from reading to determine what the correct word should be based on context.  These errors in no way diminish the value of the material, but they are a minor irritation.

Posted on June 3, 2009 at 8:42 pm by Brian R. Nichols · Permalink · Comments Closed
In: Book/Article Reviews, Lean / Six Sigma · Tagged with: 

ASQ Exam Glossary

dicTaking a good glossary to ASQ examinations is very important.  This downloadable glossary posted on Scribd should do the trick.

Also, this web based glossary posted on 6sixsigma is top notch, just be prepared to spend a lot of time stitching the pages together for printing, if you want to use it on the exam.

Posted on at 10:29 am by Brian R. Nichols · Permalink · Comments Closed
In: Quality Engineering & CQE Exam

Statistical Process Control (SPC) Downloads

spc1

SPC Cookbook by Sid Sytsma, retired professor at Ferris State University (posted with permission).  I downloaded his quality tools material several years ago when I was studying for the CQE exam, and it has been a ready reference ever since.

X and mR Chart – AKA Individuals and Moving Range Charts (File=MS Excel Paper=tabloid 11 X 17).

Difference Chart – X and mR chart for data recorded as a difference from the target value – short run chart (File=MS Excel Paper=tabloid 11 X 17).

Posted on May 20, 2009 at 2:03 pm by Brian R. Nichols · Permalink · Comments Closed
In: Quality Engineering & CQE Exam · Tagged with: 

The New Manufacturing Challenge: Techniques for Continuous Improvement -By Kiyoshi Suzaki

I read this book for training at work.  I highly recommend it.  Too often business books read like a technical journal.  The New Manufacturing Challenge is an easy read.  On with the questions:

1. What new insights were gained as a result of reading the book (article, essay, post, etc.)?

2. What old insights were confirmed, abolished, or questioned as a result of reading the book?

3. How does the book compare/contrast with other books or current events?

4. Are there any other points of interest not already mentioned?

Posted on May 14, 2009 at 1:55 pm by Brian R. Nichols · Permalink · Comments Closed
In: Book/Article Reviews · Tagged with: 

Hypergeometric Probability Distribution

questionI received the following question by e-mail from someone studying for the CQE Exam.  The question is from CQE Web’s reasonably priced preparation manual, QReview.

A box contains ten assemblies of which two are defective.   A sample of three assemblies is selected at random.  What is the probability that the two defective parts will be selected?

The Hypergeometric distribution is used to answer this question.  The formula is:

eq1Where:
N=Population size
n=sample size
D=number defective in the population
d=number defective in the sample
A=number conforming in the population
a=number conforming in the sample

To solve the problem enter the data into your calculator like this

eq2

The answer is .0667

Posted on May 5, 2009 at 8:06 pm by Brian R. Nichols · Permalink · Comments Closed
In: Quality Engineering & CQE Exam · Tagged with: