The Roster Sheet is one of four ways a Roster can be created within Discover.
This view option allows Administrators to view all staff and hours at a daily level.

How to navigate the Roster Sheet:

1. Day/Date selector: By default, the current week will be displayed, and any day can be clicked on to view the roster. Alternatively, using the calendar icon, admins can easily navigate to a particular day outside of the current week to add/edit/update or view the roster. 

2. Group View Selector: This option enables administrators the ability to view the roster for a particular room/group of staff. Please note these staff will need to be assigned to the group through their staff profile.

3. Roster Menu

	Add Staff Members: By selecting this menu option, admins will be able to add additional team members to their roster enabling them to add tasks for that particular day/date. Click the blue + next to a staff members name to add them.
	Mark as Public Holiday: By selecting this menu item, admins are able to mark all staff as being on a Public Holiday. Please note: Once implemented, this action cannot be reversed.
	Full Screen Mode: This menu option will move the roster to consume the full screen of the device the administrator is using.
	Column View: This menu item allows the administrator to toggle between a large or small column view for their roster. Small: Large:
	Rostered Teachers: Toggling this feature on, administrators will be able to see if they have met the required number of teachers on the roster. Green is meeting, Red is not meeting. Required Teachers: Shows the number of Registered teachers required and rostered, vs any unregistered teachers rostered.
	Application of Rule 44A: Applies regulation 44A to this day, allowing you to use any spare teaching capacity in your under 2's to your total staffing in certain circumstances only.  Please see the ministry handbook for more information about when you can/can not apply this rule.
	Roster Locking / Unlocking: Locking/Unlocking the roster is a way for admins to control historic data to ensure no changes are accidentally made. Once the roster has been completed for a service and any amendments have been actioned within the system.  Please note: Rosters should only be locked for historic data only, not for any future dates. This mitigates any risk that rosters could be changed for any RS7 funding periods. The lock ensures the rostered times are saved. Clock in/out times entered on the tablet by staff will not adjust the locked times
	Roster Lock/Unlock Log: This menu item will enable administrators the ability to view a log of Lock State Changed By Changed On
	Times in Cell: This menu item enables admins to view the task times within the cells.
	Ratio Widget: This menu item enable the ratio widget to appear alongside the Roster Sheet.
	Reorder Roster: This menu item enables administrators to reorder the staff within the roster offering the opportunity to view their holistic roster in a way that is meaningful to them.

4. Registered Staff Percentage: This number will increase/decrease based on the percentage of registered staff teaching throughout the day and any discretionary hours applied (calculated at 10/15 min increments depending on roster settings).

5. Staff Members: This shows the names of the Staff Members rostered. Directly underneath their name, admins have a quick view of their qualifications.

Red: This team member has expired qualifications and requires to update or provide evidence to the admin team who can then update within the Discover platform.

Yellow: This staff member has qualifications that are due to expire soon. 

Blue: This team member is either unqualified or holds qualifications within Discover that are not expired or due to expire within the next 4weeks.

By selecting on the arrow directly underneath the Staff Members name, admins will have the following options:

6. Understanding the Ministry and Room Ratio Requirements: Admins can hover their mouse over each of the time increments to view ratio information. Colours will depend on their ratio, as per below:

Green - if your roster meets the Ministry and room ratio.

Orange - if your roster meets the Ministry ratio for funding purposes, but out of ratio in a particular room. *For Discover to be able to count how many staff are in a particular room you need to assign a specific room to specific tasks.

Red - if your roster meets the Ministry ratio and don't have enough staff at a given time.

7. Extend to Midnight: This will extend the roster view to midnight allowing for inputting of after hours tasks.

Add/Edit/Delete Shifts and Tasks

To assign tasks/ shifts, administrators will navigate as follows:

1. In the menu to the left hand side, select Staff Roster.
2. Navigating the menu across the top of the screen, select Roster Sheet.
3. Use the arrow drop down underneath the relevant staff member, corresponding to the time they will begin, and select a task.
4. Add in any breaks/task changes throughout the day as above.
5. After the last 10 or 15 minute time increment the staff member will be working, select 'Finish' from the drop down.

To Edit

An assigned task can be edited by selecting the arrow at the time they wish to change the shift type and select a new task from the dropdown. 

To Delete / Create Gaps

1. Click on the cell corresponding to the staff member and time the task is to be removed.
2. Tap 'Delete' on the keyboard or select the Blank option in the dropdown arrow.

Quick Tips

• While you can use the mouse for these screens, the spreadsheet options (quick entry and spreadsheet entry) are optimised for keyboard entry.  The entry fields that look like spreadsheets behave like spreadsheets and you can use the arrows to navigate around them, as well as control-c and control-v to copy and paste information from one cell to another. On an Apple device that might be apple-c and apple-v for copy and paste.
• As you type tasks and press enter (type the first few letters, you do not need to type the whole task name), Discover will fill the task automatically down until the end of the day (or until the 'Finished' task, whichever is found first).  You can type over this task at a given point in time to fill it down using another task.  Finally, you can press the delete key on your keyboard to delete a roster entry.
• Copy from Excel. You can also copy and paste data in from excel spreadsheets directly into Discover as long as you match the format and task names on the spreadsheet entry tab.