Data Analysis and Visualization in Spreadsheets

Course Information
TitleΑνάλυση και Οπτικοποίηση Δεδομένων σε Υπολογιστικά Φύλλα (Θ/Α) / Data Analysis and Visualization in Spreadsheets
CodeGE6900
FacultySocial and Economic Sciences
SchoolJournalism and Mass Communications
Cycle / Level1st / Undergraduate
Teaching PeriodWinter
CoordinatorConstantinos Barbargires
CommonNo
StatusActive
Course ID600014356

Programme of Study: UPS School of Journalism and Mass Communications (2010-today)

Registered students: 10
OrientationAttendance TypeSemesterYearECTS
GenericElective CoursesWinter-4
Mass CommunicationsElective CoursesWinter-4
JournalismElective CoursesWinter-4

Class Information
Academic Year2021 – 2022
Class PeriodWinter
Instructors from Other Categories
Weekly Hours3
Total Hours39
Class ID
600191659
Course Type 2016-2020
  • General Knowledge
  • Skills Development
Course Type 2011-2015
General Foundation
Mode of Delivery
  • Face to face
  • Distance learning
Language of Instruction
  • Greek (Instruction, Examination)
Prerequisites
Required Courses
  • GE1100 Information Technologies and Applications
Learning Outcomes
Students who will have successfully completed the course, will be able to: - Use spreadsheet software effectively. - Perform basic data analysis on spreadsheets. - Create charts to visualize data on spreadsheets. - Use decision-making tools for script analysis and goal search. - Import external data into spreadsheets from other data files (e.g., CSV files), databases, or the Web, to further analyze and visualize them.
General Competences
  • Apply knowledge in practice
  • Retrieve, analyse and synthesise data and information, with the use of necessary technologies
  • Make decisions
  • Work autonomously
  • Advance free, creative and causative thinking
Course Content (Syllabus)
The course is an introduction to the analysis and visualization of data in spreadsheets, and it is supported by extensive bibliography (both Greek and foreign) in electronic form, as well as special audiovisual educational material, which is presented during the lessons. In particular, the course material includes: Introduction to spreadsheets, spreadsheet software (Microsoft Excel, LibreOffice Calc, Google Sheets), Formulas, Functions, Charts, Datasets, Tables, Subtotals, PivotTables, PivotCharts, What-If Analysis, Special Functions, Statistical Functions, Multi-spreadsheet Management, External Data Entry, Web Queries and XML language, Collaboration and distribution of spreadsheets.
Keywords
spreadsheets, data analysis, data visualization, Microsoft Excel, LibreOffice Calc, Google Sheets
Educational Material Types
  • Notes
  • Slide presentations
  • Multimedia
  • Book
Use of Information and Communication Technologies
Use of ICT
  • Use of ICT in Course Teaching
  • Use of ICT in Laboratory Teaching
  • Use of ICT in Communication with Students
  • Use of ICT in Student Assessment
Description
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.
Course Organization
ActivitiesWorkloadECTSIndividualTeamworkErasmus
Lectures241.0
Laboratory Work120.5
Reading Assigment502
Tutorial30.1
Project301.2
Exams20.1
Total1214.8
Student Assessment
Description
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.
Student Assessment methods
  • Written Exam with Extended Answer Questions (Summative)
  • Labortatory Assignment (Formative, Summative)
Bibliography
Course Bibliography (Eudoxus)
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)
Additional bibliography for study
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.
Last Update
22-07-2021