MABS 101 Spreadsheets/Excel

Welcome to MABS 101. In this course we will use Excel, an industry leading spreadsheet program. Learning how to use Excel is an investment in both your academic and professional career. Upon completion of this course, you will become proficient in this flexible and powerful software which is widely used in multiple industries. In this course you will create a variety of small and large scale solutions for businesses. This program excels in calculations and the ability to highlight select information with charts.

Upon successful completion of this course, students will be able to:

  1. Plan and design an Excel worksheet
  2. Create formulas with multiple operators and range names in Excel
  3. Choose appropriate functions to solve common business problems using Excel
  4. Plan, design, edit and enhance an Excel chart
  5. Design and create Excel macros to automate tasks

Course Information

MABS 101 Spreadsheets for Business/Excel (CRN 79004)

3 Units, fully online (no on-campus meetings required). Canvas Login

Course Duration: Begins: September 3, 2019 Ends: December 20, 2019

Instructor: Allen Fung.

Contact Information:

Email: afung@ccsf.edu (preferred method of Contact)

Course Syllabus

Assignments must be turned in on by the assigned date. Advance notice must be given for late assignments.

Course Description

This course comprises creating, and modifying spreadsheets using Excel software. Includes creating charts, working with advanced functions, database features, and the use of macros.

Upon completion of this course, a student will be able to:

  • Plan and design an Excel worksheet.
  • Create formulas with multiple operators and range names in Excel.
  • Choose appropriate functions to solve common business problems using Excel.
  • Plan, design, edit and enhance an Excel chart.
  • Design and create Excel macros to automate tasks.

Assignments must be turned in on by the assigned date. In a typical week, the Chapter Trainings and Discussions are due by Wednesday, with the other assignments due by Sunday. No late assignments are accepted.

Textbook Bundle and materials

1) The textbook bundle provides a book/ebook and an Access code card to use the courseware in Canvas. You must have an Access code to participate in this course. You have the choice of purchasing the code with a a) printed text or b) electronic text.

a) MABS 101 Excel (Cirrus code, print textbook)

ISBN 9780763888060 Cirrus for Benchmark Series: Microsoft Excel 365 for 2019 Levels 1 & 2 - Access code card and Text (physical) Discounted Unit Price $101.95.

b) MABS 101 Excel (Cirrus digital code only-physical

ISBN 9780763887896 Cirrus for Benchmark Series: Microsoft Excel 365 for 2019 Levels 1 & 2 - Access code

You may purchase this package at the 1. CCSF bookstore or by clicking on the link below to order from the Paradigm publisher. http://paradigm.emcp.com/ccosf-mabs-101.html

Be sure to use one of the Promo Codes listed at the bottom of the web page. (Note the ISBN code for the eText package on the paradigm web page is listed as 978-0-76388-788-9)


2) You must have access to a computer with Microsoft Excel 2019 installed and Internet access. You will be asked to insert your Microsoft ID (from MS Office) prior to using the Cirrus application.

CCSF students can download Office 2019 for free. For information visit http://www.ccsf.edu/en/employee-services/technology-services2/software/msOffice4Students.html (Links to an external site.)Links to an external site.

Evaluation and Grading

Your final grade will be based on the Training, Skills and Assessments and Discussions within the Course Modules. Each assignment has a visible score assigned.

Grading scale:

A = 90% - 100%

B = 80-89%

C = 70-79%

D = 60-69%

F = 0- 59%

Keys to Online Student Success?

Please read and follow written directions carefully. Assignments must be completed each week. This is NOT a self-paced class. Proper time management is essential to completing the assignments. Please schedule regular sessions each week to complete your homework assignments. Most students need approximately 9 hours per week to complete all the assignments.

Access to this Course - Login Instructions

Claim RAM ID and Login to Canvas: Student Guide

Login to Canvas: https://ccsf.instructure.com

Canvas Support

CCSF Online Course Support Center

Canvas Support Hotline (844) 592-2198

Are you new to Online classes?

Click on the link below to view what it takes to be successful online

Tips for Success in Online Classes

Canvas Overview

Paradigm Setup Instructions

    • You must install SNAP/Evergreen to connect your computer’s MS Excel program to the courseware. These videos provide information regarding SNAP installation. Click on the blue box “Getting Started Videos”.
    • Windows Systems requirements are listed on this page..
  • Help is listed on this page. The support number is 1-800-328-1452 (press 2) 6 am – 8 pm Pacific time. EMAIL → Email support@emcp.com for any technical issues

Accommodations

Students who need academic accommodations should request them from the Disabled Students Programs and Services (DSPS) located in the Rosenberg Library, Room 323 on the Ocean Campus.

Telephone: 415-452-5481 (V) 415-452-5451 (TTY).

DSPS is the campus office responsible for verifying disability-related need for academic accommodations, assessing that need, and for planning accommodations in cooperation with students and instructors as needed and consistent with course requirements.


Computer Labs at CCSF

Students enrolled in Business Department courses may use the Business Department Computer Lab located in Cloud 111. Lab hours are posted outside room 111. The lab is a free, non-credit course (COMP 9000) that you must register in to use the lab. Registration forms are available in the lab. Students may also use the Academic Computer Lab in the Rosenberg Library. Visit the Learning Assistance Center (R207) for information and lab hours. (For more information, visit The Learning Assistance Center (Links to an external site.)Links to an external site. website.)

For the Spring 2018 semester, I will be working in the Business Department Computer Lab (Cloud 111) every Monday from 1pm-4pm and Tuesdays from 10am-1pm (except for holidays).

CCSF Rules of Student Conduct

Item # 3: Academic or intellectual dishonesty, such as cheating or plagiarism

Cheating is defined as taking an examination or performing an assigned, evaluated task in a dishonest way, such as by having improper access to answers. Plagiarism is defined as the unauthorized use of the language and thought of another author and representing them as your own.

All work submitted in this class must be your own work. For the consequences of academic dishonesty, refer to the CCSF Rules of Student Conduct (http://www.ccsf.edu/dam/Organizational_Assets/Department/forms/rules_of_student_conduct.pdf (Links to an external site.)Links to an external site.).

Course Information

  • This course consists of 16 modules. Each new module will be released on Mondays.
  • Assignments: Each module consists of multiple assignments and usually a discussion. Assignments are due on two days of the week on Thursdays and Sundays by 11:59 p.m. Please allow extra time for potential upload issues. No assignments will be allowed after the due date and time.

Contact with the Instructor

You can email the me through the Canvas Inbox. I will usually respond within 48 hours on weekdays. Please pay attention to the day of the week each assignment is due. I will also posts replies and tips that may be useful to the entire class in the Discussions section,

Course Schedule

Course Schedule

Content and Description

Level 1

Section 1: Preparing and Formatting Worksheets

Module 1: Preparing an Excel Workbook Week 1: 1/28 2/23

Module 2: Inserting Formulas in a Worksheets Week 2: 2/42/10

Module 3: Formatting a Worksheet Week 3: 2/112/17

Module 4: Enhancing a Worksheet Week 4: 2/182/24

Section 2: Enhancing the Display of Workbooks

Module 5: Moving Data within and between Workbooks Week 5: 2/253/3

Module 6: Maintaining Workbook Week 6: 3/43/10

Module 7: Creating Charts and Inserting Formulas Week 7: 3/113/17

Module 8: Adding Visual Interest to Workbooks Week 8: 3/183/24

Level 2

Section 1: Advanced Formatting, Formulas, and Data Management

Module 1: Advanced Formatting Techniques Week 9: 4/14/7

Module 2: Advanced Functions and Formulas Week 10: 4/84/14

Module 3: Working with Tables and Data Features Week 11: 4/154/21

Module 4: Summarizing and Consolidating Data Week 12: 4/224/28

Section 2: Managing and Integrating Data and the Excel Environment

Module 5: Using Data Analysis Features Week 13: 4/29 - 5/5

Module 6: Protecting and Sharing Workbooks Week 14: 5/6 - 5/12

Module 7: Automating Repetitive Tasks and Customizing Excel Week 15: 5/13 - 5/19

Module 8: Importing, Exporting, and Distributing Data Week 16: 5/205/22