JEB111 - Advanced Data Analysis in MS Excel
|Status:||Bachelors - All
Bachelors - elective
BEF - elective
Semester - summer
Semester - winter
|Course supervisors:|| PhDr. Jakub Mikolášek
|Teachers:|| PhDr. Ihor Kruchynenko
PhDr. Jakub Mikolášek
|Schedule:||To be discussed, probably 2 classes - We, 17:00-19:50 There is only 1 class per week for two groups of students (up to 30 students each) AS THE CAPACITY IS LIMITED TO 2X30 STUDENTS ONLY, STUDENTS OF 2nd YEAR WILL BE GIVEN PRIORITY.|
|Announcements:||Second attempt for Mid-term test will take place on Wednesday, May 22rd in usual classroom 016 at 18:30.
Deadline for submission of the project will be 24:00:00 03.06.2013 (end of exam session). But earlier submission is more then welcome. Please submit the projects to email@example.com.
|Literature:||Craig Stinson, Mark Dodge: Mistrovství v Microsoft Office Excel 2003 (Microsoft excel Inside out), Computer Press. – but any handbook will do. No book is required, but might come handy.|
|Description:||This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MSExcel.
After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
Time and date functions
If, Errors, Sumif, (Sumifs) etc.
Searching (lookup functions, match, index)
Vectors, sumproduct, vector conditions
Filtering, advanced filters
Tips and tricks – how to make life easier
|Examination dates:||Mid-term Test on Wednesday, 19.12.2012, 17:00, room 016
Project to be submitted till 15.1.2013
|Course requirements:||Mid-term test, project|
Excel-functions in English
Project - Assignment
Project - sample
Results - Final
Sample Test 1 + Solution
Sample Test 2 + Solution
Seminar 4 Solution