Computer Skills
A.Y. 2019/2020
Learning objectives
The Lab provides the basic notions of the computer-science discipline with focus on i) Internet and web, ii) information management. Furthermore, the Lab provides skills about i) search-engine organization and querying, ii) information filtering and retrieval of relational data sources.
Expected learning outcomes
The student will acquire a mix of Knowledge and Skills.
Knowledge: the student will learn about i) Internet and web, ii) information management. 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. 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.
Skills: the student will acquire the following skills:
· Understanding of search-engine structure and organization
· Use of basic and advanced functionalities for search-engine querying
· Understanding of model and constraints of relational databases
· Use of the SQL language for relational database querying
Knowledge: the student will learn about i) Internet and web, ii) information management. 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. 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.
Skills: the student will acquire the following skills:
· Understanding of search-engine structure and organization
· Use of basic and advanced functionalities for search-engine querying
· Understanding of model and constraints of relational databases
· Use of the SQL language for relational database querying
Lesson period: Open sessions
Single course
This course cannot be attended as a single course. Please check our list of single courses to find the ones available for enrolment.
Course syllabus and organization
Single session
Course syllabus
The Lab program is focused on the following topics:
· 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
· 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
· Information management
o Introduction to information management
o Data storing and databases
o Relational databases
o Database creation
o Query composition
o Web databases
Prerequisites for admission
The Lab does not have prerequisites
Teaching methods
The Lab 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: I) Internet and web, B) Information management. 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 has to attend two exercise sessions in a computer-science room. Each exercise session is three hours long. The attendance to exercise sessions is a mandatory requirement for successfully pass the Lab and obtain the credits.
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: I) Internet and web, B) Information management. 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 has to attend two exercise sessions in a computer-science room. Each exercise session is three hours long. The attendance to exercise sessions is a mandatory requirement for successfully pass the Lab and obtain the credits.
Teaching Resources
The teaching stuff is online at https://3cfuinformatica.unimi.it
Assessment methods and Criteria
An online examination modality is defined through 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 Lab program. The questions aim to evaluate the expected acquisition of both knowledge and skills. The completion of all the expected self-evaluation tests is a mandatory requirement for successfully pass the Lab and obtain the credits.
The Lab evaluation is expressed through an "Approved" - "Not approved" result. The Lab has a biannual edition, one in the first Academic Semester and one in the second Academic Semester. Each edition has a prefixed deadline for i) completion of all the expected self-evaluation tests, and ii) attendance of the two exercise sessions in a computer-science room. After the deadline, students that passed the above two requirements directly receive the credits on the career. The deadline associated with each Lab edition is available on the Lab website.
The Lab evaluation is expressed through an "Approved" - "Not approved" result. The Lab has a biannual edition, one in the first Academic Semester and one in the second Academic Semester. Each edition has a prefixed deadline for i) completion of all the expected self-evaluation tests, and ii) attendance of the two exercise sessions in a computer-science room. After the deadline, students that passed the above two requirements directly receive the credits on the career. The deadline associated with each Lab edition is available on the Lab website.
INF/01 - INFORMATICS - University credits: 3
Lessons: 20 hours