COMPUTER CONCEPTS
CGS 1570
TEACHER: Eris Reddoch
OFFICE: 3212
PHONE: 484-2279
Email: ereddoch@pjc.edu or
| WEEK |
CLASS ACTIVITIES |
READINGS & ASSIGNMENTS |
| 08/29 | Introduction &
Overview of class. Computers as tools. Systems. Hardware and Software. Types of Computers. Computer Hardware: cpu, memory, storage, input and output. Computer Software: Operating Systems & Applications. |
Read Essential
Introduction to Computers. Begin to use the computer to access data on the web: Syllabi, Schedule & Online Labs. Assignment 1: Complete and Print Online Labs: Input Devices and Peripheral Devices. Read Windows XP Project 1. |
| 09/05 | Learning to use
disks, diskettes, CD/Rs, and USB drives to store and manage files.
Using the Computer: Windows XP 1 The Windows XP Desktop. Windows Explorer. |
Assignment 2: Complete and Print Online Labs: Understanding the Motherboard, Binary Numbers and Maintaining a Hard Drive. Assignment 3: Complete and Print Online Labs: Using Windows and Managing Files and Folders. |
| 09/12 | Using the Internet:
Browsers and the Web Using the Internet: Web Searches. Using the Internet: Email, FTP and Web pages. Review for Test 1. |
Assignment 4:
Complete and Print Online Labs: Networking Basics, Connecting to the
Internet, and Getting the Most out of the Internet. Assignment 5: Complete and Print Online Labs: E-Mail, create an E-Mail account (if you do not have one) and use it to email your instructor a message. Read Word Project One and Word Project Two. Completing the Online Lab: Word Processing may be helpful during the next 2 weeks, but is not required. |
| 09/19 |
Test 1, on Concepts, Operating Systems, and the Internet. Word Project 1: Creating and Editing a Word Document. Entering and formatting text. Inserting and manipulating clip art. Word Project 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 6:
Cases and Places 1 on page WD71. Assignment 7: The research paper, completed in class with guidance from your Instructor. Read Word Project Three. Read PowerPoint
Project One and PowerPoint Project Two.
Completing the Online Lab: Presentation Software may be helpful during the
next 2 weeks, but is not required. |
| 09/26 | 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. PowerPoint 1: Creating a Simple Slide Show Presentation. PowerPoint 2: A more complex Slide Show. Clip art. Transitions. Special Effects. Review for Test 2. |
Assignment 8: A resume and cover letter, completed in class with
guidance from your Instructor.
Assignment 9: Cases and Places 2, page PPT139. Read Excel Project
One, Excel Project Two and Excel Project Three. Completing the Online
Lab: Spreadsheets may be helpful during the next week, but is not required. |
| 10/03 | 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. Excel 2: Formulas, Functions, formatting and Web Queries. Excel 3: What-if Analysis. Absolute vs. Relative addressing. The If function. Pie Chart. Naming and ordering sheets. |
Assignment 10: Cases and Places 1, page EX 63. Assignment 11: Cases and Places 1, page EX140. Assignment 12: Cases and Places 2, page EX222. Read Access Project One. Completing the Online Lab: Databases may be helpful during the next 2 weeks, but is not required. |
| 10/10 |
Access 1: Creating
a Database Using Design and Datasheet Views. Creating tables. Adding
records. Creating a form and a report. Access 2: Querying Databases. Creating a query. Compound queries. Sorting data. Joining tables. Calculating fields. |
Assignment 13: In the Lab 1, page AC56. Assignment 14: In the Lab 1, page AC109. |
| 10/17 | Programming:
Computer Languages, Rapid Application Development, Where to go from here:
COP1000 (Game Programming), COP1510 (Programming Concepts I), COP2332
(VB.Net) and COP2800 (Java). Review for Final Exam. Final Exam (Test 3), on Excel, Access, Programming and all previously covered material! |
Assignment 15: Complete and Print Online Labs: Visual Programming.
|
|
Grade Scale |
||||
| A | 94 100 | C | 74 79 |
Grading Percentages |
| B+ | 90 93 | D+ | 70 73 |
Tests. 75% |
| B | 84 89 | D | 64 69 |
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.
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.