Insegnamento a.a. 2018-2019

20591 - COMPUTER PROGRAMMING AND DATABASE SYSTEMS

Department of Decision Sciences

Course taught in English
Go to class group/s: 23
DSBA (8 credits - I sem. - OB  |  SECS-S/01)
Course Director:
CARLO LUCIBELLO

Classes: 23 (I sem.)
Instructors:
Class 23: CARLO LUCIBELLO


Mission & Content Summary

MISSION

Scope of the course is to provide a thorough introduction to computer programming (in Python) and database systems. The course covers the practical foundations of computer science, which are extensively used in subsequent courses of the education program.

CONTENT SUMMARY

  • Introduction to programming in Python.
  • Data structures and basic algorithms.
  • Programming techniques overview.
  • Object-oriented programming - classes and methods.
  • Numerical and scientific libraries.
  • Introduction to databases.
  • Large scale database systems.

Intended Learning Outcomes (ILO)

KNOWLEDGE AND UNDERSTANDING

At the end of the course student will be able to...
  • Describe  fundamental programming strategies and the functioning principles of database systems.

APPLYING KNOWLEDGE AND UNDERSTANDING

At the end of the course student will be able to...
  • Read/write advanced Python codes.
  • Master object-oriented programming.
  • Develop codes for algorithmic problem solving.
  • Handle large scale databases.

Teaching methods

  • Face-to-face lectures
  • Exercises (exercises, database, software etc.)

DETAILS

Exercises consist in programming assignments to be done in class under the supervision of the Instructor and Teaching Assistants.


Assessment methods

  Continuous assessment Partial exams General exam
  • Written individual exam (traditional/online)
    x
  • Individual assignment (report, exercise, presentation, project work etc.)
    x

ATTENDING AND NOT ATTENDING STUDENTS

  • The written exam consists in programming exercises to be performed at the PC in the computer room. This contributes to the remaining 50% of the final grade.
  • The individual assignment consists in a programming code to solve a concrete database problem, to be developed individually and described through a written report, which is evaluated by the teachers.This contributes to 50% of the final grade.

Both parts are used to asses both the "knowledge and understanding" and the "applying knowledge and understanding" learning   objectives.


Teaching materials


ATTENDING AND NOT ATTENDING STUDENTS

The textbooks are communicated prior to the start of the course. Handouts of each lecture and sample codes are provided.

Last change 10/07/2018 11:14