LABORATORY FOR COMPUTER SCIENCE I
Learning outcomes of the course unit
Giving students skills in dealing with the problems arising from their course of study and their profession by means of basic IT and models with various types of structure.
Course contents summary
Notions regarding computer hardware: Console, keyboard, mouse and other peripheral devices. CPU, Memory units. Disks, input and output devices, hard disks, tapes, mass memory units. Data recording methods according to the different types of memory units.
Operating systems, characteristics and operation, Windows, main menu of the XP version, preparation of a disk for recording data. Disk copy. Folders: use and naming. Folders shared by several computers. File characteristics and type (filename, filetype). Saving and copying files, transferring files. Copying files from several computers, and writing to more than one file destination. The clipboard, its position and use. Office filetypes, txt, htm, xml, pdf filetypes, Office 2003 and Office 2007 filetypes.
Copying and downloading files, and use of the Internet – Folders and files on numerous computers, their transference and copying. The use of the Windows clipboard folder to transfer and copy files or parts of files. The simple selection procedure, and the separate parts of a document. Examination and use of the website istat.it.
Spreadsheet. The programme Excel. Basic spreadsheet concepts. Input and correction of data in a spreadsheet. Relative and absolute values. Use of the character $. Selecting consecutive or non-consecutive spreadsheet cells. The clipboard folder and the copy-paste procedure. Operations in a spreadsheet. Inserting a formula in a spreadsheet. Calculating percentages. Diagrams using a spreadsheet. Types of diagram and their interpretation. Making changes to data origin cells in a diagram. Copying tables and changing data. Ordering data, and the use of automatic filters. Procedures and functions in the Insert Function option. Statistical concepts of mean and standard deviation (SD). Calculating mean, mode, standard deviation. Linear diagrams, trend curves and forecasts. Trend lines and their meaning. The meaning of a trend line (R2). Interpretation of the trend line equation, with particular reference to the linear trend line. Stacked diagrams and their use in the analysis of multi-variable data. Reading and interpreting Excel tables. Calculations using special formulae. Smart tags. The use of the Windows clipboard folder to transfer and copy parts of a spreadsheet. Excel models.
Word processing, the Word programme. Writing and formatting text. Smart tags. Using a stylesheet in Word. Compiling a report using a stylesheet. Document models. Selecting separate paragraphs in a file. Copying and transferring data from spreadsheets and diagrams to a Word document. Preparation and compilation of a report using a stylesheet. Writing a text and inserting elements from a spreadsheet. Creating summaries and analytical indices. Displaying the structure for correcting the application of a stylesheet.
Managing projects. The meaning of project management. The Microsoft Project programme. Management projects. Objectives, paths, events, resources. PERT and Gantt diagrams. The definition and use of Gantt diagrams in project analysis. Connecting project activities. The use of resources.
Labour resources and material resources. The standard calendar and resource working hours.
Aspects of electronic communication – Security in communications. Cryptography and passwords. Document protection in MS Office.
In teaching, every student has a computer on which to develop the themes according to the professor's suggestions. Students are encouraged to participate in lessons with individual questions and specific requests.
After having passed a practical test using the computer, students will take an oral test in which they will have to demonstrate their capacity and their basic knowledge of aspects regarding information technology communications and hardware and software tools.