APPLIED COMPUTER SCIENCE
Course unit partition: PIACENZA

Academic year 2024/25
1° year of course - Second semester
Professor
Claudio NAZZANI
Academic discipline
Informatica (INF/01)
Field
Ambito aggregato per crediti di sede
Type of training activity
Base
20 hours
of face-to-face activities
1 credits
hub: PIACENZA
course unit
in ITALIAN

Course unit partition: APPLIED COMPUTER SCIENCE

Learning objectives

Provide the student with a theoretical knowledge of basic computer
science on the technologies available today.
At the end of the course the student must be able to know the basic
characteristics of the computer, the potential of the network as regards
the sharing of resources and data, access to programs of more common
use for writing and data entry . Describe the possible applications of PCs
in medicine with regard to the acquisition and analysis of signals and
images, management of the department, support in clinical decision and
teaching.
The aim of the EXCEL course is to acquire the ability to create
spreadsheets with the use of various types of data and the correct
application of formats, use of formulas with mathematical operators and
functions, use of multimedia objects and graphics, preparation of
relationships with more sheets and layout criteria.
The aim of the course is to understand the logic of the program and to
assimilate the basic commands useful for the preparation of documents
with the formatting and layout criteria, both for the preparation of
document types "Letter" and "Report".

Prerequisites

No requirement

Course unit content

Introduction to Computer Science and Computer Use
General Concepts on the principles of operation
Functional analysis of the structure of a computer
Hardware: CPU Memory I / O devices
Binary system and Boolean operators
Information (text, numbers, images, sounds, ...) and its digital
representation
Software
Basic software and operating systems
Application software
Overview of programs and algorithms
Computer networks
Local networks and geographical networks
Internet and its applications
Functional classification of application programs
Presentation of application programs for word processing, presentations,
spreadsheets, application programs supplied with the S.O.
General concepts on the computer and medicine relationship
Introduction to computer security, legal references and general concepts,
and signs of digital signature
Use of word processing applications (Word) and spreadsheets (Excel)

Full programme

Brief notes on the historical evolution from the first inventions from 1600
to today
Introduction to Computer Science and Computer Use
General Concepts on the principles of operation
Functional analysis of the structure of a computer
Hardware: CPU Memory I / O devices
Binary system and Boolean operators
Information (text, numbers, images, sounds, ...) and its digital
representation
Software
Basic software and operating systems
Application software
Overview of programs and algorithms
Computer networks
Local networks and geographical networks
Cloud
Internet and its applications
Functional classification of application programs
Presentation of application programs for word processing, presentations,
spreadsheets, programs.
Use of the Internet (navigation, e-mail)
General concepts on the computer and medicine relationship
Introduction to computer security, legal references and general concepts,
and signs of digital signature.
Arguments Excel:
• Program versions and compatibility and conversion features (.XLS
.XLSX)
• Elements of the Excel window
• Use of toolbars
• Opening and saving of documents even with cryptography
• Entry of text, number, serial numbers and application of the relative
formats
• Insertion of formulas with mathematical operators and functions
• Examination and use of the functions SUM, MEDIUM, MIN, MAX, SE,
STRING.EXTRA, RIGHT, LEFT, COUNTER, VALUE, TEXT, DAY, MONTH,
YEAR, HOUR, MINUTES, SECONDS.
• Application of SUBTOTALS
• Assignment of cell names
• Filter management, sorts
• Copying and moving cell contents and formulas, addressing types:
Absolute, Relative, and Mixed
• Print and print preview
• Number Formats, Text, Date, Time, Font Types, Colors, Alignments,
Borders, Fills, Series, Protection
• Page breaks
• Headers and footers
• Automatic numbering and automatic date
• Image processing and multimedia objects
• Insertion and management of graphs
• Links between cells and references in formulas even between different
sheets and excel folders, implications of copying and pasting of formulas
WORD Arguments:
• Program versions and compatibility and conversion features (.DOC
.DOCX)
• Elements of the Word window and elements and multiple management
of documents
• Use of toolbars
• Opening and saving of documents even with cryptography
• Criteria for entering and editing text
• Manual and automatic correction
• Copy and move text
• Layout mode
• Print and print preview
• Character formats
• Copy of text format
• Paragraph formats
• Styles
• Margins
• Return
• Absolute and ruler tabulations
• Page breaks
• Headers and footers
• Automatic page numbering and automatic date setting
• Insertion of images from files, Clipart, Wordart, Forms
• Layout with images and text
• Tables
• Footnotes
• Bookmarks
• Hypertext links
• The glossary
• Application and creation of styles
• Creating an automatic summary and update
• Creation of an automatic index and update
• Texts in newspaper style columns

Bibliography

PDF of the lessons
Help and notes for Word and Excel

Introduzione ai sistemi informatici D. Sciuto, G. Buonanno, W. Fornaciari,
L. Mari, Mc Graw Hill, 2004

Teaching methods

During the lecture the topics contained in the program of the module will
be commented.
The lesson will have an interactive approach with the use of audiovisual
supports and computers, will encourage classroom discussion with
students, and group and individual elaborations

Assessment methods and criteria

The assessment of the achievement of the objectives set out in the
module includes a written test, consisting of a multiple choice
questionnaire on topics covered in the course.
An Excel and a Word document must also be prepared on the basis of the
requirements established by the teacher to be presented for
examination.
These documents will then be illustrated by the examining and the
examiner will be able to request further modifications and
implementations.

Other information

NO

2030 agenda goals for sustainable development

NO