Laboratories
A.Y. 2024/2025
Learning objectives
Teaching aims to provide students with the basics of:
- acquire expertise to develop complex bibliography research strategies in your own disciplines, using both freely available tools on the network and resources provided by the University
- acquire skills for using excel software
- acquire expertise to develop complex bibliography research strategies in your own disciplines, using both freely available tools on the network and resources provided by the University
- acquire skills for using excel software
Expected learning outcomes
Teaching aims to provide students with the basics of:
- acquire expertise to carry out bibliography research on databases, tabular and process research results on their own
- acquire expertise to carry out bibliography research on databases, tabular and process research results on their own
Lesson period: Open sessions
Single course
This course can be attended as a single course.
Course syllabus and organization
Single session
Course syllabus
MODULE 1 - RICERCA BIBLIOGRAFICA
Teaching workshop on bibliographic research:
Resources for Health Research in the University Digital Library
Methods for bibliographic research
PubMed: database structure, searching tools, retrieval of results
Embase: database structure, searching tools,retrieval of results
Hints on other online databases and resources for health research
MODULE 2 - EXCEL
The course program is structured as follows.
- Lecture 1: "Construction of a questionnaire for data collection": design of a research question; identification of endpoints, outcomes and independent variables; implementation of the questionnaire in Google Forms; administration to target population.
- Lesson 2: "Guide to Analysis in Excel": constructing frequency tables and graphs for nominal and ordinal qualitative v.; constructing frequency tables and graphs for discrete and continuous quantitative v.; position and scatter indices; testing averages and testing proportions; correlation; hints of linear regression.
- Group work: choice of topic to be explored by each group; transposition of objectives into a questionnaire; sending q. to target population; analysis of results and insights/tutoring on Excel; presentation and export of results; organization of final presentation; final presentation.
MODULE 3 - PEDAGOGICAL LABORATORY
The program is peculiar to the topic of the lesson.
Teaching workshop on bibliographic research:
Resources for Health Research in the University Digital Library
Methods for bibliographic research
PubMed: database structure, searching tools, retrieval of results
Embase: database structure, searching tools,retrieval of results
Hints on other online databases and resources for health research
MODULE 2 - EXCEL
The course program is structured as follows.
- Lecture 1: "Construction of a questionnaire for data collection": design of a research question; identification of endpoints, outcomes and independent variables; implementation of the questionnaire in Google Forms; administration to target population.
- Lesson 2: "Guide to Analysis in Excel": constructing frequency tables and graphs for nominal and ordinal qualitative v.; constructing frequency tables and graphs for discrete and continuous quantitative v.; position and scatter indices; testing averages and testing proportions; correlation; hints of linear regression.
- Group work: choice of topic to be explored by each group; transposition of objectives into a questionnaire; sending q. to target population; analysis of results and insights/tutoring on Excel; presentation and export of results; organization of final presentation; final presentation.
MODULE 3 - PEDAGOGICAL LABORATORY
The program is peculiar to the topic of the lesson.
Prerequisites for admission
For the "Bibliographic research" and "Excel" modules laboratory, basic knowledge on the use of the office package and skills in knowing how to surf the internet are required.
Attendance and / or inclusion in the study plan of the teaching Progettazione e gestione dei processi formativi is recommended for the teaching workshop.
Attendance and / or inclusion in the study plan of the teaching Progettazione e gestione dei processi formativi is recommended for the teaching workshop.
Teaching methods
MODULE 1 - RICERCA BIBLIOGRAFICA
The teaching workshop on bibliographic research is delivered in a blended mode through:
- Lectures in asynchronous mode, through the completion of a lab on Moodle platform, available from Ariel
- Guided classroom exercises
- Individual and group exercises carried out at home on topics assigned by the teachers. Individual exercises provide for collective corrections in the classroom, the group exercises provide for the presentation of the groups to the class
MODULE 2 - EXCEL
Students will be divided into working groups of about 4-5 students. The group's work during the lab activity will involve designing a questionnaire to answer a research question of their choice, followed by administering the questionnaire to the target population and analyzing the data in Microsoft Excel. In addition, a guided exercise will be conducted in the classroom that will include the statistical analysis of a database provided by the lecturers, using Excel software.
The teaching is delivered through face-to-face lectures in the computer classroom.
The questionnaire will be implemented in Google Forms. It is required to have at least one Google account per group.
The software used for data processing is Microsoft Excel (not Google Sheets), which is present on the PCs in the classroom. It is not necessary to bring your own laptop to the classroom. To conduct the exercises outside the classroom setting, students can use Microsoft Excel from the Office 365 Education package free of charge by logging in from a browser at office.com with University credentials (@unimi.it, @studenti.unimi.it).
In the Lab Team on Academic Microsoft Teams, to which students will be added before the start of the course, the following will be available: (i) group-specific channels, on which students can interact with each other for analysis and study; (ii) the channel with teaching materials, i.e., PDF slides and the test dataset; and (iii) the Questions & Answers channel for interaction with faculty.
Teaching materials and further notices will also be replicated on the Ariel platform.
The final presentation will be conducted in Microsoft PowerPoint or related, with export of results from Microsoft Excel.
A theoretical review of the basic concepts of descriptive and inferential statistics will also be possible.
MODULE 3 - PEDAGOGICAL LABORATORY
The training path engages the student for a total of 2 CFU, equal to 50 hours of face-to-face activities and aims to provide advanced training to intervene competently in the didactic-training processes in the areas relevant to the different health profiles included in the Class of Rehabilitation for the conduct of a classroom lesson in an academic context lasting at least 2 hours.
The activity can be carried out in convention centers under the guidance of a Tutor, proposed by the student, appointed by the Lecturer in charge and chosen from among the Professors and Researchers of the University of Milan; and / or between Contract Professors of Health Degree Courses and / or between Professors of Masters and Postgraduate Courses, with an adequate profile, curriculum and proven experience in the didactic-training field.
The teaching workshop on bibliographic research is delivered in a blended mode through:
- Lectures in asynchronous mode, through the completion of a lab on Moodle platform, available from Ariel
- Guided classroom exercises
- Individual and group exercises carried out at home on topics assigned by the teachers. Individual exercises provide for collective corrections in the classroom, the group exercises provide for the presentation of the groups to the class
MODULE 2 - EXCEL
Students will be divided into working groups of about 4-5 students. The group's work during the lab activity will involve designing a questionnaire to answer a research question of their choice, followed by administering the questionnaire to the target population and analyzing the data in Microsoft Excel. In addition, a guided exercise will be conducted in the classroom that will include the statistical analysis of a database provided by the lecturers, using Excel software.
The teaching is delivered through face-to-face lectures in the computer classroom.
The questionnaire will be implemented in Google Forms. It is required to have at least one Google account per group.
The software used for data processing is Microsoft Excel (not Google Sheets), which is present on the PCs in the classroom. It is not necessary to bring your own laptop to the classroom. To conduct the exercises outside the classroom setting, students can use Microsoft Excel from the Office 365 Education package free of charge by logging in from a browser at office.com with University credentials (@unimi.it, @studenti.unimi.it).
In the Lab Team on Academic Microsoft Teams, to which students will be added before the start of the course, the following will be available: (i) group-specific channels, on which students can interact with each other for analysis and study; (ii) the channel with teaching materials, i.e., PDF slides and the test dataset; and (iii) the Questions & Answers channel for interaction with faculty.
Teaching materials and further notices will also be replicated on the Ariel platform.
The final presentation will be conducted in Microsoft PowerPoint or related, with export of results from Microsoft Excel.
A theoretical review of the basic concepts of descriptive and inferential statistics will also be possible.
MODULE 3 - PEDAGOGICAL LABORATORY
The training path engages the student for a total of 2 CFU, equal to 50 hours of face-to-face activities and aims to provide advanced training to intervene competently in the didactic-training processes in the areas relevant to the different health profiles included in the Class of Rehabilitation for the conduct of a classroom lesson in an academic context lasting at least 2 hours.
The activity can be carried out in convention centers under the guidance of a Tutor, proposed by the student, appointed by the Lecturer in charge and chosen from among the Professors and Researchers of the University of Milan; and / or between Contract Professors of Health Degree Courses and / or between Professors of Masters and Postgraduate Courses, with an adequate profile, curriculum and proven experience in the didactic-training field.
Teaching Resources
MODULE 1 - RICERCA BIBLIOGRAFICA
No textbooks are to be adopted; for the teaching workshop on bibliographic research teaching materials (mainly in video format) are available on Moodle.
MODULE 2 - EXCEL
Teaching materials will be provided by the Lecturers and available on the University's Ariel site and Teams platform.
MODULE 3 - PEDAGOGICAL LABORATORY
The reference material and the bibliography are specific in relation to the topic of the lesson.
No textbooks are to be adopted; for the teaching workshop on bibliographic research teaching materials (mainly in video format) are available on Moodle.
MODULE 2 - EXCEL
Teaching materials will be provided by the Lecturers and available on the University's Ariel site and Teams platform.
MODULE 3 - PEDAGOGICAL LABORATORY
The reference material and the bibliography are specific in relation to the topic of the lesson.
Assessment methods and Criteria
MODULE 1 - RICERCA BIBLIOGRAFICA
For the teaching workshop on bibliographic research, the expected learning outcomes are assessed through a classroom presentation of the methodological steps of a bibliographic search concerning a specific a topic, and by a written test consisting of carrying out a literature search. Failure to pass the written test will result in the requirement to repeat the workshop the following year.
MODULE 2 - EXCEL
The final test will consist in a presentation of the work done by each group. The maximum duration of the presentation will be 20 minutes: this test will be evaluated in the modalities passed/not passed by the Lecturers.
The presentation should be structured as follows:
- Brief introduction (theoretical problem, aims and measurement of the objective)
- Presentation of the questionnaire (structure, measured variables and outcome variable)
- Descriptive analysis of the results, presenting the outcome of the questions in graphical and tabular form
- Inferential analysis of the outcome in relation to the measured variables (at least one hypothesis test)
- Discussion of the results in relation to the objective and initial hypotheses
The presentation of results by each member of the group is a necessary condition for passing the test.
MODULE 3 - PEDAGOGICAL LABORATORY
The final test consists in carrying out the lesson in the classroom and in the evaluation by both the learners and the tutor guide.
For the teaching workshop on bibliographic research, the expected learning outcomes are assessed through a classroom presentation of the methodological steps of a bibliographic search concerning a specific a topic, and by a written test consisting of carrying out a literature search. Failure to pass the written test will result in the requirement to repeat the workshop the following year.
MODULE 2 - EXCEL
The final test will consist in a presentation of the work done by each group. The maximum duration of the presentation will be 20 minutes: this test will be evaluated in the modalities passed/not passed by the Lecturers.
The presentation should be structured as follows:
- Brief introduction (theoretical problem, aims and measurement of the objective)
- Presentation of the questionnaire (structure, measured variables and outcome variable)
- Descriptive analysis of the results, presenting the outcome of the questions in graphical and tabular form
- Inferential analysis of the outcome in relation to the measured variables (at least one hypothesis test)
- Discussion of the results in relation to the objective and initial hypotheses
The presentation of results by each member of the group is a necessary condition for passing the test.
MODULE 3 - PEDAGOGICAL LABORATORY
The final test consists in carrying out the lesson in the classroom and in the evaluation by both the learners and the tutor guide.
Educational website(s)
Professor(s)