INTRODUCTION TO CODING AND DATABASE TECHNOLOGY MOD.1

This course offers an introduction to the basics of computer programming. Specifically, the course uses the Python programming language.

The aim is to provide students with an adequate knowledge of general computer science concepts, and the acquisition of specific knowledge and mastery of the basics of Python programming.

Basic computing knowledge (basic functions of the operating system, web browsing, e-mail, Office working suites).

Introduction to Computers and Programming:
¥ what computer science is
¥ how a computing device/computer interacts
¥ Input, processing and output

Introduction to problem solving and programming:
¥ Problem Solving
¥ Algorithms
¥ How to write a program: pseudocode and flowcharts
¥ Outline of a programming language for them all
¥ Exploring and familiarize with the programming environment (Google Colab)

Working with data in Python:
¥ how to write basic Python programs with atomic statements;
¥ how to interpret Python programs;
¥ how to test Python programs;
¥ how to import relevant Python packages

Data structures in Python:
¥ simple and compound data in Python;
¥ how to manage simple data in Python (e.g., integers, strings)
¥ how to manage Python compound data (e.g, lists, dictionaries, tuples and further data);

Interacting with data structures
¥ Conditionals and loops
¥ Iterators
¥ Functions, Modules and Packages

Interacting with different data (outside Ptyhon)
¥ Working with different files (text, csv)
¥ Working with regular expression (re)

(This outline may be subject to change)

Material and slides supplied by the teacher.
Conceptual Programming with Python, 1st Edition. Thorsten Altenkirch and Isaac Triguero, University of Nottingham.
Think Python 2nd Edition by Allen B. Downey

There will be regular assignments. The exam for modules 1 and 2 is unique, consisting of a 12-credit exam with grades in thirtieths. The minimum passing grade is 18.
The exam is a written test mainly consisting of programming exercises (for the Module1); It will be done using personal computers, with the programming environment utilized during the course (Google Colaboratory).

Grading Criteria:

- Grades below 18: Failure to pass the exam, indicating insufficient knowledge and understanding of course topics.
- Grades in the 18-22 range: Sufficient knowledge and understanding of course topics with reference to the syllabus, along with a sufficient level of performance in in-class and at-home activities.
- Grades in the 23-25 range: Satisfactory knowledge and ability to understand course topics, along with a satisfactory level of performance in activities both in class and at home.
- Grades in the 27-30 range: Good or very good knowledge and understanding of course topics with reference to the syllabus, along with a good level of performance in activities both in class and at home.

Il corso viene offerto in modalità blended. Ci saranno sia lezioni frontali, per l'acquisizione dei concetti teorici, che lezioni focalizzate su esercizi pratici.
Nella didattica verranno utilizzati gli strumenti messi a disposizione dalla piattaforma Moodle (chat, wiki, workshop, peer-review) e altri servizi online complementari.
Use of interactive tool for sharing data and snippets of code (Google Colaboratory)

English

IIit is highly recommended to attend the in-person course. Those unable to attend should contact the instructor to arrange an alternative schedule.

written