18067 - Data processing (A-L)

Academic Year 2021/2022

  • Teaching Mode: Traditional lectures
  • Campus: Bologna
  • Corso: First cycle degree programme (L) in Management and Marketing (cod. 8406)

Learning outcomes

At the end of the course, the student will know the essential IT tools for the searching on Internet, the selection and processing of bibliographic, documentary, statistical, business and marketing data for the financial and management support in business and professional enterprises. In particular, the student will be able to: - search in Internet bibliographies, documents and data; select, locate and acquire them, - process data for the preparation of professional documents shared by a working group, - set up simple schemes of accounting spreadsheet - calculate indicators and represent them graphically, make simple simulations of alternative situations and present results and strategies derived from the data collection, - evaluate different options for the automation of the company.

Course contents

During the course students will acquire the knowledge of the main software applications that are used in the office automation and in business environments.

THEORY

Internal architecture of an electronic computer: microprocessor, memories, clock and input/output devices. Evolution of computing systems. Representation of information inside the computer. The numbering systems: binary, octal and hexadecimal. The operating system: kernel, file, memory and peripherals manager. Application software and licenses for the use. Algorithms and programming languages. Translators: compilers and interpreters. Data protection and antivirus. The computer networks. Network cards, MAC and network protocols. Types of networks: LAN, MAN and WAN. Internet and HTTP and TCP / IP protocols. Web services. Search engines. File sharing on the web and communication tools. The Enterprise 2.0 model.

DESIGN AND PRODUCTION OF PROFESSIONAL DOCUMENTS

The main functions of a word processor. Advanced formatting on characters and paragraphs. Tab stops and indents. The regular and irregular tables. From text to hypermedia. Inserting graphic objects. The text boxes. Customized documents. Type letters and mail merge. Revision of documents. Importing data from an external database. Models and styles. Management of the summary and of the analytical index and of the images. Creating a graphical presentation. Formatting of slides. Transition and animation effects. Applications.

DESIGN AND MANAGEMENT OF ACCOUNTING SCHEMAS BY SPREADSHEET

Spreadsheets. Advanced cell formatting. Absolute and relative references. Mathematical, statistical and financial functions. The logical functions AND, OR, NOT. The logical function = IF and the nested IF. The database functions: DB.max, DB.min, DB.media, DB.sum and the function = Sum.if. The selection criteria. Simple and advanced filters. The search functions. The subtotals. Data validation. The Pivot Tables. The graphs. Mathematical and commercial graphs. The Macros. Analysis of data and business indices. Creation of economic scenarios.

DESIGN AND MANAGEMENT OF DATABASES

The design and management of databases. Conceptual, logical and physical schemes. Relations. Relational databases. The main objects of a database: tables, queries, forms and reports. Creating a table. Records and fields. The unique code or key. Relationship between multiple tables. The queries: selection, update, create a new table, delete and cross-tab queries. The logical selection criteria AND and OR. Importing data contained in a spreadsheet into the database. The forms and reports. Corporate reports.

BIBLIOGRAPHIC AND DOCUMENTARY SEARCHING

Research of information, documents, publications and lows within the databases of the University Library System (SBA). Research of degree and doctoral theses, books, articles, laws and journals. Selection and processing of shared professional documents. The targeted bibliographic and documentary research.

Readings/Bibliography

The list of open source booklets and the slides on all the topics discussed in class, for the CLEA and CLAMM courses, are published on the Virtual platform.

Teaching methods

nteractive lessons. Slides. Use of the shared folder and of the Virtual platform. Laboratory exercises. Course materials on the Virtual moodle platform.

Assessment methods

Computer exam consisting of  no. 15 questions/exercises on Theory, Word Processor and Graphic Presentations, Spreadsheet, Database Management and Bibliographic and Document Research.

Teaching tools

Computer network, Internet, Sharing of online documents, slides and lecture notes and exercises published on the teaching moodle platform IOL.

 

Office hours

See the website of Domenico Consoli

SDGs

Quality education Affordable and clean energy Decent work and economic growth Industry, innovation and infrastructure

This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.