KEYBOARDING MIDTERM

On the week of January 18th you will have your Midterm Exams. For the Keyboarding 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 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 are 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)?

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. MICROSOFT WORD:

a. How do you insert a Table in Word? Practice inserting a table and reviewing a couple of the exercises we did in class (like Exercises No.1 and No. 2).

Check the "keyboardingm" folder in the Server (Labserver). There you can find some PDF and Word documents that you can check to review your material. You can print the puzzles or other Review documents and solve or Review them.

January 2010

HAPPY NEW YEAR! It's hard to believe it's the year 2010... I wish you all the best!

I'm sure this month will go as fast as the previous month of December - you will be having your Midterms from January 19th - 22nd, and yes, there's a Keyboarding Midterm (and a Keyboarding Final Exam)! We will review for this test on the second week of the month.

You will also continue with your Keyboarding Skill Builder Lessons. Remember that you must complete these lessons both as Emphasis (or Focus) Accuracy and Speed. You must print the Assessments (Windows MicroType Program) and the Lesson Reports and put them in your binders. If you have any questions, please feel free to ask Mrs. Feld.

You may want to review a few lessons from the Alphabetic Keyboarding Lessons, especially if you feel that you need reinforcement and are typing less than 35 words per minute (GWAM). It is ery important to repeat lessons if you're still using the WRONG FINGERS! You should have mastered ACCURACY by now; if not, you have some reviewing to do. I suggest to try to practice on your free time as well. Remember to PRACTICE, PRACTICE, PRACTICE. Continue challenging yourself!

We will also start with Excel - the Spreadsheet Application, andyou will start learning how to enter some simple basic formulas in a spreadsheet and how to create some simple tables and charts. I will give you the "Introduction to Excel" Handout. Please keep it in your Keyboarding Folder. If your folder is too full or falling apart, please buy another one to keep your Keyboarding papers.

Microsoft Excel is a spreadsheet application which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs (charts), and statistical analysis.

You can use an Excel spreadsheet to create financial statements, prepare budgets, manage inventory, and analyze cash flow. Numbers and values can be easily manipulated in an Excel spreadsheet to answer "what if" questions and by inserting formulas to perform calculations (to add, subtract, multiply and/or divide values).

A document created in Excel is called a workbook. A workbook consists of individual worksheets (check the tabs at the bottom of the Excel window). The intersection of columns and rows in a worksheet is referred to as a cell.

COPY THE ABOVE THREE PARAGRAPHS -AND THE VOCABULARY BELOW- AND PASTE THIS INFORMATION IN A WORD DOCUMENT ("EXCEL NOTES").

Vocabulary: (you must study and understand the meaning of the following words)

Excel
Workbook
Worksheets
Cell (Active Cell)
Title Bar
Menu Bar
Standard Toolbar
Formatting Toolbar
Name Box
Formula Bar
Sheet Tabs
Worksheet Area
Columns (Column Identifiers)
Rows (Row Identifiers)
Scroll Bars
Gridlines
Cell Reference (Cell Address)
Status Bar
Cell Pointer
Automatic Features (AutoFill, Auto Complete, AutoSum, AutoCorrect, AutoCalculate
AutoFill Fill Handle (or AutoFill Handle)