$Groups = Import-Csv .\Downloads\Students-Day1.csv | sort Class -Unique


foreach($group in $Groups)
{
$groupName = $group.Class
New-ADGroup -name $groupName -GroupScope 2 -ErrorAction SilentlyContinue
#write-Host $groupName

}

$Students = Import-Csv .\Downloads\Students-Day1.csv
foreach($student in $Students)
{
$firstName = $student.Firstname
$lastName = $student.Lastname
$fullName = $firstName + " " + $lastName
$studentID = $student."Student ID"
$DOB = $student.DOB
$password = ConvertTo-SecureString -AsPlainText $DOB -Force
$class = $student.Class
$status = $student.Status
$enrolled = $student.enrolled
$userName = $lastName.Substring(0,3) + $studentID.Substring(3,4)
$status = $student.Status
New-ADUser -Name "$fullName" -DisplayName "$fullName" -SamAccountName $userName -GivenName "$firstName" -Surname "$lastName" -AccountPassword $password -Enabled $true -ChangePasswordAtLogon $false -PasswordNeverExpires $true -ErrorAction SilentlyContinue
if($status -eq "A" -Or $status -eq "R"){
  Add-ADGroupMember -Identity $class -Members "$username"
}
Set-ADUser -Identity $userName -HomeDirectory "\\WIN-83V4D22AKI7\UserProfiles$\$userName" -HomeDrive Z

}