AIMS AND CONTENT

LEARNING OUTCOMES

The course aims to introduce the student to the effective and conscious use of spreadsheets for the processing, visualization and analysis of data.

AIMS AND LEARNING OUTCOMES

The course uses software tools with interface and documentation in English.

The course introduces the student to the use of the LibreOffice suite (in particular the Calc spreadsheet), with the aim of making him able to use Calc to process, visualize and analyse data, such as experimental data or acquired from databases available on the network.

TEACHING METHODS

Teaching takes place over 13-14 weeks, each of which normally includes 3 hours of  lessons and/or guided workshops (students are required to have a laptop, and will receive assistance to install the necessary software).

At the end of the semester there could be a pre-exam (with booking and file uploading on AulaWeb), which replaces the exam.

Students who have valid certification of physical or learning disabilities on file with the University and who wish to discuss possible accommodations or other circumstances regarding lectures, coursework and exams, should speak both with the instructor and with Professor Sara Ferrando (sara.ferrando@unige.it), the Department’s disability liaison.

SYLLABUS/CONTENT

The course includes introductory lessons followed by guided workshops, which will be videorecorded.

In detail, the topics covered are:

• basics on operating systems and file systems
• use of compressed archives (zip format)
• general features of spreadsheets
• insertions, import (csv format), editing and formatting of data
• online information: open data, thematic data banks, bibliographic data banks (optional)
• charts for displaying tabular data
• formulas, functions, absolute/relative references, mnemonic names
• filters to hide/rearrange data
• pivot tables to create aggregated data
• export of sheets in pdf format (optional)
• generalities and terminology on data
• data classification
• what-why-how paradigm
• data clean-up
• join operations
• elements of discrete statistics
• visualization tools
• statistical tests
• predictive methods (optional)

RECOMMENDED READING/BIBLIOGRAPHY

The teaching material (including any video recordings) will be made available on aulaweb.

Moreover, one can consult and download documentation in English on LibreOffice from https://documentation.libreoffice.org/en/english-documentation

TEACHERS AND EXAM BOARD

Exam Board

EUGENIO MOGGI (President)

ENRICO PUPPO (President Substitute)

LESSONS

LESSONS START

For the timetable go to the link: https://easyacademy.unige.it/portalestudenti/

Class schedule

The timetable for this course is available here: Portale EasyAcademy

EXAMS

EXAM DESCRIPTION

The exam consists in the analysis done using Calc of data provided by the lecturer (those who passed the pre-exam are exempted).

ASSESSMENT METHODS

The exam verifies the ability to properly use the Calc spreadsheet.

Exam schedule