Introduction to Computer Sciences

Code:

610

Acronym:

610

Instance: 2020/2021 - 1S

Active?	Yes
Course/CS Responsible:	Sports Sciences

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
LCD	21	First Degree in Sports Sciences (2011/2012)	2	-	3	-
			3

Teaching language

Suitable for English-speaking students

Objectives

- To know the history of computation
- To know the way computers work
- To know the MS Windows operating system
- To know and to use antivirus and antimalware programs
- Learn to use MS Word
- Learn to use email clients
- Learn to use MS PowerPoint
- Learn to use MS Excel
- To program formulas in MS Excel

Learning outcomes and competences

- To format texts in Word

- To format images in Word

- To write mathematical formulas in Word

- To make presentations in PowerPoint

- To format images and videos in PowerPoint

- To write mathematical formulas in PowerPoint

- To make custom animations in PowerPoint

- To format text and cells in Excel

- To write mathematical formulas and functions in Excel

- To interpret mathematical formulas and translate them to Excel

Working method

Presencial

Program

- History of computation: from the abacus to the computers
- Functioning of the computers: different constituents of the hardware; the binary numeration system
- The MS Windows operating system: aspect and personalization; copy and deletion of files and folders; adding and removing programs.
- Antivirus and antimalware programs: installation and use
- MS Word: page and paragraph formating; fonts; text boxes; tables; images; automatic forms for drawing; keyboard shortcuts; taskbars.
- Email clients: introductory use; the BCC/CCO field
- MS PowerPoint: aspect and personalization of slides; text, images and automatic forms; custom animation.
- MS Excel: aspect of individual cells/group of cells – size, fill, borders, colour; fixing panels; alignment and orientation of text; merging cells.
- Programming formulas in MS Excel: Basic formulas of algebra – sum, product… to keep fix a cell/line/column in a formula; numerical derivative – instability, use of centred formulas.

Mandatory literature

Maria José Sousa, Sérgio Sousa; Microsoft Office 2007, FCA, 2007. ISBN: 9789727225774
Paulo Capela Marques; Word 2010, FCA, 2011. ISBN: 9789727226719
Mário Paulo Pinto; Microsoft PowerPoint 2010, Centro Atlântico, 2011. ISBN: 9789896151119
Maria José Sousa; Excel 2010, FCA, 2011. ISBN: 9789727226917
Joaquim Alves; Excel 2010, FCA, 2010. ISBN: 9789727226702

Teaching methods and learning activities

The topics are briefly presented by the teacher, including several examples performed by the teacher in his computer connected to the video projector, followed by the execution of exercises of application by the students, with supervision by the teacher. After a reasonable time the exercises are performed by the teacher in his computer.

Software

MS Word
MS PowerPoint
MS Excel

keywords

Physical sciences > Computer science > Computer systems > Human computer interaction
Physical sciences > Computer science > Programming
Physical sciences > Computer science > Computer hardware
Physical sciences > Computer science > Informatics > Applied informatics

Evaluation Type

Distributed evaluation with final exam

Assessment Components

designation	Weight (%)
Exame	50,00
Teste	50,00
Total:	100,00

Amount of time allocated to each course unit

designation	Time (hours)
Estudo autónomo	66,00
Frequência das aulas	15,00
Total:	81,00

Eligibility for exams

One test and one exam (in "Época Normal") are to be made. The minimum grade in each component (test and exam) is 7.5 values out of 20. Having a grade less 7.5 values implies the non admission to the exam. The students that have not obtained frequency through the test+exam and have the minimum amount of class presences, as established by law, are admitted to the final global exam, in the "Época de Recurso".

Calculation formula of final grade

Average of the test and exam: (T1+E1)/2
or
classification of the final exam (Época de Recurso)

Examinations or Special Assignments

Are not considered

Special assessment (TE, DA, ...)

Global final exam (in exam period, or not, accordingly to the law) including exercises for MS Word, MS PowerPoint, MS Excel and programming in MS Excel.

Classification improvement

Global final exam, at the "Época de Recurso", including exercises for MS Word, MS PowerPoint, MS Excel and programming in MS Excel.

Observations

The tests and exams are exclusively made in the FADEUP computers available in the classroom.
The operating system is Windows (7; 8.1; 10), and the programs are from Microsoft Office suit, in Portuguese or English.
The students have to login in their personal area of FADEUP.