Students

IDFirstNameLastNameGradeLevel
1JohnDoe10
2JaneSmith9
3EmilyBrown8
4MichaelJohnson12
5SarahWhite7

Teachers

IDFirstNameLastNameSubjectTaught
1Mr.SmithMath
2Ms.WilliamsEnglish
3Dr.HarrisHistory
4Mrs.DavisScience
5Mr.MartinezArt

Classrooms

IDRoomNumberBuildingCapacity
1101Main30
2201Annex25
3301Main35
4401Annex20
5501Library60

Textbooks_Supplies_Projects

IDTextbookTitleSupplyItemProjectDescription
1To Kill a MockingbirdPoster paperCreate a poster about the novel
2The Great GatsbyPencilsWrite a short story inspired by the book
3A Wrinkle in TimeMarkersDraw a map from the book
4Romeo and JulietGlue sticksMake a collage about the play
5Of Mice and MenIndex cardsCreate flashcards to memorize quotes

Assignments

IDTitleDescriptionDueDateMaxPoints
1Vocabulary QuizTest your knowledge of vocabulary words learned this week2023-03-1550
2Research PaperWrite a research paper on a topic related to our current textbook2023-04-10100
3Creative WritingWrite a short story based on a scene from a textbook2023-03-2580
4Group PresentationPresent a group project on a topic related to the unit2023-04-15100
5Final ExamReview all material covered during the unit2023-04-20100

Grades

IDStudentIDAssignmentIDScoreFeedback
(→ Students.ID)(→ Assignments.ID)
11145Good effort but needs improvement
22160Great job! Keep up the good work
33175Excellent work! Very well done
44185Outstanding performance! Well done
55190Exceptional work! You excelled at this assignment