Assignments

Power Point Slide Shows
 

 SAMs key code direct from publisher (Instant Access)

 

Classes End on April 29, 2010

        
You may click the above link to
buy your textbook. You must have this book and only this boo
k.

 

CGS 1100
 

Spring 2010

Introduction to Microcomputer Applications

 
Instructor:  Dr. Michael S. Copper Semester:  Spring 2010
Office:   TC 411 Lectures, Exams, Video and Lab Assignments
Phone:  561 868-3220 Room:  See your schedule
Email: copperm@pbcc.edu Office Hours:  By appointment if necessary.  If I am in my office you are welcome to come and visit me. My office hours are posted near my office door.

SAMs End Date  >>>

April 29, 2010 - you will no longer have access to the exams.  Final exam week follows.  Students can only take the final exam during final exam week.  No lab work will be accepted during final exam week.  Lab work will only be turned in during class.  The last day to withdraw from this class is March 29.

Course Description

This course provides an overview of microcomputer applications including a brief introduction to computer concepts, Microsoft Windows, Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, and computer technology in today's society.  We will use MS Office 2007 for the course.  We will use Windows XP for our operating system, not MS Vista.  This may change to Windows 7 at sometime during the course.

Textbook and supplies

You must have the above text book to complete the course.  If you do not obtain a book then you must withdraw from the course.  You must have the book no later than the fifth class meeting.    You may buy a used book if available.  You will need a USB drive for this course.  Any drive size over 256 MB is ok.

Your Book:  Microsoft Office 2007: Introductory Concepts and Techniques, Windows XP Edition  Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat.  You must have this book, not last semester's book.  You will also need a set of ear phones or ear buds.  You must have the CD that comes with this book.

ISBN 10: 0324826842

SAMs key code direct from publisher. Instant Access

GRADING

Course Grade Points      Grade
Eleven Exams All exams are 100 points each. Your grades are added and divided by 11 for your final grade.
Nine Practice Exams 0  
Twelve Lab Assignments One point will be removed from your final total grade for each lab assignment not completed. To earn the lab credit show me you assignments before the last day of class.  I will look at your work on your storage media.  Do not hand in printed assignments.

 

A   =  91 - 100,  B = 80 - 90, C = 71 - 79, D = 65 - 70, Below 65 = F; Your instructor does not round grades up.  An 90.7 is a 90.  Your test scores can be viewed on SAMs.

 

COURSE POLICIES

Student Conduct In Class Policy

Any acts of classroom disruption that go beyond the normal rights of students to question and discuss with instructors the educational process relative to subject content will not be tolerated, in accordance with the Academic Code of Conduct described in the Student Handbook.
You will print nothing in the classroom without the permission of your instructor.  There are printers available in the Learning Center located on the 2nd floor of this building.  You will download nothing.  You will email me no assignments even if the text says to.

Children/Visitors In Class Policy

Children and visitors are not allowed in class, do not ask. 

Electronic Devices In Class Policy

The use of cellular phones, pagers, CD players, radios, and similar devices is prohibited in the classroom and laboratory facilities. Calculators and computers are prohibited during examinations and quizzes, unless specified. Talk on your cell phone in class and your final grade will be lowered by one letter grade for each incident.  The second time you cell phone rings in class your final grade will be lowered by one letter grade and one letter grade for each additional incident.  Keep them turned off.  There are no exceptions, do not ask.

Examination Policy

 You must complete the exams by the due date listed under exams.    Your exam scores will be posted on SAMs.   You will complete  final exam in class.  You may take the practice exams in class or out of class on any computer that has internet access. All non practice exams will be taken in class. 

Preparing for Examinations: Attend lecture and read the chapters. At least 90% of the questions are taken directly from the reading material..  You can only take a regular exam one-time.  The exams are timed.  The practice exams are timed and you may take them 5 times.   The questions for the practice exams are very similar to the questions used on the regular exams. 

In Case You Are Late or Absent: It is your responsibility to get the course notes, handouts, and laboratory assignments should you miss class or be late. The assignments will be listed on this page.  If you come late to class do not ask the instructor what you missed.  I suggest you make some friends in the class.

Incomplete Policy

Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing and must have completed at least eight exams.   In other words you must have a passing average before an incomplete grade will be issued.  Your instructor will not come looking for you to complete the course. 

Cheating Policy

Students are expected to uphold the college’s standard of conduct relating to academic honesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student's submitted work, examinations, reports, and projects must be that of the student's own work. Students shall be guilty of violating the honor code if they:

1.      Represent the work of others as their own.

2.      Use or obtain unauthorized assistance in any academic work.

3.      Give unauthorized assistance to other students.

4.      Modify, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.

5.      Misrepresent the content of submitted work.

The penalty for violating the honor code is severe. Any student violating the honor code is subject to receive a failing grade for the course and will be reported to the Office of Student Affairs. If a student is unclear about whether a particular situation may constitute an honor code violation, the student should meet with the instructor to discuss the situation.

For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned projects, assignments, and tasks. In other words, students may not "work together" on graded assignments. Such collaboration constitutes cheating. A student may not use or copy (by any means) another's work (or portions of it) and represent it as his/her own. If you need help on an assignment contact your instructor.

Disabilities Policy

In compliance with the Americans with Disabilities Act (ADA), all qualified students enrolled in this course are entitled to “reasonable accommodations.” Please notify the college's disabilities office for further information.

Learning Center Assistance

Consultants in the Learning Center are on duty to assist you with hardware and software problems. If your computer malfunctions or your printer is out of paper, go to the main desk and ask a consultant for help. The consultants are not laboratory assistants and, therefore, are not responsible for answering specific laboratory homework questions.  The learning center is on the second floor of the TC building.  Your instructor only deals with the learning center on the Lake Worth campus.

Extra Credit

None. 

Viewing Your CGS 1100 Grades

You may view your grades through SAMs.  Your final course grade will be posted on the college's Website.  Your instructor will not discuss your final course grade over the phone or via email.  This is against school policy.  I will discuss your grades in my office.

Attendance

Attendance will be taken.  After the fifth absence I will withdraw you from the course.  This policy applies to hybrid students after the third absence. I do not need to hear why you missed class.  I do not deal with excused/unexcused absences.  Should you desire to withdraw from this course follow the procedures in the college catalog or student guide. School functions may override this policy at my discretion. March 29, 2010 is the last day to withdraw from this class.

LECTURE, LABORATORY, AND EXAMINATION SCHEDULE

You are also advised to click here and view the Power Point presentations an each chapter..    Do not forget to read your college email on a daily basis.   Do not print anything for this class.  Do not download anything for this class.

Activity Reading and Video Assignment 
(from Shelly Cashman text)
I recommend you work through the assignment's project to get the most benefit from the course.
Complete the reading assignment before starting the projects.
Text Book Lab Assignments.  You will save your lab assignments on a , thumb drive and show your instructor all (at one time) assignments before your last class.  Do not give me any printed work.  Show me your work on you USB Flash Drive.  Never email me any of your assignments.  If you want to use the printer ask me first.I will not accept lab work during final exam week.  Don't ask
Exams
All exams are listed under exams on SAMs.  Note the dates of the exams.  More especially note the cut off dates.
1

1. Essential Introduction to Computers

2.  Windows XP (WIN4 - WIN65)

 

Text book only, no written work. There is nothing to save for this first assignment. Just do the reading assignment and XP exams.

Windows XP Brief, 

XP Practice Test
XP Exam
2 Read MS Word Chapters 1 - 2 - 3
Watch the video for each chapter.
Word Chapters  1 - 2 - 3
Do Project 1, WD 2, Learn to Ride.
Complete the Autumn Festival document on WD 64.
Complete the practice research paper displayed on page WD 75.
Do the cover letter and resume starting on page WD 146.

Type the papers from scratch - no downloads.

MS Word Practice Exam Project 1
MS Word Project 1 Exam

MS Word Practice Exam  Project 2
MS Word Project 2 Exam

3 Read MS Excel Chapters  1 - 2 - 3
Watch the video for each chapter.
Excel Chapters  1 - 2 - 3
Complete the spreadsheet displayed on page EX 3.
Complete the assignment starting on page EX 75, Scissors Office Supply.
Make the spreadsheet displayed on page EX 83.  Do not do the Real-Time quotes part of the assignment.
Create the spreadsheet displayed on page EX 163.
Excel Practice Exam Project 1
Excel Project 1 Exam

Excel Practice Exam Project 2
Excel Project 2 Exam

Excel Practice Exam Project 3
Excel Project 3 Exam
 

4 Read MS Access Chapters 1 - 2
Watch the video for each chapter.
Do the Chapter 1 and 2 projects in Access.  For Chapter 2 just save any two of the queries.  Read Access Chapter 3. Access Practice Exam Project 1
Access Project 1 Exam

Access Practice Exam Project 2
Access Project 2 Exam

Acess Practice Exam Project 3
Access Project 3 Exam

5 Read MS Power Point Chapters 1 - 2
Watch the video for each chapter.
Make the Chapter 1 Power Point Presentation.
Do presentation #1 on PPT 78. Be creative.
Create the presentation in Chapter 2, page 82.
Create an Energy Savings presentation, page PPT 142 #1.  Be creative.
Power Point Practice Exam Project 1
Power Point Project 1 Exam

Power Point Practice Exam Project 2
Power Point Project 2 Exam is the final exam.

       

Suggested Strategy to Complete the Course.

Note on PCs outside of the college.  If you have an internet connection you can assess SAMs from anywhere in the world.   Your instructor has no control over this.  Your instructor is in no way responsible for the operation of anyone's personal computer outside of the classroom.  Not being able to use SAMs  outside of the classroom is not an excuse for incomplete assignments.  Remember there are PCs available on the second floor of the TC building.  You will not hook up any device to the college's internet connection.


Additional Sites/Presentations that Support the Course 

Students must purchase the SAM 4.0 key code package from either bookstore (PBCC or Booksmart).
When you sign up for SAMs you must join the correct course.  There is only one correct course for you to join.  This course is CGS 1100.  The course is listed under my name. The institution key is V7654867

SAMs Welcome Page  do not log on until you are told to do so.
 

I reserve the right to change or modify this syllabus as I deem necessary.

 

Hit Counter                        Page last updated:  Thursday January 28, 2010