79540 - Computer Lab

Learning outcomes

The student acquires the ability to use IT 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

Reference bibliography

MODULE I: A. Rossotti, Medical Informatics, McGraw-Hill Education, Milan, 2015. Capp. 2 (Hardware) - 3 (Software) - 4 (Sanitarir data network) - 5 (Digital signature and certified mail) -7 (Language for integration) -12 (Electronic clinical record) -13 (Electronic sanitary file).

MODULE II: M. Mezzini, basic computer science, Maggioli Editore, 2016. Chapter 5. (Archives and tables). A. Clerici, Handbook of information technology for the economy, Egea, Milan 2014. Chapter 4 (Basic conventions of the spreadsheet) - 5 (Creating an effective spreadsheet) - 6 (Calculations and functions in Microsoft Excel) - 7 (Data analysis in Microsoft Excel).

MODULE III: M. Mezzini, Basic Computer Science, Maggioli Editore, 2016. Chap. 6 (Elaboration of texts).

MODULE IV: S. Allegrezza, Analysis and management of databases, Editions Simpro, 2010. A. Rossotti, Medical Informatics, McGraw-Hill Education, Milan, 2015. Capp. 9 (Health data bases).

MODULE V: M. Mezzini, Basic Computer Science, Maggioli Editore, 2016. Chapter 8 (On-line Collaboration) A. Clerici, Handbook of information technology for the economy, Egea, Milan 2014. Chapter 8 (Information sharing and collaboration mediated by ICT)

Sitography The reference sitography on each module will be indicated on the on-line Teaching platform.

Teaching methods

The course includes classroom lectures 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 are structured exercises on the various applications covered by the laboratory activity.

Assessment methods

The assessment of the knowledge and skills acquired by the learner takes place through an exam at the end of the course with a mark expressed in thirtieths. The exam consists of two written tests (performed at the computer) and from possible oral interview. Written tests consist of tests with multiple choice questions, multiple answers, true or false affirmation, open answer, association of words, personalized question and / or any exercises to be performed. The first test is aimed at verifying the knowledge of the dase acquired on the basic concepts of computer science in the health sector. The second test aims to verify the skills acquired on the use of software used in laboratory activities. The outcome of the examination (expressed with marks in thirtieths) will be determined overall by the evaluation of the two written tests and from the possible oral interview.

Teaching tools

Entry questionnaire in electronic mode.

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

Use of content (text and multimedia teaching materials, videos, exercises) available on the delivery platform Online courses for registered students.

Educational Resources on the Net: Sitography.

Office hours

See the website of Stefano Russo