67059 - Data Processing (A-L)

Learning outcomes

At the end of the course, the student knows the IT and information tools essential for searching the web, selecting and processing bibliographic, documentary, statistical, budgetary and market data in a business-economic and professional work group operating in companies, in financial support, administrations and professions. In particular, the student is able to: - search the Internet for bibliographies, documents and data, select them, locate them and acquire them, - process them for the preparation of professional documents shared by the working group, - set up simple accounting schemes on an electronic sheet, - calculate indicators and represent them graphically, perform simple simulations of alternatives and present the results and the strategies that derive from them at a forum, - evaluate the different options for the automation of the company for which it operates.

Course contents

- Basic concepts of information technology

• Computer, algorithm and software
• Computer networks and Internet 
• Information system

- Search for data, documentation and bibliographie on the web

1. Look for economic-financial information online
2. Use of search engines
3. How to set up a search
4. Research strategies
5. Advanced search engine features
6. Build complex queries
7. Evaluate the reliability of the results of a research and their usability
8. On-line public access catalogue (OPAC)
9. Databank and Databases

- How to represent, process and analyze business economic data with spreadsheets (MS-Excel)

1. Basic concepts of the spreadsheet

• Data entry
• Data formatting
• Insert formulas and functions
• Cell references and formulas
• Name the cells
• Sort and link data
• Search and select data from a list (filters)
• Protect data
• Management and printing of sheets
• 2. Creating tables and tables

3. Calculations and functions in the spreadsheet

4. Creation and printing of graphs and charts

5. Statistical and business applications with Excel

6. Create Pivot tables and Pivot charts

7. Resolving problems under condition

8. Archive management with Excel

9. Protect data with Excel

10. File formats supported by Excel

11. Import and export of data

- How to present and communicate on-screen data to a forum (MS-PowerPoint) (3 hours)

• Main functions of PowerPoint
• How to import search data from the PowerPoint spreadsheet and present it

- Information sharing and online collaboration tools

• Create spreadsheets with Google Docs and Microsoft Online
• Store and share spreadsheets with Google Drive and Microsoft OneDrive

Readings/Bibliography

Alberto Clerici, Manuale di informatica per l'economia, EGEA, III Edition, 2017, p. 336. (EAN: 9788823822351). - Excluding the cap. 6 (from page 219 to page 264).

Teaching methods

Frontal lessons on the theoretical part. Presentations of the applications to be known. Free and guided exercises in the computer lab.

Attendance is recommended as it is a course based on the practical use of spreadsheets and other individual productivity software.

Assessment methods

The exam consists of a proficiency test that will take place in a computer lab in a single session. With the eligibility test, no grades are awarded, but only the qualification of "eligible". The suitability test consists of:

─ Written test with multiple choice questions and exercises to be performed on the calculation spreadsheets. The test aims to ascertain the possession of the acquired knowledge. The time for the test is forty minutes. The written test will be passed by answering exactly 75% of the questions and carrying out the exercises correctly.

Teaching tools

Online collaborative teaching tools to integrate traditional classroom teaching activities: Moodle platform, forum, chat, web conf .. wiki.

Use of content (text and multimedia teaching materials, videos, exercises) available on the delivery platform Online courses for registered students.

Educational Resources on the Net: Sitography.

Office hours

See the website of Stefano Russo