![](3D"cis225aHenderson_files/image002.gif")
SYLLABUS
FOR BUSINESS MICROCOMPUTER APPLICATIONS
Term: <=
/span>Fall,
2010-2011 (101) (September 7 - December 18, 2010)
Course Number: CMIS 225a
Instructor: &n= bsp; Mr. Darren Henderson
Office: Room 617
Office
Phone: (219) 473-4346
E-mail: dhenderson@ccsj.edu
Office
Hours: Monday <=
span
style=3D'mso-tab-count:2'> &=
nbsp; &nbs=
p; 6:00
p.m. - 7:00 p.m.
&n=
bsp; =
; &n=
bsp; Tuesday &=
nbsp; &nbs=
p; 2:30
p.m. - 3:30 p.m.
&n=
bsp; =
; &n=
bsp; Thursday &=
nbsp; 2:30
p.m. - 3:30 p.m.
Instructor
Background:
Educatio=
n
o
o
o
o
o
o
Work
Experience
o
o
§Courses
taught include Computer Literacy, Business Microcomputer Applications,
Applications in Databases: Access, Applications in Spreadsheets: Excel, Web
Page Design, C++ Programming I and II, Hardware and Software Concepts, Syst=
ems
Analysis and Design, and Data Communications and Networking Theory
o
§Accepted
interim appointment beginning Spring 2007 term
o
§Helped
lay the groundwork for the school's existing computer network and
services. Responsible for ini=
tially
creating the faculty and staff e-mail accounts and for making the school's
computers (faculty, staff, and 4th floor computer labs) Internet
accessible. Duties involved
Unix/Linux and Windows NT System Administration and TCP/IP Network
Administration in support of DNS, DHCP, WWW, and e-mail services. Implemented an early firewall to p=
rotect
the school's Univers database system from unauthorized access
- Ivy
- Adjunct
instructor in the Electronics Technology Department
- Courses
taught: Circuits I and II,
Publications/Presentations
o
o
(ISECON) 2006. (accepted/absentee)
o
o
Research
Interests
o
Course
Time: Tuesdays and Thursdays 3:30 p.m. &=
#8211;
5:00 p.m. &nbs=
p; Room
418
Course
Description: This survey course provides the
student with an introduction to microcomputers with an emphasis on business=
applications.
Application package under review will be Microsoft Office.
Prerequisite: CIS 115 and/or permission of progr=
am
director.
Learning
Outcomes/ Competencies:
Students
in this course will:
· =
Use
a personal computer and its Graphical User Interface (GUI) effectively=
o=
initiate and terminate a
computer work session (e.g. "powering-on" a computer, successfully
logging into a computer network, and shutting down a computer)
o=
manage the desktop (e.g.
starting and exiting application programs, manipulating windows)
o=
multitask (e.g. switch b=
etween
multiple concurrent application programs, transfer information between two
documents and/or applications)
=
·
Use word processing software at a basic-level mastery including<=
/o:p>
o=
use a computer keyboard =
to
enter text into a document
o=
use the appropriate comm=
ands
to edit text (e.g. add new text to an existing document, delete text, move
text)
o=
apply and remove basic
formatting (e.g. change margins, line spacing, character formatting)
o=
produce a hard copy of a
document
· =
Use
presentation graphics software at a basic-level mastery including
o=
create a bulleted list
presentation from an outline
o&nb=
sp;
edit a slide presentation (e.g. add new slides, edit slide text, dele=
te
slides, reorder or reposition slides) as needed
o=
work with graphics, incl=
uding inserting
clipart or other graphic formats, resizing and repositioning images
o=
animate presentation text
and/or graphics
o=
use the appropriate navi=
gation
controls to mechanically deliver a slide show
o=
generate the appropriate=
hard
copy printouts (i.e. presentation slides for the speaker and handouts for t=
he
audience)
· =
Use
spreadsheet software at a basic-level mastery includingo=
enter text and numbers i=
nto a
given spreadsheet cell
o=
create spreadsheet formu=
las
combining the appropriate mathematical formulas and/or built-in functions a=
nd
the appropriate cell references.
o=
apply and remove simple =
cell
formatting (e.g. number styles, character formatting styles)
o=
produce a hard copy of a
spreadsheet
· =
Perform
common file management tasks
o=
work with files during a
single computer work session and over multiple work sessions (e.g. open and
save files)
o=
use utility software to
compress and package multiple files as a single zip file
o=
use utility software to
decompress files
· =
Use
the Blackboard e-learning environment including
o=
access
CCSJ's Blackboard login page using a WWW browser and successfully login
o=
navigate the Blackboard
e-learning environment as required
o=
change their “Pers=
onal
Information” (e.g. change the default password, modify the e-mail
address)
o=
access course content (e=
.g. announcements,
homework, class exercises, Word documents, Excel spreadsheets, Access
databases, Adobe PDF files) as needed
o=
use Blackboard’s
communication capabilities (e.g. e-mail) to communicate with the instructor=
o=
use
Blackboard’s “Digital Dropbox” feature to “sendR=
21;
a file (e.g. Word document, Excel spreadsheet, Zip file, etc.) to the cours=
e instructor
o=
terminate a Blackboard s=
ession
by logging out properly
· =
Use
word processing software at an intermediate to advanced level mastery to
o=
create headers and foote=
rs
(e.g. page numbers in footer)
o=
apply formatting using
shortcut keys (e.g. CTRL + B to toggle BOLD)
o=
work with styles
o=
insert manual page break=
s
o=
determine the number of =
words
in a document
o=
indent paragraphs
o=
create hanging indents
o=
use the Find and/or Find=
and
Replace feature
o=
work with clip art (e.g.
inserting, moving, resizing)
o=
set and use
“custom” tab stops
o=
work with border formatt=
ing
o=
work with tables (e.g. c=
reate
a table with the desired dimensions, enter text into table cells, add and
delete rows and columns, merge cells)
o=
work with bulleted lists=
o=
display and remove
non-printing symbols (e.g. spaces, tabs, paragraph marks)
o=
use the zoom feature (e.=
g.
text width)
o=
insert a line break=
o=
apply and remove color t=
ext
formatting
o=
create a main document f=
orm
letter with the desired merge fields
o=
create a data source (e.=
g.
table, comma-delimited file)
o=
use an If field to
conditionally print text in a form letter
o=
insert a Fill-in field
o=
display and hide field c=
odes
o=
perform a mail merge to
generate the individual form letters
· =
Use
presentation graphics software at an intermediate level mastery to
o=
change formatting on the=
slide
master
o=
add a header and footer =
to
presentation slides
o=
add animation and slide
transition effects
o=
insert clipart on a slide
without a clip art region
· =
Use
spreadsheet software at an intermediate level mastery too=
color the characters and
background of a cell
o=
add conditional formatti=
ng to
a range of cells
o=
display and print the fo=
rmulas
version of a worksheet
o=
rename sheets
o=
enter formulas using the=
Point
mode
o=
use the average, max, an=
d min
functions
o=
verify formulas (e.g. us=
ing
range finder)
o=
import external stock da=
ta
using a Web query
· =
Use
relational database management software at a basic to intermediate level
mastery to
o=
implement a properly
normalized database design
o=
create a database table =
by
defining the appropriate database fields and their properties (e.g. data ty=
pe
and field size)
o=
add data records to a ta=
ble
using the datasheet view and/or the form view
o=
set, modify, and print t=
able
relationships
o=
create a report that inc=
ludes
the desired fields
o=
create and run queries <=
/span>that=
extract the desired rec=
ords
from a database
o=
create and run queries t=
hat
join separate tables, include calculated fields, compound conditions (e.g. =
AND
and OR criteria), and use wildcards
· =
Use
personal information management software at a basic level mastery to
o=
create personal subfolde=
rs
(e.g. in Calendar , Tasks, and Contact views)
o=
distinguish between
appointments, events, and tasks
o=
enter one-time and recur=
ring
appointments
o=
move, edit, and delete
appointments as needed
o=
create events
o=
use tasks lists
o=
create and maintain cont=
acts
o=
export, delete, and impo=
rt
subfolders
o=
color the characters and
background of a cell
o=
add conditional formatti=
ng to
a range of cells
o=
display and print the fo=
rmulas
version of a worksheet
o=
rename sheets
o=
enter formulas using the=
Point
mode
o=
use the average, max, an=
d min
functions
o=
verify formulas (e.g. us=
ing
range finder)
o=
import external stock da=
ta
using a Web query
· =
Use
relational database management software at a basic to intermediate level
mastery to
o=
implement a properly
normalized database design
o=
create a database table =
by
defining the appropriate database fields and their properties (e.g. data ty=
pe
and field size)
o=
add data records to a ta=
ble
using the datasheet view and/or the form view
o=
set, modify, and print t=
able
relationships
o=
create a report that inc=
ludes
the desired fields
o=
create and run queries <=
/span>that=
extract the desired rec=
ords
from a database
o=
create and run queries t=
hat
join separate tables, include calculated fields, compound conditions (e.g. =
AND
and OR criteria), and use wildcards
· =
Use
personal information management software at a basic level mastery to
o=
create personal subfolde=
rs
(e.g. in Calendar , Tasks, and Contact views)
o=
distinguish between
appointments, events, and tasks
o=
enter one-time and recur=
ring
appointments
o=
move, edit, and delete
appointments as needed
o=
create events
o=
use tasks lists
o=
create and maintain cont=
acts
o=
export, delete, and impo=
rt
subfolders
Textbook:
Microsoft
Office 2007: Introductory Concepts and Techniques, Windows Vista Edition,
Shelly, Cashman, and Vermaat, Course Technology, Boston, MA, 2008. (ISBN: 1=
-4239-1228-4)
Storage
Media:
Students will need to use some for=
m of
portable read/write storage to work in-class on the assigned class
exercises and/or to transport files between the CCSJ laboratory computers a=
nd their
personal computer. It is expe=
cted
that regular use of a portable storage device will exercise and will improv=
e a
student’s file management skills.&nb=
sp;
Today, a USB flash memory device is probably the safest choice for a
storage device since increasingly many of the 4th floor computer=
s do
not come configured with floppy disk drives. Alternatively, students may use ei=
ther their
CCSJ WebMail account to send an email with a file attachment or Blackboard&=
#8217;s
Digital Dropbox “Add File” feature to save a file for later use=
if
no portable storage device is available.&n=
bsp;
Remember, files saved to the hard disk (esp. My Documents and/or the
Desktop) of a CCSJ laboratory computer will not generally survive AFTER log=
ging
out of the machine!
Learning
Strategies:
The cour=
se
material is presented mainly through instructor-led software
demonstrations. Students deve=
lop
software proficiency through collaborative learning laboratory experiences =
and
through the completion of hands-on assignments and projects.
Assessment:
The student’s grade is compu=
ted
using the weights shown below:
Exam #1 =
(Computer
Literacy Basics/Word) &=
nbsp; &nbs=
p; 25%
Exam
#2 =
;
(PowerPoint/Excel) &nbs=
p; &=
nbsp; &=
nbsp; &nbs=
p; 25%
Exam
#3 =
;
(Access/Advanced Word) &=
nbsp; &=
nbsp; &nbs=
p; 25%
&=
nbsp; &nbs=
p; Class
Exercises/Homework Assignments &=
nbsp; &nbs=
p; &=
nbsp; 25%
&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; ------
&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; 100%
Class
Policy for Assignments/Exams:
Homework will be assigned througho=
ut
the duration of the term. =
Homework
assignments and due dates will be posted on the Blackboard supplement to the
course. Homework will be
collected generally two weeks =
from
the date assigned unless directed otherwise. Students are required to submit ho=
mework
in both hardcopy and electronic form. Students will submit electronic ve=
rsions
to the instructor via Blackboard’s Digital Dropbox. Homework that is submitted (<=
=3D 7
calendar days late) is subject to an automatic
deduction to be determined by =
the
instructor. Homewor=
k that
is more than one week late will NOT be accepted for credit and will
result in an assigned score of zero. =
Homework received after 3:30 p.m. on Tuesday, December 7, =
2010
(i.e. Week #14) will NOT be considered for credit and will result in an
assigned score of zero.=
Students are expected to submit th=
eir own
independently created solutions to any and all exams, homework assignme=
nts,
and class exercises. Therefor=
e, the
sharing of computer solution files and/or the misrepresentation of someone
else’s work as your own is prohibited. Any student found violating this p=
olicy
will be given a zero grade for that particular assignment or
activity. Repeated violators =
of this
policy are subject to further consequences including receiving a failing gr=
ade
for the course.
The official class policy is
that there is NO MAKE-UP EXAMS,
however in recognition of the occasional personal and/or family
emergency that may occur during the semester, a make-up exam may be granted provided all the following conditio=
ns are
met:
1) &=
nbsp;
The instructor is notified =
via
voice mail (preferably) or email of the make-up exam request by the student=
before
or within 24 hours of the scheduled exam date/time.
2) &=
nbsp;
A suitable alternate time c=
an
be arranged. Remember that ma=
ke-up
exams will generally require that a computer lab be reserved. Therefore, make-up times are gover=
ned both
by computer lab availability and instructor availability. The general practice is to offer t=
he
student(s) one alternate
make-up time.
3) &=
nbsp;
The missed scheduled exam m=
ust
be made-up within one-week<=
/b> of
the scheduled exam date.
The granting of make-up exams is N=
OT
an entitlement but is a courtesy granted to the student by the instructor.<=
span
style=3D'mso-spacerun:yes'> If this courtesy is abused by a
particular student or the class as a whole, then the privilege may be revok=
ed.
A missed exam will be assig=
ned
a score of zero.
Exams are performance-based or
The function of the homework
assignments and class/laboratory exercises is that they serve as exam
preparation. The function of =
the
exams is to confirm that the student has achieved the required level of
proficiency.
Grading
Scale:
A: 93-100
C: 73-76 &=
nbsp; C-: 70-72 =
D+: 67-69 D: 63-66
D-: 60-62 F: 59 & below
Class
Policy on Attendance/Class Exercises:
Attendance will be taken for
administrative purposes. Alth=
ough
class attendance does NOT acco=
unt
for a percentage of the assigned semester grade, it is vital that students
attend the class sessions on a regular basis in order to be informed of any
important class announcements, any deviations from the course outline below,
and of any supplemental material presented.
However, class/lab attendance and
participation is used as a factor in deciding borderline case=
s (if
applicable).
Periodically throughout the term,
class exercises will be given during the class session to reinforce =
the
course concepts and material. The
class exercises are intended as a formative learning experience for the stu=
dent
and are to be completed and reviewed by the instructor in-class. =
Students
missing a class session in which a class exercise is assigned may complete =
the
class exercise and have it reviewed by the instructor at the start of the next class session on=
ly. Therefore, frequent absence=
s may
result in the student failing to receive credit for the class exercise
component of the course.
Class
Policy on Electronic Devices:
As a matter of courtesy to the
instructor and to fellow students, cell phones, beepers, pagers, etc. are
generally NOT to be answered in class and should be switched off BEFORE cla=
ss
begins. If it is absolutely
necessary to receive a call during the class period, then the device should=
be
placed in a “vibrate” mode and the student should answer the ca=
ll
outside the classroom so as to minimize disruptions to the learning
environment.
Course
Outline:
|
Class Dates: |
Topics/Assignments: |
|
|
WEEK
1 |
9/07/2010 9/09 |
Course
Policies/Syllabus CCSJ
Network Login/CCSJ Web Mail/Blackboard Login CCSJ Student Online Services (SO=
S),
CCSJ Alerts Class Exercise – File Management Office File Extensions |
|
WEEK
2 |
9/14 9/16 |
Office
2007 Introduction WD-1 (=
Creating
and Editing a Word Document) Comput=
er
Skills Remediation (Individual and/or Small Groups) |
|
WEEK
3 |
9/21 9/23 |
Blackboard 6
Introduction/Accounts/Digital Dropbox WD-2 (Creating a Research Pap=
er) Class Exercise – Word 2 |
|
WEEK
4 |
9/28 9/30 |
WD-3 (Creating a Cover Letter and a Resu=
me) WinZip (i.e. file
compression/decompression utility) Introduction Class Exercise – Word 3 |
|
WEEK
5 |
10/05 10/07 |
PPT-1
(Creating and Editing a Presentat=
ion) PPT-2 (Creating a Presentation
with Illustrations and Shapes) Class Exercise – PowerPoin=
t |
|
WEEK
6 |
10/12 10/14 |
EXAM
#1
(Computer Literacy Basics/Word) PART 1=
PART 2=
|
|
WEEK
7 |
10/19 10/21 |
Exam #1 Results EX-1 (Creating a Worksheet and an Embedded Chart) Class
Exercise – Cubs Baseball |
|
WEEK
8 |
10/26 10/28 |
EX-2
(Formulas, Functions, Formatting,=
and
Web Queries) Class Exercise – Excel 2 |
|
WEEK
9 |
11/02 11/04 |
AC-1
(Creating and Using a Database) |
|
WEEK
10 |
11/09 11/11 |
EXAM
#2
(PowerPoint/Excel) PART 1=
PART 2=
|
|
WEEK
11 |
11/16 11/18 |
Exam #2 Results Class Exercise – Access 1<=
/span> AC-2
(Querying a Database) |
|
WEEK
12 |
11/23 11/25 |
Handout
(Word
Mail Merge) Class Exercise – Word Mail
Merge NO CLASS
– Thanksgiving Break |
|
WEEK
13 |
11/30 12/02 |
Handou=
t (Schedule and Contact Management Usi=
ng
Outlook) Class Exercise – Outlook |
|
WEEK
14 |
12/07 12/09 |
Handou=
t (Word Forms) Class Exercise |
|
WEEK
15 |
12/14
or 12/16 |
EXAM #3 (Ac= cess/Advanced Word) |
Class
Participation:
See "Class Policy on
Attendance" above
Student Support Services:
Among its other services, the Student Support
Services Office guides, counsels and assists students with disabilities.
If a student believes that he or she needs a “reasonable
accommodation” of some kind because of a physical, psychological, or
mental condition (e.g., additional time needed for tests, note taking
assistance, special testing arrangements, etc.), he or she should contact t=
he
Student Support Services Office at 473-4388. Staff there will secure
documentation pertinent to the disability and work with faculty and staff, =
if
necessary, to address the matter.
CCSJ
Tutoring Center:
The Tutoring Center is dedicated to
supporting Calumet College of St. Joseph students. Students work with tutors to devel=
op
course competencies and study skills such as time management, test preparat=
ion,
and note taking. In addition,
students are provided with tutoring support to help pass courses, to improve
grade point average, and to promote continuing education and career
advancement. Tutors have a sp=
ecific
charge: to help students learn how to master specific subject matter and to
develop effective learning skills.
Tutoring is open to all students at Calumet College of St. Joseph at=
no
charge and is available to support most introductory courses. Tutoring in support of some other
courses is available as well. The
Tutoring Center is located in Room 413.&nb=
sp;
The hours of operation are normally Mondays, Wednesdays, and Fridays
from 9:00 a.m. to 5:00 p.m. and Tuesdays and Thursdays from 9:00 a.m. to 7:=
00
p.m. The telephone number is =
(219)473-4287
or (800)700-9100 ext. 287.
Academic
Alerts:
In order
to assist students to successfully persist towards course completion, Calum=
et
College of St. Joseph asks instructors to give a written evaluation in the =
form
of an Academic Alert at the end of the 5th and 10th w=
eeks
of the semester (Fall and Spring) for any students performing below
“C” average work. The
current practice is to have the instructor hand-deliver the alert to the
student if possible otherwise the alert is forwarded to the CCSJ Academic
Advising office where it is then delivered to the student via the U.S Postal
Service. The intent of the ac=
ademic
alert system is to notify the student of substandard performance so that th=
ey
may take steps to rectify the situation (e.g. tutoring through the Center f=
or
Academic Excellence). However,
students should realize that NOT receiving an Academic Alert on week #5 or =
week
#10 is NOT a guarantee of NOT receiving a grade below a “C” for=
the
semester since a student’s assigned semester grade depends on the
student’s performance during all 15 weeks of the semester.
Statement
of Plagiarism:
If an instructor or other Calumet
College of St. Joseph personnel find that a student has plagiarized or been
involved in another form of academic dishonesty, the instructor or other
personnel may elect to bring the matter up for judicial review. The maximum
penalty for any form of academic dishonesty is dismissal from the College. =
The
procedures for judicial review are listed under the section of the CCSJ
handbook that addresses student grievances.
Pl=
ease
note:
Citation
Guidelines:
Calumet
College of St. Joseph adheres to citation guidelines as prescribed by the
particular discipline (i.e., MLA, APA, and Chicago Manual of Style or
Turabian.). All of these guid=
elines
are available in the Calumet College of St. Joseph library or bookstore.
CCSJ Alert:
Calumet
College of St. Joseph utilizes an emergency communications system that
transmits messages via text, email, and voice platforms. In the event of an emergency, of we=
ather
related closings, or of other incidents, those students who are registered =
for
the system shall receive incident specific message(s) notifying them of the
situation. Please sign-up for=
this
important service at any time on the College’s website. Alternatively, you can register at =
the
time you register for classes. This
service requires each user to register once per academic year. Therefore, at
the beginning of each academic year, please remember to re-register for the
system.
School Closing Information:
&n=
bsp; =
; Internet:
&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; http://www.ccsj.edu
&n=
bsp; =
;
http://www.EmergencyClosings.com
Facility:
Phone:
219.473.4770
&n=
bsp; =
; Radio:
WAKE
– 1500 AM
WGN - 720 AM
WIJE
– 105.5 FM
WLS
– 890 AM
WZVN
– 107.1 FM
WBBM
NEWS RADIO 78
&=
nbsp; TV
Channels:
2,
5, 7, 9 (WGN), 32 (WFLD)
Withdrawal
from Classes Policy:
After
the last day for class changes has passed (see College calendar), students =
may
withdraw from a course in which they are registered with permission from the
faculty member conducting the course. A written request detailing the reaso=
n(s)
for the withdrawal must be filed with the Registrar. The Registrar must rec=
eive
written request for withdrawal by the last day of classes prior to the final
examination dates specified in the catalogue. Written requests may be maile=
d to
the Registrar or faxed to the College fax number 219-473-4259. Students are=
to
make note of the refund schedule when withdrawing from courses. The request=
is
forwarded to the faculty member, who makes the final determination to accep=
t or
deny the request. If the request is honored, the student will receive
notification of official withdrawal; if denied, the notification will indic=
ate
why the withdrawal is disallowed.
An
official withdrawal is recorded as a "W" grade on the student's
transcript. Dropping a course without written permission automatically incu=
rs
an "F" grade for the course (see Refund Schedule).