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 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, basic concepts of information systems, data management and computer science are provided.
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.
Full programme
Introduction: Introduction to information systems, computer science and database managment systems.
Statistics in 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
- Binomial Distribution
Database in Excel:
- How to realize tables and relationships between tables.
- How to load and process excel data starting from file.
Bibliography
Classroom notes and slides, literature provided by the teacher.
Analisi statistica con Excel (Maria Michela Dickson, Diego Giuliani)
Teaching methods
The course will be held through face-to-face lectures to Students. 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. The final grade will be in 30/30 and the final grade will be the average of the grade of this module with respect to those of the other modules of the integrated course.
Students with SLD / BSE must first contact the welcome and inclusion center (cai@unipr.it).
Other information
2030 agenda goals for sustainable development
- - -
