JEB111 - Advanced Data Analysis in MS Excel
| Credit: | 3 |
|---|---|
| Credit ETCS: | 3 |
| Hours weekly: | 0/2 |
| Status: | Bachelors - All Bachelors - elective BEF - elective English Semester - summer Semester - winter |
| Obligatory courses: | |
| Recommended courses: | |
| Course supervisors: | PhDr. Jakub Mikolášek |
| Teachers: | PhDr. Ihor Kruchynenko PhDr. Jakub Mikolášek |
| Assistants: | |
| 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 kruchynenko@gmail.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. |
| Content: | Introduction Basic Functions Time and date functions Text Functions If, Errors, Sumif, (Sumifs) etc. Searching (lookup functions, match, index) (test) Vectors, sumproduct, vector conditions Filtering, advanced filters Advanced formatting Tips and tricks – how to make life easier Pivot tables (project preparation) (test) |
| Seminar: | |
| 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 |
| Downloadable: | Exam 8 Exam 9 Exam Results Excel-functions in English Project Project - Assignment Project - sample Results - Final Sample Project Sample Test 1 + Solution Sample Test 2 + Solution Sample_Test Seminar 1 Seminar 3 Seminar 4 Seminar 4 Solution Seminar 5 Seminar 6 Seminar 7 Seminar 8 Syllabi |