CS 114, Microcomputer Applications

Instructor:

Linda Shoesmith

Text:

Microsoft Office 2003: Introductory Concepts and Techniques

Credit Hours:

3

Office:

2405

Office Hours:

9:15 – 10:25 MW; 7:15 – 7:45 MWF; 9:50 – 10:25 T Th;

E-mail:

Lshoesmith@eicc.edu

Web Site:

http://faculty.eicc.edu/lshoesmith

Phone:

441-4029

Additional Material:

Three blank IBM formatted 3 ½ “ diskettes, CD-rw, or USB flash drive

PRIVATECourse Description: This course is an introduction to micro computing using the Windows operating system.  It includes instruction and graded exercises in word processing, spreadsheets, database, and graphical presentation applications, using the Microsoft Office integrated software package.  Since this course is designed primarily to develop basic computer skills, the majority of class time will be spent working on in lab computer exercises.

Homework Assignments: Assignments and due dates are outlined on the attached schedule.  Make sure your name and Project Number/Exercise Number appear at the top right hand corner of the paper.  Please staple the pages together.  Do not staple different assignments together.  Disorganized assignments (pages out of order, mislabeled, unreadable, etc.) will be handed back with a grade of zero.  If there are multiple sheets to be handed in, sequence them in the order you were told to print them in the exercise.

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 and homework.  A student may not use or copy (by any means) another’s work (or portions of it) and represent it as his/her own.  Each student must have his/her own copy of the computer file(s) and printout(s) for each assignment.  Be prepared to show your computer file(s) to the instructor upon request.  Projects are worth 20 points each and the end of project exercises are worth 10 points each.

Late Assignments:  Late assignments will be accepted for up to one week with a 30 % penalty.  No assignments will be accepted more than one week late.

Interactive Laboratory Assignments: Interactive laboratory assignments are outlined in the class schedule.  These labs are excellent tutorials and take 10 to 15 minutes to complete.  These are for supplemental instruction and are not graded.

Project Exams: Each student will complete four graded computer laboratory exercises done in the lab using Word, PowerPoint, Excel, and Access.  These exams are each worth 50 points and will be similar to the class projects.  The requirements for these projects will be discussed during class.  You may use your book, notes, or printouts.  You may not use any other computer files, either on a floppy disk, or on the hard drive.  The exams have a two-hour limit and must be completed in the one class session, so plan accordingly.  Missed exams must be made up within one week of the class exam date and will have a 30 % late penalty deduction.  Exams may be taken early to avoid penalty.

Final Exam: The final exam is worth 100 points.

Extenuating circumstances will be handled on a case-by-case basis.

Bonus PowerPoint Project: Students may earn up to 20 bonus points by developing and presenting a four to five minute PowerPoint presentation covering a topic of their choice.

Diskette Check: The instructor reserves the right to check student’s diskettes at any time, to be sure that the assignments turned in for credit are the work of the student.

Attendance: Attendance will be taken.  Good attendance is important for success in this class.  If you are absent, it is your responsibility to obtain class notes/assignments from another classmate.  Notify your instructor by phone or e-mail if an absence is necessary.

Free Tutoring: If you find yourself having problems with any of the material, please contact me promptly. You can also get help from the tutors in Student Success Center (Rooms 2101 & 2017). There is no cost for this tutoring.

SCC Academic Honesty Policy: Submission of another person’s work is a violation of the SCC Academic Honesty Policy. Students who are suspected of violating this policy will be referred to the dean for appropriate action.  This may cause you to fail the course. See the student handbook for more information.

Point

Value

Total

Points

A

93 and

   up

C +

79 – 77

D -

62 – 60

Projects (10)

  20

 200

A -

92 – 90

C

76 – 73

F

Below 60

Homework Assignments (19)   

  10

 180

B +

89 – 87

C -

72 – 70

Project Exams (4)

  50

 200

B

86 – 83

D +

69 - 67

Final Exam

 100

 100

B -

82 – 80

D

66 - 63

Total

 680

Day

Project/Exercise

Points

Points Received

Aug 25

Interactive Labs and Web tutorials as needed.

     (* See list below)

Copy files to your floppies.  Bring 3 empty diskettes to class.

Read:  COM 1 – 38 and WIN 3 – 82

Read:  (App A) App 1 – 9 and OUT 4 – 58

World Wide Web: Outlook in the Classroom  Units 1 thru 5  http://www.actden.com/oe/index.htm  (optional)

Opt.

Aug 30

Sept 1

Word Project 1 WD 3 – 62

WD 65 Apply Your Knowledge # 1

WD 70 In the Lab # 3

WD 71 Cases and Places # 3 (Use bullets)

20

10

10

10

Sept 6/8

Word Project 2 WD 73 – 126 (print document; read, but do not email document)  WD 132 In the Lab # 2, (Part 1 instructions, only)

20

10

Sept 13/15

Word Project 3 WD 137 – 195 (Don’t print WD149 or envelope – WD 191)

  WD 198 Apply Your Knowledge # 1

20

10

Sept 20

Word Project Exam

Word Web Feature, WD 203 – 215      (10 points extra credit – due Sept 22)

50

(10)

Sept 22/27

Excel Project 1 EX 3 – 55

EX 57 Apply Your Knowledge # 1

EX 58 In The Lab # 1 (Instructions 1 – 9 only)

(Interactive Lab: Spreadsheets)

20

10

10

Opt.

Sept 29

Oct 4

Excel Project 2 EX 65 – 127 (Do not email document.) EX 76, step 3 shall

     read I 4 not “14.”

EX 130 – 131 Apply Your Knowledge # 1, (Part 1 only)

EX 132 – 133 In The Lab # 1, (Part 1 only)

20

10

10

Oct 6/11

Excel Project 3 EX 145 – 208

20

Oct 13

Excel Project Exam

(Interactive Lab – Designing a Database)

50

Opt.

Oct 18/20/25

Access Project 1 AC 3 – 52

AC 54 – 55 Apply Your Knowledge # 1

AC 56 – 58 In The Lab # 1

20

10

10

Oct 27

Nov 1/3

Access Project 2 AC 65 – 106

AC 109 Apply Your Knowledge # 1, Note the following:

   # 2, use *Fletcher.

   # 4, see AC 79-80

   Omit duplicates see AC 87

   # 5, see AC 89-90

   # 6, see AC 90-93

   # 8 Skip

AC 109 – 110 In The Lab # 1, Note the following:

   # 3, use *bird*

   # 8, to change caption see AC 98-99; to restrict retrieval, AC 89-90

   # 11, In new field type  OnHandValue:[On Hand]*[Cost]

20

10

10

Nov 8

Access Project Exam

World Wide Web: PowerPoint in the classroom  Units 1 – 8  http://www.actden.com/pp/index.htm

50

Opt.

Nov 15/17

PowerPoint Project 1 PPT 3 – 65 (Print in Handout View – 6 slides to a page)

     Be sure to use bullet command

PPT 72 – 73 In The Lab # 2

PPT 74 – 75 In The Lab # 3 (Instructions for part 1 only.)

PPT 78 Cases and Places # 1

20

10

10

10

Nov 22/29

PowerPoint Project 2 PPT 81 – 128 (Print as a handout – 6 slides to a page)

PP 131 – 132 Apply Your Knowledge # 1

PP 136 – 137 In The Lab # 3 (Instructions 1 – 9, only.  Do not email.)

20

10

10

Dec 1

PowerPoint Presentations (20 Extra Credit Points)

PowerPoint Web Feature, PPT 141 – 157

      (10 Points extra credit – due Dec 8)

(20)

(10)

Dec 6

PowerPoint Project Exam

50

Dec 8

Final Exam

100

Dec 13

Wrap up – Continue PowerPoint Presentations