Bring: 
Green scantron 
#2 pencil with working eraser 
Photo ID 



FINAL REVIEW FOR CS 103

Lectures on line at http://mason.gmu.edu/~montecin/CS103/

| Review lectures online   |  Review your text  |  Review your notes | Review your lab book |

I have included links to some material you need to review. 
But review all lectures since the test is cumulative. 

Bootstrap process
Operating System - types and functions
RAM, ROM 
Virtual memory 
GUI
LYNX
PINE
PICO
ASCII
BITS AND BYTES
ASCII
CHARACTER
 BITS
A
0100 0001
B
0100 0010 
 C 
0100 0011 
HOW MANY BITS IN A BYTE?

HOW MANY BYTES IN A: 

GIGABYTE?
KILOBYTE?
MEGABYTE?

Storage Device technologies - types, properties, random/sequential access, how data is represented

What is a driver?

What is a port?

what is a peripheral device?

What is a pixel? 

Wordprocessing - templates macros

Spreadsheets - relative and absolute cell addresses, What-if functionIf-then function -

ACCESS - What is a relational database? Review database structure.

FILE "PATH" hierarchy/structure:


What is the unit of measurement for  RAM?
for processor speed?
hard drive capacity?

What is a reasonable range of specs in the categories above for a new computer today?

What's a compiler?
PGP 
ENCRYPTION - define, software -  examples

Computer ethics: security, safety, and privacy issues
Computer health issues - computer related - ergonomics ,eye strain, 
Links to repetitive stress/strain injury (RSI),  carpal tunnel syndrome sites

Computer Laws and Ethics: The CDA (Communications Decency Act), CFAA (Computer Fraud and Abuse 
Act), Virginia Computer Crimes Act, and ECPA (Electronic Communications Privacy Act), SAFE Act 
Review Laws Relating to Computing (http://www.cs.gmu.edu/~amarchan/cs105/law.html)
Computer Laws and Ethics lecture: http://mason.gmu.edu/~montecin/CS103/lec13ethics-lawWEB.htm

Review library search strategies (http://mason.gmu.edu/~montecin/CS103/lec10-library.htm)

Copyright Issues and plagiarism  (http://mason.gmu.edu/~montecin/plagiarism.htm)
Copyright and the Internet  (http://mason.gmu.edu/~montecin/copyright-internet.htm)

Review Programming Languages  (http://www.cs.gmu.edu/~amarchan/proglang.html)

Types of Viruses and examples.  Difference between a bug and a virus

Y2K

Names given to people who commit high tech crimes

Define and specifiyat least  5 ways to keep data secure

CPU - Parts and their functions (in a PC) 

Domain name

TCP/IP Address

JAVA 

hypertext

Boolean logic  (http://mason.gmu.edu/~montecin/engines.htm#boolean)

Computer Evolution - dominant early machines

History of Computer Science: Pascaline, Jacquard Loom, Babbage/Byron, A. ,Difference Engine, Atanasoff Berry Computer, Alan Turing, Ada Byron, John Atanasoff

AI - history, key figures 

AI machines

Games

Natural language processing 

Expert systems

Virtual Reality 

Neural Networks

Common sense project

Types of Questions : True False, Multiple Choice 

Examples of types of questions - 

 1.      What is a Megabyte?
 A.      256
 B.      about a 1000
 C.      about a million
 D.      a measure of processor speed

 2.      A spreadsheet cell address, such as $F$1 is referred to as a/an:
 A.      absolute address
 B.      relative address
 C.      formula bar
 D.      rural route

 3.      Which of the following was a programming language developed for
  teaching programming in the 1960s: 
 A.      COBOL
 B.      BASIC
 C.      Ada
 D.      Pascal

4.      Use the sample database below for the next three questions:

Restaurant                 Food            City            Average Meal
Juan's Place             Mexican      Chantilly          $10.95
The Olde Fox           British         Vienna              $12.95
Casa Grande            Mexican     Vienna              $11.50
The Green Dragon  Chinese       Fairfax             $10.00
Chez Lucien             French         Fairfax             $16.95

5.      How many fields does each record have?
A.      4
B.      5
C.      20
D.      24

6.      How many record(s) would be retrieved if the database is given the query:
        LIST Food=Chinese OR Average Meal <= $12.00

A.      0
B.      1
C.      2
D.      3

7.      If the database is sorted by City (primary sort key) and by Food (secondary sort key), what will be the  new order of the records?
A.      Juan's Place, The Olde Fox, Casa Grande, The Green Dragon, Chez Lucien
B.      The Olde Fox, The Green Dragon, Chez Lucien, Juan's Place, Casa Grande
C.      Juan's Place, The Green Dragon, Chez Lucien, The Olde Fox, Casa Grande
D.      Casa Grande, Chez Lucien, The Green Dragon, The Olde Fox, Juan's Place

8.  Given the following spreadsheet:

         A         B          C 
____________________________
1       30      100
2       20      200
3       30

Assume the formula in cell C1 is =A1+$B$1.  What will be the value in cell C2 when the formula in C1 is filled down into C2?

A.      130
B.      220
C.      230
D.      120

Lynx is:

A.  an operating system.
B.  an text based Web browser
C.  a programming language
D.  a library database

In the evolution of MODERN computers, this technology came first:

A.  integrated circuit
B.  vacuum tube
C.  transistor
D.  IDE
 

 

Lectures on line and course material