BUS 226
MICROCOMPUTER APPLICATIONS IN BUSINESS
COURSE
SYLLABUS
|
Room 3204
Fall 2005 |
|
|
Instructor: Phil Hamlett |
E-mail: hamlettp@cvcc.vccs.edu |
|
Home phone: 237-4430 |
Mobile: philmobile@webovations.net |
|
Work phone: 948-5070 |
|
COURSE
DESCRIPTION:
Introduces
terminology, concepts and methods of using computers in Information Systems and
instructs in computer literacy and proficiency in Office 2003. This is a lecture class consisting of 3
hours per week and constitutes 3 credit hours.
COURSE TEXT:
Microsoft Office 2003 Introductory Concepts and Techniques
Shelly,
Cashman and Vernaat
MATERIALS
REQUIRED:
Four 3 ½ high-density disks or a jump (flash) drive
ATTENDANCE
EXPECTATIONS:
Students are expected to be present for all class meetings,
and to review text material and assignments prior to each lecture session. In case of absence, the student is expected
to be responsible for completion of all assignments as outlined in this
syllabus. Computers are also available
in the open lab, which can be used for the completion of assignments. Check the schedule outside the lab door for
lab availability.
GRADING POLICY FOR COURSEWORK:
Projects assigned in class are expected to be completed by
the deadline specified by the instructor.
Projects will be accepted late, but will be penalized 5 points for each
class date that has passed since the due date of the project. Late work will not be accepted more than two
class dates after the initial due date. Discussion of in-class laboratory exercises is encouraged, however, projects that are to be turned in for
grade must not involve any collaborative effort on the part of students, unless
the instructor explicitly states
otherwise.
GRADING:
|
The students
final grade will consist of the following 3 components: Tests
60% Class
Projects 20% Final Exam 20% |
Grading
Scale: A 90 - 100 B 80 - 89 C 70 - 79 D 60 - 69 F < 60 |
FALL
SEMESTER CALENDAR:
§
Monday,
August 22 .........
.............Classes Begin
§
Friday, August 26 ...............
...
........Last Day for
Adds
§
Friday ,September 2
.........................Last day for
Drops/Receive Tuition Refund
§
Monday Sept. 5
..........
...Official Recess - No
Class
§
Friday ,September 9............................Last day to
apply for graduation
§
Wednesday, October 26......................Last Day to
Withdraw w/o Grade Penalty
§
Wed. - Sat.
November 23-26
.
..Official Recess - No Class
§
Monday,
December 12..........................Classes End
§
Tuesday-Monday
December 13-19......Final Exams
TENTATIVE
ASSIGNMENT SCHEDULE:
|
Date |
Topic |
Assignment |
|
Monday, August 22nd |
Introduction to Computers |
·
Visit websites on p. COM-26 (Figure 40)
. Compare the prices of computers. Print a copy of computer specifications
that you examine. ·
Visit online provider sites on p. COM-30
(figure 43). Compare the various
features offered by each company such as e-mail, web page hosting, chat, etc. ·
Page
COM-39 Learn it online Project reinforcement (#1) - print for
review
http://www.scsite.com/off2003/0-619-25489-0_mc1.htm Practice test (#2)
Print test for review
http://www.scsite.com/practicetest/default.cfm?ISBN=0-619-25489-0&project=1 |
|
Wednesday,
August 24th |
Project 1 Introduction to Microsoft Windows
XP Introduction to Office 2003 |
·
Page
WIN-91 Learn it online Project reinforcement (#1) -print and use book to answer questions in
review of project #1
http://www.scsite.com/off2003/0-619-25477-7_mc1.htm Practice test (#3) Complete test and print
http://www.scsite.com/practicetest/default.cfm?ISBN=0-619-25477-7&project=1 Try out Tips & Tricks (#7) for practice
http://www.microsoft.com/windowsxp/expertzone/tips/moretips.asp |
|
Monday,
August 29th |
||
|
Wednesday,
August 31st |
Test #1 Introduction to Computers and Introduction to Windows XP
and Office 2003 Project 1 |
|
|
Monday, September
5th |
NO CLASS |
|
|
Wednesday,
September 7th |
Project 1 Creating and editing a Word
document |
·
Page WD 64
Learn it online Project reinforcement (#1) print and use
book to answer
http://www.scsite.com/off2003/0-619-20037-5_p1_mc1.htm Practice test (#3) Take the practice test
and print
http://www.scsite.com/practicetest/default.cfm?ISBN=0-619-20037-5&project=1 ·
Page WD 67
In the Lab Creating an announcement with clip art (#1) Creating an announcement with resized clip
art, a bulleted list, and color ·
Page WD 71
Cases and Places Case study #3 use concepts &
techniques learned to make announcement |
|
Monday,
September 12th |
||
|
Wednesday,
September 14th |
Project 2 Creating a Research paper |
·
Page WD
128 Learn it online Practice test (#3) Take the practice test
and print
http://www.scsite.com/practicetest/default.cfm?ISBN=0-619-20037-5&project=2 ·
Page WD
129 Apply your knowledge Revising a document (#1) Open Apply 2-1
Authentication Paragraph (Drive S) ·
Page WD
130 In the lab Preparing a Short Research Paper (#1) Prepare a Research Report with a footnote
(#2) (stop after step number 6 in the part 2 instructions. |
|
Monday,
September 19th |
||
|
Wednesday,
September 21st |
Project #3 Creating a Resume Using a
Wizard and a Cover Letter with a table |
·
Page WD
198 Apply your knowledge Working with Tabs and a Table (#1) Open
Apply 3-1 Expenses Table (Drive S) ·
Page WD
199 In the lab Creating a cover letter with a Table (#2) ·
Page WD
201 Cases and Places Follow directions to create a calendar (#1) Follow directions to create a fax (#3) |
|
Monday,
September 26th |
||
|
Wednesday,
September 28th |
Test # 2 Projects 1, 2
& 3 Word 2003 |
|
|
Monday,
October 3rd |
Project 1 Creating a worksheet and
Embedded Chart |
·
Page EX 57
Apply your knowledge Changing the values in a worksheet (#1)
Open Apply 1-1 Watsons Computer Discount Annual Sales (Drive S) ·
Page EX 58
In the lab Monthly Sales Analysis worksheet (#1) Annual Business Analysis Worksheet (#2) ·
Page EX 64
Cases and Places Follow directions to prepare worksheet based
on information in the case. (#3) |
|
Wednesday,
October 5th |
||
|
Monday,
October 10th |
NO CLASS |
|
|
Wednesday,
October 12th |
Project # 2 Formulas, Functions, Formatting and Web Queries |
·
Page EX
130 Apply your knowledge Profit Analysis Worksheet (#1) Open the
workbook Apply 2-1 e-cove Profit
Analysis (Drive S) ·
Page EX
132 In the lab Weekly Payroll Worksheet (#1) Accounts Receivable Worksheet (#2) |
|
Monday,
October 17 |
||
|
Wednesday,
October 19th |
Project #3 What-if analysis, Charting, and
working with Large Worksheets |
·
Page EX
212 In the lab Seven-Year Financial Protection(#1) |
|
Monday,
October 24th |
||
|
Wednesday,
October 26th |
Test # 3 Projects 1, 2 &
3 Excel 2003 |
|
|
Halloween |
NO CLASS |
|
|
Wednesday,
November 2nd |
Project 1 Using a Design Template and
Autolayouts to create a Presentation |
·
Page PPT
69 In the lab Proper Tire Care Presentation(#1) |
|
Monday,
November 7th |
||
|
Wednesday,
November 9th |
Project 2 Using Outline Tab and Clip Art
to Create a Slide Show |
·
Page PPT 131 Apply your knowledge Hiking for Family Fitness (#1) Open Apply
2-1 Hiking Adventure (Drive S) ·
Page PPT
132 In the lab Bass Lake Camping Presentation(#1) |
|
Monday,
November 14th |
||
|
Wednesday,
November 16th |
Test #4 Powerpoint Presentations |
|
|
Monday November
21st |
||
|
Wednesday,
November 23rd |
NO CLASS |
|
|
Monday,
November 28th |
Project 1 Creating and Using a Database |
·
Page AC 54 Apply your knowledge Changing Data, Creating Queries and Creating
Reports (#1) Open the database Begon Pest Control (Drive S) ·
Page AC
56 In the lab Creating the Birds2U Database (#1) Creating the Babbage Bookkeeping Database
(#2) |
|
Wednesday
November 30th |
||
|
Monday,
December 5th |
Project 2 Querying a Database Using the
Select Query Window |
·
Page AC
109 In the lab Querying the Birds2U Database (#1) Querying the Babbage Bookkeeping Database
(#2) |
|
Wednesday,
December 7th |
||
|
Monday,
December 12th |
||
|
Dec. 13th
thru 19th (Final Exams) |
EXAMS |
|
|
|
||