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
HOW MANY BYTES IN A:
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 function , If-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?
Computer Laws and Ethics: The CDA (Communications
Decency Act), CFAA (Computer Fraud and Abuse
Review library search strategies (http://mason.gmu.edu/~montecin/CS103/lec10-library.htm)
Copyright Issues and plagiarism (http://mason.gmu.edu/~montecin/plagiarism.htm)
Review Programming Languages (http://www.cs.gmu.edu/~amarchan/proglang.html)
Types of Viruses and examples. Difference between a bug and a virus
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)
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
Natural language processing
Common sense project
Types of Questions : True False, Multiple Choice
Examples of types of questions -
is a Megabyte?
2. A spreadsheet
cell address, such as $F$1 is referred to as a/an:
of the following was a programming language developed for
4. Use the sample database below for the next three questions:
5. How many fields
does each record have?
6. How many record(s)
would be retrieved if the database is given the query:
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?
8. Given the following spreadsheet:
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. an operating system.
In the evolution of MODERN computers, this technology came first:
A. integrated circuit