Taller Uno
Aplicaciones para la
Administración de Negocios
Agenda para hoy
• Registro de estudiantes en la clase
– Blackboard Academic
•
•
•
•
•
Proceso de ‘CHECK-IN’
Evaluación de estudiantes
Presentación de grupo
Examen final
Como luce la clase en los próximas 8
semanas
Agenda para hoy
• Taller Uno
– Aplicaciones generales de software y sus
funcionalidades
– Hojas de cálculos / Historia
– Como se comienza Excel
– Aspectos de Excel
– Menús básicos de Excel
– Conceptos de filas, columnas y celdas
– Tipos de datos, alineamientos
– Editar, insertar y eliminar
Check-In
• Proceso donde necesito estar seguro que usted
llego al salón
• ¿Esta usted aquí, AHORA?
– ‘BE HERE NOW’
• Ejercicios donde estaremos tratando que su
mente elimine lo que le esta molestando o lo
que le distraiga de la clase
•
•
•
•
•
•
•
Check- in >> Introducciones
Nombre completo
Algo personal de usted
A que se dedica o que hace además de
estudiar
Porque esta en el programa AHORA
¿Que opinión le merece el programa?
Tres actividades que hace y les gusta
hacer
Uno de ella no es cierta o a deseado
hacerlo y no lo ha podido hacer
Introducciones
• Ing. Gustavo A. Vélez, BSEE, MBA/TM
– Velez-Rodriguez Services
• Consultoría en Gerencia, Integración de sistemas y
Entrenamientos Gerencia/IT
• 34 años experiencia en sistemas de información
– Teléfonos
• Celular 787.413.2060 (Linda)
• E-mail: [email protected] ó
[email protected]
• Cinco años en el programa AHORA
• Tres actividades que me gusta hacer
– Una de ellas no es cierta
Evaluación del Estudiante
• Quizzes y asignaciones
8 x 20 puntos
• Diario Reflexivo
4 x 20 puntos
• Participación
8 x 10 puntos
160
80
80
– Laboratorios (7)
• Asistencia
8 x 10 puntos
• Examen (?)
1 x 100 puntos
• Presentación (grupal)
100 puntos
80
100
100
•
600
Total
Trabajos tardes
• Tienen una penalidad de 10%
• Siempre entregue los trabajos aunque
sea tarde
• Esto aplica a las pruebas cortas
Ausencias
• Debe comunicarse verbalmente con el
profesor antes o después de la ausencia,
luego enviara un correo electrónico al
profesor.
• De ser excusado por el profesor, el profesor
le asignara la puntuación adecuada que no
llegara al máximo de puntos.
• Los laboratorios y asignaciones no seran
excusadas.
Presentación Final
• Crear grupos de trabajos
• Proyecto de la clase
– Dos problemas de MS Excel
– Un proyecto de MS Access
– Dos publicaciones de MS Publisher
• Entregar en carpeta con una apariencia
bien profesional
Examen Final
• Incluye todos los temas desarrollados
en la clases y se toma en línea el ultimo
días de clase.
• Podrá utilizar presentaciones del
profesor, libro y cualquier otro material
que tenga disponible
• Tiene duración de una hora
Alcance del Curso
• Taller Uno
Excel – Operaciones Básicas
• Taller Dos
Excel – Operaciones avanzadas
• Taller Tres
Excel – Operaciones de manejo de datos
• Taller Cuatro
Excel – Gráficas y plantillas
Alcance del Curso
• Taller Cinco
Publisher – Operaciones básicas y
avanzadas
• Taller Seis
Access – Conceptos básicos
• Taller Siete
Access – Manejos de bases de datos
Taller Ocho
Presentaciones y Examen Final
Taller Uno
Application Software
What is application software?
• Programs that
perform specific
tasks for users
• Also called a
software
application or an
application
• Several reasons to
use application
software
Next
p. 3.2
To assist with
graphics and
multimedia
projects
To facilitate
communications
To serve as a
productivity/
business tool
To support
household activities,
for personal
business, or for
education
Application Software
What are the categories of application software?
Next
p. 3.2 Fig. 3-1
Application Software
What is system software?
• Programs that
control the
operations of
the computer
• Serves as the
interface
between the
user, the
application
software, and
the computer's
hardware
Next
p. 3.3 Fig. 3-2
Productivity Software
What is spreadsheet software?
• Allows you to
organize data
• Performs
calculations
• Called a
worksheet or
spreadsheet
Next
p. 3.12 Fig. 3-13
Productivity Software
How is a spreadsheet organized?

Columns identified
by letters
columns
Rows identified by
numbers
 A cell is the
intersection of a
column and row

rows
Next
p. 3.12 Fig. 3-13
cell
Productivity Software
What can a cell contain?
Label
Number
=SUM(A1:A5)
Formula
Next
p. 3.12
=C4+C5+C6+C7+C8
Productivity Software
What is a function?
• A predefined formula that performs common
calculations
=C4+C5+C6+C7+C8
=SUM(C4:C8)
PV
MAX
Next
p. 3.13
IF
NOW
LN
Productivity Software
What is recalculation?
• The capability of recalculating the rest of the
worksheet when data in a worksheet changes
• What-if analysis
New data
entered
Totals
recalculated
Next
p. 3.13
Projected College Cash Flow Analysis
Expenses
Room & Board
Tuition & Books
Clothes
Entertainment
Miscellaneous
Total
Freshman Sophomore
Junior
Senior
$ 3,290.00 $ 3,454.50 $
3,627.23 $
3,808.59 $
10,000.00
4,850.00
5,092.50
5,347.13
5,614.48
10,500.00
11,000.00
11,500.00
490.00
514.50
540.23
567.24
635.00
666.75
700.09
735.09
325.00
341.25
358.31
376.23
$ 14,740.00
9,590.00 $ 15,477.00
10,069.50 $ 16,225.86
10,572.99 $ 16,987.15
11,101.63 $
Total
14,180.32
20,904.11
43,000.00
2,111.97
2,736.93
1,400.79
41,334.12
63,430.01
Productivity Software
What is charting?
• Allows you to display spreadsheet data in graphical
form
line chart
pie chart
Next
p. 3.14 Fig. 3-15
column
chart
Productivity Software
What is a database?
• A collection of
data
organized in
a manner that
allows
access,
retrieval, and
use of that
data
Next
p. 3.15 Fig. 3-16
Productivity Software
What is database software?
• Allows you to create, access, and manage a
database
• Also called a database management system
(DBMS)
add, change,
and delete data
Next
p. 3.16
sort and
retrieve data
create forms
and reports
using the data
Productivity Software
What are the parts of a database?



A table contains records
A record is a row in a table that contains information about a given
person, product, or event
A field is a column in a table that contains a specific piece of information
within a record
fields
Item table
records
Next
p. 3.16 Fig. 3-16
Supplier table
Productivity Software
How is a database organized?
• Records and fields in a table are described by
the table structure
Item table
structure
Supplier table
structure
Next
p. 3.16 Fig. 3-17
Productivity Software
What does the table structure contain for each
field?
field name
field size
data type
Next
p. 3.16
Productivity Software
How do you extract information from a
database?
• Sort records in a particular order
• Query database
Next
p. 3.17 Fig. 3-19
Graphics and
Multimedia Software
What is desktop publishing software?
• Enables you to
design and
produce
sophisticated
documents that
contain text,
graphics, and
brilliant colors
Next
p. 3.23 Fig. 3-28
Excel
Hojas de Calculo
History of spreadsheet
• Spreadsheets have been
used by accountants for
hundreds of years.
• In 1978, Harvard
Business School student,
Daniel Bricklin, came up
with the idea for an
interactive visible
calculator. Bricklin and
Bob Frankston then coinvented or co-created
the software program
VisiCalc.
History of spreadsheet
• What is a spreadsheet?
In the realm of accounting jargon a
"spread sheet" or spreadsheet was and
is a large sheet of paper with columns
and rows that organizes data about
transactions for a business person to
examine.
History of spreadsheet
Electronic spreadsheet
• An electronic spreadsheet organizes information
into software defined columns and rows.
• The data can then be "added up" by a formula to
give a total or sum.
• The spreadsheet program summarizes
information from many paper sources in one
place and presents the information in a format to
help a decision maker see the financial "big
picture" for the company.
History of spreadsheet
What came after VisiCalc?
• The market for electronic spreadsheet software
was growing rapidly in the early 1980s and
VisiCalc stakeholders were slow to respond to
the introduction of the IBM PC that used an Intel
computer chip.
• Beginning in September 1983, legal conflicts
between VisiCorp and Software Arts distracted
the VisiCalc developers, Bricklin and Frankston.
• During this period, Mitch Kapor developed Lotus
and his spreadsheet program quickly became the
new industry spreadsheet standard.
History of spreadsheet
What is Lotus 1-2-3?
• Lotus 1-2-3 made it easier to use spreadsheets
and it added integrated charting, plotting and
database capabilities.
• Lotus 1-2-3 established spreadsheet software
as a major data presentation package as well as
a complex calculation tool.
• Lotus was also the first spreadsheet vendor to
introduce naming cells, cell ranges and
spreadsheet macros.
History of spreadsheet
What about Microsoft Excel and Bill Gates?
• The next milestone was the Microsoft Excel
spreadsheet.
• Excel was originally written for the 512K
Apple Macintosh in 1984-1985.
• Excel was one of the first spreadsheets to
use a graphical interface with pull down
menus and a point and click capability using
a mouse pointing device.
History of spreadsheet
What about Microsoft Excel and Bill Gates?
• The Excel spreadsheet with a graphical user
interface was easier for most people to use
than the command line interface of PC-DOS
spreadsheet products.
• Many people bought Apple Macintoshes so
that they could use Bill Gates' Excel
spreadsheet program.
• There is some controversy about whether a
graphical version of Microsoft Excel was
released in a DOS version.
From VisiCalc to Excel
Spreadsheet
• Microsoft Excel 2003
Microsoft Excel 2007
• Inicial Excel
Excel Basic
Nombre libro
Hojas de calculo
Menú básico
FILE
EDIT
VIEW
INSERT
FORMAT
Excel Basic
< Filas y Columnas
Columnas - A hasta 16,384
Filas - 1 hasta 1,048,576
>
>
Excel Basic
< Celda
Celda activa
>
Excel Basic
LABELS
Cualquier
título que el
usuario
desee
Excel Basic
Tipo de datos
•Alfanuméricos
•Numéricos
•Operaciones
matemáticas
•Funciones
Excel Basic
Excel Basic
Para editar celdas:
Puede usar la barra de
formulas
Ó directamente sobre la
celda
Excel Basic
Puede escribir
sobre la celda
un nuevo valor
Excel Basic
Ejercicio Uno
• Crear tabla con números y operaciones
matemáticas
– Entrar datos
– Formatear títulos
– Hacer operaciones matemática
– Crear funciones
Ejercicio Uno
Asignación Taller Dos
• Tomar la Prueba Corta número Uno
Preguntas
Taller Uno
Check-out
∆
+
Descargar

Document