Constellation

System-wide
- Authentication
  - Add authentication support for student users
- Students
  - Update Student model to new aggregate style including new ID property
  - Allow for students to be entered without SRN or Email Address
  - Allow students to not have active grades or schools
  - Move student photos storage to Attachments models
Automation
- Attendance Notifications
  - Update SMS template to parents to use new static short link instead of url shortener
- External Connections
  - Update SchoolRegisterJob to use new data.nsw sources and file layouts
  - Update AttachmentManagementJob to remove expired attachments as required
  - Update filtering options on CanvasGateway to ensure that all current courses are returned
  - Update Sentral Gateway to use API for syncing Parent Contact details
Staff Portal
- Dashboard
  - Update dashboard widgets to have sticky positioning
  - Update Auth dashboard to include student users
- Assignments
  - Assignments list now include future assignments
- Award Nominations
  - Update to reject duplicate nominations as they are entered
  - Expand reporting options for award nominations, including grouping options by school, by student, and by subject
- Group Tutorials
  - Add ability to bulk enrol students
- Science Pracs
  - Update to allow for bulk cancel of Rolls
  - Allow addition of custom comments when cancelling Rolls
  - Add report for Rolls submitted without students marked present
- Third Party Consent
  - Added ability to set applications as required for a course, grade, or individual student
  - Updated reports to show status of consent for each student for each application
- Workflows
  - Include a "For Me" filter to show only currently assigned cases for Head Teachers
  - Fix a bug where Compliance cases could be mistakenly detected as Attendance cases
Schools Portal
- Dashboard
  - Fix bug preventing student photos from being displayed properly
- Attendance
  - Update Attendance Report button to actually generate report
Parents Portal
- Third Party Consent
  - Added section to display third party consent details
  - Added form for parents to respond to third party consent requests
  - Added banner on dashboard to indicate if there are outstanding third party consent requests
Students Portal
- Attendance
  - Add attendance section where students can view all attendance data
  - Add ability for students to submit explanations for Partial Absences
- Awards
  - Add awards section where students can view award tallies and recent awards
- Support
  - Add support section outlining where to obtain help from the school
  - Add submission form for Technology Support team that is routed to the helpdesk
- Timetables
  - Add ability for students to view and download timetables

System-wide
- Authentication
  - Updated login page to handle all three user types: Staff, Partner School Staff, and Parents
  - Include extensibility options for students
  - Modify flow to ask for email address first, then determine next steps based on detected user
  - Include extensibility options for SSO
Constellation Web
- Layout
  - Updated name to Constellation Staff Portal
  - Added sidebar navigation links to all pages
  - Added /Staff url segment to separate pages from other sections
- Compliance section
  - Updated N-Award compliance scan to retrieve full incident type (e.g. 4th Warning)
- Mandatory Training section
  - Removed Roles
  - Added ability to link staff directly with Modules
- WorkFlows section
  - Added a Compliance case type for N-Award and LoC tracking
  - Added SentralComplianceScanJob to check for overdue N-Award and LoC incidents
  - Added SentralIncidentStatusAction to request update of attached Incident
  - Added a Training case type for Mandatory Training tracking
  - Updated the MandatoryTrainingScanJob to create WorkFlow cases instead of sending emails
  - Added UploadTrainingCertificateAction to request files be uploaded to Constellation
- Assets section
  - Added new Assets section to track all school assets
  - Moved old Devices data to read-only archive section
  - Fixed bug in the Assets export file where the autofilter was not being applied to the last column
  - Fixed bug in the Allocation view where Community allocated items would throw an error
Schools Portal
- System-wide
  - Converted project to Razor Pages in preparation for SSO integration
  - Updated loading spinner
- Science Rolls section
  - Fixed a bug that prevented users from editing Science Rolls that had already been submitted
Parent Portal
- System-wide
  - Converted project to Razor Pages in preparation for SSO integration
  - Updated loading spinner
- Absences section
  - Provided non-residential parents the opportunity to supply an explanation for whole absences. The explanation is not registered immediately, but sent to the school admin office for manual checking and entry

Constellation Web
- Absences section
  - Fix bug that prevented the SentAt field from being populated for Absence Notifications
- Class Covers section
  - Removed list of outstanding Adobe Connect operations
- Contacts section
  - Include the School details in the Export file
- Group Tutorials section
  - Updated export file to include a legend of the colours and symbols used in the list
- Mandatory Training section
  - Update Training area to include Roles
  - Add master/overall details export for Training area
- School Contacts section
  - Refactor School Contacts and Roles to aggregate design pattern
  - Enable domain events to track and process changes in School Contact entities
  - Add ability to include a note when assigning a role to a School Contact
  - Create Report export for Partner Schools with all related Contacts
- Science Pracs section
  - Add Reports pages to filter rolls by school or student
  - Add Overdue Report which allows staff to download an Excel file with all outstanding/overdue rolls
- Third Party Consent section
  - Added Third Party Consent section
  - Added ability to add applications
  - Added ability to disable applications from active list
  - Added ability for school administration staff to manually add consent responses from parents
  - Added report for listing consent status by class, grade, and school
- WorkFlows section
  - Added WorkFlow section
  - Added Attendance Case details
  - Added Actions for Send Email, Create Sentral Entry, Confirm Sentral Entry, Phone Parent, Parent Intervew, and Update Case
  - Added Report export for open existing Cases
Constellation Infrastructure
- Jobs (Recurring scheduled tasks)
  - Update Family Details Sync job to remove any orphaned Families during a scan
  - Fixed a bug in the Family Details Sync job that reported a family email address changed when it had not
- Canvas Gateway
  - Add ability to audit Course access and normalise based on computed access list
  - Add ability to create and manage Course Groups
  - Add ability to create and manage Course Sections
Parents Portal
- System-wide
  - Provide status feedback to users when an action fails for any reason
- Absences section
  - Fixed a bug that did not show validation errors to users when attempting to explain an absence
Schools Portal
- System-wide
  - Provide status feedback to users when an action fails for any reason
- Science Pracs section
  - Update roll submission to prevent users from setting a future date for the roll
  - Update roll submission to require a comment if none of the students are present

Constellation Web
- School Admin section
  - Add new Compliance area
  - Add Attendance statistics tracking to Compliance area
  - Add report export for Attendance statistics used by Executive staff
  - Add Wellbeing Incident status tracking to Compliance area

Constellation Web
- Subjects section
  - Refactor Course, and Offering models to use Aggregate design pattern
  - Consolidate Subject pages into new layout
  - Update Assignments to prevent automatic upload to Canvas by default
  - Create daily scan for Assignment Submissions to upload to Canvas
  - Provide option for teachers to download latest submission for each student in bulk
Schools Portal
- Exam Uploads
  - Provide feedback to users when the file selected for upload is too large
  - Provide feedback to users when the file failed to upload successfully
  - Provide an upload receipt to users via email when a file has been successfully uploaded

Parents Portal
- Contacts section
  - Updated Contacts section to include current Counsellors details
Constellation Web
- Absences section
  - Refactor Absences models to use Aggregate design pattern
  - Allow enabling and disabling Absence scanning per type per student
  - Remove missed work section
- Science Pracs section
  - Refactor Science Prac models to use Aggregate design pattern
  - Consolidate coordinator pages for Science Pracs into School Admin area
  - Update Lesson reminder emails to escalate based on number of previous emails sent rather than how overdue the roll is
- Awards section
  - Add button to allow Awards administrator to force resync of awards data from Sentral
  - Add award nomination section for special end-of-year awards
Constellation Infrastructure
- Jobs (Recurring scheduled tasks)
  - Update the Roll Marking Report job to ignore teacher where multiple are included in the scan, and instead pull the teacher from the database

Parents Portal
- Awards section
  - Some awards now include details on which teacher issued the award, and why it was awarded.
  - Some awards now include the option to download a copy of the certificate.
Schools Portal
- Awards section
  - Some awards now include details on which teacher issued the award, and why it was awarded.
  - Some awards now include the option to download a copy of the certificate.
Constellation Web
- School Admin section
  - Awards listings, leaderboard, and graphs have been moved to the School Admin section.
  - Astra awards are checked for the ability to download the certificate.
  - Awards with certificates issued in the last two days of detection now trigger an email to parents with the certificate attached.
  - Some awards now include details on which teacher issued the award, and why it was awarded.
  - Some awards now include the option to download a copy of the certificate.

Constellation Web
- Partners Section
  - Add Absence Settings Audit report to student view to check whether absence scanning is enabled for students
  - Refactor student reports to use aggregate design pattern
- ShortTerm section
  - Refactor class covers to use aggregate design pattern
  - Redesign new class cover page to make selecting covered classes more intuitive
  - Refactor casuals to use aggregate design pattern
- Subjects Section
  - Update assignments to use aggregate design pattern
  - Refactor uploading of assignment submissions to Canvas into outbox processor
  - Add options for staff to upload and download student submissions from the assignment details view
- School Admin section
  - Update Completions list to only include current staff members for editors
Schools Portal
- Absences section
- Contacts section
  - Add notification email to school administration when new contact is registered
  - Update welcome email sent to new registrations to include link to the Partner School Resources page on the school website
- Exam Uploads section
  - Refactor submission to Canvas to outbox processor to ensure that file is sent through even if the gateway is unavailable
- Reports section
  - New reports are automatically emailed to registered non-residential parents
Parents Portal
- Access
  - Verify current user has authorisation to access student data before displaying
Constellation Infrastructure
- Jobs (Recurring scheduled tasks)
  - Update the Sentral Family Sync Job to send report of any detected changes to the school administration
  - Update the Sentral Report Sync Job to use new aggregate design model

Constellation Web
- Group Tutorials section
  - Create Group Tutorials section
  - View and create Group Tutorial classes
  - Add and remove students and teachers to Group Tutorials
  - Automatically provision access to Microsoft Teams resources as users are added and removed
  - Include ability to submit rolls for a tutorial session
  - Allow reports to be run per Group Tutorial
- Admin Dashboard section
  - Create user dashboard that allows Admin users to manage user accounts
  - View user claims and roles
  - View and edit Role membership
- Partners/School Contacts section
  - Add repair user account option for admin staff
- Partners/Staff section
  - Fix display issue with staff faculty memberships on details page
Schools Portal
- Access
  - Refactor application to allow use from non-DoE networks

Constellation Web
- School Admin section
  - Added new Mandatory Training section
  - Added ability to create training modules for staff to complete
  - Added ability to create completion records for modules and upload certificates
  - Added report by module on completion records

Parent Portal
- Attendance section
  - Added new Attendance section
  - Added ability to generate and download Attendance Reports for current year
  - Added ability to view all absence data
  - Added ability to provide explanations for whole absences
- Awards section
  - Added new Awards section
  - Added ability to view awards tally per student
  - Added ability to see summary of last 10 awards issued to student
  - Added ability to change which student data is displayed for
- Reports section
  - Added new Reports section
  - Added ability to list academic reports issued to a student
  - Added ability to download academic reports for current student
  - Added ability to change which student data is displayed for
- Timetable section
  - Added new Timetables section
  - Added ability to view timetable per day per student
  - Added ability to download full timetable per student
  - Added ability to change which student data is displayed for
- Contacts section
  - Added new Contacts section
  - Added static entries for Administration Office and Technology Support
  - Added dynamic entries for Support staff (e.g. LaST, Counsellor, Careers Advisor, Librarian)
  - Added dynamic entries for Classroom Teachers based on selected student
  - Added ability to change which student data is displayed for
- Login page
  - Added login for parent users
  - Added magic link login method

Schools Portal
- School Contacts section
  - Added new School Contacts section
  - Added ability to view who the ACCs and SPTs are for your school
  - Added the ability to add new ACCs and SPTs if required
  - Added the ability to request an existing ACC or SPT is removed
- Science Rolls section
  - Added the ability to edit submitted rolls for up to 14 days
Constellation Web
- Lessons Portal section
  - Moved Lessons Portal pages to top nav to make them easier to find
  - Redesigned Lessons Portal pages to act like regular Constellation Web pages
Constellation Infrastructure
- Email Templates
  - Added new notification sent to School Contacts when they are created to welcome them to the school
  - Added new notification sent to students after they are marked present at a Science Prac lesson reminding them to submit their work on Stile

Schools Portal
- Awards section
  - Added new Awards section
  - Added ability to view student awards tally
  - Added ability to view recent student awards
- Stocktake section
  - Added new Stocktake section
  - Added ability to review stocktake event settings
  - Added ability to submit stocktake device sightings
  - Added ability to cancel stocktake sightings with incorrect details
Constellation Web
- Partners/Students section
  - Fixed bug that was causing the student details view to take multiple minutes to load
- Partners/School Contacts section
  - Added option to add contact to role from the contacts list
  - Added option to add contact to role from new contact screen
- Subject/Assignments section
  - Added details view for assignment definitions
  - Added ability for teachers to re-push submissions to Canvas
- Equipment section
  - Added new Stocktake section
  - Added ability for Equipment Editors to create Stocktake events
  - Added ability to review stocktake sightings submitted for a stocktake event
  - Added Staff Dashboard to allow staff to review their own submitted stocktake data
  - Added ability for staff to submit stocktake device sightings
- Reports section
  - Update Awards report to use local awards details rather than relying on uploaded extract from Sentral
  - Create new Awards views including graph dashboard
Constellation Infrastructure
- Jobs (Recurring scheduled tasks)
  - Create new SentralAwardSyncJob to sync details of student awards from Sentral to Constellation

Schools Portal
- Timetables section
  - Add ability to view student timetables
  - Add ability to download student timetables
Constellation Web
- ShortTerm/Covers section
  - Change singe-day cover notification emails to be calendar invites
  - Include a PDF timetable on multi-day cover notification emails
Constellation Infrastructure
- Jobs (Recurring scheduled tasks)
  - Change source for the SentralFamilyDetailsSyncJob to take advantage of 3PI data and to be more reliable

Constellation Web
- Log In
  - Added validation rules to highlight incorrect email addresses as they are entered
- Partners/Students section
  - Send notification to School Administration if a parent email address is detected missing
  - Absence explanations found in Sentral are now created as Responses instead of using custom top-level attributes
  - Missed classwork notifications are now removed when the student is marked as withdrawn
  - Lesson rolls are updated when a student has transferred between partner schools
- Partners/SchoolContacts section
  - Duplicate entries are removed when performing a custom search
- Portals/Lessons section
  - Admin lesson search now correctly displays the grade in the course name field
- Reports section
  - FTE Calculation report now includes breakdown by gender per grade
Constellation Infrastructure
- Jobs (Recurring scheduled tasks)
  - Limit jobs to one concurrent instance at a time to prevent a job being started mulitple times
  - Add log information for all lifecycle events for jobs
  - Add graceful cancellation paths for all jobs
  - Confirm photos are different from current copy before downloading in SentralPhotoSyncJob

Schools Portal
- Home section
  - Log in using DoE credentials (e.g email address and portal password)
  - View all currently active students registered from the school
  - If linked to multiple schools, change the currently selected school
- Absence section
  - View pending partial absences awaiting explanation from students
  - View and action pending partial absences awaiting verification from ACC
  - View and action pending whole absences awaiting explanation from parents or ACC
  - Generate and download Attendance Reports per student for a specific cycle
- Science Rolls section
  - View and submit attendance rolls for Partner School lead Science Practical Lessons
- Reports section
  - List and download reports published by Aurora College for students
- Exam Uploads section
  - Upload paper based exams undertaken by students for marking
Constellation Web
- Partners/Students section
  - Student family details, including parent mobile and email contacts, now synced from Sentral
- Partners/Staff section
  - Fixed bug where staff faculty membership would not be saved
- Partners/Schools section
  - Created mapping pages for standard categories (All, Stage 3, Stage 4 & 5, Stage 6, Staff)
- Subjects/Assignments section
  - Sync assignment details from Canvas, allowing ACCs to upload paper based exams
- ShortTerm/Covers section
  - Fix bugs that prevented covers from being edited or cancelled
- Log In
  - Redirect Partner Schools to School Portal when they attempt to log in to the Staff area
- Error page
  - Redesign page to include error details where possible
- Changelog
  - Added this Changelog page
Constellation Infrastructure
- Persistence (Database)
  - Included ability to store documents (pdf, jpg) in database
- Gateways
  - Canvas gateway is now able to retrive details of assignments, and submit assignments on behalf of students
  - Sentral gateway is now able to retrieve supplementary student data such as photo, reports, family contact details
- Jobs (Recurring scheduled tasks)
  - Created job to sync Student Photos from Sentral
  - Created job to sync Student Reports from Sentral
  - Created job to sync contact (Student, Staff, School) details to TrackIt
  - Bug fixes to the Absence Monitor job
- APIs
  - Migrated endpoints from ACOS to allow for school bandwidth graphs to be downloaded each day
- Email Templates
  - Converted templates to use embedded BASE64 image for school logo instead of linking to the website
  - All email templates now automatically remove duplicate email addresses before sending
  - Updated cover email templates to remove mention of Adobe Connect and provide link to individual class Teams
- Operations
  - MS Team operations now use Group ID directly to prevent delay in processing due to searching for Team
- Admin Integrations
  - Adobe Connect Admin tasks migrated from ACOS

Constellation Changelog

Current version: Release V1.16.1 (Build 2412.10)

Previous version: Release V1.15.1 (Build 2409.25)

Previous version: Release V1.14.4 (Build 2406.20)

Previous version: Release V1.13 (Build 2312.01)

Previous version: Release V1.12 (Build 2311.14)

Previous version: Release V1.11 (Build 2309.12)

Previous version: Release V1.10 (Build 2307.20)

Previous version: Release V1.9 (Build 2304.29)

Previous version: Release V1.8 (Build 2303.11)

Previous version: Release V1.7 (Build 2301.17)

Previous version: Release V1.6 (Build 2210.24)

Previous version: Release V1.5 (Build 2209.6)

Previous version: Release V1.4 (Build 2208.15)

Previous version: Release V1.3 (Build 2206.17)

Previous version: Release V1.2 (Build 2205.30)

Previous version: Release V1.1 (Build 2205.2)