|
Standard |
|
R State
Standard £
Developed College: n/a |
|
ACC 106 – 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 |
|
|
|
|
|
Save data in appropriate formats for different uses |
|
|
|
Suggested
Resources |
|
Media |
Note: Please adhere to the APA Formatting and
Style Guidelines. Duncan, G.J., & Brooks-Gunn, J.
(Eds.). (1997). Consequences of growing
up poor. New York: Russell Sage Foundation. |
|
Print |
Marder, J. & Stolins, R. (2007). Microsoft Office Excel 2007: Comprehensive
Course. El Sobrante, CA: Labyrinth. |
|
Owen, G. (2003). Excel and Access for Accounting. Ohio:
Cengage. |
|
|
Parsons, J.,Oja,D., Ageloff, R., & Carey, P. (2008). New Perspe |