CREDITS: 3 ROOM: W258 TIME: 10:30 - 12:20, TR
INSTRUCTOR: Tommy Lu OFFICE: W271 TEL: (302) 573-5475
e-mail address: lu@dtcc.edu Home page: http://www.dtcc.edu/~lu
PREREQUISITES: RDG 051
COURSE HOURS AND CREDITS: 3 Credits - 2 Hours Lecture/Week
2 Hours Lab/Week
COURSE DESCRIPTION: This course is an overview of the computer information systems concepts. Students will learn hands-on
how to use the most important topics of Microsoft Office 2003. No prior computer experience is assumed. You will first be
presented with an overview of Windows XP and File Management. Once you are comfortable with the basics of computing and
operation systems, you will learn some e-mail basics and internet browsing skills. Next, you will learn the Office 2003
programs, including Word 2003, Excel 2003, Access 2003, and PowerPoint 2003. You will also learn how to integrate these
applications, essential computer concepts, and how to create Web pages using each of these applications.
Collegewide Core Course Performance Objectives
The student will be able to:
Demonstrate an understanding of a computer system. (CCC 6; PGC 6)
Demonstrate an understanding of computer operating system software. (CCC 6, PGC 6)
Demonstrate an understanding of a computer communication in Internet and networks. (CCC 5, 6; PGC 15)
Demonstrate an understanding of an information system. (CCC 2, 3, 4, 5, 6; PGC 4, 5, 6)
Use word processing software to create a document. (CCC 6, PGC 6)
Design and create a worksheet using spreadsheet software. (CCC 6, 7; PGC 3)
Create and use a database. (CCC 5, 6; PGC 4)
Create a presentation using appropriate software. (CCC 5, 6; PGC 3)
Measurable Performance Objectives
At the end of the course, students will be able to independently perform the following tasks:
1. Word Processor Application
• Create and edit simple document
• Use word-wrap
• Save and open document to specified directory
• Format characters and paragraphs
• Set tabs and margins
• Insert, delete and move text
• Correct text
• Create and edit headers and footers
• Insert page and section breaks
• Insert graphics and tables into document
• Use and modify document style
• Create and modify footnotes
• Create bulleted and numbered paragraphs
2. Spreadsheet Application
• Navigation
• Adding and deleting Worksheets
• Entering numbers and text
• Formatting Worksheet
• Editing Cells
• Use of basic functions like AVERAGE, MAX, MIN, or SUM
• Saving, closing and opening spreadsheet
• Creating graphs and charts
• Inserting graph on a separate Worksheet
• Editing graphs and charts
• Inserting and deleting rows, columns, and cells
• Using relative and absolute addressing
• Use of IF function
• Copying, Pasting and Moving cells
• Freezing portions of a worksheet
• Changing toolbar and other attributes of the spreadsheet
• Goal Seeking
3. Database Application
• Create database
• Create and edit tables
• Add, delete and modify records in a table
• Save and open an existing database
• Create a Form
• Create a Report
• Create a simple Query
• Create a graph
• Sort and display selected records using a filter and a Query
• Create a compound Query
• Sort on multiple keys
• Use criteria in calculating statistics
• Change the structure of the database
• Create or modify validation rules
• Join two tables
• Access data from two or more joined tables
4. Presentation Applications
• Create, save and open a presentation
• Add, delete, and modify slides
• Change background and color scheme of slides
• Change transitions between slides
• Change views
• Add notes to slides
• Create tables and graphs
• Change order of slides
• Add graphics to slides
Text: "New Perspectives on Microsoft Office 2003, First Course", Premium Edition, by Ann Shaffer, Course Technology
METHOD OF INSTRUCTION:
1. Lectures: Important material from the text and outside sources will be covered in class. Students should plan to take
careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-
procured outside material relevant to topics being covered.
2. Assignments: Review Assignments, Case Problems, and other projects will be periodically assigned to reinforce material in
the text. These assignments may require the application of various software packages.
3. Internet: All material will be distributed on the Internet. Class notes, instructional material, and student assignments
will be posted on 'Blackboard' in a class website. Students are encouraged to go to the website www.course.com and
www.course.com/newperspectives in order to obtain file downloads and view other items of interest throughout the semester.
Evaluations: based upon the following: tests, homework assignments, pop quizzes and in-class labs/exercises. Students will
demonstrate proficiency on all measurable performance objectives at least to the 75% level to successfully
complete the course.
1. Tests: There will be four written tests including final exam. The highest three test scores will be used to calculate
your final grade.
2. In class labs/works: Range from 10 to 100 points, depends on the difficulty. All in class labs/works are due either at
end of the class or at beginning of next class. So if you missed a class, please check with me as
soon as possible to find out whether there is a class lab due.
3. Homework assignments/projects: 100 points each.
4. Homework assignments/projects: 33%
On-line discussions: 7%
Virtual classroom participations: 7%
Final presentation: 10%
Tests: 40%
Enthusiasm and class participation: 3%
Enthusiasm and class participation includes class attendance (tardiness), participation and other subjective observations.
Grade: average 92 or above ---> A
(Student meets the measurable objectives in an outstanding manner.)
average 83 or above but less than 92 ---> B
(Student meets the measurable objectives in an above average manner.)
average 75 or above but less than 83 ---> C
(Student meets the measurable objectives.)
average less than 75 but still attending classes---> R
(Student does not meet the measurable objectives.)
average less than 75 but stop attending classes ---> U
(Student does not meet the measurable objectives.)
Class attendance is very important. If you missed a class for any reason, please check the Blackboard or contact me as soon as possible for any in-class exercise, homework assignment and material covered. Please be advised that you are responsible for obtaining material distributed on class days when you were absent. This can be done through contacting a classmate who was present or by contacting me during my office hours or other times. No make-up test will be given and any missing test will be assigned zero.
If you have a question, please feel free to ask. Please do not let it skip. Everything you learn is a building block for the next topic. Should you find yourself behind the class, please discuss it with me after the class and make an arrangement to catch up. Please don't wait until the last minute for it would be very difficult for both of us to work out plans. If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as I have outlined it, or which will require academic accommodations, please notify me as soon as possible.
Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; or failure in course. All class exercises, homework assignments, and tests are individual work. Do your best but don't copy someone else's. Anyone found cheating/plagiarizing would receive zero on that exercise, homework, or test. For more information refer to the "Academic Dishonesty" policy in the College Catalog.
All late assignments will be accepted with penalty: within 1 day -----> 5 points within 1 week ----> 10 points within 2 weeks ---> 20 points within 3 weeks ---> 30 points No late assignments will be accepted after 3 weeks. Please save all your graded tests, e-mail message about your assignment/project scores, homework assignments, and projects. Should there is any arguments about your final grade, this is your only proof. Please check your college e-mail and the Blackboard at least once a day for any announcement and/or special notifications.
All homework assignments/projects must be turned in at the beginning of the class. You are not allowed to do your homework/project during lecturing. You have to place your name, chapter number, and assignment number on the upper left-hand corner on typed assignments. This is a requirement. All assignments, except otherwise noted, are to be submitted through Blackboard's Digital DropBox. Please follow directions how to submit your work electronically. Failure to do so will affect your grade in this class.
Students should refer to the Student Handbook for information on Academic Standing Policy, Academic Honesty Policy, Student Rights and Responsibilities and other policies relevant to their academic progress.
Week TOPICS
(Monday)
========== ==========================================
1 – 8/28 Class policies, syllabus, e-mail
Essential Computer Concepts
2 – 9/4 Windows XP: Exploring the Basics
Managing Your Files
3 – 9/11 Browser Basics Overview
Using Common Features of Office
4 – 9/18 Word 2003: Creating a Document
Test 1 (9/20)
5 – 9/25 Word 2003: Editing and Formatting a Document
Word 2003: Creating a Multiple-Page Report
6 – 10/2 Word 2003: Desktop Publishing and Mail Merge
Excel 2003: Using Excel to Manage Data
7 – 10/9 Excel 2003: Working with Formulas and Functions
Excel 2003: Developing a Professional-Looking Worksheet
8 – 10/16 Excel 2003: Working with Charts and Graphics
Test 2 (10/18)
9 – 10/23 Integrating Office 2003: Word and Excel
Access 2003: Introduction to Microsoft Access 2003
10 – 10/30 Access 2003: Creating and Maintaining a Database
Access 2003: Querying a Database
11 – 11/6 Access 2003: Creating Forms and Reports
12 – 11/13 Integrating Office 2003: Word, Excel and Access
Test 3 (11/15)
13 – 11/20 PowerPoint 2003: Creating a Presentation
14 – 11/27 PowerPoint 2003: Applying and Modifying Text and Graphic Objects
Integrating Office 2003: Word, Excel, Access, and PowerPoint
15 – 12/4 Creating Web Pages with Office 2003
Term Presentation
16 – 12/11 Term Presentation
Final exam (12/13)