|
BUS-K 201
The Computer in Business
Indiana University Kokomo|
Dr. Steven Cox
Summer 2007
|
COURSE SYLLABUS
(print friendly) (student
web pages) |
|
Time: |
1:00 - 4:15, Tuesdays and
Thursdays (May 10 - June 21) |
|
Room: |
KO080 |
|
Office Hours: |
4:15- 5:40,
Tuesdays and Thursdays (and by appointment or walk-in) |
|
Office: |
KO 174J |
|
Work Phone: |
(765) 455-9314 |
|
Home Phone: |
(317) 696-0571 |
|
FAX: |
(765) 455-9348 |
|
E-mail: |
scox@iuk.edu |
|
Web Site |
http://www.iuk.edu/~bussrc/ |
|
Required Texts: |
Parsons, Oja, Ageloff, and Carey
Excel 2003, Second Edition
Adamski and Finnegan,
Access 2003, Second Edition |
Goals:
In this course students will learn basic and
intermediate computer software skills
including the use of current operating
systems and applications. In addition,
students will learn the basics of computer
hardware and develop an overview concept of
a computer information system. Course
content will emphasize the importance of
computers in business and the development of
the student’s skills in applying their
learned computer skills in a business
context.
Objectives:
· Learn to use the Internet as a communication
tool and as the primary reference tool of
the future. Gain familiarity with popular
web browsers and demonstrate the ability to
use the gathered information in other
applications.
· Demonstrate word processing proficiency
using Word 2003. Features include: working
in columns, tables, mail merge, using
graphics, and linking files. Students will
create resumes and cover letters and learn
job search strategies.
· Demonstrate spreadsheet proficiency using
Excel 2003. Features include: functions,
amortization, cash budgets, conditional
statements, graphing, formatting, multiple
worksheets, and linking files.
· Demonstrate presentation software
proficiency using PowerPoint 2003. Students
will create a detailed presentation
promoting the performance of a selected
corporation using data obtained from the
Internet.
·
Demonstrate database proficiency using
Access 2003. Students will learn to use a
preexisting database and will also construct
their own database. Tables, forms, and
reports, filters and queries will be
featured.
·
Demonstrate basic skills in constructing a
personal web page using Front Page 2003.
·
Discuss career and workplace ergonomics
issues as well as ethical considerations
when using Internet sources and links.
The School of Business Web Site with
Mission Statement:
http://www.iuk.edu/~kobus/Mission.shtml
Grading:
|
Midterm Exam |
170 |
|
Final Exam |
100 |
|
Excel and Access Projects |
130 |
|
Web Page |
100 |
|
Total Points |
500 |
Grading Scale:
|
96% - 100% |
A+ |
90% - 96% |
A |
89% - 90% |
A- |
|
86% - 90% |
B+ |
80% - 86% |
B |
79% - 80% |
B- |
|
76% - 80% |
C+ |
70% - 76% |
C |
69% - 70% |
C- |
|
66% - 70% |
D+ |
60% - 66% |
D |
59% - 60% |
D- |
|
Below 59% |
F |
|
|
|
|
Exams:
Unexcused
absences will result in zeros on exams. On
both the midterm and final exam 100 points
will be based on actual computer use. The
remaining 70 points on the midterm exam will
be based on terms presented and discussed in
class. The midterm exam will be in class on
May 29th. The final exam
will be in class on June 21st.
Projects:
In the second half of the course Excel and
Access assignments are due at midnight on
the specified date. No late submissions will
be accepted. The personal web page
is due June 21st and it
will include the result of topics covered in
the first half of the course. Although the
web page is due at the end of the course, it
is essential that work on the project be
ongoing throughout the course. Grading of
the web page will be as follows:
|
Overall Web Page Presentation
and Navigation |
20 |
|
Web Page Personalization and
Content |
20 |
|
Resume |
30 |
|
Amortization Schedule |
10 |
|
PowerPoint Presentation |
20 |
|
Total |
100 |
Class Attendance:
It is essential that you attend this class! Computer
concepts, software skills, and projects will be
discussed in class and they will not be
discussed individually with students who
miss class. If you must miss a class, it is
your responsibility to arrange with another
student to take detailed notes.
Computer Usage:
Students will be required to work on
computer projects outside of the regular
class times. This work can be done at the
IUK computer lab or at home or at work (if
you have your employer’s permission to do
so). Registered students at IUK can
purchase Microsoft Office XP at a
great discount at the IUK
bookstore. You will need proof of current
enrollment.
The IUK computer lab is in the Library.
Students should not expect that the
workers in the computer lab will be able to
help them with specific K201 assignments.
All students should have access to an IUK
e-mail account. I encourage students to
contact me using e-mail. In order to use
the computers in the classroom and in the
labs students need an ADS account. Contact
the Help Desk to obtain the account if you
do not have one. The phone number for the
IUK Help Desk is (765) 455-9315 and the
e-mail is
kohelp@iuk.edu.
Library Usage:
The IUK library system offers a large number
and variety of resources for the student to
use in this course. Examples include
current newspapers (Wall Street Journal),
magazines (PC Computing), databases (ABI
Inform), and access to the Internet.
Confidentiality Issues:
In K201, The Computer in Business,
students are required to create a web site.
Many individual assignments (including, but
not limited to, a resume and a PowerPoint
presentation of your hobbies or interests)
will be posted to your web site. This web
site will be viewable by anyone with access
to an Internet connection. If you are
uncomfortable with your resume or other
information being available on the web you
are welcome to use hypothetical information
and you should identify the information as
hypothetical on the web site. In addition,
the content of your Indiana University
provided web page is governed by the rules
you agreed to when you received your
computer account. It is important that
students understand the confidentiality
issues described above and acknowledge that
they are allowed to use hypothetical
information for class assignments that are
posted on their web site.
Disability Issues:
Indiana University Kokomo provides equal
access and support services to students with
special needs. Students with documented
disabilities should contact the University
Division (765-455-9309) and discuss any
necessary support services or accommodation
with the instructor.
K201 Class Schedule
|
Dates |
Computer Concept Topic
(Software Topic) |
Graded
Events |
|
May 10 |
Computer Hardware
(Word) |
|
|
May 15 |
Computer Software
(FrontPage) |
|
|
May 17 |
File Management
(FrontPage) |
|
|
May 22 |
Internet and Network
Technology
(FrontPage) |
|
|
May 24 |
Web Pages, Web
Sites, E-Commerce, and Digital
Media
(PowerPoint) |
|
|
May 29 |
Mid-Term Exam |
(170 pts) |
|
May 31 |
Excel Tutorial 1 Using Excel
to Manage Data
(Case 1)
Excel Tutorial 2 Working
With Formulas and Functions
(Case 1)
Amortization Schedule |
(10 pts)
(10 pts) |
|
June 5 |
Excel Tutorial 3
Developing a Professional
Looking Worksheet (Case 3)
Excel Tutorial 4 Working with
Charts and Graphics
(Case 3) |
(10 pts)
(10 pts) |
|
June 7 |
Excel Tutorial 5 Working
with Excel Lists (Case 2)
Excel Tutorial 6 Working
with Multiple Worksheets and
Workbooks (Case 2) |
(20 pts)
(10 pts) |
|
June 12 |
Access Tutorial 1
Introduction to Microsoft Access
2003 (Case 3)
Access Tutorial 2 Creating
and Maintaining a Database
(Case 3) |
(10 pts)
(10 pts) |
|
June 14 |
Access Tutorial 3 Querying a
Database (Case 3) |
(20 pts) |
|
June 19 |
Access Tutorial 4 Creating
Forms and Reports (Case 3) |
(20 pts) |
|
June 21 |
Final Exam
Web Page Due |
(100 pts)
(100 pts) |
|