9172021 TU 170 Learning Online Prepared By M
![9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC](https://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-1.jpg)
9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 1
![Section 3 – Computing With Confidence (Cont. ) Becoming a skilled learner Working with Section 3 – Computing With Confidence (Cont. ) Becoming a skilled learner Working with](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-2.jpg)
Section 3 – Computing With Confidence (Cont. ) Becoming a skilled learner Working with words Creating your pictures Working with numbers & graphs § Storing and finding information § Creating an integrated document ü ü ü § 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 2
![Working with numbers and graphs What is a spreadsheet? • A spreadsheet is a Working with numbers and graphs What is a spreadsheet? • A spreadsheet is a](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-3.jpg)
Working with numbers and graphs What is a spreadsheet? • A spreadsheet is a program which allows you to enter and manipulate data, including numbers, text, dates and formulas. It is arranged in a set of columns and rows. 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 3
![Common features of a spreadsheet • Entering Data • Formatting data: for example 31/1/02, Common features of a spreadsheet • Entering Data • Formatting data: for example 31/1/02,](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-4.jpg)
Common features of a spreadsheet • Entering Data • Formatting data: for example 31/1/02, 31 -Jan-02, currency using £, $), time (13: 30, 1. 30 PM, etc. ), and so on. • Selecting cells • Using Formulas: =(B 2+C 2+D 2)/3 • Using Functions: Sum, Average, Max, Min, . . . • Using Charts 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 4
![Finally Do Exercises • Exercise 13: Study times and TV times 9/17/2021 TU 170 Finally Do Exercises • Exercise 13: Study times and TV times 9/17/2021 TU 170](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-5.jpg)
Finally Do Exercises • Exercise 13: Study times and TV times 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 5
![Finally Do Exercises • Exercise 14: Adding Averages and Totals 9/17/2021 TU 170 Learning Finally Do Exercises • Exercise 14: Adding Averages and Totals 9/17/2021 TU 170 Learning](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-6.jpg)
Finally Do Exercises • Exercise 14: Adding Averages and Totals 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 6
![Finally Do Exercises • Exercise 15: Creating a graph 9/17/2021 TU 170 Learning Online( Finally Do Exercises • Exercise 15: Creating a graph 9/17/2021 TU 170 Learning Online(](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-7.jpg)
Finally Do Exercises • Exercise 15: Creating a graph 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 7
![Sorting and finding information Database What is a Database? • A database is a Sorting and finding information Database What is a Database? • A database is a](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-8.jpg)
Sorting and finding information Database What is a Database? • A database is a collection of records about a particular area. • The power of a computer database lies in the amount you can store, and the ways you can access the data • A large organization may have databases for staff records, stock, customer accounts, sales… • Databases are in use in all large organizations, and there is probably a surprising amount of information about you held in databases in various places • Many people who only use a computer for personal use do not use databases, because they have less information to store and handle than a large company. 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 8
![Features of databases • • Fields: Characters, Numbers, Symbols Records: Group of fields. Tables: Features of databases • • Fields: Characters, Numbers, Symbols Records: Group of fields. Tables:](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-9.jpg)
Features of databases • • Fields: Characters, Numbers, Symbols Records: Group of fields. Tables: Group of records. Files: Group of: 1. Tables 2. Forms 3. Reports 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 9
![Finally Do Exercises Exercise 18: Creating your own Database • Create your own database Finally Do Exercises Exercise 18: Creating your own Database • Create your own database](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-10.jpg)
Finally Do Exercises Exercise 18: Creating your own Database • Create your own database about something which will be of continuing use to you, like a personal address book, list of books, CDs or tapes, membership list for some organization, or any collection of items of interest to, before you start the database program, is to decide what it is you want your database to show. For example, in an address book, you might have fields for: • name (or separate fields for first and last names), • address (or several fields, including street address, town, postcode, etc. ), • one or more phone or fax numbers, e-mail address and/or website, • a place for notes or keywords. 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 10
![Books Database Data Types 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Books Database Data Types 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y.](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-11.jpg)
Books Database Data Types 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 11
![Entering Data Table View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Entering Data Table View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y.](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-12.jpg)
Entering Data Table View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 12
![Entering Data Form View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Entering Data Form View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y.](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-13.jpg)
Entering Data Form View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 13
![Retrieving Data Report View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Retrieving Data Report View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y.](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-14.jpg)
Retrieving Data Report View 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 14
![Creating an Integrated Documents • An 'integrated document' is one in which elements of Creating an Integrated Documents • An 'integrated document' is one in which elements of](http://slidetodoc.com/presentation_image_h2/af1dfe0fd7d26761ac1b6ffffc4b3cd9/image-15.jpg)
Creating an Integrated Documents • An 'integrated document' is one in which elements of different software types are mixed. • There are many ways of linking documents so that information in one is easily accessible to another. • Copy and Paste. • Drag and Drop. • Import a document. • Link a document. • Embed a document. • Using Hyperlinks. 9/17/2021 TU 170 Learning Online( Prepared By: M. Hussein Y. Mansoour) Copyright 2005© ITC 15
- Slides: 15