COMPUTER AND TELEMATICS SKILLS FOR BUSINESS MANAGEMENT
Academic Year 2025/2026 - Teacher: Gaetano STELLAExpected Learning Outcomes
Expected Learning Outcomes
THE COURSE ALLOWS STUDENTS TO ACQUIRE THE SKILLS NECESSARY FOR WRITING AND PROCESSING TEXTS, CREATING SPREADSHEETS AND ALLOWS STUDENTS TO LEARN THE MAIN FUNCTIONS .
In particular, the student will be able to:
· Knowledge and understanding: create, format, save and print a document; create and manage workbooks and worksheets, manage cells and ranges, present tables, apply formulas and functions, create graphs and objects; insert objects from another application and print an elaborate; create and manage a presentation, insert and define the format of the slides and objects, create the content of the slides, apply the transition to the slides and the animation to the contents.
· Applied knowledge and understanding: manage the above knowledge by applying it to text formatting, table processing and drawing drafting, manage requests effectively, choosing best practices and personal solutions.
· Making judgments: knowing how to use procedural communications and technical instructions, knowing how to use IT tools to identify potentially useful solutions to a given application context in real problems, study and work, being aware of the potential and limits of the use of information Technology.
· Communication skills: knowing how to communicate correctly and effectively using IT tools.
Ability to learn: knowing how to learn independently or in a group and being able to connect topics covered during the course and with other disciplines.
Course Structure
INTERACTIVE LESSONS IN LABORATORY, in detail with:
- Frontal partecipated lessons (or in remote mode): 14 hours;
- Individual or cooperative learning exercises (or exercises carried out by the teacher in remote mode): 14 hours.
If teaching is given in a mixed formula or remotely, necessary changes may be introduced to what was previously stated in order to comply with the provided and reported syllabus.
Learning assessment may be done remotely if necessary.
As a guarantee of equal opportunities and in compliance with current laws, interested students can ask for a personal interview in order to plan any compensatory and/or dispensatory measures, based on their specific needs and on teaching objectives of the discipline. It is also possible to ask the departmental contacts of CInAP (Center for Active and Participatory Integration - Services for Disabilities and/or DSAs).
Required Prerequisites
Attendance of Lessons
Detailed Course Content
Fundamentals of computer science: information representation, numbering systems, computer architecture, notes on operating systems.
Word: open and close program, file management (new, open, close, save, save as), find and replace, page view types, print preview, toolbar customization, undo, copy, paste and paste special, size, insert (image, formula, tables, notes, page numbers, symbol), text selection, text formatting (bold, italic, underline, small caps, font, font size, superscript and subscript, line spacing, alignment and justification, hyphenation, format painter, tabs, bulleted lists). Models. Styles. Headers and footers. Spelling and grammar check. Document setup. Press. Tables. Object import. Formats
graphs.
Excel: open and close program, file management (new, open, close, save, save as), view menu, page break preview, toolbar customization, data entry, data types, selection (cells, rows, columns , non-contiguous areas), resize, align text in a cell, copy, move, delete, find and replace, sort data, references (absolute, relative and mixed), autofill, lock non-input cells, formulas, functions, graphs, document setup, print setup.
PowerPoint: create a new presentation from a template, change the theme of a presentation, add slides to the presentation, add and edit text, images, clipart and shapes to slides. Insert and modify tables and graphs, insert and modify animations and define the slide transition mode. Save the presentation.
Teams: Create and manage video conferences and meetings.
Goal 4: Ensure quality, equitable and inclusive education and promote lifelong learning opportunities for all
· Target 4.4: By 2030, substantially increase the number of young people and adults who have the necessary skills, including technical and vocational skills, for employment, decent jobs and entrepreneurial capacity
· Target 4.6: By 2030, ensure that all young people and a substantial proportion of adults, men and women, achieve literacy and numeracy skills
Modality:
· Lesson
· Vector Drawing Laboratory
· Office Automation Laboratory
Textbook Information
1. Luigi Santapaga, Matteo Trasi. Autocad 2015 pocket. Apogeo, Giugno 2014. ISBN edizione cartacea: 9788850333158.
2. Word 2021. Produrre documenti di testo puliti, eleganti e professionali. Collana POCKET di Edimatica. APOGEO, ottobre 2021. ISBN Libro: 9788850335787. ISBN Ebook: 9788850319251.
3. Excel 2021. Conoscere e sfruttare la potenza dei fogli di calcolo. POCKET Edimatica. APOGEO, ottobre 2021. ISBN Libro: 9788850335770. ISBN Ebook: 9788850319299.
4. PowerPoint 2021. Realizzare presentazioni chiare ed accattivanti. POCKET Edimatica. APOGEO, ottobre 2018. ISBN Libro:9788850335800. ISBN Ebook: 9788850319305.
Course Planning
| Subjects | Text References | |
|---|---|---|
| 1 | Word. Opening and saving files, setting up the document. Formatting styles. Inserting images, captions and cross-references and automatic summary. | Testo 2: cap. 1-8, 10-13 |
| 2 | Word. Opening and saving files, setting up the document. Formatting styles. Inserting images, captions and cross-references and automatic summary. | Exercises provided by the teacher. |
| 3 | Excel. Opening and saving files, using file manager, view menu, inserting data and formulas, and chart wizard, chart types (histogram, bar, line, pie, dispersion X Y). | Testo 3: cap. 1-8 |
| 4 | Excel: creation of a table and its graph in Excel. | Exercises provided by the teacher. |
| 5 | PowerPoint. Using the interface, creating a new presentation, inserting text, images, sound and video files, using tools for organizing and editing content, and creating templates, adding animations and transitions, printing and sharing. Practical exercise: creation of a presentation from a template. | Testo 4: cap. 1-9 |
| 6 | Teams. What is Teams, why use it (collaboration hub), installation and access (Desktop, Web, Mobile). | Exercises provided by the teacher. |
| 7 | Teams. Overview of the main tabs: Activity, Chat, Teams, Calendar, Files, Apps. | Exercises provided by the teacher. |
| 8 | Teams. Start a chat, Schedule a meeting, Manage users, Integration of Teams with other software products. | Exercises provided by the teacher. |
Learning Assessment
Learning Assessment Procedures
A final practical test on the computer, lasting 2 hours, on:
1. Word document: formatting of a text in Word;
2. Excel processing: creation of a table and its graph in Excel;
During the course there are checks, two ongoing tests, to ascertain the level of learning.
The verification of learning can also be carried out electronically, should the conditions require it.
Evaluation criteria of the practical test on the computer:
Each WORD, EXCEL work will be developed with a series of questions whose correct completion will give a positive score to the candidate. No negative score will be awarded for incorrect and non-given questions.
The exam will be passed if the threshold of 18/30 is exceeded in all two projects.
Examples of frequently asked questions and / or exercises
Word formatting of the assigned text with setting of pages and columns, use of formatting styles, insertion of images and captions, creation of cross-references and automatic summary.
Carrying out simple calculations with Excel by creating tables, formatting cells, applying formulas, and graphing the given or computed values.