CIS101 004
Fall 2009 Homework
low cost Microsoft Office 2007 for students at:  http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx
Another deal for Oakton Students
CTIS students will be able to get Windows 7  as soon as the ELMS system enables "Media Sales".
Students can get the software for the cost of duplication & shipping.
WinXP and Vista are available for the price of $24.95
Expecting Windows 7 would be the same. 
CIS101 004  Week 17 Mon  12/14/09
Homework:
1. BONUS due Tues 12/15 noon Web site assignment
see WebCT Submit Assignments for directions

2. WebCT Survey (Bonus 10 pts)

3. Wed, Dec 16  - Available for missing required work (lab exams)

FINAL EXAM in class
Please submit your Journal reflections today or Wed in WebCT
CIS101 004  Week 16 Wed  12/9/09
Homework:
1. Mon Dec 14 FINAL exam
    may bring 1 sided 3x5 index card

2. Homework:  Tues noon BONUS Web site assignment
directions in WebCT

3. Wed, Dec 16  - Available for missing required work (lab exams)
please let me know if you are coming by Tues 11 pm

Add background graphics to your INDEX page in NVU
Find graphics on Google Images - for category like favorite foods, sports, seasonal, etc
all graphics must be in your Public.www folder
remember that graphics may belong to someone else and need to be acknowledged/verified

Required components for your Internet site
1.  web page which you created in  NVU (start with Index.html)
2.  web host for your pages  Public.WWW in your H drive
    after Oakton, find one for monthly fee ~$10
    www.powweb.com
3.  domain name(www.oakton.edu/~yourlogin)
    after Oakton, find one for yearly fee <$30
    www.register.com

REVIEW for Final Exam
CIS101 004  Week 16 Mon  12/7/09
Homework:
1. Complete the INDEX page in NVU with graphics
Search online for webpage background graphics
save several to your Public.www folder

2. Any FINAL exam questions
 
Due Mon Dec 14 FINAL exam

Wed, Dec 16  - Available for makeup

The ACCESS report created in class printout due (10 pts homework)
Review Access for Exam #2
Add graphics to INDEX in NVU
do Access #2
CIS101 004  Week 15 Wed  12/2/09
Homework:
1. The Access REPORT created in class
base on CIS101 004 database query of students and zip tables
change report header to show report name & label with name, class, due date
show ID, first, last, city, state, zip, & money in pocket fields
adjust spacing between fields and rows
total money in pocket (format currency)
sort in ascending last name order
PRINT and bring paper to class

2. Be ready for Access #2 which will be done in class (Dec 7)
 
wk 16 Dec 7: web pages, privacy
wk 17 Mon Dec 14 exam; Wed - makeup


Add trademark, copyright, patent to your JOURNAL
http://www.uspto.gov/web/trademarks/workflow/start.htm

in class handwritten homework page (worth 10 pts)

create a web page in NVU, save as INDEX in PUBLIC.WWW folder on your H drive
access from a different computer at  www.oakton.edu/~yourloginid
CIS101 004  Week 15 Mon  11/30/09
Homework:
1a.  use our class database with zip table
create a query for students with more than 10 print name, city, zip & money
create a report -  for student list with names, city, state, zip
count the number of students  in the report footer via =count([last name])
PRINT the tables, query, and report
 
1b. Access #2 will be done in class (probably Dec 7)

2. research the difference between trademark, copyright, patent

wk 16 Dec 7: web pages, privacy
wk 17 Mon Dec 14 exam; Wed - makeup


PAPER HOMEWORK due today (written in hand) name, class, date on top (10 pts)
1.  name the steps of the System Development Life Cycle  with tasks
2, 3, 4, & 5 done Monday.    6 - 10 will be finished on Wed in class                    

Discuss security and privacy.
Review Access queries & reports.  Create a second table, add & delete fields from the structure, join tables in query
CIS101 004  Week 14 Mon  11/23/09
Homework:
1. Class will be online -
must send me an email by Tues 11:55 pm to meet at 10 am
post questions in the Discussion board for week 14

2.  W14 SDLC quiz in WebCT due by 11 pm Wed
-------------------------------------------------------
wk 15 Nov 30:  Access #2, Programming, Security
wk 16 Dec 7: web pages, privacy
wk 17 Dec 14 exam
Due now:
Access Lab Exam 1
In class Homework page worth 10 pts
Review Information Systems and SDLC
Cover Programming, Languages and PDLC
CIS101 004  Week 13 Wed  11/18/09
Homework:
1. Access Lab Exam 1 due
2. Add DBMS and Information systems to journal
Review dBASE & AshtonTate
DBMS 3 part definitions, lists, and terms
Access objects; practice in class together including logos for forms
Information systems and the SDLC
CIS101 004  Week 13 Mon  11/16/09
Homework:
1. what is dBASE - history, facts
2.  CoursePort  Chapter 12 online summary
System Development Life Cycle (steps)
3. play with Access tables, forms, queries
there will be another quiz on Wed
Due now:
QUIZ in WEBCT, take it now if you missed it over the weekend
Did you complete CoursePort Ch 6 Student Edition Lab - Databases
         complete ALL topics, there are 34 questions
Read Courseport Ch 14 online summary
Read Courseport Ch 6 online summary ( database )

DBMS, primary key, and database 3 part definitions
Data Hierarchy
Access objects - 4 we use are tables, forms
table structure
Open the class database and add records
Create and print from Form
Create query through design not wizard
Systems Analysis & Design
CIS101 004  Week 12 Mon  11/9/09
No class on Wednesday
Homework:
1. Read Courseport Ch 14 online summary
2. CoursePort Ch 6 Student Edition Lab - Databases
complete ALL topics, there are 34 questions
 Due now:
PowerPoint BONUS Lab
CaseGrader #7 PowerPoint Case 2: CLient Services
Intro to databases, DBMS, and Access
CIS101 004  Week 11 Wed  11/4/09
Homework:
1. PowerPoint BONUS Lab
CaseGrader #7 PowerPoint Case 2: CLient Services

2.  Add Second Life to your Journal
both in literacy and
with a REFLECTION - was the experience new?
did you like it? easy/hard? etc
In classToday:  we did the Second Life bonus activities
and a WebCT quiz
CIS101 004  Week 11 Mon  11/2/09
Homework:
1. Read CoursePort Chap 11 online summary
Ecommerce - business models - strategy
2.  Chapter 10 online summary for Multimedia

3.   SECOND LIFE BONUS test will be in class together on Wed
be able to:  change appearance, put on clothes
communicate via local chat & IM
walk & fly
find somebody on map, teleport to a location from a Landmark

4. Be ready for PowerPoint - new features
custom animation & slide transition

Due Today:
CaseGrader Case #6 PowerPoint  #1 Elder@TechTravel
Facebook - turn in bonus paper
Second Life exercise in class
CIS101 004  Week 10 Wed  10/28/09
Homework:
1. BONUS Facebook Journal due Mon

2. Do CaseGrader #6 PowerPoint Case 1 Elder@Tech Travel

3.  Go to Second Life and find one educational site
set a landmark for it (not Ohio Univ)
change your appearance & clothing  
Review literacy paragraphs
Networks, Malware, Antivirus, Hoaxes, WEP, hackers
Facebook - group and bonus assignment
Go over MIDTERM grades
Second Life - change appearance, use Inventory, Search for places, Teleport
   be sure you create a Landmark on the Oakton island before flying off
CIS101 004  Week 10 Mon  10/26/09
Homework:
1. A page on literacy terms 
one paragraph each - include 3 part definition
and facts and uses to make 5 sentences,
personal experience/opinion
a. Antivirus  symantec.com  DOE cybersecurity
b. Computer Hoax - look at http://city-mankato.us
c. Encryption - WEP
d. hacker - white/black difference
PRINT and Submit in WEBCT  (10 pts)

2.  Read Discussion board on MALWARE
Reply to the other 2 posts

3. Have your Second Life account ready to go
create from home
Go to our Oakton Island using the SLurl on my homepage

4.  Write on the Facebook group wall
reply to the posted question
Discussed Social networking
Computer networks
Malware
Facebook - group, wall post
Second Life start in world,  walk, add friends
CIS101 004  Week 9 Wed  10/21/09
Homework for Mon 10/26:
1.  Look over the Second Life.com site
requires software installed on your computer
decide on your avatar name, create basic account from home 
you do NOT need to go into SL yet, wait for class demo

2.  Facebook - Find Humby, become friend,
and join our class group
find at least 2 friends from class

3. Read Ch 7  Online Summary (CoursePort)
Ch 9 Online summary
Due Today:
Facebook - Social Network
Create a Facebook account if you don't have one.  It may be ficticious name.
Research Facebook - history, creators, date,
purpose, use, popularity, social network sites in general
Write 1/2 page minimum with source URLs

JOURNAL - reflection from 9/16 on Word  & 9/28 storage devices you have
  add reflection on the Midterm Exam - hard, easy, how do you think you did?
                        and something you liked/learned in first 7 weeks
                                something you didn't like or was hard in first 7 wks

Social Networking (online)
real time or not  (synchronous  or  asynchronous)
WebCT Discussion board  vs  Elluminate
telephone  vs  US postal service

3D Social Network -
 Second Life - for education,  18 +
     avatar
     Professor Humby
 Webkinz - for kids
Networking -   components and security
CIS101 004  Week 9 Mon  10/19/09
Homework for Wed 10/21:
1.  WebCT Submit - Facebook - Social Network
Create a Facebook account if you don't have one.  It may be ficticious name.
Research Facebook - history, creators, date,
purpose, use, popularity, social network sites in general
Write 1/2 page minimum with source URLs. 
Today:
MIDTERM EXAM in class
Check your grades in WebCT
Go to TOP of page