COMPUTER CONCEPTS
CGS 1570
TEACHER: Eris Reddoch
OFFICE: 3212
PHONE: 484-2279
Email: ereddoch@pjc.edu or
| WEEK |
CLASS ACTIVITIES |
READINGS & ASSIGNMENTS |
| 01/09 | Introduction & Overview of class. Computers as tools. Systems. Hardware and Software. | Read Essential
Introduction to Computers. Beginning using the computer to access data on the web. |
| 01/16 | Monday Holiday:
Martin Luther King Day Computer Hardware: cpu, memory, storage, input and output. |
Windows XP Project 1. |
| 01/23 | Using the Computer: Windows XP 1 Learning to use disks, diskettes, CD/Rs, and jump drives to store and manage files. |
Assignment 1: Create, save and Print a memo using Word and Paint. (Due 01/30) |
| 01/30 | Using the Internet:
Browsers and the Web Using the Internet: Searches, Email, FTP and Web pages. |
Assignment 2: Perform searches using a Browser and a search engine and send information to your instructor using EMail. (Due 02/06) |
| 02/06 | Review for Test 1. Test 1, on Concepts, Operating Systems, and the Internet. |
|
| 02/13 | Word 1: Creating and Editing a Word Document. Entering and formatting text. Inserting and manipulating clip art. | Assignment 3: A Flyer. (Due 02/20) |
| 02/20 | Word 2: Creating a Research Paper. Copying text into a file. Adjusting spacing and margins. Adding text. Pagination. Footnotes/Endnotes Citation pages. Proofreading and revising work. | Assignment 4: A research paper. (Due 02/27) |
| 02/27 | Word 3: Resume and Cover Letter: Using Wizards. Tables, Styles, and Lists. Inserting lines. Manually place tabs. Inserting: dates, non-breaking spaces, auto-text. Bullets and numbered lists. | Assignment 5: A resume and cover letter. (Due 03/06) |
| 03/06 |
PowerPoint 1: Creating a Simple Slide Show Presentation.
PowerPoint 2: A more complex Slide Show. Clip art. Transitions. Special Effects. |
Assignment 6: Project 1, as done in class. (Due 03/20) Assignment 7: Project 2, as done in class. (Due 03/20) |
| 03/13 |
Spring Break |
|
| 03/20 |
Review for Test 2. Test 2 on Word Processing and Presentation Software. Excel 1: Creating a Worksheet. Simple Formulas. Copy and Fill. Formatting the sheet. Creating a chart. Printing. |
Assignment 8: Worksheet with embedded graph ( Due 03/27) |
| 03/27 | Excel 2: Formulas, Functions, formatting and Web Queries. | Assignment 9: Worksheet with formulas and Queries. (Due 04/03) |
| 04/03 | Excel 3: What-if Analysis. Absolute vs. Relative addressing. The If function. Pie Chart. Naming and ordering sheets. | Assignment 10: What If Analysis, Absolute addressing, and Charting. (Due 04/10) |
| 04/10 |
Access 1: Creating a Database Using Design and Datasheet Views. Creating tables. Adding records. Creating a form and a report. |
Assignment 11:A Simple Database. (Due 04/17) |
| 04/17 | Access 2: Querying Databases. Creating a query. Compound queries. Sorting data. Joining tables. Calculating fields. | Assignment 12: Querying a Database.. (Due 12/08) |
| 04/24 |
Programming Review for final |
Finish any missing assignments. Study for final exam! |
| 05/01 | Final Exam (Test 3), on Excel, Access and all previously covered material! |
|
Grade Scale |
||||
| A | 94 100 | C | 74 79 |
Grading Percentages |
| B+ | 90 93 | D+ | 70 73 |
3 Tests. 75% |
| B | 84 89 | D | 64 69 |
12 Assignments.. .25% |
| C+ | 80 83 | F | 0 63 | |
ATTENDANCE POLICY: After three absences a student may be withdrawn from class. Please, let your instructor know if you are going to be absent. "Hands on" activities done in class are almost impossible to make up on your own, so try your best to attend each class.
WITHDRAWAL/INCOMPLETE POLICY: The college policy is that a student, or instructor, may withdraw a student up through the 70% point of a course. After the 70% point, neither the instructor nor the student may withdraw a student, and the student must remain in the course, and receive the grade they earn. It is the students responsibility to withdraw from a course, dont ask me to withdraw you, take responsibility and do it yourself. Please note, the last date to withdraw this term around March 33, 2006.
Incompletes are rarely given and only if over 70% of the course work has already been completed successfully and the instructor and student agree that the remaining work can be completed by a stated time that is no more than one year from the end of the course.
STUDENTS WITH DISABILITIES: If you have a documented disability, let me know the first week of class. You must let Disabled Student Services know as well. That office will forward documentation to me.
This course schedule and content outline is subject to change depending on circumstances that arise during the conduct of the course.