Frostburg State University

School of Business

 

Course Syllabus Spring 2001

 

Microcomputer Applications in Business

 


BUAD 320.001                       Monday, Wednesday, and Friday                     10:00 to 10:50

BUAD 320.002                       Monday, Wednesday, and Friday                     11:00 to 11:50

 

Instructor:                     JoAnna Burley Shore, M.Ed.               

Office:                          Framtom 316

Phones:                        301.687.4735 Office & 301.687.4008 Secretary

Office Hours:                Monday, Wednesday, & Friday 8:00 to 9:00

                                    Tuesday 8:00 to 10:00

                                    Also by appointment

 

Requirements

 

Text:  Microsoft 2000 Post Advanced Concepts and Techniques, Shelly Cashman and Vermaat; Course Technology, 2000. 

Materials:  One Zip floppy 100 mb or more. Required first day of Lab. (All disks handed in must have a label with name, subject, tutorial #, and section #.  All others will be returned without a grade.)

Suggested Readings: Computer periodicals.

 

Prerequisites:  MATH 209, COSC 220, and understanding of word processing, presentation software, databases, and spreadsheets.

Skills Required: Keyboarding and good communication skills.

 

Course Description and Objectives

 

Description:

Managerial applications of the microcomputer most often encountered in business: word processing for report writing, spreadsheets for financial modeling, graphics for presentations and managerial database applications using commercial programs.  Some telecommunication lectures will also be included. 

 

Instructor’s Objective:

To coach students in the art of integrating computers into their daily work environment and to use computers beneficially and productively in the workplace.

 

Course Objectives:

1.      To provide advanced computer concepts, applications and equipment.

2.      To offer concepts in using a microcomputer and widely used general-purpose application software; specifically the Microsoft products: Word, Excel, PowerPoint, and Access.

3.      To explore the use of telecommunication as a business tool.

 

Course Overview

 

Grading:

Hands on Tutorials (points given only if received on or before due date) 110

            Projects (full points only given if received on or before due date)                        225

            Four Tests (no makeup tests will be given PERIOD)                            200                 

            Final Exam (will be given during finals week ONLY)                             100

                                                Total Points Possible                                                     635

 

Final Letter Grade:

            100% - 90%                A

            89% - 80%                  B

            79% - 70%                  C

            69% - 60%                  D

            59% - 0%                    F

 

*If the class average falls below 70%, the instructor will adjust the grading scale.

 

Description of Grading:

 

Hands on: Each assigned chapter may have hands on exercises.  A due date will be given for each assignment.

                        Word Tutorials 7, 8, & 9

                        Excel Tutorials 7, 8, & 9

                        Access Tutorials 7, 8, & 9

                        PowerPoint Tutorials 5 & 6

 

Projects: Four projects will be assigned during the semester.

 

Microsoft Word Project: (25 Points) Student will design a four-page self-mailing company newsletter.  Articles must be original and newsletter must be of professional quality.  This project must include text, clipart, shading, columns, borders, masthead, word wrap around text or clipart, and self-mailing setup. 

 

Microsoft Excel Project: (50 Points) Student will produce a spreadsheet that contains the classes he or she has taken and will take in the future. Spreadsheet must have student’s name, social security number as a well designed masthead.  Columns must contain class name, semester taken or plan to take, credit hours, grades received, and GPA.  This must be a working spreadsheet.  I will add classes and play with the grade to see if the GPA changes.  A VLOOKUP table must be worked into the formulas (i.e. A = 4.0, B = 3.0).

 

Microsoft Access Project: (50 Points) Student will create a database of 10 to 15 records (student’s choice).  The following Access tools must be utilized:

                        One-to-many relationship                      7 to 8 columns of data

                        Primary key                                          Completed report

                        Two tables                                           Query

                        Form and subform

 

Microsoft PowerPoint Project: (100 Points) Student will design and present an 18 to 20 slide presentation about an assigned company (instructor’s choice). You will have 20 minutes to present your project in class for grading by fellow classmates and instructor.  Grade break down is 50% classmates’ grading and 50% instructor’s grading.

 

Tests: Four tests with a value of 50 point each will be given covering Word, Excel, Access, and PowerPoint.  No makeup tests will be given.

 

Final Exam: A 100 point cumulative final will be given during finals week.

 

                        BUAD 320.001           (10:00 Class)                Monday, May 21 - 2:30 to 5:00

                        BUAD 320.002           (11:00 Class)                Friday, May 18 - 11:15 to 1:45

 

Attendance:  Attendance will be mandatory due to the nature of the class.  Five points per week will be awarded for attendance. 

 

Disruptive Behavior

The University will not tolerate disorderly or disruptive conduct which substantially threatens, harms, or interferes with university personnel or orderly university processes and functions.  Disruptive behavior includes indecent exposure, lewd behavior, bomb threats, false fire alarms and other actions which disrupt normal university functions, activities and processes.  A faculty member may require a student to leave the classroom when his/her behavior disrupts the learning environment of the class.  A student found responsible for disruptive behavior in the classroom may be administratively withdrawn from the course.

 

Academic Dishonesty

Academic dishonesty is defined to include any form of cheating and/or plagiarism.  Cheating includes, but is not limited to such acts as stealing or altering testing instruments; falsifying the identity of persons for any academic purpose; offering, giving or receiving unauthorized assistance on an examination, quiz or other written or oral material in a course; or falsifying information on any type of academic record.  Plagiarism is the presentation of written or oral material in a manner which conceals the true source of documentary material; or the presentation of materials which uses hypotheses, conclusions, evidence, data, or the like, in a way that the student appears to have done work which he/she did not, in fact, do.  In cases involving academic dishonesty, a failing grade or a grade of zero (0) for either an assignment and/or a course may be administered.  Students who are expelled or suspended for reasons of academic dishonesty are not admissible to other institutions within the University System of Maryland.  Suspension or expulsion for academic dishonesty is noted on a student's academic transcript.

 

NOTE:    It is the policy of the Department of Business Administration that any student found to be guilty of Academic Dishonesty will receive, as a minimum, a grade of "F" for the course and will be forbidden to enroll in any business classes for a period of not less than 1 calendar year.  (Courses taken at another institution during this period will not transfer to our program).

 

 

 

Tentative Schedule

Instructor Reserves the Right to Adjust Schedule at any Time

 

Week 1            Jan. 29             Syllabus and Introduction

 

                        Jan. 31             Word Lecture

 

Feb. 2              Redesigning a Form     

 

Week 2            Feb. 5              Form Due end of class

 

                        Feb. 7              Résume Lecture           

 

                        Feb. 9              Résumé Assignments Due next Class 

 

Week 3            Feb. 12            Lab time for Résumé

Due end of Class

 

                        Feb. 14            Word Lecture for Newsletter   

 

                        Feb. 16            Lab for Newsletter Due end of Class

 

Week 4            Feb. 19            Word Tutorial 7

 

                        Feb. 21            Word Tutorial 7 Due end of Class

 

                        Feb. 23            Word Tutorial 8

 

Week 5            Feb. 26            Word Tutorial 8 Due end of Class

 

                        Feb. 28            Word Tutorial 9

           

                        Mar. 2              Word Tutorial 9 Due end of Class

 

Week 6            Mar. 5              Word Test 50 Questions

 

                        Mar. 7              Return Word Test

 

                        Mar. 9              Excel Lecture

 

Week 7            Mar. 12            Excel Tutorial 7

 

                        Mar. 14            Excel Tutorial 7 Due end of Class

                       

                        Mar. 16            Excel Tutorial 8

 

Spring Break From March 17 to March 25

 

Week 8            Mar. 26            Excel Tutorial 8 Due end of Class

 

                        Mar. 28            Excel Tutorial 9

                       

                        Mar. 30            Excel Tutorial 9 Due end of Class

 

Week 9            Apr. 2              Excel Test 50 Questions

 

                        Apr. 4              Return Excel Test        

 

                        Apr. 6              Access Lecture

 

Week 10          Apr. 9              Access Tutorial 7


                        Apr. 11            Access Tutorial 8

 

                        Apr. 13            Access Tutorial 9

 

Week 11          Apr. 16            Access Tutorials Due end of Class

                       

                        Apr. 18            Access Test 50 Questions

 

                        Apr. 20            Return Access Test and PowerPoint Lecture

 

Week 12          Apr. 23            Tutorial 5 & 6 Due end of Class

 

                        Apr. 25            PowerPoint Test 50 Questions

 

                        Apr. 27            No Class

 

Week 13          Apr. 30            Presenter 1, 2, & 3

 

                        May 2              Presenter 4, 5, & 6

 

                        May 4              Presenter 7, 8, & 9

 

Week 14          May 7              Presenter 10, 11, & 12

 

                        May 9              Presenter 13, 14, & 15

 

                        May 10            Presenter 16, 17, & 18

 

Week 15          May 14            Presenter 19, & 20

 

Finals Week May 17 through 23