Application for scheduling students?

[Arnold]

I'm emailing to inquire how a VBA-based application be maybe be made in
Excel or Access that helps to schedule students in classes. For
example, the app should allow the following:

Inputting and removing students.
Inputting and removing classes/teachers.
Assigning students to classes, based on 6 classes per day (quarter
system).
Notification of class conflicts if students are omitted or scheduled
multiple times, or class sizes become too large.
Reporting of class schedules per hour and grade.

Additional features that would be handy:
Track the classes that students had been in previously (in data tables
or other sheets).
Drag & drop of student names into class slots.

This would be for a very small school, with 150 students max and 15-20
classrooms, 15-20 teachers.

Online, I've seen several apps that have this functionality, but no
templates in Excel or Access. Thanks for any advice/assistance.

Arnold

 

[N10]

Hi Arnold

My view is that you should spend a little time exploring the Access
database creation wizard. In relation to your goal I think it would be
relatively easy to create something workable in a very short time.

The alternate of coding your requirments in Excel would require some
learning on your part so that you could create the required product. Such
a project would be relatively complex but not beyond the skill of a keen
learner. I have been studying VBA for Ecell for about a year and I guess it
would take me about one to two weeks of concerted coding and testing to
arrive at a working beta version.

I wish you luck

Best N10