30424 - COMPUTER SCIENCE / COMPUTER SCIENCE
Dipartimento di Scienze della Computazione / Department of Computing Sciences
Orario di ricevimento / Student consultation hours
Orario delle lezioni / Class timetable
Calendario esami / Exam timetable
Per la lingua del corso verificare le informazioni sulle classi/
For the instruction language of the course see class group/s below
Vai alle classi / Go to class group/s: 1 - 2 - 3 - 4 - 5 - 6 - 11 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19 - 40 - 41 - 42 - 43 - 44
Docente responsabile dell'insegnamento / Course Director:
MAURIZIO DE PRA
MAURIZIO DE PRA
Classi: 1 (II sem.) - 2 (II sem.) - 3 (II sem.) - 4 (II sem.) - 5 (II sem.) - 6 (II sem.) - 11 (II sem.)
Docenti responsabili delle classi:
Classe 1: ANGELA BENVENUTA PEREGO, Classe 2: DARIO BOSCHETTI, Classe 3: MAURIZIO DE PRA, Classe 4: DARIO OMODEO ZORINI, Classe 5: SALVATORE ADRIANO PRENCIPE, Classe 6: CRISTIANO TONI, Classe 11: MAURIZIO DE PRA
Classe 1: ANGELA BENVENUTA PEREGO, Classe 2: DARIO BOSCHETTI, Classe 3: MAURIZIO DE PRA, Classe 4: DARIO OMODEO ZORINI, Classe 5: SALVATORE ADRIANO PRENCIPE, Classe 6: CRISTIANO TONI, Classe 11: MAURIZIO DE PRA
Classe/i impartita/e in lingua italiana
Conoscenze pregresse consigliate
Per poter frequentare con profitto il corso è opportuna una conoscenza di base dell'ambiente Windows e degli applicativi Office. Per potersi iscrivere all'esame è necessario conseguire una delle certificazioni informatiche di base riconosciute (ad esempio ECDL/ICDL)
Mission e Programma sintetico
MISSION
L'obiettivo è quello di fornire agli studenti le competenze immediatamente applicabili nel loro percorso di studi e fondamentali nel mondo del lavoro per strutturare, elaborare, analizzare dati e comunicare efficacemente informazioni, nella soluzione di problemi economici, finanziari e di management, e in supporto ai processi di decision-making.
PROGRAMMA SINTETICO
Il corso è diviso in tre sezioni che evidenziano altrettante aree di competenza, integrate tra loro in funzione dell’obiettivo finale del corso:
- Conoscere gli elementi fondamentali della Computer Science
- Elaborare e analizzare i dati con Microsoft Excel
- Imparare i fondamenti e le logiche dalla programmazione, utilizzando Python
Risultati di Apprendimento Attesi (RAA)
CONOSCENZA E COMPRENSIONE
Al termine dell'insegnamento, lo studente sarà in grado di...
- Comprendere come rappresentare i dati in forma digitale
- Riconosce gli strumenti principali dell'ICT
- Riconoscere le logiche principali del foglio elettronico per l'analisi e l'elaborazione dei dati
- Identificare le caratteristiche di un elenco di dati funzionale all'analisi e alle elaborazioni successive
- Riconoscere le logiche e i paradigmi dei linguaggi di programmazione
- Riconoscere i costrutti principali di un programma (con riferimento al linguaggio Python)
- Riconoscere un algoritmo per la risoluzione di un problema e i suoi elementi caratterizzanti
CAPACITA' DI APPLICARE CONOSCENZA E COMPRENSIONE
Al termine dell'insegnamento, lo studente sarà in grado di...
- Utilizzare il foglio elettronico per analizzare ed elaborare dati per ottenere informazioni utili per il processo decisionale
- Utilizzare formule e funzioni complesse di un foglio elettronico per risolvere problemi applicativi
- Applicare le logiche della programmazione alla scrittura di codice in Python
- Esaminare un programma per comprenderne la struttura e il funzionamento
- Sviluppare semplici programmi in Python per eseguire calcoli e automatizzare operazioni anche complesse
- Analizzare gli elementi essenziali di un algoritmo per la risoluzione di problemi
Modalità didattiche
- Lezioni
- Esercitazioni pratiche
- Lavori/Assignment individuali
DETTAGLI
Il corso integra lezioni frontali con sessioni di esercitazione con i personal computer degli studenti, focalizzandosi sull'utilizzo avanzato di Excel e sulla programmazione in Python.
Sono previste anche attività in itinere di self-assessment delle competenze acquisite, da svolgere come assignment individuali.
Metodi di valutazione dell'apprendimento
| Accertamento in itinere | Prove parziali | Prova generale | |
|---|---|---|---|
|
x | ||
|
x |
STUDENTI FREQUENTANTI E NON FREQUENTANTI
La valutazione prevede il superamento di un esame generale in forma scritta, composto da domande multiple-choice e da esercizi.
Le domande multiple-choice sono volte a verificare la corretta comprensione e l’apprendimento dei concetti, delle logiche di funzionamento e degli strumenti illustrati nel materiale didattico. Gli esercizi sono volti a valutare le capacità applicative delle conoscenze apprese durante il corso in seguito allo studio dei materiali didattici.
L'esame è suddiviso in due parti. E' possibile svolgere la prima parte dell'esame come una serie di prove in itinere durante il corso. Chi deciderà di tenere il punteggio ottenuto con le valutazioni in itinere potrà accedere direttamente alla seconda parte dell'esame generale. Il punteggio ottenuto con le prove in itinere resterà valido unicamente per tutte le sessioni d'esame dell'anno accademico in cui sono state svolte.
Materiali didattici
STUDENTI FREQUENTANTI E NON FREQUENTANTI
- M. Ballerini, M. De Pra, Excel per gli studenti di economia e finanza, 2° ed., Egea, 2025
- M. Ballerini, M. De Pra, M. Debernardi, Eserciziario di Excel, 4° ed., Egea, 2025
- M. Ballerini, M. De Pra, M. Debernardi, Capire Python, Egea, 2025
- M. Ballerini, D. Boschetti, A. Clerici, M. De Pra, M. Debernardi, G. Pertusi, Eserciziario di Python, Egea, 2022
- Materiali ed esercizi aggiuntivi (forniti in itinere)
Modificato il 21/05/2024 13:38
Docente responsabile dell'insegnamento / Course Director:
MAURIZIO DE PRA
MAURIZIO DE PRA
Class group/s taught in English
Suggested background knowledge
Basic knowledge of the Windows environment and Office applications is appropriate to be able to attend the course profitably. To be able to register for the exam it is necessary to achieve one of the recognized basic IT certifications (eg ECDL/ICDL)
Mission & Content Summary
MISSION
The objective is to provide students with new skills they can use in their studies and that are fundamental in the job market: to structure, process, analyze data and effectively communicate information in order to solve managerial problems and support decision-making processes.
CONTENT SUMMARY
The course is divided into three sections highlighting as many areas of expertise, which are integrated with each other according to the mission of the course:
- Know the fundamental elements of Computer Science
- Process and analyze data with Microsoft Excel
- Learn the fundamentals and logic of coding with Python
Intended Learning Outcomes (ILO)
KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
- Understand how to represent data in a digital format
- Recognize the main tools of ICT
- Recognize the logics of the spreadsheet for analyzing and processing data
- Identify the features of a set of data that are functional to the analysis and subsequent elaborations
- Recognize the logic and paradigms of software programming
- Recognize the main constructs of a program (functions, loops, conditional constructs, etc.)
- Read a program to understand its structure and features
APPLYING KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
- Use the spreadsheet to analyze and process data to obtain information useful for decision making
- Use complex formulas and functions to solve business and management problems with the spreadsheet
- Apply software programming logics to coding with Python
- Examine a program to understand its structure and functioning
- Develop simple programs in Python to perform calculations and automate even complex operations
- Analyze the essential elements of an algorithm for problem solving
Teaching methods
- Lectures
- Practical Exercises
- Individual works / Assignments
DETAILS
The course integrates traditional lessons with practice sessions, focusing on the advanced use of Excel and on programming with Python.
Ongoing self-assessment activities on the skills acquired will also be carried out as individual assignments.
Assessment methods
| Continuous assessment | Partial exams | General exam | |
|---|---|---|---|
|
x | ||
|
x |
ATTENDING AND NOT ATTENDING STUDENTS
The assessment involves passing a general exam in written form, consisting of multiple-choice questions and exercises.
Multiple-choice questions are aimed at assessing the correct understanding and learning of the concepts, operating logic and tools illustrated in the course materials and during the teaching activities. The exercises are aimed at assessing the ability to apply the knowledge learned during the course as a result of studying the course materials.
The exam is divided into two parts. It is possible to take the first part of the exam as a series of ongoing assessments during the course. Those who decide to keep the score obtained with the ongoing assessments will be able to directly access the second part of the general exam. The score obtained with the ongoing assessments will remain valid only for all exam sessions of the academic year in which they were carried out.
Teaching materials
ATTENDING AND NOT ATTENDING STUDENTS
- M. Ballerini, M. De Pra, Excel for students in economics and finance, 2nd ed., Egea, 2025
- M. Ballerini, M. De Pra, M. Debernardi, Excel workbook, 4th ed., Egea, 2025
- M. Ballerini, M. De Pra, M. Debernardi, Understanding Python, Egea, 2025
- M. Ballerini, D. Boschetti, A. Clerici, M. De Pra, M. Debernardi, G. Pertusi, Python workbook, Egea, 2022
- Additional materials and exercises (provided during the course)
Last change 20/11/2024 15:58
BESS-CLES (6 cfu - II sem. - OB) - BIEF (6 cfu - II sem. - OBBC) - BIEM (6 cfu - II sem. - OBBC) - BIG (6 cfu - II sem. - OB | INF/01)
Docente responsabile dell'insegnamento / Course Director:
MASSIMO BALLERINI
MASSIMO BALLERINI
Classes: 13 (II sem.) - 14 (II sem.) - 15 (II sem.) - 16 (II sem.) - 17 (II sem.) - 18 (II sem.) - 19 (II sem.) - 40 (II sem.) - 41 (II sem.) - 42 (II sem.) - 43 (II sem.) - 44 (II sem.)
Instructors:
Class 13: GIANLUIGI PERTUSI, Class 14: MARIA CHIARA DEBERNARDI, Class 15: MASSIMO BALLERINI, Class 16: MASSIMO BALLERINI, Class 17: ANDREA BIANCINI, Class 18: TOMMASO D'ORSI, Class 19: MASSIMO BALLERINI, Class 40: MASSIMO BALLERINI, Class 41: GIANLUIGI PERTUSI, Class 42: MICHELE SLOCOVICH, Class 43: GIANLUIGI PERTUSI, Class 44: FEDERICA VALSECCHI
Class 13: GIANLUIGI PERTUSI, Class 14: MARIA CHIARA DEBERNARDI, Class 15: MASSIMO BALLERINI, Class 16: MASSIMO BALLERINI, Class 17: ANDREA BIANCINI, Class 18: TOMMASO D'ORSI, Class 19: MASSIMO BALLERINI, Class 40: MASSIMO BALLERINI, Class 41: GIANLUIGI PERTUSI, Class 42: MICHELE SLOCOVICH, Class 43: GIANLUIGI PERTUSI, Class 44: FEDERICA VALSECCHI
Class group/s taught in English
Suggested background knowledge
Basic knowledge of the Windows environment and Office applications is appropriate to be able to attend the course profitably. To be able to register for the exam it is necessary to achieve one of the recognized basic IT certifications (eg ECDL/ICDL)
Mission & Content Summary
MISSION
The objective is to provide students with new skills they can use in their studies and that are fundamental in the job market: to structure, process, analyze data and effectively communicate information in order to solve managerial problems and support decision-making processes.
CONTENT SUMMARY
The course is divided into three sections highlighting as many areas of expertise, which are integrated with each other according to the mission of the course:
- Know the fundamental elements of Computer Science
- Process and analyze data with Microsoft Excel
- Learn the fundamentals and logic of coding with Python
Intended Learning Outcomes (ILO)
KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
- Understand how to represent data in a digital format
- Recognize the main tools of ICT
- Recognize the logics of the spreadsheet for analyzing and processing data
- Identify the features of a set of data that are functional to the analysis and subsequent elaborations
- Recognize the logic and paradigms of software programming
- Recognize the main constructs of a program (functions, loops, conditional constructs, etc.)
- Read a program to understand its structure and features
APPLYING KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
- Use the spreadsheet to analyze and process data to obtain information useful for decision making
- Use complex formulas and functions to solve business and management problems with the spreadsheet
- Apply software programming logics to coding with Python
- Examine a program to understand its structure and functioning
- Develop simple programs in Python to perform calculations and automate even complex operations
- Analyze the essential elements of an algorithm for problem solving
Teaching methods
- Lectures
- Practical Exercises
- Individual works / Assignments
DETAILS
The course integrates traditional lessons with practice sessions, focusing on the advanced use of Excel and on programming with Python.
Ongoing self-assessment activities on the skills acquired will also be carried out as individual assignments.
Assessment methods
| Continuous assessment | Partial exams | General exam | |
|---|---|---|---|
|
x | ||
|
x |
ATTENDING AND NOT ATTENDING STUDENTS
The assessment involves passing a general exam in written form, consisting of multiple-choice questions and exercises.
Multiple-choice questions are aimed at assessing the correct understanding and learning of the concepts, operating logic and tools illustrated in the course materials and during the teaching activities. The exercises are aimed at assessing the ability to apply the knowledge learned during the course as a result of studying the course materials.
The exam is divided into two parts. It is possible to take the first part of the exam as a series of ongoing assessments during the course. Those who decide to keep the score obtained with the ongoing assessments will be able to directly access the second part of the general exam. The score obtained with the ongoing assessments will remain valid only for all exam sessions of the academic year in which they were carried out.
Teaching materials
ATTENDING AND NOT ATTENDING STUDENTS
- M. Ballerini, M. De Pra, Excel for students in economics and finance, 2nd ed., Egea, 2025
- M. Ballerini, M. De Pra, M. Debernardi, Excel workbook, 4th ed., Egea, 2025
- M. Ballerini, M. De Pra, M. Debernardi, Understanding Python, Egea, 2025
- M. Ballerini, D. Boschetti, A. Clerici, M. De Pra, M. Debernardi, G. Pertusi, Python workbook, Egea, 2022
- Additional materials and exercises (provided during the course)
Last change 13/01/2025 10:32