Student timetable automation uipath

Help Studio
, ,
1

How can we automate the timetable of the students in the college and even allocate the students with their proper room no. without any repetition in the room nos.

2

Hey @V_Meenakshi_Iyer
Please read data of class schedule, student enrollment, and room information into DataTables, named eg. dtClassSchedule , dtStudents , and dtRooms

This LINQ query is a conceptual approach to filter classes based on student schedules.

Dim validClasses = From class In dtClassSchedule.AsEnumerable()
                   Where Not dtStudents.AsEnumerable().Any(Function(student) student("EnrolledClasses").ToString().Split(","c).Contains(class("ClassID").ToString()) AndAlso dtClassSchedule.AsEnumerable().Any(Function(otherClass) otherClass("ClassID").ToString() <> class("ClassID").ToString() AndAlso otherClass("TimeSlot").ToString() = class("TimeSlot").ToString() AndAlso student("EnrolledClasses").ToString().Split(","c).Contains(otherClass("ClassID").ToString())))
                   Select class

After filtering classes to avoid student schedule conflicts, allocate rooms ensuring no room is double-booked for the same time slot.

Dim roomAllocations = From class In validClasses.CopyToDataTable().AsEnumerable()
                      Group Join room In dtRooms.AsEnumerable()
                      On class("TimeSlot") Equals room("AvailableTimeSlot")
                      Into RoomGroup = Group
                      From room in RoomGroup.DefaultIfEmpty()
                      Select New With {.ClassID = class("ClassID"), .RoomNumber = room?("RoomNumber")}


Dim finalScheduleData = roomAllocations.Select(Function(allocation) New With {
    .ClassID = allocation.ClassID,
    .RoomNumber = If(allocation.RoomNumber IsNot Nothing, allocation.RoomNumber, "Not Allocated")
}).ToList()
3

I am unable to implement it we need to make the time table in these guidelines:
Class Time Table -
I have to make a project which automate making time table.I time table shoud be made for 13 sections of a college.A-E section will have morning class and F-M will be having1 a evening class.Now English and Language class should be together for all the section(if morning then A-E , evening then F-M) . When a Lab is happening there should be 2 faculty present .Overlapping of Faculty and classes should not be done.Input will be given by telling the subjects.Write the subject name in the time table.(For eg. OS,AL1 Lab,Lang).

Teacher Time Table-
Here I would get to know which teacher is going where and how many classes he is taking in a week.Every subject should have 4 faculty .Our program will allocate each faculty to diffrent sections.

Room Data-
A table which stores which room is empty,occupied or double occupied(Use colours to represent).Show which hour the room is free or empty.Room most probably will be arranged chronologically.For eg.room 101-105 will be alloted to A-E and in the evening room 101-108 will be alloted to F-M.

All the tables should be connected
If subejct is given as input than it should fill the class TT and Faculty TT and Room TT.

@ruchirmahajan

1 Like
4

Wow, you came up with this. There’s a lot of work here.

1 Like
6

Yeah, pretty much it was. But finally the project is completed and working great!!