Both sides previous revisionPrevious revisionNext revision | Previous revision |
downloads [2023/05/01 11:37] – ["Apollo Cause & Effect" Chart in Word (03-19-2023)] rrandall | downloads [2024/11/23 17:28] (current) – ["SMART Tasks" template in Word (10/21)] rrandall |
---|
</WRAP> | </WRAP> |
| |
===== "Competency Matrix" template in Excel (01/17/23) ===== | ===== "Competency Matrix" template in Excel ===== |
| |
{{ :downloads:competency_matrix-block_rev._01-17-23_.png?direct&600 |"Competency Matrix" template in Excel (01/17/23)}} | {{ :downloads:competency_matrix-template_11-14-23.png?direct&600 |"Competency Matrix" template in Excel}} |
<WRAP clear></WRAP> | <WRAP clear></WRAP> |
{{ :downloads:competency_matrix-block_rev._01-17-23_.xlsx |"Competency Matrix" template in Excel (01/17/23)}} | |
| {{ :downloads:competency_matrix-template_rev._11-23-24_.xlsx |"Competency Matrix" template in Excel (11/23/24)}} |
\\ | \\ |
This free "Competency Matrix" template (in Excel) utilizes "Conditional Formatting" to produce graphical block quadrants. Simply enter a space (for no training required) or number (associated with competency levels identified in the "Key + Instructions" tab) into the desired cell to produce the appropriate block icon. | This free "Competency Matrix" template (in Excel) utilizes "Conditional Formatting" to produce graphical block quadrants. Simply enter a space (for no training required) or number (associated with competency levels identified in the "Key + Instructions" tab) into the desired cell to produce the appropriate block icon. |
| |
This template provides a simple tool to address ISO 9001/AS9100, section 7.2 "Competency". | This template provides a simple tool to address ISO 9001/AS9100, section 7.2 "Competency". AND it has been verified by multiple auditors as being compliant with ISO 9001, AS9100 & AS9120. |
| |
<WRAP center round info 80%> | <WRAP center round info 80%> |
For AS9100 series companies, this "Competency Matrix" is considered equivalent to the IAQG SCMH-7.13.3 "Competency Management Template and Example", Rev-A Dated-27NOV2020. | For AS9100 series companies, this "Competency Matrix" is considered equivalent to the IAQG SCMH-7.13.3 "Competency Management Template and Example", Rev-A Dated-27NOV2020. |
</WRAP> | </WRAP> |
| |
| <WRAP center round tip 80%> |
| In the 11/23/24 version, I added [[https://www.sae.org/standards/content/as9146/|AS9146 FOD Prevention Program]] under the recurring training tab. |
| </WRAP> |
| |
| |
Aerospace-specific training topics to consider include: | Aerospace-specific training topics to consider include: |
* [[https://www.sae.org/standards/content/as9102b/|AS9102B Aerospace First Article Inspection Requirement]] | * [[https://www.sae.org/standards/content/as9102b/|AS9102B Aerospace First Article Inspection Requirement]] |
* [[https://www.sae.org/standards/content/as9146/|AS9146 FOD Prevention Program]] | |
* [[https://www.sae.org/standards/content/as5553d/|AS5553 Counterfeit Electrical, Electronic, and Electromechanical (EEE) Parts; Avoidance, Detection, Mitigation, and Disposition]] | * [[https://www.sae.org/standards/content/as5553d/|AS5553 Counterfeit Electrical, Electronic, and Electromechanical (EEE) Parts; Avoidance, Detection, Mitigation, and Disposition]] |
* [[https://www.sae.org/standards/content/as6081/|AS6081 Fraudulent/Counterfeit Electronic Parts: Avoidance, Detection, Mitigation, and Disposition - Distributors]] | * [[https://www.sae.org/standards/content/as6081/|AS6081 Fraudulent/Counterfeit Electronic Parts: Avoidance, Detection, Mitigation, and Disposition - Distributors]] |
| |
| |
===== "SMART Tasks" template in Word (10/21) ===== | ===== "SMART Tasks" template in Word (11/24) ===== |
| |
{{ :downloads:smart_tasks_-_template_10-01-21_screen_shot.png?direct&600 |"SMART Tasks" template in Word (10/21)}} | {{:downloads:smart_tasks_form_11-24.png?600|"SMART Tasks" template in Word (11/24)}} |
| |
<WRAP clear></WRAP> | <WRAP clear></WRAP> |
{{ :downloads:smart_tasks-template_10-01-21_.doc |"SMART Tasks" template in Word (10/21)}} | {{ :downloads:smart_tasks_form_11-24.docx |"SMART Tasks" template in Word (11/24)}} |
\\ | \\ |
S.M.A.R.T. is a mnemonic acronym, that provides criteria to guide in the setting of goals and objectives for better results. The first known use of the term appeared in the November 1981 issue of "//Management Review//" by [[https://www.projectsmart.co.uk/smart-goals/brief-history-of-smart-goals.php|George T. Doran]]. While there are several minor variations on the acronym, Doran's original definition was: \\ | S.M.A.R.T. is a mnemonic acronym, that provides criteria to guide in the setting of goals and objectives for better results. The first known use of the term appeared in the November 1981 issue of "//Management Review//" by [[https://www.projectsmart.co.uk/smart-goals/brief-history-of-smart-goals.php|George T. Doran]]. While there are several minor variations on the acronym, Doran's original definition was: \\ |
| |
Based on the SMART structure, this free "SMART Tasks" template provides a simple tool for management to address ISO 9001/AS9100, sections 9.3.3a (opportunities for improvement) & b (any need for changes to the quality management system). As the "SMART Tasks" template is utilized, it can also be used to address the requirement of ISO 9001/AS9100, sections 9.3.2a (the status of actions from previous management reviews). | Based on the SMART structure, this free "SMART Tasks" template provides a simple tool for management to address ISO 9001/AS9100, sections 9.3.3a (opportunities for improvement) & b (any need for changes to the quality management system). As the "SMART Tasks" template is utilized, it can also be used to address the requirement of ISO 9001/AS9100, sections 9.3.2a (the status of actions from previous management reviews). |
| |
| <WRAP center round info 80%> |
| A FREE web-based version of a SMART Task app is available at: [[https://www.smarttask.io/]] |
| </WRAP> |
| |
===== "SWOT Analysis" template in Word ===== | ===== "SWOT Analysis" template in Word ===== |
To use this template, management should review the issues identified... deleting those that are not applicable, modifying those that are applicable (when needed), and using it as a resource, identify other "quality-related" issues that aren't included in the template. | To use this template, management should review the issues identified... deleting those that are not applicable, modifying those that are applicable (when needed), and using it as a resource, identify other "quality-related" issues that aren't included in the template. |
| |
===== "Unilateral Cp-Cpk Calculator" (2-07-23) ===== | ===== "Unilateral Cp-Cpk Calculator" ===== |
| |
{{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.png?direct&600 |"Unilateral Cp-Cpk Calculator w/trend lines" (Excel)}} | {{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.png?direct&600 |"Unilateral Cp-Cpk Calculator w/trend lines" (Excel)}} |
| |
<WRAP clear></WRAP> | <WRAP clear></WRAP> |
{{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.xlsx |"Unilateral Cp-Cpk Calculator w/trend lines" (Excel)}} | {{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.xlsx |"Unilateral Cp-Cpk Calculator w/trend lines", 2-07-23 (Excel)}} |
\\ | \\ |
| |
===== "DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080) ===== | ===== "DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080) ===== |
| |
[{{:dpmo-sigma_conversion_wallpaper.png?direct&600 |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}}] | {{:dpmo-sigma_conversion_wallpaper.png?direct&600 |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}} |
<WRAP clear></WRAP> | <WRAP clear></WRAP> |
{{:dpmo-sigma_conversion_wallpaper.png?linkonly |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}} \\ | {{:dpmo-sigma_conversion_wallpaper.png?linkonly |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}} \\ |