Data Analysis and Visualization in Spreadsheets

The course is supported by an independent web-site, at the following address: [http://veria.jour.auth.gr/ge6900/]. There is free access for everyone to the home-page, the news page, and the course summary, while for the other areas of the site (course material and bibliography, weekly-lessons program and contents, evaluation methods and results, subjects of projects and past exams), the access is allowed by using personalized access codes for every student.

The final grade of the course is calculated only if there are no absences in the laboratory lessons and it is the result of the individual grades in the following: 1. Exercises during laboratory lessons (20%) 2. Data analysis and visualization project in Microsoft Excel (20%) 3. Final theoretical examination (30%) 4. Final practical examination (30%) Remarks (a) Each individual grade, in order to count towards the final score, should be greater than the corresponding base-score, which is set at half of the corresponding maximum score. b) All laboratory exercises are mandatory. Only two (2) very well-justified absences may be replenished during the semester, after consultation with the instructor, and at the latest within one week of the respective absence. Ensuring transparency in the assessment of student performance Students are informed on a weekly basis about their performance in the laboratory exercises they perform at each (weekly) laboratory lesson by receiving a personalized e-mail in the account provided by the University, and have the possibility -in the context of office hours- to be further informed about their errors and omissions. In the same way they are informed of their performance and their errors / omissions both in the project they deliver and in the final examinations of the theoretical and practical part of the course at the end of the semester.

1) Curtis D. Frye, "Ελληνικό Microsoft Excel 2010, Βήμα-Βήμα", ISBN 978-960-461-407-3, Εκδόσεις Κλειδάριθμος, Αθήνα, 2011. (Κωδικός Βιβλίου στην υπηρεσία Εύδοξος: 12277926) 2. Λουκάς Ζαχείλας, "Χρήση και Εφαρμογές του Ελληνικού Excel 2016", ISBN 978-960-6706-45-5, Εκδόσεις «σοφία» Ανώνυμη Εκδοτική & Εμπορική Εταιρεία, Θεσσαλονίκη, 2017. (Κωδικός Βιβλίου στην υπηρεσία Εύδοξος: 68403374)

1) Steven M. Freund, Joy L. Starks, and Eric Schmieder, "Microsoft Office 365 Excel 2016: Comprehensive" (Shelly Cashman Series), ISBN: 978-1-305-87072-7, Cengage Learning, 2017. 2) David Slager, "Essential Excel 2016: A Step-by-Step Guide", ISBN: 978-1-4842-2160-0, Apress, 2016. 3) Adam Aspin, "High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI", 2nd Edition, ISBN: 978-1-4842-2399-4, Apress, 2016. 4) Curtis D. Frye, "Microsoft Excel 2016, Step by Step", ISBN 978-0-7356-9880-2, Microsoft Press, 2015. 5) Cole Nussbaumer Knaflic, "Storytelling with Data - A data visualization guide for business professionals", ISBN: 978-1-119-00225-3, John Wiley & Sons, Inc., 2015. 6) Paul McFedries, "Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables", 4th Edition, ISBN: 978-1-118-51714-7, Wiley Publishing, Inc., 2013. 7) Riccardo Mazza, "Introduction to Information Visualization", ISBN: 978-1-84800-218-0, Springer, 2009.