EXCEL and Third Quarter

On January 23rd we started our Third Quarter. We will continue learning EXCEL - the Spreadsheet Program, and we'll work on a few more exercises and learn how to create charts. We will also cover part of Chapter 5 (Microsoft Office 2010 textbook). Every Friday you will do a Timed Writing, that you will print for Mrs. Feld (2-minute and 3-minute). There are 13 Timed Writings, you can do the ones you haven't done yet and/or repeat others. Mrs. Feld may add some new ones as well.

Excel Test: Friday, February 10, 2012. Review your Excel notes (from PowerPoint presentation) and the handouts Mrs. Feld gave you - the Excel Simple Formulas Paper and the Spreadsheets and Excel Paper. You must understand basic formulas (addition, subtraction, multiplication, division, average, square root and numbers squared). You will also have an Excel exercise (to create a table) and will have to create one or two charts. If you have any questions, please feel free to ask Mrs. Feld.

Vocabulary: Excel, workbook, worksheet, ribbon, active cell, cell, title bar, quick access toolbar, name box, cell address or cell reference, formula bar, scroll bars, sheet tabs, worksheet area, gridlines, status bar, column, column identifiers, row, row identifiers, cell pointer and AutoFill Handle (or Fill Handle). Also the "automatic features" in Excel (learn to identify them): AutoSum, AutoFill, AutoComplete, AutoCorrect and AutoCalculate. When do you see number symbols (###) in your cells? What are labels? What are values? What are formulas? Which sign or symbol must be entered first when entering a formula in Excel? How do you change the column width in Excel? How do you change the row height? How do you change the alignment of titles or text in cells? How do you "wrap" text in cells? How do you add borders to your table? What is a chart?

A chart is a visual representation of worksheet data. A chart can enhance and simplify the understanding of numerical data in a worksheet because the relationship between data is illustrated. You can check your notes and Chapter 5 in the Microsoft Office 2010 textbook to answer some of these questions. Also check the Chapter Summary.

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.