ITC100-05, Computers and Their Uses

Tentative Master Course Schedule Spring 2009*

 

*If there are unforeseen technical difficulties or extenuating circumstances during the semester, this Course Schedule will be adjusted to reflect such issues. Adjustments to this Course Schedule will be submitted to the student in writing or by the established communication tools, i.e. email, posted on course website, etc. by the instructor.

 

WEEK 1

Jan 19

Holiday

Mon. Jan 19

 

·         Course Orientation

·         Course Syllabus

·         Orientation to CaseGrader

·         Purchasing of textbooks and CaseGrader Keycode

 

 

Week No

Computer Concepts (Parsons/Oja text)
Weekly Content & Assignments

MS Office 2007

(Hunt text)
Weekly Content & Assignments

NOTE: The purpose of the “Concepts Review” Assignments at the end of each chapter is to help prepare you for the exams.

 

 

Instructor-Generated Learning Activities

To Submit

 

 

Lab Assignments to

Submit or CaseGrader Projects to Submit

WEEK 2

Jan 26

Visual Tour: Windows Vista & Office 2007

·         Read pages 261-269

 

Computer & Internet Basics

·         Read Unit A, pages 1-20

 

 

 

 

Important Guidelines

·         Read pages xviii-xxiii Windows Vista

·         Read Unit A, pages 1-19

·         Complete Concepts Review, p. 20-21

 

File Management

NOTE: You need a USB Flash Drive to practice the skill sets in this Unit

·         Read Unit B, pages 25-43 and follow steps as introduced in Unit.

Complete Concepts Review, p. 44-45

 

Hands on Word activity (1)

 

 

WEEK 3

Feb 2

 

 

Computer Hardware

·         Read Unit B,
pages 25-46

 Getting Started with MS Office 2007

·         Read Unit C, pages 49-65 & do steps introduced within the Unit.

·         Complete Concepts Review, p. 66-67

·         Complete & Submit—Independent Challenge 3, page 72

 

Introduction to MS Word

Creating a Document

·         Read Unit D, pages 75-93 & Do Steps introduced within the Unit.

·         Complete Concepts Review, p. 94-95

·         Complete & Submit—Independent Challenge 3, page 99

 

 

Internet research activity (2)

Submit the following lab assignments:

 

·         Lab No. 1 - Independent Challenge 3, p. 72 (Unit C)

Filename: Thank You Letter.docx

 

·          Lab No. 2 - Independent Challenge 3, p. 99 (Unit D) Filename:
Job Description.docx

 

CaseGrader: Practice Case to submit to CaseGrader

Select one from:

 

#1 Word Case 1: Workshop Descriptions  OR

#2 Word Case 2: DTS Candidates FAQ

 

WEEK  4

Feb 9

No Assigned Readings

Enhancing a Document

·         Read Unit E, pages 101-117 & Do Steps.

·         Complete & Submit—the Steps on pages 101-117

·         Complete Concepts Review, p. 118-119

 

Quiz Units A and B from Computer Concepts (Parsons text) (3)

Submit the following lab assignments:

 

·         Lab No. 3 – Steps Unit E,
pp. 101-117

Filename: Clubhouse Kit Info Sheet.docx

 

CaseGrader: Practice Case to submit to CaseGrader

Select one from:

 

#3 Word Case 3: Fine Fare Brochure OR

 #4 Word Case 4: Camp Handbook

 

WEEK 5

Feb 16

Holiday

Mon., Feb. 16

Computer Software

·         Read Unit C, pages 51-74

 

Adding Special Elements to a Document

·         Read Unit F, pages 125-141 & Do Steps.

·         Complete & Submit—the Steps on pages 125-141

·         Complete Concepts Review, p. 142

 

Internet Activity with Flickr (4)

 

 

Submit the following lab assignments:

 

·         Lab No. 4 – Steps Unit F,
pp. 125-141

Filename: The Hammer Newsletter.docx

 

Submit CaseGrader Project 1 to CaseGrader

 

·          CaseGrader Project No. 1

#5 Word Case 5: Grand Mesa Resort. Submit via CaseGrader.

 

 

WEEK 6

Feb 23

 

 

Digital Electronics and File Management

·         Read Unit D, pages 81-105

 

Introduction to MS Excel

Creating and Enhancing a Worksheet

·         Read Unit G, pages 151-169 & Do Steps.

·         Complete & Submit—the Steps on pages 151-169

·         Complete Concepts Review, p. 170-171

 

Complex Formulas, Functions, Tables

·         Read Unit H, pages 179-195 & Do Steps.

·         Complete & Submit—the Steps on pages 179-195

·         Complete Concepts Review, p. 196-197

 

Hands on Excel Activity (5)

Submit the following lab assignments:

 

·         Lab No. 5 – Steps Unit G,
pp. 151-169

Filename: Outdoor Designs Product Order.xlsx

 

·         Lab No. 6 – Steps Unit H,
pp. 179-195

Filename: Western Region YTD Sales.xlsx

 

 

 

WEEK 7

March 2

 

 

No New Assigned Readings. Review for the Midterm

Working with Charts

·         Read Unit I, pages 203-219 & Do Steps

·         Complete & Submit—the Steps, pages 203-219

·         Complete Concepts Review, p. 220-221

 

 

Submit the following lab assignments:

 

·         Lab No. 7 – Steps Unit I,
 pp. 203-219

Filename: Clubhouse Kit Sales by Region.xlsx

 

WEEK 8

March 9

 

Midterm Exam

 

 

·         Review for Midterm Exam

·          Midterm Exam Content:

o    Computer Concepts, Seventh Edition textbook, Parsons & Oja. UNITS: A, B, C, D

o    MS Office 2007

·         Midterm Exam to be administered during this week

·         Complete CaseGrader Project No. 2  - Spreadsheets

Submit the following:

 

Midterm Exam

 

Submit CaseGrader Project 2 to CaseGrader

·          CaseGrader Project No. 2

#12 Excel Case 4: Produce Comparison. Submit via CaseGrader.

WEEK 9

March 16

Spring Break Mon., March 16 thru Friday March 20

Spring Break Monday, March 16 through Friday, March 20

WEEK 10

March 23

 

Networks and the Internet

·         Read Unit E, pages 113-138

Introduction to MS Access

Creating a Database

·         Read Unit J, pages 227-243 & Do Steps.

·         Complete & Submit—the Steps, pages 227-243

·         Complete Concepts Review, p. 244-245

Hands on assignment

Upload a video to a Blackboard and  include comments (6)

 

Submit the following lab assignments:

·         Lab No. 8 – Steps Unit J,
pp. 227-243

Filename: Outdoor Designs.accdb

WEEK 11

March 30

 

 

 

Data Security

·         Read Unit F, pages 145-164

 

Working with Data

·         Read Unit K, pages 251-267 & Do Steps.

·         Complete & Submit—the Steps, pages 251-267

·         Complete and submit the Visual Workshop on pp 276

·         Complete Concepts Review, p. 268-269

Hands on assignment

Participate in a class blog on Blackboard (7)

 

 

Submit the following lab assignments:

 

·         Lab No. 9 – Steps Unit K,
 pp. 251-267

Filename:
Outdoor Designs 2.accdb

 

·         Lab No. 9A (Instructor Lab) Unit K Visual Workshop,
pp.276
Filename: Executive Charity Run.accdb

 

WEEK 12

April 6

 

 

Read & Review Buyer’s Guide Worksheets for Purchasing a PC

pages 257-260

Creating Database Reports

·         Read Unit L, pages 277-291 & Do Steps.

·         Complete & Submit—the Steps, pages 277-291

·         Complete Concepts Review, p. 292-293

Quiz Units E and F from Computer Concepts (Parsons text) (8)

 

 

Submit the following lab assignments:

 

·         Lab No. 10 – Steps Unit L,
pp. 277-291

Filename:
Outdoor Designs 3.accdb

WEEK 13

April 13

 

 

The Web and E-commerce

·         Read Unit G, pages 171-190

Introduction to MS PowerPoint

Creating a Presentation

·         Read Unit M, pages 299-315 & Do Steps.

·         Complete & Submit—the Steps, pages 299-315

·         Complete Concepts Review, p. 316-317

 

Hands on PowerPoint Activity (9)

 

Submit the following lab assignments:

 

·         Lab No. 11 – Steps Unit M,
pp. 299-315

Filename: Reinforced Product Branding.pptx

 

Submit Access Project #3 to Instructor

·          Project No. 3 Database. Distributed by instructor. See instructor for submission details.

 

WEEK 14

April 20

Holiday

Mon. April 20

 

Digital Media

·         Read Unit H, pages 197-222

 

Polishing and Running a Presentation

·         Read Unit N, pages 323-339 & Do Steps.

·         Complete & Submit—the Steps, pages 323-339

·         Complete Concepts Review, p. 340-341

Hands on PowerPoint Activity (10)

 

Your PowerPoint Presentations are due and need to be uploaded to Blackboard (11)

Submit the following lab assignments:

 

·         Lab No. 12 – Steps Unit N,
pp. 323-339

Filename: Bird House.pptx

 

 

 

WEEK 15

April 27

 

CLASSES END Friday, May 1

 

 

Computer Industry & Careers

·         Read Unit I, pages 229-250

 

 

No Assigned Readings/Labs from this textbook.

 

Present your PowerPoint presentation to the class

 

Submit the following lab assignments:

 

Submit CaseGrader Project 4 to CaseGrader

·          CaseGrader Project No. 4

#8 PowerPoint Case 3: Fine Fare Classes.  Submit via CaseGrader.

 

 

 

 

·         Completion of all above course requirements and lab assignments.

·         Class presentations

·         Review for Final Exam content

·         Final Exam Content:

o    Computer Concepts, Seventh Edition textbook, Parsons & Oja. UNITS: E, F, G, H, I

o    MS Office 2007 textbook, Hunt. UNITS: G, H, I, J, K, L, M, N.

 

WEEK 16

May 4

Reading Day

Mon., May 4

 

Final Exam Week

 

·         Final Exam Week runs from Tuesday, May 5, through Tuesday, May 12

·         Final Exam will be administered during the scheduled Final Exam day and time as posted on the SSC website.

See link: http://www.salemstate.edu/registrar/finals.php

·         Final Exam Make-up Day is Wednesday, May 13.