COMPUTER SCIENCE (30424)
Starting from 2018/2019 academic year 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 detailed syllabus is available on Blackboard starting from the beginning of the semester.
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 specifically refer to the chapters mentioned in the course syllabus (available on Blackboard). 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.
- 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 used software 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 revealed the day before the exam). The assigned shift cannot be changed. In case of serious and verifiable reasons, it is necessary to communicate these to the SEDIN office before the closing date for registration.
Bibliography - Academic Year 2018-2019
- A.CLERICI (edit by), Computer skills handbook for economics, Egea, 2017, 3rd ed.
- A.CLERICI (edit by), Excel workbook, Egea, 2017, 2nd ed.
- 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
To register for the Computer science exam (second partial or general), you need to have obtained a basic ICT certification among those accepted, within the fixed deadlines.
If such prerequisite has not been achieved within the fixed deadlines, registration for the exam will not be allowed.
For further information on the prerequisite, please visit the Prerequisite for curricular courses page.