- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Introduction to Excel and Economic Data Analysis 2400-INTER-WEXCEL-OG
Detailed subject of the course:
1. Entering and editing data
2. Formatting cells
3. Finding, replacing and cleaning data
4. Designing sheets
5. Formulas in Excel
6. Basic functions (statistical, text, dates and times, good working practices on functions)
7. Advanced functions (logical, search, nested formulas).
8. Working with data (sorting, filtering, data tables)
9. Pivot tables
10. Charts
11. Keyboard shortcuts
12. Business examples
Note 1: classes are held in the form of e-learning (full class materials with solutions and pre-prepared instructional videos explaining the issues discussed - no live classes) on the platform: https://elearning.wne.uw.edu.pl.
Note 2: materials are published once a week in blocks of 5 teaching hours. The course ends in December.
Note 3: The course requires a lot of student work.
Note 4: The software version in the course is Microsoft Office 2021 or 365 (language version: Polish, operating system: Windows). Using an earlier version is possible, but it may cause some difficulties (some functions are missing). The English language version is not a major problem, but the course a different operating system is (e.g. MacOS) due to the limitations of the Office suite (possible lack of necessary software components). The University of Warsaw does not provide participants with the necessary computer hardware or software.
Type of course
Prerequisites (description)
Course coordinators
Learning outcomes
The student gained the ability to use MS Excel independently and to use its versatile possibilities. The topics of the course included, among others the following topics: efficient work in Excel (entering and editing data, finding and replacing data, formatting cells), formulas and functions (relative and absolute references, date and time, text, statistical functions), advanced functions (logical, search, nested functions) ), data browsing (data sorting, data filtering, data tables, sheet formatting), data visualization (various types of charts), data analysis using pivot tables. The listener is able to carry out all stages of work on data - from ordering and processing, through analysis and visualization, to inference.
Assessment criteria
The final grade consists of:
• two collective homework assignments, each scored 30 points
• additional activity in discussion forums
Punctation:
Score points
[0-30) 2
[30-36) 3
[36-42) 3.5
[42-48) 4
[48-54) 4.5
[54-60) 5
from 60 5!
Bibliography
own materials
Additional information
Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes:
- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: