Facebook pixel
Info
Foto sezione
Logo Bocconi

Course 2022-2023 a.y.

30424 - COMPUTER SCIENCE

Department of Computing Sciences

For the instruction language of the course see class group/s below

Go to class group/s: 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 - 13 - 15 - 16 - 17 - 18 - 21 - 22 - 23

CLEAM (6 credits - II sem. - OBBC) - CLEF (6 credits - II sem. - OBBC) - CLEACC (6 credits - II sem. - OB) - BIEF (6 credits - II sem. - OBBC) - BIEM (6 credits - II sem. - OBBC) - BIG (6 credits - II sem. - OB)

Classi: 1 (II sem.) - 2 (II sem.) - 3 (II sem.) - 4 (II sem.) - 5 (II sem.) - 6 (II sem.) - 7 (II sem.) - 8 (II sem.) - 9 (II sem.) - 10 (II sem.) - 11 (II sem.) - 12 (II sem.) - 13 (II sem.) - 15 (II sem.) - 16 (II sem.) - 17 (II sem.) - 18 (II sem.) - 21 (II sem.) - 22 (II sem.) - 23 (II sem.)
Docenti responsabili delle classi:
Classe 1: MAURIZIO DE PRA, Classe 2: DAVIDE TOSI, Classe 3: DARIO BOSCHETTI, Classe 4: DARIO OMODEO ZORINI, Classe 5: GABRIELLA GRIGNOLIO, Classe 6: DAMIANO MARINO SOMENZI, Classe 7: MARIA CHIARA DEBERNARDI, Classe 8: CRISTIANO TONI, Classe 9: ANGELA BENVENUTA PEREGO, Classe 10: MAURIZIO DE PRA, Classe 11: DA DEFINIRE, Class 12: MASSIMO BALLERINI, Class 13: FEDERICA VALSECCHI, Class 15: MASSIMO BALLERINI, Class 16: ROBERTA REMIGI, Class 17: TO BE DEFINED, Class 18: VITTORIO LOCATI, Class 21: GIANLUIGI PERTUSI, Class 22: MICHELE SLOCOVICH, Class 23: ALESSANDRO ROGORA

Classe/i impartita/e in lingua italiana

Conoscenze pregresse consigliate

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)


Mission e Programma sintetico
MISSION

The objective is to provide students with new skills they can immediately use in their studies and that are fundamental to enter the job market: to structure, process, analyze data and effectively communicate information in order to solve managerial problems and support decision-making processes.

PROGRAMMA SINTETICO

The course is divided into two sections that highlight two areas of expertise, integrated one to the other to reach the final objective of the course:

  1. Process and analyze data: deepen the application of the spreadsheet (Excel) to import, structure, process and analyze data, understanding the logic and functions in the solution of business problems, in order to produce meaningful and consistent information according to defined goals.
  2. Learn computer programming: learn the basics of computer programming, learn to make use of a programming language (Python), use Python to solve business problems.

Risultati di Apprendimento Attesi (RAA)
CONOSCENZA E COMPRENSIONE
Al termine dell'insegnamento, lo studente sarà in grado di...
  • Recognize the main logics and tools of the spreadsheet for importing, analyzing, processing and presenting 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.
CAPACITA' DI APPLICARE CONOSCENZA E COMPRENSIONE
Al termine dell'insegnamento, lo studente sarà in grado di...
  • Use the spreadsheet to import, analyze, process data and communicate information useful for decision making.
  • Use complex formulas and functions to solve business and management problems with the spreadsheet.
  • Apply software programming logics in Python or other languages.
  • Examine a program to understand its structure and functioning, modify it or reuse it.
  • Develop simple programs in Python to perform calculations and automate even complex operations.

Modalità didattiche
  • Lezioni frontali
  • Lezioni online
  • Esercitazioni (esercizi, banche dati, software etc.)
  • Lavori/Assignment individuali
  • Altre attivita' d'aula interattive (role playing, business game, simulation, online forum, instant polls)
DETTAGLI

The course alternates lessons in traditional classrooms and practice sessions in computer rooms, focusing especially on the use of Microsoft Excel at an advanced level and on programming with Python.
Practical activities on the main topics covered during the lesson will also be carried out in class.
Furthermore, ongoing self-assessment activities on the skills acquired, will be carried out both during the face-to-face activity and as individual assignments.


Metodi di valutazione dell'apprendimento
  Accertamento in itinere Prove parziali Prova generale
  • Prova individuale scritta (tradizionale/online)
  • x x x
    STUDENTI FREQUENTANTI E NON FREQUENTANTI

    The exam can be taken in two ways: as two partial exams or as a single general exam.

     

    • Partial exams are intended only for students who regularly attend the lessons and specifically refer to the chapters mentioned in the course syllabus. Only first-year students can take partial exams. It is not possible to take or repeat partial exams in the following years. Students who fail the first partial exam (grade <18) are not allowed to take the second partial exam. To pass the partial exam it is necessary to earn a positive grade (>=18) on both of them. The final grade comes from the average of the two partials. Partial exams include a part of multiple choice questions and a part of computer exercises.
      • The part of multiple choice questions aims to verify: the ability to read a program understanding its structure and functionalities; the knowledge and learning of the logics and main tools of the spreadsheet and of the logics and paradigms of software programming; the knowledge of the main constructs of a program and the ability to understand its structure and functioning.
      • The part of computer exercises aims to verify the ability to use the spreadsheet to solve business problems and to develop or modify simple Python programs to perform calculations and automate operations.

     

    • General exams are intended for students who have not taken or have not passed the partial exams and refer to the general exam bibliography. General exams include a part of multiple choice questions and a part of computer exercises.
      • The part of multiple choice questions aims to verify: the ability to read a program understanding its structure and functionalities; the knowledge and learning of the logics and main tools of the spreadsheet and of the logics and paradigms of software programming; the knowledge of the main constructs of a program and the ability to understand its structure and functioning.
      • The part of computer exercises aims to verify the ability to use the spreadsheet to solve business problems and to develop or modify simple Python programs to perform calculations and automate operations.

     

    There are also optional ongoing assessments that can allow to achieve a bonus valid only for those who will take the partial exams.


    Materiali didattici
    STUDENTI FREQUENTANTI E NON FREQUENTANTI
    • M. Ballerini, A. Clerici, M. De Pra, Excel for students in economics and finance, Egea, 2020
    • M. Ballerini, A. Clerici, M. Debernardi, D. Del Corno, M. De Pra, Excel workbook, 3rd ed., Egea, 2021
    • A. Clerici, M. De Pra, M.C. Debernardi, D. Tosi, Learning Python, Egea, 2020
    • M. Ballerini, D. Boschetti, A. Clerici, M. De Pra, M. Debernardi, G. Pertusi, Python workbook, Egea, 2022
    • Materials and additional exercises (provided during the course).
    Modificato il 26/09/2022 14:14