Curricular Unit:Code:
Programming in Excel831PEXC
Year:Level:Course:Credits:
3UndergraduateComputer Systems Engineering4 ects
Learning Period:Language of Instruction:Total Hours:
Portuguese/English52
Learning Outcomes of the Curricular Unit:
In Computer Systems Engineering course it is important to know how to use the computer in solving problems, so it is required that students know their programming and logical reasoning. In this UC the technical knowledge of programming that allows developing logical reasoning is provided, as well as the VBA (Visual Basic for Applications) language, which allows the students learning a versatile language with an accessible base in their professional life.
Syllabus:
1. Elements of Logic and Mandatory Programming
1.1. Terms and Propositions;
1.2. Logical operations;
1.3. Properties of logical operations;
1.4. Propositional expressions;
1.5. Conditions: universal, impossible and possible;
1.6. Formal implication;
1.7. Quantifiers.
2. Algorithms
2.1. Pseudocode;
2.2. Basic tools for all programming languages;
2.3. Indexed variables.
2.4. Numerical applications and manipulation of vectors and matrices
2.5. Recursive programming
2.6. Large-scale programming: modular programming method based on object-based layers.
3. VBA language in Excel
3.1. VBA environment;
3.2. Elements: characters, constants, variables and arithmetic operators;
3.3. Functions, arithmetic and logical expressions;
3.4. Matrices and Arrays;
3.5. Programming: sequence control instructions;
3.6. Interaction with Excel;
3.7. Macro recording in programming support.
Demonstration of the Syllabus Coherence with the Curricular Unit's Objectives:
The syllabus presented are consistent with the learning objectives of the curricular unit since there is a large convergence between the table of contents and the knowledge that the student is supposed to acquire in each of the program topics. The fundamental concepts of algorithm and computation are presented in the introductory chapters, in the following chapters are presented the fundamentals of computer programming.
The learning objetives are achieved by supplementing the theoretical concepts with concrete examples and exercises run in lab environment using VBA language in Excel.
Teaching Methodologies (Including Evaluation):
Teaching programming by increasing the complexity of solved problems as the instructions are presented, beginning by addressing some algorithmic techniques. In the lessons examples with the computer will be given and students will develop and test their own programs in solving various problems.
The evaluation includes:
• Individual written tests (60% average of tests)
• Individual practical work (30%)
• Student performance, including attendance, resolution of proposed problems and active participation in classes (10%).
Demonstration of the Coherence between the Teaching Methodologies and the Learning Outcomes:
The teaching / learning methodology applied in this curricular unit as well as its evaluation system is perfectly aligned with the objectives to be achieved by the students at the end of the school term. Theoretical concepts are presented, discussed, applied and evaluated in the context of classes, which guarantees students a solid foundation of fundamental knowledge. On the other hand, for the study not to be restricted to conceptual models, are also presented concrete case studies and implemented solutions to real problems using Excel VBA. In this curricular unit the concepts related to algorithm and programming are presented and evaluated and are then applied in problem solving in the context of Computer Systems Engineering.
Reading:
[1] Cormen, Thomas H.; Introduction to algorithms
[2] Jelen, Bill : Macros e VBA para Microsoft Excel / Bill Jelen e Tracy Syrstad ; trad. de Altair Dias Caldas de Moraes. - Rio de Janeiro : Elsevier, 2004. - 576 p. : il. ; 24 cm. - Tít orig.: "VBA and Macros for Microsoft Excel"