Progress Tracking with PowerShell

KorovievKoroviev Posts: 44Member ■■□□□□□□□□
As I was skimming through the objectives in Asif Dasl's thread, it occurred to me that I would like to have an organized method of tracking progress based on those objectives.

So, I created a PowerShell-friendly spreadsheet ;)

Link to CSV (defaults are for 410 but can easily be modified for other exams): https://www.dropbox.com/s/n7o1i1nu47tmuqh/Master.csv

Properties:

1. Section - Default based on thread
2. Objective - Default based on thread
3. Video - Number of hours spent on video content
4. Reading - Number of hours spent reading
5. Lab - Number of hours spent "in the lab"
6. PowerShell - Have I configured this with PowerShell? Yes/No

Examples of how to get some numbers:

1. This example demonstrates how to get the total number of hours spent in the lab on objectives pertaining to Hyper-V.

# Fill the object array
$objArr = Import-Csv -Path 'd:\lab\server 2012\410\master.csv'

# Instantiate sum variable
$sum = 0

# Get objectives where the section relates to Hyper-V and add lab hours to sum
$objArr | ? {$_.section -like '*hyper-v*'} | % {$sum += $_.lab}

# Print sum
$sum

2. I was going to add another example here, but then I ended up writing several functions to manipulate the data...

Link to script: https://www.dropbox.com/s/13mfewg5z5mbxa7/Get-410Metrics.txt

Functions include:

Get-SectionTotalTime
Get-TotalTime
Get-SectionPercentage
Get-PercentReport

Simply change the file type to '.ps1' to use, and of course, change the CSV path to reflect your environment. Also, if you would like to use this to track progress for a different exam, then modify $sectionArr with unique identifiers for the sections you are studying.

I am sure the script could be improved, but that is what I have for now :)

Comments

Sign In or Register to comment.