Learning objectives
The Module of Information processing systems, introduced into the Teaching or integrated Course of chemical-physical and experimental Sciences, is addressed to the Prevention technician in university education, aimed to enter professionally both public and private processes in the sphere of public prevention. Its target is to provide useful information for the understanding of the value of adopting computer science technologies and know-how with the purpose of tool achievement, for a useful use in the described field.
The course has the aim of letting student know and understand essential elements of computer science, automatic systems for data management, statistics on excel.
Its target is to let students be able to use the knowledge and understanding for:
- an effective integration in a working environment of the described field, characterized by the use of latest data management systems.
- The representation by means of flowcharts of the active processes in the present working environment of the area of expertise
- The correct analysis of the data flow, using statistical analysis on excel
- The use of hardware systems for the data management
- The realizations of simple database.
EDUCATION RESULTS
At the end of the course, thanks to the achieved knowledge, the student shall show know-how and comprehension skills regarding:
- the graphic representation of data flow in a process
- The correct representation of the data by charts
- The basic use of hardware and software tools for the data management and processing
- La capacità dell'utilizzo del software excel
Prerequisites
Basic mathematics knowledge.
Course unit content
The course is divided into four lessons, structured as briefly described below.
At the beginning, the importance of technological evolution for the redefinition of health system targets is analyzed, with particular attention to the prevention field. Basic concepts of computer science are provided afterwards.
The second lesson is focused on the concept of data bases and their possible logical modelling; the model of relationship data base is deepened, together with concepts related to a DBMS (Data base management system).
In the next 3 lesson the base concept of statistics in excel are defined.
Finally, in the last two lesson database in excel are explained (tables, relationships and pivot tables)
Full programme
Introduction: Introduction to information systems and database managment systems.
Statistics on Excel:
- Introduction to the Excel Software and its functionalities. Elements of statistics applied on Excel: mean variance, frequency, etc..
- Regression, Correlation and t-student test
- Mann Whitney and WIlkoxon tests
- Chi squared test
Database in Excel:
- How to realize tables, pivot tables and relationships between tables.
- How to load excel data starting from file. Realize Pivot tables from data of large dimention.
Bibliography
Classroom notes and slides, literature provided by the teacher.
Teaching methods
The course will be held through lectures to Students in presenza. Therefore, the opportunity of Student/Teacher interaction will be preserved.
Lectures will be supported by slide presentations, which will be available to students on the Elly platform (https://elly.medicina.unipr.it).
Assessment methods and criteria
The verification of the course target achievement consists on one practical test in excel in the laboratory where the topics of the course will be verified.
Students with SLD / BSE must first contact Le Eli-che: support for students with disabilities, D.S.A., B.E.S. (https://sea.unipr.it/it/servizi/le-eli-che-supporto-studenti-con-disabilita-dsa-bes
Other information
