CODE 57279 ACADEMIC YEAR 2022/2023 CREDITS 4 cfu anno 2 SCIENZE BIOLOGICHE 8762 (L-13) - GENOVA SCIENTIFIC DISCIPLINARY SECTOR INF/01 LANGUAGE Italian TEACHING LOCATION GENOVA SEMESTER 1° Semester PREREQUISITES Propedeuticità in ingresso Per sostenere l'esame di questo insegnamento è necessario aver sostenuto i seguenti esami: Biological Sciences 8762 (coorte 2021/2022) INSTITUTIONS OF MATHEMATICS 52344 2021 TEACHING MATERIALS AULAWEB AIMS AND CONTENT LEARNING OUTCOMES The module aims to introduce the student to the effective and conscious use of the most common software tools AIMS AND LEARNING OUTCOMES The module consists of two parts, of 2 credits each. The Computer Science part 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 and visualize data, such as those that can be acquired from databases available on the network. The Bioinformatics part introduces the student to the analysis of biological sequences through computer tools, the use of databases such as ncbi and the visualization of the results obtained with software. PREREQUISITES In order to use spreadsheets properly, the student must have basic mathematical skills and reasoning and analytical skills, typically covered by mathematics courses in the first year. TEACHING METHODS Teaching takes place over 14-16 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) During the semester there will be an assessment on the first part (with booking and file uploading on AulaWeb). SYLLABUS/CONTENT The Computer Science part includes introductory lessons followed by guided workshops on how to find information on the network and process and visualize data using Calc. 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 charts for displaying tabular data formulas, functions, absolute/relative references, mnemonic names filters to hide/rearrange data Pivot Tables to create aggregated data data analysis tools export of sheets in pdf format online information: open data, thematic data banks, bibliographic data banks The Bioinformatics part consists of lectures in which the biological and evolutionary theories underlying the analysis techniques and databases are illustrated, combined with practical sessions in which the techniques taught will be applied. In detail, the topics covered are: biological sequences and their importance from a functional and evolutionary point of view sequence alignment, BLAST replacement matrices main databases of biological resources (NCBI, pubmed, nucleotide, protein, genbank) multiple alignment of sequences concepts of phylogeny: hierarchical clustering, evolutionary distances, linkage molecular phylogeny and reconstruction of phylogenetic trees calculation of statistical strength indices of trees viewing and annotating trees "Horizontal" evolution: phylogenetic reconciliation of horizontal gene transfer events RECOMMENDED READING/BIBLIOGRAPHY The teaching material (including any video recordings) will be made available on aulaweb. It is also possible to consult and download the documentation in English on LibreOffice from https://documentation.libreoffice.org/en/english-documentation TEACHERS AND EXAM BOARD EUGENIO MOGGI Ricevimento: See the aulaweb module and as second alternative the web page https://person.dibris.unige.it/moggi-eugenio/ EMANUELE BOSI Exam Board EUGENIO MOGGI (President) GIANNA REGGIO EMANUELE BOSI (President Substitute) STEFANO ROVETTA (Substitute) LESSONS LESSONS START For the timetable go to the link: https://easyacademy.unige.it/portalestudenti/ Please check the module Aulaweb for timetable updates dependent on the sanitary and epidemic situation. Class schedule ELEMENTS OF INFORMATICS AND BIOINFORMATICS EXAMS EXAM DESCRIPTION The Computer Science exam consists in the analysis by Calc of data provided by the lecturer (those who passed the assessment in the semester are exempted). The Bioinformatics exam requires to carry out a series of analyzes on a biological sequence provided by the lecturer. ASSESSMENT METHODS The Computer Science exam verifies the ability to properly use the Calc spreadsheet. The Bioinformatics exam verifies the ability to analyze biological sequences. Exam schedule Data appello Orario Luogo Degree type Note 16/01/2023 09:00 GENOVA Laboratorio 19/01/2023 15:00 GENOVA Scritto 09/02/2023 15:00 GENOVA Scritto 14/02/2023 09:00 GENOVA Laboratorio 21/02/2023 15:00 GENOVA Scritto 13/06/2023 09:00 GENOVA Laboratorio 15/06/2023 15:00 GENOVA Scritto 06/07/2023 15:00 GENOVA Scritto 21/07/2023 09:00 GENOVA Laboratorio 04/09/2023 15:00 GENOVA Scritto 05/09/2023 09:00 GENOVA Laboratorio 21/09/2023 14:00 GENOVA Scritto