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) |
MS Office 2007 (Hunt text) 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,
|
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: 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, 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, 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, Filename: Outdoor Designs Product Order.xlsx ·
Lab
No. 6 – Steps Unit H, 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, 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, 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, Filename: ·
Lab No. 9A (Instructor Lab) Unit K Visual
Workshop, |
||
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, Filename: |
||
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, 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, 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. |
|||||