Data Organization and Processing
| Title | Οργάνωση και επεξεργασία δεδομένων (Θ/A) / Data Organization and Processing |
| Code | GE2600 |
| Faculty | Social and Economic Sciences |
| School | Journalism and Mass Communications |
| Cycle / Level | 1st / Undergraduate |
| Teaching Period | Winter |
| Coordinator | Constantinos Barbargires |
| Common | No |
| Status | Active |
| Course ID | 140000027 |
| Academic Year | 2020 – 2021 |
| Class Period | Winter |
| Instructors from Other Categories |
|
| Weekly Hours | 3 |
| Total Hours | 39 |
| Class ID | 600177355
|
Course Type 2016-2020
- General Knowledge
- Skills Development
Course Type 2011-2015
General Foundation
Mode of Delivery
- Face to face
- Distance learning
Digital Course Content
- e-Study Guide https://qa.auth.gr/en/class/1/600177355
- Other: http://veria.jour.auth.gr/ge2600/
Language of Instruction
- Greek (Instruction, Examination)
Prerequisites
Required Courses
- GE1100 Information Technologies and Applications
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/ge2600/]. 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
| Activities | Workload | ECTS | Individual | Teamwork | Erasmus |
|---|---|---|---|---|---|
| Lectures | 24 | ✓ | |||
| Laboratory Work | 12 | ✓ | |||
| Reading Assigment | 50 | ✓ | |||
| Tutorial | 3 | ✓ | |||
| Project | 30 | ✓ | |||
| Exams | 2 | ✓ | |||
| Total | 121 |
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
Course Bibliography (Eudoxus)
1) Joyce Cox, Joan Lambert, "Ελληνική Microsoft Office Access 2010 Βήμα-Βήμα", ISBN 978-960-461-417-2, Εκδόσεις ΚΛΕΙΔΑΡΙΘΜΟΣ, Αθήνα, 2011. (Κωδικός Βιβλίου στην υπηρεσία Εύδοξος: 12278008)
Additional bibliography for study
1) An Nguyen (Ed.), "News, Numbers and Public Opinion in a Data-Driven World", ISBN: 978-1-5013-3035-3, Bloomsbury Academic, 2018.
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
01-02-2021
