REVIEW FOR FINAL EXAM

The Final Exam will cover the material learned after the Midterm (January 2013). Please review the following and study from your notes, tests, puzzles and exercises:

EXCEL:

1. What is Excel? What is a cell? What is an “active” cell? 
2. When can you use Excel? 
3. What is a formula in Excel? How do you enter a formula in Excel? Which sign should you enter first? 
4. What is a workbook? What is a worksheet? 
5. How many default worksheets are in a workbook? 
6. What is the Auto Fill Handle (or AutoFill Fill Handle or simply Fill Handle)? How do you use it?
7. Which are four automatic features in Excel? Explain all of them. Know the difference between these features. 
8. How are columns in Excel labeled? How are rows labeled?
9. How is an entire column selected? How is an entire row selected?
10. What is a  “cell reference”  or  “cell address ”? When does a cell display ###?
11. How do you use the AutoSum feature?
12. Which is the Excel Formula that adds the numbers in cells A1 through A6?
13. Which is the Excel Formula that multiplies the numbers in cells B3 and C3?
14. Which is the Excel Formula to calculate the average of the numbers in cells B3 to B8?
15. We will have an Excel Exercise. Study your Excel Test. Review Excel exercises. Practice creating charts (column, pie, line, etc.) and review the Blog Entry of February 4, 2013.
16. Study the Excel Review Paper Mrs. Feld will give you, and practice the exercise. There's a mistake in the Excel exercise with the term "First Quarter," since a quarter refers to three months not four; but this won't affect anything. It's basically the Total Sales for the First Four Months of the Year (January, February, March and April).

True/False Excel Practice:

1.  A cell reference consists of a column letter only.

2.  Selected cell and active cell mean the same thing.

3.  The contents of the active cell are displayed in the Name Box.

4.  A cell’s alignment can be changed.

5.  A cell address is also called a cell reference.

6.  The “AutoComplete” Feature in Excel will automatically insert data in a cell that begins the same as a previous entry.

7.  The “AutoCorrect” Feature automatically formats your data to your liking.

8.  The “AutoFill fill handle” is the white cross (pointer) in an Excel workbook.

9.  The “AutoSum” feature in Excel allows you to add and calculate the sum of a list of numbers in your worksheet.

 10.  The multiplication symbol in an Excel formula is an “x.”

 11.  The division symbol in an Excel formula is represented by a slash (“/”).

 12.  All formulas must start with an equal sign (=).

 13.  Any expression in a formula that is enclosed within a parentheses is calculated first.

 14.  Certain formulas can be entered in Excel without entering an equal sign.

 15.  To enter "today's date" formula in Excel you enter =TODAY().

 16.  The "AutoCalculate" feature in Excel is a shortcut that allows you to view the calculation for a selected range of cells without placing a function in a cell.

FORMATTING DOCUMENTS USING MICROSOFT WORD:

1. What are Tab Stops? Mention four types of Tab Stops. Which is the most popular one?
2. What are Indents? Indent Markers? What is a Hanging Indent? First Line Indent? 
3. What are the default Tabs in Microsoft Word? 
4. How do you remove a Tab Stop from the ruler? 
5. How do you select a different Tab Stop? (Where do you go?) 
6. What are Margins? How can you change the Margins? (Mention two ways) 
7. What are Indents? How can you change the indentation of individual paragraphs in a Word document? What is a Hanging Indent? What is a First Line Indent?
8. How do you insert a Page Break in a document? (Mention two ways) 
9. How can you change the line spacing in a Word document? (Mention two ways)
10. What are bullets? When do you use them? How do you insert bullets in Microsoft Word 2010?
11. How do you insert a Header and Footer in a Word Document? When do you insert a Header and/or Footer? What is a Header? What is a Footer?
12. Study the PowerPoint Presentation and your test. Review the Formatting Documents Exercises done in class (from the Microsoft Office Textbook).

BUSINESS LETTERS:

1. What are Business Letters? When do you use them?
2. What is a “personal” Business Letter? What is a “regular” Business Letter?
3. Mention the 10 Basic Parts of a Business Letter. Describe each of them. (You should know well what each part is)
4. What are the three styles of Business Letters? Which is the most popular one? Describe them. (Know the difference between the different styles)
5. How should you type the date in a Business Letter?
6. What is another name for the “Greeting”? It normally begins with the word …
7. The “Closing” is also called…
8. When do you add the word “Enclosure(s)” in a Business Letter?
9. Can you add “Postscripts” in a Business Letter?
10. Can you use “lined paper” when typing a Business Letter?
11. Can you use  “Fancy Fonts”?
12. Study the PowerPoint Presentation and your test (review the Business Letters Exercises done in class, check the Microsoft Office Textbook).

Study the last test (Mrs. Feld will give you this test as soon as possible, one student still has to take it). There will also be a two minute timing. If you have any questions, please feel free to ask Mrs. Feld.

Third Quarter - Excel Exercises & EOFC Project

This Third Quarter we will continue with a few more Excel Exercises and then, after the test of February 26 we will start the "Exploring Our Future Careers (EOFC) Project."

On Thursday, February 28, 2013 you will create an exercise similar to the Excel Exercise No. 5 (BSC Ex 05). You can work in groups of two (but each student has to create this exercise). You will go to the following websites and do some research on the 15 highest paying jobs in 2011 and/or 2012. You will visit: Jobs 1 and Jobs 2 (click on these links) and copy the data for Average Annual Salary and Current Employment into an Excel Workbook (use the nbc.com site for gathering your data). You will create a Table (Spreadsheet) on Sheet 1 with the following information: Jobs, Average Annual Salary and Current Employment and enter the necessary information there. Your table must have a Main Title and Subtitles. Enter the data, format the numbers properly (Currency - No Decimals), and Sort the information from Largest to Lowest Salary (unless you already entered the information this way). Copy this table (all the information on Sheet 1) and paste it on Sheet 2 (you need it on Sheet 2 to create a Pie Chart there later).

Create a Column Chart on Sheet 1 of the 6 highest paying jobs only (highest Average Annual Salary). The Column Chart should have a main title and Axes Labels (title for y axis and title for x axis), also add Data Labels (to view the salaries on top of the columns). Then go to Sheet 2, Sort the information on Current Employment from Largest to Smallest (select all columns to do the sort) and create a Pie Chart with the Current Employment Data of the 6 Careers that employ the most people in the USA (the Pie Chart should have Data Labels - Values and Percentages). Enter your Name and Period Number in the Footer and the Today's Date formula under the tables (Sheet 1 and Sheet 2). Put the Charts below the tables (on Sheet 1 and Sheet 2) and print the worksheets for Mrs. Feld (with your Name, Period No. in the Footer of both worksheets). Change the margins if necessary, so that everything looks centered nicely on the page (good presentation). If you have any questions, please feel free to ask Mrs. Feld.

EOFC Project:

Mrs. Feld will give you a handout and explain the project. Please read the instructions carefully and spend a good amount of time researching the type of careers you think you'll be interested in pursuing in your future.

Goal: to do some research about possible future careers. Students should select at least six “possible” future careers (even if it’s different careers in just one field, e.g. Healthcare). Each field of interest has many different possibilities.

You will work individually for this project (it is not a “group project” – but you can help each other while you’re working on it).

The websites to check are: http://www.bls.gov/. From this site you can also go to: www.bls.gov/k12/index.htm, www.bls.gov/k12/azlist.htm, http://www.bls.gov/oco/home.htm (Check the Occupational Outlook Handbook, OOH 2010-2011). You can also check: http://www.bls.gov/oes/2008/may/oes_alph.htm for an alphabetical list of careers. You can also go back to the links above (Jobs 1 and Jobs 2) for more information.

Other good sites are:
http://www.usnews.com , http://money.usnews.com/money/careers/articles/2012/12/18/the-best-jobs-of-2013 and http://money.usnews.com/careers/best-jobs/rankings/the-100-best-jobs (Explore Careers, Browse Occupations, Salary Information)  
careerpath.com/defaultb.asp

http://www.myplan.com/careers/top-ten/highest-paying.php

http://www.superscholar.org/highest-paying-jobs/

http://www.becomecareer.com/highest-paying/50-best-and-the-degrees-you-need-for-them

Take a personality test at: TEST (click the word TEST for the link). This test is based on Carl Jung and Isabel Briggs Myers typological approach to personality. You can also try QUIZ. This quiz will help you understand your inner self. Why you behave or make certain decisions. Whether you're doing research on career paths or trying to understand your relationship with others, or just trying to make sense of the world - this quiz will help you get to know yourself better. To analyze your psychological type profile check: http://typelogic.com. Also, in Google you could enter your personality type e.g. "ENFP careers" and check different websites suggesting careers for you. This is just to help you get ideas on careers.

The Word Document - with a brief description of your careers and with information on the Average Annual Salary and an Estimate on the number of jobs available (Current Employment) for that profession in the United States (or locally, if you prefer to select a particular city or state) - is due: Friday, March 8, 2013. Please: no more than two pages long. You will save it in the Server (don't print!).

You will also create Excel Worksheets and Excel Charts and then a PowerPoint Presentation explaining the careers chosen, including the Excel Tables and Charts.

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

“All our dreams can come true, if we have the courage to pursue them.”  ~ Walt Disney
 
“Be courageous! Dare to explore what you love and what is most important to you. Don’t waste time assessing yourself as you are now. Dream and plan for who you want to be in the future.”
~ Betty Jo Matzinger Lash, Associate Director, Georgetown University Career Center
 
“When looking for any position, I look for people who have a grasp of computers and good communication skills. I also look for people who can work well with others, adapt easily to change, and be creative when looking for new ways to do things.”
~ Debbie Bornholdt, Human Resource Manager QVC, Electronic Retailer West Chester, PA

EXCEL

This month of February we will concentrate on Excel. You will also learn how to create charts using the Spreadsheet exercises you did in class and also work on some of the Textbook exercises. We will read and study Chapter 7 (Microsoft Office 2010 Textbook) and lean about Charts and how to create them.

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 will do the "Continents" Exercise on page 269 (two-part exercise). Follow the instructions carefully! You will create a Column Chart for Excel Exercises 1 and 2. Also a Pie Chart for one of the data series (one of the columns with numerical data) for those exercises. Mrs. Feld will explain in class.

You will also complete the "Temperature" Exercise on page 276 (two-part exercise). Also follow the instructions carefully!

On Tuesday, February 5th, you will have an Excel Quiz (Quiz 1) - Excel Exercise. You will have to calculate the totals and the averages for the columns with numbers, and the totals for the rows with numbers, like you did in class. Remember to use the AutoSum function and the AutoFill handle to quickly enter the formulas into the cells. Also remember the Average formula (there are three different ways of entering averages in a spreadsheet).

On Friday, February 8th, you will have another Excel Quiz (Quiz 2) - Excel Exercise similar to Exercise No. 3, to practice multiplication.

Formulas learned to date

Sum (addition):  =SUM(range of cells you are adding here). Example: =SUM(B3:B8) or =B3+B4+B5+B6+B7+B8
Multiplication: =PRODUCT(range of cells you are multiplying here). Example: =PRODUCT(B3:C3) or =B3*C3
Average: =AVERAGE(range of cells you are using here - without including the Total). Example: =AVERAGE(B3:B8) or =B9/6 (if your total for B3:B8 is in B9)

Ask Mrs. Feld if you have any questions. You will have an Excel Test on February 26th.

Vocabulary you must know: cell, active cell, cell address (or cell reference), name box, columns, rows, data, worksheet area, AutoSum, AutoCalculate, AutoComplete, AutoFill Handle, AutoCorrect, formula, formula bar, gridlines, range, workbook, worksheet, sheet tab, spreadsheet. You can find these definitions in the textbook, page 199. Also, review the previous entry.

When and why do you see number symbols or pound signs (###) in Excel?

More vocabulary: chart, chart title, the legend, data labels, the plot area, the chart area, bar chart, column chart, pie chart, line chart, category axis, value axis, data series. You can find these definitions on pages 268 and 291 in the textbook and throughout Chapter 7.

Midterm and Introduction to Excel Information

You will be having your Midterm next week: Period 2 on Wednesday, January 23 from 11:15 am - 12:25 pm; Period 5 on Thursday, January 24 from 8:45 - 9:55 am; and Period 9 on Thursday, January 24 from 11:15 am - 12:25 pm. The test will take place in the Windows Lab.

Please review the following information (you can copy and paste this information in a Word Document and print it for yourselves):

1. Computer concepts: What is a computer? What is hardware? Examples. What is software? Examples. Check your notes and review your tests and quizzes. Input devices, output devices, processing devices, CPU, storage devices (examples of all), two kinds of software and examples. What is computer memory? What is digital? What are bits, bytes, kilobytes, megabytes, gigabytes, terabytes? What is a network? Which is the most popular network? 
2. What are copyrights?
3. Ergonomics: what is it? How do you call the persons that study and design safe and comfortable environments and furniture for humans? Why is good posture important?
4. Home Row Keys. What is touch typing? Which is the first goal of a beginner typist? Name of the Keyboard. Who invented the typewriter?
5. What is Excel? What is a cell? What is an active cell? What is a cell address or cell reference? How do you call a document in Excel? When do you use Excel? How are columns labeled? How are rows labeled? 
6. There will be two Timings: a 2 minute and a 3 minute timed writing.

EXCEL (information from the PowerPoint Mrs. Feld showed you yesterday):

 Microsoft Excel is a spreadsheet application which allows one to enter numerical values or data into rows and columns of a spreadsheet, and to use these entries for calculations, graphs, and statistical analysis. There are many uses for a spreadsheet application including payroll, inventory, data collection, personal budgets, and cost calculations.

A document created in Excel is referred to as a "workbook." An Excel workbook consists of individual worksheets (or sheets). You can add more worksheets, delete them and rename them. Columns are labeled with letters and rows are labeled with numbers in Excel. You can add more columns and more rows in a spreadsheet.You can also change the width of columns and rows.

The cell address or cell reference is the address of a cell in Excel (the Column Letter and the Row Number): i.e. D3 - Column D, Row 3. This cell address appears in the Name Box. You use cell addresses when creating formulas in Excel. When you enter data in cells you can also see it in the Formula Bar.

The worksheet area is the area containing the gridlines in the Excel window. These gridlines are the gray vertical and horizontal lines that define the cells in the worksheet area. A cell in Excel is the intersection between a row and a column. An active cell is the cell surrounded by a black border with the AutoFill Handle (see below). When the cell is active you are ready to enter information, text or other data (numbers, dates, formulas, etc.).

When text doesn't fit into a cell, it overlaps to the next cell. When a number is too long to fit a cell, Excel changes the display into number symbols (###) to warn the user.

The cell pointer is the white cross (mouse pointer). Excel offers several automatic features: AutoComplete, AutoCorrect, AutoFill, AutoSum and AutoCalculate.

The AutoComplete Feature automatically inserts data in a cell that begins the same as a previous entry. It's very useful when entering repetitive data entries.

The AutoCorrect Feature automatically corrects many common typographical (typing) errors, like in Microsoft Word.

The AutoFill Feature is used to quickly fill a range of cells with the same data or with consecutive data; you can also quickly enter months of the year or a list of numbers. To use this feature you use the AutoFill fill handle (or AutoFill handle), which is the black square at the bottom right of the border that surrounds an active cell.

The Auto Sum Feature allows you to add and calculate the sum of a list of numbers in your worksheet. Go to the Home Tab and click the AutoSum symbol - the Greek letter Sigma (like an E) after highlighting a group of cells with numbers.

The AutoCalculate Feature is a shortcut that allows you to view a calculation for a selected range of cells without placing a function in a cell. You can highlight a group of cells, and "AutoCalculate" will calculate the sum, average, or count (on the bottom right side of the Status Bar).

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

Second Quarter

You all have been working very well completing your Keyboarding Lessons from the MicroType 4 Program. I'm hoping that most of you complete all the Alphabetic Keyboarding Lessons by December 20th. If not take some time this week (December 10) and next week (December 17) to complete as much as you can. Also, don't forget that I need to find at least 6 timings (timed writings 1 - 6 or other) by December 20th as well. Those of you working on the Skill Builder Lessons should continue doing so, as "Accuracy" (first). Once these Lessons A - T are completed (including the five Assessments) you can do them all with "Speed" as the focus. Please check the bottom section of the window that shows all the Skill Builder Lessons, make sure you selected "Focus: Accuracy" (you just click on it to change it).

You are also working in the Group Project (Small Business Adventurers) - our Christmas Project. Please remember to read the instructions carefully and to print the rubric for your group folder. You must pay close attention and complete all the steps mentioned in this rubric. You can also print the instructions if you wish. All of you must have these instructions on your desktop. (Instructions in your class folder in the K Drive - Keyboarding 8).

Make sure each member of your group completed the required assignments: logo, business cards, letterhead, coloring page, wrapping paper, flyer, photo card and newsletter. You must also have a Word Document explaining the purpose of your company, whether you sell products or provide a service, or both. Also include the selected "slogan" there. I need you to have everything completed by Thursday, December 20th, 2012. If you have any questions, please do not hesitate to ask Mrs. Feld.

KAIROS RETREAT: I'll be in the Kairos Retreat as an Adult Leader from Tuesday, December 11 to Friday, December 14. You will have a sub on those days. Please continue with your work and read this blog entry carefully.

October 2012 - MicroType 4 or other Keyboarding Program

You already started using the MicroType 4 Keyboarding Program (or other program). I'm hoping that most of you complete up to lesson 10 of the Alphabetic Keyboarding Lessons by Wednesday, October 31st. But, please remember: if you feel that you should repeat some of these lessons, I encourage you to do so. These first lessons are very important! If you are still having difficulties finding the right keys, or using the right fingers, you must definitely repeat them. As you advance, the lessons will get harder and once you get to the Skill Builder Lessons, you must have very good dominion of the Alphabetic Keys. It will be harder for you to do well on timings, if you don't practice a lot and repeat many of these lessons. The first goal is ACCURACY!

Little by little you'll acquire SPEED. But proper technique and fingering are essential! I will check your Lesson Reports often, to see how you're doing and may ask you to repeat some of the Lessons. Check once in a while your Performance Graphs and your Summary Reports.

You can check the following site www.sense-lang.org/typing and use some of the Typing Tutorials there. You can click the red "Lessons" button to Practice touch-typing using random text - for beginners to become familiar with the location of the letters on the keyboard. Also, you may want to click the "My Text" button to add your own text and practice touch-typing using this customized text - insert text from any source and exercise your own preferences (enter the text of the timing in the white box and click Start). You may want to practice Timed Writings 1 - 5 first (one, two or three paragraphs). If you are more advanced, you may practice any of the other timings (6 - 13).

Your PowerPoint "About Me" presentation must be completed by Monday, October 8, 2012. Please print this presentation as Hand-Outs (6 per page). Ask Mrs. Feld if you have any questions. Also, you must save it in Mrs. Feld's flashdrive. She will explain how to save it in the Server (in the Keyboarding 8 - K Drive).

Welcome Class!

We will have a very successful year! Please read the goals and classroom policies carefully.

First you will learn some important information about "Ergonomics," and "Ergonomists" and their importance. Make sure you understand what these terms mean (you will also have homework - finding two good definitions "ergonomics" and why good posture is important). You will learn a little bit of history about the keyboard. Who invented the "Type Writer" and the "QWERTY" Keyboard? Why is the layout of the keyboard the way it is? Also the importance of "Good Posture."

Later you will learn about "Computer Concepts": What is Digital? (watch the movie by clicking the link on the upper right side). What are Bits, Bytes, Kilobytes, Megabytes, Gigabytes? What is a Computer? What is Hardware? What is Software? What are Input Devices? What are Output Devices? What are Integrated Circuits? What are Processing Devices? What are Storage Devices? What are Networks? What is the Internet? What is Connectivity? What are Telecommunications? What are Copyrights?

We will also cover the "Home Row Keys" and which is the correct "fingering" - which fingers type which keys. I will show you an easy way to remember this. You can also check the fingering chart on your tables.

We will also start with the first MicroType Keyboarding Lessons (Lessons 1 - 20) - "Alphabetic Keyboarding". Initially, you will enter these lessons as a "Guest"; until the system allows us to connect to the Labserver properly and you can then be able to enter the program as a "User". Take these lessons seriously; they will teach you to type the proper way and use the right fingers. Please read the instructions and techniques shown on each lesson carefully! At first, you will concentrate on "accuracy" (not speed). It is essential for you to learn the right fingering and the right techniques. As you become better at typing, you will start working on "speed". Remember: the first goal in Keyboarding Class is to learn the Home Row Keys and to learn to type accurately.

If you need to, please repeat the lessons until you feel more confident. Practice makes perfect!

Quiz: Thursday, September 20, 2012 (which will include what you have learned in class up to this date - Mrs. Feld can give you hand-outs with all the presentations shown).

Test: Friday, September 28, 2012 (which will include what you have learned in class up to this date).

If you have any questions, please feel free to ask me. Communication is important!

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.

(The Quiz and Test will only include the vocabulary learned in class up to September 20th and 28th respectively!)