Excel (Spreadsheets) Part 1
Assignments
Following are the Lab Assignments for CS 61.11a:
|
Lab 1
Due by the first day of class in Week 2 |
| Create a simple Spreadsheet |
| Return to CS 61.11a Syllabus |
|
Lab 2
Due by the first day of class in Week 3 |
| Data Entry, Formatting and Charting |
| Return to CS 61.11a Syllabus |
|
Lab 3
Due by the first day of class in Week 4 |
| Functions MIN MAX AVG |
| Return to CS 61.11a Syllabus |
|
Lab 4
Due by the first day of class in Week 5 |
| Embedded Functions and the IF Function |
| Return to CS 61.11a Syllabus |
|
Lab 5
Due by the first day of class in Week 6 |
| Financial Functions, Data Tables, and Amortization Schedules |
| Return to CS 61.11a Syllabus |
|
Lab 6
Due by the first day of class in Week 7 |
| VLOOKUP, Sort and Query |
| Return to CS 61.11a Syllabus |
|
Lab 7
Due by the first day of class in Week 8 |
| Multiple Worksheets and Workbooks |
| Return to CS 61.11a Syllabus |
|
Lab 8
Due on the Last day of Class |
| Final Project - Not Available until the last Week |
| Return to CS 61.11a Syllabus |
| Return to CS 61.11a Class Links | Return to CS 61.11a Syllabus |