ON-LINE DATABASE of SCIENTIFIC PAPERS
10.5593/sgemsocial2017/15/S05.071

IT TOOL CREATED IN LINE WITH THE CONCEPT OF “MICROTOOLS BASED ON THE RELATIONAL DATA MODEL” TO SUPPORT THE PROCESS OF WORK PLANNING FOR SPECIAL SCHOOL TEACHER ASSISTANTS.

B. Szczesniak
Thursday 28 September 2017 by Libadmin2017

References: 4th International Multidisciplinary Scientific Conference on Social Sciences and Arts SGEM 2017, www.sgemsocial.org, SGEM2017 Conference Proceedings, ISBN 978-619-7408-17-1 / ISSN 2367-5659, 24 - 30 August, 2017, Book 1, Vol 5, 565-572 pp, DOI: 10.5593/sgemsocial2017/15/S05.071

ABSTRACT

There is a specific group of information processes performed in an organisation which are particularly linked with information acquisition, processing and rendering. And even though numerous highly advanced IT solutions are commonly available, handling of such processes often involves a considerable share of manual activities. In order to support them, one can use tools developed in spreadsheets by following the author’s signature concept referred to as “Microtools Based on the Relational Data Model”. The article addresses a concept of one of such tools created to support a process which consists in planning the work of special school teacher assistants. The first aspect explained in the paper is the functionality assumed for the tool in question. What has been identified is the kind of information considered relevant to facilitate the work performed by a person preparing such a plan. Subsequent paragraphs of the article present the data structure providing grounds for the solution proposed, as determined with reference to the problem analysis previously conducted. Connections between individual entities identified within this structure have been illustrated in an adequate Entity-Relationship Diagram (ERD). Furthermore, characteristics of all entities and their attributes have been provided. The description of the tool structure comprises the method used to implement all the entities proposed in the spreadsheet. What has also been discussed is the solutions applied to ensure integrity of the data stored as well as those which allow for the assumed functionality to be attained. The final section of the article provides a description of the advantages resulting from application of the tool in question.

Keywords: business process improvement, information process, scheduling, database, spreadsheet

PAPER DOI: 10.5593/sgemsocial2017/15/S05.071 ; IT TOOL CREATED IN LINE WITH THE CONCEPT OF “MICROTOOLS BASED ON THE RELATIONAL DATA MODEL” TO SUPPORT THE PROCESS OF WORK PLANNING FOR SPECIAL SCHOOL TEACHER ASSISTANTS.

35 EURO ADD TO CART


Your cart ( items)

Subtotal:
Tax cost ():
Shipping cost:
Total:
Checkout Empty