Computer Science Course

A.Y. 2020/2021
3
Max ECTS
30
Overall hours
SSD
INF/01
Language
Italian
Learning objectives
The Course provides the basic notions of the computer-science discipline with focus on i) foundations of Computer Science, ii) spreadsheets, iii) information management, and iv) Internet and web. Furthermore, the Course provides skills about the main functionalities of spreadsheet software tools, with focus on the use of formulae, functions, and chart creation.
Expected learning outcomes
The student will acquire a mix of Knowledge and Skills.
Knowledge: the student will learn about i) foundations of Computer Science, ii) spreadsheets, iii) information management, and iv) Internet and web. The part about the foundations of Computer Science includes: historical notions about the computer-science discipline, physical structure and organization of computers, information coding, units of measure of information, definition of algorithm and program, digital representation of text, audio, and video contents, classification of software tools, security issues and risks concerned with the use of digital technologies. The part about spreadsheets includes: spreadsheet definition and structure, functions in Microsoft Excel, statistical functions in Microsoft Excel, chart creation in Microsoft Excel. The part about information management includes: definition of data and information, databases, relational model of databases, database systems, similarities and differences between spreadsheets and relational databases, database languages, query composition, web databases. The part about Internet and web includes: basic notions of computer networks, standard and protocols of computer networks, history and structure of the Internet, web architecture, HTML language, design and structure of search engines.
Course syllabus and organization

Single session

Lesson period
First semester
Course syllabus
The Course program is focused on the following topics:
· Foundations of Computer Science
o Introduction to Computer Science
o Information coding
o Computer structure
o Programs and software
o The "Infosphera" risks
· Spreadsheets
o Introduction to spreadsheets
o General functions in Excel
o Statistical functions in Excel
o Chart creation in Excel
· Information management
o Introduction to information management
o Data storing and databases
o Relational databases
o Database creation
o Query composition
o Web databases
· Internet and web
o Computer networks
o The Internet network
o Web architecture
o Web standards
o Web contents
o Search engines
o Web evolutions
Prerequisites for admission
The Course does not have prerequisites
Teaching methods
The Course is provided as a blended-learning course.
For acquisition of expected knowledge, a student has to browse the program contents on the online course according to an e-learning modality. Contents are organized into the following training courses: G) Foundations of Computer Science, F) Spreadsheets, B) Information management, and I) Internet and web. A training course is then articulated into thematic modules. Students have to pass a self-evaluation test at the end of each thematic module. Initially, a student can access just an introductory module. The access to subsequent modules is progressively enabled when the test of available modules is successfully passed. For acquisition of expected skills, a student can attend two exercise sessions in a computer-science room. Each exercise session is three hours long. The attendance to exercise sessions is not a mandatory requirement for successfully pass the Course and obtain the credits, however students are strongly encouraged to attend the exercise sessions.
Teaching Resources
The teaching stuff is online at https://3cfuinformatica.unimi.it
Assessment methods and Criteria
The examination is articulated in two distinct evaluation steps.
The first evaluation step consists in the successful completion of self-evaluation tests related to all the thematic modules that constitute the training courses. The tests are composed of choice questions on the whole Course program. The completion of all the expected self-evaluation tests is a mandatory requirement for accessing to the subsequent evaluation step (final exam).
The second evaluation step (final exam) consists successfully pass a test in a computer-science room. The test one hour long and it is based on choice questions on the whole Course program. The questions aim to evaluate the expected acquisition of both knowledge and skills. During the test, it is not possible to use paper stuff and to access web resources that are not explicitly authorized. The Course evaluation is expressed through an "Approved" - "Not approved" result. The Academic Exam System (SIFA) is exploited by students for subscription to the final exam and for getting the results of taken exams.
INF/01 - INFORMATICS - University credits: 3
Computer skills assessment: 30 hours