1 / 15

INF1060: SPREADSHEET1

Take this course to learn how to use basic functions and commands in spreadsheet software for data manipulation and record keeping. No prerequisites required.

dignacio
Download Presentation

INF1060: SPREADSHEET1

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. INF1060: SPREADSHEET1

  2. INF1060: SPREADSHEET1 • Why Take This Course? • This course will give you an opportunity to use basic functions and commands in spreadsheet software for general data manipulation and personal record keeping.

  3. INF1060: SPREADSHEET1 • What do you need to know before you start? • There is no prerequisite for this course. • What will you know and be able to do when you are finished? • Demonstrate basic electronic spreadsheet software competence. • Create data and content for spreadsheets. • Analyse in a spreadsheet • Format data and content in a spreadsheet • Create a spreadsheet using appropriate data to solve problems

  4. INF1060: SPREADSHEET1 • When should your work be done? • This module should take approximately 20 hours to complete.

  5. INF1060: SPREADSHEET1 • Which resources can you use? • Microsoft Excel 2010 • Assignment templates found in the Information Processing 10 folder • The help menu,….. • This on-line tutorial http://www.usd.edu/trio/tut/excel/index.html

  6. What is a Spreadsheet? • A spreadsheet is a computerized worksheet in which data is arranged in horizontalrows and vertical columns.

  7. Spreadsheets (Cont’d) • A cell will accept four kinds of data: • labels: January, February • numbers and values: 1234 • dates and times: 28/02/01 • formulas: =D14*C24 (the contents of cell D14 are multiplied by the contents of cell C24)

  8. Spreadsheets (Cont’d) • Spreadsheets automatically recalculate when data is changed via formulas. • Spreadsheets can be used for a variety of tasks. • For example, they can answer “what if” types of questions, such as the following: What happens if your allowance changed? • Once a spreadsheet has been created, it can be saved and used over and over. This is called a template.

  9. Formula Formats • In order for a formula to work in Excel, it must start with an equal sign (=). • You must use cell references to tell the computer what to calculate. • You can reference a cell simply by typing the cell name. • =B14*C12 (multiplies the contents of cell B14 by the contents of cell C12 • and displays the answer in the cell where the formula was typed.)

  10. Formulas (Cont’d) • You can use the following mathematical operators to create a formula: • To make things easier, Excel has hundreds of functions pre-programmed into it: • =SUM(A12:A17) ……………………………sums the cells A12 through A17 • =AVERAGE(A12:A17) ……………………. averages the cells A12 through A17 • Insert > Function (Formulas Tab) lists all of Excel’s pre-programmed functions.

  11. Steps in Creating a Spreadsheet 1). Enter labels on the computer that will identify the contents of rows and columns. 2). Enter the numbers to be used in your calculations and apply necessary formatting. 3). Enter the appropriate formulas into your spreadsheet. Be sure to use cell references when keying in these formulas. 4). Enter the functions to be used in calculations. Again be sure to use cell references. 5). Explore any “what if’s” by changing variables. 6). When you have a “finished product”, save it to your SPREADSHEET folder and submit it to Moodle. You may be asked to print copies of your spreadsheet showing both numbers and formulas (when applicable). So read the instructions carefully.

  12. Formatting • Borders • Merge and Center • Change cell size • Adding and Deleting • Adding Sheets • Saving

  13. Assignment #1‘Excel’ing in the Basics • You have been asked by the Royal Tyrell Museum to produce a spreadsheet outlining information on a number of different dinosaurs. You have collected all of the data, but haven’t yet created a visually appealing spreadsheet to present to the ‘big-wigs’ at the museum. Recreate the following spreadsheet and apply your own personal style to it. • Save this spreadsheet as “1060 SS Assgn 1”. INF1060 Spreadsheet I

  14. INF1060 Spreadsheet I

  15. Assignment #1 (Cont’d) • Your finished product must show evidence of ALL of the following: • 2 different text alignments • 2 different text styles (ie. bold, underlined, italic) • 2 different font styles and sizes • Text wrapping • A header and/or footer containing spreadsheet information (eg. title, date, your name, page number) • Sorted data • Borders around title/label cells • Coloured (filled) cells • Print the finished spreadsheet with gridlines in Landscape format. • Microsoft Excel “Help” is an important resource and can help you complete numerous tasks within this course. You may find “Help” useful for this activity. INF1060 Spreadsheet I

More Related