http://www.texarkanacollege.edu/images/TCsm.gif

http://www.texarkanacollege.edu/images/ctis.gif

http://www.texarkanacollege.edu/images/hr.gif

 


Bob Forward
Professor, Computer Technology
Mgr, Mainframe Operations

(903) 832-5565 ext. 3344

email: bforward@texarkanacollege.edu

 

http://www.texarkanacollege.edu/images/hr.gif

 

BCIS 1305 -- Business Computer Applications

Instructor: Bob Forward

Office

Phone

Business & Computer Technology Building, Room 32

(903) 838-4541 Ext. 3344 (switchboard)

(903) 832-5565 x3344 (direct number)

E-mail

Internet Page

bforward@texarkanacollege.edu

www.texarkanacollege.edu/~bforward/

 

Required Textbooks from Thomson Course Technology:

·         Discovering Computers 2008, Brief Edition, by Shelly, Cashman, Vermaat

·         Microsoft Office 2007 – Introductory Concepts and Techniques, Windows XP edition,
by Shelly, Cashman, and Vermaat

·         SAM 2007 Student tutorial, with unused software key

Course Objective

To introduce the student to computer terminology, hardware, software, operating systems, and information systems relating to the business environment, and to give “hands on” experience with Microsoft Office 2007, Professional Version, business applications. Classroom instruction, class projects, and lab assignments will be combined for a comprehensive study. For transcript credit, students will be thoroughly tested on their ability to recall facts about computers and the use of application software.

Semester Grade, Attendance, & Withdrawal

 

Weight

From…

60%

Average of 10 tests

30%

Average of 18 Projects &
Lab Assignments

10%

Attendance & Participation

Final Average

Final Grade

90-100

A

80-89.99

B

70-79.99

C

60-69.99

D

Below 60

F

 

 

No incomplete grades will be given for failure to attend and participate. If you must quit, you should initiate an official withdrawal in the Admissions Office prior to the last date to drop courses. Punctual attendance and participation are required for successful completion of the course. You may be dropped from the class without notice after a total of two weeks of class absences. Only currently enrolled students are allowed to attend classes and labs. Any student who officially withdraws from the course before the drop date and before the instructor has dropped the student from the course will receive a grade of "W". The student is responsible for work missed because of illness, school business, or other circumstances.


Chapter Tests

You must take a test for each of six selected chapters in the text: Discovering Computers. Test questions for each chapter test will be taken directly from the pages of the text. The questions are written to test your knowledge of the terms, definitions, and concepts presented in the chapter. To study for a chapter test, re-read the chapter memorizing detailed facts. You may also take advantage of online materials, including practice tests from the author’s Web site. See instructions in the textbook for creating a CoursePort® account to receive access.

 

Chapter tests are administered by computer in the college’s Testing Center, located in the Business & Computer Technology Building, Room 11. The student must arrange to take each test before its deadline. Reservations for time and a computer terminal may be made in the Testing Center or by phone (903-832-5565 Ext.3278).

 

Each chapter test is 25 true-false/multiple-choice questions randomly selected from a large file of questions. You will have 30 minutes to complete a test. You may elect to take each test a second time. For second takes, you may receive different questions and the higher score of the first and second takes counts as the effective score for that test.

 

TO TAKE A TEST

You must arrive on time and present two forms of identification: your STUDENT ID CARD, and a PICTURE ID (driver license, employment id, etc.). You must know:

                        1.         The course key            T10712401305 __ __  ß enter your section number

                        2.         Your Student ID         __ __ __ __ __ __ __ __ __

                        3.         The test ID                  __ __ __ (Test ID = Chapter number)

 

TESTING CENTER HOURS

            Monday - Thursday                8:00am - 8:00pm (no tests started after 7:45pm.)

            Friday                                      8:00am - 4:00pm (no tests started after 3:45pm.)

The Testing Center is not open on weekends and not open on college holidays


 

Lab Tests

You must take a “hands-on” lab test for each of the four applications in the tutorial: Office 2007. Lab tests are administered in class using SAM® (Skills Assessment Management) software. These tests measure your ability to carry out the tasks you learned by doing projects and associated lab assignments. You may take each lab test only once. To study for a lab test, re-do the projects and lab assignments or practice any unassigned lab assignments. Specific dates will be announced for taking lab tests.

 

Test Checklist

Book

Test ID*

Study Source

Deadline

My Score

Discovering Computers
(small book)

1

Chapter 1 p. 4-37

1st Take by

Mid-term
(Week 8)

 

2

Chapter 2, p. 68-101

 

4

Chapter 4, p.184-217

 

5

Chapter 5, p.234-267

 

6

Chapter 6, p.300-327

 

7

Chapter 7, p.354-381

 

Office 2007
(large book)

SAM
Word
test

Word Chapter 1, p.2-62

Word Chapter 2, p.74-132

Word Chapter 3, p.146-204

Week 7-8

 

SAM
Excel
test

Excel Chapter 1, p.2-69

Excel Chapter 2, p.82-144

Week 10-11

 

SAM
Access
test

Access Chapter 1, p.2-63

Access Chapter 2, p.74-127

Week 13

 

SAM
PowerPoint
test

PowerPoint Chapter 1, p.2-65

PowerPoint Chapter 2, p.82-131

Week 15

 

*Enter this Test ID when taking a chapter test in the Testing Center

**All 2nd takes for chapter tests must be completed in the Testing Center by the last day of the semester.

 


 Tentative Course Outline

Week

Activity

1

Introduction, Syllabus, Testing Center Demo

Chapter 1, 2

2

Chapter 4

Chapter 5

3

Chapter 6, 7

Logins, passwords

Word project 1

4

Word project 2

Word Lab 1-2, 2-2

5

Word project 3, Lab 2-2, 3-2

Register for SAM

6

SAM Word practice test

 

7

SAM Word test

 

8

Excel project 1, Lab 1-2

Excel project 2

9

Excel Lab 2-2

SAM Excel practice test

10

SAM Excel test

 

11

Access project 1, Lab 1-1

Access Project 2

12

Access Lab 2-1

SAM Access practice test

13

SAM Access and PowerPoint practice tests

 

14

PowerPoint Project 1, Lab 1-1

SAM practice test

15

PowerPoint Project 2

SAM PowerPoint test

16

Complete Chapter tests in Testing Center by Dec 14

 

Additional Texarkana College Policies

Students are not allowed to bring food or drinks into the classroom, lab, or the Testing Center. The cost of damage to computer equipment, carpet, and furniture can be significant due to a minor mishap. Also, students must disable any cell phone, pager, or other wireless communication device upon entering the classroom, lab, or the Testing Center. Exceptions must be cleared with written approval from the Dean of Students.

 

Academic Honesty

All assignments must represent the student’s own work. A student may discuss assignments with others to gain a better understanding of the problem. However, copying projects or assignments, whole or in part, from ANY source, without explicit instructor direction, is considered plagiarism and can result in a grade of zero for that assignment, a failing grade for the course, or college disciplinary action as outlined in the Student Handbook section: ACADEMIC DISHONESTY. Students are required to originate, complete, and maintain their project and lab assignment documents in disk folders assigned to them using Texarkana College computer equipment.

 

Projects from “Office 2007”

Project/Lab Assignment

Page Numbers


# docs


Output

WORD Project 1

WD 2 – 62

1

Learn to Ride announcement

WORD Lab 1-2
(In the Lab #2)

WD 69 – 70

1

Blooming Deals announcement

WORD Project 2

WD 74 – 132

3

“Wireless Communications” paper
by Alex Pappas

WORD Lab 2-2
(In the Lab #2)

WD 140 – 141

3

“Antivirus Programs” paper
by Pahdi Yadav

WORD Project 3

WD 146 – 204

2

Canaan Cover letter & Resume

WORD Lab 3-2
(In the Lab #2)

WD 210 – 211

1

Constance Leah Marsh Resume

EXCEL Project 1

EX 2 – 69

1

“Walk and Rock Music, First Quarter Rock-It MP3 Sales” worksheet & chart

EXCEL Lab 1-2
(In the Lab #2)

EX 75 – 77

2

Scissors Office Supply original and revised worksheets, with chart

EXCEL Project 2

EX 82 – 143

3

Silver Dollars Stock Club Portfolio Summary worksheet, selected print area, formulas version

EXCEL Lab 2-2
(In the Lab #2)

EX 151 – 153

3