1 / 49

Computer Skills Study Guide

Computer Skills Study Guide. Design Principles. 5.01 Understand business publications. Six Principles of Design. Balance Proximity/unity Alignment Repetition/consistency Contrast White space. Balance . Graphics don’t overpower text Page is not too heavy on one side or the other

levana
Download Presentation

Computer Skills Study Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Computer SkillsStudy Guide

  2. Design Principles 5.01 Understand business publications

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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

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

  12. Design Principles 5.01 Understand business publications

  13. 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

  14. 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

  15. The Target Audience

  16. Traits of the Target Audience • Once the type of publication is determined, the next step is to examine the Target Audience. Knowledge of the Target Audience is critical to effective communication through publications.

  17. Traits of the Target Audience The identifying characteristics of the Target Audience provide the “hooks” for grabbing their attention by appealing to their • Age • Ability • Special interests, and • Group Membership

  18. Traits of the Target Audience • Although a TargetAudiencecan be characterized by many traits, we will only cover the following fourin this objective: • Age • Educational background (ability) • Interests • Group membership

  19. Age of the Target Audience • What is the generalage group ? • Elementary • Preteen • Teen • Young adult • Mature adult • Senior citizen Is the publication being prepared for young children to entertain them and tell a story at a birthday party? Is it for a classroom to inform students about a topic? 3. The age of the Target Audience will assist in choosing Design Elements that will be used in the publication.

  20. Age of the Target Audience Look at the two versions of an elementary school flyer and discuss which one is more appropriate. Version A or Version B?

  21. Educational Backgroundof the Target Audience • What is the general Education Level of the Target Audience? • If it can be defined, knowledge of the Educational Background will determine the amount of text, wordchoices, and amount of graphics used in the publication. • Remember, less is more! • Be concise and get to the point.

  22. Educational Backgroundof theTarget Audience • If you think back to the previous flyers of the elementary school, what do you think about the educational level of the Target Audience? • Can the audience read well? • Their vocabulary is probably limited, so more age appropriate graphics were used to convey the message than text.

  23. Common Interestsof the Target Audience • Does the Audience(group) as a whole share CommonInterests, such as knitting, doll collecting, bowling, stamp collecting, kayaking,or fly fishing?

  24. Special Interest Groups Boy Scouts FBLA Gaming Gardening Harry Potter Other Groups Religious Ethnic Political Sports Sorority or Fraternity Group Memberships Is the TargetAudiencea member of a particular group? Does the Audience share similarGroup Memberships?

  25. Elementary School Flyer Version A

  26. Elementary School Flyer Version B

  27. Spreadsheets

  28. 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?

  29. SpreadsheetBasics What is a Spreadsheet? A spreadsheet (or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form. A workbook is a file which contains one or more spreadsheets.

  30. Spreadsheets Perform Mathematical Calculations Do you or your family use spreadsheets? Daily Uses of Spreadsheets: • Balancing a checkbook • Calculating car loans • Calculating student grades (helping students keep up with their grades) • Household budgets Why would a business use spreadsheets? • Payroll • Financial statements for a business (profit/loss)

  31. Designing a Spreadsheet Cell – individual locations on a spreadsheet (intersection of a row and column) • Column— identified by letters of the alphabet (vertical) • Column A refers to all of the contents in a vertical range of cells in the first column of the spreadsheet. • Row— identified by numbers (horizontal) • Row 3 refers to all of the contents in a horizontal range of cells on Row 3 COLUMNS (vertical) ROWS (horizontal)

  32. Cell Specifics 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. Active cell: • The cell that is selected • It is the cell that is ready to receive information

  33. 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.

  34. 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.

  35. 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

  36. 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.

  37. Word Processing Basics

  38. Word Processing and Formatting Paragraph Formatting What are the three types of paragraphs? Example: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Example: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXX Example: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Hanging Indent – used for work cited and bibliographies. Block Style – used in memorandums and letters. Indent – used in academic reports, essays, regular writing.

  39. 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?

  40. 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?

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

  42. 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

  43. 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.)

  44. 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)

  45. Get Familiar with Proofreaders Marks

  46. 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.

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

  48. SPEED AND ACCURACYDEVELOPMENT

  49. Figuring Gross Words a MinuteGWAM • Every 5 strokes (punctuation marks, numbers, symbols, and spaces) equals 1 word. • Divide the total number of words keyed by the number of minutes you were timed. Example: The dog jumped into the water to fetch the stick! There are 49 characters or spaces in the above sentence. You will divide 49 by 5 to determine gwam. You drop the remainder. Answer - 9 gwam

More Related