|
Standard |
|
R State Standard £ Developed College: n/a |
|
BUS 2120 – Spreadsheet Applications |
|
|
|
Course Description |
|
Provides instruction in the use of
electronic spreadsheet software in business applications. Students become proficient in creating and
modifying spreadsheets in a business environment and in printing files that
meet business standards. Topics
include: spreadsheet concepts, data
entry and modification, analyzing data, charts and graphs, formatting data
and content and managing workbooks. |
|
Competency Areas |
Hours |
|
|
Spreadsheet Concepts |
Class |
1 |
|
Data Entry and
Modification |
D. Lab |
4 |
|
Analyzing Data |
P. Lab/O.B.I. |
0 |
|
Charts and Graphs |
Credit |
3 |
|
Formatting Data and Content |
|
|
|
Managing Workbooks |
|
|
|
Prerequisite:
SCT 100 |
|
|
|
Corequisite: |
|
|
|
Course
Guide |
|
Competency |
After
completing this section, the student will be able to: |
Hours |
||
|
Class |
D.Lab
|
P.Lab/ O.B.I. |
||
|
SPREADSHEET
CONCEPTS |
1 |
4 |
0 |
|
|
|
Define basic terminology relating to a spreadsheet program |
|
|
|
|
|
Create, update, and delete files and folders |
|
|
|
|
|
Save a file to various locations |
|
|
|
|
|
Retrieve files from various locations |
|
|
|
|
|
Start and exit a spreadsheet program |
|
|
|
|
DATA
ENTRY AND MODIFICATION |
1 |
4 |
0 |
|
|
|
Enter and edit alphanumeric cell content |
|
|
|
|
|
Locate specific cell content |
|
|
|
|
ANALYZING DATA |
2 |
8 |
0 |
|
|
|
Insert and modify formulas |
|
|
|
|
|
Use statistical, date and time, financial,
and logical functions |
|
|
|
|
CHARTS
AND GRAPHS |
2 |
8 |
0 |
|
|
|
Understand the most commonly used chart
types |
|
|
|
|
|
Create, modify, and position diagrams and
charts based on worksheets data |
|
|
|
|
Formatting Data and
Content |
2 |
8 |
0 |
|
|
|
Apply and modify cell formats |
|
|
|
|
|
Apply and modify cell styles |
|
|
|
|
|
Modify row and column formats |
|
|
|
|
|
Format worksheets |
|
|
|
|
Managing Workbooks |
2 |
8 |
0 |
|
|
|
Create new workbooks from templates |
|
|
|
|
|
Insert, delete, and move cells |
|
|
|
|
|
Create and modify hyperlinks |
|
|
|
|
|
Organize worksheets |
|
|
|
|
|
Preview data in other views |
|
|
|
|
|
Customize window layout |
|
|
|
|
|
Setup pages for printing |
|
|
|
|
|
Print data |
|
|
|
|
|
Organize workbooks using file folders |
|
|
|
|
|
|
|
|
|
|
Suggested
Resources |
|
Media |
|
|
Print |
Rutkosky, Nita (2008). Benchmark Series: Microsoft Excel
2007: Excel-Windows XP Edition or Vista Edition. EMC Paradigm. |
|
Rutkosky, Nita (2008). Marquee Series: Microsoft Excel
2007. EMC Paradigm. ISBN: 978-0-76382-961-2. |
|
|
Shelly, Gary B.,
Cashman, Thomas J., and Quasney,
Jeffrey (2008). Microsoft Excel 2007 Comprehensive Concepts and Techniques.
Course Technology-CENGAGE Learning, Mason, OH. ISBN: 978-1-4188-4344-1. |
|
|
Shelly, Gary B.,
Cashman, Thomas J., and Quasney,
Jeffrey (2008). Microsoft Excel 2007 Complete Concepts and Techniques. Course
Technology-CENGAGE Learning, Mason, OH. ISBN: 978-1-4188-4343-4. |
Posted: 10/28/08