 The course lectures consisting of PowerPoint slides and video modules can be downloaded from the links below. Also, please ensure that your lab portfolio is stored in a OneDrive folder that could be access using the web link specified in the attached spreadsheet. |
CIS 1200 >
Labs
| Week | Chapter | Slides | Videos 1 | Videos 2 | Sort |
|---|---|---|---|---|---|
| Week 2 OneDrive | 020 | ||||
| O1-Creating OneDrive Account | 022 | ||||
| O2-Managing OneDrive | 024 | ||||
| O3-OneDrive for Business | 026 | ||||
| Week 3 Word | 030 | ||||
| W1-Creating and Editing a Document | Slides | 1.Creating a Document | 034 | ||
| W2-Creating a Research Paper | Slides | 2.Research Paper | 036 | ||
| Week 4 | 040 | ||||
| W3-Creating a Cover Letter | Slides | 1.Cover Letter 1 | 2.Cover Letter 2 | 042 | |
| W3-Creating a Resume | 3.Resume | 046 | |||
| W4-Creating a Webpage Using Word | 048 | ||||
| Week 5 Midterm 1 | 050 | ||||
| Midterm 1 Examination | Midterm 1 Schedule | Midterm 1 Review | 057 | ||
| Week 6 Excel | 060 | ||||
| E1-Creating a Worksheet and a Chart | Slides | 1.Worksheets | 2.More on Worksheets | 062 | |
| Week 7 | 070 | ||||
| E2-Formulas, Functions, Formatting and Web Queries | Slides | 3.Formulas | 4.More on Formulas | 076 | |
| Week 8 | 080 | ||||
| E3.1-What-if Analysis | Slides | 1.What-if | 2.More on What-if | 082 | |
| Week 9 | 090 | ||||
| E3.2-Charts | 3.Pie Charts | 094 | |||
| E4-Presenting Worksheets as Webpages Using Excel | 096 | ||||
| Week 10 Midterm 2 | 100 | ||||
| Midterm 2 Examination | Midter 2 Schedule | Midter 2 Review | 102 | ||
| Week 11 Access | 110 | ||||
| A1-Creating and Using a Database | Slides | 1.Creating Databases | 2. Using Databases | 112 | |
| Week 12 | 120 | ||||
| A2-Querying a Database | Slides | 1.Creating Queries | 2.Using Criteria | 122 | |
| 3.Wild Cards | 4. Displaying Fields | 5. Parameter Query | 123 | ||
| 6.Comparison Query | 7.AND Query | 8.OR Query | 124 | ||
| 9.Moving Fields | 10.Sort Query | 11.Unique Values | 126 | ||
| 12.Multiple Sorts | 13.Top Value Query | 14.Join Query | 127 | ||
| Week 13 | 130 | ||||
| A3-Maintaining a Database | Slides | 1. Maintaining Databases | 2. More on Maintenance | 132 | |
| A4-Sharing Data Among Applications | 134 | ||||
| Week 14 Google Sites | 140 | ||||
| G1-Google Sites and Drive | 142 | ||||
| Week 15 PowerPoint | 150 | ||||
| P1-Creating and Editing a Presentation | Slides | 152 | |||
| P2-Creating a Presentation with Illustrations and Shapes | Slides | 154 | |||
| P3-Creating Web Pages from PowerPoint | Slides | 156 | |||
| Week 16 | 160 | ||||
| Lab Portfolios | Link to Lab Porfolios | 162 | |||
| Final Exam | Final Exam Schedule | Final Exam Review | 164 |
Showing 44 items