====== Creating Users for Sebeka Schools ======

===== Infinite Campus =====
  - login as tschulz
  - select **all schools**
  - go to **Ad Hoc Reporting->Data Export**
  - Select Student **Export->New Student Logins**
  - export as CSV

===== CSV =====
  - open CSV copy new student rows
  - open **student_logins.xls**
  - paste into **New Students** worksheet
  - in column F paste username formula e.g. row 67<file>
=LOWER(CONCATENATE(14-E67+12,LEFT(C67,1),B67))
</file>
  - copy new user rows into **Student Logins** worksheet

===== Gmail =====
  - copy new user rows into gmail_script worksheet
  - copy user data into gam rows e.g. <file>
gam create user <USERNAME> firstname <FNAME> lastname <LNAME> password <PASSWORD> changepassword off agreedtoterms off
</file>

===== Creating users in AD =====
  - copy new user rows from **student_logins.xls**:**New Students** into a fresh text file save as csv
  - select **Students->import**
  - on **DC01** run **Active User Manager** run **New User Wizard**
  - align columns in **New User Wizard** and import
  - assign new users to correct groups (this is essential for network drives to map correctly)
  - lastly move users to their correct OU