Computer Skills Test

The Course provides the basic notions of the computer-science discipline with focus on i) foundations of Computer Science, ii) spreadsheets, iii) information management, and iv) Internet and web. Furthermore, the Course provides skills about the main functionalities of spreadsheet software tools, with focus on the use of formulae, functions, and chart creation.

The student will acquire a mix of Knowledge and Skills.
Knowledge: the student will learn about i) foundations of Computer Science, ii) spreadsheets, iii) information management, and iv) Internet and web. The part about the foundations of Computer Science includes: historical notions about the computer-science discipline, physical structure and organization of computers, information coding, units of measure of information, definition of algorithm and program, digital representation of text, audio, and video contents, classification of software tools, security issues and risks concerned with the use of digital technologies. The part about spreadsheets includes: spreadsheet definition and structure, functions in Microsoft Excel, statistical functions in Microsoft Excel, chart creation in Microsoft Excel. The part about information management includes: definition of data and information, databases, relational model of databases, database systems, similarities and differences between spreadsheets and relational databases, database languages, query composition, web databases. The part about Internet and web includes: basic notions of computer networks, standard and protocols of computer networks, history and structure of the Internet, web architecture, HTML language, design and structure of search engines.
Skills: the student will acquire the following skills:
· Creation and organization of data in a spreadsheet
· Dragging of formulae in a spreadsheet
· Cell formatting in a spreadsheet
· Use of general and statistical functions in Microsoft Excel
· Chart creation in Microsoft Excel