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

On Campus Course

Syllabus Information

Textbooks

\ Textbooks for BCIS 1305

\  

\	\ \  Exploring Microsoft Office 2010 Vol. 1 by Grauer \  ISBN 9780136122326   \   \
\	\ \  Technology In Action, Introductory Version, 7th Ed., Complete by Evans \ \   ISBN 9780135096697 \

\  

\ Textbook requirements for this class:
\  

\ Options for textbooks:

\  Purchase a bundled package:

\
• \ Technology in Action, Complete, 7th.edition complete
\
• \ Exploring Office 2010, Vol. I
\
• \ myitlab code (allows for use of e-text books or electronic textbook)
\
• \ Getting started with myitlab
\
• \ CD for Technology in Action
\

\  Purchase a myitlab code that allows for e-texts of Technology in Action and Exploring Office 2010:

\
• \ Rental at AC Bookstore is available for the textbooks Technology in Action, Complete, 7^th edition  and Exploring Office 2010, Vol 1
\

\ *Please note this course will require a myitlab code and assignments to be completed in Microsoft Office 2010, Professional Edition, Word, Excel and Access and PowerPoint

Supplies

\ Access to a PC (personal computer ).  Available in the CIS Department at Amarillo College

\ Office 2010, Professional:  Word, Excel, Access and PowerPoint.  Available in the CIS Department at Amarillo College

\

Student Performance

\  

\ This is an 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 presentation software..

\ After completing assignments in Technology in Action, the student will be able be able to explain

\
• \ What software is included in system software?
\
• \ What are the different kinds of operating systems?
\
• \ What are the most common operating systems?
\
• \ How does the operating system provide a means for users to interact with the computer?
\
• \ How does the operating system help manage resources such as the processor, memory, storage, hardware, and peripheral devices?
\
• \ How does the operating system interact with application software?
\
• \ How does the operating system help the computer start up?
\
• \ What are the main desktop and window features?
\
• \ How does the operating system help me keep my computer organized?
\
• \ What utility programs are included in system software, and what do they do?
\
• \ What exactly is a computer, and what are its four main functions?
\
• \ What is the difference between data and information?
\
• \ What are bits and bytes, and how are they measured?
\
• \ What devices do I use to get data into the computer?
\
• \ What devices do I use to get information out of the computer?
\
• \ What’s on the motherboard?
\
• \ Where are information and programs stored?
\
• \ How are devices connected to the computer?
\
• \ How do I set up my computer to avoid strain and injury?
\
• \ What is the origin of the Internet?
\
• \ How can one communicate through the Internet?
\
• \ How can one communicate and collaborate using Web 2.0 technologies?
\
• \ What are the various kinds of multimedia files found on the Web, and what software do I need to use them?
\
• \ What is e-commerce, and what e-commerce safeguards protect me when I’m online?
\
• \ What is a Web browser?
\
• \ What is a URL, and what are its parts?
\
• \ How can I use hyperlinks and other tools to get around the Web?
\
• \ How do I search the Internet effectively?
\
• \ How do I evaluate a Web site?
\
• \ How does data travel on the Internet?
\
• \ What are my options for connecting to the Internet?
\
• \ What will the Internet of the future look like?
\
• \ What’s the difference between application software and system software?
\
• \ What kinds of applications are included in productivity software?
\
• \ What are the different types of multimedia software?
\
• \ What are the different types of entertainment software?
\
• \ What are the different types of drawing software?
\
• \ What kinds of software do small and large businesses use?
\
• \ What kind of software is available online?
\
• \ Where can I go for help when I have a problem with my software?
\
• \ How can I purchase software or get it for free?
\
• \ How do I install, uninstall, and start software?
\
• \ What are the changes that have brought us a digital lifestyle?
\
• \ How has the move to digital information affected the communication tools important to both the business world and life outside of work?
\
• \ How do cell phone and smartphone components resemble a traditional computer, and how do they work?
\
• \ Why would I use VoIP, and what does it offer that is unique?
\
• \ How is digital media different from analog?
\
• \ What can I carry in a portable media player, and how does it store data?
\
• \ What ways are there for me to create and to watch digital video?
\
• \ What changes does ubiquitous computing bring to our lifestyles?
\
• \ From which types of viruses do I need to protect my computer?
\
• \ What can I do to protect my computer from viruses?
\
• \ How can hackers attack my computing devices, and what harm can they cause?
\
• \ What is a firewall, and how does it keep my computer safe from hackers?
\
• \ How do I create secure passwords and manage all of my passwords?
\
• \ How can I surf the Internet anonymously and use biometric authentication devices to protect my data?
\
• \ How do I manage online annoyances such as spyware and spam?
\
• \ What data does one need to back up, and what are the best methods for doing so?
\
• \ What is social engineering, and how do I avoid falling prey to phishing and hoaxes?
\
• \ How do I protect my physical computing assets from environmental hazards, power surges, and theft?
\
• \ What are the advantages of a business network?
\
• \ How does a client/server network differ from a peer-to-peer network?
\
• \ What are the different classifications of client/server networks?
\
• \ What components are needed to construct a client/server network?
\
• \ What do the various types of servers do?
\
• \ What are the various network topologies (layouts), and why is network topology important in planning a network?
\
• \ What types of transmission media are used in client/server networks?
\
• \ What software needs to run on computers attached to a client/server network, and how does this software control network communications?
\
• \ How do network adapters enable computers to participate in a client/server network?
\
• \ What devices assist in moving data around a client/server network?
\
• \ What measures are employed to keep large networks secure?
\
• \ Who owns, manages, and pays for the Internet?
\
• \ How do the Internet’s networking components interact?
\
• \ What data transmissions and protocols does the Internet use?
\
• \ Why are IP addresses and domain names important for Internet communications?
\
• \ What are FTP and Telnet, and how do you use them?
\
• \ What are HTML/XHTML and XML used for?
\
• \ How do e-mail, instant messaging, and Voice over Internet Protocol work, and how is information using these technologies kept secure?
\
• \ How do businesses use the Internet to reduce computing costs?
\

\ After completing PowerPoint the student will be able to:

\
• \ Understand how word processors work
\
• \ Customize Word
\
• \ Use features that improve readability
\
• \ Check spelling and grammar
\
• \ Display a document in different views
\
• \ Prepare a document for distribution
\
• \ Modify document properties
\

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

\
• \ Understand how word processors work
\
• \ Customize Word
\
• \ Use features that improve readability
\
• \ Check spelling and grammar
\
• \ Display a document in different views
\
• \ Prepare a document for distribution
\
• \ Modify document properties
\
• \ Apply font attributes through the Font dialog box
\
• \ Control word wrap
\
• \ Set off paragraphs with tabs, borders, lists, and columns
\
• \ Apply paragraph formats
\
• \ Understand styles
\
• \ Create and modify styles
\
• \ Format a graphical object
\
• \ Insert symbols into a document
\
• \ Insert comments in a document
\
• \ Track changes in a document
\
• \ Acknowledge a source
\
• \ Create and modify footnotes and endnotes
\
• \ Insert a table of contents and index
\
• \ Add other reference tables
\
• \ Create cross-references
\

\ After competing Excel, the student will be able to:

\
• \ Plan for effective workbook and worksheet design
\
• \ Explore the Excel window
\
• \ Enter and edit cell data
\
• \ Use symbols and the order of precedence
\
• \ Use Auto Fill
\
• \ Display cell formulas
\
• \ Manage worksheets
\
• \ Manage columns and rows
\
• \ Select, move, copy, and paste
\
• \ Apply alignment and font options
\
• \ Apply number formats
\
• \ Select page setup options
\
• \ Print a worksheet
\
• \ Use semi-selection to create a formula
\
• \ Use relative, absolute, and mixed cell references in formulas
\
• \ Avoid circular references
\
• \ Insert a function
\
• \ Total values with the SUM function
\
• \ Insert basic statistical functions
\
• \ Use date functions
\
• \ Determine results with the IF function
\
• \ Use lookup functions
\
• \ Calculate payments with the PMT function
\
• \ Create and maintain range names
\
• \ Use range names in formulas
\
• \ Decide which chart type to create
\
• \ Create a chart
\
• \ Change the chart type
\
• \ Change the data source and structure
\
• \ Apply a chart layout and a chart style
\
• \ Move a chart
\
• \ Print charts
\
• \ Insert and customize a sparkline
\
• \ Select and format chart elements
\
• \ Customize chart labels
\
• \ Format the axes and gridlines
\
• \ Add a trendline
\

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

\
• \ Navigate among the objects in an Access database
\
• \ Understand the difference between working in storage and memory
\
• \ Practice good database 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 Relationships window
\
• \ Understand relational power
\
• \ Design data
\
• \ Create tables
\
• \ Understand table relationships
\
• \ Share data with Excel
\
• \ Establish table relationships
\
• \ Create a single-table query
\
• \ Specify criteria for different data types
\
• \ Copy and run a query
\
• \ Use the Query Wizard
\
• \ Create a multi-table query
\
• \ Modify a multi-table query
\

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

\ Final grades will be assigned as indicated below.

Attendance

\
• \ Check your email daily and have assignments in on time.
\
• \ An exam may be taken only one time.
\
• \ Attendance for on campus classes and dual credit classes will be taken during each class period.  Attendance for online classes will be determined by participation through homework assignments, discussions, exams and logging on to AC Online.
\

Calendar

Additional Information

\
\   Important Dates to Remember

\