| Code: | DPT06 | Acronym: | TIAT |
| Teaching Area: | Informatics |
| Acronym | Study plan | Curriculum Years | ECTS | Contact hours | Total Hours |
|---|---|---|---|---|---|
| CTSPDP | Aviso nº 10227/2016 | 1º | 4 | 30 | 107 |
Teaching - Hours
|
Descriptive summary of course 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.
| 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 |
| 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 | |
| Test/Exam | Teste/Exame | 3 | |
| Project Work | Projectos | 53 | |
| Project Work | Trabalho laboratorial ou de campo | 12 | |
| Project Work | Projectos | 9 | |
| Total: | 107 |
Elements of Continuous Assessment:
Two individual written tests, each weighing 40% of the final mark.
Practical activities carried out under the ISAG e-learning platform, with a weighting of 20% of the final grade.
Under the terms of the CTSP's Regulation:
1. 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).
2. 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.
3. 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).
4. 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.
Final evaluation topics:
Written exam with 100% weighting.
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.