Test Review

Review 3 © R. Craig Collins, 2005

Table of Contents
1. Introduction to Computers
2. The Internet and World Wide Web
3. Application Software
4. The Components of the System Unit
5. Input and Output
6. Storage
7. Operating Systems and Utility Programs
8. Communications and Networks
9. Database Management
10. Computer Security, Ethics, and Privacy
11. Information System Development and Programming Languages
12. Enterprise Computing

Test 1: 1, 2, 7, 3, 4, 5 Word

Test 2: 6, 8, 9 Excel

Test 3: 10, 11, 12 Access and PowerPoint

Discovering Computers 10: Security, Ethics, and Privacy
Distinguish between hackers, crackers, and script kiddies.
Compare and contrast viruses, worms, Trojan horses, Denial of Services, and the symptoms of each.
What is spoofing? Phishing?
What is the best deterent when it comes to preventing unauthorized computer access? Password
Name three software tools to prevent unauthorized computer access. Name the device that identifies users. Antivirus, antiad.spyware, popupblocker
List a way to prevent unauthorized network access. Firewall
List two ways to prevent hardware theft (one to prevent use, one to prevent removal) biometric, chain
Is wireless networking more or less secure? Why? Name a solution to network protection.
Name a device to protect your system from failure, and a procedure to protect your data. RAID, backup
Briefly discuss copyright.
Comment on protecting your identity and privacy. Include cookies, spyware, and adware.
What is ergonomics and how does it relate to computing?

Technology TrailblazerL Clifford Stoll

Discovering Computers 11: System Development Cycle
Understand:

				1. Planning

			5. Support		2. Analysis

					3. Design
			4. Implementation
	1. Analyze

6 Document		2 Design


5. Test		3 Validate
	4. Implement

Direct Converstion vs. Parallel conversion vs. Phased conversion vs. Pilot Conversion
Ist generation programming language: machine (1s and 0s)
2nd generation programming language: assembly (symbolic code)
3rd generation programming languages: procedural (english like)

Interpreted		Compiled
Web pages		Cobol, Ada
Basic		Object oriented (Java or C++)

Visual Programming and Computer aided programming
4th generation programming languages: (non-procedural, SQL in databases)

Sequence control: IF then-else
Repetition
Do-while (tests at beginning of loop)
Do-until (tests at end of loop)

Technology Trailblazer
Commodor Grace Hopper, developer of Cobol

Discovering Computers 12: Enterprise Computing
Discuss Information Systems (hardware, software, data, people,and procedures)
Who uses Management Information Systems, and what are exception reports
Who uses Decision support systems, and is it for current use, or planning?
Describe an expert system. What does it capture? What is it's function?
Compare and contrast intranets, the internet, and extranets
What is RAID, and what is it good for?
What is a LAN?

PowerPoint Tips
Access: Implementing Database theory
What must be in place before a query on several tables can be created?
What are the four logical operators used in queries?

What is can allow you to display results in rows and columns, such as salemen AND sales?

How can you get Access to ask you for a query parameter at the time of query execution, rather than at the time of the query design? What button runs a query?