Senior Internship - Week 6 Progress Report

Hours worked: 17

Total Hours: 74

Last week I was unable to work, however, before that I had started to plan out how I'd tackle the creation of a python application that would let me both update the passwords of Active Directory accounts and email a list of individuals the new password.

I spoke with an IT security personnel named Max and we discussed the best way to ensure I am handling passwords safely. Originally, I had planned to use python and to read/write a csv file. However, he suggested that this wasn't the safest option and that I'd be better off using an encrypted and password protected excel file.

So, to me, this means I will have to use less python and more VBA.

I had hoped to start this application this week but due to the workload I was given I was unable to do so.

Next week I will begin writing the application in VBA. I believe it will be possible to create the form, plan out how it will work, and understand all the different macros I will need to create. That way, I will be ready to write it the following week (7).