csc 100 introduction to computers
Download
Skip this Video
Download Presentation
CSC 100: Introduction to Computers

Loading in 2 Seconds...

play fullscreen
1 / 34

CSC 100: Introduction to Computers - PowerPoint PPT Presentation


  • 356 Views
  • Uploaded on

CSC 100: Introduction to Computers. Dr. Chuck Lillie. Introduction. Course Outline Syllabus Assignments Web Page Exams Grading Class Makeup. Course Outline. What is a Computer Windows 98 Word Processor Spreadsheet Spreadsheet & Word Processor Database

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 'CSC 100: Introduction to Computers' - Roberta


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
introduction
Introduction
  • Course Outline
  • Syllabus
  • Assignments
  • Web Page
  • Exams
  • Grading
  • Class Makeup
course outline
Course Outline
  • What is a Computer
  • Windows 98
  • Word Processor
  • Spreadsheet
  • Spreadsheet & Word Processor
  • Database
  • Database & Word Processor & Spreadsheet
  • PowerPoint
  • PowerPoint & Word Processor & Database & Spreadsheet
  • Web Pages & Word Processor & PowerPoint
syllabus
Syllabus
  • CSC100-01 Syllabus-F02
  • CSC100-03Syllabus-F02
what is a computer
What is a Computer
  • Mechanical Devices
    • The Pascaline: Blaise Pascal
    • Stepped Reckoner: Goddfried Wilhelm van Leibniz
    • Difference Engine: Charles Babbage, Ada Byron
      • Punched Cards
  • Electro-Mechanical Devices
    • Tabulating Machine: Herman Hollerith
    • Mark I: Howard Aiken
  • First Generation Computers
    • Atanasoff-Berry Computer (ABC): John Atanasof & Clifford Berry
      • Binary Number System
    • Electronic Numerical Integration and Calculator (ENAC): John Mauchly and J. Presper Eckert
what is a computer6
What is a Computer
  • Stored Program Computer
    • Electronic Discrete Variable Automatic Computer (EDVAC)
    • Electronic Delay Storage Automatic Computer (EDSAC)
    • Universal Automatic Computer (UNIVAC)
  • Second Generation Computers
    • Transistor
    • IBM Model 650
    • Read/Write Tape
  • High-Level Programming Languages
    • Formula Translator (FORTRAN)
    • Common Business Oriented Language (COBOL)
    • Beginner’s All-Purpose Symbolic Instruction Code (BASIC)
what is a computer7
What is a Computer
  • Third Generation Computers
    • Integrated Circuits
  • Mainframes
    • IBM System 360
  • Fourth Generation Computers
    • Microprocessor
  • The Personal Computer
    • Apple Computer, Inc.
    • IBM-PC
    • PC Software
      • Spreadsheet, accounting,and word processing
what is a computer8
What is a Computer
  • Computer Components
    • Memory
      • ROM: Read Only Memory
      • RAM: Random Access Memory
    • Processor
      • CPU: Central Processing Unit
    • Storage Devices
      • Diskette
      • CD: Compact Disk
      • Hard Disk
    • Peripheral Devices
      • Printers
      • Scanners
what is a computer9
What is a Computer
  • Bits & Bytes
    • Binary Digits (BIT): 0 or 1
    • Byte: 8 bits
  • ASCII: American Standard Code for Information Interchange
    • Each letter is represented by 1 byte
    • Examples
      • J = 01001010
      • I = 01001001
      • M = 01001101
what is a computer10
What is a Computer
  • Telecommunications
  • Networks
    • LAN: Local Area Network
    • WAN: Wide Area Network
  • Network Services
    • eMail
    • BBS: Bulletin Board Service
    • Netnews Newsgroup
    • Listserv
  • WWW: World Wide Web
what is a computer11
What is a Computer
  • Software
    • Word Processors
    • Spreadsheets
    • Databases
    • Desktop Publishing
    • Presentation Graphics
    • Web Publishing
windows 98
Windows 98
  • Key Issues
    • Mouse
    • Desktop
    • Dialog Box
    • My Computer
    • Starting an Application
    • Windows Explorer
    • File and Folder Management
      • Creating a folder
    • Recovering Deleted Files
word processor chapter 3
Word Processor – Chapter 3
  • Key Issues
    • Create Word document
    • Edit Word document
    • Save Word document
    • Open Word documents
    • Spell check
    • Use toolbar
    • Display and identify formatting marks
    • Change views
    • Scroll
    • Close and print a document
    • Exit Word
major steps for producing a word processor document
Major Steps for Producing a Word Processor Document
  • Create a new document in Word using the New Office Document command in the Start menu on the Taskbar.
  • Enter or edit the document.
  • Save the document on disk.
  • Print the document if necessary.
  • Close the document.
  • Properly exit Word.
word processor chapter 4
Word Processor- Chapter 4
  • Key Issues
    • Undo
    • Print preview
    • Format a document
    • Create headers & footers
    • Control pagination
word processor chapter 416
Word Processor- Chapter 4
  • Key Issues
    • Use tabs
    • Set tab stops
chapter 5 word processor
Chapter 5: Word Processor
  • Key Issues
    • Copy & Paste Text
    • Use Windows and Office Clipboards
    • Find & Replace Text
    • Use Thesaurus
    • Format Indents
chapter 6 word processor
Chapter 6: Word Processor
  • Key Issues
    • Create & Format Table Structures
    • Insert Special Characters
    • Hyphenate a Document
    • Apply Built-in Styles
    • Use Outline View
    • Create a Table of Contents
    • Create a Section in a Document
spreadsheet chapter 7
Spreadsheet – Chapter 7
  • Key Issues
    • Create spreadsheet
    • Edit spreadsheet
    • Save spreadsheet
    • Print spreadsheet
    • Format simple spreadsheet
    • Use formulas
    • SUM
    • AVERAGE
    • ROUND
    • Cell references in formulas
    • Fill handle
spreadsheet chapter 8
Spreadsheet – Chapter 8
  • Key Issues
    • Plan a spreadsheet
    • Find
    • Replace
    • Copy
    • Cut
    • Paste
    • MAX function
    • MIN function
    • Absolute cell reference
    • Insert and Delete rows and columns
    • IF command
spreadsheet chapter 9
Spreadsheet – Chapter 9
  • Key Issues
    • Copy and Move data between sheets
    • Refer to data in different sheets
    • Create, modify, format, and print pie, bar, and line charts
spreadsheet chapter 10
Spreadsheet – Chapter 10
  • Key Issues
    • Sort
    • CHOOSE
    • VLOOKUP
    • Freeze Cells
    • PMT
    • Hyperlinks
spreadsheet word processor chapter 11
Spreadsheet & Word Processor – Chapter 11
  • Key Issues
    • Share data between Word documents and Excel spreadsheets
    • Create hyperlinks to Office files
    • Use OLE (Object Linking and Embedding) to create an embedded or linked object
database chapter 12
Database – Chapter 12
  • Key Issues
    • Understand what a relational database is
    • Design an Access relational database
    • Crate an Access relational database
csc 100 sec 01 access data files
CSC 100 Sec 01Access Data Files
  • Go to CSC100 directory; then to CSC100 Data directory; and then to Data Files directory
  • Find the Access file you need and copy it to the clipboard
  • Go to your CSC100 directory; then to the Access directory in your directory
  • Paste the Access file from the clipboard to your directory
  • Right click on the Access file in your Access directory; select Properties; find the Attributes selection at bottom of form; click on the check mark in Read Only to unselect it; click on OK
csc 100 sec 03 access data files
CSC 100 Sec 03Access Data Files
  • Go to CS100C directory; then to CS100C Data directory; and then to Data Files directory
  • Find the Access file you need and copy it to the clipboard
  • Go to your CS100C directory; then to the Access directory in your directory
  • Paste the Access file from the clipboard to your directory
  • Right click on the Access file in your Access directory; select Properties; find the Attributes selection at bottom of form; click on the check mark in Read Only to unselect it; click on OK
database chapter 1227
Database – Chapter 12
  • Key Issues
    • Create database form
    • Enter records
    • Format Datasheet view
    • Query a table
relational database techniques chapter 13
Relational Database Techniques – Chapter 13
  • Key Issues
    • Sort records
    • Modify a table
    • Modify records
    • Define relationships
    • View subdatasheets
    • Use select queries
    • Modify and delete select queries
    • Sort quer4y results
    • Use ranges in criteria
    • Create select queries involving And and Or
relational database reports chapter 14
Relational Database Reports – Chapter 14
  • Key Issues
    • Create relational database reports
    • Use fields
    • Create calculation fields
database word processor spreadsheet chapter 15
Database & Word Processor & Spreadsheet – Chapter 15
  • Key Issues
    • Copy Access database entries to a Word document
    • Copy Access database entries to an Excel spreadsheet
    • Create an Access table from Excel spreadsheet data
    • Use mail merge
powerpoint chapter 16
PowerPoint – Chapter 16
  • Key Issues
    • Create a presentation
    • Change views
    • Add and delete slides
    • Add graphics and charts
    • Format the presentation with transitions and animation
    • Apply a design template
    • Create speaker notes
web pages
Web Pages
  • Key Issues
ad