Computer Spreadsheets, Data Analysis in Medical, Dental and Pharmacist Practical Training

Data

Official data in SubjectManager for the following academic year: 2022-2023

Course director

Number of hours/semester

lectures: 12 hours

practices: 0 hours

seminars: 0 hours

total of: 12 hours

Subject data

  • Code of subject: OXFADA-z-T
  • 1 kredit
  • Dentistry
  • Optional modul
  • autumn
Prerequisites:

-

Course headcount limitations

min. 5 – max. 25

Available as Campus course for 25 fő számára. Campus-karok: ÁOK GYTK

Topic

Within the framework of the optional course, students acquire the basic knowledge used in the preparation of lab reports, mainly during their internship. The aim of the course is to get acquainted with the use of spreadsheet application(s), especially Microsoft Excel, from the basics to the implementation of mathematical and statistical functions with a spreadsheet. Students can also use this knowledge in their later studies and work (e.g., research field, medical and pharmacy practice, or as a PhD student, etc.).

Lectures

  • 1. Introduction: matrix-based data set management systems, spreadsheets. Understanding Microsoft Excel and its versions. Excel basics. Concept, handling, filtering of cells, rows and columns. - Zalai Zsófia
  • 2. Data entry, data collection, data modification. Data type of cells. Combining data, data transformation. Cell styles. Import data. Data structure in Excel. Content and form: formatting. Using basic keyboard shortcuts. Other formatting options, insert. - Zalai Zsófia
  • 3. Diagrams. Types of graphs. The purpose of the analysis and the selection of the appropriate chart type. - Zalai Zsófia
  • 4. Characterization of diagrams, modes of representation. Scaling and data labels. Format charts. Biaxial and mixed representation. - Dr. Bugyi Beáta
  • 5. Formulas and functions. Their operation and arguments. Compatibility. Introducing the most useful functions. Dynamic data. Reference to workbook, worksheet, functions. Handling bad functions. Intersection points. - Dr. Bugyi Beáta
  • 6. Data analysis, models. Data integrity. Identify the required data structures and functions. Grouping data within a model. - Dr. Bugyi Beáta
  • 7. Regression, fitting. The most common regression representation and analysis: linear regression. Linear trend line. Understanding and using the equation of a line in Excel. Example task and representation. - Dr. Bukovics Péter
  • 8. Logistic regression. Understanding and using the logistic function in Excel. Example task. - Tempfliné Pirisi Katalin Erzsébet
  • 9. Exponential regression. Understanding and using the exponential function in Excel. Example task. - Tempfliné Pirisi Katalin Erzsébet
  • 10. Automating Repetitive Tasks: Macros. Add and edit a macro. Create some useful macros. Learn about additional features. Links. Sheet and booklet protection. - Tempfliné Pirisi Katalin Erzsébet
  • 11. Useful Excel Tips and Tricks. Summary of lessons learned. - Dr. Bukovics Péter
  • 12. End-semester test / exam. - Dr. Bukovics Péter

Practices

Seminars

Reading material

Obligatory literature

Literature developed by the Department

LinkedIn: Learning Excel;
Microsoft Press: Data Analysis Fundamentals with Excel;
Udemy: Learn The 10 Most Powerful Microsoft Excel Tips and Tricks;
Udemy: Microsoft Excel - Excel from Beginner to Advanced.

Notes

Optional: In addition to consultation with students at the beginning of the semester, it is also possible to hold two-week block courses of the course. 2 x 45 minutes = 90 minutes lecture every two weeks and 2 x 45 minutes = 90 minutes practice every two weeks.

Recommended literature

Excel Formulas and Functions for Dummies (3rd Edition)
Statistical Analysis with Excel for Dummies

Conditions for acceptance of the semester

Maximum of 25 % absence allowed

Mid-term exams

At the end of the semester, a written / computer-based practical end-semester test is required during the final week of the course at regular time (week 12). Students will receive a recommended exam grade for completing the course.

Making up for missed classes

When multiple groups start in another group. In case of multiple absences of several students, only one extraordinary (extra-curricular) occasion during a semester, in consultation with students.

Exam topics/questions

1. Introduction: matrix-based data set management systems, spreadsheets. Understanding Microsoft Excel and its versions. Excel basics. Concept, handling, filtering of cells, rows and columns.
2. Data entry, data collection, data modification. Data type of cells. Combining data, data transformation. Cell styles. Import data. Data structure in Excel. Content and form: formatting. Using basic keyboard shortcuts. Other formatting options, insert.
3. Diagrams. Types of graphs. The purpose of the analysis and the selection of the appropriate chart type.
4. Characterization of diagrams, modes of representation. Scaling and data labels. Format charts. Biaxial and mixed representation.
5. Formulas and functions. Their operation and arguments. Compatibility. Introducing the most useful functions. Dynamic data. Reference to workbook, worksheet, functions. Handling bad functions. Intersection points.
6. Data analysis, models. Data integrity. Identify the required data structures and functions. Grouping data within a model.
7. Regression, fitting. The most common regression representation and analysis: linear regression. Linear trend line. Understanding and using the equation of a line in Excel. Example task and representation.
8. Logistic regression. Understanding and using the logistic function in Excel. Example task.
9. Exponential regression. Understanding and using the exponential function in Excel. Example task.
10. Automating Repetitive Tasks: Macros. Add and edit a macro. Create some useful macros. Learn about additional features. Links. Sheet and booklet protection.
11. Useful Excel Tips and Tricks. Summary of lessons learned.
12. End-semester test / exam.

Examiners

Instructor / tutor of practices and seminars

  • Dr. Bugyi Beáta
  • Dr. Bukovics Péter
  • Tempfliné Pirisi Katalin Erzsébet
  • Zalai Zsófia