Basic Statistics with Computer Applications

A.Y. 2024/2025
6
Max ECTS
64
Overall hours
Language
Italian
Learning objectives
The course aims to provide basic knowledge and skills in the field of informatics and statistics, with particular attention to their use for reading, synthetizing, analyzing and interpreting complex phenomena. Therefore, the basic concepts of descriptive statistics will be introduced, such as the different ways of organization and representation of the data, the measures of central tendency and the associated indices of dispersion, the study of the relation between two statistical variables.
With the aim of developing statistical and computational thinking, the theoretical notions will be transferred into the application field through the use of up-to-date computer tools.
The transversal aim of the course is to provide digital, communicative, relational, decision-making and problem-solving skills useful for addressing the academic career and the world of work.
Expected learning outcomes
At the end of the course, the student will be able to:
· use the main tools for information collection and use public sources to derive secondary data;
· represent phenomena related to daily experience, both graphically and through appropriate synthesis values, and interpret them also through the exploration of dependency relationships between variables;
· use software and write scripts useful for management, processing, automation, archiving, data representation;
· design and produce multimedia contents with independent judgement to offer third-party users knowledge on key issues of agricultural and environmental sciences;
· adopt an ethical approach to the use of communication and information technologies;
· make a critical use of participative web tools
Single course

This course can be attended as a single course.

Course syllabus and organization

Single session

Lesson period
Second semester
Course syllabus
- Basic principles of using Excel
- Pivot Tables, grafichs, presentation of results
- Statistics on agrifood data
- Main methodologies of descriptive statistics, regression, one-way analysis of variance
- Use of the Excel "Data Analysis" package
Prerequisites for admission
The student should know the mathematical language
Teaching methods
The lessons will be both theoretical and in the form of a computer lab.
Teaching Resources
1) Material provided by the teachers on website (TEAMS).
2) suggested book:
"Introduzione alla Statistica", di M. K. Pelosi e T. M. Sandifer, ed. McGraw-Hill, 2009.
"Analisi Statistica con Excel", di D. Giuliani, M. M. Dickson, ed. Apogeo, 2015
Assessment methods and Criteria
The final test will consist in 2 database elaborations using the statistical and computer techniques acquired during the course. to assess the knowledge acquired.
Simulation tests of the exam will be carried out during the course.

Students with SLD or disability certifications are kindly requested to contact the teacher at least 15 days before the date of the exam session to agree on individual exam requirements. In the email please make sure to add in cc the competent offices: [email protected] (for students with SLD) o [email protected] (for students with disability).
- University credits: 6
Computer room practicals: 32 hours
Lessons: 32 hours
Professor(s)
Reception:
by appointment
Agricultural and Environmental Sciences - Production, Landscape, Agroenergy, Building 6
Reception:
by appointment (send an email)
Dipartimento di Scienze Agrarie e Ambientali (sezione Zootecnica) via Celoria 2 Milano