39176 - Basic and Laboratory Informatics

Academic Year 2022/2023

  • Docente: Stefano Russo
  • Credits: 3
  • SSD: INF/01
  • Language: Italian
  • Teaching Mode: Traditional lectures
  • Campus: Bologna
  • Corso: First cycle degree programme (L) in Biomedical Laboratory techniques (cod. 8484)

    Also valid for First cycle degree programme (L) in Midwifery (cod. 9201)

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. The student also possesses basic knowledge on the use of spreadsheets (operations, functions, graphs), and database management (construction of tables, relationships, masks, and queries).

Course contents

A) Fundamentals of computer science (3 hours)

  • The computer, the algorithm, the software
  • Computer and Internet networks

B) Introduction to health informatics (4 hours of which only 3 for the degree course in obstetrics)

  • Main areas of information technology in health activities
  • Dematerialization of documents in the clinical-health field.Life cycle of the electronic document Digital archives and conservation of medical documents in public health organizations (document types, storage times)
  • Protection and processing of health data
  • Software for the management of laboratory activities (only for the Degree Course in Biomedical Laboratory Techniques)

C) How to organize, process and analyze biometric and clinical data with spreadsheets (12 hours)

  • Organize, synthesize, process, analyze and represent data with MS-Excel
  • Import / Export data Export data to the R platform for statistical analysis (formats)
  • Create, store and share spreadsheets with Google Drive and Microsoft OneDrive

D) How to organize and manage archives with databases (11 hours - only for the Degree Course in Biomedical Laboratory Techniques)

  • Archives and databases
  • Database architecture
  • Relational model
  • Design a database
  • Create a database with MS-Access

E) Cone search and select medical-scientific information on the Net (4 hours)

  • Search the Net for medical information
  • Specialized and multi-resource websites
  • Use of search engines and advanced search
  • Evaluate the reliability of the results and their usability
  • Public Access Online Catalogs (OPAC)
  • Databases (generalist and specialized for medicine)

F) How to present and communicate on screen the data processed with Excel at a forum (2 hours)

  •  How to import search data from spreadsheet into MS-PowerPoint and create slides

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

- Educational materials and exercises available on the e-learning platform.

Teaching methods

Frontal lessons on the theoretical part. Presentations of the applications to be known. Free and guided computer exercises.

As concerns the teaching methods of this course unit, all students must attend Module 1, 2 [https://www.unibo.it/en/services-and-opportunities/health-and-assistance/health-and-safety/online-course-on-health-and-safety-in-study-and-internship-areas] on Health and Safety online.

Assessment methods

There is a written test that will take place with the computer in a single session. The test consists of a test with questions (multiple choice) and possible exercises. The test aims to ascertain the possession of the knowledge and skills acquired. The time for the test is forty minutes.

The written test is assessed with a mark expressed out of thirty which will average with the physics and statistics mark. The student will be awarded only one grade for the integrated course of Physics, Statistics and Computer Science by the lecturer.

Teaching tools

Learning control questionnaires.

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

Use of contents (textual and multimedia teaching materials, videos, exercises) available to students enrolled on the e-learning platform.

Online Educational Resources: Sitography.

Office hours

See the website of Stefano Russo

SDGs

Quality education

This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.