PROCESS OF INTEGRAL PROFESSIONAL TRAINING MANAGEMENT

LEARNING GUIDE FORMAT

1. IDENTIFICATION OF THE LEARNING GUIDE

Microsoft Tools Management

OFFICE 2016: EXCEL

Training Program Code: 22810744 Version 3

Competence: Apply information technologies considering the needs of the

administrative unit

Learning Outcomes Achieved:

• Identify Microsoft Excel tools for managing information according to the
needs of the organization.

Duration of the Guide: 10 Hours

[Link]

Dear learners:
Welcome to the training program Management of
Microsoft Office 2016 tools: Excel, which allows you
will allow performing tasks of various kinds in spreadsheets
to present the information through tables and formats
that include the use of mathematical processes and formulas,
facilitating additionally, the creation of graphics for the
schematization of the data.

This training process begins with the review of the interface of the Microsoft Excel tool.
2016, where you will be able to learn about editing tools and the implementation of calculations
basics. It is also requested that you carefully review the Training Material and compare
applying what is presented there in your daily use files.

To strengthen and support your learning process, activities have been proposed that will
they call for reflection, critical thinking, and the application of what has been learned in their context
work and personal. For this, it is necessary to remember the use of bibliographic sources, in a way
of consultation. Your commitment and punctuality in delivering activities is essential for a
appropriate process and completion of the program
 3. FORMULATION OF LEARNING ACTIVITIES

3.1 Initial Reflection Activities

The following activities aim to appropriate the virtual environment and each of them
its components. First of all, we invite you to:

1. To start, it is very important that you access the platform and explore all the options.
the same, for this it is useful to review the following video:
The request does not contain translatable text.
c66a30ef9___.mp4
There you will find the guidelines for working in TERRITORY.
Additionally, you should perform the following initial activities that you find in the path: Content
of the course / Initial activities

✓ Develop the induction evaluation.

✓ Conduct the survey of prior knowledge.
✓ Introduce yourself to your colleagues in the social forum.

2. Consult the button 'COURSE CONTENT/ Program Information' in the menu of

training program to understand its description and the methodology to follow.

3. To initiate an initial reflection, based on your prior knowledge, you are invited to
reflecting on the following question, how does the tool
Could Excel improve your information management both personally and professionally?

3.2 Contextualization activities and identification of necessary knowledge for the

learning

In the Study Material corresponding to this Learning Activity, the

components of the Excel 2016 spreadsheet tool that allow you to edit information and
the introduction of simple functions and formulas.

However, to achieve the proposed learning outcomes in this program is

it is necessary to start from the clear identification of the teaching and learning objectives determined to
based on the contents, the nature of these, and always seeking for the learner to achieve
meaningful learnings and consequently I was able to replicate what I learned in my tasks through
their formative process.

Evidence: Thematic Forum No. 1 "Excel and the Development of Skills".

In the forum, the development of two actions is expected, which initially correspond to expressing their
opinions or knowledge about the discussion question; next, review and read the answers
from their fellow participants so that they respond to at least two of their peers, in a manner
argumentative your opinions on the responses given. It's not about saying whether you agree or not.
Simply put, it is about arguing about the opinions of your colleagues.

The reflection and discussion in the forum starts from the following question:

How does this office tool facilitate your work and allow you to
develop new skills in the management of Information Technologies and
Communication (I.C.T.)?

Argue your response based on the knowledge you analyzed in the Program Materials and
consultations made in other sources, without forgetting to cite them correctly. Reflect on the
responses from your peers and share your comments. Please note that, in order to give the
relevant contributions, it is necessary to review what they have commented.

Your participation in the forum must be argumentative. This means you should provide the references that
they originated their point of view. Similarly, the response that must be made, at least to the participation of two of
Your companions must be supported by the concepts learned.

The forum is available in two spaces: the first one from the button Forums / Thematic Forum 1
Excel and skill development, in the main menu of the program or in the folder
Learning Activity 1.

3.3 Knowledge appropriation activities (Conceptualization and Theorization)

Evidence: Interactive activity 'Skills Development in Excel Part 1.'

For the development of the interactive activity, you must answer the 10 multiple-choice questions with
unique answers related to the interface, Excel editing tools, and simple functions.

It is important that you successfully carry out the actions requested by the interactive activity.
The result I obtain will be sent to the grading center once I finish the
activity. This activity has a maximum of two (2) attempts per learner.

To access the interactive activity, refer to the main menu, following the path that starts from the
Button Course Content / PROJECT / Activity 1 / Evidence: Interactive Activity
"Development of Skills in Excel Part 1"

3.4 Knowledge transfer activities

Evidence: Workshop "The Excel 2016 Interface".

For an appropriation and application of the necessary knowledge offered by this Activity
Learning, you are invited to review the training material and the proposed supporting materials.
The activity that must be developed consists of a workshop related to the week's contents. Read.
Attend the workshop and provide solutions to the questions and/or requests raised there.

Send the evidence (spreadsheet) through the space found in the button.
EVIDENCES of the course menu.
Remember that this activity is graded and the submission will be recorded in the gradebook.
within the times assigned by your tutor. In this same space is the document with
the guidelines.

4. EVALUATION ACTIVITIES

Take as a reference the evaluation techniques and instruments mentioned in the Development guide.
Curricular

Evidence of Criteria of Techniques and Instruments

Learning Evaluation of Evaluation

Evidence Enter information into a Techniques:

Knowledge: spreadsheet having in
count the tools Formulating questions. of
Evidence: Activity basics of Microsoft Excel. of
interactive Development of Assessment questions.
skills in Excel
Part 1. in

Instruments:

Present the information T.I.G.R.E. Rubric

Evidence of from a spreadsheet to Checklists.
Performance: from the Questionnaire. Link
defined requirements.
willing
Thematic forum 'Excel and the' Territory
development of skills.
 Product Evidence:

Workshop 'The Excel Interface'

2016.

5. GLOSSARY OF TERMS

Formula bar: it is the space where the values or expressions that are written appear.
in the cells, it is located at the top of the sheet, below the ribbon of
Excel.

Cell: a cell in Excel is the intersection of a row and a column, it can contain
text, numbers, date, instructions, functions or other data can also be combined
calculation with data or instructions provided on other sheets of the workbook.

Column: in Excel, a column is a grouping of cells that are arranged vertically

from top to bottom of the workbook. The columns are identified by a letter that
It is at the top of the column.

Data: a piece of data in Excel corresponds to the information that is stored in the cells of the sheet
calculation. In general, each cell has a single type of data, in addition to being stored in Excel, the
Data can be used to perform calculations, create graphs, search for information or filter.
values, the three types of data commonly used in Excel are: text data, data
numerical and formula-type data.

Excel: software that allows you to perform accounting and financial tasks thanks to its functions,
specifically designed to help create and work with spreadsheets.

Row: the rows are identified by a number that is located on the left side of the
document. This number is known as the row header and ranges from 1 to 65,536. In total, there are
65,536 rows in each Excel spreadsheet indicate how far an object is from the
left to the current position.

Spreadsheet: it is software through which numerical data can be used and operations can be performed.
automatic calculations of numbers that are in a table. It is also possible to automate
complex calculations when using a large number of parameters and when creating tables called sheets of
work.

Microsoft Office: is a suite of office software programs developed by

Microsoft Corp. (an American company founded in 1975). It is a set of
applications that perform office tasks, that is, that allow for automating and perfecting the
usual activities of an office.

Syntax: a set of rules that define the correct sequences of elements in a language
of programming.

Trend: the trend function (known_y, known_x, new_matrix_x, constant) is used

to perform linear regression.

[Link] REFERENCES

Cavsi. (f.s.) Definition of Cell. Consulted on December 17, 2015, at:

What is an Excel cell?

Cavsi. (s.f.) Definition of Column. Consulted on December 17, 2015, at:

What is an Excel column?

Cavsi. (n.f.) Definition of Data. Consulted on December 17, 2015, at:

What is data in Excel?

Cavsi. (s.f.) Definition of Row. Consulted on December 17, 2015, at:

What is an Excel row?

CCM. (2015). Definition of Spreadsheet. Retrieved on December 17, 2015, at:

[Link]

Definition of Excel. Consulted on December 17, 2015, at:

Cannot access external links or provide content from URLs.

Definition of Microsoft Office. Consulted on December 17, 2015.

[Link]

Raymundoycaza. (n.d.) Definition of Formula Bar. Consulted on December 17, 2015.

[Link]

RAE. (2015). Definition of Syntax. Consulted on December 17, 2015, at:

Invalid URL format. No text to translate.

National Learning Service, SENA. (2010). Management of Microsoft Office Tools

2010: Excel. Colombia: Author.
Support Microsoft. (2015). Definition of Trend. Retrieved on December 17, 2015, from:
Unable to access external links for translation.

[Link] CONTROL

Name Cargo Dependency Date

Center of the
Diana Rocío
Advisor Design Technology and
Possos Beltrán
pedagogical Productivity
Author Business
December 2015
Center of the
Sandra Milena
Publisher of Design Technology and
Rodriguez
Content Productivity
Alvarez
Business
Center of the
Juan PabloVale Leader Design and Technology
Business Productivity

8.(fill out only if adjustments are made to the guide)

Name Cargo Dependency Date Reason del

Change
Mary
CTPI -
Alejandra Instruction 01/06/2
Author(s) Regional UPDATE
López you 020
Cauca
Hurtado