Dynamics 365 education accelerator – K-12

The K-12 component in the Microsoft Dynamics 365 education accelerator sits on top of an existing Dynamics 365 instance or Microsoft Power Apps instance to assist with day-to-day operations, or as a standalone data model for developers to build custom applications. The student profile, educator, and community engagement scenario contains the data model and installable scenarios.

The data model

The Microsoft Dynamics 365 education accelerator comes with an industry data model that can be used across the Microsoft Dataverse and Microsoft technology stack. The data model is a combination of extensions to native entities and custom entities to track student, school, staff, and faculty data elements. These data elements can be extended to build industry leading applications on the low-code or no-code Microsoft Power Platform. The K-12 data model is also available as a stand-alone model that ISV and SI partners can utilize.

Installable scenarios

Feature	Description
Standard entity attribute extensions	Extensions to Dataverse tables that are used in Dynamics 365 Customer Sales and Dynamics 365 Customer Service scenarios. Examples include: Contact, Account, Activities and Address. These extensions allow partners and customers to use the native capabilities of Microsoft Power Platform, Dynamics 365, and other products such as Microsoft Power Apps portals and Dynamics 365 Marketing (licensing required).
Specific education entities for K-12	Industry-specific data tables have been added as extensions to Dataverse. These extensions provide a strong schema foundation for customers who want to build industry leading solutions on Microsoft Power Platform. Customers and partners can easily extend K-12 Dataverse tables to enable more value-add scenarios for institutions.
Sample data	Each application has optional sample data. This data helps customers and partners better understand the schema. Customers can choose to install the sample data at any time. Sample data includes records across both custom tables and extended Dataverse tables.
Prebuilt dashboards and portals	Gain a better understanding of your students, staff, and other related data sources. The education accelerator ships with a set of templates for both native Dynamics 365 dashboards and Microsoft Power BI templates. Customers can use these templates upon installation to view sample data and to extend these reports to meet more extensive reporting requirements.

Enhance student engagement

Engage your students with intuitive applications for faculty and staff. Set up a student and parent access portal for better communication and engage donors to help raise funds for your school.

Scenario	Target audience	Description
K-12 parent and student portal	Parents and students	View student information related to: school registrations, activities, attendance, achievements, coursework, learning standards, incidents and interventions. Parents and students can access this information from a responsive website built on Microsoft Power Apps portals.
Collect school paperwork and forms	Faculty and staff	Use Microsoft Power Platform to extend applications that automate the collection of paperwork and forms related to application processes. Digitally transform your application and application process.
School management	Faculty and staff	Interact with custom schema that aligns to industry standards for managing school operations. Use the model-driven application to manage school calendars, bell schedules, learning accommodations, and teacher certification and licenses.
Ability to engage donors and raise funds	Staff	Interact with custom schema that aligns to industry standards for managing donors and donations. Use the model-driven application to gain a better understanding of donors. Customers can use the industry-leading marketing and customer relationship management (CRM) features of Microsoft Power Platform and Dynamics 365 to bring in donations and increase donor communication.
Student Behavior Management application	Faculty and staff	Administrators can easily record, track, and encourage positive behavior from students through a Power Apps application built on canvas apps.
Track and Report Attendance application and dashboard	Faculty and staff	Educators can easily track and report attendance in the attendance application. For ease of access, this application can also be modified for use on a tablet or phone.

Site map extensions

With the K-12 component, schools can optimize student success through understanding data about the student journey. When the accelerator is installed, the experience is transformed into one built for K-12 schools and one that allows schools to quickly build Power Apps applications and Power BI visualizations.

Entities and workflows

This accelerator provides core entities for education and also K-12 entities to support the needs of K-12 schools.

Education core entities

• Academic Period
• Academic Period Detail
• Academic Subject
• Accomplishment
• Achievements
• Area of Interest
• Area of Study
• Bell Schedule
• Bell Schedule Time
• Certification
• Certification Process
• Certification Requirement
• Course
• Course History

• Course Section
• Credential
• Education Level
• External System
• External System Identifier
• Extra Curricular Activity
• Extra Curricular Participant
• Internship
• Internship Applicant
• Previous Education
• Program
• Program Level
• Program Requirement
• Program Version

• Program Version Detail
• Recommended Student Resource
• Registration Status
• Scholarship
• Scholarship Applicant
• School Calendar
• School Calendar Date
• Student Program Type
• Student Resource
• Student Status
• Test Score
• Test Type

K-12 entities

• Assessment
• Assessment Delivery
• Assessment Item
• Assessment Score
• Attendance

• Behavior Incident
• Education Content
• Grading Period
• Incident Action
• Incident Type

• Intervention
• Intervention Participant
• Learned Standard
• Learning Standard Criteria
• Student Assessment Item Response

Connections

To gain a better view of the student and to maintain information of interest to the parents, guardians, faculty, and staff who are connected to the student, the education accelerator has extended the Dataverse Connections feature that enables a dynamic yet flexible data model that can enrich student information.

Below are the connections that are implemented in the education accelerator.

Connections for account

• Adjunct
• Administrator
• Advisor
• Affiliate
• Aide
• Alumni
• Assistant
• Chair
• Coach
• Doctor
• Extraprofessional
• Faculty

• Guardian
• Instructor
• IT Admin
• Lecturer
• Nurse
• Occupational Therapist
• Office Staff
• Other
• Parent
• Physical Therapist
• Principal
• Proctor

• Professor
• Relative
• Researcher
• Special Services
• Speech
• Staff
• Student
• Substitute
• Teacher
• Teacher Assistant
• Vision

Connections for contact

• Administrator
• Advisor
• Aide

• Child
• Doctor
• Guardian

• Other
• Parent
• Relative

Connections for courses and course sections

• Adjunct
• Administrator
• Advisor
• Affiliate
• Aide
• Assistant
• Course
• Coach

• Instructor
• Lecturer
• Occupational Therapist
• Paraprofessional
• Physical Therapist
• Principal
• Proctor
• Professor

• Special Services
• Speech
• Staff
• Student
• Substitute
• Teacher
• Teacher Assistant

Forms, dashboards, and apps

To better understand and use the available forms, dashboards, and apps in this scenario, let’s look at it through the personas of a parent, an administrator, and an educator.

Parent and student portal

The K-12 Parent Student portal allows both the parent and student access to the student’s information. From attendance to grades, it facilitates clear conversations about progress made by students with the parents and guardians who support their students.

Here, students can see all their assignments and progress made with each, and focus on a particular subject to see only those assignments.

Students can easily check assignments, grades, and test scores.

They can also check other important details like attendance.

They can explore extracurricular activities offered at their schools.

Parents can view the school calendar.

Parents can also easily view the course history for the student, including both current and previous courses.

Model-driven app

Administrators have a complete view of attendance, courses, internships, accomplishments, extracurricular activities, interventions, assessments, and behavior incidents. This information enables them to make data-driven decisions about how to support students.

Administrators can also view teachers' certification and credential status and track their progress towards completing new certifications.

Donor management app

Administrators use the Donor management app to view and manage donors and update them on how the school is using their donations.

Administrators can also get a clear view of donation designations.

Student behavior management app

Administrators can easily record, track, and encourage positive behavior from students in the Student Behavior Management app.

They can also better understand details on how students earned recognition for positive behaviors in class.

Track and report attendance app

Educators can easily track and report attendance in the Track and Report Attendance application. For ease of access, this application can also be modified to use on a tablet or phone.

Attendance Power BI dashboard

The Attendance Power BI report dashboard allows educators to easily view and take action on attendance data.

Additional resources

• Download the Dynamics 365 education accelerator from AppSource.

• Read our K-12 blog post from Dynamics 365 blogs

• The K-12 data model, solutions, data samples, Power BI examples, SDK extensions, and more are provided as part of the open-source creative license available on GitHub

• Continue your accelerator experience and engage with experts and peers, read blog articles, and find local events within the industry accelerator community: Join us.

Connect and share feedback

Do you have feedback or need support? Contact us at dynindaccsupport@microsoft.com.