DOI: 10.5593/SGEM2015/B21/S7.039

SPREADSHEET AS A MEANS TO SUPPORT A TIMETABLE SCHEDULING PROCESS WITH REFERENCE TO THE EXAMPLE OF A COURSE ENTITLED WITH REFERENCE TO THE EXAMPLE OF A COURSE ENTITLED “EDUCATION OF SPECIALISTS IN THE FIELD OF MANAGEMENT OF POST-MINING AREAS IN THE POLISH-CZECH BORDERLAND”

B. Szczesniak, K. Michalski
Monday 14 September 2015 by Libadmin2015

References: 15th International Multidisciplinary Scientific GeoConference SGEM 2015, www.sgem.org, SGEM2015 Conference Proceedings, ISBN 978-619-7105-34-6 / ISSN 1314-2704, June 18-24, 2015, Book2 Vol. 1, 315-322 pp

ABSTRACT
This article addresses a concept of spreadsheet application to support a timetable scheduling process for a sample educational course. Based on the analysis performed, it was assumed that the tool in question should ensure ongoing verification of correctness of the timetable being planned. It should guarantee the timetable completeness for every group of students, conformity between the hours envisaged in the timetable and the number of hours assigned to tutors as well as general principles of the course. In specific cases, it should also verify the right sequence of individual types of classes, correct scheduling of classes assumed to be conducted in parallel and – when explicitly imposed by specific requirements – correct allocation of classes to appropriate rooms. A detailed analysis of the problem enabled making a suggestion of an entity constituting the basis of the solution being designed. This structure has been depicted in the applicable ERD diagram. For individual entities and their attributes, general characteristics have been provided. Also the manner in which the structure proposed is to be implemented in a spreadsheet has been discussed. The author has also described individual solutions ensuring integrity of the data stored with the tool as well as solutions enabling the functionality envisaged to be achieved. The tool proposed for these purposes has been developed by means of basic MS Excel mechanisms and functions, without the necessity for any macros being registered or a code being manually created using the Visual Basic for Applications programming language. The solution proposed corresponds to a concept according to which smart organisations function.

Keywords: relational data model, spreadsheet, computer-aided processes, timetable scheduling


Home | Contact | Site Map | Site statistics | Visitors : 2916 / 1556059

Follow site activity en  Follow site activity INFORMATICS  Follow site activity Papers SGEM2015   ?

CrossRef Member    Indexed in ISI Web Of Knowledge   Indexed in ISI Web Of Knowledge
   

© Copyright 2001 International Multidisciplinary Scientific GeoConference & EXPO SGEM. All Rights Reserved.

Creative Commons License