The written lab material from your Microsoft Office 2000 book.
The test covers 2.12 (Spreadsheets), 1.50-1.60 (History of Computing), 14.20-14.22 (Privacy),
all of 10(Database), and 7.12 (Searching topics) and 8 (OS and Utilities)
in your Discovering Computers 2001.
It also will include the four worksheets,
Relative versus Absolute Addresses in a Spreadsheet (Excel)
Functions in an Spreadsheet (Excel)
Database Queries I and II. (Access)
Topics from lecture such WWW searching techniques, graphics (charts and graphic format
and production) and history of computing will also be covered.
The lecture test will also use the reading material from Labs 6 through 12.
Hints on how to study for the lecture exam:
Discovering Computers 2001
Thumb through the covered chapters and look for the words in bold.
If a term is unfamiliar to you, reread that section. This assumes that
you have read it once before.
Go to the Checkpoint at the end of each section.
Make sure that you can define the key terms. If you cannot define these or say
something intelligent about the term, look it up in the chapter.
Answer matching and short answer questions in the Checkpoint.
Take the practice test from the web.
Worksheets
Material for the exam can also be taken from the worksheets.
Determine if you can do these problems.
If you cannot, review this material. The material for the spreadsheet cell addressing
and function concepts is in the original handout and also explained in your Microsoft Office 2000 book.
(See the links to the handouts below or go to CS 104 Vitual Office -> Worksheets)
The background material for the queries are in the lecture notes or in Microsoft Office 2000 book.
Access I
Access II
Other Lecture Material
Lecture material not directly included in Discovering Computers 2000 book can also
be used.
Remember Technology changes daily!
Review the points listed below in the section Other Lecture Material.
Make sure you can say something (definition) about each topic.
If not review the presentation on the Web.
Labs
Material for the exam can also be taken from the labs.
Review your Homepage lab handout,
Review the (handouts) Projects covered in Microsoft 2000 Office book (Labs 6 through 12).
Again, use the same technique as you did for the Discovering Computers 2001 book.
Make sure you can can define the words listed in italics. Important concepts
are also listed on the sidebar of the page. For example see project 1 section E1.6 for the
definitions of worksheets, charts and databases.
Reviewing these will also help review for your lab test.
Topics covered in lab are listed in second half of this document.
Topics for CS 104 Lecture Test 2
LECTURE and Reading MATERIAL FROM Discovering Computers 2001
Spreadsheets
The following terms are important to know:
spreadsheet
icons
control panel
work area
cell
current cell
active cell
range-block
worksheet
Basic Spreadsheet Features
Uses
Cell addressing - rows and columns
Data types in cells, value or labels
formula, functions (MAX, MIN, SUM, COUNT, AVERAGE)
Functions in a Spreadsheet Handout
Spreadsheet navigation
Spreadsheet commands (Move, copy, insert, delete, format, print, etc.)
Graphics
Bar graphs
pie graphs
line graphs
Spreadsheet Referencing.
Review
Worksheet on Relative versus Absolute Addressing in Spreadsheet
relative
absolute
History of Computing
We covered this timeline by a powerpoint presentation.
first computers (the earliest we saw was the ENIAC)
all the generations of modern day computers were shown
Moore's Law
Metcalfe's Law
OS
User Interfaces
features and functions
Windows XX
Utility Programs
Databases
The following terms are important to know:
database
field
record
data dependence
data redundancy
data integrity
data security
file management program
flat file
The 6 important objects in an Access DB
TABLES
QUERIES
FORMS
REPORTS
MACROS
MODULES
database management system
hierarchical databases
network databases
relational databases
object-oriented databases
data definition language
schema
data manipulation language
queries (see Query Lecture)
report generator
Uses of a Database
Types of Databases
Parts of Databases
Queries in Access
Queries in Access (part 2)
Computer Security and Privacy
The following terms are important to know:
e-mail
CLipper chip or Key Escrow microcircuit
wiretapping
data encryption
record matching
computer viruses
worm
trojan horse
file infectors
boot sector virus
vaccines
callback system
cookies
Right to Privacy
E-Mail, Databases, Credit Reporting, Electronic Funds Transfer
Security
OTHER LECTURE MATERIAL
Searches on the Web (Searches Lecture )
Search engines and directories
differences
where to find
techniques for smart searching
use of " "
+ and -
capitalization
boolean operators
analyzing the outcome
use more than one engine
Find command
LABS
Lab 6: Introduction to Computer Spreadsheets (lab 6)
Rows and Columns, Cells, Worksheet
labels, values, formulas
formula development and evaluation
entering data into a spreadsheet
block
formatting: (general,fixed, currency, comma, percent...)
Lab 7: Spreadsheet Formulas (lab 7)
Inserting Rows and Columns
Deleting Rows and Columns
Using Absolute Cell References
Functions
Sorting
3-D Formulas
Lab 8: More Excel Part III: Charts and Maps (lab 8)
Chart types
Lab 9:Creating and Viewing HTML(lab 9)
Homepage creation
index.html
template
hyperlinks
uploading
copyrights
LAB 10: Setting up a Database with Microsoft Office (lab 10 )
Access objects - tables, queries, forms, reports, macros, and modules
different views
data types
copying database files
switchboard
adding or deleting records
primary key
form versus datasheet
LAB 11: Customizing a Database (lab 11 )
creating tables
Field properties
query (filter - a single table query)
Queries I
database design
criteria
multiple conditions - conjunctions (AND, OR)
save queries
customize a form view - decorate and labels, rearrange
reports
LAB 12: Maintaining a Database (lab 12 )
multi-table queries
more customizations
relationships : 1:1, 1:many, many:many
joins
Queries II