Intraclass #12

Date: Wednesday, November 28th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Database management

Objective: Perform database manipulation operations such as filters, statistical explanation and graphics.

Description of the class:

Through the data analysis, the functions CONTARA and CONTAR.SI were applied, these are useful to know the number of answers of a certain question. In addition, the theme of filters and advanced filters was analyzed.

File of work

Intraclass #11

Date: Monday, November 26th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: The functions

Objective: Analyze the main functions of Excel and its application in the resolution of cases through machine operation.

Description of the class:

An invoice was made, using the operators previously seen and a new function, the SI.ERROR function. In addition, new options were used, such as: data validation, leaf blocking, and formula display. Then, another topic was analyzed, forms controls, where the function of each developer was explained.

File of work

File of work

File of work

Intraclass #10

Date: Wednesday, November 21st, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Lesson

Description of the class:

An evaluation was made about all the topics seen in class.

File of work

Intraclass #9

Date: Monday, November 19th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: The excel operators

Objective: Analyze operators through hotel exercises to assimilate the operation.

Description of the class:

We solved exercises manually, using relational and logical operators. In addition, the flow diagrams were used, both for the Function Si and for the Function Y.

File of work

Intraclass #8

Date: Monday, November 12th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Excel environment

Objective: Operate the management of functions and operators by applying exercises to master the synthesis.

Description of the class:

Exercises were performed through the use of operators. In addition, it was indicated how to insert statements within the formulas used and analyzed the components of a flow chart.

File of work

Intraclass #7

Date: Wednesday, November 7th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Excel functions

Objective: Operate the function..... then......else, through practical cases for assimilation.

Description of the class:

We make a reminder of the relationship operators and logical operators through an exercise. Then, we analyze how to apply the SI function together with the previous topics, through the resolution of exercises.

File of work

Intraclass #6

Date: Monday, November 5th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Excel and its functions

Objective: Analyze the most used operators through the development of exercises, for their understanding.

Description of the class:

We analyze the functions of the mathematical operators, both in their form 1 and 2, and then perform exercises using the formulas. Then, we review the relationship operators and logical operators. Finally, we solved problems on the subject.

File of work