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 Type	Things you should know
Student Accounts	Username must match the username in your AD/OD
Teacher Accounts	Username 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 Membership	The 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 name	PowerSchool field name	PowerSchool table	Notes
unique_sis_user_id	Student_Number	Students
	TeacherNumber	Teachers
username	Student_Number	Students	Must match AD/OD username
	TeacherLoginID	Teachers	Must match AD/OD username
first_name	First_Name	Students
	First_Name	Teachers
last_name	Last_Name	Students
	Last_Name	Teachers
unique_sis_school_id	SchoolID	Students
	SchoolID	Teachers
grade	Grade_Level	Students	Must be a value 0-12
email	Email_Addr	Teachers	Optional
user_type	N/A	N/A	1 (students)
	N/A	N/A	2 (teachers)
password	N/A	N/A	Blank when using AD/OD
authentication	N/A	N/A	0 (students) (AD/OD)
	N/A	N/A	0 (teachers) (AD/OD)

Groups.csv

MBC field name	PowerSchool field name	PowerSchool table	Notes
unique_sis_group_id	Course_Number + Section_Number	Sections
group_name	Course_Name	Courses
unique_sis_user_id	TeacherNumber	Teachers	Teacher account must exist in users.csv
unique_sis_school_id	SchoolID	Sections
private	N/A	N/A	1 (Make group private)

Memberships.csv

MBC field name	PowerSchool field name	PowerSchool table	Notes
unique_sis_group_id	Course_Number + Section_Number	Sections
unique_sis_user_id	Student_Number	Students	Student account must exist in users.csv
unique_sis_school_id	SchoolID	Sections

Child pages