16692 - Computer Science Lab-based Course (G.F)

Learning outcomes

At the end of the course the student: - has the knowledge to understand the fundamental structure of the Internet as a packet-switched network and the main services offered by the World Wide Web such as e-mail, instant messaging, remote connections, the evolution of social network services or Web2, the processes of searching for information on the Web; - will also have basic knowledge on the use of spreadsheets (operations, functions, graphics), and database management (construction of tables, relations, forms, and queries).

Course contents

Basic concepts of computer science

• Meaning and implications of the term digital
• The computer: nature, denomination and functions
• The computer general executor of algorithms
  
• From the algorithm to the computer program: introduction to coding and computational thinking
• Programming and structuring languages
• Architecture of a computer

Internet

• Computer networks and the Internet
• Services offered by the Network
• Web architecture and standards
• Evolution of the Web
• Social network services
• Copyright on the Internet

How to search for information on the web

•  Digital resources 
• Where and how to find digital resources
• Search engines and how they work
• Plan and carry out an online search
• Evaluate the information
• Check the credibility of the sources

How to represent, process data with spreadsheets

• Data entry
• Data formatting
• Formulas and functions •
• Cell references and formulas
• Sort and link data
• Search and select data in a list (filters)
• Protect your data
• Management and printing of sheets

How to organize and manage archives with databases

• Archives and databases
• Architecture of a database
• Relational model
• Design a database
• Create a database

In particular, in this workshop, once the basic principles of computer science and programming have been provided, the topic of coding in kindergarten is introduced. We will propose some unplugged coding activities (without the use of electronic devices) suitable to initiate the child to the maturation of computational thinking with games that rely on the metaphor of programming.

Readings/Bibliography

Readings/Bibliography

- Curtin - Foley - Sen - Morin, edizione italiana a cura di A. Marengo Alessandro Pagano, Informatica di base. Con aggiornamento online. Con e-book, 6 edizione, McGraw-Hill Education, Milano, 2016.

-Alessandro Bogliolo, A scuola con CodyRoby. Il coding come gioco di ruolo, Giunti Scuola, Milano, 2020.

Teaching methods

As concerns the teaching methods of this course unit, all students must attend Module 1, 2 on Health and Safety online

Assessment methods

Individual and / or group work.

Teaching tools

Learning control questionnaires.

Online collaborative teaching tools to integrate traditional classroom teaching activities: Moodle platform, forum, chat, web conf .. wiki.

Use of content (text and multimedia teaching materials, videos, exercises) available on the delivery platform Online courses for registered students.

Educational Resources on the Net: Sitography.

Office hours

See the website of Stefano Russo