Università degli Studi di Urbino Carlo Bo / Portale Web di Ateneo


COMPUTER SKILLS
ABILITÀ INFORMATICHE

Algorithms, coding and use of spreadsheets
Algoritmi, coding e uso dei fogli elettronici

A.Y. Credits
2020/2021 2
Lecturer Email Office hours for students
Stefano Russo Weekly assistance with Blackboard web conference Collaborate on the blended platform at the times agreed with the teacher by e-mail.

Assigned to the Degree Course

Modern Languages and Civilisations (L-11)
Curriculum: AZIENDALE
Date Time Classroom / Location
Date Time Classroom / Location

Learning Objectives

The computer skills course aims, after having clarified what computer science is and what a computer is, to provide the basic concepts of programming and understand how this is the language of things. Furthermore, students can acquire adequate knowledge on the use of spreadsheets, on how to search for web digital resources, how to graphically represent information to communicate them.

Program

Basic concepts of computer science

  • Meaning and implications of the term digital
  • The computer: nature, denomination and functions
  • The computer general executor of algorithms
  • What is an algorithm
  • From algorithm to computer program: introduction to coding and computational thinking
  • Programming languages ​​and program structuring
  • Architecture of a computer
  • Computer networks and the Internet
  • Architecture and standards for the web
  • Introduction to managing data with databases

- How to represent, process and analyze data with spreadsheets

Basic concepts of the spreadsheet

  • Data entry
  • Data formatting
  • Formulas and functions
  • Cell references and formulas
  • Name the cells S
  • Sort and link data
  • Search and select data in a list (filters)
  • Protect your data Management and printing of sheets

- Digital and Web resources

  • Searching for sources of information on the web
  • Evaluate the information
  • Check the credibility of the sources

- Programs for the graphic representation of information

  • Presentation tools

-Tools for sharing information on the network

  • Online collaboration applications (groupware)

Bridging Courses

No specific prerequisites are needed. However, basic computer familiarity is required.

Learning Achievements (Dublin Descriptors)

In relation to computer science teaching, the student must show possession of:

  • Knowledge and under standing. At the end of the course, students must be able to understand and explain the fundamental concepts of computer science (what computer science deals with, the logic behind the functioning of a computer, the algorithm and the software) and in particular which uses information technology may have in the business environment.
  • Ability to apply knowledge and understanding. At the end of the course, students will have to demonstrate the ability to apply knowledge on IT tools in the business environment with particular reference to software tools for processing texts and graphical representation of information.
  • Autonomy of judgment (making judgments). At the end of the course, students will have to demonstrate the ability to use knowledge and concepts to reason with autonomy of judgment according to the logic of the discipline.
  • Communication skills. At the end of the course, students must be able to expose and discuss the topics studied with conceptual and linguistic precision, and to outline general frameworks that effectively and concisely illustrate the problems faced.
  • Learning skills. At the end of the course, students must have achieved some familiarity with the basic concepts of computer science applied to the field of educational sciences in order to be able to independently acquire new knowledge by consulting in-depth bibliographic tools.
  • Teaching Material

    The teaching material prepared by the lecturer in addition to recommended textbooks (such as for instance slides, lecture notes, exercises, bibliography) and communications from the lecturer specific to the course can be found inside the Moodle platform › blended.uniurb.it

    Supporting Activities

    Any additional lessons and / or seminars.


    Didactics, Attendance, Course Books and Assessment

    Didactics

    Lectures and online, practical demonstrations on the use of the software indicated in the study program with the aid of multimedia tools. Structured exercises on the use of word processing software, information search, graphic representation of information, sharing of information on the network. It is recommended that you bring a notebook to class.

    Attendance

    Nobody. Attendance is however recommended.

    Course books
    • Mauro mezzini, Informatica di base, Maggioli Editore, Collana Apogeo Education, 2016  [ISBN / EAN 8891619471 / 9788891619471]
    • Educational materials available on the blended learning platform.
    Assessment

    The exam consists of a test of eligibility. This means that no votes are assigned, but only the qualification of "suitable".

    The suitability test consists of:

    • Written exam using a multiple choice question type test, multiple choice, true or false statement, open answer, word association, personalized question (total 35 questions) and/or any exercises to be performed. The test will focus on theoretical topics and on the use of the software tools indicated in the course program to ascertain the possession of basic knowledge and skills acquired. The time for carrying out the test is forty minutes. The written test will be passed by answering exactly 75% of the questions and correctly carrying out any exercises.
    • Written elaboration of a theme with a word processing program and presentation of the arguments of the theme in PowerPoint. Both papers must be sent to the teacher by e-mail ten days before the exam for the evaluation. The title of the topic, the editorial indications and the e-mail address to send the works to will be published on the blended learning platform.

    Additional Information for Non-Attending Students

    Didactics

    Individual study on the specific texts and materials reported.

    Autonomous exercises on the topics of the application part.

    Attendance

    Nobody.

    Course books

    Same texts and teaching materials used by attending students.

    Assessment

    The same methods of assessment for attending students.

    « back Last update: 21/04/2021

    Condividi


    Questo contenuto ha risposto alla tua domanda?


    Il tuo feedback è importante

    Raccontaci la tua esperienza e aiutaci a migliorare questa pagina.

    Se sei vittima di violenza o stalking chiama il 1522

    Il 1522 è un servizio pubblico promosso dalla Presidenza del Consiglio dei Ministri – Dipartimento per le Pari Opportunità. Il numero, gratuito è attivo 24 h su 24, accoglie con operatrici specializzate le richieste di aiuto e sostegno delle vittime di violenza e stalking.

    Posta elettronica certificata

    amministrazione@uniurb.legalmail.it

    Social

    Performance della pagina

    Università degli Studi di Urbino Carlo Bo
    Via Aurelio Saffi, 2 – 61029 Urbino PU – IT
    Partita IVA 00448830414 – Codice Fiscale 82002850418
    2021 © Tutti i diritti sono riservati

    Top