Study-unit FUNDAMENTALS OF COMPUTER SCIENCE

Course name Engineering management
Study-unit Code A002905
Curriculum Comune a tutti i curricula
Lecturer Fabrizio Montecchiani
CFU 12
Course Regulation Coorte 2022
Supplied 2022/23
Supplied other course regulation
Type of study-unit Obbligatorio (Required)
Type of learning activities Attività formativa integrata
Partition

INFORMATION SYSTEMS

Code A002907
CFU 6
Lecturer Carla Binucci
Lecturers
  • Carla Binucci
Hours
  • 54 ore - Carla Binucci
Learning activities Base
Area Matematica, informatica e statistica
Sector ING-INF/05
Type of study-unit Obbligatorio (Required)
Language of instruction English.
Contents Introduction to information systems and relational databases. Introduction to ERP and CRM software.
Reference texts Lecture notes provided by the teacher.
Educational objectives The educational objective of the course is to acquire basic skills related to information systems, to the design and querying of relational databases, to ERP and CRM software.
Prerequisites Basic knowledge of computer science and programming.
Teaching methods The course includes two main types of lessons.

Lectures: lessons held in the classroom. In each lesson new concepts are taught with the support of projected slides.

Laboratory guided exercises: lessons held in lab. In each lesson the students design and query relational databases under the guidance of the teacher.
Other information None.
Learning verification modality The exam consists of a test of both a theoretical and practical nature.

For information on services for students with disabilities and/or DSA, visit http://www.unipg.it/disabilita-e-dsa.
Extended program Introduction to information systems.
The relational model.
The Structured Query Language (SQL).
Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems.
Fundamentals of Data Warehousing and OLAP techniques.

INTRODUCTION TO COMPUTER SCIENCE AND PROGRAMMING

Code A002906
CFU 6
Lecturer Fabrizio Montecchiani
Lecturers
  • Fabrizio Montecchiani
Hours
  • 54 ore - Fabrizio Montecchiani
Learning activities Base
Area Matematica, informatica e statistica
Sector ING-INF/05
Type of study-unit Obbligatorio (Required)
Language of instruction English.
Contents Basic concepts of computer science, of programming, and of the software development lifecycle. The Python programming language.
Reference texts "Starting out with Python", 5th edition. Tony Gaddis, Pearson.
Educational objectives The course provides some basic concepts of computer science. The fundamental educational objective is to teach the basic elements of programming and of the software life cycle. In particular, Python is used as a reference programming language. In addition, students acquire basic notions regarding the computer architecture and the representation of information.
Prerequisites The course assumes no special prerequisite knowledge.
Teaching methods The course includes two main types of lessons.

Lectures. In each lesson new concepts are taught with the support of projected slides, often with a direct application to programming.

Guided exercises. In each lesson the students design and implement new programs under the guidance of the teacher.
Other information None.
Learning verification modality The exam consists of a theory test and a programming test.

For information on services for students with disabilities and/or DSA, visit http://www.unipg.it/disabilita-e-dsa.
Extended program - Basic concepts of computer science
-- Programs, software, hardware
-- Information representation
-- How programs work
-- Creating programs and using Python

- Programming in Python
-- Printing, comments, variables
-- Input, calculations, strings, constants
-- Control and repetition structures
-- Functions
-- Lists and tuples
-- Files and exceptions
-- Advanced operations with strings
-- Recursion
-- Modules