none
Suggestion for list creation for school report card RRS feed

  • Question

  • Hi,

    I am trying to create a report card for a school using a custom list.

    The students can take different subjects based on their interest.

    Example: student1 - subjects selected: Maths, Physics, Chemistry

    student2 - subjects selected: Biology, Physics, Chemistry

    The school conducts exams monthly and want to to update the scores  and then provide the Total score every month. The score and total score should be updated after each month.

    The school will only enter the marks for each object every month, this should in turn update the marks for the students.

    How should the various lists be defined to handle this scenario? I can only use JSOM model.

    Thanks

    Wednesday, May 3, 2017 1:59 PM

All replies

  • Hi,

    The following list design for your reference:

    Student List: StudentId, Name, Grade, SchoolYear

    Subject List: SubjectId, Name, Grade, SchoolYear

    Exam List: ExamId, Name, SubjectId

    ExamResult List: ExamResultId, ExamId, StudentId, Marks

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, May 5, 2017 9:33 AM
    Moderator