Notes for the course of Excel freely available on the Moodle page of the course.
Learning Objectives - Part A
Learning of the mathematical formalism relevant to the characterizing courses of the cursus studiorum.
Learning Objectives - Part B
Learning of some tools of excel relevant to the characterizing courses of the cursus studiorum.
Prerequisites - Part A
Arithmetics of real numbers.
Notions of synthetic geometry.
Notions of literal calculus.
Prerequisites - Part B
Arithmetics of real numbers.
Notions of synthetic geometry.
Notions of literal calculus.
Teaching Methods - Part A
Frontal lessons complemented with recorded videos available on the Moodle platform.
Teaching Methods - Part B
Frontal lessons complemented with recorded videos available on the Moodle platform.
Further information - Part A
Every student in need of specific auxiliary support can request it by email to the professor.
Further information - Part B
Every student in need of specific auxiliary support can request it by email to the professor.
Type of Assessment - Part A
Mandatory written and oral exam. In November an ongoins test is offered valid for the written part.
Type of Assessment - Part B
The examen consits in a practic exercise solved with excel software; it can be in alternative the resolution in itinere of some exercises during the exercitations in laboratory.
Course program - Part A
Real numbers and algebraic laws: powers of ten; percent and proportions; means.
Algebraic expressions: verification of correctness; ste of variability; subordinate expressions; conditions for existence; domain; transformation of an expression.
Euclidean distance: Cartesian coordinates on a straight line, on a plane, on the space; Pythagoras theorem and calculus of distance.
Angles: not oriented and oriented; sine, cosine, tangent, cotangent, and their inverse of the measure of an angle; polar coordinates.
Straight lines on a plane: how to determine the cartesian equation.
Vectors, scalar product, sum of vectors, product of a scalar times a vector, canonical writing of a vector; orthogonal projection of a vector; cross product.
Equations and inequalities: techniques to solve them; determination of the sign of expressions.
Differential calculus: monotonicity and sign of first derivative; theorems on differentiable functions; critical points.
Integral calculus: definite and numerical techniques of computation of area.
Course program - Part B
The relative and absolute referement in Excel, numerical tratement of data, tables. Formulas and funciotns. graphics, ricerca obiettivo , maximum and minimum problems.