Computer Skills Study Guide

1. Computer SkillsStudy Guide

2. Objective 1.00Digital Literacy • What are the parts of the computer? • What are the functions and components of operating systems, programs, and networks? • What are the uses and features of the Internet and the World Wide Web? • What are the methods of online communication? • What are the threats to your computer? • What are the guidelines for protecting your computer and family from online predators? • What are some terms related to email?

3. Parts of the Computer • Input devices: • keyboard • Mouse • Scanner • Output devices • Printer • Monitor • Speakers/headphones • Processing: • CPU (central processing unit, “The brains”) • Storage devices • Floppy disks • Hard drive (internal drive) • USB Not all input devices or storage devices are listed here. Can you name others?

4. Words Located Within the Test Questions • Depress • Default • Omit • Netiquette • Unsolicited • Moderated • Monitor • Yelling (in emails) • Key • The Copy • Strike • If the word is in ALL CAPS AND BOLD in a question that means what?

5. Software: Operating System and Application • Windows (operating system) • Without an operating system, such as Windows, you would not see all the wonderful icons. It would be difficult for you to access your programs. • Programs/Apps (application) • You install various programs on your computer so that it is a valuable tool. Ex: without a word processing software like Microsoft Word, you would find it difficult to type a academic report (a report for school). • What tells the computer what to do?

6. Peripheral Devices Any type of hardware that can be attached to your computer. • Examples: • Printer • Speakers • Scanner • Mouse • Joystick Peripheral Devices are also what?

7. Storage Devices Side Note: The Zip Disk will never be shown in the pictures or figures on test questions. This is a CD Notice the similarities between the zip disk and the floppy disk. Notice the similarities between the zip drive and the floppy drive.

8. The Mouse • What are the three basic uses of the mouse? • Remember, the mouse controls the computer. • What type of device is the mouse?

9. What type of copy does the Monitor and Printer Produce? • The monitor produces a _____________ copy. • The printer produces a ______________ copy.

10. Research on the Internet • Two basic tools used to find information: • Search engines • Used to search for keywords • Google and search for Presidents • Subject directories • Used to find specialized topics • Go into list of internal directories then search a specific term

11. Types of Search Engines • Multimedia Search Engines • Used to find graphics, video clips, animation, and MP3 music files. • Meta Search Engines • Search several major search engines at one time. • Individual Search Engine • Provides the highest volume of results – most broad • Putting in a key word

12. What are the methods of online communication? • Blogging • Podcasts • Email • Chat Rooms • Skype What are the differences or similarities of these? Can you identify them for their unique qualities? What makes a chat room safe?

13. What are the threats to your computer? • Malicious Code • Viruses • Trojan horse • Malware • Spyware • Worms

14. Avoiding Malicious Code Step 1: Use an Internet firewall There are FOUR important steps to keeping your computer secure! Make sure your computer is protected by a firewall. Step 2: Update your operating system regularly You should set to automatically update when updates are available. Step 3: Use antivirus software and update it regularly Step 4: Use anti-spyware software & update it regularly An anti-spyware program can ensure you don’t have programs operating without your knowledge.

15. What are the guidelines for protecting your computer and family from online predators? • What do you do if you are being bullied? • What do you do if someone has hacked your account? • How do prevent these threats from taking place? • What should you do if you come across inappropriate material while searching on the internet? INSTALL A FIREWALL DON’T SAY ANYTHING YOU WOULD NOT SAY TO THE PERSON’S FACE DON’T REPLY EXIT IMMEDIATELY CONTACT YOUR INTERNET SERVICE PROVIDER IGNORE THE SENDER CONTACT LOCAL LAW ENFORCEMENT INSTALL SECURITY SOFTWARE

16. Objective 3.00 Spreadsheet Basics • What formatting options are used in spreadsheets and why? • What operations and formulas are commonly used in spreadsheets? Why? • What results are produced by the operations and formula? • What does a formula begin with? • How does a correctly written or keyed formula look? • The vertical lines in a spreadsheet are? • The horizontal lines in a spreadsheet are? • The workbook allows you to do what?

17. Objective 3.00 Spreadsheet Basics • What is Wrap Text? What is the purpose of wrapping text in a spreadsheet? • Define Merge. Why would you need to merge cells in spreadsheet? • Define Indent. What is the purpose of indenting? • What is Sorting? • What is the purpose of Freeze Pane? • Fill Series is used when__________? • What is Linking and Embedding? • Differentiate between Labels and Values. • Define Alignment. How do you Align? Where are the alignment tools located on the tool bar? Cell Range: • A4:A16 refers to a group of adjacent cells • A Range isa group/block of cells. • example: A6:E16 refers to a range of cells in a specific spreadsheet. Cell Address: a specific location • Cell A4 = Cell address • It is the Column letter and Row number. • The cell address is also called the cell reference.

18. Formatting options used in spreadsheets are: • Cells can be formatted a variety of ways. The most common are: • Currency(money) • Percent • Numbers with or without decimals • You can align the text in the cells centering both vertically and horizontally, and you can wrap text. • Changing column width and row height allows you to see all of the data entered into a particular cell or enhances the appearance of the spreadsheet.

19. Common operations used in spreadsheets are: • The mathematical operators are located on your numeric keypad. • They are: + used for addition - used for subtraction * used for multiplication / used for division • To alert the computer that you want it to perform math, you begin your formula with the = sign. • Formulas can be written so that the computer performs a particular task.

20. Common formulas and functions used in spreadsheets are: • Formulas vs. functions • To add the formula below could be used =b5+b6 This formula will add the 2 numbers that appear in those cells and produce the answer in the cell in which the formula sits. • To add using a function you would use =SUM(b5:b6) This function will also add the 2 numbers in the range of cells and produce an answer in the cell in which the function sits.

21. The most commonly used functions are: Function or operation the computer will perform • SUM • Adds all the numbers in a range of cells • AVERAGE • Returns the average or mean, of the set of date • MIN (minimum) • Returns (finds) the smallest value in a set of values. • MAX (maximum) • Returns (finds) the largest value in a set of values. • =SUM(B3:G3) • =AVERAGE(B3:G3) • =MIN(B3:G3) • =MAX(B3:G3) Cell range where the data is located

22. Design Principles 5.01 Understand business publications

23. SixPrinciples of Design • Balance • Proximity/unity • Alignment • Repetition/consistency • Contrast • White space

24. Balance • Graphics don’t overpower text • Page is not too heavy on one side or the other • such as, putting matching text boxes at the top and bottom of a publication

25. Proximity/Unity • Distance between elements on a page • Where pictures and words are placed • Used to demonstrate a relationship or a lack of relationship between elements • such as, you must put captions (text) next to the related photograph

26. Alignment • Justification of elements • Related items should be justified the same to emphasize their relationship to each other • such as, the text giving the location, date, time, and cost of an event are all CENTERED on a flyer

27. Repetition/Consistency • Consistent pattern of fontand color schemes and graphic types; repeated fonts, color schemes, or graphics • Specific font, size, and style for headings, subheadings, and body text. • Do not mix photographic images or digital and cartoon images on the same page. • Scheme - a planned combination of elements, such as a combination of font styles and sizes

28. Repetition/Consistency (continued) • Scheme examples: • In a publication: • all the Headings are keyed in 14 pt. Arial font and the Bodyis keyed in 12 pt. Times New Roman font • or all the text is in the same font type/style • The graphics that are used all relate to the topic of the publication

29. Contrast • the use of color and size to emphasize the most important elements on a page • for example: • Use black font on a light pink colored page • Use white font on black paper • Use light gray on dark blue

30. White Space • White space is: blank or negative space on a page • Used to give the reader’s eyes a break • Used to focus the reader’s attention on important details • White Space does not have to be white • Examples of White Space: • Using wide margins to create white space • An example of poor use of white space: putting text boxes in the margins of a publication

31. Link to publisher examples More information regarding the 6 Principles of Design with examples http://desktoppub.about.com/cs/basic/g/principles.htm

32. State Soccer Playoffs Lake Norman HS November 15, 2009 Asheville, NC 7:00 pm Pay $10 to ride the bus Flyer The Five Publications Newsletter Letter Head Business Card Brochure

33. The Five Publications The Purpose of this publication is: • Brochure-To educate, inform or advertise about a specific topic • Flyer-To advertise/communicate information about a one-time upcoming event • Business Card - To identify and provide contact information for a business or individual. • Letterhead - To identify and provide contact information for a business or individual. The phrase letterheadstationery implies the use of a heading at the top and sometimes also at the bottom of a letter. • Newsletter-To provide informational updates to a specific club, group, or organization on a regular basis – weekly, monthly, quarterly

34. Word Processing and Formatting Paragraph Formatting What are the three types of paragraphs? Example: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Example: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXX Example: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

35. Word Processing and Formatting • What are the Operational Keys? • What’s the difference between Formatting and Editing? What color is the line under the words when there is a: • Spelling Error? • Grammatical Error?

36. Word Processing and Formatting Spacing • How many spaces between a single space? • Double Space? • Triple Space? • Quadruple Space? • How Many Times Do You Enter to Get A: • Single Space? • Double Space? • Triple Space? • Quadruple Space?

37. Word Processing and Formatting Know Your Bars! • Title Bar • Tool Bar • Cursor • Scroll Bar • Menu Bar

38. Combine the Operational Keys • Control and Page Up – quickly moves you to the first page of a multi-page document • Control and Home – quickly takes you to the first line of a document • Control and End – quickly takes you to the last line of a document • Control and Page Down – moves you to the next page of a multi-page document

39. Proofreading Remember the Grammar Rules: Capitalize: • the first word of a sentence • days of the week, months, holidays, and religious days, but not seasons(Examples: You can expect leaves to start changing in October. It’s the beginning of fall.) • proper nouns and the pronoun I • the name of specific course titles, but not names of school subjects (Examples: I love language arts! I am registering for Ms. Johnson’s English 101 class in the spring.) • North, South, East, West when they are in an address, part of a proper noun, and when they refer to specific regions (Examples: I live on East Waverly Street. She made a wrong turn going west.) • titles that precede names but not those that follow names (Examples: I met President Bill Clinton yesterday. This is Ms. Rose, vice president of our FBLA chapter.)

40. Proofreading • Proofreading is the process of comparing a copy on screen or paper to the original copy and marking errors to be corrected. • Proofreader marks are symbols that are used to mark corrections and changes to a document. (Found on a rough draft of a document)

41. Get Familiar with Proofreaders Marks

42. Ways to Proofread • View the Soft Copy • Print a draft and view the Hard Copy • Peer Edit • Then Edit your document after viewing the marks and comments of incorrect spelling and grammar.

43. Agenda and Minutes What is the purpose of: Itinerary-Trip to Disney Agenda Meeting Minutes Click and Drag to Enlarge

44. You use Word Processing to Create: • Memos (memorandum) • Letters • Tables • Reports What is the Purpose? What are the Parts? What is the line Spacing? What is the proper paragraph formatting for each? (See Your Cheat Sheet)