City College of San Francisco
Business Department
MABS 101 – Spreadsheets Using EXCEL
(Tentative Schedule)
Instructor: Terrence Corbie (tcorbie@ccsf.edu)



Click this link for infformation on Student Learning Outcomes

Week # Topics
1

Orientation. Navigating the spreadsheet and menu

2

Simple functions: =SUM, =MAX, =MIN, =AVERAGE, =COUNT/COUNTA. Copying and Moving data, Inserting Rows/Columns, Formatting

Project 1: Budget

3

Absolute vs. Relative, Range Names

Project 2: Sales

4

Printing. Intro. to =IF statements

Project 3: IF Sales

5

Nesting =IF statements

Project 4: Motel

6

=AND, =OR

Project 5: Car Rental

7

Tables (=VLOOKUP/=HLOOKUP),

Project 6: Shipping Cost

8

Tables continued, Simple Sorting

Project 7: LOOKUP MOTEL

9

Midterm Project

10

Dates (=MONTH, =DAY, =YEAR, =WEEKDAY, =TODAY, =NOW)

Project 10: Employee Dates

11

Sorting and Filtering - Lesson 13

12

Text functions (=LEN, =TRIM, =FIND, = UPPER, =LOWER, =MID etc.) Advanced Sorting

Project 11: Customers

13

Goal Seek. Solver. Lesson 9

14

Linking. Protecting your work - Lesson 12

15

What-If Tables and Pivot Tables - Lesson 15

16

Macros. Customizing the tool bar

Project 12: Macro 1

17

Macros Continued

Project 13: Macro 2

18

Final Project

Grading is based on Midterm 33%, Final 33%, assignments 34% (in class or homework)


Office Hours: Online

This class is taught at a fast pace using lectures, overhead projector (on campus classes), and hands-on instructions, and discussions boars (online). The main goal of this class and the approach, is to foster critical thinking. Less focus is placed on following step-by-step instructions in a textbook. No assignments come directly from the book.

 

Textbook: Not required

The textbook YOU choose is for outside reading and is meant to compliment the in-class lectures. Please check the college calendar for important dates such as drops and withdrawals.

The software used is Excel 2016 and is free of charge for all CCSF students.