June 26, 2011
June 26, 2011
June 29, 2011
Design in Engineering Education
22.198.1 - 22.198.61
An Optimization Routine for Assigning Students to Capstone Project GroupsThe University of XXX includes a multidepartment, multidisciplinary capstone projectexperience in the curriculum. Projects in this course include those sponsored by industry, campusresearch laboratories, departmental administrators and governmental entities, as well as thosebenefiting service or charitable organizations. Students from mechanical, electrical and civilengineering and engineering technology programs, as well as systems engineering majors, arepooled to staff these projects. Student teams are selected by indicated student preference andrequired expertise as defined by the project description. For a small number of students, this taskis tractable using standard sorting routines available in typical spreadsheet software. When thenumber of students becomes large (n > 200), typical sorting tools struggle to provide a workablesolution. This work details a methodology for automating the staffing process for a large numberof students, using some common optimization tools.The optimization toolkit will be designed to run on open source spreadsheet software, with codeavailable as an appendix. Output from the optimization tool will also be compared an contrastedwith output generated by faculty using existing tools, with incorporation of experience withstudents who did not receive one of their top 3 project “picks”.
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2011 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015