Mind the Gap: Leveraging mind maps & self-assessments to develop a personal training plan

Let’s be clear here: there is a place for everyone and every skillset in cybersecurity.

Source: MITRE, https://www.mitre.org/sites/default/files/publications/pr-13-1028-mitre-10-strategies-cyber-ops-center.pdf
Source: Henry Jiang, https://www.linkedin.com/pulse/cybersecurity-domain-map-ver-30-henry-jiang
  • Analyze
  • Collect and Operate
  • Investigate
  • Operation and Maintain
  • Oversee and Govern
  • Protect and Defend
  • Securely Provision

That’s a NICE Self-Assessment You Got There!

  1. Click the “Click to view KSAs” hyperlink for our role on the Table of Contents page.
  2. Copy the entire KSA page.
  3. Open a blank workbook.
  4. Paste (plaintext) into the blank workbook.
  5. Navigate back to the supplemental workbook and copy the Tasks page for your role.
  6. Paste the Tasks as plaintext at the bottom of the page where you pasted the KSAs.
  7. You should now have the KSAs and Tasks in one long spreadsheet.
  8. Delete the extra lines and section titles between each category. For example, delete the blue line that says “Abilities” at the top of the abilities section.
  9. Insert a blank column and title it “Score.”
  10. Insert a blank column and title it “Category.”
  11. In the “Category” column, add the appropriate category (e.g. “Knowledge,” “Skills,” “Abilities,” and Task” for each line of the spreadsheet.
  1. I’ve heard of this, but please don’t ask me to explain it
  2. I’m familiar with the topic and can explain it with a little more research / Google-fu
  3. I get this stuff and can do it on my own
  4. This is my jam. I can perform this task on my own and my teammates ask me for assistance with this sorta thing. I can also explain it to my non-technical friends and family
  5. I’m kind of a big deal. I can teach it to anyone and others call me a SME for this topic
  • Risk management
  • Common networking protocols and fundamentals
  • Attacker methods and techniques

Putting it all together


Bonus Nerd Stuff

  • Category
  • Average
  • High
  • Low
  • Task
  • Knowledge
  • Skills
  • Abilities
  • In B3, type =AVERAGEIF(Category, A3, Score)
  • In B4, type =AVERAGEIF(Category, A4, Score)
  • In B5, type =AVERAGEIF(Category, A5, Score)
  • In B6, type =AVERAGEIF(Category, A6, Score)
  • In C3, type =MAXIFS(Score, Category, A3)
  • In C4, type =MAXIFS(Score, Category, A4)
  • In C5, type =MAXIFS(Score, Category, A6)
  • In C6, type =MAXIFS(Score, Category, A6)
  • In D3, type = MINIFS(Score, Category, A3)
  • In D4, type = MINIFS(Score, Category, A4)
  • In D5, type = MINIFS(Score, Category, A5)
  • In D6, type = MINIFS(Score, Category, A6)





I enjoy writing, mentoring, and sharing knowledge. I’m klrgrz (killer grizz) on Twitter. I do stuff n things with cyber threat intel.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How the Poverty Stoplight Business Network eliminates poverty for employees

You should always ask for the discount


Ask Women in Product: How do I establish a compelling value narrative for my product?

Inspirational Women In Hollywood: How Tracy Lamourie of Lamourie Media Is Helping To Shake Up The…

Mean Girl Coaches & Devious Sales Pitches

a course worth remembering

Get to Know Yourself and Understand Your Strengths

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Andy Piazza

Andy Piazza

I enjoy writing, mentoring, and sharing knowledge. I’m klrgrz (killer grizz) on Twitter. I do stuff n things with cyber threat intel.

More from Medium

All-In Podcast 2022 Predictions

How Data Collected By IoT Devices Can Support Eco-Conscious Solutions


Intranasal passive vaccines: thinking beyond the jab

Representation of an intranasal dry-powder inhaler passive vaccine. (Image credit: Lumen Bio)