Basic computer science: main notions of computer science, notions of hardware and software, binary system, ascii code and boole algebra. Concept of Computer Network and Database.
IT Security and application of Security Measures.
General computer science oriented to Pharmaceutical Sciences: definition and study of the spreadsheet and its use. Viewing Modes, Format Management, Functions, Data Sorting, Filters and Graphs.
Solid knowledge of the basics of Computer Science.
Solid knowledge of IT tools oriented to Pharmaceutical Sciences.
Prerequisites
Sufficient knowledge of mathematics: sets, fundamental set operations, binary relations, basic arithmetic operations and polynomials. Functions.
Teaching Methods
Frontal lesson in the classroom and in the laboratory
Further information
-
Type of Assessment
written and oral exam
Course program
Main concepts of Information Technology, Input Data and Output Data, Information Processing Cycle;
Basic Definitions, Hardware and Software, Von Neumann Architecture, Operating System;
Concepts of Multiuser, Binary Notation System; transformations from binary numbers to decimals and other way; ASCII encoding, Boolean algebra;
Concepts of Computer Networks, Classification of Networks, Switches, Routers, Packet Data Transmission and Reception; Elements of IT Security, IT Security: Possible attacks and Security Measures.
Databases. Basic notions and hints of SQL
Spreadsheets: use of spreadsheets and solid knowledge of the tools available.
Inserting values, Absolute and Relative References, data types.
Viewing Modes, Format Management, Formulas and Functions. Data Sorting, Filters and Graphs.