Data Organization and Processing (Theory/Practice)

Course Information
TitleΟργάνωση και Επεξεργασία Δεδομένων (Θ/Α) / Data Organization and Processing (Theory/Practice)
CodeAGE1800
FacultySocial and Economic Sciences
SchoolJournalism and Mass Communications
Cycle / Level1st / Undergraduate
Teaching PeriodWinter
CoordinatorConstantinos Barbargires
CommonYes
StatusActive
Course ID600020544

Programme of Study: ANPPS Tmīmatos Dīmosiografías kai M.M.E. (2020-2021)

Registered students: 1
OrientationAttendance TypeSemesterYearECTS
''DĪMOSIOGRAFIAS''Elective CoursesWinter/Spring-5
''MESŌN EPIKOINŌNIAS''Elective CoursesWinter/Spring-5

Class Information
Academic Year2024 – 2025
Class PeriodWinter
Instructors from Other Categories
Weekly Hours3
Total Hours39
Class ID
600259663
Course Type 2021
Skills Development
Course Type 2016-2020
  • General Knowledge
  • Skills Development
Course Type 2011-2015
General Foundation
Mode of Delivery
  • Face to face
Language of Instruction
  • Greek (Instruction, Examination)
Prerequisites
Required Courses
  • AGE1100 Information Technologies and Applications in Communication
Learning Outcomes
Upon successful completion of the course, students will be familiar with the use of office automation applications for organizing and processing data. In particular, they will be able, not only to use an existing database (DB) effectively, but also to design, create, and manage a new DB, perform basic import, update and deletion tasks, create and perform simple and complex queries to search for information, design and use data import and update forms, design and print reports with bundled data, and finally use DB on the Internet for downloading directory information, and references.
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 aims to teach data organization and processing principles and techniques, with special emphasis on the operation and management of databases that present journalistic interest. In particular, the course contains the following educational units: Introduction to databases (basic definitions and historical development), Data organisation and processing with Microsoft Excel, Database management with Microsoft Access, Database creation (database design, tables, relations between tables), Working with data (inserting, updating, and searching), Query design and execution (select queries, cross-tab queries, update queries), Form design and usage, Report design and printing, Co-operation between database management software and other office automation software (mail-merge), On-line databases and databases on the Internet, Digital libraries, General Data Protection Regulation (GDPR).
Keywords
databases, data organization, data processing, Microsoft Access, GDPR
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:82/course/view.php?id=8 ]. 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
Lectures24
Laboratory Work12
Reading Assigment50
Tutorial3
Project30
Exams2
Total121
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. Database project in Microsoft Access (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
Additional bibliography for study
  1. Mary-Anne Poatsy, Jerri Williams, and Amy Rutledge, "Exploring Microsoft Office 365 Access 2019 Comprehensive", ISBN 978-0-1354-3581-6, Pearson, 2020.
  2. Mary-Anne Poatsy, Eric Cameron, Jerri Williams, Amy Rutledge, and Robert Grauer, "Exploring Microsoft Office Access 2016 Comprehensive", ISBN 978-0-1344-7945-3, Pearson, 2016.
  3. "Microsoft Official Academic Course: Microsoft Access 2013", ISBN 978-0-470-13310-1, John Wiley & Sons Ltd., 2014.
  4. Carlos Coronel, Steven Morris, and Peter Rob, "Database Systems: Design, Implementation, and Management", 9th Edition, ISBN 978-0-538-46968-5, Cengage Learning, 2010.
  5. Mark Whitehorn, Bill Marklyn, "Inside Relational Databases with Examples in Access", ISBN 978-1-84628-394-9, Springer, 2007.
  6. Ειρηνικός Πλατής, "Προσωπικά Δεδομένα - Προστασία GDPR", ISBN 978-960-569-873-7, Εκδόσεις Παπαδόπουλος, Αθήνα, 2018.
Last Update
06-03-2025