ITE 115 –MICROCOMPUTER APPLICATIONS IN BUSINESS

COURSE SYLLABUS

Room 2402 Spring 2006
Instructor: Phil Hamlett	E-mail: hamlettp@cvcc.vccs.edu
Home phone: 237-4430	Mobile: philmobile@webovations.net
Work phone: 948-5070	WWW: http://www.webovations.net/cvcc

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 student’s 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, January 9^th .........….............Classes Begin

§ Friday, January 13^th ..............…...…........Last Day for Adds

§ Monday, January 16^th .………..........……...Official Recess - No Class

§ Monday, January 23^rd ….........................Last day for Drops/Receive Tuition Refund

§ Friday, February 1^st …............................Last day to apply for graduation

§ March 6^th – 11^th ………..………….……….…..Official Recess - No Class

§ Monday, March 20^th …..….......................Last Day to Withdraw w/o Grade Penalty

§ Monday, May 1^st……...........................Classes End

§ Tuesday-Monday May 2^nd – 8^th ........Final Exams

TENTATIVE ASSIGNMENT SCHEDULE:

Date	Topic	Assignment
Monday, January 9^th	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, January 11^th	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, January 16^th (NO CLASS)
Wednesday, January 18^th
Monday, January 23^rd	Test #1 – Introduction to Computers and Introduction to Windows XP and Office 2003 Project 1
Wednesday, January 25^th	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, January 30^th
Wednesday, February 2^nd	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, February 6^th
Wednesday, February 8^th	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, February 13^th
Wednesday, February 15^th	Test # 2 – Projects 1, 2 & 3 Word 2003
Monday, February 20^th	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 Watson’s 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, February 22^nd
Monday, February 27^th	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)
Wednesday, March 1^st
Monday March 6^th & Wednesday March 8^th	NO CLASS – SPRING BREAK
Monday, March 13^th	Project #3 – What-if analysis, Charting, and working with Large Worksheets	· Page EX 212 – In the lab Seven-Year Financial Protection(#1)
Wednesday, March 15^th
Monday, March 20^th	Test # 3– Projects 1, 2 & 3 Excel 2003
Wednesday, March 22^nd	Project 1 – Using a Design Template and Autolayouts to create a Presentation	· Page PPT 69 – In the lab Proper Tire Care Presentation(#1)
Monday, March 27^th
Wednesday, March 29^th	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, April 3^rd
Wednesday, April 5^th	Test #4 – Powerpoint Presentations
Monday April 10^th
Wednesday, April 12^th	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)
Monday, April 17^th
Wednesday, April 19^th	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)
Monday April 24^th
Wednesday, April 26^th
May 2^nd to May 8^th – Final Exams	FINAL EXAM - Wednesday, May 3^rd , from 5:30-8 p.m.