CIS 105 - Computer Applications Fall 2008
|
9:30 – 10:20 AM |
Daily room 1302 |
Section 1, Item 0445 |
|
10:30 – 11:20 AM |
Daily room 1302 |
Section 2, Item 0447 |
Prof.: Robert Shields; Email:
rshields@shoreline.edu; Tel:
(206) 546-4773; Web: http://shoreline.edu/rshields
Office 1420 - Hours: see my web site or by appointment
Required Text: Bundle with Exploring Microsoft Office 20073 Volume I, by Grauer and Barber, Prentice-Hall, Inc., 2008 & Computer Concepts: ISBN 0-13-608400-1. You will need to read the book at least 3 times. The old 2003 book will not do.
Required Supplies: USB storage devices or substitute
Student Data files: http://www.prenhall.com/grauer or Q:\Shields\105\studentDataFiles 2007
DESCRIPTION: This class is an excellent introduction to business and personal desktop computing. Students learn Microsoft Office applications such as Word and Excel, Internet tools, & file management skills. Prerequisites: ASSET reading score of 40 and Math 080 or equivalent or instructor permission.
Class Schedule; I reserve the right to adjust this schedule to meet the needs of the class. See my web site for updates.
|
Week |
Homework in this column is on gray pages at the back of each chapter and is due Mon. unless noted |
by Tuesday each week, read the chapters listed in the far right column below start on page 1 for week one |
by Wednesday night each week : repeat the online study guide for the current chapter(s) until you score at least 75% then email me the result |
by Friday each week: 1. Learn Key terms. 2. Complete all hands-on - yellow pages exercises. You must hand in a printed sheet showing each exercise with your name, chapter name & # and exercise #. |
|
|
wk1 |
Due Wed. - Create a folder called C:\your_name Due Fri.-How many sec. to download 2.5MB file such as exp_word_vol1_sdf.zip using dial up vs. DSL? |
Office
Fundamentals p.1 -67 & |
|||
|
wk2 |
Due Monday - Homework 1: Get free email http://mail.shore.ctc.edu/info/ & p.57, Practice #1-Help & #2-Fraud. |
Windows
XP, p. 1077-1130 |
|||
|
wk3 |
Due Mon. - Homework. 2: P. 889-944, *Computing Concepts: draw a computer schematic; *Explain how to create a good password in an email message to me. & briefly explain every 11th key term on p. 43. & p.1125 #3-College bound |
(Email me this week to request an MSDN ID for a free,
student copy of MS Access) |
|||
|
wk4 |
Due Mon. - Homework 3: Practice with Word Ch.1 p. 121 #3-shortcuts, #4-protect, p. 127 capstone; Word Ch.2, p.183: #1-purchase,p 186 #4-edit |
Word Ch. 3 :Clipart + Mail merge (p.224, MLA) & Word Ch. 4 (compare/contrast APA & MLA footnotes, & credit card web sites (ask me)) |
|||
|
wk5 |
Due Mon. - Homework 4: Word Ch.3: #4-invoice, p.245-capstone; Ch.4: p.308-capstone Tuesday Test 2: Word |
Excel Ch. 1. For credit on any/every Excel exercise you must print a complete formula view, with row headings & gridlines, all on one page and print values all on one separate page. |
|||
|
wk6 |
Due Mon. - Homework 5: Excel Ch.1: p.365 #1-debit & p.376- capstone-band & p.377 Housing ofc. |
Excel Ch. 2 formulas & Functions |
|||
|
wk7 Nov 3 |
Due Mon. - Homework 6: Excel Ch.2: #2-retire , #4-expand payroll & p. 426-capstone |
Excel Ch. 3 Charts |
|||
|
wk8 |
Due Mon. - Homework 7: Excel Ch.3: p477#1-car, p478#2-Row vs. Col. P.480
#4-study analysis |
Excel
Ch. 4. Large worksheets & tables: sort, filter |
|||
|
wk9 |
Due Mon. -Homework 8: Excel Ch.4: p539 #4-pop. & p. 541-capstone Wednesday. Test 3: Excel |
|
|||
|
wk10 |
Due Mon. - Homework 9: Access Ch. 1: p.597-soccer, p. 601-capstone Holiday Thurs & Fri. |
Access Ch. 2 |
|||
|
wk11 |
Due Wed. Homework 10: Access Ch. 2: #1-Martha,
#2 Martha query, p.672 #3-create/use query |
Thurs. : PowerPoint Ch. 1 & 2 See web site for final exam date and time week 12 |
|||
GRADING:
Tests: 60% + Assignment, homework and quizzes ~40% (There will be no makeup quizzes.)
|
Score |
Grade |
Score |
Grade |
Score |
Grade |
Score |
Grade |
Score |
Grade |
|
95-100 |
4.0 |
88 |
3.3 |
81 |
2.6 |
74 |
1.9 |
67 |
1.2 |
|
94 |
3.9 |
87 |
3,2 |
80 |
2.5 |
73 |
1.8 |
66 |
1.1 |
|
93 |
3.8 |
86 |
3.1 |
79 |
2.4 |
72 |
1.7 |
65 |
1.0 |
|
92 |
3.7 |
85 |
3.0 |
78 |
2.3 |
71 |
1.6 |
64 |
.9 |
|
91 |
3.6 |
84 |
2.9 |
77 |
2.2 |
70 |
1.5 |
62-3 |
.8 |
|
90 |
3.5 |
83 |
2.8 |
76 |
2.1 |
69 |
1.4 |
60-1 |
.7 |
|
89 |
3.4 |
82 |
2.7 |
75 |
2.0 |
68 |
1.3 |
0-59 |
0.0 |
Late Work:
Any work received after the due date or time will be considered late. Late work will be subject to a discount at the rate of 25%. You will not be able to resubmit your assignments with corrections.
NOTE: the current version of Office has features that previous versions of Office do not have. Office XP and Office 2000 files save in a compatible format and should allow you to work interchangeably. Office 2003 and Office 2007 WILL NOT work interchangeably. Microsoft Works is not the same as Microsoft Office. If you are planning to do homework at home, your computer should be equipped with Windows and Office 2007 and adequate storage on a hard disk. A printer, Internet connection, and e-mail would also be helpful. If you have a computer and have Microsoft Office, check to see which version and parts of the Office suite you have since Microsoft offers many different bundles of Office. If you are a full-time student, academically priced software may be available through the bookstore, the UW computer store, or online vendors.
Because the CIS program pays for the MSDN Academic Alliance, CIS students may get a free copy of Microsoft Access to use for this class. Send an email message to me with your full name and class to request this at least 3 weeks before you will need to use Microsoft Access.
Demonstrate the ability to create documents with formats and styles that meet industry standards using word processing software.
Demonstrate the ability to use the Internet.
Demonstrate the ability to work with operating system tools.
Demonstrate the ability to work with spreadsheet software.
Demonstrate the ability to work with data stored in a relational database.
ACCOMMODATIONS:
If you require accommodations, please see me early in the quarter so that we can work together for your success. Students with disabilities who have accommodations needs are required to meet with Disabled Student Program staff (206-546-5832, Room 5229) to establish eligibility for accommodation. All such information is kept private. Examples of accommodations include extra time, using sign language interpreters or recording class sessions.
CHEATING:
Cheating is a serious offense and may result in a failing grade. ANY use of work of another or providing work to another with the intent to submit it as your own is considered cheating. If two assignments/tests look inappropriately similar, both assignments/tests will receive no credit (0 points). If you study with someone else on non-group homework or assignments, you must each complete your own work in its entirety; simply altering or adding names on individual assignments is considered cheating. If you are not sure, ask me before doing this.
Read the assigned text book sections before you come to class. Read the instructions on the Assignment sheet as well as the information in the text before completing the hands-on assignments. Do not rely on learning the software features simply by completing the hands-on exercises. Complete work for your class on a regular basis. You will need from five to 20 hours each week outside of class time on the computer and to complete the reading assignments.
Contact me if you have questions about an Assignment. It is your responsibility to do this. If you do not ask questions, I will not be able to provide you with the help you may need. Do not wait until the weekend before the Assignment is due to ask your questions; I usually do not check e-mail on the weekends.
WITHDRAWAL:
If you decide to withdraw, fill out a Schedule Change Form. Your instructor must sign it, and you must take it to the Registration Office by the date determined by the registrar. The W grade remains on the transcript but is not counted in the GPA computation. No Ws are possible after the date determined by the registrar.
The Z Grade is a Hardship Withdrawal. To receive this grade, submit a written statement that a crisis and/or unusual, extreme circumstance has occurred which has interfered or interrupted your ability to attend class and perform course work for the current quarter. This grade will not be considered in Shoreline Community College GPA calculations.
P/NC or P/0.0 STATUS:
P/NC or P/0.0 grading is an option, but application must be submitted by the date determined by the Registrar. The P grade at Shoreline means that the student has achieved a minimum of 2.0 or better for the quarter in this class. See your instructor if you are considering this option. The college catalog fully describes this option.
You can earn an NC grade in this class but you must apply in writing according the schedule determined by the Registrar. This grade may be earned only after consultation with your instructor and with instructor permission. This grade is not considered in the GPA calculation.
The Incomplete grade is used only rarely in cases of unusual circumstance when no additional instruction is needed and very few activities remain to be completed. This grade must be arranged in consultation with the instructor and only with instructor permission. Both the student and the instructor must sign an Incomplete Contract form. See the college catalog for a complete description of this option. The Incomplete Grade is not to be used just because you get behind.
If you are working in the computer labs on campus, there is no smoking, drinking, or eating in the labs. No children are allowed in the labs. Please, no beepers or cell phones. Duplication of material protected by U.S. Copyright Law is strictly forbidden.
Microsoft Office is available in the PC computer labs and the student open lab located in library. A schedule will be posted on the entrance door for each computer room listing open lab time. When a class is in session, the room is not an open lab. Check the Shoreline web site for hours http://www.shoreline.edu/help/ .
CLASSROOM GUIDELINES:
1. Listen during lectures and ask questions when in doubt . Do not work on the computer during this time unless the lecture includes such work. Do not print during lectures.
2. Attend all classes and take notes. Set up a buddy system in case you are absent. Please do not take up time during class to find out what you missed while you were gone.
3. Come on time and prepared with storage media, books, pen/pencil, paper, etc..
4. Turn off all cell phones and beepers. Be mindful of the ideas of others, as well as their time and property.
5. Always make more than one backup of your computer work.
6. Your work should be neat, clean, ordered, labeled, identified, proofread, and corrected when you submit it. Staple multiple pages in the upper left corner of the packet. Use your first name and your last name when you submit your work.
7. Please do not talk with your classmates or out loud with yourself during lectures or tests.
8. Please do not surf the web or use chat rooms during class.
9. Viewing or downloading pornographic or sexually offensive material is absolutely prohibited.
10. According to School policy or state law, no food, drink, smoking, or children are allowed in classrooms.
If the College is closed due to inclement weather or other extraordinary events, students should listen to KIRO, KING, or KOMO radio and television stations for broadcast of closures. You may also check the college web site at http://www.shoreline.edu/ . Or call 206-546-4101 on the main campus. Do not confuse SHORELINE COMMUNITY COLLEGE with the Shoreline School District. Students should follow the course schedule and be prepared for the next scheduled class. It is your responsibility to listen for such announcements. If the College should be closed for more than 5 days, I will determine which, if any, Assignments may be omitted. Check with me for any additional information. Please note that if the campus is closed, I will not be available.