slide1
Download
Skip this Video
Download Presentation
B.A. (Mahayana Studies) 000-209 Introduction to Computer Science November 2005 - March 2006 3. Office Tools

Loading in 2 Seconds...

play fullscreen
1 / 28

B.A. Mahayana Studies - PowerPoint PPT Presentation


  • 361 Views
  • Uploaded on

B.A. (Mahayana Studies) 000-209 Introduction to Computer Science November 2005 - March 2006 3. Office Tools. A look at the main tools most computer users need: word processing, spreadsheets, and databases. Overview. 1. Office Tools commercial and free tools 2. Word Processing

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'B.A. Mahayana Studies' - LionelDale


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

B.A. (Mahayana Studies)000-209 Introduction to Computer ScienceNovember 2005 - March 20063. Office Tools

A look at the main tools most computer users need: word processing, spreadsheets, and databases.

overview
Overview
  • 1. Office Tools
    • commercial and free tools
  • 2. Word Processing
    • writing documents on a computer
  • 3. What is a Spreadsheet?
    • analyzing numbers on a computer
  • 4. What is a Database?
    • manipulating tables of data on a computer

000-209 Intro to CS. 3/Office Tools

1 office tools
1. Office Tools
  • Some commercial software
    • AppleWorks, iWork, Lotus SmartSuite
    • Microsoft Office, Microsoft Works
    • StarOffice, WordPerfect Office
  • Free/open source software
    • GNOME Office, KOffice
    • NeoOffice/J, OpenOffice.org

000-209 Intro to CS. 3/Office Tools

1 1 ms office
1.1. MS Office
  • MS Office
    • developed for Microsoft Windows and Apple Mac OS
  • Core tools
    • Word, Excel, Outlook, PowerPoint
  • Other tools:
    • Access, Publisher, FrontPage, Internet Explorer, Photo Editor, Project, Visio

000-209 Intro to CS. 3/Office Tools

1 2 openoffice org
1.2. OpenOffice.org

http://www.openoffice.org

  • OpenOffice.org (abbreviated OOo) is an open source office suite.
  • Available for many platforms, including Windows, Linux, and Mac OS X.
  • It is intended to be just like Microsoft Office.
    • but free, and less \'buggy\'
  • Core tools:
    • Writer, Calc, Impress, Draw, Base, Math

000-209 Intro to CS. 3/Office Tools

what is open source software
What is Open Source Software?
  • The software is free.
  • Open source software is developed by groups of people working together
    • they work for free
    • they aren\'t part of a company
  • The program code can be changed/reused by anyone.

000-209 Intro to CS. 3/Office Tools

2 word processing
2. Word Processing
  • Create, store, and print documents using a computer program called a word processor.
  • Tools: MS Word, OOo writer, WordPerfect

000-209 Intro to CS. 3/Office Tools

2 1 word processing features
2.1. Word Processing Features
  • Editing:
    • insert/delete text blocks
    • move entire paragraphs or pages
  • Outlining: view document as a hierarchy of headings and subheadings
  • Thesaurus: suggest different words
  • Search: search and replace
  • Spellchecking

continued

000-209 Intro to CS. 3/Office Tools

slide9
Document statistics
    • count each word/sentence/paragraph in the document
  • Concordance
    • create an alphabetical list of words and their frequency in the document
  • ReadabilityMeasures
    • calculate the reading level required to understand the document.

continued

000-209 Intro to CS. 3/Office Tools

slide10
IndexandTableofContents
  • MailMerge
    • create a series of personalized letters by combining information in a names/addresses list with a form letter

000-209 Intro to CS. 3/Office Tools

2 2 text formating
2.2. Text Formating
  • A font is a type style.
  • Adjustable line spacing, margins, indents, tabs, borders, and frames.
  • Justification defines how letters and words are spaced across each line.

Hanging indents make

numbers stand out

continued

000-209 Intro to CS. 3/Office Tools

slide12
Header
    • text that appears in the top margin of every page
      • e.g. the document title
  • Footer
    • text that appear in the bottom margin of every page
      • e.g. the page number

000-209 Intro to CS. 3/Office Tools

2 3 document formatting
2.3. Document Formatting
  • A document templateis a preformatted document
    • format settings done for you

Document

templates

000-209 Intro to CS. 3/Office Tools

2 4 web publishing
2.4. Web Publishing
  • Convert the document to a Web page.
    • the Web page is formatted using HTML
  • HTML (hypertext markup language)
    • document text + special formatting codes

000-209 Intro to CS. 3/Office Tools

html in a browser
HTML in a Browser

displayed in

Web browser

Web page (HTML Formatted Document)

000-209 Intro to CS. 3/Office Tools

3 what is a spreadsheet
3. What is a Spreadsheet?
  • A program that allows a user to enter data into row and column positions (known as cells).
  • A spreadsheet can apply many math operations to the values in its cells.
  • Tools: MS Excel, OOo Calc, Lotus 1-2-3, Corel Quattro Pro

000-209 Intro to CS. 3/Office Tools

3 1 example spreadsheet
3.1. Example Spreadsheet

000-209 Intro to CS. 3/Office Tools

3 2 spreadsheet components
3.2. Spreadsheet Components
  • Worksheet
    • a grid of cells organized into columns and rows
  • Cellreference
    • a unique address for a cell
    • e.g. cell A1 is in column A, row 1
  • A cell can contain
    • numbers, text, formulas (math equations referring to other cells)

000-209 Intro to CS. 3/Office Tools

3 3 uses
3.3. Uses
  • A spreadsheet is good for:
    • storing data
    • doing calculations
    • graphing data
  • Spreadsheetmodeling
    • set up numbers to describe a real-world situation
  • What-ifanalyses
    • experiment with different numbers

000-209 Intro to CS. 3/Office Tools

3 4 some spreadsheet graphs
3.4. Some Spreadsheet Graphs

000-209 Intro to CS. 3/Office Tools

4 what is a database
4. What is a Database?
  • A database is a collection of data organized so it can be searched, selected, and combined easily.
  • Tools: MS Access, Oracle, MySQL
  • Relational databases are organized into tables, record, and fields.
    • a field is a single piece of data
    • a record is a set of fields
    • a table is a collection of records

000-209 Intro to CS. 3/Office Tools

4 1 example database
4.1. Example Database

A field (the name of this field is “PRODUCT DESCRIPTION”)

A record (this record describes an A4 lab book)

A single table in a database

000-209 Intro to CS. 3/Office Tools

4 2 tables relationships
4.2. Tables Relationships

“Students” table:

“Staff” table:

000-209 Intro to CS. 3/Office Tools

relationships in ms access
Relationships in MS Access
  • The Relationships Window

000-209 Intro to CS. 3/Office Tools

4 3 other database features
4.3. Other Database Features
  • Queries
    • search the tables, collect information
  • Reports
    • display information in a nicer way (graphically)
  • Forms
    • make input to tables easier
    • can add error checking

000-209 Intro to CS. 3/Office Tools

creating a form
Creating a Form

by you

real form

form in the database

000-209 Intro to CS. 3/Office Tools

ad