Business Administration 1800

Computers and Information Systems

Summer 2009

 

 

 

Course Instructor:

Dr. Joseph Rottman

rottman@umsl.edu

 

228 CCB

www.umsl.edu/~rottmanj/

 

516-6288 Office

Office Hours by appointment

 

 

Class Meeting times

D01

M/W

1:00 – 3:40

CCB 003

 

Course Description:

This course covers the basic concepts of networked microcomputers including the basics of file management on local and remote computers, electronic mail, Internet browsers, and web page development.  Students are also exposed to applications used in problem solving, communication, and making informed decisions, including word processors, presentation software, electronic spreadsheets, and databases.  The characteristics of computer hardware and software used in implementing various applications are considered.  Students will develop skills in utilizing applications that run on familiar computer platforms.

 

Course Objectives:

·   Access and/or generate information using a variety of technological information sources, including personal productivity tools (word processing, presentation packages, electronic spreadsheets, and databases) and information on public networks, such as the Internet

·   Create and evaluate information for its currency, usefulness, truthfulness, and accuracy using electronic spreadsheet and database management systems.

·   Organize, store, and retrieve information effectively using personal productivity tools, including electronic spreadsheets, database management systems, and file transfer protocols

·   Present information clearly and concisely, using contemporary technologies such as the graphics features of an electronic spreadsheet, presentation software, and reporting facilities of a database management system.

·   Effective communication using computer technologies including electronic mail.

 

Course Materials:

Required Books:          Shrink-wrapped custom book from Pearson that includes:

·             Tech in Action Fifth Edition

·             Go! With Microsoft Office 2007

·             Compact Guide to Web Page Creation and Design

 

Recommended:            flash drive or thumb drive to ease file portability

 

 

 

 

 

 

Grades:

During the course of the semester, exams, and assignments will be given.  The total points available during the semester will be 1,000.  The exams will total 700 points and the assignments will total 300 points.  In general, total points of 900 and above will get an A, 800 and above a B, and so on.  Depending on the grade spread, incremental grades may be issued.

Point values will be assigned as follows:

                                Exam I                                                                                                 200 points

                                Exam II                                                                                                200 points

                                Excel Competency Exam                                                 100 points

                                Final Exam                                                                                      200 points

Assignments:

                                E-Mail                                                                                                  30 points

                                Computer Concepts                                                              30 points

                                Word                                                                                                     40 points

                                Web Page                                                                                      75 points

                                Excel                                                                                                     50 points

                                Access                                                                                                50 points

                                Discussion Board                                                                    25 points

                                                                                                                                                   Total              1,000 points

Exams:

The two exams given during the semester and the final exam will cover material from the texts, lectures, handouts, and assignments.  A grade of 0 will be given for any exam missed without the instructor's consent.  Makeup exams may only be given to students who have contacted the instructor prior to the published date of the exam.  Permission to take a make-up exam is based on documented proof and is at the instructor's discretion.  The Final Exam is comprehensive.  There will be a review session for the Final Exam.

 

Assignments:

Assignments will be given periodically during the semester.  The due dates are listed on the Tentative Schedule, but may be subject to change as course work proceeds. Assignments must be turned in during the class period on the due date.  Each assignment must be turned in with the proper format.  Assignments should reflect the student's own work.  There are many ways that an instructor can verify a student's work.

 

Disability statement: 

If anyone has a health condition or disability, which may require accommodations in order to effectively participate in this class, please contact the Disability Access Services Office in 144 Millennium Student Center at 516.6554. Information about your disability will be regarded as confidential.

 

Attendance:

In a four-week session, regular attendance is mandatory to be successful in this course. As you are aware, attendance is required during the first week of class for class roster verification.  After the first week, attendance will continue to be taken.  Two absences will be allowed. After two absences, one point will be deducted for every class session missed.

 

Class participation:

It is essential that you come to class prepared with the proper text and other necessary materials.  You should be ready to take part in class discussions.  During almost every class period, hands-on computer time will be allocated to practice what has been taught.  In addition to class participation, you will spend time outside of class to complete your assignments and to build skills.  You must practice in order to achieve proficiency in the software packages.

 

Policy Statements:

University policy clearly defines the requirements for academic honesty and defines disciplinary actions to which a student may be subject if these requirements are violated.  All students are expected to respect their classmates, the instructor and the university.  Civility is a basic requirement. 

This syllabus may be revised at the discretion of the instructor without prior notification or consent of the student.

 

Business School/Second Floor Secretary:

Karen Walsh    211 CCB                                        516.6267

E‑mail:  karen_walsh@umsl.edu                   

Fax Number:  516.6827                                           Mail Room:  210 CCB    


 

Approximate Class Day

Topic / Assignment

Assigned Reading

1:  5/18

Introduction / My Gateway / Syllabus K drive email, file management etc.

TIA: Chapter 2

Office Fundamentals

In class

2:  5/19

E-Mail and PowerPoint

PowerPoint Chapter 15, 16 and 17

3:  5/20

Concepts

TIA:  Chapters 4, 5 and 6

4: 5/21

Finish Concepts and Begin Word

 

5:  5/26

Word Day 2

Concepts Assignment Due

Word Chapters 5, 6, 7 and 8

6:  5/27

Finish Word

Exam I Review

 

7:  5/28

Exam 1:  TIA and Word

 

8:  5/29

TIA:  internet, communication and networks

Begin HTML

Word Assignment Due

TIA 3, 7, 8, 12, 13

Web Creation: 1, 2, and 3

9:  6/1

HTML Day 2

 

10:  6/2

Begin Excel

HTML Assignment Due

 

11:  6/3

Excel Day 1

Excel Chapters 9, 10 and 11

12:  6/4

Excel Day 2

Excel Competency Exam

Excel Assignment Due

 

13:  6/8

Exam II Review

Exam II:  HTML and TIA 3, 7, 8, 12, 13

 

14:  6/9

Begin Access

Access Chapters 12, 13 and 14

15:  6/10

Access

 

16:  6/11

Review for Final

Access Assignment Due

Discussion Board Due

Final Comprehensive Exam

 

Final Exam:   Thursday,  June 11th  1:00 PM (normal class time)