CIS105 Schedule

	Sign In Sign-Up

CIS105 Daily Schedule and Assignments

In designing this schedule for CIS105, I wrote in blue what I as the teacher will do, and put in red what you are to do. Tests are listed in green and changes in book directions appear in purple. Each week, there will be lighter assignments on Monday and Tuesday than there will be on Wednesday and Thursday because you will have more time to get the heavier assignments done on Friday or over the weekend. Unless noted below, all assignments are due at the beginning of the next class period.

Date Computing Essentials Office Assignments

Aug. 20/21 Introductions, syllabus, supplies, e-mail, Blackboard.
Get book, read chapter. 1. Write definitions for key terms p. 21. Read Word 2000 xxi to WDO-6 and write definitions of key terms, p. xl.

Aug. 22/23 Have definitions checked when you walk in, review chapter 1, answer questions about e-mail and Blackboard.
Read pp. 26 - 46 and define terms p. 47. Word: Cover common Office features, and introduce Word chapter 1. Read and follow directions from WD1-0 (before WD1-1) to WD1-55. Save every 10 minutes after WD1-25!
Create and print Hands-On Practice Exercise 4 on WD1-64.

Aug. 27/28 Check definitions first thing, cover chapter 2.
Read pp. 52 - 68 and define terms p. 70. Word: preview Word chapter 2. Read and follow directions from WD2-0 to WD2-26 (due Sep. 4/5, but save your work frequently as Tour Report for later).
Turn in "Trip Announcement1" (WD1-50) and "Debbie" (WD1-64).

Aug. 29/30 Check definitions, cover chapter 3.
Read pp. 74 - 82 and define bold terms. Word: Finish chapter 2. Read and follow directions from WD2-26 to WD2-49 and Hands-On Practice Exercises 2 and 5 (WD2-55 and WD2-58).

Sep. 3 No classes Monday -- Labor Day.

Sep. 4/5 Check definitions, cover pp. 74 - 82, chapter 4
Read pp. 83 - 92 and define bold terms. Word: preview Word chapter 3. Read and follow directions from WD3-0 to WD3-27 (due Sep. 11/12).
Turn in "Revised Tour Letter" (WD2-47) and "Coffee Flyer2" (WD2-58).

Sep. 6/10 Check definitions, cover pp. 83 - 92, chapter 4.
Read pp. 98 - 110 and define bold terms. Word: preview Word tables and HTML. Read and follow directions from WD3-28 to WD3-57 and WDW-1 to WDW-11.
Excel: Read EX0-1 to EX0-10.

Sep. 11/12 Check definitions and cover pp. 98 - 110, chapter 5, test over chapters 1 - 4 and Word.
Read pp. 111 - 121 and define bold terms. Excel: Introduce spreadsheets. Read and follow directions from EX1-1 to EX1-65 and complete Hands-On Practice Exercise 3 on EX1-74.
Turn in "Tour Report" (WD3-54) and disk with "New Tour Presentations" (WDW-7) and "Presentation Locations" (WDW-11).

Sep. 13 Go over grades from the first test. Excel: Introduce Grades Spreadsheet (due Dec. 5/6), charts, and absolute cell referencing. Read and follow directions from EX2-1 to EX2-25 (due Oct. 3/4).

Sep. 17/18 Check definitions, cover pp. 111 - 120, chapter 5, watch corny video.
Read pp. 126 - 143 and define terms p. 144. Excel: Finish discussing chart modifications. Read and follow directions from EX2-26 to EX2-49 and Hands-On Practice Exercise 2 on EX2-56.
Turn in "Cafe Forecast" (EX1-63) and "Real Estate Prices" (EX1-74) with disk.

Sep. 19/20 Check definitions, cover pp. 126 - 143, chapter 6
Read pp. 148 - 159 and define bold terms. Excel: Preview chapter 3 and demonstrate absolute cell referencing with "Sales Tax" spreadsheet. Read and follow directions from EX3-0 to EX3-47.
Turn in "Cafe Sales Charts" (EX2-47) and "Real Estate Charts" (EX2-57) with disk.

Sep. 24/25 Check definitions and , cover pp. 148 - 159, chapter 7
Read pp. 160 - 172 and define bold terms. Excel: Preview linking Excel and Word and chapter 4. Read and follow the directions from EXW-1 to EXW-12 and EX4-2 to EX4-37.
Turn in "Annual Forecast Revised" (EX3-45) with disk.

Sep. 26/27 Check definitions, cover pp. 160 - 172, chapter 7
Read pp. 178 - 192 and define bold terms. Excel: Preview chapter 5. Read and follow directions from EX5-0 to EX5-41.
Turn in "Sales Forecast Memo Linked" (EXW-11) and "Year 2002 Forecast Scenario Summary" (EX4-35) with disk.

Oct. 1/2 Check definitions, cover pp. 178 - 192, chapter 8
Read pp. 192 - 204 and define bold terms. Excel: Preview chapter 6. Read and follow directions from EX6-0 to EX6-39, ad read only form EX6-40 to EX6-49. Print Pivot Chart (landscape, fit to one page) and Pivot Table from page EX6-39 with your name and date in a footer.
Turn in "March Bonus Dollars" (EX5-39).

Oct. 3/4 Check definitions, cover pp. 192 - 204, chapter 8
Read pp. 210 - 218 and define bold terms.
Oct. 5 deadline to withdraw without instructor's signature. Excel: Preview Working Together 2 and review for test.
Read from EXW2-1 to EXW2-17. Read Access from AC0-1 to AC1-5.
Turn in "Internet Customers" (EXX6-14 landscape, fit to 1 page), "Cafe Customers" (EX6-30), "Cafe Customer Analysis" (EX6-47).

Oct. 8/9 Check definitions, cover pp. 210 - 218, chapter 9, test over chapters 5 - 8 and Excel.
Read pp. 219 - 228 and define bold terms. Above: print Pivot Chart and Pivot Table from page EX6-39 with your name and date in a footer (landscape, fit to one page)

Oct. 10/11 Check definitions, cover pp. 219 - 228, chapter 9
Read pp. 234 - 240 and define bold terms. PowerPoint: preview PowerPoint chapter 1. Read from PP0-1 to PP0-6 and follow directions from PP1-1 to PP1-51. Print "Volunteer" (PP1-24). Complete Hands-On Practice Exercise 3, p. PP1-59.

Oct. 15/16 Tour Virtual Reality Center on the Williams Campus. PowerPoint: preview PowerPoint chapter 2. Read and follow directions from PP2-0 to PP2-23.
Turn in "Volunteer" (PP1-24), "Recruit1" (PP1-49), and "Coffee" (PP1-61) (all as handouts, grayscale, 6 per page).

Oct. 17/18 Check definitions, cover pp. 234 - 240, chapter 10
Read pp. 240 - 257 and define bold terms. PowerPoint: preview the rest of chapter 2. Read and follow directions from PP2-23 to PP2-51, Hands-On Practice Exercise 3 on PP2-62, and PPW-1 to PPW-11.

Oct. 22/23 Check definitions, cover pp. 240 - 257, chapter 10
Read pp. 262 - 272 and define bold terms. PowerPoint: Finish PowerPoint and review for test.
Turn in "Final Volunteer" (PP2-49 handouts, grayscale, 3 per page), "Coffee Show" (PP2-63 handouts, grayscale, 4 per page), and "Final Volunteer Linked" (PPW-11 slides 7 and 13 as handouts, grayscale, 2 per page).

Oct. 24/25 Check definitions, test over chapters 9, 10 and PowerPoint, cover pp. 262 - 272, chapter 11
Read pp. 273 - 280 and define bold terms. Access: Introduce databases and Access. Read and follow directions from AC1-6 to AC1-49 and complete Hands-On Practice Exercise 3 on AC1-57.
Turn in "2002 Forecast"

Oct. 29/30 Check definitions, cover pp. 273 - 280, chapter 11
Read pp. 286 - 293 and define bold terms. Access: Introduce Access forms. Read and follow directions from AC2-0 to AC2-35 and complete Hands-On Practice Exercise 2 on C2-45.
Turn in "Employees" (AC1-45) and "Vendors" (AC1-58).

Oct. 31/1 Check definitions, cover pp. 286 - 293, chapter 12
Read pp. 294 - 301 and define bold terms. Access: Introduce reports. Read and follow directions from AC3-0 to AC3-45 and complete Hands-On Practice Exercise 3 on AC3-53.
Turn in "Employee Data Form" (AC2-32) and "Cafe Vendors" (AC2-44).

Nov. 5/6 Check definitions, cover pp. 294 - 301, chapter 12
Read pp. 307 - 317 and define bold terms. Access: Preview linking Access and Word and chapter 4. Read and follow directions from ACW-1 to ACW-11 and AC4-2 to AC4-18.
Turn in 2 query printouts from AC3-21, "Employee Address Report" (AC3-42) and "Cafe Items To Be Ordered" (AC3-54).

Nov. 7/8 Check definitions, cover pp. 307 - 317, chapter 13
Read pp. 317 - 328 and define bold terms. Access: Finish previewing chapter 4. Read and follow directions from AC4-19 to AC4-47 and complete Hands-On Practice Exercise 4 on AC4-56.
Turn in "Service Awards Linked" (ACW-12).

Nov. 12 Veterans Day -- no classes

Nov. 13/14 Check definitions, cover pp. 317 - 328, chapter 13
Read pp. 334 - 344 and define bold terms. Access: Preview custom forms. Read and follow directions from AC5-0 to AC5-41 and complete Hands-On Practice Exercise 4 on AC5-51.
Turn in "Gross Pay 4/20/01" (AC4-31), "Hours_Crosstab" (AC4-36), "Relationships for Club Employees" and Cafe Purchases printouts.

Nov. 15/19 Check definitions, cover pp. 334 - 344, chapter 14
Read pp. 344 - 356 and define bold terms. Access: Preview chapter 6. Read and follow directions from AC6-0 to 39 and Hands-On Practice Exercise 5 on AC6-52.
Turn in "Employee Update Form" and your "Cafe Purchases Form."

Nov. 20/21 Check definitions, cover pp. 344 - 356, chapter 14
Read pp. 362 - 375 and define terms p. 376. Access: Preview Working Together2. Read and follow directions from ACW2-1 to ACW2-14.
Turn in chapter 6 printouts and "Cafe Orders."

Nov. 22 Thanksgiving -- no classes

Nov. 26/27 Check definitions, cover pp. 362 - 375, chapter 15
Read pp. E1 - E8. Visual BASIC:

Nov. 28/29 Test over chapters 11 - 15 and Access, cover pp. E1 - E8 and show Computer History PowerPoint
Read BG1 - BG6 and bring in 4 newspaper ads and 4 Internet ads for computers. Fill out Buyer's Guide on pp. BG5 and BG6. Visual BASIC:

Dec. 3/4 Cover pp. BG1 - BG6, and create a spreadsheet of all 8 computers. Visual BASIC:

Dec. 5/6 Review for Final Exam. Visual BASIC:
Bring in "Grades Spreadsheet."

Dec. 10/11 Final Exam

29 class meetings = Word 5 days, PowerPoint 4 days, Excel 8 days, Access 8 days, Visual BASIC 4 days

Date	*Computing Essentials*	Office Assignments
Aug. 20/21	Introductions, syllabus, supplies, e-mail, Blackboard. Get book, read chapter. 1. Write definitions for key terms p. 21.	Read Word 2000 xxi to WDO-6 and write definitions of key terms, p. xl.
Aug. 22/23	Have definitions checked when you walk in, review chapter 1, answer questions about e-mail and Blackboard. Read pp. 26 - 46 and define terms p. 47.	Word: Cover common Office features, and introduce Word chapter 1. Read and follow directions from WD1-0 (before WD1-1) to WD1-55. Save every 10 minutes after WD1-25! Create and print Hands-On Practice Exercise 4 on WD1-64.
Aug. 27/28	Check definitions first thing, cover chapter 2. Read pp. 52 - 68 and define terms p. 70.	Word: preview Word chapter 2. Read and follow directions from WD2-0 to WD2-26 (due Sep. 4/5, but save your work frequently as Tour Report for later). Turn in "Trip Announcement1" (WD1-50) and "Debbie" (WD1-64).
Aug. 29/30	Check definitions, cover chapter 3. Read pp. 74 - 82 and define bold terms.	Word: Finish chapter 2. Read and follow directions from WD2-26 to WD2-49 and Hands-On Practice Exercises 2 and 5 (WD2-55 and WD2-58).
Sep. 3	No classes Monday -- Labor Day.
Sep. 4/5	Check definitions, cover pp. 74 - 82, chapter 4 Read pp. 83 - 92 and define bold terms.	Word: preview Word chapter 3. Read and follow directions from WD3-0 to WD3-27 (due Sep. 11/12). Turn in "Revised Tour Letter" (WD2-47) and "Coffee Flyer2" (WD2-58).
Sep. 6/10	Check definitions, cover pp. 83 - 92, chapter 4. Read pp. 98 - 110 and define bold terms.	Word: preview Word tables and HTML. Read and follow directions from WD3-28 to WD3-57 and WDW-1 to WDW-11. Excel: Read EX0-1 to EX0-10.
Sep. 11/12	Check definitions and cover pp. 98 - 110, chapter 5, test over chapters 1 - 4 and Word. Read pp. 111 - 121 and define bold terms.	Excel: Introduce spreadsheets. Read and follow directions from EX1-1 to EX1-65 and complete Hands-On Practice Exercise 3 on EX1-74. Turn in "Tour Report" (WD3-54) and disk with "New Tour Presentations" (WDW-7) and "Presentation Locations" (WDW-11).
Sep. 13	Go over grades from the first test.	Excel: Introduce Grades Spreadsheet (due Dec. 5/6), charts, and absolute cell referencing. Read and follow directions from EX2-1 to EX2-25 (due Oct. 3/4).
Sep. 17/18	Check definitions, cover pp. 111 - 120, chapter 5, watch corny video. Read pp. 126 - 143 and define terms p. 144.	Excel: Finish discussing chart modifications. Read and follow directions from EX2-26 to EX2-49 and Hands-On Practice Exercise 2 on EX2-56. Turn in "Cafe Forecast" (EX1-63) and "Real Estate Prices" (EX1-74) with disk.
Sep. 19/20	Check definitions, cover pp. 126 - 143, chapter 6 Read pp. 148 - 159 and define bold terms.	Excel: Preview chapter 3 and demonstrate absolute cell referencing with "Sales Tax" spreadsheet. Read and follow directions from EX3-0 to EX3-47. Turn in "Cafe Sales Charts" (EX2-47) and "Real Estate Charts" (EX2-57) with disk.
Sep. 24/25	Check definitions and , cover pp. 148 - 159, chapter 7 Read pp. 160 - 172 and define bold terms.	Excel: Preview linking Excel and Word and chapter 4. Read and follow the directions from EXW-1 to EXW-12 and EX4-2 to EX4-37. Turn in "Annual Forecast Revised" (EX3-45) with disk.
Sep. 26/27	Check definitions, cover pp. 160 - 172, chapter 7 Read pp. 178 - 192 and define bold terms.	Excel: Preview chapter 5. Read and follow directions from EX5-0 to EX5-41. Turn in "Sales Forecast Memo Linked" (EXW-11) and "Year 2002 Forecast Scenario Summary" (EX4-35) with disk.
Oct. 1/2	Check definitions, cover pp. 178 - 192, chapter 8 Read pp. 192 - 204 and define bold terms.	Excel: Preview chapter 6. Read and follow directions from EX6-0 to EX6-39, ad read only form EX6-40 to EX6-49. Print Pivot Chart (landscape, fit to one page) and Pivot Table from page EX6-39 with your name and date in a footer. Turn in "March Bonus Dollars" (EX5-39).
Oct. 3/4	Check definitions, cover pp. 192 - 204, chapter 8 Read pp. 210 - 218 and define bold terms. Oct. 5 deadline to withdraw without instructor's signature.	Excel: Preview Working Together 2 and review for test. Read from EXW2-1 to EXW2-17. Read Access from AC0-1 to AC1-5. Turn in "Internet Customers" (EXX6-14 landscape, fit to 1 page), "Cafe Customers" (EX6-30), "Cafe Customer Analysis" (EX6-47).
Oct. 8/9	Check definitions, cover pp. 210 - 218, chapter 9, test over chapters 5 - 8 and Excel. Read pp. 219 - 228 and define bold terms.	Above: print Pivot Chart and Pivot Table from page EX6-39 with your name and date in a footer (landscape, fit to one page)
Oct. 10/11	Check definitions, cover pp. 219 - 228, chapter 9 Read pp. 234 - 240 and define bold terms.	PowerPoint: preview PowerPoint chapter 1. Read from PP0-1 to PP0-6 and follow directions from PP1-1 to PP1-51. Print "Volunteer" (PP1-24). Complete Hands-On Practice Exercise 3, p. PP1-59.
Oct. 15/16	Tour Virtual Reality Center on the Williams Campus.	PowerPoint: preview PowerPoint chapter 2. Read and follow directions from PP2-0 to PP2-23. Turn in "Volunteer" (PP1-24), "Recruit1" (PP1-49), and "Coffee" (PP1-61) (all as handouts, grayscale, 6 per page).
Oct. 17/18	Check definitions, cover pp. 234 - 240, chapter 10 Read pp. 240 - 257 and define bold terms.	PowerPoint: preview the rest of chapter 2. Read and follow directions from PP2-23 to PP2-51, Hands-On Practice Exercise 3 on PP2-62, and PPW-1 to PPW-11.
Oct. 22/23	Check definitions, cover pp. 240 - 257, chapter 10 Read pp. 262 - 272 and define bold terms.	PowerPoint: Finish PowerPoint and review for test. Turn in "Final Volunteer" (PP2-49 handouts, grayscale, 3 per page), "Coffee Show" (PP2-63 handouts, grayscale, 4 per page), and "Final Volunteer Linked" (PPW-11 slides 7 and 13 as handouts, grayscale, 2 per page).
Oct. 24/25	Check definitions, test over chapters 9, 10 and PowerPoint, cover pp. 262 - 272, chapter 11 Read pp. 273 - 280 and define bold terms.	Access: Introduce databases and Access. Read and follow directions from AC1-6 to AC1-49 and complete Hands-On Practice Exercise 3 on AC1-57. Turn in "2002 Forecast"
Oct. 29/30	Check definitions, cover pp. 273 - 280, chapter 11 Read pp. 286 - 293 and define bold terms.	Access: Introduce Access forms. Read and follow directions from AC2-0 to AC2-35 and complete Hands-On Practice Exercise 2 on C2-45. Turn in "Employees" (AC1-45) and "Vendors" (AC1-58).
Oct. 31/1	Check definitions, cover pp. 286 - 293, chapter 12 Read pp. 294 - 301 and define bold terms.	Access: Introduce reports. Read and follow directions from AC3-0 to AC3-45 and complete Hands-On Practice Exercise 3 on AC3-53. Turn in "Employee Data Form" (AC2-32) and "Cafe Vendors" (AC2-44).
Nov. 5/6	Check definitions, cover pp. 294 - 301, chapter 12 Read pp. 307 - 317 and define bold terms.	Access: Preview linking Access and Word and chapter 4. Read and follow directions from ACW-1 to ACW-11 and AC4-2 to AC4-18. Turn in 2 query printouts from AC3-21, "Employee Address Report" (AC3-42) and "Cafe Items To Be Ordered" (AC3-54).
Nov. 7/8	Check definitions, cover pp. 307 - 317, chapter 13 Read pp. 317 - 328 and define bold terms.	Access: Finish previewing chapter 4. Read and follow directions from AC4-19 to AC4-47 and complete Hands-On Practice Exercise 4 on AC4-56. Turn in "Service Awards Linked" (ACW-12).
Nov. 12	Veterans Day -- no classes
Nov. 13/14	Check definitions, cover pp. 317 - 328, chapter 13 Read pp. 334 - 344 and define bold terms.	Access: Preview custom forms. Read and follow directions from AC5-0 to AC5-41 and complete Hands-On Practice Exercise 4 on AC5-51. Turn in "Gross Pay 4/20/01" (AC4-31), "Hours_Crosstab" (AC4-36), "Relationships for Club Employees" and Cafe Purchases printouts.
Nov. 15/19	Check definitions, cover pp. 334 - 344, chapter 14 Read pp. 344 - 356 and define bold terms.	Access: Preview chapter 6. Read and follow directions from AC6-0 to 39 and Hands-On Practice Exercise 5 on AC6-52. Turn in "Employee Update Form" and your "Cafe Purchases Form."
Nov. 20/21	Check definitions, cover pp. 344 - 356, chapter 14 Read pp. 362 - 375 and define terms p. 376.	Access: Preview Working Together2. Read and follow directions from ACW2-1 to ACW2-14. Turn in chapter 6 printouts and "Cafe Orders."
Nov. 22	Thanksgiving -- no classes
Nov. 26/27	Check definitions, cover pp. 362 - 375, chapter 15 Read pp. E1 - E8.	Visual BASIC:
Nov. 28/29	Test over chapters 11 - 15 and Access, cover pp. E1 - E8 and show Computer History PowerPoint Read BG1 - BG6 and bring in 4 newspaper ads and 4 Internet ads for computers. Fill out Buyer's Guide on pp. BG5 and BG6.	Visual BASIC:
Dec. 3/4	Cover pp. BG1 - BG6, and create a spreadsheet of all 8 computers.	Visual BASIC:
Dec. 5/6	Review for Final Exam.	Visual BASIC: Bring in "Grades Spreadsheet."
Dec. 10/11	Final Exam