04-11-2023, 04:35 PM
Hi Nasacow
briefing about your ideas, file database following your directives, interface for users.
fine to see that you like this development of your UDT and database in one file.
I found necessary to add UID fields into UDT structure for AssignmentMaster (UID) and AssignmentSlave (UIDm, UIDs).
following the demo image of PowerTeacher GradeBook (PowerTeacher GradeBook) to catch the kind of data to manage with this kind of application, I advice these fields must be added to your original UDT set of data: for grouping students in Class there is HouseColor (string * 8) in Student UDT and Acolor (unsigned Byte) in AssignmentMaster. This way need a good planification creating a code to store both string and unsigned byte.
Thinking about a class with max 24 students and a group of minimum 4 students (max 6 groups in a class), doubling the amount of data to manage with the purpuse to let future enlargment of stack of data to manage (max 48 students with max 12 groups in a class).
... for my level of knowledge about storing in one byte different information using math and bitdata I got an headache and no practical solution... so I prefer to modify Housecolor into a string and the same for Acolor so both student UDT and MasterAssignment UDT have the same field that shows which are the class and the group color.
The student UDT need add these fields: Gender, Grade Scale, Grade Level, Student email, Student phone
The MasterAssignment UDT need add these fields: Weight score, Extra Score, Total score = extra Score + (Possible Score * Weight Score), date of assignment, description, IncludeInFinalGrade.
Moreover we need another UDT for class with these fields: Course name, Term, Start date, End date, Course number, Section Number, Periods/Days, Grade Scale, Room, Custom display, Description.
The interface for user can be developed into TUI or GUI. We need a window, some listbox, panels, button menu .
Well, after these developments , we must thinking about Reports.
briefing about your ideas, file database following your directives, interface for users.
fine to see that you like this development of your UDT and database in one file.
I found necessary to add UID fields into UDT structure for AssignmentMaster (UID) and AssignmentSlave (UIDm, UIDs).
following the demo image of PowerTeacher GradeBook (PowerTeacher GradeBook) to catch the kind of data to manage with this kind of application, I advice these fields must be added to your original UDT set of data: for grouping students in Class there is HouseColor (string * 8) in Student UDT and Acolor (unsigned Byte) in AssignmentMaster. This way need a good planification creating a code to store both string and unsigned byte.
Thinking about a class with max 24 students and a group of minimum 4 students (max 6 groups in a class), doubling the amount of data to manage with the purpuse to let future enlargment of stack of data to manage (max 48 students with max 12 groups in a class).
... for my level of knowledge about storing in one byte different information using math and bitdata I got an headache and no practical solution... so I prefer to modify Housecolor into a string and the same for Acolor so both student UDT and MasterAssignment UDT have the same field that shows which are the class and the group color.
The student UDT need add these fields: Gender, Grade Scale, Grade Level, Student email, Student phone
The MasterAssignment UDT need add these fields: Weight score, Extra Score, Total score = extra Score + (Possible Score * Weight Score), date of assignment, description, IncludeInFinalGrade.
Moreover we need another UDT for class with these fields: Course name, Term, Start date, End date, Course number, Section Number, Periods/Days, Grade Scale, Room, Custom display, Description.
The interface for user can be developed into TUI or GUI. We need a window, some listbox, panels, button menu .
Well, after these developments , we must thinking about Reports.