| Code: | LRE2101 | Acronym: | INFGES |
| Web page: | http://elearning.isag.pt/isag1920/ |
| Teaching Area: | Informatics |
| Acronym | Study plan | Curriculum Years | ECTS | Contact hours | Total Hours |
|---|---|---|---|---|---|
| LRE | Aviso nº 9881/2017 | 1º | 4 ECTS | 45 | 106 |
| Práticas: | 31,00 |
| Other: | 0,00 |
Teaching - Hours
|
Microsoft Office Word
Microsoft Office Excel
Portuguese
DESCRIPTIVE SUMMARY OF CURRICULAR UNIT
The unit, Management Information Systems (IS) connects two distinct areas of knowledge, Information Technology (IT) and Management.
This course will use word processing tools, such as Microsoft Word, and spreadsheets, such as Microsoft Excel, among others, in open source format.
OBJECTIVES AND EXPECTED LEARNING OUTCOMES
The objectives of the course are:
1. Know advanced features of a word processor;
2. To deepen the knowledge of Word of the students exploring all their potentialities;
3. Knowing the basic features of a spreadsheet;
4. Deepen Excel knowledge of students anda make them explore its full potential;
5. Using different formulas and functions in Excel;
6. Undertake analysis and data management using the Excel.
SKILLS TO BE DEVELOPED
With this course, it is intended that students acquire the following skills:
1. Handle Microsoft Word and other existing word processors;
2. Know how to implement advanced Microsoft Word functionality;
3. Handle Microsoft Excel and other spreadsheets existing;
4. Knowing implement formulas and functions;
5. Knowing how to recognize and apply analysis and data management, as well as automating tasks.
In this course content will be taught to allow the student to master the tools, word processing and spreadsheet of the Microsoft productivity package. In this sense, the unit will begin with introductory concepts of the productivity package, starting with the text processing tool exploring all its advanced potentialities (topic 1) that will respond to Objectives 1 and 2. Later we will approach the spreadsheet (topic 2) which will respond to Objectives 3, 4, 5 and 6.
| RODRIGUES, L.;Utilização do Excel para Economia & Gestão, FCA Editora de Informática, 2016. ISBN: 978-972-722-775-4 |
| CARVALHO, A.;Excel para a Gestão - 65 exercícios, FCA Editora de Informática, 2017. ISBN: 978-972-722-875-1 |
| Kevin Wilson;Essential Office 365 Third Edition: The Illustrated Guide to Using Microsoft Office, Illustrated Edition, 2018. ISBN: 173092767X |
| Marques, P., Costa, N.;Fundamental do Excel 2013, FCA Editora de Informática, 2014. ISBN: 978-972-722-800-3 |
| Marques, P., Costa, N.;Fundamental do Word 2013, FCA Editora de Informática, 2013. ISBN: 978-972-722-780-8 |
| CARVALHO, A.;Gráficos com Excel - 95 exercícios, FCA Editora de Informática, 2017. ISBN: 978-972-722-876-8 |
There will aplied the following methods: exhibition, demonstration and experimentation. Multimedia presentations will support most of the expository content. The most practical part of the course will be mostly dedicated to carrying out enforcement activities of the contents taught, assuming here the teacher, the role of tutor, recalling concepts and functionality, providing support and encouraging students to refine and hone their performances.
During classes students are always encouraged to take a pro-active critical participation, about the contents exposed and present current topics for debate.
Avaliação distribuída com exame final
| Description | Type | Time (hours) | Conclusion Date |
|---|---|---|---|
| Attendance (estimated) | Lessons | 30 | |
| Study | 58 | ||
| Teste/Exame | 3 | ||
| Participação Presencial | 15 | ||
| Total: | 106 |
Two individual written tests, each weighing 40% of the final grade.
Two mini-tests on the e-learning platform, with a global weighting of 20% of the final grade.
Under the terms of the Bachelor's Regulation:
a) The students' attendance in classes will be recorded and, if the number of absences per student exceeds 30% of the total number of lessons scheduled for each course unit, the student will be automatically transferred to the final evaluation (regular season).
b) In the written tests and other assessment elements mentioned in paragraph 2 of Art. 30 it is necessary to obtain a minimum grade of 7.5 (seven point five) points.
c) If the student misses a test or receives a grade lower than 7.5 points in the tests or in another assessment element mentioned in the previous number, the student will be automatically transferred to the final evaluation (regular season).
d) If the student misses or obtains less than 7.5 in the second written test, held in the same date of the final exam in the regular season, they may apply for further evaluation in the Appeal season.
e) All written academic work provided for in the assessment (reports, case studies, etc.) must be submitted to the Turnitin database, available on the ISAG E-Learning platform, with a similarity rate up to 30% acceptable.
Individual written test: 100%.
:
- The practical or theoretical-practical work(s) referred to in point b) of paragraph 2 of Art. 39 may also be considered, with a weighting corresponding to half of that considered in the continuous assessment, if the student communicates such intention to the professor, filling, in that case, a specific form to be made available by the professor at the moment of the written exam.
The teaching methodology assumes theoretical and practical characteristics appropriate to the nature of the subjects taught and to the objectives of the curricular unit. The spirit of reflection and discovery in students is encouraged as a way of obtaining real qualifications both in terms of the assimilation of theoretical knowledge and in the capacity of its application to practical situations. In this way, the defined objectives will be achieved, both with regard to the understanding of the concepts and with regard to the capacity for their practical application.