Computer Applications for Management

Classes will be taught under theoretical and practical regime, in computer rooms.
An expository methodology will be used for the presentation of the concepts of the course, supported by practice in the classroom, through the resolution of proposed exercises of application of the concepts transmitted, in the classroom computers. The experimentation will seek to approach, whenever possible, to situations that students will encounter in their professional life.In addition to classes, students should develop further work, which will be shown throughout the semester.

This course aims to provide students with conceptual and instrumental skills in the field of spreadsheets that are particularly useful in the context of other courses as well as the subsequent effective and efficient exercise
of students’ professional activity.
The specific objectives of this course aims to give students a basic understanding of management technology and information systems and the role they play in the organizations, that students be able to usespreadsheets
to solve problems, perform data analysis, create reports and the expound conclusions.
At the end of the course, students should have developed the ability to solve problems using spreadsheet
applications, using advanced features of these tools.

1. Introduction to Information Systems

2. Microsoft Excel Spreadsheet

2.1 Basic features

2.2 Study of functions

2.2.1 Introduction to formulas and functions

2.2.2 Math functions

2.2.3 Statistical functions

 2.2.4 Analysis Toolpak Tool

2.2.5 Financial functions

2.2.6. Date and Time functions

2.2.7 Logic functions

2.2.8 Lookup functions

2.3 Charts and graphics

2.4 Data Tables

2.4.1 Data sort

2.4.2 Data filtering 2.4.3 Subtotals

2.4.2 Data filtering
2.4.3 Subtotals

NAO

1. Luís Silva Rodrigues (2011), “Utilização do Excel 2010 para Economia & Gestão”, FCA Editora de Informática
   Lda.
   2. Paulo Capela Marques (2011), “Exercícios de Excel 2010”, FCA Editora de Informática Lda.
   3. Maria José Sousa (2011), “Fundamental do Excel 2010”, FCA Editora de Informática Lda.
   4. António Martins (2004), “Excel aplicado à gestão”, 2ª edição, Edições Sílabo.
   5. Jorge Sequeira (2005), “Excel – guião de funções para Economia e Finanças”, Escolar Editora.
   6. Katherine Smith, Smith Murphy and Lawrence Smith (2002), “Microsoft Excel for Accounting:
   TheFirstCourse”, Prentice Hall.
   7. Bill Jelen(2010), “Microsoft Excel 2010 in Depth”, QUE.
   8. John Walkenbach(2010), “Excel 2010 Bible”, John Wiley& Sons.