textbookLogo

CIS105 Survey of Computer Information Systems
Spring 2011 - 16 Week Course (Blended/Hybrid)
Weekly Schedule

Professor: Deb Fells

Note: This schedule is subjected to BE CHANGED at your instructor's discretion. Please check this list often (and all announcements posted by your instructor), at least twice a week, to make sure that you do not miss any assignments.

Textbooks and Abbreviations:

  1. Textbook #1: Technology In Action ( TIA ), 7th edition, Pearson Prentice Hall, and Technology in Focus ( TiF ) chapters (located in TIA textbook).
  2. Textbook #2 : Skills for Success with Windows 7 ( Win )
  3. Textbook #3: Skills for Success with Microsoft Office 2007 ( Skills ), 1st edition, Pearson Prentice Hall
  4. MyITLab: Assessment Software

Most assignments are usually due on Monday evenings by 11:59 p.m., Arizona Time . There are some variations to the assignment due dates; make sure you read your schedule each week and pay close attention to the due dates. All weekly quizzes in WebCT are opened-book and three tries, best score. All quizzes and projects in MyITLab are opened-book and three tries , best score.
PRIOR TO START OF CLASS!
  1. Install : Ensure Windows, Internet Explorer is installed on your system  and that you have Internet access from home (or obtain Student ID if you will be using MCC's lab)
  2. Install/Update :  A virus protection program of your choice (i.e. Nortons Antivirus; McAfee; AVG; Penicillin)
  3. Install: Adobe Reader (available free from MCC's Technology Services
    Check your System for Pop-up Stoppers/Firewalls :
  4. If you have one, learn how to temporarily disable the pop-up stopper feature.
  5. Create: Your MCC Email account (if not already existing) and read mail from Instructor.
  

Navigate the WebCT site until you are familiar with the website.

Review: Layout of textbook

IMPORTANT: When you look at your weekly assignments and points, (the columns labeled "Activities/Assignments" and "Points") the numbers for each assignment will match the numbers of the point value in the points column.
Modules   Activities/Assignments Points Due Dates
Module 1  

Read & Review

  • In WebCT Review: Getting Started link from Course Content Page (Must complete before taking Course Info Quiz)
  • In WebCT Read: Course Syllabus
  • Read: TIA Textbook: Chapter 1: Why Computers Matter to You assignments
  • Review: TIA Textbook: Technology in Focus : The History of the PC (pp 36-47)
  • Read: TIA Textbook: Chapter 2: Looking at Computers

Submit Assignments in WebCT

  1. Take Quiz: Course Info (Use Quizzes/Survey link)
  2. Submit Photo for Photo Gallery
  3. Post Web Board Discussions: Self Intro
  4. Take Quiz Chapter 1: Why Computers Matter
  5. Take Quiz Chapter 2: Looking at Computers: Understanding the Parts
  6. Post Web Board Discussion for Module 1 (See Discussion Guidelines)
  1. 10
  2. 10
  3. 15
  4. 20
  5. 20
  6. 15
 24 January 2011
Module 2  

Read & Review

  • Read: TIA textbook: Chapter 3: Using the Internet
  • Read TIA textbook: Technology in Focus: IT Ethics (After Chapter 3, pp. 140-159)
  • Read TIA textbook: Chapter 4: Application Software

Submit assignments in WebCT

  1. Take Quiz Chapter 3: Using the Internet
  2. Take Quiz: TIF Ethics
  3. Take Quiz Chapter 4: Applications Software
  4. Post Web Board Discussion for Module 2
  1. 20
  2. 10
  3. 20
  4. 15
 31 January 2011
Module 3   Read & Review:
  • Read TIA textbook: Chapter 5: Using System Software
  • Read TIA textbook: Technology in Focus , Computing Alternatives (after Chapter 5, pp. 252-265)
  • Read TIA textbook: Chapter 6: Understanding and Assessing Hardware
  • In WebCT, click on the link MyIT Lab Instructions from the Course Contents or from within the Learning Modules section, and review all items listed in this section.

Submit assignments in WebCT

  1. Take Quiz Chapter 5: System Software
  2. Take TiF-Computing Alternatives Quiz
  3. Take Quiz Chapter 6: Understanding and Assessing Hardware
  4. Post Web Board Discussions for Module 3 (There are 2 discussions for this module)
  1. 20
  2. 10
  3. 20
  4. 30
 7 February 2011
Module 4  

Read & Review

  • Read and work through Skills for Success , Window 7 textbook #2. No points for this exercise.
  • Read and work through Skills for Success Office 2007 textbook #3 , Introduction , p. 2-24 - No points for this exercise.

Prepare for your MyITLab Assignments:

  • Obtain MyITLab's course ID information from your instructor (inside WebCT)
  • Be sure to have your MyITLab access code available.
  • Go to MyitLab.com web site to register and to log in.
  • Install your MS Office 2007 CD - trial version (if you are using off campus computer or your own computer).

Submit MyITLab Windows 7 & Office 2007 Introduction Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

  1. Go to MyitLab.com web site and log in.
  2. Complete Window 7 Concept Quiz - 10 points
  3. Complete Introduction to Office2007 Concept Quiz - 10 points
  4. In WebCT, Post Web Board Discussion for Beginning of Course Reflections - 15 points
  1. 0
  2. 10
  3. 10
  4. 15
 14 February 2011
Module 5  

Read & Review

  • Read and use your Skills for Success Office 2007 textbook as a guide to work through your MyITLab Word assignments.
  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Word Chapters 1-3 within MyITLab using the textbook, as a guide and reference.
  • Review PowerPoints for Word Chapters 1-3
  • Watch videos for Word Chapters 1-3

Note: Your assignments completed inside MyITLab will be automatically graded. Your instructor will transfer your grades over to WebCT upon your completion of the Word Section ( Word Chapters 1-3 ). (Skip Word Chapter 4. Students who are interested in learning more features on MS Word are recommended to take BPC110 or BPC 103BK )

Submit MyITLab Office 2007 Word Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Word Chapter 1- Complete and submit the following inside MyITLab for grading.

  1. Complete Word Chapter 1 Concepts Quiz , 10 points
  2. Complete Word Chapter 1 Project-Based Training , 20 points

2. Word Chapter 2- Complete and submit the following inside MyIT Lab for grading.

  1. Complete Word Chapter 2 Concepts Quiz , 10 points
  2. Complete Word Chapter 2 Project-Based Training , 20 points
  3. Download and complete Word Hands-on Assignment #1 (Using Word 2007), 100 points
    Upon completion, upload the saved files into MyITLab for grading, 100 points

3. Word Chapter 3- Complete and submit the following inside MyIT Lab for grading.

  1. Complete Word Concept Chapter 3 Quiz , 10 points
  2. Complete Word Chapter 3 Project Based Training , 20 points
  3. Download and complete Word Hands-on Assignment #2 . Upon completion, upload the saved files into MyITLab for grading, 100 points

Note: No Discussion Postings for this module
  1. 30
  2. 130
  3. 130
 21 February 2011
Module 6   Read & Review (Return to WebCT Interface and TIA for this module)

  • Read and complete Technology In Action textbook, Chapter 7: Networking and Security
  • Read and complete Technology In Action textbook, Chapter 8: Mobile Computing
  • Read and complete Technology In Action textbook, Chapter 9: Behind the Scene: System Hardware
  • Read and complete Technology In Action textbook, Tech in Focus: Digital Entertainment

Submit assignments in WebCT

  1. Take Quiz Chapter 7, Networking and Security, 20 points
  2. Take Quiz Chapter 8, Mobile Computing, 20 points
  3. Take Quiz Chapter 9, Behind the Scenes: System Hardware, 20 points
  4. Post Discussion for Module 6
  1. 20
  2. 20
  3. 20
  4. 15
 28 February 2011
Module 7  

Read & Review

  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Excel within MyITLab using the textbook, as a guide and reference
  • Read and use Skills Book, Excel Chapter 1: Create Workbooks with Excel 2007, p. 166-223 as a guide as you complete your MyITLab assignments:
  • Read and use Skills Book , Excel Chapter 2: Construct Formulas and Charts , p. 200-223 as a guide as you complete your MyITLab assignments:
  • Read and use Skills Book , Excel Chapter 3: Manage Multiple Worksheets in a Workbook , p. 234-257, as a guide as you complete your MyITLab assignments:
  • Review PowerPoints for Excel Chapters 1-3
  • Watch videos for Excel Chapters 1-3

Submit MyITLab Office 2007 Excel Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Excel Chapter 1- Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Excel Chapter 1.
  • Inside MyITLab, watch video for Excel Chapter 1.
  1. Complete Excel Chapter 1 Project-Based Training, 20 points
  2. Complete Excel Concepts Quiz for Chapter 1, 10 points
    ( No hands-on assignment for Excel Chapter 1)

2. Excel Chapter 2- Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Excel Chapter 2.
  • Inside MyITLab, watch video for Excel Chapter 2.
  1. Complete Excel Chapter 2 Project-Based Training, 20 points
  2. Complete Excel Concepts Chapter 2 Quiz, 10 points
  3. Download and complete Excel Hands-on Assignment #1 . Upon completion, upload the saved files into MyITLab for grading, 100 points

3. Excel Chapter 3- Complete and submit the following inside MyITLab for grading.

  • Inside MyITLab, review PP for Excel Chapter 3.
  • Inside MyITLab, watch video for Excel Chapter 3.
  1. Complete Excel Chapter 3 Project-Based Training, 20 points
  2. Complete Excel Concepts Chapter 3 Quiz, 10 points
  3. Download and complete Excel Hands-on Assignment #2 . Upon completion, upload the saved files into MyITLab for grading, 100 points

Note: No Discussion Postings for this module
  1. 30
  2. 130
  3. 130
 7 March 2011
Module 8  

Read & Review

  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Excel within MyITLab using the textbook, as a guide and reference
  • Read and use Skills Book, Excel Chapter 4: Using Excel Functions and Tables, p. 268-290, as a guide and reference when you work inside MyITLab to complete your assignments
  • Use Excel Explore Chapter 5 PowerPoints within MyITLab and information from your instructor as a guide and references when you work inside MyITLab to complete your assignments (the Skills book only includes chapters 1-4)
  • Review PowerPoints for Excel Chapters 4-5
  • Watch videos for Excel Chapters 4-5

Submit MyITLab Office 2007 Excel Assignments All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Excel Chapter 4 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Excel Chapter 4.
  • Inside MyITLab, watch video for Excel Chapter 4.
  1. Complete Excel Chapter 4 Project-Based Training, 20 points
  2. Complete Excel Concepts Chapter 4 Quiz, 10 points
  3. Download and complete Excel Hands-on Assignment #3 . Upon completion, upload the saved files into MyITLab for grading, 100 points

2. Excel Chapter 5- Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Excel Chapter 5.
  1. Complete Excel Chapter 5 Project-Based Training, 20 points
  2. Complete Excel Chapter 5 Hands-on Exercise 3 Project 20 points

Note: No Discussion Postings for this module
  1. 130
  2. 40
 14 March 2011
   

SPRING BREAK: March 14-March 20- No Class (Campus Closed)

    
Module 9  

Read & Review

  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Excel within MyITLab using the textbook, as a guide and reference.
  • Use Excel Explore Chapter 6 PowerPoints within MyITLab and information from your instructor as a guide and references when you work inside MyITLab to complete your assignments (the Skills book only includes chapters 1-4)
  • Use Excel Explore Chapter 7 PowerPoints within MyITLab and information from your instructor as a guide and references when you work inside MyITLab to complete your assignments (the Skills book only includes chapters 1-4)

Submit MyITLab Office 2007 Excel Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Excel Chapter 6- Complete and submit the following inside MyIT Lab for grading.

  1. Complete Excel Concepts Chapter 6 Quiz, 10 points
  2. Complete Excel Chapter 6 Hands-on Exercise 1 Project 10 points
  3. Complete Excel Chapter 6 Hands-on Exercise 2 Project 10 points
  4. Complete Excel Chapter 6 Hands-on Exercise 4 Project 15 points

2. Excel Chapter 7- Complete and submit the following inside MyIT Lab for grading.

  1. Complete Excel Chapter 7 Hands-on Exercise 3 Project 20 points

Note: Students are recommended to take CIS114DE if you want to learn to use more advanced features of Excel.

Note: No Discussion Postings for this module
  1. 45
  2. 20
 28 March 2011
Module 10   Read & Review ( Return to WebCT Interface and TIA for this module)

  • Read and complete Technology In Action textbook, Chapter 1 0: Building Applications
  • Read and complete Technology In Action textbook, Chapter 11: Database and Information Systems
  • Read and complete Technology In Action textbook, Technology in Focus: Careers

Submit assignments in WebCT

  1. Take Quiz Chapter 10, Building Applications, 20 points .
  2. Take Quiz Chapter 11, Database and Information Systems, 20 points .
  3. Post Discussion for Module 10, 15 points.

OPTIONAL ASSIGNMENTS ( Complete and submit Optional Assignments for bonus points)

  • Optional Social Bookmarking, 10 points
  • Optional Movie Analysis, 20 points
  • Optional Learning Style & Teamwork Webquest, 30 points
  • Optional Blogging, 20 points
  1. 20
  2. 20
  3. 15
 28 March 2011
Module 11  

Read & Review

  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Access within MyITLab using the textbook, as a guide and reference.
  • Read and use Skills Book , Access Chapter 1: Working with Databases, p. 302-325 , as a guide and reference as you complete your MyITLab assignments
  • Read and use Skills Book , Access Chapter 2: Building a Relational Database and Creating Forms , p. 336-359 , as a guide and reference as you complete your MyITLab assignments
  • Read and use Skills Book , Access Chapter 3: Creating Queries and Reports , p. 370-394 , as a guide and reference as you complete your MyITLab assignments
  • Review PowerPoints for Access Chapters 1-3
  • Watch videos for Access Chapters 1-3

Submit MyITLab Office 2007 Access Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Access Chapter 1 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 1.
  • Inside MyITLab, watch video for Access Chapter 1.
  1. Complete Access Training Project Chapter 1, 20 points
  2. Complete Access Concepts Quiz for Chapter 1, 10 points
    ( No hands-on assignment for Access Chapter 1 )

2. Access Chapter 2 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 2.
  • Inside MyITLab, watch video for Access Chapter 2.
  1. Complete Access Training Project Chapter 2, 20 points
  2. Complete Access Concepts Quiz for Chapter 2, 10 points
  3. Download and complete Access Hands-on Assignment #1 . Upon completion, upload the saved files into MyITLab for grading, 100 points

3. Access Chapter 3 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 3.
  • Inside MyITLab, watch video for Access Chapter 3.
  1. Complete Access Training Project Chapter 3, 20 points
  2. Complete Access Concepts Quiz for Chapter 3, 10 points
  3. Download and complete Access Hands-on Assignment #2 . Upon completion, upload the saved files into MyITLab for grading, 100 points

Note: No Discussion Postings for this module
  1. 30
  2. 130
  3. 130
 4 April 2011
Module 12  

Read & Review

  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Access within MyITLab using the textbook, as a guide and reference.
  • Read and use Skills Book , Access Chapter 4: Designing Advanced Database Object , p. 404-426 , as a guide and reference as you complete your MyITLab assignments
  • Use Access Explore Chapter 5 PowerPoints within MyITLab and information from your instructor as a guide and references when you work inside MyITLab to complete your assignments (the Skills book only includes chapters 1-4)
  • Review PowerPoints for Access Chapters 4-5
  • Watch videos for Access Chapters 4-5

Submit MyITLab Office 2007 Access Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Access Chapter 4 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 4.
  • Inside MyITLab, watch video for Access Chapter 4.
  1. Complete Access Training Project Chapter 4, 20 points
  2. Complete Access Concepts Quiz for Chapter 3, 10 points
  3. Download and complete Access Hands-on Assignment #3 . Upon completion, upload the saved files into MyITLab for grading, 100 points

2. Access Chapter 5- Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 5.
  1. Complete Access Chapter 5 Project-Based Training, 20 points

Note: No Discussion Postings for this module

  1. 130
  2. 20
 11 April 2011
Module 13  

Read & Review

  • Log into MyITLab You will use Skills for Success Office 2007 Book #3 and your computer to work on Access within MyITLab using the textbook, as a guide and reference.
  • Use Access Explore Chapter 6 PowerPoints within MyITLab and information from your instructor as a guide and references when you work inside MyITLab to complete your assignments (the Skills book only includes chapters 1-4)
  • Use Access Explore Chapter 6 PowerPoints within MyITLab and information from your instructor as a guide and references when you work inside MyITLab to complete your assignments (the Skills book only includes chapters 1-4)
  • Review PowerPoints for Access Chapters 6-7
  • Watch videos for Access Chapters 6-7

Submit MyITLab Office 2007 Access Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab ).

1. Access Chapter 6- Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 6.
  1. Complete Access Chapter 6 Project-Based Training, 20 points

2. Access Chapter 7- Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for Access Chapter 7.
  1. Complete Access Chapter 7 Hands-on Exercise 1 Project 20 points

Note: No Discussion Postings for this module
  1. 20
  2. 20
 18 April 2011
Module 14   Read & Review ( Return to WebCT Interface and TIA for this module)

  • Read Technology In Action textbook Chapter 13:The Internet and How It Works (Note - Chapter out of order)
  • Review HTML Project instructions (in WebCT)

Submit assignments in WebCT

  1. Take Quiz Chapter 13, 20 points
  2. Upload your HTML Project in Assignment dropbox in WebCT, 25 points

Note: No Discussion Postings for this module
  1. 20
  2. 25
 25 April 2011
Module 15   Read & Review ( You will use both WebCT and MyITLab Interfaces for this module)

  • Read Technology In Action textbook, Chapter 12: Networking and Security (Note - Chapter out of order)
Use MyIT Lab and Skills and MS Office 2007: PowerPoint Module, Chapter 1.

  • Read and use Skills book, PP Chapter 1: Getting Started with PP 2007, p. 438-461 , as a guide and reference as you complete your MyITLab assignments
  • Read and use Skills book, PP Chapter 2: Format Presentation, p. 472-495 , as a guide and reference as you complete your MyITLab assignments:
    ( Skip PP Chapters 3 and 4. Students are recommended to take BPC118DB to learn more on advanced features of PP)

Submit assignments in WebCT

    1. Take Quiz Chapter 12, 20 points
    2. Post Module 15 Discussion, 15 points.

Submit MyITLab Office 2007 PowerPoint Assignments ( All Office 2007's assignments will be completed and graded inside MyITLab except Final PowerPoint Project ).

3. PowerPoint Chapter 1 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for PowerPoint Chapter 1.
  • Inside MyITLab, watch video for PowerPoint Chapter 1.
  1. Complete PowerPoint Training Project Chapter 1, 20 points
  2. Complete PowerPoint Concepts Quiz for Chapter 1, 10 points

4. PowerPoint Chapter 2 - Complete and submit the following inside MyIT Lab for grading.

  • Inside MyITLab, review PP for PowerPoint Chapter 2.
  • Inside MyITLab, watch video for PowerPoint Chapter 2.
  1. Complete PowerPoint Training Project Chapter 2, 20 points
  2. Complete PowerPoint Concepts Quiz for Chapter 2, 10 points
  1. 20
  2. 15
  3. 30
  4. 30
 2 May 2011
Module 16  

Read & Review

Submit assignments in WebCT

  1. Using PowerPoint 2007 , create and present PowerPoint Final Project - 25 points
  2. Post Office 2007 Reflection Discussion, 40 points
  3. Follow the guidelines in the assignment and upload your Final Reflection in Assignment dropbox in WebCT, 25 points.
  1. 25
  2. 40
  3. 25
 9 May 2011 5PM
   

FINALS Week: All assignments are DUE- No Exceptions. Your instructor will let you know when your final class meeting is (based on the academic/final exam calendar).

Final grades are calculated and posted by:
5 p.m., Friday, May 13th.

    

Revised January 14, 2011