12/16/2023 0 Comments Google forms lab scheduler![]() ![]() There are then parameters you can adjust. When you first load the schedule, it will pause for perhaps a minute while it starts creating schedules – this is normal. It will ask you to upload the XLSX file downloaded from Google Forms or created in Excel. There is an R shiny app here that runs the scheduling program. The only valid entries in the cells are exactly Not possible, Unwelcome but feasible, Feasible, Preferred, and Ideal. Getting started: Excel file approachĪlternatively, you can download this Excel file and fill it in yourself. It’d be possible to make this more flexible, but this was all written on Sept. 24-25 to get it working quickly, and so it doesn’t have all the features one might want. Do not change any of the time fields – the exact wording must be correct for the scheduling software to work. xlsx file as people fill it in and run it in the interactive scheduler tool. In the form edit window, click the Responses tab and click the green spreadsheet icon to create a spreadsheet. Go to this link:Īnd it will ask you to copy it to your Google account. The easiest way to use this program is to copy our Google form. ![]() The output spreadsheet has the raw scores for many measures, and schedulers should use these and human judgements: the “best” schedule from this program might be terrible albeit feasible. There are other criteria, too: is there a schedule that has fewer class time conflicts, can instructors avoid unwelcome assignments, are classes well distributed between MWF and TR, etc. Possible schedules are scored by the percentage of classes that had positive student responses in that schedule as well as by the percentage of classes that had instructors with a “Preferred” or “Ideal” time option. The form for instructors has time options of Not possible, Unwelcome but feasible, Feasible, Preferred, and Ideal. Average scores for each time could range from -2 to 2. Students were asked: “I would want to enroll in a class offered at this time” for each time possible answers were Strongly disagree, Disagree, Neutral, Agree, or Strongly agree. EEB did a survey of students to assess their preferences for times outside the “prime” class times of 9 am - 2 pm. However, there are other measures built in that can be used. This first pass tries to minimize the number of schedule changes from last spring while still hitting the university’s criteria for prime time courses. These schedules are ranked and the best ones saved to an Excel file again, with one sheet per potential schedule. This is then parsed by a program (written in R) to compute multiple possible schedules. This is most easily created with a Google form, then exported. Its input is an Excel file (.xlsx format) with columns for instructor names, various times, and more (preferences for each instructor are in a row). ![]() Our hope is that this helps achieve the overall names of balancing room use and student preferences while making sure that instructors have schedules that work for them. I made a tool for our department to schedule classes for the upcoming semester others may use it, too. Scheduling classes can be difficult given limited room availability and various schedule conflicts and constraints. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |