Logo Facoltà di Scienze Agrarie e Alimentari Università degli Studi di Milano foto
Facoltà di Scienze Agrarie e Alimentari Università degli Studi di Milano
contatti    cerca    mappa   
Notions and skills of Informatics
Code: G260L-
Teacher:  Luca Andrea Ludovico
CFU subdivision: Lectures: 3
Basic aims:  To provide students with the first concepts of this discipline, balancing the practical and theoretical aspects, respectively related to the use of computer and to the information management.
Acquired skills:  Principles of computer science integrated to outline of information systems applied in agricultural and / or agri-food contexts. Use of software for digital data managing, processing and storage.
Course contents:  Introduction to Informatics, information encoding, internal computer structure, programs and software. Computer networks and web. Spreadsheets. Information management and databases.
Program:  PART I – Introduction to computer science
G.1. Basic elements
G.2. Information coding
G.3. Computer hardware
G.4. Software and programming
G.5. Computer networks

PART II – Information management and spreadsheets
F.1. Spreadsheets
F.2. Use of functions with Excel
F.3. Statistical functions with Excel
F.4. Creation of graphs with Excel

PART III – Information management and databases
B.1. Information management
B.2. Data storage and databases
B.3. Data models
B.4. Relational databases
B.5. Database creation with Access
B.6. Query composition with Access
B.7. Databases on the Web

PART IV – Internet and the Web
I.1. Internet
I.2. Web architecture
I.3. Web standards
I.4. Html: a markup language for the Web
I.5. Client-side programs and applications
I.6. Search engines
Prerequisites:  Wide manual skills in the use of computers (file and document management, web browsing). Basic notions of mathematics.
Preparatory instructions:  None
Learning materials:  Teaching stuff available on the course website (upon registration in the expected periods).

Suggested book for possible further readings:
S. Castano, A. Ferrara, S. Montanelli. "Informazione, conoscenza e Web per le scienze umanistiche". Pearson, Milano 2009.
Other info:  During the course, multi-choice tests about the entire syllabus are provided to support the student self-evaluation of the acquired skills.
The final examination is written. The examination is composed of multi-choice tests about the entire syllabus.
The exam produces an APPROVED – NOT APPROVED judgment.

Course website: http://islab.di.unimi.it/infagr/
Program of Notions and skills of Informatics (pdf version)
  The Faculty
  How to reach us
  Undergraduate programmes
  Teaching organization
  LLP/Erasmus for incoming students
Università degli Studi di Milano