COMPUTER SCIENCE (30424)
The Computer science course is intended for students enrolled in CLEAM, CLEF, CLEACC, BESS, BIEM, BIEF and BIG programs, it is worth 6 credits and it is taught in the second semester of the first year of the program.
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.
The course includes traditional in-class lectures and hands-on sessions, which will take place in specially designed IT classrooms.
The course is divided into two sections that highlight four areas of expertise, integrated one to the other to reach the final objective of the course:
- PROCESS AND ANALYZE DATA: deepen the application of the spreadsheet 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.
- LEARN COMPUTER PROGRAMMING: learn the basics of computer programming, learn how to program with Python, use Python to solve business problems.
The course alternates lessons in traditional classrooms and practice sessions in computer rooms, mainly focusing on the use of Microsoft Excel at an advanced level and on programming with Python.
The exam can be taken in two ways: as two partial exams or as a single general exam.
- The set of two partial exams is intended only for students who regularly attend the lessons and it specifically refers 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. In order to pass the partial exams it is necessary to get a positive grade (>=18) on both of them. The final grade comes from the average of the two partials.
- The single general exam is for students who have not taken or passed the partial exams. This exam refers to the general exam bibliography.
In both cases the exam consists of multiple-choice questions and computer exercises.
The software used is:
- Excel 2016 for Windows in English, with regional options and formats set to English (US)
- Python 3.7.x with IDLE
N.B. The exam takes place on several shifts during the same day (the classroom and exact time are communicated the day before the exam). The shift that has been assigned cannot be changed. In case of serious and verifiable reasons, it is necessary to report them to the SEDIN office before the closing date for registration.
Bibliography - Academic Year 2019-2020
- M. BALLERINI, A. CLERICI, M. DE PRA, Excel for students in economics and finance, Egea, 2020
- A. CLERICI (edited by), Excel workbook, 2nd ed., Egea, 2017
- A. CLERICI, M. DE PRA, M. DEBERNARDI, D. TOSI, Learning Python, Egea, 2019
The detailed program for partial exams and general exams is available on Blackboard.
Prerequisite for the exam
It is possible to register for the Computer science exam (second partial or general) only after obtaining, by the deadlines set, a basic ICT certification among those accepted.
If the prerequisite has not been achieved by the deadlines set, the registration for the exam will not be allowed.
For further information on the prerequisite, please visit the Prerequisite for curricular courses page.