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


COMPUTER SKILLS
ABILITÀ INFORMATICA

A.Y. Credits
2017/2018 4
Lecturer Email Office hours for students
Stefano Russo Thursday from 6.00 pm to 7.00 pm (Magistrero- Professor's room); Friday from 8.00 pm to 9.00 pm (Raffaello hall - Collegio Raffaello)

Assigned to the Degree Course

Psychology - Sciences and Techniques (L-24)
Curriculum: PERCORSO COMUNE
Date Time Classroom / Location
Date Time Classroom / Location

Learning Objectives

The course in computer skills is firstly to give students all the computer knowledge necessary for them to get an idea own clear and sufficiently detailed (although on certain technical details approximate) of what the science that goes by the name computer science and how and with what effects it will develop in favor of man and science and spicologiche techniques.

Students in learning the general concepts and fundamental theoretical concepts will also acquire, for all practical purposes, mastered all the most common Italian and English linguistic expressions, abbreviations, acronyms of their own in the IT world.

The course, in particular, aims to promote the acquisition by students of skills relating to the use of electronic spreadsheets (spreadsheets) in order to facilitate the study of the Research Methodology teachings with elements of statistics and dell ' teaching of Psychometrics.

Program

The course is divided into two parts: theory (rudiments of information technology and their application to humanistic social science) and practice (this part aims to teach information technology skills)

The topics will be addressed in the order they are listed in the program.

Theory (contents) (8 ore)

  • Introduction to information technology and to computer: basic concepts

  • Computer architecture, hardware. Input/output devices

  • The binary code

  •  Algorithms and flowcharts

  • Introduction to coding and computational thinking

  • The software

  • The operating system

  • Productivity software (application software dedicated to producing information, such as documets, presentations, worksheets, databases, charts,graphts, digital paintings, electronic music and digital video)

  • Computer networks. Client-server architectures

  • Internet and the basic services

  • Web browsing and on-line security

  • Application of information technology to social sciences 

  • Practice (contents) (16 ore)

  • Operating systems. Functions of the operating system (Windows)
  • File system and file management system
  • Word processors (Word)
  • Creating documents
  • The different text file formats
  • Set up the page, the paragraphs and the body of the text (margins, page breaks, tabs, indentation of paragraphs, body text)
  • Text formatting. Insert tables, images, objects, and graphics in documents
  • Setting the main parameters of the printing
  • Spreadsheets (Excel)
  • Enter data in the worksheet
  • Formatting data
  • References and formulas
  • Order and link data
  • Import data in Excel
  • Math Functions (SUM, ROUND, ABS, RAND, PRODUCT, SUMPRODUCT, SUMIF)
  • Search functions and reference (VLLOOKUP, HLOOKUP)
  • Logical Functions (IF, AND, OR, NOT)
  • Statistical Functions (AVERAGE, MAX, MIN, COUNTA, COUNTBLANK, COUNT, COUNTIF,, MODE, MEDIAN, QUAQRTILE, VAR, VARP, STDEV, STDEVP)
  • Creating and printing charts and graphs
  • Print management
  • Bridging Courses

    No specific prerequisites are needed. We still need a basic familiarity with the computer (use of keyboard, monitor and mouse, opening and closing of the working session, etc.)

    Learning Achievements (Dublin Descriptors)

    In relation to the teaching of computer science students must demonstrate possession of:

  • Knowledge and understanding (knowledge and under standing). After the course students should be able to understand and explain the basic concepts of information technology.
  • Ability to apply knowledge and understanding (applying knowledge and understanding). After the course students should be able to discuss and evaluate various claims and arguments in the field of computer science  and to use this knowledge competently.
  • Making judgments (Making judgments). After the course students should be able to demonstrate the ability to use knowledge and concepts to reason with independent judgment according to the logic of the discipline.
  • Communication skills (communication skills). After the course students should be able to explain and discuss the relevant topics with conceptual and linguistic exactness, and to offer efficacious  and synthetic accounts of the subject matter.
  • Learning skills (learning skills). After the course students should be acquainted the computer science and the computer to be able to proceed on their own  in gathering further knowledge from the literature in the field and in contiguous fields.
  • 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 supplementary lessons and / or seminars.  


    Teaching, Attendance, Course Books and Assessment

    Teaching

    Lectures, practical demonstrations on the use of the software listed in the study program with the help of multimedia tools (PC and projector), structured exercises on the use of spreadsheets.

    Attendance

    No obligation.

    However, it is recommended the frequency given the technical nature of the course.

    Course books

    -Mauro Mezzini, Unformatica di Base, Apogeo (Maggioli Editore), 2016. Tutto il libro.
    - Alberto Clerici (a cura di), Manuale di informatica per l'economia, Egea, Milano, 2014. Cap. 4 (da pagg. 91-117), cap. 5 (da pagg. 127-137 e 141-143) e cap.6 (da pagg. 161-181 e 208-215).

    For an in-depth analysis on algorithms and coding, we recommend reading "Problemi, algoritmi e coding" di P. Crescenzi ee L. Pagli, Zanichelli, Bologna, 2017

    Assessment

    Written test by means of a multiple choice question type, multiple answer, true or false statement, open answer, word association, personalized question and / or any exercises to be performed on spreadsheets. The test will focus on the theoretical topics and on the use of the software tools indicated in the program of the course to ascertain the possession of basic knowledge.

    Disability and Specific Learning Disorders (SLD)

    Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.

    To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.

    Additional Information for Non-Attending Students

    Teaching

    Individual study on texts and reported specific materials.


    Autonomous exercises on the topics of the application part.
     

    Attendance

    No obligation.

    Course books

    Same texts and materials indicated for attending students.

    -Mauro Mezzini, Unformatica di Base, Apogeo (Maggioli Editore), 2016. Tutto il libro.
     -Alberto Clerici (a cura di), Manuale di informatica per l'economia, Egea, Milano, 2014. Cap. 4 (da pagg. 91-117), cap. 5 (da pagg. 127-137 e 141-143) e cap.6 (da pagg. 161-181 e 208-215).

    For an in-depth analysis on algorithms and coding, we recommend reading "Problemi, algoritmi e coding" di P. Crescenzi ee L. Pagli, Zanichelli, Bologna, 2017

    Assessment

    Same manner as for the attending students.

    Disability and Specific Learning Disorders (SLD)

    Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.

    To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.

    Notes

    For non-attending students it is recommended to practice  the examples proposed in to course books.

    « back Last update: 19/05/2018

    Il tuo feedback è importante

    Raccontaci la tua esperienza e aiutaci a migliorare questa pagina.

    Posta elettronica certificata

    amministrazione@uniurb.legalmail.it

    Social

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

    Top