COSC1371                                             Course Syllabus                                          Fall 2012

 

   Required textbook:

   Microsoft Office 2010: A Skills Approach, by Cherri Manning and Catherine Manning

   Swinson, McGraw Hill Publishing, 2012

 

  References:

1.       Office 2010, Volumn 1. Second edition, by Robert T. Grauer and et al,  Pearson Education Inc., 2013.   

2.       Skills for Success with MS Internet Explorer 9, Kris Townsend, Pearson Education, Inc., 2012

 

  Instructor: Dr. Hikyoo Koh

                          Professor of CS

    Office:   MA68

    Phone:   880-8779 (Cell: 808-255-4901)

    E-Mail:     Blackboard Mail Tool

    HTTP:       galaxy.cs.lamar.edu/~hkoh/#COSC1371

    Office Hours:          

                    MW:           14:50 --- 15:50

                    TTH:          11:00 --- 12:00

                    Sat:             11:00 --- 14:00 (About every other Saturday, with appointments

                                                          preferred)

                   

  Learning Objectives:

 

  By completing this course, students will

  1. attain a good working knowledge of computer systems, their hardware components

     and software components,

  2. attain proficiency in the application of Microsoft Office including Word,

     Excel, Access and Powerpoint, and

  3. be able to build a simple personal webpage.

 

  Topics to Cover:

                    Brief History of Computers

                    Computer Systems

                      Hardware, Software, Operating Systems

                    Microsoft WINDOWS 7

                    Office Fundamentals

                    Internet Browsers

                    Word Processing-I

                      TEST-1

                    Word Processing-II   

                    Spreadsheets (EXCEL)                 

                    WebPage Building                                             

                      TEST-2

                    Database (ACCESS)                                           

                    Powerpoint Presentation                                  

                      TEST-3

        Final Exam. (Comprehensive to cover all course contents)

                    Some major Projects include:     

                    1. Microsoft Office Interface Interaction and Help Information

                    2. Web Search and Use of Scientfic Calculator

                    3. Four Word projects for Formatting, Table creation and sorting, and Document

                       enhancements by inserting various objects such as Clip Arts and Shapes and

                       a Webpage building.

                    4. Three Excel projects for Net Income optimization, Mortgage Payment table

                       construction and Insertions of various Charts.

                    5. Two Access projects for Table and Filter creation, Report and Query creation

                       and establishment of one-to-many relationships among tables.

                    6. Two Powerpoint presentation projects for slide show presentation and

                       Presentation enhancements including transition effects and animation

 

  Class Plan:

 

  Except for the beginning introductions, you will primarily read relevant sections

  of our Textbook in order to complete about 13 project assignments mostly taken from

  Projects Sections (Skill Reviews) of our Textbook.

  Needless to say, our Textbook is the main source of your learning and completing

  assigned projects is the main activities of your learning. You are expected to

  have an access to the Blackboard Learn System maintained by the University Center

  for Distance Education as all tests (three tests and the Final Exam)

  and assigned projects will be performed and submitted only through the Blackboard. 

 

  GRADING POLICY:

                    3 TESTS -------------------     300

                    FINAL EXAM ----------------     200

                    13 projects ---------------     260

                    -----------------------------------

                    TOTAL                           760

                    -----------------------------------

 

                    Your final grade will be determined by your class average as follows:

 

                                         88% - 100%:                A

                                         78% -  87%:                 B

                                         68% -  77%:                 C

                                         58% -  67%:                 D

                                         Else:                               F

                                         -----------------                 

                                         Your class average is computed simply by dividing total points you

                                         actually earned (by the end of the semester) by the maximum total points

                                         which at the moment stands at 760.

                                         Of course this maximum total is subject to change.

                                         For example, if you get only 12 projects instead of 13 currently planned,

                                         the maximum total will be 740 instead of 760.

  Students with Disabilities:

 

  This course complies with university policies on disability, accommodations and

  academic honesty as published in the Student Handbook and also in the Computer

  Science Department Policy (on Academic Honesty).

 

  Online Course Evaluations. 

 

  Lamar University encourages students to evaluate online the courses they take

  and the instruction they receive via a contract with a national company,

  OnlineCourseEvaluations.com. 

  The evaluation instruments themselves were developed by LU faculty and

  administrators. 

  Evaluation windows for fall and spring courses open two weeks before the final

  examination period and close at the end of the last class day. 

  The student is notified of the specific dates at his/her myLAMAR e-mail address. 

  If course evaluations are given during summers, mini semesters, and other

  compressed terms, evaluation windows are extended past the last class meeting. 

  Evaluations are completely anonymous, and neither LU faculty nor LU administrators

  have the ability to determine the name of the student who completed a specific

  evaluation form. 

  The primary purpose of course evaluation is the improvement of instruction. 

  That is, after the semester has ended and grades have been awarded, I am able to access

  the results of my course evaluations, to include all student comments. 

  I analyze the data and read the comments, and often use student observations and

  suggestions to make changes in course content and delivery. 

  The results of course evaluations are also used by chairs and deans as one factor

  in decisions involving merit pay, tenure, and promotion. 

  Both the administration and I take your input via course evaluations very seriously,

  and I encourage you to participate in this process. 

  Any questions or comments you have about the process should be addressed to

  Dr. Tom Matthews, University Assessment Coordinator, at 409-880-2385 or

  tom.matthews@lamar.edu.  Thank you.

 

  Honesty Policy:

                    1. Anyone caught copying or otherwise cheating on a test or a project

                       will get a zero on that test or project.

                       Anyone caught copying or otherwise cheating on more than one

                       occasion will get an F in the course.

                    2. Missed test will not be made up.

                       If you miss no more than one test and if you show a written document for

                       missing a test, the instructor will count the worst test score you get twice.