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.