City College of San Francisco
Business Department
MABS 101 – Spreadsheets Using EXCEL
(Tentative Schedule)
Instructor: Terrence Corbie (tcorbie@ccsf.edu)
Click for textbook information
On Campus classes meet every Monday and Wednesday from 11:00 to 12:30 PM. in room 115 Cloud Hall, Main Campus. Open Lab – Room 111 (Cloud Hall), and Monday evening 6:00 - 9:00 PM, at the Downtown Campus in room 515A. Open Lab - Room 516 (5th Floor Downtown Campus)
Online classes follow the same syllabus and timeline as On campus classes.
Grading is based on Midterm 35%, Final 35%, assignments 20% (in class or homework), and attendance 10%
Office Hours: When arranged with instructor – MW starting at 12:30 in Cloud Hall, Main Campus, or M starting at 5:00 PM or earlier, Downtown Campus. Alternate times can also be arranged by appointment.
| 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 |
This class is taught at a fast pace using lectures, overhead projector, and hands-on instructions. 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. The textbook 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 links above in orange color will give details on textbook, course pre-requisites and course description.
If you print this page and wish to re-visit it online, the address is: http://fog.ccsf.edu/~tcorbie/syllabus-mabs101.html