Business Computer Applications Syllabus for 2011-2012
Return to Syllabus List

Instructor Information

Instructor

(Curriculum Vitae)

E-Mail

jrpickle@actx.edu

Phone

Office Location

Office Hours

Contact me via e-mail.

Course Information

Recording Policy

Disability Statement

Any student who, because of a disabling condition, may require some special arrangements in order to meet course requirements should contact disAbility Services (Student Service Center room 119, phone 371-5436) as soon as possible.

Statement for Mental Health and Advocacy & Resource Center:

As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student's ability to participate in daily activities. Amarillo College offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus by calling the AC Counseling Center at 806-371-5900. The AC Counseling Center website is https://www.actx.edu/counseling/ . Also, if you are in need of social services (affordable housing, utilities, transportation, food, clothing, childcare, medical/dental/vision, legal), please call the AC Advocacy & Resource Center at 806-371-5439. The AC Advocacy & Resource Center website is https://www.actx.edu/arc

Amarillo College Tutoring for Success Policy:

Administrative Drop Policy

N/A

Student Withdrawal Procedures

N/A

Privacy Statement

The Amarillo College Privacy Policy is found at https://www.actx.edu/-amarillo-college-privacy-notice , and applies to all Amarillo College students. If you have questions about this privacy statement or you believe that your personal information has been released without your consent, send email to humanresources@actx.edu .

Course

BCIS-1305-064 Business Computer Applications

Prerequisites

RDNG 0321-minimum grade of C or a score on a state-approved test indicating readiness for RDNG 0331

Course Description

In-depth study of computer hardware, software, operating systems and information systems pertaining to a business environment. The main focus of this course is to understand and use various business software applications including word processing, spreadsheets, databases, presentation graphics and other miscellaneous business applications.

Student Resources Student Resources Website

Department Expectations

Occupational License Disclaimer

Hours

(3 sem hrs; 2 lec, 3 lab)

Class Type

Dual Credit Course

Syllabus Information

Textbooks

Technology in Action, 5th edition by Alan Evans, Kendall Martin, Mary Anne Poatsy.

ISBN-13: 9780135137208

Exploring Microsoft Office 2007, Volume 1, Third Edition by Robert Grauer, Michelle Hulett, Cynthia Krebs, Maurie Wigman Lockley, Keith Mulbery, Judy Sheeren

ISBN-13: 978-0-13-506250-0 http://www.coursesmart.com/9780137003525?__instructor=1951024

NOTE: The MyITLab code is good for one (1) calendar year. If you take BCIS 1401, you do not need to purchase a new code. Your BCIS 1305 code will work.

Supplies

\ Access to a PC (personal computer )
\ Office 2007
\ Reliable access to the Internet.
\ A working email address
\ Storage media

Student Performance

\ After studying the material presented in this course of study, demonstrate understanding of the following as evaluated by the faculty in the department/program.

\ Describe the major classes of software available in the marketplace.
\ Describe the types and categories of application and system software.
\ Describe several uses of telecommunications technology.
\ Name various types of communications media and how they carry messages.
\ Describe local and wide area networks.
\ Discuss how the Internet has evolved.
\ Identify the resources of the Internet and the variety of tools available for working on the Internet.
\ Define the many evolving opportunities available in Web publishing.
\ Describe what word processing, spreadsheets, and databases do, and how they work.
\ Identify the operations that one must master to use word-processing, spreadsheet, and database program software effectively.
\ Explain what a system is and how to develop a system for an organization. Identify and describe the activities involved in applications software development.
\ Explain how to go about selecting a microcomputer system for home or office use.

\ After completing Word, the student will be able to:

\ Understand Word basics
\ Use AutoText View a document
\ Use the Mini toolbar
\ Set margins and specify page orientation
\ Insert page breaks
\ Add page numbers
\ Insert headers and footers
\ Create sections Insert a cover page
\ Use the Find and Replace commands
\ Check spelling and grammar
\ Use save and backup options
\ Select printing options
\ Customize Word
\ Apply font attributes through the Font dialog box
\ Highlight text
\ Control word-wrapping with nonbreaking hyphens and nonbreaking spaces
\ Copy formats with the Format Painter
\ Set off paragraphs with tabs, borders, lists, and columns
\ Apply paragraph formats
\ Create and modify styles
\ Create atable of contents
\ Create an index
\ Insert atable
\ Format atable
\ Sort and apply formulas totable data
\ Convert text to atable
\ Insert clip art and images into a document
\ Format a graphic element
\ Insert WordArt into a document
\ Insert symbols into a document

\ After completing Excel the student will be able to:

\ Define worksheets and workbooks
\ Use spreadsheets across disciplines
\ Plan for good workbook and worksheet design
\ Identify Excel window components
\ Enter and edit data in cells
\ Describe and use symbols and the order of precedence
\ Display cell formulas Insert and delete rows and columns
\ Use cell ranges;
\ Excel move; copy, paste, paste special; and AutoFill
\ Manage worksheets
\ Format worksheets
\ Select page setup options for printing
\ Create and copy formulas
\ Use relative and absolute cell addresses
\ Use AutoSum
\ Insert basic statistical functions
\ Use date functions
\ Use the IF function
\ Use the VLOOKUP function
\ Use the PMT function
\ Use the FV function (page 49).
\ Manage cell comments
\ Create and copy formulas
\ Use relative and absolute cell addresses
\ Use AutoSum
\ Insert basic statistical functions
\ Use date functions
\ Use the IF function
\ Use the VLOOKUP function
\ Use the PMT function

\ After completing the Access the student will be able to:

\ Use the FV function
\ Explore, describe, and navigate among the objects in an Access database
\ Understand the difference between working in storage and memory
\ Practice good file management
\ Back up, compact, and repair Access files
\ Create filters
\ Sorttable data on one or more fields
\ Know when to use Access or Excel to manage data
\ Use the Relationship window
\ Understand relational power
\ Design data
\ Create tables
\ Understandtable relationships
\ Share data with Excel
\ Establishtable relationships
\ Create a query
\ Specify criteria for different data types
\ Copy and run a query
\ Use the Query Wizard
\ Understand large database differences (page 177).
\ Understand the order of precedence
\ Create a calculated field in a query
\ Create expressions with the expression Builder
\ Create and edit Access functions
\ Perform date arithmetic
\ Create and work with data aggregates

\ In-depth study of computer hardware, software, operating systems and information systems pertaining to a business environment. The main focus of this course is to understand and use various business software applications including word processing, spreadsheets, databases, and other miscellaneous business applications.

Students Rights and Responsibilities

Student Rights and Responsibilities

Log in using the AC Connect Portal

In order to receive your AC Connect Email, you must log in through AC Connect at https://acconnect.actx.edu .

If you are an active staff or faculty member according to Human Resources, use "Exchange". All other students, use "AC Connect (Google) Email".

Expected Student Behavior

\ Students are expected to maintain a high standard of individual honor in their scholastic work.Students who are guilty of cheating, plagiarism, copying, or dishonesty may be excluded from class with a grade of F; or, in flagrant cases, may be suspended from the College.

\ The faculty of the CIS Department reserves the right to ask a student to verify any portion of a test by reproducing any specific section or all of the test in question. Any action that comprises the computer systems at Amarillo College, including but not limited to hacking or cracking, can result in a grade of "F" in this course and possible further disciplinary action.

Grading Criteria

Final grades will be assigned as indicated below.

A - Superior, Minimum of 90% average on exams and quizzes plus

all homework turned in with a 90% average on graded work.

B - Good, Between 80% and 89.49% average on exams and quizzes plus

all homework turned in with a minimum average of 80% on

graded work.

C - Adequate, Between 70% and 79.49% average on all work.

D - Minimum, Between 60% and 69.49% average on all work.

F - Failing, Below 60% average on all work.

EVALUATION:

Student grade will be based on the following:

Technology in Action Chapter Tests – 10%

Technology in Action Major Exams – 15%

Technology in Action Final – 15%

MyITLab Labs – 20%

MyITLab Major Exams – 25%

MyITLab Final – 15%

Summary of the above:

10% - Chapter Tests TIA total

40% - Major Exams for TIA and MyITLab total

20% - Labs total

30% - Final for TIA and MyITLab total

100% TOTAL

Assignment, homework, quiz, and test dates are provided for each student at the beginning of the semester. It will be your responsibility to complete each assignment, all homework, and take exams on the scheduled dates.

Attendance

\ Regular attendance is necessary for satisfactory achievement. Therefore, it is the responsibility of the student to attend class and also adhere to the CIS Department attendance requirements.

\ Check your email daily and have assignments in on time.
\ An exam may be taken only one time.

Calendar

\ The Course Schedule is accurate at time of publication. However, topics addressed may be rearranged due to class climate, high school activity schedules, and weather factors (school closings, etc.)

\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \

\ \ BUSINESS COMPUTER APPLICATIONS – BCIS 1305 \
\ \ *Technology in Action (TIA) is your lecture book. For each chapter in this textbook, you must do a Chapter Test (required) from the AC Online site. Exploring Office 2007,* MyITLab Training for each hands-on exercise is optional. It exactly duplicates the textbook Hands-on exercises. The project based labs and skill based exams are mandatory for each chapter. Doing the training will greatly improve your grade on the labs and exams. \
\ \ Week \	\ \ Date \	\ \ Chapter \	\ \ Training in MyITLab can be repeated as many times as you want— \ \ it is not mandatory \	\ \ Lab Assignments and Tests-- \ \ These are completed by downloading file(s) from MyITLab, completing the tasks using the live software, and then uploading file(s) to MyITLab Grader for grading. \
\ \ 1 \	\ \ 8/22 \	\ \ Technology in Action \	\ \ Read Chapter 1 – TIA \ \ Read Word – Ch 1,and MyITLab Training \	\ \ Lab 1A \ \ Introduction to Windows XP/File Management \
\ \ 2 \	\ \ 8/29 \	\ \ Technology in Action, TIA Chapter 1, Why Computers Matter to You \ \ Office 2007, Word Chapter 1 \	\ \ Read Chapter 2 – TIA \	\ \ Chapter 1 Test, TIA \ \ MyITLab Word Chapter 1 Lab 1B \
\ \ 3 \	\ \ 9/5 \	\ \ TIAChapter 2, Looking at Computers \	\ \ Read Chapter 3 – TIA \ \ Read Word – Ch 2 and \ \ MyITLab Training \	\ \ Chapter 2 Test TIA \ \ MyITLab Word Major Exam, Part 1 \
\ \ 4 \	\ \ 9/12 \	\ \ TIAChapter 3, Using the Internet \ \ Office 2007, Word Chapter 2 \	\ \ Read Chapter 4 – TIA \	\ \ Chapter 3 Test, TIA \ \ MyITLab Word Chapter 2 Lab 2 \
\ \ 5 \	\ \ 9/19 \	\ \ TIAChapter 4, Application Softwareand Technology in Focus, Digital Entertainment \ \ \	\ \ Read Word – Ch 3 and \ \ MyITLab Training \	\ \ Chapter 4 Test, TIA \ \ MyITLab Word Major Exam, Part 2 \
\ \ 6 \	\ \ 9/26 \	\ \ Office 2007, Word Chapter 3 \	\ \ Read Chapter 5 – TIA \ \ Read Excel – Ch 1 and \ \ MyITLab Training \	\ \ MyITLab Word Chapter 3 Lab 3 \ \ MyITLab Word Major Exam, Part 3 \
\ \ 7 \	\ \ 10/3 \	\ \ TIAChapter 5, Using System Software and Technology in Focus, Computing Alternatives \	\ \ Study for Major Exam 1 – TIA, Chapter 1-5 \	\ \ Chapter 5 Test, TIA \ \ MyITLab Excel Chapter 1 Lab 4 \
\ \ 8 \	\ \ \ 10/10 \	\ \ Office 2007, Excel Chapter 1 \	\ \ Read Chapter 6 – TIA \ \ Read Excel – Ch 2 \ \ MyITLab Training \	\ \ MyITLab Excel Major Exam, Part 1 \ \ Major Exam 1, Chapters 1–5, TIA \
\ \ 9 \	\ \ 10/17 \	\ \ TIAChapter 6, Understanding and Assessing Hardwareand Technology in Focus, Computing Alternatives \ \ Office 2007, Excel Chapter 2 \	\ \ Read Chapter 7 – TIA \ \ Read Excel – Ch 2 and \ \ MyITLab Training \	\ \ Chapter 6 Test, TIA \ \ \ \ MyITLab Excel Chapter 2 Lab 5 \
\ \ 10 \	\ \ 10/24 \	\ \ TIA Chapter 7, Networking and Security and Technology in Focus, Protecting Your Computer \ \ Office 2007, Excel Chapter 3 \	\ \ Read Excel – Ch 3 \ \ and MyITLab Training \	\ \ Chapter 7 Test, TIA \ \ \ \ MyITLab Excel Major Exam, Part 2 \
\ \ 11 \	\ \ 10/31 \	\ \ Office 2007, Access Chapter 1 \	\ \ Read Chapter 8 – TIA \ \ Read Access – Ch 1 \ \ and MyITLab Training \	\ \ MyITLab Excel Chapter 3 Lab 6 \ \ MyITLab Excel Major Exam, Part 3 \
\ \ 12 \	\ \ 11/7 \	\ \ TIA Chapter 8, Mobile Computing and Technology in Focus, Digital Entertainment \ \ \ \ Office 2007, Access Chapter 2 \	\ \ Read Chapter 9 – TIA \ \ Read Access Ch 2 \ \ and MyITLab Training \	\ \ Chapter 8 Test, TIA \ \ MyITLab Access Chapter 1 Lab 7 \ \ MyITLab Access Major Exam, Part 1 \
\ \ 13 \	\ \ 11/14 \	\ \ TIA Chapter 9, A Closer Look at System Hardware \ \ \ \ Office 2007, Access Chapter 3 \	\ \ Read Chapter 13 – TIA \ \ Read Access Ch 3 \ \ and MyITLab Training \	\ \ Chapter 9 Test, TIA \ \ MyITLab Access Chapter 2 Lab 8 \ \ MyITLab Access Major Exam, Part 2 \
\ \ 14 \	\ \ 11/21 \	\ \ TIA Chapter 13, The Internet \	\ \ Study for Major Exam 2 – TIA, \ \ Chapters 6, 7, 8, 9 & 13 \	\ \ Chapter 13 Test, TIA \ \ MyITLab Access Chapter 3 Lab 9 \ \ MyITLab Access Major Exam, Part 3 \ \ \
\ \ 15 \	\ \ 11/28 \	\ \ \	\ \ \	\ \ MyITLab Final \ \ Major Exam 2 – TIA, Chapters 6, 7, 8, 9 & 13 \ \ \
\ \ 16 \	\ \ 12/5 \	\ \ FINAL TIA – Online course finals are due by Tuesday, Dec. 6 \	\ \ \	\ \ \

Additional Information

\
\ Important Dates to Remember

\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \

\ \ August 22 \	\ \ Fall Classes Begin \
\ \ August 22-26 \	\ \ Late Registration \
\ \ September 5 \	\ \ Labor Day Holiday (college closed) \
\ \ November 7 \	\ \ Spring Registration Begins \
\ \ November 16 \	\ \ Last Day to Withdraw \
\ \ November 24-27 \	\ \ Thanksgiving Holiday \
\ \ December 5 \	\ \ Finals Week \

Syllabus Created on:

11/30/-1 12:00 AM

Last Edited on: