Microcomputer 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-1401-001 Microcomputer Applications

Prerequisites

BCIS 1305

Course Description

Introduction to intermediate business programming techniques. Includes structured programming methods, designing customized software applications using word processing, spreadsheet and presentation graphics for the computer.

Student Resources Student Resources Website

Department Expectations

\N

Occupational License Disclaimer

Hours

(4 sem hrs; 3 lec, 2 lab)

Class Type

Online Course

Syllabus Information

Textbooks

BCIS  1401 Textbook Options

 

Exploring Microsoft Office 2010 Vol. 2 by Grauer     9780135091081

Textbook requirements for this class:

     Options:

 1. Purchase Exploring Office 2010, Vol.2 and an e-text myitlab code if you do not have Exploring Office 2010, Vol 1 textbook.

  (*Please note this course will require a myitlab code and assignments to be completed in Microsoft Office 2010,)

             2.  Purchase the Exploring Office 2010, Vol. 2 textbook without an e-text myitlab code,  (This option is only available if an e-text myitlab code has already been purchased and it is less than a year old)

             3. Purchase a Exploring Office e-text code code for myitlab without a printed textbook

             4.  Rent an Exploring Office 2010, Vol. 2 textbook from the AC Bookstore, but you must have a current e-text code for myitlab or purchase one...

Contact your instructor for any questions.

 

 

 

 

Supplies

  

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

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

Reliable access

Student Performance

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

\

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

\

\
• \ Construct a newsletter
\
• \ Develop a document design
\
• \ Insert graphical objects
\
• \ Manipulate graphical objects
\
• \ Use OLE to insert an object
\
• \ Update a linked object
\
• \ Select a template from the Backstage view
\
• \ Create a Word template
\
• \ Use Building Blocks
\
• \ View documents side by side
\
• \ Merge documents
\
• \ Use navigational tools
\
• \ Customize theme colors
\
• \ Customize theme fonts and effects
\
• \ Create an electronic form
\
• \ Insert form controls
\
• \ Protect a form
\
• \ Record a macro
\
• \ Run a macro
\
• \ Apply document restrictions
\
• \ Set passwords to open a document
\
• \ Use digital signatures to authenticate documents
\
• \ Customize the Ribbon
\
• \ Build a Web page
\
• \ Publish a Web page
\
• \ Understand XML
\
• \ Attach an XML schema
\
• \ Create a blog post  
\

\

\ After completing the Excel section the student will be able to:

\

\
• \ Create a Spreadsheet
\
• \ Group and ungroup data
\
• \ Subtotal data
\
• \ Create a PivotTable
\
• \ Change the values field
\
• \ Modify a PivotTable
\
• \ Sort, filter, and slice a PivotTable
\
• \ Create a calculated field
\
• \ Format a PivotTable
\
• \ Create a PivotChart
\
• \ Create a one-variable data table
\
• \ Create a two-variable data table
\
• \ Identify an input value with Goal Seek
\
• \ Use Scenario Manager
\
• \ Generate scenario summary reports
\
• \ Load the Solver Add-In
\
• \ Optimize results with Solver
\
• \ Use conditional math and statistical functions
\
• \ Calculate relative standing with statistical functions
\
• \ Create a nested logical function
\
• \ Use MATCH and INDEX lookup functions
\
• \ Use advanced filtering
\
• \ Manipulate data with database functions
\
• \ Create a loan amortization table
\
• \ Perform other financial calculations
\
• \ Work with grouped worksheets
\
• \ Manage windows and workspaces
\
• \ Insert hyperlinks
\
• \ Insert a 3-D formula
\
• \ Link workbooks
\
• \ Audit formulas
\
• \ Set up a watch window
\
• \ Validate data
\
• \ Import data from external sources
\
• \ Create a Web query
\
• \ Manage connections
\
• \ Convert text to columns
\
• \ Manipulate text with functions
\
• \ Understand XML syntax
\
• \ Import XML data into Excel
\
• \ Customize Excel
\
• \ Change properties
\
• \ Share and merge workbooks
\
• \ Insert comments
\
• \ Track changes
\
• \ Check for issues
\
• \ Protect a workbook
\
• \ Save a workbook in different formats
\
• \ Send a workbook to others
\
• \ Select a template
\
• \ Apply themes and backgrounds
\
• \ Apply cell styles
\
• \ Create and use a template
\
• \ Protect a cell, a worksheet, and a workbook
\
• \ Create a macro
\
• \ Create macro buttons
\
• \ Set macro security
\

\

\  After completing the PowerPoint section the student will be able to:

\

\
• \ Use PowerPoint views
\
• \ Save as a slide show
\
• \ Plan a presentation
\
• \ Assess presentation content
\
• \ Use slide layouts
\
• \ Apply themes
\
• \ Review the presentation
\
• \ Insert media objects
\
• \ Add a table
\
• \ Use animations and transitions
\
• \ Insert a header or footer
\
• \ Run and navigate a slide show
\
• \ Print in PowerPoint
\
• \ Create a presentation using a template
\
• \ Modify a template
\
• \ Create a presentation in Outline view
\
• \ Modify an outline structure
\
• \ Print an outline
\
• \ Import an outline
\
• \ Add existing content to a presentation
\
• \ Use sections
\
• \ Examine slide show design principles
\
• \ Modify a theme
\
• \ Create shapes
\
• \ Apply Quick Styles and customize shapes
\
• \ Create SmartArt
\
• \ Modify SmartArt
\
• \ Create WordArt
\
• \ Modify WordArt
\
• \ Modify objects
\
• \ Arrange objects
\
• \ Insert a picture
\
• \ Transform a picture
\
• \ Use the Internet as a resource
\
• \ Add video
\
• \ Use Video Tools
\
• \ Add audio
\
• \ Change audio settings
\
• \ Create a Photo Album
\
• \ Set Photo Album options
\

\

\ The main focus of this course is to understand and use various business software applications including word processing, spreadsheets, presentation graphics 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

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.

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

Final Options

In this class you have two options for your Final:

First Option--Completing a Final consisting of Word, Excel and PowerPoint exams in Myitlab.

Second Option--Take either a Word Microsoft Office Specialist (MOS) Certification exam or Excel Microsoft Office Specialist (MOS) Certification exam (either one will count as your final.)  The CIS department will supply the training for MOS in your Myitlab account and will be a proctor for the MOS exam.  The MOS exam costs $65, but if you pass the exam, you will be refunded the $65.  This option is a great opportunity for students at Amarillo College.  Here are a few frequently asked questions.

 

Important Dates to Remember     January 17 Classes Begin January 18-20 Late Registration March 12-18 Spring Break April 6 Easter Holiday April 9 Registration Begins April 19 Last Day to Withdraw May 7 Final Week