SHAWNEE STATE UNIVERSITY

COURSE SYLLABUS

 

 

BUIS1010-02

Computer Applications I

 

 

Instructor

Jean P Houser, Professor

Phone

351-3670

Office

227 Kricker

E-mail

jhouser@shawnee.edu

Office Hours

W 1:00 pm – 1:30 pm

T 12:00 noon1:00 pm

R 12:00 noon – 2:30 pm

Dept.

Business Dept.

 

 

 

 

Credit Hours:

3

 

Class Location and Meeting Times:  

MWF 10:00 – 10:50 am

                                Kricker 252

 

Materials Needed:

1              Microsoft Office 2007 Introductory Concepts and Techniques Windows XP by Shelly Cashman Vermaat 


2              SAM2007 Assessment, Training, and Projects for Microsoft Office 2007

 

3              USB Flash Drive

 

Prerequisites:
Knowledge of the fundamental computing process, components of the computing system, and basic computer terminology. Can demonstrate ability to use basic features of the operating system, email, and the Internet. Minimum keyboarding skills of 20 WPM with 3 or fewer errors on a three minute timed writing.

Course Credit by Examination:
Students who have had prior computer training or who have considerable experience working with computers have the opportunity to earn credit for this course via a proficiency examination. The current fee for course credit by examination is $105 (subject to change) and must be paid prior to the exam. Students must achieve a score of 70% or higher to receive a passing grade. You are not eligible to attempt a proficiency exam once you have been enrolled in the course for 20 class days. The proficiency exam for this course may be taken only once. Pages 38-39 of the 2003-05 catalog contain additional Information.

MOUS Certification:
Students who have passed the Core level Microsoft User Specialist Exam for Microsoft Word, Excel, Access, and PowerPoint may receive credit for this course by presenting the appropriate documentation to the Department of Business Chairperson's Office. You must have passed the Word, Excel, Access, and PowerPoint sections to receive course credit.

Course Description:

Introduces computer concepts within the framework of business applications. The emphasis is to introduce the use of Windows, Word, Excel, PowerPoint, and Access, and thus building a solid foundation in the use of a word processing, spreadsheet, presentation, and database applications software.

 

Goals and Objectives:

Upon completion of this course, the student must demonstrate that they can use an integrated business software package as a tool in making business, accounting, financial, and statistical decisions. They can identify hardware and software system requirements that match business needs and align with business strategy. They must demonstrate an understanding of the basic components of a computer system, computer hardware, computer software, computer applications, and computer issues.

The student:

Word:
1. can identify each of the features in the tool and menu bars of
Microsoft Word 2003.
2. can create, save, open, edit, spell-check, and grammar
check a Word document.
3. can apply formats such as: font style, size, and color; change
margins, tabs, and spacing; use indents, numbers, bullets, and borders.
4. can understand and use Word tables for data and formatting.
5. can insert graphics into a document, scale and position
graphics on the page.
6. can insert and delete page breaks and footnotes into a
document.
7. can create headers, footnotes and endnotes using various
styles of numbering.
8. can apply the features of the page setup and print menus.

Excel:
1. can create, save, open, and edit a worksheet and embedded chart.
2. can use formulas/functions to calculate sums, averages, percentages, maximums, minimums, absolute and relative cell addressing.
3. can format the worksheet.
4. can create pie, column, and line charts from spreadsheet data.
5. can name ranges and worksheets.
6. can email with Excel.
7. can cut and copy adjacent and nonadjacent cells.
8. can create series and use fill handles to copy series.
9. can conduct "what if" analysis including the "if" function, "goal
seek", and "now" function.
10. can use print options for print to fit and formulas version of a
worksheet.

Access:
1. can create and use relational and non-relational databases that include tables, queries, forms and reports.
2. can create, save, and run queries and print the results including simple, parameter, update, delete, append, make-table, and cross tab
queries.
3. can find, filter, add, change, or delete records (including duplicate and unmatched).
4. can change the structure of a database and the appearance of a datasheet.
5. can create relationships, specify referential integrity, and use
subdatasheets.
6. can create and use a lookup field.
7. can specify and update a table using validation rules including a required field, a range, default values, legal values, and formats.
8. can create single and multiple field indexes.

PowerPoint:
1. can plan, create, save, and run a PowerPoint presentation using templates and outline.
2. can incorporate animation schemes into a presentation.
3. can edit, insert, rearrange, and delete slides in a presentation.
4. can change design templates.
5. can select, move, copy, delete, and size objects on a slide.
6. can add animation effects, insert, size, and scale clip art images in a presentation.
7. can add headers and footers to slides and notes and handouts.

 

 

University Disability Statement:

For students who have a specific physical, psychiatric, or learning disability and require accommodations, please let me know early in the quarter so that your learning needs may be appropriately met. By law, it is your responsibility to provide documentation of your disability to the Office of Disability Services, located in the Student Success Center, Massie Hall, (Ph) 351-3594, PRIOR to receiving services.

 

Evaluation:

Tests will be given at the completion of Word, Excel, Access, and PowerPoint.  Test scores and project scores will be added together to ascertain the student grade for the class.  Tests will count 60% of the total grade and projects will count 40% of the total grade.

 

All projects must be turned in by the next class after they are assigned.

 

You are required to do your own work on all tests and assignments. Any form of cheating may result in a grade penalty or the student being withdrawn from the course as well as dismissal from the University. See page 37 of the Shawnee State University catalog.

Make-Up Tests:

A comprehensive final exam will be administered during the final exam period to all students in the course.  Those requiring make-up for tests missed will have the score on the final exam replace missed exam scores and those students, who have not missed a test, will have their score on the final exam replace their lowest test score made during the course.

 

Extra Credit:

Points may be awarded based on attendance, neatness of work turned in, courtesy, completion of homework and similar factors.

 

Grading Scale:              90 – 100   A

                                    80 – 89     B

                                    70 – 79     C

                                    60 – 69     D

                                    Below 60 F

 

Attendance:

The student is responsible for the activities of each class period. Assignments are due as stated on the attached weekly schedule. Late assignments will receive reduced credit.
Students missing class because of legitimate reasons must consult with the instructor by telephone or email concerning the absence. Legitimate absences do not excuse the student from class responsibilities. Examples of reasons to be excused by the instructor are serious illness, death in the family, or institutional activities. Documentation for absences may be required.

 

Instructional Delivery Method:

Lecture, class discussions, lab assignments

 

Licensure or Accreditation Statement

N/A

 

Record Retention:

I will retain all student work submitted for grading for two weeks after the end of the quarter, at which time I will put the material through a paper shredder.

 

Payne Protocol:

The instructor reserves the right to modify the syllabus without advance notice.



Miscellaneous:
All data files are located on the X drive under BUAI 1010.

Word, Access, Excel, PowerPoint, and
SAM are loaded in the Success Center. Use Lab 149 for SAM. You may also use the labs in Kricker Hall when they are open.

Tentative material schedule:
Week 1: Essentials/Intro
Weeks 2,3: XP
Weeks 4,5,6,7: Word 1,2,3, Web
Weeks 8,9,10: Excel 1,2,3
Weeks 11,12,13: Access 1,2,3
Weeks 14,15: PowerPoint 1,2

 

Week

Assignment

1

Syllabus

SAM Pre-Test

Essentials/Intro

 

2

XP

3

XP

4

Word Project 1 – In the Lab 3

5

Word Project 2 – In the Lab 2

6

Word Project 3 – In the Lab 1, 2

SAM Training – Word Projects 1,2,3

7

Word Web – project to be assigned

Word Test

8

Excel Project 1 – In the Lab 2

9

Excel Project 2 – In the Lab 2

10

Excel Project 3 – In the Lab 2

SAM Training – Excel Projects 1,2,3

Excel Test

11

Access Project 1 – In the Lab 3

12

Access Project 2 – In the Lab 3

13

Access Project 3 – In the Lab 3

SAM Training – Access Projects 1,2,3

Access Test

14

PowerPoint Project 1 – In the Lab 2

15

PowerPoint Project 2 – In the Lab 3

SAM Training – PP 1,2

PP Test

Exam Week

Final Exam