Portale di Ateneo - En.Unibs.it

Module 1 Basic Excel course (total 8 hours)

Learning Unit 1 - Concepts and basic functions
1. Resize, insert, delete rows and columns
2. Management, insertion, copy of worksheets
3. Formatting cells (character, background, borders, alignment, number formats, custom number formats, excluding date formats)
4. Automatic formatting
5. Parameter notion of a function
6. The sum and average functions
7. Percentage calculations
8. Copying a formula to another cell (copy / paste, drag)
9. Relative and absolute addressing ($ sign)

Teaching Unit 2 - Management of data / statistical functions
1. Sorting of data
2. Automatic filter
3. Advanced filter
4. Validation criteria
5. Subtotals
6. Use of the data entry form
7. The arithmetic-logical functions of excel

Learning Unit 3 - Logical functions
1. The "SE" function is simple
2. The nested "SE" function (simple examples)
3. The "E" and "O" functions
4. Conditional formatting

Teaching Unit 4 - Use of graphs and images
1. Use of charts in Excel
2. Use of the different types of charts
3. The difference between data and labels
4. The function (and the button) enter chart
5. Properties of the constituent elements of the graph (area of ​​the graph, area of ​​the plot, axes, title, labels, etc.)
6. Formatting the different elements of the chart
7. Inserting images (from file / clipart)
8. Inserting diagrams

Module 2 (total 4 hours)

Teaching Unit 5 - Internet Module and Electronic Mail

1. Introduction to telecommunication networks: the Internet
2. Methods of sharing information on the web: the most common protocols
3. Network connection mode (analog modem, ISDN, ADSL or cable)
4. The World Wide Web (WWW)
5. The tools to navigate
6. Web surfing: Browsers
7. Search for information on the web: search engines
8. The world of viruses and antivirus: precautions and control
9. Electronic Mail
10. How Electronic Mail works
11. Email browsers: MS Outlook, thunderbird ...
12. Composition, sending and reading of messages
13. E-mail filters
14. Antispam

Teaching Unit 6 - Bibliographic Research Module

1. Introduction to research methods for medical-scientific publications, example of the Lombard Biomedical Library System (SBBL)

The remaining hours will be used for laboratory exercises in order to put into practice the concepts seen in theory.