| Code: | LTU2101 | Acronym: | INFGES |
| Web page: | http://elearning.isag.pt/isag1920/ |
| Teaching Area: | Informatics |
| Acronym | Study plan | Curriculum Years | ECTS | Contact hours | Total Hours |
|---|---|---|---|---|---|
| LTU | Aviso nº 9929/2017 & Ret. nº 612/2017 | 1º | 4 | 45 | 107 |
| Laboratórios: | 10,00 |
| Other: | 0,00 |
| Laboratórios: | 30,00 |
| Other: | 15,00 |
| Laboratórios: | 30,00 |
| Other: | 15,00 |
Teaching - Hours
|
Microsoft Word
Microsoft office Excel
Microsoft office Word
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.
1. Features of word processors;
1.1. Open Source Word processors
1.2. Microsoft Word
1.2.1. Text Effects and automating tasks;
1.2.2. Inserting special characters and formulas
1.2.3. Margins;
1.2.4. Tabs;
1.2.5. Automatic bullets and numbering;
1.2.6. Envelopes;
1.2.7. Text in columns;
1.2.8. Breaks;
1.2.9. Construction of indices;
1.2.10. Charts and graphs;
1.2.11. Models;
1.2.12. Merge;
1.2.13. Bookmarks and hyperlinks;
1.2.14. Building bibliographies
2. Features of spreadsheets;
2.1. Spreadsheets Open Source
2.2. Microsoft Excel
2.2.1. Editing and manipulation of cells
2.2.2. Page Setup and Print
2.2.3. Formulas and functions
2.2.3.1. Introduction to Formulas and Functions
2.2.3.2. Mathematical functions
2.2.3.3. Statistical functions
2.2.3.4. Financial functions
2.2.3.5. Date and Time functions
2.2.3.6. logical functions
2.2.3.7. Search and reference functions
2.2.3.8. Text and information functions
2.2.3.9. Database functions
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.
| CARVALHO, A.;Gráficos com Excel - 95 exercícios, FCA Editora de Informática, 2017. ISBN: 978-972-722-876-8 |
| CARVALHO, A.;Excel para a Gestão - 65 exercícios, FCA Editora de Informática, 2017. ISBN: 978-972-722-875-1 |
| RODRIGUES, L.;Utilização do Excel para Economia & Gestão, FCA Editora de Informática, 2016. ISBN: 978-972-722-775-4 |
| Marques, P., Costa, N;Fundamental do Excel 2013, FCA Editora de Informática, 2014. ISBN: 978-972-722-800-3 |
| CARVALHO, A.;Exercícios resolvidos com Excel 2010 para Economia & Gestão, FCA Editora de Informática, 2011. ISBN: 78-972-722-729-7 |
| Marques, P., Costa, N;Fundamental do Word 2013, FCA Editora de Informática, 2013. ISBN: 978-972-722-780-8 |
| RODRIGUES, L.;Utilização do Excel 2010 para Economia & Gestão, FCA Editora de Informática, 2011. ISBN: 978-972-722-669-6 |
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 | |
| Individual assessment | Teste/Exame | 3 | |
| Individual self-study | Study | 59 | |
| Others | Trabalho laboratorial ou de campo | 15 | |
| Total: | 107 |
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.
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.