Informatics and Applications of Medical Informatics
Code
11117
Academic unit
NOVA Medical School|Faculdade de Ciências Médicas
Department
SP
Credits
3
Teacher in charge
Profª Doutora Ana Luísa Papoila
Teaching language
Portuguese
Objectives
· To know and find the main online medical information resources and to know how to search a literature database
· To know how to describe the technology that supports the development of software applications in Medicine
· To know how to describe the design and configuring a database
· To know how to use a spreadsheet and how to organize and structure biomedical research data
Prerequisites
Subject matter
|
Date |
Summary |
T/P |
Teacher |
Location |
|
26-02-2015 |
Information and computation technologies: Computer networks; the Internet and WWW; software architectures- two-tier (client-server), three-tier, n-tier; distributed architectures .NET and B2B systems
|
2 hours, lecture
14:30-16:20 |
Carlos Geraldes |
Informatics Room |
|
05-03-2015 |
Bibliographic databases: Pubmed: setting up a literature research; MeSH. |
2 hours practice
14:30-16:20 |
Amália Marques |
Informatics Room |
|
12-03-2015 |
Bibliographic databases: |
2 hours practice
14:30-16:20 |
Amália Marques |
Informatics Room |
|
19-03-2015 |
Introduction to Bioinformatics: Introduction to biology databases, motivation, types of information. Databases: DNA Sequences, complete genomes: NCBI GenBank
|
2 hours practice
14:30-16:20 |
Pedro Fernandes |
Informatics Room |
|
26-03-2015 |
Introduction to Bioinformatics: Databases: Proteins: sequence - SWISS-PROT; tridimensional structure PDB
|
4 hours practice
14:30-16:20
16:30-18:20 |
Pedro Fernandes |
Informatics Room |
|
09-04-2015 |
Introduction to Bioinformatics: Databases: Metabolism, enzymes, biochemical reactions: KEGG, ENZYME, BRENDA; Mutations, polymorphisms related to disease: OMIM
|
2 hours practice
14:30-16:20 |
Pedro Fernandes |
Informatics Room |
|
16-04-2015 |
DataBase Management Access
Conceptual model
ER - Diagram |
2 hours practice
14:30-16:20 |
Carlos Geraldes |
Informatics Room |
|
23-04-2015 |
DataBase Management Access
Logical Model
Database configuring |
2 hours practice
14:30-16:20 |
Carlos Geraldes |
Informatics Room |
|
30-04-2015 |
DataBase Management Access
Forms |
2 hours practice
14:30-16:20 |
Carlos Geraldes |
Informatics Room |
|
07-05-2015 |
DataBase Management Access
Database queries |
4 hours practice
14:30-16:20 |
Carlos Geraldes |
Informatics Room |
|
14-05-2015 |
Excel Spreadsheet
Getting started with Excel
Formatting cells |
2 hours practice
14:30-16:20 |
Ricardo São João |
Informatics Room |
|
21-05-2015 |
Excel Spreadsheet
Creating Graphics
Formulas |
2 hours practice
14:30-16:20 |
Ricardo São João |
Informatics Room |
|
28-05-2015 |
Excel Spreadsheet
Formulas
Lists of data |
2 hours practice
14:30-16:20 |
Ricardo São João |
Informatics Room |
|
04-06-2015 |
Excel Spreadsheet
Protect data
What-If Analysis |
2 hours practice
14:30-16:20 |
Ricardo São João |
Informatics Room |
Bibliography
Handbook of Biomedical Informatics disponível em:
http://en.wikipedia.org/wiki/Book:Handbook_ of_Biomedical_Informatics
Microsoft Access 2010, António Abreu, Vidal de Carvalho e Ana Azevedo, ISBN 978-989-615-108-9,Mai/2011, Editora Centro Atlântico
Microsoft Access 2013, Mário Paulo Pinto, ISBN 978-989-615-188-1, Out/2013, Editora Centro Atlântico
Teaching method
This curricular unit has duration of 14 weeks, with a total of 32 contact hours distributed by 2 hours (1 lesson) of lectures and 30 hours (13 classes) of practice. Practical lessons consist on the execution of practical exercises using a computer.
Evaluation method
In order to have a grade, students are required to attend a minimum of 10 practical classes. There are no provisions to compensate classes for students who do not achieve the minimum attendance.
Evaluation of student competencies consists of a practical examination where the student will have to demonstrate competencies on the utilization of a spreadsheet and of a relational database.
Courses
