Welcome to CMPE003 Personal Computers: Hardware and Software

1. Welcome toCMPE003Personal Computers: Hardware and Software Dr. Chane Fullmer Fall 2002 UC Santa Cruz

2. Exams • Exams now on-line….. • http://www.cse.ucsc.edu/classes/cmpe003/Fall02/ • Must have your own Scantron form to determine test version you took

3. Assignments • Assignment #6 – The Last One  • Due November 22, 2002 • 1 week from today…don’t be late.. • Using Spreadsheets – (M$ Excel) • Generate a personal monthly budget spreadsheet http://www.soe.ucsc.edu/classes/cmpe003/Fall02/hw6_spreadsheet.html

4. Peer web pages…….. • Web pages from assignment #3/4.. • http://people.ucsc.edu/~acortez • http://people.ucsc.edu/~swells • http://people.ucsc.edu/~emccabe

5. SpreadsheetsandBusiness Graphics:Facts and Figures Chapter 13

6. Objectives • Describe the advantages of spreadsheets • List several applications for spreadsheets • Explain the underlying principles of electronic spreadsheet use • Describe how to set up and modify a spreadsheet • Describe the advantages of business graphics • Differentiate between analytical and presentation graphics • Name the elements of standard charts and graphs

7. Why Use Spreadsheets? • Plan ahead (What if) • Make the computer do the work • See the results of change

8. The Nature of Spreadsheets • Use numbers to track performance • Manual • Tedious • Time-consuming • Error-prone • Electronic spreadsheets • Automate • Increase ability to track performance

9. Electronic Spreadsheets VisiCalc • First electronic spreadsheet program • 1979 • Apple II microcomputer • Computer becomes an indispensable tool for financial analysis

10. Electronic SpreadsheetsLabor Saving Automatic recalculation • Change one value • All dependent values are recalculated • A single change can affect many calculations

11. Electronic SpreadsheetsLabor Saving “What If” Analysis The process of changing one or more spreadsheet values and observing the resulting calculated effect What if we reduce the price by 5%? What if we buy a home and the mortgage rate increases (or decreases) by .5%?

12. Working with Spreadsheets • Plan your inputs & outputs • Create sheet based on your plan • Edit and proofread as needed • Format columns/rows • Print • Add graphics • Provide data security – password, protect

13. Working with Spreadsheets The plan… …The result

14. Electronic SpreadsheetsHow it Works • Enter data and calculations • Electronic spreadsheet automatically performs the calculations • Error-free results are displayed on the spreadsheet • Print • Store to be used again

15. Electronic SpreadsheetsFundamentals • Screen • Window into the spreadsheet • Scroll using mouse or cursor-movement keys • Rows and columns • Row – number • Column – letters

16. Electronic SpreadsheetsFundamentals • Cell • Junction of a row and column • Cell address (cell reference) – letter and number • Active cell (current cell) • Highlighted with border or reverse video • Can enter or edit data in active cell only

17. Cell Contents • Label • Descriptive text about entries • Not used for calculations • Value • Number • May be used in calculations

18. Cell ContentsFormula • Calculation instruction • Contains • Cell address • One or more arithmetic operators • Functions • Result appears in the cell containing the formula • Calculation appears in the formula bar

19. Cell ContentsFunctions • Pre-programmed formulas • Used in formulas in place of operators • Common • SUM • AVERAGE • COUNT • MIN • MAX

20. Cell Ranges • Group of one or more adjacent cells occurring in a rectangular shape • Treated as a unit during an operation • Indicate the upper-left and lower-right cells of the block • May be referenced in a formula or function

21. Formatting Features • Column width • Row height • Headings • Number styles – commas, number of decimals, dollar and percent signs • Appearance of data • Justification • Text font and style

22. Formatting Features • Decoration • Borders • Color • Clip art • Business graphics • Shows words and numbers in visual form • Quickly and easily understood

23. Business Graphics • Generate and sustain the interest of an audience • Make a lesson, report, or business document more attractive • Help get a point across • Can reveal a trend that is lost in a column of numbers • Presenter appears more prepared and organized

24. Business Graphics Analytical graphics View and analyze data Presentation graphics Make a positive impression during a presentation • Enhance charts • Animation • Sound

25. Analytical GraphicsAnalysis-oriented Graphics Help users analyze and understand data Line Bar Pie

26. Line Graphs Shows trends or cycles over time • Axis • Plot area • Data point • Labels • Titles

27. Bar Graphs • Comparisons • Rectangular area up to the height of the point being plotted • Easy to absorb

28. Pie Charts • Proportions Relationship between parts and whole • One time period • Exploded pie chart One wedge pulled slightly away from the pie

29. Presentation Graphics --- Business-quality Graphics • Look like preparation by professional graphic artist • Charts • Graphs • Visual aids • Control the appearance when you create it • Produce graphics faster • Make last-minute changes

30. Presentation Graphics --- Business-quality Graphics • Edit and enhance charts created by other programs • Create charts, diagrams, drawing, and text slides • Use clip art • Support animated effects • Add sounds

31. Presentation Graphics --- Business-quality Graphics Hardware • High-resolution color monitor • Color printer • Ability to project computer slides on a screen

33. Extra Credit