Course Number: CA101S
Course Title: Computer Applications for Secretaries
STUDENT LEARNING OUTCOMES
General
To build on the
understanding of fundamentals in computer literacy, students will comprehend the
Microsoft Office Professional. Electronic Spreadsheet and Presentation will be
covered. Electronic Spreadsheet and Presentation will provide students with
comprehensive understanding of computer usage in personal and professional life.
Improve skill in speed building and control and maintain the minimum speed of 45
words a minute with error tolerance of 1 error per minute on a 5-minute writing.
Specific
1.
Plan a
worksheet, start Excel, enter labels and numbers, save a workbook, rename and print an Excel worksheet.
2.
Modify a
worksheet, and enter dates and formulas.
3.
Navigate a
worksheet and work with ranges. Name ranges, copy, move and clear cell
contents.
4.
Adjust
column width and row height, inset and delete column and rows, and add and
remove borders.
5.
Create
chart, modify, resize, move, add objects and text and print charts.
6.
Insert and
size an embedded picture and an Excel worksheet in word document.
7.
Protect and
unprotect a range of cells and worksheet.
8.
Format cells
and use Automatic Formatting to format a worksheet.
9.
Apply name
to cell range(s) and use in formulas.
10.
Hide and unhide column(s) and row(s).
11. Create a database - sort and find data in a
worksheet.
12. Manage database - filter database and create pivot table(s) and subtotal.
13. Use mathematical, statistical and financial function to perform business
calculations.
14.
Start Power
Point and define different parts of the Power Point Windows.
15.
Work in
slide, outline, slide sorter, and notes pageview to add, edit, delete and
rearrange slides. (Use drag-and-drop to move slide.)
16.
Save and
print a presentation.
17.
Use the
Autocontent wizard to create, resize and change text font of a presentation.
18.
Use Drawing
Toolbar to add objects to a
presentation.
19.
Insert,
resize, and recolor a clip art picture
and embed an Excel chart in a presentation.
20.
Create a
speaker notes. Insert a graph, using
tables and an insertion of an organization chart
21.
(Ming
reports using Word, and Excel in a
Power Point presentation.
22.
Recall and
improve keyboarding techniques.
23.
Identify and use the
proofreader's mark
24.
Type corrected copy
from rough drafts.