79540 - Computer Lab

Learning outcomes

The student acquires the ability to use computer tools as means of processing and communicating information.

Course contents

MODULE I - Basic IT concepts necessary to understand the digital world with particular reference to the health sector. Computerized management of documents: technical, regulatory and documentary indications.

• Foundations of Informatics

1. The computer, the algorithm, the software
2. Computer and Internet networks

• Introduction to health informatics

1. Areas of information technology in health activities
2. Dematerialization of documents in the clinical-health field.
3. Life cycle of the electronic document Digital archives and conservation of medical documents in public health organizations (document types, storage times)
4. Protection and processing of health data

MODULE II - How to organize, process and analyze data with spreadsheets

• Features and functions of MS-Excel

1. Organize and summarize data in tables and prospects
2. Processing data (calculation operators, functions, Pivot tables)
3. Introduction to tools for performing complex data analysis
4. Represent data with graphs
5. Import data into other applications
6. Export data to other applications and to the R platform for statistical analysis (formats)

• Create spreadsheets with Google Docs and Microsoft Online
  

• Store and share spreadsheets with Google Drive and Microsoft OneDrive

MODULE III - Text processing

• Electronic writing

1. Word processing software
2. Text file formats
3. Advanced features and functions of MS-Word
4. Store and share text documents with Google Drive and Microsoft OneDrive

MODULE IV - How to organize and manage databases with databases

• Archives and databases

1. Database architecture
2. Relational model
3. Design a database
4. Create a database with MS-Access
   

• Store and share databases with Google Drive and Microsoft OneDrive

MODULE V - Cone search and select medical-scientific information on the Net - How to present and communicate on screen the data to a forum.

• Search the Network for information

1. Specialized and multi-resource websites
2. Use of search engines
3. How to set up a search Evaluate the reliability of the results and their usability
4. Search strategies (word search, thesauri, use of Boolean logic operators, etc.)
5. Search engines - Advanced features
6. Online Public Access Catalogs (OPAC)
7. Databases (generalist and specialized for medicine)

• How to import research data from the MS-PowerPoint spreadsheet and present it
• Main functions of MS-PowerPoint

Readings/Bibliography

MODULO I:

• A. Rossotti, Informatica Medica, McGraw-Hill Education, Milano, 2015. Capp. 2 (Hardware) - 3 (Software) - 4 (Rete dati sanitarir) - 5 (Firma digitale e posta certificata) -7 (Linguaggi per l'integrazione) -12 (Cartella clinica elettronica) -13 (Fascicolo saniratio elettronico).
  

MODULO II:

• M. Mezzini, Informatica di base, Maggioli Editore, 2016. Cap. 5. (Archivi e tabelle).
  
• A. Clerici, Manuale di informatica per l'economia, Egea, Milano 2014. Cap. 4 (Convetti di base del foglio elettronico) - 5 (Creare un foglio di calcolo efficace) - 6 (Calcoli e funzioni in Microsoft Excel) - 7 (Analisi dei dati in Microsoft Excel).
  

MODULO III:

• M. Mezzini, Informatica di base, Maggioli Editore, 2016. Cap. 6 (Elaborazione dei testi).
  

MODULO IV:

• S. Allegrezza, Analisi e gestione delle basi di dati, Edizioni Simpro, 2010.
• A. Rossotti, Informatica Medica, McGraw-Hill Education, Milano, 2015. Capp. 9 (Basi di dati sanitarie).
  

MODULO V:

• M. Mezzini, Informatica di base, Maggioli Editore, 2016. Cap. 8 (Collaborazione on-line)
  
• A. Clerici, Manuale di informatica per l'economia, Egea, Milano 2014. Cap. 8 (La condivisione delle informazioni e la collaborazione mediate dalle ICT)

Teaching methods

The course includes lectures and online with the aid of multimedia tools for some topics of Module I and practical laboratory activities to be carried out with word processing, calculation and database software on modules II, III, IV, V. There will be structured exercises on the various applications subject to the laboratory activity.

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

The assessment of the knowledge and skills acquired by the learner takes place through an end-of-course exam with a mark out of thirty.

The exam consists of two written tests (carried out on the computer) and a possible oral interview.

Written tests consist of multiple choice question, multiple choice, true or false statement, open answer, word association, personalized question and / or any exercises to be performed.

The first test aims to verify the basic knowledge acquired on basic IT concepts in the healthcare sector. 

The second test aims to verify the skills acquired on the use of the software used in the laboratory activity.

The outcome of the exam (expressed with a mark out of thirty) will be determined overall by the evaluation of the two written tests and by the possible oral interview.

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 on the delivery platform.

Online teachings for registered students.

Online Educational Resources: Sitography

Office hours

See the website of Stefano Russo