Sequência didática: atividades para o ensino-aprendizagem da planilha eletrônica através da simulação de processos administrativos

Abstract

This material represents the final product of a Master's Degree dissertation that aims to expand the possibilities of the pedagogical making of the Basic and Advanced Computer Science classes for Professional Education students through a didactic sequence that contemplates, in its methodology and approach, to stimulate the thinking through simulations of with the spreadsheet as a tool. The proposal of a didactic sequence aims at the development of strategies to facilitate the understanding of the topics addressed through the implementation of learning situations whose intention is to promote the understanding of the subjects and that these are in accordance with what students will have to face in their daily work as apprentices. Although the Basic and Advanced Computing course consists of several modules, this material intends to focus only on the Electronic Spreadsheet module and is composed of 5 regular 4-hour classes using materials that are easily accessible to students. During the classes, subjects related to the spreadsheet will be approached, such as formulas, mathematical functions, search functions, database functions, table formatting, dynamic tables, data validation, meta, solver, spreadsheet automation and form controls. objectives: to guide the students to a reflection about the proposed content, in the sense of encouraging the construction of skills that can stimulate Computational Thinking; to provide students with familiarity and exploration of the potentialities of the spreadsheet, specifically Microsoft Excel software, in the simulation of learning situations involving processes related to the administrative activities of a company; concepts of Computer Science to assist in the construction of automated solutions for problems that allow the use of the computer through the spreadsheet, allowing the student to see the result of their work. Considering that in a classroom not everyone learns in the same way, one looks for the didactic sequence and through a planning and a set of activities, to reach the objectives proposed in each planned stage. And, if learning does not happen immediately, create the possibility that it may occur in the future through the practice of computational thinking. Thus, this material does not intend to exhaust the pedagogical possibilities of the classes of Basic and Advanced Computing, much less be considered infallible in its objective. On the contrary, considering that each class has its characteristics and peculiarities, it is a suggestion of activities to be developed in the search to contribute to the practice of teachers, in order to make IT more interesting and motivate them to continue searching for methodologies of teaching and tools favor thinking organization and problem solving, which are Computational Thinking skills, as well as taking full advantage of the educational potential of computers and digital technologies