- Docente: Stefano Russo
- Credits: 6
- SSD: INF/01
- Language: Italian
- Moduli: Stefano Russo (Modulo 1) Stefano Russo (Modulo 2)
- Teaching Mode: In-person learning (entirely or partially) (Modulo 1); In-person learning (entirely or partially) (Modulo 2)
- Campus: Ravenna
- Corso: First cycle degree programme (L) in Environmental Sciences (cod. 6642)
-
from Feb 24, 2026 to May 05, 2026
Learning outcomes
The student will learn computer skills, with the ability to apply them to data processing and presentation in environmental sciences. In particular, the student will learn concepts about computer architecture, main computer tools, Internet and databases. The student will be learn also some rudiments of programming.
Course contents
Module 1 (in person)
Introduction to spreadsheets for environmental data
Organizing data in Excel
Cleaning and preparing data
Automation in Excel with VBA
VBA macros for data cleaning
Practical examples of macros for environmental datasets
How to use an AI system to generate VBA macros
Inserting generated macros into Excel
Verifying and debugging macros
Best practices
Module 2 (E-learning)
Personal productivity applications:
Spreadsheets
Slide presentations
Computer networks:
Computer networks
The Internet
Protocols
Markup and HTML:
Hypertext
Markup classification
Web 1.0 and Web 2.0
HTML and CSS
Social networks
Collaborative tools
Databases:
I database relazionali
Le chiavi
I linguaggi di interrogazione (SQL)
Creazione di tabelle e query
Readings/Bibliography
The reference texts will be communicated at the beginning of the course.
Teaching materials will be made available online.
Teaching methods
-Classroom lessons
-Laboratory exercises
-E-learning activities
Assessment methods
Written exam with an online questionnaire consisting of thirty multiple-choice, true/false, yes/no, and short-answer questions on Module 1 and Module 2, plus a possible exercise on the topics covered in both modules.
Teaching tools
Material made available online by the instructor.
Students who, for reasons related to disability, illness, psychological disorders, or specific learning disorders (SLD), require compensatory tools may contact the Service for Students with Disabilities and the Service for Students with Learning Disorders directly to agree on the most appropriate measures.
Office hours
See the website of Stefano Russo