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

Dual Credit Course

Syllabus Information

Textbooks

Supplies

\
• \ Select a template from the New Document
\
• \ Use a resume template
\
• \ Create a Word template
\
• \ Customize theme colors
\
• \ Customize theme fonts and effects
\
• \ Select a main document  
\
• \ Select or create recipients 
\
• \ Sort records in a data source
\
• \ Insert merge fields
\
• \ Merge a main document and a data source
\
• \ Use Excel worksheets as a data source
\
• \ Use Access databases as a data source
\
• \ Construct a newsletter
\
• \ Develop a document design
\
• \ Insert drawing shapes
\
• \ Insert SmartArt
\
• \ Insert a text box
\
• \ Format graphical objects
\
• \ Group and layer objects
\
• \ Flip and rotate objects
\
• \ Use OLE to insert an object
\
• \ Update a linked object
\
• \ Create an electronic form
\
• \ Insert form controls
\
• \ Protect a form
\
• \ Mark a document as final
\
• \ Set formatting restrictions
\
• \ Set editing restrictions
\
• \ Set passwords to open a document
\
• \ Use Digital signatures to authenticate documents
\
• \ Record a macro
\
• \ Run a macro
\

\
• \ Design tables based on data table theory
\
• \ Import data from text files and other sources
\
• \ Apply conditional formatting
\
• \ Apply advanced filtering and sorting methods
\
• \ Create and use range names
\
• \ Use database functions
\
• \ Create and delete PivotTables and PivotCharts 
\
• \ Format, sort, filter, subtotal, and refresh a PivotTable
\
• \ Separate and combine text
\
• \ Manipulate text with functions
\
• \ Identify and remove duplicate rows 
\
• \ Group and subtotal data 
\
• \ Work with windows
\
• \ Use conditional functions 
\
• \ Create nested IF functions
\
• \ Use AND, OR, NOT, and IFERROR functions
\
• \ Define the amortization table
\
• \ Use functions in amortization tables
\
• \ Consolidate data from multiple worksheets
\
• \ Define the three-dimensional workbook
\
• \ Create three-dimensional formulas
\
• \ Link workbooks
\
• \ Create the documentation worksheet
\
• \ Restrict values to a drop-down list
\
• \ Validate data
\
• \ Audit formulas
\
• \ Set up a Watch Window
\
• \ Create a one-variable data table
\
• \ Create a two-variable data table
\
• \ Solve problems with Goal Seek
\
• \ Use Scenario Manager 
\
• \ Load the Solver Add-In 
\
• \ Solve problems with Solver Track changes
\
• \ Enable simultaneous changes by multiple users
\
• \ Save workbooks in different formats
\
• \ Copy data to Word and PowerPoint
\
• \ Finalize documents
\
• \ Prepare workbooks for distribution
\
• \ Understand Excel options
\
• \ Work with the Quick Access Toolbar 
\
• \ Add add-ins Work with existing templates, themes, and styles
\
• \ Create and apply custom styles for advanced formatting
\
• \ Create and use a template
\
• \ Create a Web page
\
• \ Create Web queries
\
• \ Create a macro with the Macro Recorder
\
• \ Create macro buttons
\
• \ Work with macro security
\
• \ Understand the basics of VBA
\

\
• \ Establish data validity 
\
• \ Create and modify a lookup field
\
• \ Create and modify a multivalued lookup field
\
• \ Work with input masks 
\
• \ Create forms by using the Form Tool
\
• \ Create custom forms in Design view
\
• \ Create subforms
\
• \ Maintain databases with action queries 
\
• \ Update data with an update query
\
• \ Add records to a table with an append query 
\
• \ Create a table with a make table query
\
• \ Delete records with a delete query
\
• \ Provide flexibility with a parameter query
\
• \ Summarize data with a crosstab query
\
• \ Find unmatched records with a query
\
• \ Find duplicate records with a query
\
• \ Design functional formats
\
• \ Encrypt and password-protect a database 
\
• \ Digitally sign and publish the database
\
• \ Save the database as an ACCDE file
\
• \ Analyze database documentation
\
• \ Analyze database performance 
\
• \ Analyze database table structure and relationships 
\
• \ Move data to new database files
\
• \ Analyze and optimize object relationships in an Access database
\
• \ Create usable switchboards
\
• \ Understand the purpose of macros in Access databases
\
• \ Create embedded macros using wizards
\
• \ Create macros using the Macro Builder
\
• \ Assign macros to events 
\
• \ Use SQL conditions to control macro actions 
\
• \ Understand Visual Basic for Applications (VBA)
\
• \ Use the Visual Basic Editor
\
• \ Create procedures
\
• \ Declare and use variables
\
• \ Manage data using SQL
\

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.
\
• \ An exam may be taken only one time
\
• \ Attendance will be determined from online class participation through homework assignments, discussions, and exams. 
\

Calendar

Additional Information

\  

\ Important Dates to Remember

\  

\