Learn about My Big Campus

How to get started

NWOCA can assist with setting up My Big Campus for your district.  My Big Campus can integrate with your Lightspeed filtering policies and your Active or Open Directory.  Please contact us to get the process started.

MBCQuickStart2014.pdf

Documentation

Some documentation is available in the MyBigCampus help section.

Article on SIS Imports with MBC (login to MyBigCampus required)

Other FAQs for Administrators

NWOCA Lunch & Learn - 12/14/2012

SIS Integration with PowerSchool

My Big Campus has the ability to pull in CSV files to create users and groups.  NWOCA can assist with setting up a script to export this data from PowerSchool and import it into My Big Campus on a nightly basis.

Here is an article from Lightspeed that explains the process: http://www.mybigcampus.com/groups/mbc-trainers/group_pages/sis-imports-with-mbc---268834

What can be imported?

Data TypeThings you should know
Student AccountsUsername must match the username in your AD/OD
Teacher AccountsUsername must match the username in your AD/OD
Groups/Course

These are pulled from the Sections table in PowerSchool
It will create all Sections in MBC (we can filter out some)
The Group name will match the Course name, and it can not be changed
If you delete a group from MBC it will reappear the next day

Group MembershipThe assigned Teacher in PowerSchool will also be the Teacher in MBC
Student members will be updated nightly 

Data fields in PowerSchool

Here are the basic fields that we use.  Note that your district may need some modifications if you store data in custom fields.

Data mapping help document - shows which PowerSchool fields are typically used for the import.

Users.csv

MBC field namePowerSchool field namePowerSchool tableNotes
unique_sis_user_idStudent_NumberStudents 
 TeacherNumberTeachers 
usernameStudent_Number

Students

 Must match AD/OD username
 TeacherLoginID

Teachers

 Must match AD/OD username
first_nameFirst_NameStudents 
 First_NameTeachers 
last_nameLast_NameStudents 
 Last_NameTeachers 
unique_sis_school_idSchoolIDStudents 
 SchoolIDTeachers 
gradeGrade_LevelStudentsMust be a value 0-12
emailEmail_AddrTeachersOptional
user_typeN/AN/A1 (students)
 N/AN/A2 (teachers)
passwordN/AN/ABlank when using AD/OD
authenticationN/AN/A0 (students) (AD/OD)
 N/AN/A0 (teachers) (AD/OD)

Groups.csv

MBC field namePowerSchool field namePowerSchool tableNotes
unique_sis_group_idCourse_Number + Section_NumberSections 
group_nameCourse_NameCourses 
unique_sis_user_idTeacherNumberTeachersTeacher account must exist in users.csv
unique_sis_school_idSchoolIDSections 
privateN/AN/A1 (Make group private)


Memberships.csv

MBC field namePowerSchool field namePowerSchool tableNotes
unique_sis_group_idCourse_Number + Section_NumberSections 
unique_sis_user_idStudent_NumberStudentsStudent account must exist in users.csv
unique_sis_school_idSchoolIDSections