West Los Angles College
Search
 
West LA College | WLAC Course Syllabi | Computer Science | CSIT 930 - Advanced Microsoft Office 2007 - Ken Buckner
WLAC Course Syllabi
CSIT 930 - Advanced Microsoft Office 2007 - Ken Buckner

Course Description

As a student in this course, you will learn the most important topics of Microsoft Office 2007. Some prior computer experience is assumed. You will first be presented with Microsoft Word, followed by an introduction to Microsoft Excel, Access and PowerPoint. You will learn to use Office to create and edit documents and flyers, as well as term papers, manage finances as well as to work with formulas, charts and graphics, and to develop a professional worksheet. You will then learn to work with multiple worksheets and workbooks. You will learn to use Office's editing and Web tools, and learn to develop Office applications. You will work with logical functions and integrate the various Office applications. You will use Microsoft Access 2007 to learn about data tables and scenario management, how to use Solver to help with problems, and how to import data. In short, we will go over almost every aspect of Microsoft Office 2007.

This is going to be an intensive, "doing" course. I will be more than willing to help you in any way I can.

Text and Materials

Text: Shelley Cashman Vermaat, Microsoft Office 2007 - Introductory Concepts and Techniques, Windows Vista Edition, Course Technology, 2008.

Software: Microsoft Office 2007.

Handouts: Additional handouts may be required. Instructor will provide information on obtaining this material.

Data Storage: 128MB (or larger) Flashdrive

Scantrons: 10-pack of 882-E

Teaching Methods

1. Classroom Lectures: Important material from the text and outside sources will be covered in class. Students should plan to take careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-procured outside material relevant to topics being covered.
2. Assignments: End of chapter activities and online activities will be assigned weekly to reinforce material in the text. These assignments may require the application of various software packages.
3. Quizzes: Occasional unannounced quizzes will be given to help ensure students stay up with assigned material.
4. Exams: Several exams will be given. The exams will be closed book/notes and will test assigned readings and material discussed in class. For these "official" exams I will give you a printout of the questions in advance and allow you to research the answers. Questions from that handout will be on the exams.
5. The final exam will be comprehensive in nature, representing everything we've covered during the semester. You will receive a printout of the questions ahead of time.
6. Participation: I expect student participation.
7. Attendance: I expect your attendance. This is college, not high school, and this is not a beginning class for noobs.

Grading and Course Policies

Grading:
Total points will be computed as follows. The total points for quizzes, cases, and assignments may vary. Grading will be based on the following percentages:
 A 90.0%
 B 80.0%
 C 70.0%
 D 60.0%
 F less than 60.0%

 Course Policies:
Missed Classes: Be here. If it’s an absolute emergency, call or email me.
Assignments: All assignments are due at the beginning of class on the date due. Late assignments results in “points off.”
Academic Dishonesty: Do your own work. If you don’t, by turning in work you didn’t do, you may fail the course, not just the assignment.
Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as I have outlined it, or which will require academic accommodations, please notify me as soon as possible.
Internet Support: Feel free to send me an email with a question about anything in this course. My email address is at the top of this syllabus.
Posting of Grades: I regularly post your grades on the classroom wall, with the running totals and the associated grades. The last 4 digits of your ID are used to identify you. If, for any reason, you don’t want your grades posted, please tell me and I’ll remove your listings.
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 a significant portion of the course.
 
FWIW:
Finally, after teaching various computer courses numerous times, let me mention several things.

1. This is the 16-week version of a Computer Science class, and as such, demands as much time and effort as any other class.  You are required to complete a certain amount of class work, and homework, as well as pass the tests and quizzes that will be given during the semester.
2. Plan to spend a minimum of 2 to 3 hours reading the required texts, and doing class assignments, for every hour spent in class.  This includes regular computer lab activities using the applications programs.
3. We’re here to have fun, but we can also learn something we can use. Being good at Office 2007 puts you ahead of the curve. Way ahead!
4. I run a classroom like I run my company, and you “work” for me.  Get the phone numbers of fellow classmates to create a network of “study buddies.”  Just like your contemporaries in the business world, you must count on them to help you when you miss something or fail to complete the assignments.  Their notes may save your grade.
5. I do not carry copies of homework assignments or tests after they are given in class.  You are responsible for the homework whether or not you’re in class.
6. Homework turned in late will be given “points off” for being late.
7. All assignments are worth various “points” towards your grade.  Everything counts, including any quizzes, homework and tests, with the point value declared at the time the assignment is given.  No “drop the lowest grade” considerations are given.
8. Occasionally, there will be assignments where “extra credit” points are given; however, late assignments do not receive any extra credit points.
9. This is college, not high school.  You wanted to be here, and your involvement and participation are reflected in your grade.  Suit up and show up and you shouldn’t have any problems.  Get behind, and you’re dead.
10. You are responsible for officially withdrawing from class. I don’t take the time to exclude you if you don’t care enough to exclude yourself. If your name is on the final roster and you haven’t been in class, you will not be excluded; you will be given an “F.” Deal with it.
11. It is in your interest to keep track of your grades and absences.  In the case of a grading error, you must have your original assignment or test to have the grade changed.
12. Children are not permitted in class.
13. Food and drinks are not allowed in the classrooms or computer labs.
14. Beepers and cell phones must be turned off in class and the lab.  If you must talk on the phone, please do it outside the class or lab.
15. In my class, I invite questions on anything to do with computers or the use of computers in the business world.  If I fail to explain anything properly, and there’s something you don’t understand, ASK QUESTIONS… Don’t be shy.
16. You are here to learn about computers, and I will do anything I can to accomplish that.

West LA College | WLAC Course Syllabi | Computer Science | CSIT 930 - Advanced Microsoft Office 2007 - Ken Buckner