Intraclass #14

Date: Monday, December 17th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Free software applications (CALC)

Objective: Operate macros and functions in free software to understand their operation.

Description of the class:

Apply macros, development buttons, logical operators, and functions such as SI.ERROR 

and SEARCH.V through the use of tools established in the free software CALC.

File of work

File of work

Intraclass #13

Date: Monday, December 10th, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1 level "A"

Topic: Macros in excel

Objective: Operate basic macros to understand how they work

Description of the class:

A macro is an action or a set of actions that can be executed as many times as you want. When a macro is created, mouse clicks and keystrokes are recorded. In addition, for the execution of these we can use development buttons and functions like BUSCARV.

File of work

File of work

Evaluation

Date: Monday, December 03rd, 2018

Name: Anthony Barrezueta

Career: Tourism

Level: 1° level "A"

Topic: Evaluation of the first partial

File of work

File of work

File of work

File of work

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