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


COMPUTER SKILLS
ABILITÀ INFORMATICA

COMPUTER SKILLS
ABILITA' INFORMATICA

A.Y. Credits
2016/2017 4
Lecturer Email Office hours for students
Stefano Russo n the first half, by appointment. Contact the teacher by e-mail

Assigned to the Degree Course

Psychology - Sciences and Techniques (L-24)
Curriculum: PERCORSO COMUNE
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

  • Software and Algorithm

  • Basic and application software

  • 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

    Theory:
    - Renato Borruso - Stefano Russo, Approccio umanistico all'informatica. Un mondo di BIT, 2° ed. completamente riveduta e aggiornata da S. Russo, Edizioni Scientifiche Italiane (ESI), Napoli, 2016. (three hundred pages). The book is in print.The old edition of the book is no longer suitable for exam preparation.
    Practice:
    -For the step 1 of syllabus (Operating systems. Functions of the operating system) and for the step 2 of syllabus (File system and file management system) we recommend using any of the preparation manuals to the European Computer Driving Licence (ECDL - Core Level); for the step 4 of syllabus (Spreadsheets) we recommend: 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).

    Assessment

    Written by test with multiple choice questions on theoretical arguments and the use of software tools indicated in the course program to ensure the possession of basic knowledge and / or any exercises to be carried out on electronic spreadsheets.

    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.

    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 sguendo the examples proposed educational materials.

    « back Last update: 17/10/2016

    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