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

Instructor Information

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-019 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

\N

Occupational License Disclaimer

Hours

(3 sem hrs; 2 lec, 3 lab)

Class Type

Dual Credit Course

Syllabus Information

Textbooks

\

\  

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

\ Textbooks for BCIS 1305

\	\ \  Exploring Microsoft Office 2007 Vol. 1, 3rd Ed.      by Grauer \  ISBN-10:  0135062500 \  ISBN-13:  9780135062500 \
\	\  Technology In Action, Introductory Version, 7th Ed., Complete      by Evans \  ISBN-10:  0135096693 \  ISBN-13:  9780135096697
\  myIT Lab Access Code	\ \  ISBN# 0558667910 (Packaged Books) or may be purchased individually at \  https://register.pearsoncmg.com/reg/include/consent.jsp?originalDest=/reg/buy/buy1.jsp?productID=32215 \

\

\  

\

\ Options are available for your textbooks for this course:

\ \

\ ·         Purchase bundled package (TIA 7^th ed. & Office 2007 + myitlab code) at AC bookstore

\

\ ·         Purchase TIA 7^th ed. & Office 2007 E-book (electronic book) and myitlab code from Pearson Education

\

\ ·         Purchase TIA 7^th ed. E-book(electronic book) & myitlab code from Pearson Education.  Some students do not want a paper textbook for Office 2007 and choose to do all their work on the myitlab website.  Other students prefer a paper or electronic resource that they can use for visual reinforcement.

\

\ For the Office 2007 e-book:   Robert T. Grauer; Michelle Hulett; Cynthia Krebs; Maurie Wigman Lockley; Keith Mulbery; Judy Scheeren, Exploring Microsoft® Office 2007, Volume 1, Third Edition, http://www.coursesmart.com/9780137003525?__instructor=1951024

\

\ For Technology in Action, 7th edition:

\ \

\ Alan Evans; Kendall Martin; Mary Anne Poatsy, Technology in Action: Complete, Seventh Edition, http://www.coursesmart.com/9780135096765?__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

\ Removable 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.
\

\
• \ 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 non-breaking hyphens and non-breaking spaces
\
• \ Copy formats with the Format Painter
\
• \ Set off paragraphs with tabs, borders, lists, and columns
\
• \ Apply paragraph formats
\
• \ Create and modify styles
\
• \ Create a table of contents
\
• \ Create an index
\
• \ Insert a table
\
• \ Format a table
\
• \ Sort and apply formulas to table data
\
• \ Convert text to a table
\
• \ Insert clip art and images into a document
\
• \ Format a graphic element
\
• \ Insert WordArt into a document
\
• \ Insert symbols into a document
\

\
• \ 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
\
• \ Manage cell comments
\

\
• \ 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
\
• \ Sort table 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
\
• \ Understand table relationships
\
• \ Share data with Excel
\
• \ Establish table relationships
\
• \ Create a query
\
• \ Specify criteria for different data types
\
• \ Copy and run a query
\
• \ Use the Query Wizard
\
• \ Understand large database differences
\
• \ 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

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

Grading Criteria

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

\ Check your email daily and have assignments in on time.

\ Attendance is required for all seated classes.  Attendance will be taken each class period.  The CIS Departmental Attendance policy is as follows:

\ Classes meet twice a week in a regular semester.  After two absences for any reason, one point will be deducted from the semester average for each additional absence.  There are no excused absences.  Two tardies equal one absence.  If you leave class while class is being conducted, it will count as a tardy.  If you are more than 10 minutes late, it will be counted as an absence. It is your responsibility to check with the instructor after class to correct an “absence” to a “late” if you enter the class after role has been taken and you were less than 10 minutes late.

\ If you miss a lecture or lab period, it is your responsibility to determine what you have missed and take appropriate measures.  It is also your responsibility to drop the course if you cannot meet course expectations.

\ The instructor will set the times for the exams.  There will be no make-up exams. An exam may be taken only one time.

\ The Texas Education Code stipulates that students attending Texas institutions of higher education for the first time in fall 2007 and later may not withdraw from more than six courses during their academic career, including courses from which transfer students have withdrawn at other Texas institutions of higher education. There are certain exceptions to this policy and petitions for exceptions should be directed to the Registrar.

Calendar

Additional Information

 Important Dates to Remember