Final Exam covers content from entire semester and is worth up to 100 points (20% of your grade). There will also be a few extra credit questions.
Last updated 4/30/2009 at 10:25 AM --> Modified "Final Days" section
Technology In Action Material
Unit 1: Chapter 1
1.1 What does it mean to be “computer literate”?
Unit 2: Chapter 3
3.1 How can I communicate through the Internet with Weblogs, VoIP, wikis, e-mail, chat?
3.5 What is a Web browser?
3.6 What is a URL, and what are its parts?
3.7 How can I use hyperlinks and other tools to get around the Web?
3.8 How do I search the Internet using search engines and subject directories?
3.10 How do I evaluate a Web site?
3.14 What is the origin of the Internet?
- What is Web 2.0?
- Key events in Internet history: ARPANet, WWW, Web Browser,Internet, Internet Explorer, Firefox
Unit 3: Chapter 4
4.1 What’s the difference between application software and system software? (p. 162)
4.2 What kinds of applications are included in productivity software I might use at home? (pp. 162–175)
4.8 Where can I go for help when I have a problem with my software? (pp. 187–188)
From Active Help Desk, Avoiding Computer Viruses
- What is a computer virus?
- How do you get different types of viruses? What are they? Trojan horses, worms
- See Active Help Desk Cheat Sheet
From Textbook and PowerPoint slides
- Computer Threats
- What is cybercrime?
- What's the difference between white-hat and black-hat hacker?
- Name several ways to protect yourself from identity theft
- What is a backdoor program?
- What is a denial of service attack?
- What is social engineering and how can you protect yourself from it?
- Protecting yourself
- What is encryption?
- What makes a "good" password?
Unit 6: Hardware
2.1 What exactly is a computer, and what are its four main functions?
2.2 What is the difference between data and information?
2.3 What are bits and bytes, and how are they measured?
- Know abbreviation and approximate number of bytes for each of the following
- kilobyte, megabyte, gigabyte,
2.4 What devices do you use to get data into the computer?
- Different types of mice
- Touchpad, pointing stick
2.8 What's inside your system unit?
- Key terms (see p. 84): binary digit (bit), byte, central processing unit (CPU, or processor), connectivity port, data, drive bay, ergonomics, expansion card (adapter card), expansion slot, gigabyte (GB), hard disk drive, information, input device, kilobyte, megabyte, nonvolatile storage, port, random access memory (RAM), system unit, toggle key, touchpad, trackball mouse, USB, video card, volatile storage
5.1 What software is included in system software?
5.4 How does the operating system provide a means for users to interact with the computer?
5.6 How does the operating system manage memory and storage?
5.7 How does the operating system manage hardware and peripheral devices?
5.11 How does the operating system help me keep my computer organized?
5.12 What utility programs are included in system software, and what do they do?
- Key terms (see p. 246): command-driven interface, device driver, Disk Cleanup, disk defragmenter, file compression utility, file management, file path, graphical user interface (GUI), operating system, Plug and Play (PnP), real-time operating system, single-user multitask operating system, single-user single-task operating system, swap file, system software, Task Manager utility, Task Scheduler utility, thrashing, user interface, utility program, virtual memory
- Key terms: arithmetic logic unit (ALU), cache memory, control unit, gigahertz (GHz), megahertz (MHz), motherboard
- Refer to Ethics slides posted in Blackboard
- Ethics in Computing, p. 146
- Intellectual Property, p. 150
- Key terms: copyright, fair use, intellectual property
- Entering Data
- Entering and editing cell content: text, numerical values, numeric labels and date values
- Entering a range of data
- Modifying cell contents
- Clearing and editing cells
- Finding and replacing cell content
- Editing a Worksheet
- Deleting columns and rows
- Inserting columns and rows
- Merging cells
- Selecting cells and ranges
- Using Cut, Copy, Paste
- Using Copy and Paste Special
- Formatting Worksheets
- Changing fonts and font sizes
- Applying different number formats
- Changing cell alignments
- Adding borders, shading, and colors to cells
- Modifying column widths and row heights
- Hiding and unhiding columns and rows
- Applying Bold, Italic, and Underline
- Using Formulas and Functions
- Using operators in formulas
- Understanding and using operator precedence
- Entering and editing formulas
- Using relative & absolute references in a formula
- Using functions
- Applying simple Excel functions: SUM, AVERAGE, MAX, MIN, IF
- Analyzing Data
- Working with Charts
- Using the Chart Wizard to create charts
- Modifying and formatting a chart (chart title, axis titles, data labels, legend)
- Moving a chart to new worksheet
- Using Quick Chart Layouts
- Managing Worksheets
- Renaming worksheets
- Insert and delete worksheets
- Move and copy worksheets
- Navigating through worksheets in a workbook