MIDTERM REVIEW 2012

For the Midterm, please study from your notes (from the PowerPoint Presentations I showed you in class and any handouts I gave you. Also study from your Tests and Quizzes. There will be two timings for this exam: a 3-minute timing and a 2-minute timing – I’ll let you know which ones you’ll do the day of the exam. You may want to practice 3-minute timings (from the Timed Writings) and the Measurement Writings (2-minute timings) of the Skill Builder Lessons.

1. Computer Concepts: (STUDY YOUR COMPUTER CONCEPTS’ NOTES)

What is a computer? What is hardware (name the four types of hardware)? What are Input Devices (name four and define)? What are Output Devices (name four and define)? What is the Central Processing Unit? What are storage devices (name four and define)? What is software (name the two types of software)? What is Digital? What is RAM? What is ROM? What are binary numbers? What is a bit? What is a byte? Kilobytes? Megabytes? Gigabytes? What is a network? What is a server? What is the Internet? What are telecommunications? What are modems? What is the World Wide Web? What is a Web Site? What is a Web Page? What is a Web Browser? What is a URL (give one example)? What is “http”? What is a “domain”? What are URL identifiers (give four examples)?

Vocabulary: Digital, Digital System, Digitize, Bits, Bytes, Kilobytes, Megabytes, Gigabytes, Ergonomics, Ergonomists, Posture, Christopher Latham Sholes, QWERTY, Computer, Hardware, Input Devices, Memory, Integrated Circuits, Processing Devices, Central Processing Unit, Output Devices, Software, Data Bus, Storage Devices, Inkjet Printers, Laser Printers, RAM, ROM, Network, Server, The Internet, Connectivity, Telecommunications, The World Wide Web (WWW), Web Site, Web Page, Web Browser, Domain, URL, Copyrights.

2. What are Copyrights? Why are they important?

3. Ergonomics:

What is ergonomics? Why is it important to follow ergonomic rules? Name four ergonomic rules (or tips). What are ergonomists? What is the right ergonomic position you should use when typing (mention four rules)? Why is good posture important?

4. KEYBOARDING:

a. Home Row Keys: Which are the letters of the Home Row? Which fingers do you use to type the Home Row keys? What is the first goal in Keyboarding?

b. What is Touch-Typing?

c. Which letters does each finger type (mention both left and right hand fingers)? What fingers do you use to key the Space Bar?

d. Who invented the “Type Writer”? When? What is the official name of the present keyboard? Why was the first typewriter designed to slow down the typist?

5. EXCEL:

We will start learning Excel this month. You will have to study whatever we cover during the week before the exams (January 17 – 20). There may be a small Excel exercise (similar to the ones practiced in class) in the Keyboarding Midterm (if we cover this before the Exams).

a. What is Excel? What is a Spreadsheet? What is a Workbook? What are Worksheets? What is the Worksheet Area? What are rows? What are columns? What are “cells” in Excel?

b. Mention at least six elements or parts of an Excel Worksheet and explain what these are.

c. What is the “cell reference”? What is an “active cell”?

d. What is the AutoFill Fill Handle?

e. What are the five Automatic Features of the Excel Program? The “AutoComplete” Feature, The “AutoCorrect” Feature, The “AutoFill” Feature, The “AutoSum” Feature and The “AutoCalculate” Feature. Understand what these are.

If you have any questions, please feel free to ask Mrs. Feld.