Timetable

Overview - Timetable

Are you sure you want to remove this component?

Accessing your Timetable

Are you sure you want to remove this component?

You can access your timetable in a number of ways, but this depends on the set up of your school.

You can:

1. View your entire timetable by adding /timetable to the end of the URL from your dashboard.

2. View your entire timetable by selecting the Timetable tab in the top menu.

image.php?hash=1ba51d5b1758968950a114a3cddd1d190ca1ce58

3. View the timetable for the day on your dashboard.

image.php?hash=bcf74541f3df8daa39c2ae084d945d5257befb92

Accessing Another User's Timetable

Are you sure you want to remove this component?

1. Select the Search tab in the top menu.

image.php?hash=3730f0e39c438a5ef8447083dc299473efa164c1

2. Type the person whose timetable you wish to view.

image.php?hash=f2ae50a40fa3536330616421241433a5a1b0f44a

3. Navigate to the user's profile page.

4. Select the 'Timetable' tab.
 image.php?hash=12a6a9476575b8d594b6915cf9c4529c382f7530

 

Creating a Timetable using SUDs (Superuser Only)

Are you sure you want to remove this component?

Using the three tabs in Administration > School Data Import (Timetable Structure, Timetable, and Enrolment), you can create the timetable for school. These three tabs should be completed in order.

Once the timetable data has been uploaded, the timetable will not appear unless class pages are created.

Before you create your timetable, ensure you have completed the following:

  • Create the Campus/es in Administration > Lists > Campus.

  • Set the Term date in Administration > Terms. You can only view timetable data for the current Term.

  • Ensure you have the Exernal IDs/Schoolbox ID for staff who will be assigned as teachers for each class. You cannot use the Schoolbox User ID, Username, or any other potential identifier). 

Importing the Timetable Structure 

Importing the timetable structure will create the grid/structure for your timetable; it will not be populated with data. You will add the data by importing the timetable then uploading the enrolment data. 

The entire timetable structure for the current term must be included. All periods for all days must be specified as it does not append. 

Periods will be displayed in the order specified in the CSV. The entries in the ‘Time’ field have no bearing on the display order.

1. Go to Administration > School Data Import > Timetable Structure

2. Click 'Download Template' and fill in the details. 

 Some things to note:

  • Term Campus: This must match the external timetable code that is set in Administration > Lists > Campus.

  • Term Title: This can be labelled in any way you like, but must be filled in because it is referenced in the ‘Timetable’ CSV. 

  • Term Start/Finish: The start and end dates of term. This should be in YYYY-MM-DD format.

  • Term Start Day Number: Term Start Day Number is the day number of the timetable cycle that the first (start) date is, e.g. If the first date is a Tuesday and the timetable has only 5 days, then this would be set to 2. Alternatively, for a 10 day timetable, it could be day 2 or day 6 for the first date the timetable is active.

  • Period Day: This must be a number, e.g. Day 1 = 1.

  • Period Title: This can be labelled in any way you like. It is important to be consistent with whatever term you choose between uploads.

  • Period Start/Finish: You must set the start and finish times of the period, as this will work out which period to highlight on the timetable. This should be in HH:MM:SS format.

3. Save as a CSV and upload into the blue field.

4. Click 'Preview Import'. If you receive errors (the text will appear in red), read the error message and amend the CSV.

5. After you have checked the preview, click 'Run Import'. 

Importing the Timetable for Schools using the Schoolbox Data Store

The following instructions explain how to import class data into the Timetable Structure that you have already set up. 

This upload will create the timetable. Assigning the class code specified in the CSV to a class page will link that page into the timetable.

NOTE: To update the timetable, you must re-upload the timetable and then the enrolment data (using the CSV files). You must upload your data all in one go, as it does not append. Any existing data will be deleted.

1. Go to Administration > School Data Import >Timetable

2. Click 'Download Template', and fill in the details.

 Some things to note:

  • You must have first uploaded your Timetable Structure.
  • You must upload your entire timetable in one .csv - any existing timetable information will be deleted. Keep previous uploads for reference.
  • The values you enter for Term Campus, Term Title, Period Day and Period Title must exactly match a row in the timetable structure CSV that has been imported.
  • Any empty fields will be filled with the previous non-empty value in that column.
  • Title: this will show on the timetable. 
  • Classroom: the room code input here links to resource booking. 
  • Teacher code: this is the Schoolbox ID, not the Schoolbox User ID. This should match the 'External ID' input into the user import template.

3. Save as a CSV and upload into the blue field.

4. Click 'Preview Import'. If you receive errors (the text will appear in red), read the error message and amend the CSV.

5. After you have checked the preview, click 'Run Import'. 

Importing Enrolment for Schools using the Schoolbox Data Store

The Enrolment import sets the relationship between a student and a class code. This gives them access to the class page and also adds the class to their timetable. 

You can also assign additional teachers other than the one defined in the Timetable Import.

1. Go to Administration >School Data Import > Enrolment

2. Click 'Download Template' and fill in the details. 

 Some things to note:

  • Class details will not show in the timetable unless a class page with a matching code has been created.
  • The class code specified in the ‘Enrolment’ CSV must match with the code specified in the ‘Timetable’ CSV.
  • Student code: this is the Schoolbox ID, not the Schoolbox User ID. This should match the 'External ID' input into the user import template.

3. Save as a CSV and upload into the blue field.

4. Click 'Preview Import'. If you receive errors (the text will appear in red), read the error message and amend the CSV.

5. After you have checked the preview, click 'Run Import'.