PDF-Spreadsheets

ECDL ICDL Syllabus Version 5 0 Copyright. +5 Swords of Calculation. Fluency with Information Technology. INFO100 and CSE100. Katherine Deibel. 2012-02-17. Katherine Deibel, Fluency in Information Technology. 1. Spreadsheets. Powerful tools for managing data. Lesson Outline. Created by The University of North Texas in partnership with the Texas Education Agency. UNT in partnership with TEA, Copyright © 2008. All rights reserved.. 2. II.. . Relevance of Spreadsheets to Everyday Life. A few scenarios where Excel is. . not optimal and alternatives. Setting 9 on machine A was wrong!. . Supposed to be 20 instead of 24. Limitations of spreadsheets. * Updating non-normalized data. & Pitfalls. Chapter . 1. Ken Koedinger. Based on slides from Ruth Clark. 1. Chapter 1 objectives. Evaluate research evidence on media comparisons. Classify kinds of . e. -learning . Timing: synchronous & asynchronous. Converting Recital Recordings Data at the University of Kentucky into MARC (eventually). The Database. File Maker Pro. Unsupported. Data moved to Excel spreadsheet. The . Spreadsheet: Problems. Individual . Basics. Objective 4.01. 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. . to . UAccess. Analytics. An Introduction to Utilizing . MyAnalytics. Lists. . . .. Are . you entering data from Analytics into your spreadsheets? . Do you have seemingly countless spreadsheets that you’re updating everyday with only one or two items of information?. Tyra Burton. Marketing & Professional Sales, Coles College. What we are doing today. How to get an account. Google Drive. Forms. How to create & add to D2L. Documents. Other Uses including Spreadsheets. ICT 2. Learning target. Student will identify the parts of a spreadsheet.. vocabulary. Cell Reference – location of a cell. Row – labeled with numbers. Formula Bar – allows users to enter a formula. Basics. 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. . You will . learn about some . important . features of spreadsheets, as well as a few principles for designing and representing information. .. Online . MS-Office information . source: . https://. support.office.com/. CSCI-N 100. Department of Computer Science and Information Science. Microsoft Office – Excel 2010. This is a worksheet. Multiple worksheets make up a workbook.. The default is three worksheets to start.. Kathleen McElhinney, Metadata/Cataloging Librarian. Agenda. Basics of Tab-Delimited Spreadsheets (TDS). Differences in TDS for simple and complex objects. Adding structure for monograph compound objects. Skills > . Google Docs. In this section:. Spreadsheets Part 1. Navigating in Google Docs. Spreadsheets Part 2. Word Processing. Presentations. Google Docs. In this section:. Sharing Documents. Creating Documents and Folders.