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.
Documentation
Some documentation is available in the MyBigCampus help section.
Article on SIS Imports with MBC (login to MyBigCampus required)
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 |
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_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 |
2 Comments
Unknown User (destelle)
Under the groups session, it says "The Group name will match the Section name, and it can not be changed". Will the group name be the Course Name or the Section Name?
Thanks!
Brad Rellinger
Hi Darren, the Group name in My Big Campus will match the Course name from PowerSchool. My understanding is that there is no separate value in PowerSchool for Section name. - Thanks