Jack, H., “A Web Based Approach to Senior Project Management”, ASEE Annual Conference, Austin, TX, June 14-17, 2009.
At Grand Valley State University undergraduate senior projects are done for companies using multidisciplinary groups of students. The projects include the design, fabrication, testing and delivery of i) production equipment, ii) test equipment, or iii) new product designs. The course runs over two semesters. During the first semester the students develop a detailed design proposal that is presented to the corporate sponsor. In the second semester students order and build components, do testing and debugging, and prepare for final delivery. At all stages the project sponsor is required to approve the project before it moves forward. Great care is taken to ensure that the projects meet all appropriate engineering and industrial standards at the proposal and final delivery phases. To this end the projects are overseen by faculty using common project management tools such as Gantt charts, budgets, proposals, and progress reports. Progress of the teams is reviewed on a weekly basis at a set common time by face-to-face meetings and with progress reports. Naturally coordinating and tracking the dozen or so teams of four to six students requires effort.
The common industrial approach to this problem is to use groupware from companies such as Novell, IBM, and Microsoft. While these can be powerful solutions, they can be difficult to deploy and maintain within a university IT structure. To this end an alternate solution was found using free public services, in this case provided by Google. In the first iteration the system was used for communication with Gmail and Google talk, document sharing with Gdocs (Google Documents), scheduling with Google Calendar, and web publishing with Google sites. Aside from signing up for a Gmail account the process is remarkably simple. The ability to set up groups, set sharing privileges, and track changes makes the system capable of services not possible with traditional course management systems.
This paper outlines how to use Google or similar services to manage senior and course projects. To this end the paper will be partially tutorial in nature, but special effort will be made to highlight the pedagogical values of the methods.
At Grand Valley State University the senior project course1 is interdisciplinary for all four undergraduate programs: Computer, Electrical, Mechanical, and Product Design and Manufacturing Engineering. Projects are solicited from local companies, project sponsors pay for materials, and then must sign off on the final project deliverables. Typical projects include the design, construction, and testing of production equipment, test equipment, or new product designs (See Figure 1). To obtain these results the project course is carefully managed for student based innovative design monitored and guided by faculty. The stages of the senior project course are,
The management structure used for the projects includes multidisciplinary teams of 4-6 students with one faculty member acting as a primary manager, and one faculty member acting as a mentor to the teams. The manager tracks the progress of multiple projects and deals with general administrative details. The mentor has a much more flexible role to advise the team on various technical and professional issues with the team. The managers and mentors select grades for the students.
The structure of the project management process has evolved over the last decade based on positive and negative experiences with the teams. In the past students were guided and tracked with the following elements.
Logbooks: Were intended as a way to track student progress in a professional sense. Students were directed to carry it with them and make notes as they discover new information, make decisions, etc. In addition they were also directed to log their hours. In practice students are more likely to use computers as the tools of choice. The log books would be pushed to the side to make space for a laptop. Over the past few years the quality of notes in the books has decreased and entries are made less often. Simply put they were no longer the right tools for the job.
Weekly Progress Reports: became an artificial way to track the team. To prepare for a progress report students would meet once a week, sometimes update the budgets and Gantt charts, and then write benign statements to describe progress and issues. In effect the progress reports became a time consuming extra task that did not effectively reveal true team progress and issues.
Beginning in the 2007/2008 project cycle Google Docs was used on a limited scope to share documents. The result was very positive so this year various Google tools have been deployed on a large scale to support the projects. In effect it has become a groupware solution like that used by many companies.
First, it is worth noting that the services that Google offers can be purchased from them with additional space, uptime guarantees, and features. It is also worth noting that similar free services are also available from other providers. Many of these services can also be found in common university software such as Blackboard. So while this work uses Google services, there is no intention to introduce commercialism or exclusively represent these as unique.
Google Docs: A user can create spreadsheets, text documents, data entry forms, and presentations that can be shared and edited by other users simultaneously (note this is a very important feature for teamwork).
The Google site provide up to 7GB of space per user without charge. This is more than enough to host most project files. Privacy is an issue with projects, but Google specifically states that files that are not shared will be kept confidential. In addition, users have the ability to set sharing settings that include view and edit files and sites that are open to anybody on the Internet, people who sign in, and specific users on gmail. All of these services can be interlinked and launched from any google service page.
4. Students were directed to create a Google Site, or Google Group to host individual notes, and team notes. Approximately a third chose the Groups, but in hind-sight it would have been more effective to have all teams use it.
A project tracking spreadsheet was created as a common document that centralizes team tracking. The spreadsheet can be opened and edited by multiple users so that team members may keep it active and make frequent updates while they work. It also permits other team members, mentors, and managers to track the team progress in real-time. This eliminated the need for weekly progress reports. The spreadsheet is divided into pages as listed below,
To replace the function of the log books for taking notes students are asked to maintain a ‘notebook’ in Google Sites or Groups. The stated objective for these pages is that as students do their work it should appear in their individual pages with corresponding time log entries in the team spreadsheet. These pages provide an easily accessible place to store notes that are shared with their team-mates, mentor, and manger. The notes on individual pages document preliminary work by an individual team member. Once the individual work has matured to the point where it was ready for use by the team it is added to the team page. The team pages are used for common and agreed upon elements of the team work. The team page links to the student pages to make it a single landing point for all project activity.
Previously, when using the logbooks, the contents of notes were only available to the student, unless physically shared with their colleagues or submitted for grading. With the shared notes the students have a much greater motivation for quality because their peers will see it, and timeliness because they never know when it will be graded.
Students were given a choice for keeping notes. Google Sites provides the ability to create web pages with places for discussions (open to the Internet, with limited shared, or non-shared). Google Groups allows students a common place to keep notes and hold threaded discussions. Regardless of the choice of Google sites or Groups the students were also able to hold conversations about items and work on a common document without the ‘hand-off’ problems created by logbooks. However, at this point there is a slight advantage in the presentation of in Google Groups, thus it will be the tool of choice in the 2009/2010 offering of the senior project course.
The use of computer based tools allows much more flexibility for faculty grading and tracking. Materials can be graded at the instructors leisure without the need for students to submit reports. During the first couple of weeks it is important to review the materials a few times and send email to the teams or individuals. This creates an environment where the students update documents as they work within an environment of continual expectation (i.e., quality is not driven by last minute work before deadlines). The team spreadsheet allows a fairly quick assessment of the team progress. Although we do not do so, it is possible to assign weekly grades by reviewing the spreadsheet and notes pages.
At the time of writing the new method was in use for one month and all signs point to a very successful introduction. By the time of final submission (April 2009) the authors expect to provide some anecdotal assessment data that describes the success of the approach.