Computer Fundamentals for Technicians

Fall 2008

 

Course Number

 

BCA188

Credit Hours

3

Section Number

 

 48932    48932

Instructor

Darrell Hanan

E-mail

 

dhanan@eicc.edu

Phone

441-4228

Office Hours

 

3:00pm-4:00pm

Office

3116BB

Class Days

 

TTh

Class Times

8:10am-10:40am

Room

1107

Website

http://faculty.eicc.edu/dhanan/

 

 

Click here to go to lesson schedule.

Text

Microsoft Office 2007; Illustrated Series, Windows XP Edition, Introductory. – Beskeen,Cram,Duffy,Friedrichsen,Reding

 

Supplies

USB Flash drive, lined paper, writing utensil

 

Course Description

This course will cover microcomputer operating systems, hardware and application software. Spreadsheets, database management, word processing and 2-D graphics packages will be specific areas of coverage. Lab exercises will follow lecture and class discussion.

 

 

Prerequisites

None

 

Attendance/Participation

Students are expected to attend all class sessions. Students are expected to stay in class until dismissed by the instructor. Students who have completed and turned in all of the assignments for the week may ask for permission to leave early. Students are not expected to be surfing the web or doing other activities on the computers that are not directly related to course assignments during class time. Such activities will result in the student being removed from the PC lab!

 

 

Evaluation

Final grade will be based on six areas:

 

Final Project (25%):

Your Final Project will be a PowerPoint presentation about a personal hobby, object or activity. The presentation must be at least FIVE slides long. The project must include text, photos, and animated text or objects and slide transitions. Extra credit will be earned if a chart is included and/or it is converted to a web format.  Final Project is due Thursday, December 11th at 10:00am and will not be accepted late!

 

Project Assignments (30%): Each student will be required to complete the Projects assigned for Word, Excel, Access and PowerPoint units, as well as, an Integrated Project. The projects are laid out step-by-step in the textbook. Students are expected to complete the projects as individuals, not in groups.

Students are encouraged to assist and learn from each other.

 

Employee Characteristics (10%): Students will receive a weekly grade based on their demonstration of basic employee characteristics expected by employers. These include Dependability, Punctuality, Teamwork, Communication, and Participation. The instructor will rate each characteristic weekly on a scale of 0 to 4:          

0 - Unacceptable

                                    2 - Consistently meets minimum requirements

                                    3 - Occasionally exceeds minimum requirements 

4 - Consistently exceeds minimum requirements

 

Prerequisite Assignments (10%): Prerequisite assignments are prerequisites to quizzes. Prerequisite assignments are located in the textbook support website found the Learn It Online sections. The course schedule (below) has the web link and assignment details. Each unit’s prerequisite assignments must be completed before the unit quiz is taken.

 

Quizzes (15%): Quizzes will be printed from the textbook support website found in the Learn It Online sections. The course schedule (below) has the web link and quiz details. The quizzes will be completed as the student progresses through the unit assignments. Quizzes cannot be completed before the prerequisite assignments are completed and turned in. Quizzes must be completed within one class period of the completion of the prerequisite assignments. Quizzes will not be accepted late.

 

Final Test (10%): A comprehensive written Final Exam will be given. All students are expected to take it.

 

 

Final Grading Scale:            A …90 - 100%

B….80 - 89%

C… 70 - 79%

D….60 - 69%

F….59% or below          

Make-up policy
See Above

 

Late Assignment Policy

See Above

 

Assessment

See Above

 

Cell phone policy

See Below

 

The following are non-negotiable expectations of

classroom and lab conduct.

 

  • Class members will attend class on time. The instructor reserves the right to refuse admittance to anyone who arrives late for class! (Ten minutes grace for students and instructor on rare occasions.)
  • Class members will refrain from negative comments about others in the class.
  • Class members will refrain from disrupting the learning of others by theirs words and behavior.
  • Class members will adhere to all safety policies.
  • Cell phones will not ring or be used for conversation during classroom or lab sessions.
  • Class members will refrain from using tobacco products during classroom or lab sessions.
  • Class members will refrain from sleeping in class. Sleep at home, be alert in class!
  • Class members will endeavor to conduct themselves in a professional manner.

 

POLICIES ON ACADEMIC DISHONESTY CAN BE FOUND IN THE EICCD STUDENT CODE OF CONDUCT PUBLISHED IN THE STUDENT HANDBOOK.

 

 

Benefits of taking this class

Students who successfully complete this course will have increased their skills in using the basic Microsoft Office suite applications.

 

Study Tips

To be successful students must complete the assignments in a timely and thorough manner.

Semester Schedule

 

Event

Date

Start date

8/25/08

Midterm

10/17/08

Advising Day

11/11/08

Staff Development Day

9/26/08

College Closed

11/27 & 28/08

Last date to drop with “W”

12/5/08

End date

12/15/08

 

Academic Accommodation

Anyone who feels they may need an academic accommodation based on the impact of a documented disability should contact Jan Weis at the Belmont campus 441-4027 to arrange an appointment as soon as possible. At the appointment, course format, individual needs, and potential accommodations will be discussed. This service is FREE and confidential

 

Class Cancellation

Students may go to the web site at http://www.eicc.edu/students  to check if class has been cancelled. Once there, click on academics and again on class cancellations. You may also call the college at 563-441-4001.

 

Course Schedule

Computer Fundamentals fro Technicians

Assignment Schedule

Week

Reading Assignment

Laboratory Assignment

1

 

Understanding Computer Concepts

 

Concepts 1 thru Concepts 25

 

Concepts Review #'s 1 thru 26 on Concepts 26-27.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

Learn It Online exercises;

  1. 30 Flash Cards
  2. Who Wants to be a Computer Genius
  3. Practice Test

 

 

 

Website: http://oc.course.com/sc/off2007/index.cfm?action=learn&product=Introduction%20to%20Computers%20Seventh%20Editioncom/ic6/learn

 

Take the PC Concepts Quiz!

 

2

 

Getting Started with Windows XP

 

Windows 1 thru Windows19

 

 

Concepts Review #'s 1 thru 28 on Windows 20-21

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

 

PC Exercises:

A. Windows 10

        Print after step 8 on page 10.

B.  Windows 16

        Print after step 8 on page 16.

 

3

 

 

 

 

Understanding File Management

 

Windows 25 thru Windows 45

 

 

 

PC Exercises:

A. Download the Student Data Files needed for this course from

     the web to your flash drive. Click on the link below.

     Follow the instructions on the inside back cover of your book

     beginning with step 4.

                   Student Data file web page link

 

Note: Whenever the text refers to UDISK 2.0 it is referring

             to your flash drive!

 

B.  Windows 28-30

        Print after step 5 on page 30.

C.  Windows 38

        Show the instructor your screen after step 8.

D.  Windows 42-44

        Print after step 5 on page 44.      

 

Learn It Online exercises;

  1. 30 Flash Cards
  2. Who Wants to be a Computer Genius
  3. Practice Test

 

 

 

Website:

http://oc.course.com/sc/off2007/index.cfm?action=learn&product=windowsxp

 

Take the Windows Quiz!

 

4

 

Word 2007

 

PC Exercises:

A. Word 6-16

        Print after the following steps:

        Step 8 on page 10 after saving the document.

        Step 10 page 12.

        Step 10 page 14.

 

Complete the Concepts Review #'s 1 thru 20 on Word 18-19.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

 

 

5

 

Word 2007

 

 

 

PC Exercises:

A. Hyperlink exercise with instructor.

 

B. Word 26-34

        Print after the following steps:

        Step 6 on page 28 after saving the document.

        Step 8 page 34. 

 

C. Word 50-66

        Print after the following steps:

        Step 9 on page 52 after saving the document.

        Step 9 page 66. 

 

    

If you have a current resume’ and/or cover letter, bring it to the next class meeting on your flash drive!!

 

6

 

Word 2007

 

 

PC Exercises:

Update your current resume using a different style from the  Resume template.  You may cut and paste information that is still current from an existing resume.

 

Click on the Microsoft Office Button, then select New, scroll down on the left side and select Resumes and CVs. Select a resume template to use.

 

Enter or Cut & Paste your info into the template.  

Run Spell Check and Print the new resume.

Refer to Word 26-35 for instructions.

 

Complete the Concepts Review #'s 1 thru 20 on Word 42-43.

 

Use the answer sheet document provided at this link.

5.    Open the link.

6.    Save the document to your flash drive using the assignment name as the document name.

7.    Complete the Review.

8.    Take the Flash drive to the instructor.

 

 

 

Take the Word Quiz!

 

7

 

 

Excel 2007

Excel 1-17, 23-41

 

PC Exercises:

A. Excel 1-17

        Print after the following steps:

        Step 8 on page 10 after saving the document.

        Step 8 page 16.

    

B.

Excel 23-41

        Print after the following steps:

        Step 8 on page 32 after saving the document.

        Step 7 page 40.

 

Complete the Concepts Review #'s 1 thru 17 on Excel 42-43.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

 

8

 

Excel 2007

Excel 51-69

 

 

PC Exercises:

A. Excel 1-17

        Print after the following steps:

        Step 8 on page 58 after saving the document.

        Step 7 page 68.

 

Learn It Online exercises;

  1. Practice Test  Chapter 1

 

   

Website:

http://oc.course.com/sc/off2007/index.cfm?action=learn&product=excel

 

    

Complete the Concepts Review #'s 1 thru 20 on Excel 70-71.

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

Take the Excel Quiz!

 

9

 

Excel 2007

   Creating a costumer ticket

 

 

Repair Report

 

 

Shop Ticket

 

 

Using the Shop Ticket sample and the repair report blank for ideas, create a spreadsheet that can be used as a Repair Bill to charge costumers for repair work or to calculate repair estimates.

 

Create a sketch and have it approved by the instructor before beginning on the PC.

 

10

 

 

Access 2007

 

PC Exercises:

A. Access 1-19

        Print after the following steps:

        Step 6 on page 8 after saving the document.

        Step 5 page 18.

    

B. Access 27-43

        Print after the following steps:

        Step 7 on page 32 after saving the document.

        Step 7 page 38.

        Step 7 page 42.

 

 

 

 

11

 

Access 2007

Free Lance Project:

Creating a Personal Tool Database

 

 

Create a database that can be used to inventory all of your tools. Include at least; name of tool, replacement cost, type of tool, vendor and storage place in the database. After the database is created list at least 40 of your current tools in the database. Print the database on ONE page.

 

Create a sketch and have it approved by the instructor

before beginning on the PC.

 

Run two queries, an AND Query & an OR Query, on the data

base and print the results.

See Access 28-41 for hints.

 

 

Learn It Online exercises;

Chapter 1

  1. 30 Flash Cards
  2. Practice Test

 

Website:

http://oc.course.com/sc/off2007/index.cfm?action=learn&product=access

 

Complete the Concepts Review #'s 1 thru 20 on Access 20-21.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

Complete the Concepts Review #'s 1 thru 20 on Access 44-45.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

Take the Access Quiz!

 

12

 

 

PowerPoint 2007

 

PC Exercises:

A. PowerPoint 1-17

        Follow steps 1 thru 6 on page 16 to print slide 2.

        After printing slide 2, print both slides with the

        "Handouts" feature, then close the program.

            

B. PowerPoint 49-61

        Print as Handouts after the following steps:

        Step 8 on page 52 after saving the document.

        Step 9 page 56.

        Step 8 page 60.

 

 

13

 

 

 

PowerPoint 2007

 

A. PowerPoint 73-87

        Save the Presentation to your flash drive and take it

         to the instructor for viewing.

 

Learn It Online exercises;

Chapter 1

  1. 30 Flash Cards
  2. Practice Test

 

 

Website:

http://oc.course.com/sc/off2007/index.cfm?action=learn&product=powerpoint

 

Complete the Concepts Review #'s 1 thru 21 on PowerPoint 18-19.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

Complete the Concepts Review #'s 1 thru 22 on PowerPoint 42-43.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

Complete the Concepts Review #'s 1 thru 22 on PowerPoint 66-67.

 

Use the answer sheet document provided at this link.

1.    Open the link.

2.    Save the document to your flash drive using the assignment name as the document name.

3.    Complete the Review.

4.    Take the Flash drive to the instructor.

 

 

Take the PowerPoint Quiz!

 

14

 

 Final Project

 

Your Final Project will be a PowerPoint presentation about a personal hobby, object or activity.

 

The presentation must be at least FIVE slides long.

 

The project must include text, photos, animated text or objects and slide transitions.

 

Extra credit will be earned if a chart is included and/or it is converted to a web format.

 

15

Final Exam

 

Final Project completion

 

Final Exam will be given at 8:10am

Thursday, December 11th.

 

Time will be given afterwards to complete the Final Project.

 

 

Final Project is due Thursday, December 11th at 10:00am and will not be accepted late!