SUBJECT
Title
Information technology in health research
Type of instruction
practical
Level
master
Faculty
Part of degree program
Credits
4
Recommended in
Semester 1
Typically offered in
Autumn semester
Course description
The course covers advanced data storage, management (spreadsheets) software for health care research.
Topics include:
- types of data storage,
- spreadsheets as a data storage,
- working with data
- cells, rows, ranges, sheets, workbooks
- formatting cells, ranges, tables
- built in styles, custom number formats
- using basic functions, string, mathematical, statistical etc.
- visualisation, creating, modifying graphs
- inserting pictures and other objects
- advanced functions
- data validation, data protection
- data analysing
- solver
- goal seeking
- Pivot tables
- linking workbooks, external linking
- programming Excel with VBA
- creating custom functions
- using macros
- user forms, user controls
- collecting data from other data sources
- internet, text, xml file
- sql databases
- sql queries
Readings
John Walkenbach Microsoft Excel 2013 Bible, John Wiley & Sons Inc., Indianapolis, Indiana, 2013