UNIVERSITY

PRIVATE OF. NORTH

SYLLABLE OF THE BUSINESS COMPUTER COURSE I

I. GENERAL INFORMATION:

ADMINISTRATION AND
Faculty Business Career Cycle 2° Credits 3
MANAGEMENT OF HUMAN
TALENT H.T. H.P. H.L. PC
School period 2021-1 Requirements COMPUTER TOOLS (*) Hours
0 0 4 2
The course contributes to general competence: Creative and Critical Thinking : The student explores and evaluates problems to develop and argue his
or her own position or creative proposals for solutions.
The course contributes to the specific Process Management : Develops proposals for improvement in the organization's processes, considering
competence(s): their impact in various scenarios of human talent management.
The course develops the component: Investigation IX Social Responsibility □ Citizenship □ Pre-professional practice
“In the current academic semester, due to an exceptional situation in the country, the sequence and/or modality of the activities for the development of □
content and/or evaluations could be reformulated, depending on the provisions issued by the government of Peru and the university"

II. SUMILLA:

The course is of a theoretical and practical nature, the purpose is to develop in the student skills for the management and application at an advanced level
of the MS Excel spreadsheet, which allows the application of advanced functions to streamline and automate tasks, allowing decision making. at the
highest management level. The main topics are: Ms Excel environment. Functions, Filters, Sorting, Charts, Schemes and Subtotals, Forms, Scenarios,
Excel Add-ins, Dynamic Tables and Charts, External Data, Data Analysis and Macros.

III. COURSE ACHIEVEMENT:

At the end of the course, the student efficiently applies the topics learned and will be able to apply appropriate functions for the calculation of financial
statements, rates, payment methods, investments, profits and portfolio management, analyze data with the use of dynamic reports, streamline tasks with
the use of forms and automate repetitive processes through macros.

IV. ORGANIZATION OF LEARNING UNITS:

UNIT UNIT NAME/ACHIEVEMENT SEM ESSENTIAL KNOWLEDGE PC ACTIVITIES (*)

• Entry exercises: diagnosis and recapitulation of what has

been seen in MS Excel in Computer Tools.
1
• Formats and Styles: tables, cells, conditional, general
format, adjust, justify data.
Basic use of the MS Excel spreadsheet.
At the end of the unit, the student solves
practical cases, using the MS Excel • Basic operations: basics of a formula, priority of operators,
environment, formats and styles, basic references to cells in formulas, modifying formulas, error
2 values, naming cells and cell ranges.
Yo operations, data validation and date
functions, text, mathematics and • Data Validation: Data Validation, Skip Blanks, Create
statistics basic, Validation, Validation List, Customize Error Message,
Delete Data Validation.
demonstrating order and coherence in
information.
3
• Introduction to functions: syntax, buttons, insert a
function, autocomplete formula.
• Date and Text Functions
4 • Mathematical and Statistical Functions
• T1 EVALUATION See annex of
5
• Search and logic functions field practice
activities
Intermediate handling of MSExcel
6
• Database: filters, sorting, graphics and DB functions.
II
At the end of the unit, the student manages
Databases, applying different types of
• Schemes and Subtotals: definition, components,
preparation of source data, automatic creation and
functions and editions, to solve business manual creation.
7
cases for the good of companies.
• Form controls: programmer tab, form controls, application
of controls.

• T2 EVALUATION
Advanced use of MS Excel.
At the end of the unit, the student will use
• Scenarios: creating scenarios and searching for
objectives.
8
scenarios and complements of the tool and
external data to process, analyze, consolidate
• Excel Add-ins: Solver, Installation, Create Model, Add
Constraint, Change or Delete Constraint, Dialog Square.
III and present data, demonstrating mastery in
the management and application of said 9 • Excel add-ins: MegaStat, installation, add MegaStat,
statistics exercises.
tools.
10 • Access to external data: create, edit and manage
connections.
 UNIVERSITY
PRIVATE OF. NORTH

• Data analysis tools: consolidate, formula audit, search

object, data table.

• T3 EVALUATION
MS Excel for Business.
At the end of the unit, the student supports an 11
• Financial Functions: calculate investments, functions VA,
NPV, VF, PAYMENT, PAGOINT, PAGOPRIN, NPER,
application project through the use of RATE, IRR, TIRM
financial functions, tables and dynamic
graphs and recording of macros, 12 • PivotTables and Charts: Environment Description, Fields
Panel, Report Creation, Calculation Operations,
demonstrating competence in solving a PivotChart Reports.
business case. 13
• T4 EVALUATION
IV
• Macros: procedures and functions, recording, modifying
14 and running macros, assigning buttons to a macro, saving
workbooks that contain macros, macro security.

15 • T5 evaluation
16 FINAL EVALUATION
17 SUBSTITUTE EXAM
(*) PC= Field Practice. / Field practice only applies to courses that have PC hours declared in the Curriculum / Field practice activities are
detailed in the field work sheet that is attached to the syllabus.

V. EVALUATION SYSTEM

ASSESSMENT PESOS SEM Evaluation Description

T1* 12% 4 Evaluation T1: Theoretical and practical exam.

T2* 12% 8 T2 evaluation: Theoretical and practical exam.

T3* 12% 11 T3 Evaluation: Average reports and project progress.

T4* 12% 14 T4 Evaluation: Average of reports and Project Presentation.

Evaluation of Field Practice activities described in the annex
T5*
12% 15
Practical field evaluation
FINAL EVALUATION 40% 16 Final evaluation

SUBSTITUTE EVALUATION -- -- DOES NOT APPLY

*Qualifiers must be published in the system according to the Academic Calendar established for this Semester.
SAW. BASIC BIBLIOGRAPHY:

No. AUTHOR QUALIFICATION YEAR URL LINK

Juan Carlos Vergara Schmalbach [Link]
[Link]?docID=3201214
and Víctor Manuel Quesada Ibargüen Application development in
1 2011
Microsoft Excel: 12 practical
cases solved step by step

VII. ADDITIONAL INFORMATION:

TO. IMPORTANT LINKS.

TOPICS LINKS
Basic Excel Course [Link]
 ANNEX OF FIELD PRACTICE ACTIVITIES ( COMPUTER COURSE FOR BUSINESS I)

Week (From/To) Activity Evidence of Field Practice Evaluation Date of delivery

Instrument
Form teams of 4 members with their Delegate's report showing the groups formed
classmates of class for the and the coordinators of each team.
1 Check list Week 2
presentation of class workshops during
the course.
2 Prepare the first class workshop called: Link to the report on the development of Week 3
Ms. environment. Excel. each group's workshop in the Google drive Check list
that is attached to the Portfolio.
4 Develop 4 data validation exercises in Link to exercises in the Google drive that is Week 5
Ms. Excel. attached to the portfolio. Check list
5 Research about the applications of Deliver report with the development for the Week 6
functions in Ms Excel. portfolio. Check list
6 Prepare the second class workshop Link to the report on the development of Week 7
called: functions in Excel. each group's workshop in the Google drive Check list
that is attached to the Portfolio.
8 Create a database in Ms. Excel related Database link in the Google drive that is Week 9
to your specialty. attached to the portfolio. Check list
9 Make an invoice or receipt form in Ms. Form link in the Google drive that is attached Week 10
Excel. to the portfolio. Check list
10 Link to the report on the development of Week 11
Prepare the third class workshop called: each group's workshop in the Google drive Check list
exercises with Solver and MegaStat. that is attached to the Portfolio.
11 Development of a practical case on the Group reports in Google Drive Week 12
application of financial functions to a Review Guide
specific company
12 Case development with application of Group reports in Google Drive Week 13
Review Guide
dynamic tables
13 Preparation of comprehensive project for Group reports in Google Drive Group work Week 14
business application rubric
14 Progress of the comprehensive project Group reports in Google Drive Group work Week 15
applying various functions and macros rubric
15 Progress of the comprehensive project Group reports in Google Drive Group work Week 16
applying various functions and macros rubric
16 Preparation and review of knowledge Practical case Qualification Week 16
developed for the final exam record
17 Final exam