| Code: | LGH2102 | Acronym: | INFG |
| Web page: | http://elearning.isag.pt/isag1819/ |
| Teaching Area: | Informatics |
| Acronym | Study plan | Curriculum Years | ECTS | Contact hours | Total Hours |
|---|---|---|---|---|---|
| LGH | Aviso nº 9705/2017 & Ret. nº 682/2018 | 1º | 4 ECTS | 45 | 107 |
| Laboratórios: | 22,00 |
| Other: | 0,00 |
Teaching - Hours
|
Microsoft Office Word
Microsoft Office Excel
Portuguese
SUMMARY
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 OUTCOMES OF LEARNING
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 DEVELOP
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 Word 2013, FCA Editora de Informática, 2013. ISBN: 978-972-722-780-8 |
| Marques, P., Costa, N;Fundamental do Excel 2013, FCA Editora de Informática, 2014. ISBN: 978-972-722-800-3 |
| 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 | |
| Teste/Exame | 3 | ||
| Study | 59 | ||
| Trabalho laboratorial ou de campo | 15 | ||
| Total: | 107 |
Two individual written tests, each weighing 40% of the final grade.
A mini-test on the e-learning platform, with a weighting of 20% of the final grade.
Under the terms of the Bachelor's Regulation:
1. The actual presence of the students in the classes will be registered and, if the number of absences per student exceeds 30% of the total number of contact sessions provided for each course unit, it will automatically be transferred to the final evaluation of the normal time.
2. In the written tests and in the evaluation elements referred to in points b) to e) of paragraph 2 of Article 39 it is necessary to obtain a minimum grade of 7.5 (seven point five) values.
3. If the student is absent or has a grade lower than 7.5 points in the tests or evaluation elements referred to in the preceding paragraph, he will be automatically transferred to the final evaluation of the normal season.
4. If the student fails to obtain a grade of less than 7.5 points in the second written test (held on the same date as the final written test of the normal time), he / she may apply for evaluation at the time of appeal.
Individual written test: 100%.
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.