COMPUTER CONCEPTS
CGS 1570
TEACHER: Eris Reddoch
OFFICE: 3212
PHONE: 484-2279
Email: ereddoch@pjc.edu or
| WEEK |
CLASS ACTIVITIES |
READINGS & ASSIGNMENTS |
| 08/25 | Introduction & Overview of class. Computers as tools. Systems. Hardware and Software. | Read Essential
Introduction to Computers. Begin to use the computer to access data on the web: Syllabi, Schedule & Online Labs. |
| 08/28 | Types of Computers. Computer Hardware: cpu, memory, storage, input and output. Computer Software: Operating Systems & Applications. |
Assignment 1:
Complete and Print Online Labs: Input Devices and Peripheral Devices.
|
| 09/04 | Monday Holiday:
Labor Day Learning to use disks, diskettes, CD/Rs, and USB drives to store and manage files. |
Assignment 2: Complete and Print Online Labs: Understanding the Motherboard, Binary Numbers and Maintaining a Hard Drive. Read Windows XP Project 1. |
| 09/11 | Using the Computer: Windows XP 1 The Windows XP Desktop. Windows Explorer. Other Operating Systems. |
Assignment 3:
Complete and Print Online Labs: Using Windows and Managing Files and
Folders.
|
| 09/18 | Using the Internet:
Browsers and the Web Using the Internet: Web Searches. |
Assignment 4: Complete and Print Online Labs: Networking Basics, Connecting to the Internet, and Getting the Most out of the Internet. |
| 09/25 | Using the Internet: Email, FTP and Web pages. Review for Test 1. Test 1, on Concepts, Operating Systems, and 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. |
| 10/02 | Word Project 1: Creating and Editing a Word Document. Entering and formatting text. Inserting and manipulating clip art. | Completing the
Online Lab: Word Processing may be helpful during the next 3 weeks, but is
not required. Assignment 6: Cases and Places 1 on page WD71. Read Word Project Two. |
| 10/09 | 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 7: The research paper, completed in class with guidance from your Instructor. Read Word Project Three. |
| 10/16 | 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 8: A resume and cover letter, completed in class with
guidance from your Instructor. Read PowerPoint Project One and PowerPoint Project Two. |
| 10/23 |
PowerPoint 1: Creating a Simple Slide Show Presentation.
PowerPoint 2: A more complex Slide Show. Clip art. Transitions. Special Effects.
|
Completing the Online Lab: Presentation Software may be helpful during the next 2 weeks, but is not required. Assignment 9: Cases and Places 2, page PPT139. Read Excel Project One. |
| 10/30 |
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. |
Completing the
Online Lab: Spreadsheets may be helpful during the next 3 weeks, but is not
required. Assignment 10: Cases and Places 1, page EX 63. Read Excel Project Two. |
| 11/06 |
Excel 2: Formulas,
Functions, formatting and Web Queries. Friday Holiday: Veterans Day |
Assignment 11: Cases and Places 1, page EX140. Read Excel Project Three. |
| 11/13 | Excel 3: What-if Analysis. Absolute vs. Relative addressing. The If function. Pie Chart. Naming and ordering sheets. | Assignment 12: Cases and Places 2, page EX222. Read Access Project One. |
| 11/20 |
Access 1: Creating a Database Using Design and Datasheet Views. Creating tables. Adding records. Creating a form and a report. Thursday & Friday Holiday: Thanksgiving |
Completing the Online Lab: Databases may be helpful during the next 2 weeks, but is not required. Assignment 13: In the Lab 1, page AC56. |
| 11/27 | Access 2: Querying Databases. Creating a query. Compound queries. Sorting data. Joining tables. Calculating fields. | Assignment 14: In the Lab 1, page AC109. |
| 12/04 |
Programming: Computer Languages, Rapid Application Development, Where to go from here: COP1000 (Game Programming), COP1510 (Programming Concepts I), COP2332 (VB.Net) and COP2800 (Java). |
Assignment 15: Complete and Print Online Labs: Visual Programming. Finish any missing assignments. Study for final exam! |
| 12/11 |
Review for final Final Exam (Test 3), on Excel, Access, Programming and all previously covered material! |
|
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.