CISCO COLLEGE
BUSINESS COMPUTER INFORMATION SYSTEMS
101 College Heights
CISCO, TX 76437
BCIS 1305
Sections 1, 2, 6, 4, 7
BUSINESS COMPUTER APPLICATIONS
(3 hours credit)
SPRING 2015
INSTRUCTOR
:
Glennis Boyd
OFFICE
:
Room 31A, Vocational Technical #1
OFFICE PHONE
:
254-442-5159
SCHOOL E-mail
[email protected]
OFFICE HOURS
:
Tuesday, Thursday—8:30 a.m.11:00 a.m
I.
COURSE TITLE AND NUMBER
Business Computer Applications – BCIS 1305 (Credit: 3 semester hours)
II.
TEXTBOOK
Computer Concepts & Microsoft Office 2013 by Denise Seguin, Paradigm Publishing, Inc. with Student Resources CD (provided with textbook)
Other Requirements:
Access to a computer with Windows 7 or Windows 8 and Microsoft Office 2013 with internet connection
SNAP Training and Assessment for MS Office 2013, (snap2013.emcp.com) Windows 7 or 8 Storage media such as a Jump Drive, flash drive, USB drive.
Folder with brads for Class Handouts
III.
COURSE STRUCTURE
SECTION CLASS TIME CLASS DAYS ROOM Section 01 8:00 a.m.—9:25 a.m. MW 34 Section 02 9:35 a.m.—11:00 a.m. MW 34 Section 06 11:10 a.m.—12:35 p.m. MW 34 Section 04 11:10 a.m.—12:35 p.m. TR 34 Section 07 1:00 a.m.—2:25 p.m. TR 34
2
IV.
COURSE DESCRIPTION
Students will study computer terminology, hardware, and software related to the business environment. The focus of this course is on business productivity software applications and professional behavior in computing, including word processing (as needed), spreadsheets, databases, presentation graphics, and business-oriented utilization of the Internet.
V.
LEARNING OUTCOMES
(ACGM – Spring 2014)
Upon successful completion of this course, students will:1. Describe the fundamentals of Information Technology (IT) infrastructure components: hardware, software, and data communications systems. (LO1)
2. Explain the guiding principles of professional behavior in computing. (LO2)
3. Demonstrate proper file management techniques to manipulate electronic files and folders in a local and networked environment. (LO3)
4. Use business productivity software to manipulate data and find solutions to business problems. (LO4)
5. Explain the concepts and terminology used in the operation of application systems in a business environment. (LO5)
6. Identify emerging technologies for use in business applications. (LO6)
7. Complete projects that integrate business software applications. (LO7)
VI.
CORE OBJECTIVES
This course meets the Core Objectives of Critical Thinking, Communications Skills, and
Empirical & Quantitative Skills for the Foundational Component Area of the Institutional Option as approved by Cisco College.
BCIS 1305 is foundational course in which students learn basic and intermediate features of the programs in the Microsoft Office Professional 2013 suite as well as the basics of Windows 8, the operating system. It emphasizes the Core Objective of Empirical & Quantitative Skills in the Excel and Access application areas. In Excel the students create worksheets to enter formulas, and functions. Students perform logical test calculations and use goal seek to use what-if analysis for different scenarios. In Access students perform calculations and calculate statistics in queries. The Core Objective of Critical Thinking is demonstrated in the Word, Excel, Access, and PowerPoint applications. Students are required to complete assignments from the textbook and the web-based portion of the course and make decisions about formatting, style, formulas, and other decisions necessary to have a finished document. Students are required to use written and oral communications in Word, Excel, Access, and PowerPoint to meet the Core Objective of Communication Skills.
VII.
COURSE REQUIREMENTS
Pre-requisites:BCIS 1305 does not have any pre-requisites. Computer Lab:
Since BCIS 1305 consists of two lecture hours and two lab hours per week with only 3 contact hours per week of class, students are expected to spend 1 hour per week at a computer working on course assignments. Computer labs are located in the library.
Attendance policy:
Prompt and regular class attendance is considered necessary for satisfactory work. It is the responsibility of the professor to keep an accurate and comprehensive record of attendance. Cisco College recognizes that absence from class may occur due to illness, death or illness in the immediate family, observance of a religious holiday, or participation in a college-sponsored activity. (Absences due to participation in a college-sponsored activity must be authorized by the Vice President of Instruction.) When absences occur due to the above-stated reasons, the student is allowed to make up work missed; the professor may require the work to be made up within two weeks from its original due date. During a regular Fall or Spring semester, the following
requirements apply for face-to-face classes. For a class that meets three times per week, a student is allowed six absences. For a class that meets two times per week, a student is allowed four absences. For a class that meets one time per week, a student is allowed two absences. If a student misses one more than the allowed number of absences, he/she may be dropped from the class if the professor deems the student to be failing due to excessive absences and/or failure to make up work due to absences.
For online or hybrid courses, a student may be dropped after he/she fails to access the course web site and/or participate in the class for a two-week period, and the professor deems the student to be failing.
During a Summer I or II regular face-to-face class, a student is allowed two absences. Upon the third absence, he/she may be dropped from the class if the professor deems the student to be failing due to excessive absences and/or failure to make up work due to absences. For any Minimester or Summer night class, a student is allowed one absence. Upon the second absence, he/she may be dropped from the class if the professor deems the student to be failing due to excessive absences and/or failure to make up work due to absences.
Any student who ceases to attend class without officially withdrawing through the Admissions Office is subject to a grade of “F”. The student will receive a grade of “W” for the course if withdrawn before the “last day to drop with a “W”, and an “F” if withdrawn after “the last day to drop with a “W”. Three tardies may constitute an absence.
Absence Policy and Make-up Work:
Cisco College recognizes that absences from class may occur due to illness, death, or illness in the immediate family, observance of a religious holiday, or participation in a College-sponsored
4
activity. (Absences due to participation in a College-sponsored activity must be authorized by the appropriate administrator.) When absences occur due to the above, the student is allowed to make up work missed; the instructor may require the work to be made up within two weeks.
Assignments will not be accepted after the due date. The final exam will be substituted for ONLY one missed exam or lowest exam grade.
VIII.
COURSE ASSESSMENT
Grading Policy:The final semester letter grade will be based on the following range:
90-100 A
80-89 B
70-79 C
60-69 D
Below 60 F
COURSE EVALUATION
Class assignments (Textbook and SNAP) 15%
Exams: 70%
Concepts Exam—Part I Chapters 1-7 and Part II Chapters 1, 2, 3, and 15 Word Exam—Part II Chapters 6 and 7
Excel Exam—Part II Chapters 8 and 9
PowerPoint Exam—Part II Chapters 10 and 11 Access Exam—Part II Chapters 12 and 13 Integration Exam—Part II Chapter 14
Final Exam 15%
Grades are reported for specific assignments in SNAP and Canvas. The gradebooks in SNAP and Canvas are not combined, and therefore, do not represent a cumulative grade. Grades are
combined in the professor’s gradebook.
Pre- & Post-Tests:
A department pre-test will be given on the first day of class. The pre-test will not count toward a student’s grade in the course. A department post-test will be given as part of the final exam at the end of the course and will count 25% of the final exam grade. Items on the pre- and post-test are designed to measure the Course Goals and Objectives, Course Level Outcomes, and Core Objectives of the Core Curriculum at the program level.
IX.
COURSE TEXTBOOK OUTLINE
The course covers the following chapters and sections of the text: Part I COMPUTER CONCEPTS
Part I-Chapter 1: Living in a Digital World (LO1), (LO2, Ethics Projects) 1 Week Topic 1.1 Personal Computers
Topic 1.2 Mobile Devices, Wearable Computers, and Embedded Computers Topic 1.3 Computers for Connection Multiple Users and Specialized Processing Topic 1.4 Computer Innovations and Converging Technologies
Topic 1.5 Information Technology and Information Processing Cycle Topic 1.6 Cloud Computing
Topic 1.7 Green Computing
Topic 1.8 Computers and Your Health
Part I-Chapter 2: Exploring the World Using the Internet (LO1), (LO2, Ethics Project) 1 Week Topic 2.1 Networks, the Internet, and the World Wide Web
Topic 2.2 Connecting to the Internet Topic 2.3 Popular Web Browsers
Topic 2.4 Understanding Internet and Web Addresses and Navigation Web Pages Topic 2.5 Searching the Web
Topic 2.6 Evaluation Web Content
Topic 2.7 Popular Web Plug-ins and Players for Multimedia Content
Topic 2.8 E-Commerce, Messaging, and Internet Telephone and Conferencing Options Part I-Chapter 3: Computer Hardware (LO1), (LO2, Ethics Projects) 1 Week
Topic 3.1 The System Unit Topic 3.2 Input Devices Topic 3.3 Output Devices Topic 3.4 Network Adapters Topic 3.5 Digital Data Topic 3.6 Storage Options
Part I-Chapter 4: The Operating System and Utility Programs (LO1), (LO2, Ethics Project), (LO5) 1 Week
Topic 4.1 Introduction to the Operating System (OS) and the OS Functions Topic 4.2 Popular Operating Systems for Computer Systems
Topic 4.3 Popular Operating Systems for Mobile Devices
Topic 4.4 Embedded Operating Systems and Cloud Operating Systems Topic 4.5 Utilities in Your OS Package for Maintaining System Performance Topic 4.6 Using Operating System Tools to Troubleshoot Computer Problems
Part I-Chapter 5 Application Software (LO1), (LO2, Ethics Projects) 1 Week Topic 5.1 Productivity Applications for the Workplace
Topic 5.2 Other Workplace-Oriented Productivity Applications
Topic 5.3 Applications for Working with Graphics, Multimedia, and the Web Topic 5.4 Software Applications for Personal Use
6
Topic 5.6 Acquiring, Installing, Uninstalling, and Upgrading Software Topic 5.7 Mobile Apps
Part I-Chapter 6: Using Social Media to Connect and Communicate (LO1), (LO2, Ethics Projects) 1 Week
Topic 6.1 Social networking Topic 6.2 Social Bookmarking Topic 6.3 Sharing Media Topic 6.4 Blogging
Topic 6.5 Wikis for User-Generated Content Topic 6.6 Social Media Strategies in Business
Part I-Chapter 7: Computer Security and Privacy (LO1), (LO2, Ethics Projects) 1 Week Topic 7.1 Unauthorized Access and Unauthorized Use of Computer Resources
Topic 7.2 Botnets and Denial of Service Attacks Topic 7.3 Malware Infections
Topic 7.4 Phishing, Pharming, and Clickjacking Threats Topic 7.5 Information Privacy
Topic 7.6 Mobile Device Security
Part II COMPUTER APPLICATION WITH MICROSOFT OFFICE 2013
Part II-Chapter 1: Using Windows 8 and Managing Files (LO3) 1 Week Topic 1.1 Using Touch, Mouse, and Keyboard Input to Navigate Windows 8
Topic 1.2 Starting Windows 8 and Exploring Apps
Topic 1.3 Revealing the Charms Bar, Searching for an App and Closing Apps Topic 1.4 Locking the Screen, Signing Out, and Shutting Down Windows 8 Topic 1.5 Customizing the Start Screen
Topic 1.6 Personalizing the Start and Lock Screens Topic 1.7 Using the Desktop
Topic 1.8 Browsing Files and File Explorer
Topic 1.9 Creating Folders and Copying Files and Folders
Topic 1.10 Moving, Renaming, and Deleting Files and Folders, and Ejecting a USB Flash Drive
Topic 1.11 Finding Help in Windows
Part II-Chapter 2: Navigating and Searching the Web (LO4) 1 Week Topic 2.1 Introduction to the Internet and the World Wide Web
Topic 2.2 Navigating the Web Using Internet Explorer 10 Topic 2.3 Navigating the Web Using Google Chrome Topic 2.4 Navigating the Web Using Mozilla Firefox
Topic 2.5 Searching for Information and Printing Web Pages Topic 2.6 Downloading Content from a Web Page
Part II-Chapter 3: Exploring Microsoft Office 2013 Essentials (LO4) 1 Week Topic 3.1 Starting and Switching Programs, Starting a New Presentation, and Exploring the Ribbon Interface
Topic 3.2 Using the Backstage View to Manage Documents Topic 3.3 Customizing and Using the Quick Access Toolbar
Topic 3.4 Selecting Text or Objects, Using the Ribbon and Mini Toolbar, and Selecting Options in Dialog Boxes
Topic 3.5 Using the Office Clipboard
Topic 3.6 Finding Help in an Office Program
Topic 3.7 Using SkyDrive for Storage, Scrolling in Documents, and Using Undo Topic 3.8 Changing Display Options
Part II-Chapter 4: Organizing and Managing Class Notes Using OneNote (Optional) Part II-Chapter 5: Communicating and Scheduling Using Outlook (Optional)
Part II-Chapter 6: Creating, Editing, and Formatting Documents Using Word (LO4) 1 Week Topic 6.1 Creating and Editing a New Document
Topic 6.2 Inserting Symbols and Completing a Spelling and Grammar Check Topic 6.3 Finding and Replacing Text
Topic 6.4 Moving Text and Inserting Bullets and Numbering
Topic 6.5 Formatting Text with Font and Paragraph Alignment Options Topic 6.6 Indenting Text and Changing Line and Paragraph Spacing Topic 6.7 formatting Using Styles
Topic 6.8 Creating a New Document from a Template
Part II- Chapter 7: Enhancing a Document with Special Features (LO4) 1 Week Topic 7.1 Inserting, Editing, and Labeling Images in a Document
Topic 7.2 Adding Borders and Shading and Inserting a Text Box Topic 7.3 Inserting a Table
Topic 7.4 Formatting and Modifying a Table Topic 7.5 Changing Page Layout Options
Topic 7.6 Formatting a Research Paper with a Header and Page Numbers Topic 7.7 Inserting and Editing Citations
Topic 7.8 Creating a Works Cited Page and Using Word Views Topic 7.9 Inserting and Replying to Comments
Topic 7.10 Creating a Resume and Cover Letter from Templates
Part II-Chapter 8: Creating, Editing, and Formatting Worksheets Using Excel (LO4) 1 Week Topic 8.1 Creating and Editing a New Worksheet
Topic 8.2 Formatting Cells
Topic 8.3 Adjusting Column Width and Row Height, and Changing Alignment Topic 8.4 Entering or Copying Data with the Fill Command and Using AutoSum Topic 8.5 Inserting and Deleting Rows and Columns
Topic 8.6 Sorting and Applying Cell Styles
Topic 8.7 Changing Orientation and Scaling and Displaying Cell Formulas
Topic 8.8 Inserting and Renaming a Worksheet, Copying Cells, and Indenting Cells Topic 8.9 Using Go To, Freezing Panes, and Shading, Wrapping, and Rotating Cell Entries
Part II-Chapter 9: Working with Functions, Charts, Tables, and Page Layout Options in Excel (LO4) 1 Week Topic 9.1 using Absolute Addressing and Range Names in Formulas
Topic 9.2 Entering Formulas Using Statistical Functions Topic 9.3 Entering, Formatting, and Calculating Dates Topic 9.4 Using the IF Function
Topic 9.5 Using the PMT Function
8
Topic 9.7 Creating and Modifying a Column Chart Topic 9.8 Creating and Modifying a Line Chart
Topic 9.9 Using Page Layout View, Adding a Header, and Changing Margins Topic 9.10 Creating and Modifying Sparklines and Inserting Comments Topic 9.11 Working with Tables
Part II-Chapter 10: Creating, Editing, and Formatting Presentation Using PowerPoint (LO4) 1 Week Topic 10.1 Creating a New Presentation and Inserting Slides
Topic 10.2 Changing the Theme and Inserting and Modifying a Table Topic 10.3 Formatting Text with Font and Paragraph Options
Topic 10.4 Selecting, Resizing, Aligning, and Moving Placeholders
Topic 10.5 Using Slide Sorter View and Moving, Duplicating, and Deleting Slides Topic 10.6 Modifying the Slide Master
Topic 10.7 Adding Notes and Comments Topic 10.8 Displaying a Slide Show
Topic 10.9 Preparing Audience Handouts and Speaker Notes
Part II-Chapter 11: Enhancing a Presentation with Pictures, Sound, Video, and Animation Effects (LO4)1 Week Topic 11.1 Inserting Graphics from Clip Art and Picture Collections
Topic 11.2 Inserting a SmartArt Graphic
Topic 11.3 Converting Text to SmartArt and Inserting WordArt Topic 11.4 Creating a Chart on a Slide
Topic 11.5 Drawing Shapes and Adding Text Boxes Topic 11.6 Adding Video to a Presentation
Topic 11.7 Adding Sound to a Presentation
Topic 11.8 Adding Transitions and Animation Effects to a Slide Show Topic 11.9 Set Up a Self-Running Presentation
Part II-Chapter 12: Using and Querying an Access Database (LO4) 1 Week Topic 12.1 Understanding Database Objects and Terminology
Topic 12.2 Adding Records Using a Datasheet
Topic 12.3 Editing and Deleting Records in a Datasheet Topic 12.4 Adding, Editing, and Deleting Records in a Form
Topic 12.5 Finding and Replacing Date and Adjusting Column Widths Topic 12.6 Sorting and Filtering Records
Topic 12.7 Creating a Query Using the Simple Query Wizard Topic 12.8 Creating a Query Using Design View
Topic 12.9 Entering Criteria to Select Records in a Query
Topic 12.10 Entering Multiple Criteria to Select Records and Sorting A Query Topic 12.11 Creating A Calculated Field in a Query and Previewing a Datasheet Part II- Chapter 13: Creating a Table, Form, and Report in Access (LO4) 1 Week
Topic 13.1 Creating a New Database File and Understanding Table Design Guidelines Topic 13.2 Creating a New Table
Topic 13.3 Creating a New Table in Design View and Assigning a Primary Key Topic 13.4 Adding fields to an Existing Table
Topic 13.5 Modifying Field Properties in Design View Topic 13.6 Creating a Lookup List
Topic 13.8 Creating and Editing a Form
Topic 13.9 Creating, Editing, and Viewing a Report
Topic 13.10 Compacting, Repairing, and Backing Up a Database
Part II-Chapter 14: Integrating Word, Excel, PowerPoint, and Access Components (LO7) 1 Week Topic 14.1 Importing Excel Worksheet Data into Access
Topic 14.2 Exporting an Access Query to Excel
Topic 14.3 Embedding an Excel Chart into a Word Document
Topic 14.4 Embedding Excel Data into and Editing the Data in a PowerPoint Presentation Topic 14.5 Linking an Excel Chart with a Presentation and Updating Links
Part II-Chapter 15: Using Windows Live SkyDrive and Other Cloud Computing Technologies (LO6) 1 Week
Topic 15.1 Creating a Document Using Microsoft Word Web App Topic 15.2 Creating a Worksheet Using Microsoft Excel Web App Topic 15.3 Creating a Presentation Using Microsoft PowerPoint Web App Topic15.4 Editing a Presentation in Microsoft PowerPoint Web App Topic 15.5 Downloading and Uploading files from and to SkyDrive Topic 15.6 Sharing a File on SkyDrive
Topic 15.7 Creating a Document Using Google Docs Final Exam Schedule—Mrs. Boyd Spring 2015
1305.01—MW 8 a.m.— Monday, May 11, 2015, 8:00-10:00 a.m.
1305.02—MW 9:35 a.m.—Wednesday, May 13, 2015, 10:15 a.m.—12:15 p.m. 1305.06—MW 11:10 a.m.—Monday, May 11, 2015, 10:15 a.m.—12:15 p.m. 1305.04—TR 11:10 a.m.—Tuesday, May 12, 2015, 10:15 a.m.—12:15 p.m. 1305.09—TR 1 p.m.—Thursday, May 14, 2015, 1-3 p.m.
10
X.
COURSE SCHEDULE
The class meets for two hours lecture and two hours lab per week. This is a tentative Schedule. Week 1
Jan 20-23
Introduction to Class, and registration to web-based account (SNAP), and pretest. Part I Chapter 1 (Living in a Digital World) and Part I Chapter 3 (Computer Hardware)
Week 2 Jan 26-30
Part I Chapter 2 (Exploring the World Using the Internet) and Part 2 Chapter 2 (Navigating and Searching the Web
Week 3 Feb 2-6
Part I Chapter 4 (The Operating System and Utility Programs) and Part II Chapter 1 ( Using Windows 8 and Managing Files)
Week 4 Feb 9-13
Part I Chapter 5 (Application Software) and Part II Chapter 3 (Exploring Microsoft Office 2013 Essentials)
Week 5 Feb 16-20
Part I Chapter 6 (Using social Media to Connect and Communicate), Chapter 7 (computer Security and Privacy), and Part II Chapter 15 (Using Windows Live SkyDrive and Other Cloud Computing Technologies)
Week 6 Feb23-27
1st Major Exam (Concepts—Part I Chapters 1-7 and Part II Chapters 1, 2, 3, and 15). Part II Chapter 6(Creating, Editing, and Formatting Documents Using Word)
Week 7 Mar 2-6
Part II Chapter 6(Creating, Editing, and Formatting Documents Using Word) and Chapter 7 (Enhancing a document with Special Features) Week 8 Mar 9-13 SPRING BREAK Week 9 Mar 16-20
Part II Chapter 7 (Enhancing a document with Special Features) and Word Major Exam
Week 10 Mar 23-27
Part II Chapter 8 (Creating, Editing, and Formatting Worksheets Using Excel)
Week 11 Mar 30-Apr 3
Part II Chapter 9 (Working with Functions, Charts, Tables, and Page Layout Options in Excel)
Week 12 Apr 6-10
Excel Major Exam and Part II Chapter 10 (Creating, Editing, and Formatting a Presentation Using PowerPoint)
Week 13 Apr 13-17
Part II Chapter 10 (Creating, Editing, and Formatting a Presentation Using PowerPoint) and Chapter 11 (Enhancing a Presentation with Pictures, Sound, Video, and Animation Effects)
April 17 Last Day to Drop with a “W”. Week 14
Apr 20-24
PowerPoint Major Exam and Part II Chapter 12 (Using and Querying an Access Database)
Week 15 Apr 27-May 1
Part II Chapter 13 (Creating a Table, Form, and Report in Access) and Access Major Exam
May 4-8 Components) and Integration Major Exam Week 17
May 11-15
Final Exams (See Cisco College Final Exam Schedule for Specific Exam Date and Time)
XI.
SYLLABUS REQUIREMENTS
All course syllabi must contain the following statements from the Faculty Handbook: Course Content. College-level courses may include controversial, sensitive, and/or adult material. Students are expected to have the readiness for college-level rigor and content. Academic Integrity. It is the intent of Cisco College to foster a spirit of complete
honesty and a high standard of integrity. The attempt of students to present as their own any work they have not honestly performed is regarded by the faculty and administration as a serious offense and renders the offender liable to serious consequences, possibly suspension. (If caught cheating in my class, first offense, you will be dropped from the class.)
Student Conduct. Students are expected to take responsibility in helping to maintain a classroom environment that is conducive to learning. In order to assure that all students have the opportunity to gain from the time spent in class, students are prohibited from using cell phones or beepers or IPods, making offensive remarks, reading material not related to class, sleeping, or engaging in any other form of distraction. Inappropriate behavior in the classroom shall result, at a minimum, in a request to leave class. A more detailed list of inappropriate behaviors is found in the current student handbook.
Student Technology Use in Classroom Policy.
Option 1: Students should silence all communication devices, which include but are not limited to phones, pagers, recorders, palm devices, and laptops. No communications devices should be visible on desks during class unless otherwise directed by the instructor as part of a class activity or approved by the instructor for note-taking. An exception to this policy may occur due to college-wide emergency notification. If a pressing situation requires communication during class, notify the instructor before class begins, sit near the door and quietly exit the classroom before answering any communication. In testing situations, use of any communications, electronic, or data storage device for a reason other than college emergencies or a use specified by the instructor, may lead to a charge of academic dishonesty.
Changes to the Syllabus. The schedule and procedures in the syllabus are subject to change if deemed appropriate by the instructor.
Students with Special Needs. Students who qualify for specific accommodations under the Americans with Disabilities Act (ADA) should notify the instructor the first week of class. It is the student’s responsibility to provide the necessary documentation to the Special Populations Coordinator.
CISCO COLLEGE
BUSINESS COMPUTER INFORMATION SYSTEMS
101 College Heights
CISCO, TX 76437
717 East Industrial Blvd
Abilene, TX 79602
BCIS 1305
Sections .56, .57, .59, .03, 09
BUSINESS COMPUTER APPLICATIONS
(3 hours credit)
SPRING 2015
INSTRUCTOR
:
Tianay Bralley
OFFICE
:
Room 32A, Vocational Technical #1-Cisco; Room 148-Abilene
OFFICE PHONE
:
(Office) 254-442-5154--Cisco
SCHOOL E-mail
[email protected]
OFFICE HOURS
:
Monday, Wednesday—9:00 a.m.-9:30 a.m. (Abilene—Room 148)
Tuesday, Thursday—11:00 a.m.-1:00 p.m. (Cisco)
I.
COURSE TITLE AND NUMBER
Business Computer Applications – BCIS 1305 (Credit: 3 semester hours)
II.
TEXTBOOK
Computer Concepts & Microsoft Office 2013 by Denise Seguin, Paradigm Publishing, Inc. with Student Resources CD (provided with textbook)
Other Requirements:
Access to a Computer with Windows 7 OR Windows 8, Microsoft Office 2013, and Internet connection.
SNAP Training and Assessment for MS Office 2013, (snap2013.emcp.com) Storage media such as a Jump Drive, flash drive, USB drive.
Folder with brads for Class Handouts
III.
COURSE STRUCTURE
SECTION CLASS TIME CLASS DAYS ROOM Section 56 9:35 a.m.—11:00 a.m. MW 148 Section 57 11:10 a.m.—12:35 p.m. MW 148 Section 59 1:00 a.m.—2:25 p.m. MW 148 Section 03 8:00 a.m.—9:25 a.m. TR 34 Section 09 9:35 a.m.—11:00 a.m. TR 34
IV.
COURSE DESCRIPTION
Students will study computer terminology, hardware, and software related to the business environment. The focus of this course is on business productivity software applications and professional behavior in computing, including word processing (as needed), spreadsheets, databases, presentation graphics, and business-oriented utilization of the Internet.
V.
LEARNING OUTCOMES
(ACGM – Spring 2014)
Upon successful completion of this course, students will:1. Describe the fundamentals of Information Technology (IT) infrastructure components: hardware, software, and data communications systems. (LO1)
2. Explain the guiding principles of professional behavior in computing. (LO2)
3. Demonstrate proper file management techniques to manipulate electronic files and folders in a local and networked environment. (LO3)
4. Use business productivity software to manipulate data and find solutions to business problems. (LO4)
5. Explain the concepts and terminology used in the operation of application systems in a business environment. (LO5)
6. Identify emerging technologies for use in business applications. (LO6)
7. Complete projects that integrate business software applications. (LO7)
VI.
CORE OBJECTIVES
This course meets the Core Objectives of Critical Thinking, Communications Skills, and
Empirical & Quantitative Skills for the Foundational Component Area of the Institutional Option as approved by Cisco College.
BCIS 1305 is foundational course in which students learn basic and intermediate features of the programs in the Microsoft Office Professional 2013 suite as well as the basics of Windows 8, the operating system. It emphasizes the Core Objective of Empirical & Quantitative Skills in the Excel and Access application areas. In Excel the students create worksheets to enter formulas, and functions. Students perform logical test calculations and use goal seek to use what-if analysis for different scenarios. In Access students perform calculations and calculate statistics in queries. The Core Objective of Critical Thinking is demonstrated in the Word, Excel, Access, and PowerPoint applications. Students are required to complete assignments from the textbook and the web-based portion of the course and make decisions about formatting, style, formulas, and other decisions necessary to have a finished document. Students are required to use written and oral communications in Word, Excel, Access, and PowerPoint to meet the Core Objective of Communication Skills.
3
VII.
COURSE REQUIREMENTS
Pre-requisites:BCIS 1305 does not have any pre-requisites. Computer Lab:
Since BCIS 1305 consists of two lecture hours and two lab hours per week with only 3 contact hours per week of class, students are expected to spend 1 hour per week at a computer working on course assignments. Computer labs are located in the library in Cisco and Room 157 in Abilene.
Attendance policy:
Prompt and regular class attendance is considered necessary for satisfactory work. It is the responsibility of the professor to keep an accurate and comprehensive record of attendance. Cisco College recognizes that absence from class may occur due to illness, death or illness in the immediate family, observance of a religious holiday, or participation in a college-sponsored activity. (Absences due to participation in a college-sponsored activity must be authorized by the Vice President of Instruction.) When absences occur due to the above-stated reasons, the student is allowed to make up work missed; the professor may require the work to be made up within two weeks from its original due date. During a regular Fall or Spring semester, the following
requirements apply for face-to-face classes. For a class that meets three times per week, a student is allowed six absences. For a class that meets two times per week, a student is allowed four absences. For a class that meets one time per week, a student is allowed two absences. If a student misses one more than the allowed number of absences, he/she may be dropped from the class if the professor deems the student to be failing due to excessive absences and/or failure to make up work due to absences.
For online or hybrid courses, a student may be dropped after he/she fails to access the course web site and/or participate in the class for a two-week period, and the professor deems the student to be failing.
During a Summer I or II regular face-to-face class, a student is allowed two absences. Upon the third absence, he/she may be dropped from the class if the professor deems the student to be failing due to excessive absences and/or failure to make up work due to absences. For any Minimester or Summer night class, a student is allowed one absence. Upon the second absence, he/she may be dropped from the class if the professor deems the student to be failing due to excessive absences and/or failure to make up work due to absences.
Any student who ceases to attend class without officially withdrawing through the Admissions Office is subject to a grade of “F”. The student will receive a grade of “W” for the course if withdrawn before the “last day to drop with a “W”, and an “F” if withdrawn after “the last day to drop with a “W”. Three tardies may constitute an absence.
Absence Policy and Make-up Work:
Cisco College recognizes that absences from class may occur due to illness, death, or illness in the immediate family, observance of a religious holiday, or participation in a College-sponsored activity. (Absences due to participation in a College-sponsored activity must be authorized by the appropriate administrator.) When absences occur due to the above, the student is allowed to make up work missed; the instructor may require the work to be made up within two weeks.
Assignments will not be accepted after the due date. The final exam will be substituted for ONLY one missed exam or lowest exam grade.
VIII.
COURSE ASSESSMENT
Grading Policy:The final semester letter grade will be based on the following range:
90-100 A
80-89 B
70-79 C
60-69 D
Below 60 F
COURSE EVALUATION
Class assignments (Textbook and SNAP) 15%
Exams: 70%
Concepts Exam—Part I Chapters 1-7 and Part II Chapters 1, 2, 3, and 15 Word Exam—Part II Chapters 6 and 7
Excel Exam—Part II Chapters 8 and 9
PowerPoint Exam—Part II Chapters 10 and 11 Access Exam—Part II Chapters 12 and 13 Integration Exam—Part II Chapter 14
Final Exam 15%
Individual grades are reported for specific assignments in SNAP and Canvas. The gradebook in SNAP and Canvas are not combined and therefore do not represent a cumulative grade. Grade are combined in the professor’s gradebook.
Pre- & Post-Tests:
A department pre-test will be given on the first day of class. The pre-test will not count toward a student’s grade in the course. A department post-test will be given as part of the final exam at the end of the course and will count 25% of the final exam grade. Items on the pre- and post-test are designed to measure the Course Goals and Objectives, Course Level Outcomes, and Core Objectives of the Core Curriculum at the program level.
IX.
COURSE TEXTBOOK OUTLINE
The course covers the following chapters and sections of the text: Part I COMPUTER CONCEPTS
Part I-Chapter 1: Living in a Digital World (LO1), (LO2, Ethics Projects) 1 Week Topic 1.1 Personal Computers
Topic 1.2 Mobile Devices, Wearable Computers, and Embedded Computers Topic 1.3 Computers for Connection Multiple Users and Specialized Processing
5
Topic 1.4 Computer Innovations and Converging Technologies Topic 1.5 Information Technology and Information Processing Cycle Topic 1.6 Cloud Computing
Topic 1.7 Green Computing
Topic 1.8 Computers and Your Health
Part I-Chapter 2: Exploring the World Using the Internet (LO1), (LO2, Ethics Project) 1 Week Topic 2.1 Networks, the Internet, and the World Wide Web
Topic 2.2 Connecting to the Internet Topic 2.3 Popular Web Browsers
Topic 2.4 Understanding Internet and Web Addresses and Navigation Web Pages Topic 2.5 Searching the Web
Topic 2.6 Evaluation Web Content
Topic 2.7 Popular Web Plug-ins and Players for Multimedia Content
Topic 2.8 E-Commerce, Messaging, and Internet Telephone and Conferencing Options Part I-Chapter 3: Computer Hardware (LO1), (LO2, Ethics Projects) 1 Week
Topic 3.1 The System Unit Topic 3.2 Input Devices Topic 3.3 Output Devices Topic 3.4 Network Adapters Topic 3.5 Digital Data Topic 3.6 Storage Options
Part I-Chapter 4: The Operating System and Utility Programs (LO1), (LO2, Ethics Project), (LO5) 1 Week
Topic 4.1 Introduction to the Operating System (OS) and the OS Functions Topic 4.2 Popular Operating Systems for Computer Systems
Topic 4.3 Popular Operating Systems for Mobile Devices
Topic 4.4 Embedded Operating Systems and Cloud Operating Systems Topic 4.5 Utilities in Your OS Package for Maintaining System Performance Topic 4.6 Using Operating System Tools to Troubleshoot Computer Problems
Part I-Chapter 5 Application Software (LO1), (LO2, Ethics Projects) 1 Week Topic 5.1 Productivity Applications for the Workplace
Topic 5.2 Other Workplace-Oriented Productivity Applications
Topic 5.3 Applications for Working with Graphics, Multimedia, and the Web Topic 5.4 Software Applications for Personal Use
Topic 5.5 Cloud and Open Source Applications
Topic 5.6 Acquiring, Installing, Uninstalling, and Upgrading Software Topic 5.7 Mobile Apps
Part I-Chapter 6: Using Social Media to Connect and Communicate (LO1), (LO2, Ethics Projects) 1 Week
Topic 6.1 Social networking Topic 6.2 Social Bookmarking Topic 6.3 Sharing Media Topic 6.4 Blogging
Topic 6.5 Wikis for User-Generated Content Topic 6.6 Social Media Strategies in Business
Part I-Chapter 7: Computer Security and Privacy (LO1), (LO2, Ethics Projects) 1 Week Topic 7.1 Unauthorized Access and Unauthorized Use of Computer Resources
Topic 7.2 Botnets and Denial of Service Attacks Topic 7.3 Malware Infections
Topic 7.4 Phishing, Pharming, and Clickjacking Threats Topic 7.5 Information Privacy
Topic 7.6 Mobile Device Security
Part II COMPUTER APPLICATION WITH MICROSOFT OFFICE 2013
Part II-Chapter 1: Using Windows 8 and Managing Files (LO3) 1 Week Topic 1.1 Using Touch, Mouse, and Keyboard Input to Navigate Windows 8
Topic 1.2 Starting Windows 8 and Exploring Apps
Topic 1.3 Revealing the Charms Bar, Searching for an App and Closing Apps Topic 1.4 Locking the Screen, Signing Out, and Shutting Down Windows 8 Topic 1.5 Customizing the Start Screen
Topic 1.6 Personalizing the Start and Lock Screens Topic 1.7 Using the Desktop
Topic 1.8 Browsing Files and File Explorer
Topic 1.9 Creating Folders and Copying Files and Folders
Topic 1.10 Moving, Renaming, and Deleting Files and Folders, and Ejecting a USB Flash Drive
Topic 1.11 Finding Help in Windows
Part II-Chapter 2: Navigating and Searching the Web (LO4) 1 Week Topic 2.1 Introduction to the Internet and the World Wide Web
Topic 2.2 Navigating the Web Using Internet Explorer 10 Topic 2.3 Navigating the Web Using Google Chrome Topic 2.4 Navigating the Web Using Mozilla Firefox
Topic 2.5 Searching for Information and Printing Web Pages Topic 2.6 Downloading Content from a Web Page
Part II-Chapter 3: Exploring Microsoft Office 2013 Essentials (LO4) 1 Week Topic 3.1 Starting and Switching Programs, Starting a New Presentation, and Exploring the Ribbon Interface
Topic 3.2 Using the Backstage View to Manage Documents Topic 3.3 Customizing and Using the Quick Access Toolbar
Topic 3.4 Selecting Text or Objects, Using the Ribbon and Mini Toolbar, and Selecting Options in Dialog Boxes
Topic 3.5 Using the Office Clipboard
Topic 3.6 Finding Help in an Office Program
Topic 3.7 Using SkyDrive for Storage, Scrolling in Documents, and Using Undo Topic 3.8 Changing Display Options
Part II-Chapter 4: Organizing and Managing Class Notes Using OneNote (Optional) Part II-Chapter 5: Communicating and Scheduling Using Outlook (Optional)
Part II-Chapter 6: Creating, Editing, and Formatting Documents Using Word (LO4) 1 Week Topic 6.1 Creating and Editing a New Document
Topic 6.2 Inserting Symbols and Completing a Spelling and Grammar Check Topic 6.3 Finding and Replacing Text
Topic 6.4 Moving Text and Inserting Bullets and Numbering
Topic 6.5 Formatting Text with Font and Paragraph Alignment Options Topic 6.6 Indenting Text and Changing Line and Paragraph Spacing Topic 6.7 formatting Using Styles
Topic 6.8 Creating a New Document from a Template
Part II- Chapter 7: Enhancing a Document with Special Features (LO4) 1 Week Topic 7.1 Inserting, Editing, and Labeling Images in a Document
7
Topic 7.2 Adding Borders and Shading and Inserting a Text Box Topic 7.3 Inserting a Table
Topic 7.4 Formatting and Modifying a Table Topic 7.5 Changing Page Layout Options
Topic 7.6 Formatting a Research Paper with a Header and Page Numbers Topic 7.7 Inserting and Editing Citations
Topic 7.8 Creating a Works Cited Page and Using Word Views Topic 7.9 Inserting and Replying to Comments
Topic 7.10 Creating a Resume and Cover Letter from Templates
Part II-Chapter 8: Creating, Editing, and Formatting Worksheets Using Excel (LO4) 1 Week Topic 8.1 Creating and Editing a New Worksheet
Topic 8.2 Formatting Cells
Topic 8.3 Adjusting Column Width and Row Height, and Changing Alignment Topic 8.4 Entering or Copying Data with the Fill Command and Using AutoSum Topic 8.5 Inserting and Deleting Rows and Columns
Topic 8.6 Sorting and Applying Cell Styles
Topic 8.7 Changing Orientation and Scaling and Displaying Cell Formulas
Topic 8.8 Inserting and Renaming a Worksheet, Copying Cells, and Indenting Cells Topic 8.9 Using Go To, Freezing Panes, and Shading, Wrapping, and Rotating Cell Entries
Part II-Chapter 9: Working with Functions, Charts, Tables, and Page Layout Options in Excel (LO4) 1 Week Topic 9.1 using Absolute Addressing and Range Names in Formulas
Topic 9.2 Entering Formulas Using Statistical Functions Topic 9.3 Entering, Formatting, and Calculating Dates Topic 9.4 Using the IF Function
Topic 9.5 Using the PMT Function
Topic 9.6 Creating and Modifying a Pie Chart Topic 9.7 Creating and Modifying a Column Chart Topic 9.8 Creating and Modifying a Line Chart
Topic 9.9 Using Page Layout View, Adding a Header, and Changing Margins Topic 9.10 Creating and Modifying Sparklines and Inserting Comments Topic 9.11 Working with Tables
Part II-Chapter 10: Creating, Editing, and Formatting Presentation Using PowerPoint (LO4) 1 Week Topic 10.1 Creating a New Presentation and Inserting Slides
Topic 10.2 Changing the Theme and Inserting and Modifying a Table Topic 10.3 Formatting Text with Font and Paragraph Options
Topic 10.4 Selecting, Resizing, Aligning, and Moving Placeholders
Topic 10.5 Using Slide Sorter View and Moving, Duplicating, and Deleting Slides Topic 10.6 Modifying the Slide Master
Topic 10.7 Adding Notes and Comments Topic 10.8 Displaying a Slide Show
Topic 10.9 Preparing Audience Handouts and Speaker Notes
Part II-Chapter 11: Enhancing a Presentation with Pictures, Sound, Video, and Animation Effects (LO4)1 Week Topic 11.1 Inserting Graphics from Clip Art and Picture Collections
Topic 11.2 Inserting a SmartArt Graphic
Topic 11.3 Converting Text to SmartArt and Inserting WordArt Topic 11.4 Creating a Chart on a Slide
Topic 11.5 Drawing Shapes and Adding Text Boxes Topic 11.6 Adding Video to a Presentation
Topic 11.8 Adding Transitions and Animation Effects to a Slide Show Topic 11.9 Set Up a Self-Running Presentation
Part II-Chapter 12: Using and Querying an Access Database (LO4) 1 Week Topic 12.1 Understanding Database Objects and Terminology
Topic 12.2 Adding Records Using a Datasheet
Topic 12.3 Editing and Deleting Records in a Datasheet Topic 12.4 Adding, Editing, and Deleting Records in a Form
Topic 12.5 Finding and Replacing Date and Adjusting Column Widths Topic 12.6 Sorting and Filtering Records
Topic 12.7 Creating a Query Using the Simple Query Wizard Topic 12.8 Creating a Query Using Design View
Topic 12.9 Entering Criteria to Select Records in a Query
Topic 12.10 Entering Multiple Criteria to Select Records and Sorting A Query Topic 12.11 Creating A Calculated Field in a Query and Previewing a Datasheet Part II- Chapter 13: Creating a Table, Form, and Report in Access (LO4) 1 Week
Topic 13.1 Creating a New Database File and Understanding Table Design Guidelines Topic 13.2 Creating a New Table
Topic 13.3 Creating a New Table in Design View and Assigning a Primary Key Topic 13.4 Adding fields to an Existing Table
Topic 13.5 Modifying Field Properties in Design View Topic 13.6 Creating a Lookup List
Topic 13.7 Displaying and Editing a Relationship Topic 13.8 Creating and Editing a Form
Topic 13.9 Creating, Editing, and Viewing a Report
Topic 13.10 Compacting, Repairing, and Backing Up a Database
Part II-Chapter 14: Integrating Word, Excel, PowerPoint, and Access Components (LO7) 1 Week Topic 14.1 Importing Excel Worksheet Data into Access
Topic 14.2 Exporting an Access Query to Excel
Topic 14.3 Embedding an Excel Chart into a Word Document
Topic 14.4 Embedding Excel Data into and Editing the Data in a PowerPoint Presentation Topic 14.5 Linking an Excel Chart with a Presentation and Updating Links
Part II-Chapter 15: Using Windows Live SkyDrive and Other Cloud Computing Technologies (LO6) 1 Week
Topic 15.1 Creating a Document Using Microsoft Word Web App Topic 15.2 Creating a Worksheet Using Microsoft Excel Web App Topic 15.3 Creating a Presentation Using Microsoft PowerPoint Web App Topic15.4 Editing a Presentation in Microsoft PowerPoint Web App Topic 15.5 Downloading and Uploading files from and to SkyDrive Topic 15.6 Sharing a File on SkyDrive
Topic 15.7 Creating a Document Using Google Docs Final Exam Schedule—Mrs. Bralley Spring 2015
1305.56—MW 9:35 a.m.— Wednesday, May 13, 2015, 10:15 a.m.—12:15 p.m. 1305.57—MW 11:10 a.m.—Monday, May 11, 2015, 10:15 a.m.—12:15 p.m. 1305.59—MW 1:00 p.m.—Wednesday, May 13, 2015, 1:00 p.m.—3:00 p.m.- 1305.03—TR 8:00 a.m.—Tuesday, May 12, 2015, 8:00 a.m.—10:00 a.m. 1305.09—TR 9:35 a.m.—Thursday, May 14, 2015, 10:15 a.m.—12:15 p.m.
9
X.
COURSE SCHEDULE
The class meets for two hours lecture and two hours lab per week. This is a tentative Schedule. Week 1
Jan 20-23
Introduction to Class, and registration to web-based account (SNAP), and pretest. Part I Chapter 1 (Living in a Digital World) and Part I Chapter 3 (Computer Hardware)
Week 2 Jan 26-30
Part I Chapter 2 (Exploring the World Using the Internet) and Part 2 Chapter 2 (Navigating and Searching the Web
Week 3 Feb 2-6
Part I Chapter 4 (The Operating System and Utility Programs) and Part II Chapter 1 ( Using Windows 8 and Managing Files)
Week 4 Feb 9-13
Part I Chapter 5 (Application Software) and Part II Chapter 3 (Exploring Microsoft Office 2013 Essentials)
Week 5 Feb 16-20
Part I Chapter 6 (Using social Media to Connect and Communicate), Chapter 7 (computer Security and Privacy), and Part II Chapter 15 (Using Windows Live SkyDrive and Other Cloud Computing Technologies)
Week 6 Feb23-27
1st Major Exam (Concepts—Part I Chapters 1-7 and Part II Chapters 1, 2, 3, and 15). Part II Chapter 6(Creating, Editing, and Formatting Documents Using Word)
Week 7 Mar 2-6
Part II Chapter 6(Creating, Editing, and Formatting Documents Using Word) and Chapter 7 (Enhancing a document with Special Features) Week 8 Mar 9-13 SPRING BREAK Week 9 Mar 16-20
Part II Chapter 7 (Enhancing a document with Special Features) and Word Major Exam
Week 10 Mar 23-27
Part II Chapter 8 (Creating, Editing, and Formatting Worksheets Using Excel)
Week 11 Mar 30-Apr 3
Part II Chapter 9 (Working with Functions, Charts, Tables, and Page Layout Options in Excel)
Week 12 Apr 6-10
Excel Major Exam and Part II Chapter 10 (Creating, Editing, and Formatting a Presentation Using PowerPoint)
Week 13 Apr 13-17
Part II Chapter 10 (Creating, Editing, and Formatting a Presentation Using PowerPoint) and Chapter 11 (Enhancing a Presentation with Pictures, Sound, Video, and Animation Effects)
April 17 Last Day to Drop with a “W”. Week 14
Apr 20-24
PowerPoint Major Exam and Part II Chapter 12 (Using and Querying an Access Database)
Week 15 Apr 27-May 1
Part II Chapter 13 (Creating a Table, Form, and Report in Access) and Access Major Exam
Week 16 May 4-8
Part II Chapter 14 (Integrating Word, Excel, PowerPoint, and Access Components) and Integration Major Exam
Week 17 May 11-15
Final Exams (See Cisco College Final Exam Schedule for Specific Exam Date and Time)
XI.
SYLLABUS REQUIREMENTS
All course syllabi must contain the following statements from the Faculty Handbook: Course Content. College-level courses may include controversial, sensitive, and/or adult material. Students are expected to have the readiness for college-level rigor and content. Academic Integrity. It is the intent of Cisco College to foster a spirit of complete
honesty and a high standard of integrity. The attempt of students to present as their own any work they have not honestly performed is regarded by the faculty and administration as a serious offense and renders the offender liable to serious consequences, possibly suspension. (If caught cheating in my class, first offense, you will be dropped from the class.)
Student Conduct. Students are expected to take responsibility in helping to maintain a classroom environment that is conducive to learning. In order to assure that all students have the opportunity to gain from the time spent in class, students are prohibited from using cell phones or beepers or IPods, making offensive remarks, reading material not related to class, sleeping, or engaging in any other form of distraction. Inappropriate behavior in the classroom shall result, at a minimum, in a request to leave class. A more detailed list of inappropriate behaviors is found in the current student handbook.
Student Technology Use in Classroom Policy.
Option 1: Students should silence all communication devices, which include but are not limited to phones, pagers, recorders, palm devices, and laptops. No communications devices should be visible on desks during class unless otherwise directed by the instructor as part of a class activity or approved by the instructor for note-taking. An exception to this policy may occur due to college-wide emergency notification. If a pressing situation requires communication during class, notify the instructor before class begins, sit near the door and quietly exit the classroom before answering any communication. In testing situations, use of any communications, electronic, or data storage device for a reason other than college emergencies or a use specified by the instructor, may lead to a charge of academic dishonesty.
Changes to the Syllabus. The schedule and procedures in the syllabus are subject to change if deemed appropriate by the instructor.
Students with Special Needs. Students who qualify for specific accommodations under the Americans with Disabilities Act (ADA) should notify the instructor the first week of class. It is the student’s responsibility to provide the necessary documentation to the Special Populations Coordinator.
CISCO COLLEGE
Computer Business Applications
BCIS 1305.E1 Online
Spring 2015
Michael Hitt – Instructor
Contact Information
Email:
[email protected]
(Canvas email program preferred)
Canvas:
https://ciscocollege.instructure.com/login
(Course syllabus, assignments, messages, etc.)
Office: Not available on campus during semester
Phone: Not available by phone
Communications to the instructor for this course will be through Canvas only. No other email sites will
be monitored. To get a prompt response, please use Canvas. All your questions can be answered by
contacting the instructor thru the Canvas’s message feature. Course messages are like most email
programs. I will not be available on campus to answer questions and I do not have a phone on campus or
off campus that I can be reached.
Textbook
Computer Concepts & Micosoft Office 2013 by Denise Seguin, Paradigm Publishing. (SNAP is packaged with
the text if purchased from Cisco College bookstore. You must have SNAP to take exams and complete
assignments.
Other Requirements:
Storage media such as a Jump drive, Flash drive, USB drive. (use as backup for your
assignments)
SNAP Training and Assessment account for MS Office 2013, SNAP2013 is packaged with
textbook if purchased from Cisco College bookstore.
SNAP is required for the course.
SNAP Enrollment Key is the text:
woken-flips
.
Reliable computer with internet access (DSL recommended).
A reliable Windows based computer with Windows 7, or 8. Sorry, Mac’s are not adequate for
the course.
Office 365 University (for Windows PC based computers) is required for course. (Make
sure it includes Word, Excel, Access, and PowerPoint).
It is available by download from
Microsoft.com or purchased elsewhere for college students at a reasonable cost of about $99
.
You may already have the software installed that is needed (Word, Excel, Access, and
PowerPoint). Check to see if it has Access. Versions of Office like 2010 or earlier will not work
adequately for this course.
Check out the hardware and browser requirements for Canvas and SNAP at their respective
websites to see if your computer is supported.
Course Description
Students will study computer terminology, hardware, and software related to the business environment. The
focus of this course is on business productivity software applications and professional behavior in computing,
including word processing (as needed), spreadsheets, databases, presentation graphics, and business-oriented
utilization of the Internet. Two lecture hours per week. Credit: 3 semester hours.
Course Structure
Online Class
Learning Outcomes
(ACGM – Spring 2014)
Upon successful completion of this course, students will:
1.
Describe the fundamentals of Information Technology (IT) infrastructure components:
hardware, software, and data communications systems. (LO1)
2.
Explain the guiding principles of professional behavior in computing. (LO2)
3.
Demonstrate proper file management techniques to manipulate electronic files and folders in
a local and networked environment. (LO3)
4.
Use business productivity software to manipulate data and find solutions to business
problems. (LO4)
5.
Explain the concepts and terminology used in the operation of application systems in a
business environment. (LO5)
6.
Identify emerging technologies for use in business applications. (LO6)
7.
Complete projects that integrate business software applications. (LO7)
CORE OBJECTIVES
This course meets the Core Objectives of Critical Thinking, Communications Skills, and Empirical &
Quantitative Skills for the Foundational Component Area of the Institutional Option as approved by
Cisco College.
BCIS 1305 is foundational course in which students learn basic and intermediate features of the
programs in the Microsoft Office suite as well as the basics of Windows 8, the operating system. It
emphasizes the Core Objective of Empirical & Quantitative Skills in the Excel and Access application
areas. In Excel the students create worksheets to enter formulas, and functions. Students perform logical
test calculations and use goal seek to use what-if analysis for different scenarios. In Access students
perform calculations and calculate statistics in queries. The Core Objective of Critical Thinking is
demonstrated in the Word, Excel, Access, and PowerPoint applications. Students are required to
complete assignments from the textbook and the web-based portion of the course and make decisions
about formatting, style, formulas, and other decisions necessary to have a finished document. Students
are required to use written and oral communications in Word, Excel, Access, PowerPoint, and to meet
the Core Objective of Communication Skills.
COURSE REQUIREMENTS
Pre-requisites:
3
Online Attendance Policy
Online presence includes but is not limited to completing textbook chapter labs, completing SNAP
assignments, and discussions assignments, reading and studying the text material, taking major exams
and the final at the scheduled times, and following instructions.
Students must login to Canvas each
day to check for assignment and exam due dates and messages about the course.
A student that
fails to have a Canvas and SNAP 2013 online presence for more than two (2) weeks will be
dropped!
Any student who ceases to attend class without officially withdrawing through the Admissions Office is
subject to a grade of “F”. The student will receive a grade of “W” for the course if withdrawn before the
“last day to drop with a “W”, and an “F” if withdrawn after “the last day to drop with a “W”. Last day to
drop class with a “W” for the spring 2015 semester will be Friday, April 17 by 2:00 pm.
COURSE ASSESSMENT
Grading Policy:The final semester letter grade will be based on the following range:
90-100
A
80-89
B
70-79
C
60-69
D
Below 60
F
COURSE EVALUATION
Textbook, SNAP, and discussion Assignments (see Canvas for posted assignments)
15%
Major Exams:
70%
Part I – Computer Concepts
Computer Concepts Exam I
(Chapters 1-7)
Part II – Computer Applications with Microsoft Office 2013
Computer Applications Exam II
(Chapters 1, 2, & 3)
Word Exam III
(Chapters 6 & 7)
Excel Exam IV
(Chapters 8 & 9)
PowerPoint Exam V
(Chapters 10 & 11)
Access Exam VI
(Chapters 12 & 13)
Final Exam
15%
Pre- & Post-Test
A department pre-test will be given on the first day of class. The pre-test will not count toward
student’s grade in the course. A department post-test will be given as part of the final exam at the
end of the course and will count 25% of the final exam grade. Items on the pre- and post-test are
designed to measure the Course Goals and Objectives, Course Level Outcomes, and Core
objectives of the Core Curriculum at the program level.
Student Contributions
Since this is an online class, it is the responsibility of the student to check Canvas and SNAP daily for
important information and instructions from the instructor, to take major exams at the scheduled times, and
complete textbook, SNAP, discussion assignments on time. Since there are no “formal” class-meetings, students
must be very self-disciplined and spend time on the course each day. Expect to spend 6 hours or more per week
reading and studying the textbook material, completing textbook and SNAP assignments, responding to the
instructor’s messages, and preparing for major exams and the final. It is of the utmost importance that students
stay current with their assignments and turn them in on time. DON’T WAIT UNTIL THE LAST DAY TO
COMPLETE YOUR ASSIGNMENTS!!!!! Spend Time On The Course Each Day!!!
COURSE TEXTBOOK OUTLINE
The course covers the following chapters and sections of the text:
Part I COMPUTER CONCEPTS
Part I-Chapter 1: Living in a Digital World (LO1), (LO2, Ethics Projects) k
