CIS103 003
Fall 2009 Homework

low cost Microsoft Office 2007 for students at:  http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx

CIS103 003  Week 16,  Thurs 12/10/09

HOMEWORK :
for Tues Dec 15:  1. FINAL EXAM (100 pts)
2. Bonus Print JOURNAL reflections only-
add a final reflection on the Journal itself
3. BONUS survey due Wed noon(10-20 pts)
Due now:
1. Computer purchase Homework (10 pts)  due by end of class
2.   Access Lab Exam 2  (50 pts)
REview for Final Exam

CIS103 003  Week 16,  Tues 12/8/09

HOMEWORK :
1. Computer purchase Homework (10 pts)
I            P wf RAM          O          S      and any extras
Where did you find it? what does it cost?  good or bad
 Print the spec page (1 page)
Explain the specs
HP model p6204y from BB

  2. Access Lab Exam 2 (50 pts)

Tues, Dec 15:  FINAL EXAM (100 pts)
BONUS survey (10-20 pts)
JOURNAL
Due now:
Visio Lab Exam (40 pts)
   2 parts/files in WebCT  and 2 PRINTouts to hand in

TURN in the 3 items in green in order, Submit the file in WebCT
 Access Homework SfS pg 372 - 385  PRINT each object created

Computer purchase in class using IPOS and BB comparison

CIS103 003  Week 15,  Thurs 12/3/09

HOMEWORK :
Due Tues Dec 8: 1. Visio Lab Exam will be 2 parts
a. a diagram of our class room - accurate and to scale
add header with name, class, due date
PRINT and submit in WebCT

2. Access Homework SfS pg 372 - 385  PRINT each object created
  page 372 - use a03_Cypress_Golf database and logo
rename as directed on page 374 -   better to do in My Computer
open the database file.  ADD  YOUR FIRST NAME to all TABLE & QUERY names
do pages 374-375
  save query as "Tee Time Labels yourfirstname"   step 9 pg 375
                   ADD  YOUR FIRST NAME to all TABLE & QUERY names
  PRINT
labels  page 376 to 377   PRINT
query numeric & date pg 378 -379 be sure to include your name with all query names
Report Wizard  pg 380 - 385  Create, modify, & format the Sponsors Report
PRINT and Submit in WebCT


Due Dec 10:  Access Lab Exam 2 see WebCT

Tues, Dec 15:  FINAL EXAM

Return and go over Access Lab exam 1.
Review Access and add SfS Chap 3

Homework due now:  Visio Dec 2009 calendar
Look at Purchasing a new computer - Best Buy site, specs

CIS103 003  Week 15,  Tues 12/1/09

HOMEWORK due next class:
1. Visio Dec 2009 calendar
appointments for our classes
Final exam on Dec 15
a vacation
add header with name, class, due date
PRINT and submit in WebCT

2. Due next Monday 12/7
Visio Lab Exam (40 pts) will be 2 parts
a. a diagram of our class room - accurate and to scale
add header with name, class, due date
PRINT and submit in WebCT
b. a family tree
Turn in Access Lab Exam 1

Visio material can be found on the F drive
Visio software is found on the All Programs - NAL Explorer - Microsoft Office 2003 menu

use the "Visio quick" guide found on the F drive in CIS - 103 - Pamela - Visio
   the "Get to know Visio" ppt in F - CIS - 103 - VISIO

File - new - Project Schedule - Calendar
    Month of Dec 2009


No CLASS Thursday
Happy Thanksgiving

CIS103 003  Week 14,  Tues 11/24/09

HOMEWORK due next class:
1. Access Lab Exam 1
found in WebCT Submit Assignments

2.  Reply to the other 2 group posts
significant reply which reflects or adds data
1 paragraph in length
Go over group posts for system unit
Review system unit terms
 Add second table to Access
go over design and look at the use of relationships
IN CLASS QUIZ in WebCT

CIS103 003  Week 13,  Thurs 11/19/09
HOMEWORK due next class:
1. do  Sfs Access Chapter 1 pg 304
MyIT PH Training homework

2. Group final drafts due in WebCT
Captain makes thread for drafts
everybody posts at least 4 times in that thread
the FINAL draft goes into the new board by Tues noon
Discuss processors and  storage
Access - add queries and a first report

CIS103 003  Week 13,  Tues 11/17/09
HOMEWORK due next class:
1.  http://www.intel.com/consumer/learn
go thru videos on processor and  models

wikipedia.org  on the  CPU
http://en.wikipedia.org/wiki/Cpu
a little history, definition, components & process

2,  play with Access table and form

3.  Group on Storage Devices
    check in private board and add content
(drafts will be over weekend)
PowerPoint Lab Exam 2 is due
Journal entry for Second Life (and comment on Access)
IPOS - cover P and S
backup
begin Access, database, and DBMS
tables and forms

CIS103 003  Week 12,  Thurs 11/12
HOMEWORK due next class:
1. PowerPoint Lab Exam 2
directions in WebCT
Return papers
-   reflection on PowerPoint Lab Exam 1
PRINT and turn in REFLECTIONs pages only

Discuss current grade  is 310 Lab Exam pts of (total 500)  (PPT2, Acc1, Acc2, Visio left to do)

in class WEBCT  QUIZ wk 12
Finish Second Life BONUS


CIS103 003  Week 12,  Tues 11/10
HOMEWORK due next class:
1. be ready for a WebCT quiz
on material like Tues homework
Due now: MyIT LAb PH Training  Ppt Chap 2
- - -  in class  quiz/homework - - -   
Second Life bonus activities

CIS103 003  Week 11,  Thurs 11/5
HOMEWORK due next class:
1. Do SfS  Ppt Chap 2
2. MyIT LAb PH Training  Ppt Chap 2
3. Update your Journal for SL
4. Play around in SL
walk, fly, chat, search, teleport
change your appearance and clothing
Turn in: PowerPoint Lab Exam 1
Do you have your Second Life avatar account
Is your JOURNAL up to date?
Work in SL

CIS103 003  Week 11,  Tues 11/3
HOMEWORK due next class:
1. PowerPoint Lab Exam 1
Directions in WebCT Submit Assignments

2.  Create Second Life avatar account
from home (not on campus computer)
Remember your name & password
turn in: WEB PAGE Lab Exam (40 pts)
Submit in WebCT and bring printouts to class

MyIT PH Training PowerPoint Chap 1 (hmwrk 10-20 pts)

start Second Life - online social networking
    is an online 3D virtual world that is created by residents for networking & learning
           examples of features unique to SL are  avatars & _________
  software must be installed on the computer that is running SL

Create a PPT presentation on SL together in class (TREK design theme)
slide 1:  CLASS, SECOND LIFE  title        Name , Date
slide 2:   MY AVATAR   what name do you think you will use; what starting appearance 
slide 3    SECOND LIFE HISTORY - When,   by Whom,       For what
slide 4     different layout - content with caption
                   SL 3 part definition on left                       SL picture on right
              notes pane with what the picture is and where you found it (URL)
slide 5   THE END   title centered
 Add headers/footers  to slides/handouts

JOURNALs -    add to the NETWORKING area
    social network - Facebook,  MySpace
         3 D virtual networks - Second Life,  _______
add  HARDWARE -
INPUT devices -  
        keyboard -  
        mouse -  
        other - 
OUTPUT devices -
       classified as hard copy (permanent) or soft copy (temporary)
        monitor -  
        printer - 
       other output devices -  speakers,  plotters,  fax,  projectors, microfilm

CIS103 003  Week 10,  Thurs 10/29
HOMEWORK due next class:
1.  WEB PAGE Lab Exam (40 pts)
Submit in WebCT and bring printouts to class

2. Work through Sfs PPT Chapter 1 uses files from F drive
Do MyIT PH Training PowerPoint Chap 1 (hmwrk 10-20 pts)


bonus attendance day  1 of 4
Review Computer Network - quiz in WebCT
Finish NVU - work with web page backgrounds and printing
Start PowerPoint using SfS and class sample

CIS103 003  Week 10,  Tues 10/27
HOMEWORK due next class:
1.  Finish the Second web page
look similar to first
has 2 tables  one for INPUT devices
one for STORAGE devices
add info and pictures

LINK to it from your "homepage"


Turn in video summaries
Update Journal - Week 9 Internet, Networking, Web pages
Add reflection on Midterm
Go over Midterm results in class
Create second WebPage in class, link to it from homepage

CIS103 003  Week 9,  Thurs 10/22
HOMEWORK due next class:
1.  Add Networking terms to Journal

2. WebCT Submit 1/2 page about Mozilla
directions in WebCT Submit Assignments

3. In MyIt PH Videos, go through Connecting to the Internet
and one other related to networking ( your choice)
Write a brief summary of what the video was about
Print and bring paper to class

4. Finish your INDEX web page using NVU
Adjust text, pictures, table, colors
put it in the PUBLIC.WWW folder
Access and test it
Networking
Internet
Web pages
(If you missed this class, email Professor Hegg for help)

CIS103 003  Week 8,  Thurs 10/15
HOMEWORK due next class:
1. MIDTERM EXAM (100 pts)
Literacy & Lab


Due today: 
WebCT: Photoshop Lab Exam (50 pts)  - remember the explanation of steps (due by 11:30 pm)
       you may submit both in WebCT by retrieve photo and then upload explanation, submit both
       or EMAIL in WebCT the explanation of steps/tools used for the Photoshop Lab Exam
Turn in Printout of photo now

TURN in: Homework:  Pick a photo you worked on last week
Submit BW with explanation of what you did (20 pts)

Review for MIDTERM exam

CIS103 003  Week 7,  Tuesday  10/6/09 to Wk 8 Tues 10/13
HOMEWORK due next class:
1. WebCT: Photoshop Lab Exam (50 pts)
2.  Homework:  Pick a photo you worked on last week
Submit BW with explanation of what you did (20 pts)
3.  Test your internet speed at home
write down your ISP provider, 2 test site, 3 results
Catch up, review Photoshop
In Class Photo homework - turn in 20 pts
Look at Concepts for Midterm exam and Web Pages

CIS103 003  week 6   Thursday  10/1/09
Yes, there is class on campus
Thur 10/1 & Tues 10/6

CIS103 003  Week 6,  Tuesday  9/29/09
HOMEWORK due next class:
1. WebCT Excel lab Exam 2 (50 pts)
2. MyItLab PH Training Excel Chap 2 skill based (10 pts)
3. WebCT W6 Excel Quiz (10 pts)
Due:
EXCEL Lab Exam 1
Take the 1st try on the Excel quiz in class together
Go over the answers and process to get them
Work with Elluminate in class 
Start Photoshop using the F drive - CIS - 103 - pamela  - photoshop folder

CIS103 003  Week 5,  Thursday  9/24/09
HOMEWORK due next class:
1.  WebCT  EXCEL Lab Exam 1

2. be ready for Excel quiz 
Absolute and relative referencing
Practice quiz in class - email me answers in WebCT

CIS103 003  Week 5,  Tuesday  9/22/09
HOMEWORK due today:
1.  FIX & Submit your Journal in WebCT

due Thursday:
2.  Excel budget sheet
for months Sep - Dec
use formulas, functions, format, header, footer
PRINT data and Cell Formulas (as done in class)

3.  Finish Excel SfS Chap 1, submit in WebCT
submit in WebCT and print e01_New_Men_Items_yourname
 
Due today:
SfS start on pg 166, do Excel Chap 1
MyItLab  PH Training Excel Chap 1

GO over comments on your CIS103 Journal
Look at the WebCT quiz results

Excel - you should be able to:
    create an Excel sheet document
    save and print the document
    adjust column/row width/height
    format numbers/values

there are 2 types of data:
    1.  LABELS - text data, non calculating numbers
    2.  VALUES -  numeric for calculating
        a.  constants -  ex    98.6
        b.  formulas - start with = use math operators
            ex:    = B5 * C3                              = 5 * 10
            good formulas use cell references not constants
        c. functions -  predefined formulas from software manufacturer
            ex:   = SUM ( parameters)   = SUM (B5:B10)

Formula print out
    formula tab - Show Formulas
    adjust the width of the columns - because they will get wide
    Go to Page Setup (in print preview)
        sheet tab
            in the print group,
                 check Gridlines
                  check row & column headings

CIS103 003  Week 4,  Thursday  9/17/09
HOMEWORK due next class :
1. START SfS pg 166,  Excel Chap 1
Go as far as you can, the full assignment will be due Thurs
Submit and print e01_New_Men_Items_yourname

2.  MyItLab  PH Training Excel Chap 1
Due today:
Reply to the other Group posts
PH Required Exams:  Word Lab Exam 2 - due Thursday
Add journal entries
Take WebCT quiz in class
Do Word Lab Exam 2 part 2

CIS103 003  Week 4,  Tuesday  9/15/09
HOMEWORK due next class :
1. Reply to the other Group posts
 significant paragraph that reflects or adds

2. PH Required Exams:  Word Lab Exam 2

3.  WebCT Quiz in class 
Due today:
PH Training: Word Chapter 3 Skill based (10 pts)
Group posts on software - rough draft Tues -  practice version of group work
Start your   CIS103 Journal PH (your initials)
Work with groups
Go through Chapter 3 and try the WordArt Skill

CIS103 003  Week 3,  Thursday  9/10/09
HOMEWORK due Tuesday :
1. Go through SfS Word Chapter 3 and then do
PH Training: Word Chapter 3 Skill based
2. PH Videos: Look at the videos on the Web
3.  Group posts on software - rough draft Tues
due Thursday
4. PH Required Exams:  Word Lab Exam 2 - due Thursday
Review Internet topics
Start Application software categories

CIS103 003  Week 3,  Tuesday  9/8/09
HOMEWORK :
1. Finish PH Req exams in MyItLab Word Lab 1 by 6 pm Tues
for next class:
2. Finish Sfs Word Chapter 2 Job Description file
Submit in WebCT & PRINT
3. FTP to your H drive from home
 http://www.oakton.edu/resource/it/ftp/index.htm
ftp://student.oakton.edu
Due today:
SfS Word Chapter 1 -
    1. submit in WebCT
    2.  TURN in a printed copy of this exam -
                 be sure you have the footer (pg 50-51) with your name
myitlab PH Required Exams - Word 1 Lab Exam
Check your grades in WebCT - your should have homework 20 pts
Work on the MyItLab screen and gradebook
Word Chapter 2 - steps; begin in class
INTERNET define & work with FTP

CIS103 003  Week 2,  Thursday  9/3/09
HOMEWORK for next class:
1.  Do the SfS Word Chapter 1 - submit in WebCT (20 pts)
2. DO myitlab PH Required Exams - Word 1 Lab Exam
Due today:
myitlab  PH Training Word Ch 2 Skill based (10 pts)
    PRINT out results
WebCT quiz in class

CIS103 003  Week 2,  Tuesday  9/1/09
HOMEWORK for next class:
1. myitlab  PH Training Word Word Ch 2 Skill based (10 pts)
2. Skills for Success   
Common Features of Office Chapter 1
Read and do it

3.  Do the Elluminate Participant training video
http://www.elluminate.com/support/docs/9.0/participant.jsp
attendance
Be sure you replied to the Windows posts
create a document in Word/Wordpad with your name, class, date, & "Win versions" at top
    list the versions of Windows (start from DOS) in chronological order.     
    list the date and one fact.  Use the Discussion board for help
in class:  do a recall of 10 of the 12 Windows versions with dates and a fact
MyItLab - Skill based training
Elluminate
Skills for Success chapter 1

CIS103 003  Week 1,  Thursday  8/27/09
HOMEWORK for next class:
1. Reply to 2 of the Windows WebCT Discussion posts
2. in myitlab: complete Start Here: Getting Started with myitlab
 our class id is:  CRSABMG-418605
3. in the myitlab PH Training folder: complete Word Chapter 1 Skill based training
4. in PH Videos folder: complete Virtual Computer Tour soundbyte

attendance
REVIEW last class
Post WebCT History Discussion
My Computer folder/file exercise in class, turn in Notepad and Wordpad pages
start myitlab



CIS103 003  Week 1,  Tuesday  8/25/09
HOMEWORK for next class:
1. purchase book and myitlab

2. in myitlab: complete Start Here: Getting Started with myitlab

3. activate your Oakton email - myoakton

4.  send me an email in WebCT, tell me if you have used WebCT before

5.  Research your Windows version
2 paragraphs, use 2 documented sites
bring in a paper and electronic copy
attendance, syllabus, start WebCT
IPOS, Hardware, Software
Versions of Windows - discussion board assignment for WebCT

Go to TOP of page