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 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 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 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 No late assignments will be accepted after 2 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.
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. This is a requirement.
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 – 1/9 Class policies, syllabus, e-mail
Essential Computer Concepts
2 – 1/16 Windows XP: Exploring the Basics
3 – 1/23 Managing Your Files
4 – 1/30 Browser Basics Overview
Test 1 (2/1)
5 – 2/6 Browser Basics Overview
Using Common Features of Office
6 – 2/13 Using Common Features of Office
Word 2003
7 – 2/20 Word 2003
Excel 2003
8 – 2/27 Excel 2003
Test 2 (3/1)
9 – 3/6 Integrating Office 2003: Word and Excel
10 – 3/13 Access 2003
11 – 3/20 Integrating Office 2003: Word, Excel and Access
12 – 3/27 PowerPoint 2003
Test 3 (3/29)
13 – 4/3 PowerPoint 2003
Integrating Office 2003: Word, Excel, Access, and PowerPoint
14 – 4/10 Spring Break (no class)
15 – 4/17 Integrating Office 2003: Word, Excel, Access, and PowerPoint
Internet II
16 – 4/24 Internet II
Term Presentation
17 – 5/1 Term Presentation
Final exam (5/3)