CSC 010-030 – Computer Applications, TH 12:00 – 1:20PM

Kutztown University of Pennsylvania, Fall 2009

Text: Microsoft Office 2007: Introductory Concepts and Techniques, Shelly Cashman Series

NOTE: This is a tentative schedule that is subject to change. DO NOT PRINT!

Instead,check weekly for updates.

Date / Topic/Assignment / Comments
9/1(T) – Intro + Concepts / Syllabus + Windows Account Creation
Essential Introduction to Computers / Lab
Lecture, COM 1-23
9/3 (H) Windows XP and Office 2007 / How to Purchase a Personal ComputerChap 1: Introduction to MS Windows XP. / COM24-38
WIN 2-38
Windows 38-45
9/8 (T) / *** NO Class Meeting *** / Follow Monday Schedule
9/10 (H) – Concepts / File Management in Windows Explorer
Saving files to stucluster & using data files at stucluster
Video:
The Machine that Changed the World / Windows 45-55
Lab
Video Viewing
9/15 (T) –
Word 2007 / Chap 1: Creating and Editing a Word Document
QUIZ 1– Video, Concepts, Windows XP / Lecture
WD 2-61
9/17 (H) –
Word 2007 / Chap 1:ITL 3
Chap 2: Research Paper in MLA Style
Creating a Research Paper – MLA Style / Lab 70-71
Lecture
WD 74-131
9/22 (T) – WD / Chap 2: Research Paper in MLA Style
Creating a Research Paper – MLA Style / Lab WD 74-131
9/24 (H) – WD / Chap 2:ITL 2
Chap 3:Create Cover Letter and Resume / Lab: WD 140-141
LectureWD146-202
9/29 (T) – WD 2007 / ITL 2: Creating a Resume from a Template
ITL 3: Creating a Letter / Lab: WD 210-211
Lab: WD 212
10/1 (H) –
Word 2007 / QUIZ 2 – Word 2007
Chap 1: Creating a Worksheet and an Embedded Chart / LectureExcel 2-68
10/6 (T) –
Excel 2007 / ** Word Project Due
Chap 1: Creating a Worksheet and an Embedded Chart / See handout
Lab: Excel 2-68
10/8 (H) –
Excel 2007 / ITL 2: Annual Sales Analysis Worksheet / Lab: Excel 75-77
10/13 (T) –
Excel 2007 / Chap 2: Formulas, Functions, Formatting, and Web Queries / Lecture Excel 82-141
10/15 (H) –
Excel 2007 / Chap 2: Formulas, Functions, Formatting, and Web Queries / Lab: Excel 82-141
10/20 (T) / QUIZ 3 – Excel 2007
10/22 (H) / ITL 1: Sales Analysis Worksheet
Parts 1 & 2 only
** Excel Project Due / Lab: Excel 149-151
See handout
10/27 (T) – PPT / Chap 1: Creating and Editing a Presentation / Lecture PPT 2-62, Lab
10/29 (H) – PPT / Chap 2: Creating a Presentation with Illustrations and Shapes
QUIZ 4 – PowerPoint 2007 / Lecture PPT 82-130 & Lab
11/3 (T) / ITL 3: With Clips and Shapes / Lab – PPT 140-141
11/5, 11/10, 11/12 / *** Individual PPT Presentations *** / Lab
11/17 (T) –
ACC 2007 / ** PowerPoint Project Due
Web feature / See handout
11/19 (H) –ACC / Chap 1: Creating and Using a Database / LectureAccess 2-61
11/24 (T) – ACC / ITL 1: JMS TechWizards Database / Lab: Access 67-68
12/1 (T) – ACC / Chap 2: Querying a Database / Lecture Access 74-125
12/3 (H) – ACC / ITL 2: JMS TechWizards Database / Lab:Access 131-132
12/8 (T) – ACC / Chap 3: Maintaining a Database / Lecture Access 138-156
12/10 (H) – ACC / QUIZ 5 – Access 2007
** Access Project Due / See handout

Legend: ITL – In the Lab

NOTE:For projects and lab exercises, you must save a copy to“stucluster”. There is an automatic 25% deduction if no copy is saved.I do notaccept assignments sent by e-mail.