|
Official Course Description:
MCCCD Approval: 10-22-1991 |
|||||
|
BPC114DE
1992 Fall – 2011 Fall |
L+L
3.0 Credit(s) 5.0 Period(s) 4.4 Load Occ |
||||
|
Excel
Spreadsheet |
|||||
|
Computer spreadsheet skills for solving business problems
using Excel, including calculations, forecasting, projections, macro
programming, database searching, extraction, linking, statistics, and matrix
manipulation. Production of graphs and reports. Project design using
multiple, integrated spreadsheets. Prerequisites: None. |
|||||
|
Cross-References:
CIS114DE
|
|||||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
BPC114DE 1992
Fall – 2011 Fall |
Excel Spreadsheet |
|
1.
|
Load and set up the spreadsheet program. (I) |
|
2.
|
Create a properly-formatted worksheet file. (II) |
|
3.
|
Organize a problem for solution with spreadsheet software.
(III) |
|
4.
|
Apply the
principles of effective worksheet and database layout in building a
spreadsheet template, using labels, numbers, and formulas. (III) |
|
5.
|
Enter, delete, and alter spreadsheet data. (IV) |
|
6.
|
Save a spreadsheet to disk and retrieve it. (V) |
|
7.
|
Print a spreadsheet on the printer and on disk, using
spreadsheet print capabilities to enhance printed output. (VI) |
|
8.
|
Sort a spreadsheet in a variety of ways. (VII) |
|
9.
|
Use spreadsheet functions to prepare and print graphs.
(VIII) |
|
10.
|
Create and use complex spreadsheet macros. (IX) |
|
11.
|
Use the spreadsheet's database techniques to locate, link,
extract, and combine data from multiple spreadsheets. (X) |
|
12.
|
Use built-in statistical analysis features of spreadsheet
software. (XI) |
|
13.
|
Manipulate matrices with spreadsheet software. (XII) |
|
14.
|
Design and implement a spreadsheet project which includes
multiple, integrated spreadsheets. (XIII) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
|
|
|
|
|
BPC114DE 1992
Fall – 2011 Fall |
Excel Spreadsheet |
|
I. Spreadsheet concepts A. Loading B. Terminology C. Set up II. Creating worksheet file
A. Using proper keys B. Aligning data within
cells C. Reformatting data within
cells III. Spreadsheet template
definition and design A. Defining and organizing
the problem B. Designing a template to
solve the problem 1. Entering the formulas 2. Using proper symbols 3. Algebraic hierarchy 4. Using the spreadsheet's
built-in functions IV. Entering and modifying
data A. Entering new data B. Deleting existing data C. Modifying existing data V. Saving and retrieving
files A. Saving a spreadsheet on
disk B. Updating and correcting
spreadsheet file C. Replacing a spreadsheet
file VI. Printing a spreadsheet A. Controlling margins and
options B. Printing on the printer C. Printing on the disk D. Enhancing reports VII. Sorting a spreadsheet A. Sorting in ascending
order on rows or columns B. Sorting in descending
order on rows or columns VIII. Creating and printing
graphs A. Creating graphs B. Printing graphs IX. Spreadsheet macros A. Creation B. Use X. Spreadsheet database
techniques A. Searching B. Linking C. Extracting D. Combining XI. Use of spreadsheet
statistical functions XII. Matrix manipulation XIII. Integrated
spreadsheet project A. Design of spreadsheets
for integrated systems B. Building of templates C. Entry and manipulation
of data D. Production of
appropriate reports and graphs |