COURSE
SYLLABUS
BUIS1010-02
Computer Applications I
|
Instructor |
Jean P
Houser, Professor |
Phone |
351-3670 |
|
Office |
227
Kricker |
E-mail |
|
|
Office
Hours |
W T R 12:00
noon – 2:30 pm |
Dept. |
Business
Dept. |
Kricker 252
1 Microsoft Office 2007 Introductory Concepts and Techniques Windows XP by Shelly Cashman Vermaat
2
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.
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.
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
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
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.
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
Lecture,
class discussions, lab assignments
N/A
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.
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
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 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 |
|
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 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 Access Test |
|
14 |
PowerPoint Project 1 – In the Lab 2 |
|
15 |
PowerPoint Project 2 – In the Lab 3 PP Test |
|
Exam Week |
Final Exam |