The course aims to provide a solid understanding of the fundamental concepts of computer science and its practical application through the use of spreadsheets.
Students will develop the necessary skills to use spreadsheet software to solve real-world problems and perform data analysis. They will explore various advanced functions and tools of spreadsheets to optimize processes and improve calculation efficiency. Additionally, they will gain familiarity with creating charts and visual representations of data to facilitate communication and interpretation of results.
Teaching Methods
Lectures and practice in the classroom.
Assessment Methods
Final project
Texts
Poli, P. Excel 2019 – Formule e analisi dei dati. Hoepli editore, 2019.
John W. Foreman - Data Smart: Using Data Science to Transform Information into Insight-Wiley (2013)
Contents
Recalls on basic concepts. Graphical interface, menus, and toolbars, data input, and deletion, cell formatting. Data types. Representation of numbers in computers. Usage of electronic spreadsheets. Basic functions, conditional constructs, and logical operators. Advanced functions. Pivot table construction. Data sorting, filtering, and grouping. Macros in the spreadsheet. Macro concept definition. Recording and editing elementary macros. Basic syntax. Spreadsheets and databases. Data import and export, supported formats, limits, and performance. Data visualization. Creation and analysis of different types of charts. Basic numerical methods. Numerical integration. Recommendation systems. Laboratory exercises related to the studied functionalities using real data and applications.
Course Language
Italian
More information
The lessons will take place in a non-computerized classroom, so it is necessary to bring your own laptop.
