Division of
Business and Technology
COMPUTER
APPLICATIONS I
POFI
1401—Excel
Credit hours:
4
Offered in Spring 2008
Instructor:Jan Haynes,
Office Technology Coordinator
Phone:
806-665-8801 Ex 2012
Office Hours: Mon-Thurs.
9:00am-12 noon-1:00-4:00pm
Textbook: Shelly Cashman Quasney, MS Office Excel 2003, Shelly Cashman Series.
ISBN 1-4188458X
Statement of
Purpose: Partially satisfies the requirements for receiving the Certificate of
Office
Technology.
Course Description: The course is designed to teach the most common
spreadsheet computer applications that create, edit, format
and print worksheets; construct graphics, build data bases that utilize the
data table function. Students will be
given the opportunity to acquire hands-on experience using the designated
software packages.
Course
Objectives: The student will be able to complete the following at the end of
the course:
1.
Run MS Excel
2.
Describe the Excel worksheet
3.
Select a cell or range of cells
4.
Enter text and numbers
5.
Use the AutoSum button to sum a range of cells
6.
Copy a cell to a range of cells using the fill handle
7.
Change the size of the font in a cell
8.
Bold cell entries
9.
Center cell contents over a series of columns
10.
Apply the AutoFormat command to format a range
11.
Use the Name box to select a cell
12.
Create a 3-D Column chart using the Chart Wizard
13.
Save a workbook
14.
Print a worksheet
15.
Quit Excel
16.
Open a workbook
17.
Use the AutoCalculate area to determine totals
18.
Correct errors on a worksheet
19.
Use Office Assistant and other online Help tools to answer your questions
20.
Enter multiple lines of text in the same cell
21.
Enter a formula using the keyboard
22.
Enter formulas using Point mode
23.
Identify the arithmetic operators +, -, *, /, %, and ^
24.
Apply the AVERAGE, MAX, and MIN functions
25.
Determine a percentage
26.
Change the font of a cell
27.
Vary the font size of characters within a cell
28.
Color the characters and background of a cell
29.
Add borders to a range
30.
Format numbers using the Format Cells dialog box
31.
Align text in cells
32.
Change the width of a column and height of a row
33.
Check the spelling of a worksheet
34.
Create a 3-D Pie chart on a separate sheet
35.
Format chart items
36.
Rename sheets
37.
Preview how a printed copy of the worksheet will look
38.
Print multiple sheets
39.
Print a partial or complete worksheet
40.
Display and print the formulas version of a worksheet
41.
Print to fit
42.
Distinguish between portrait and landscape orientation
43.
Use a Web query to get real-time data from a Web site
44.
Rotate text in a cell
45.
Use the fill handle to create a series of month names
46.
Copy a cell’s format to another cell using the Format Painter button
47.
Copy a range of cells to a nonadjacent paste area
48.
Freeze the column and row titles
49.
Insert and delete cells
50.
Format numbers by entering them with a format symbol
51.
Use the NOW function to display the system date
52.
Format the system date
53.
Use the IF function to enter one value or another in a cell on the basis of a
logical test
54.
Copy absolute cell references
55.
Italicize text
56.
Display and dock toolbars
57.
Add a drop shadow to a range of cells
58.
Create a 3-D Column chart on a separate sheet
59. Format the 3-D Column chart
60.
Use the Zoom box to change the appearance of the worksheet
61.
View different parts of the worksheet through window panes
62.
Use Excel to answer what-if questions
63.
Use the Goal Seek command to analyze worksheet data
Grading Policy
Daily grades, homework and weekly test.. 2/3
Final exam –major exams……………….. 1/3
The final
semester grades will be figured as set in the current catalog:
90-100=A 80-89=B 70-79=C 60-69=D Below 59=F
Methods of
Instruction: 1. Lecture/overhead projector
examples
2.
PowerPoint presentations
3.
Demonstrations by instructor
Classroom
Conduct:
Cell phone
use: Students are not to have a cell
phone out during class, and the ringer is to be turned off or to vibrate.
Failure to
comply with lawful direction of a classroom instructor is a disruption for all
students enrolled in the class. Cheating
violations include, but are not limited to: (1)obtaining an examination,
classroom activity, or laboratory exercise by stealing or collusion; (2)
discovering the content of an examination, classroom activity, laboratory
exercise, or homework assignment before it is given; (3) using an unauthorized
source of information during an examination, classroom activity, laboratory
exercise, or homework assignment; (4) entering an office of building to obtain
unfair advantage; (5) taking an examination for another person; (6) completing
a classroom activity, laboratory exercise, homework assignment, or research
paper for another person; (7) altering grade records; (8) using any
unauthorized form of electronic communication device during an examination,
classroom activity, or laboratory exercise; (9) Plagiarism. Plagiarism is the using, stating, offering,
or reporting as one’s own, an idea, expression, or production of another person
without proper credit.
Disciplinary
actions for cheating in a course are at the discretion of the individual
instructor. The instructor of that
course will file a report with the Dean of Students when a student is caught
cheating in the course, whether it be a workforce or academic course. The report shall include the course,
instructor, student’s name, and the type of cheating involved. Students who are reported as cheating to the
Dean of Students more than once shall be disciplined by the Dean. The Dean will notify all involved parties
within fourteen days of any action taken.
American with
Disabilities Act Statement:
Academic
Integrity and Honesty:
In order to help students learn in an academic environment, I adhere to a
strict policy regarding academic honesty. Anyone who is dishonest in any way
(including the following examples) will receive a zero on that assignment or
test with no opportunity to make up the zero and may be dropped from the course
with a grade of F:
Examples of
dishonest behavior:
Uses notes or textbooks during an
exam
Receives help from someone during an exam
Gives help to another student during an exam
Uses someone else’s files for part or all of a lab
assignment
Lets someone else use any of your lab assignment
files**
** It is your
responsibility to protect your electronically saved files. If someone else
turns in an assignment as if it were that student’s work but it is work that
you completed, I will have to assume that you allowed it to happen. Therefore,
make sure your saved files are kept in a place where others cannot copy them.
In class we will discuss ways to protect your files. It is okay to help someone
else on a lab assignment by explaining to that person how to complete a task,
but it is dishonest for you to complete the work for that person or to let that
person copy your completed files.
Dropping a
Course: A student who is enrolled in a developmental course for TSI purposes
may not drop his/her only developmental course unless the student completely
withdraws from the college. A student
may drop any other course with a grade of “W” any time after the census date
for the semester and on or before the end of the 12th week of a long
semester, or on or before the last day to drop a class of a term as designated
in the college calendar. The request for
permission to drop a course is initiated by the student by procuring a drop
form the Office of Student Services. (Refer to other policies concerning this
issue in the current college catalog online.) (Please visit with me before you
drop the course.) If you decide you must
withdraw, a formal procedure must be followed in order for you to receive a “W”
on your transcript. The last day to drop
must be followed, which is found in college catalog.
According to
Texas state law a student is only allowed to drop the same class twice before
he/she will be charged triple the tuition amount for taking the class a third
time or more. Furthermore, beginning
with the Fall 2007 semester, students in
Withdrawal
from College: When a student finds it necessary to withdraw from school before
the end of the semester, he or she should obtain a withdrawal form from the
Office of Student Services. Students may
also withdraw from the college by sending a written request for such action to
the Registrar’s Office. The request must
include the student’s signature, the student’s current address, social security
number and course information details.
Students who withdraw after the census date for the semester and on or
before the end of the 12th week of a long semester, or on or before
the last day to drop a class of a term as designated in the college calendar
will be assigned a grade of “W”. If you quit and do not formally withdraw, you
will receive a grade of “F” on your transcript.
Tentative
Schedule: Excel
Week 1:
Project 1
Week 2:
Project 2
Week 3: Project
3
Week 4:
Project 4
Week 5:
Project 1-a
Week 6:
Project 2-b
Week 7 Project
3-c
Week 8:
Project 4-d