Csc 100 introduction to computers
Download
1 / 34

CSC 100: Introduction to Computers - PowerPoint PPT Presentation


  • 355 Views
  • Updated 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
Csc 100 introduction to computers l.jpg

CSC 100: Introduction to Computers

Dr. Chuck Lillie


Introduction l.jpg
Introduction

  • Course Outline

  • Syllabus

  • Assignments

  • Web Page

  • Exams

  • Grading

  • Class Makeup


Course outline l.jpg
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 l.jpg
Syllabus

  • CSC100-01 Syllabus-F02

  • CSC100-03Syllabus-F02


What is a computer l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
What is a Computer

  • Software

    • Word Processors

    • Spreadsheets

    • Databases

    • Desktop Publishing

    • Presentation Graphics

    • Web Publishing


Windows 98 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Word Processor- Chapter 4

  • Key Issues

    • Undo

    • Print preview

    • Format a document

    • Create headers & footers

    • Control pagination


Word processor chapter 416 l.jpg
Word Processor- Chapter 4

  • Key Issues

    • Use tabs

    • Set tab stops


Chapter 5 word processor l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Spreadsheet – Chapter 10

  • Key Issues

    • Sort

    • CHOOSE

    • VLOOKUP

    • Freeze Cells

    • PMT

    • Hyperlinks


Spreadsheet word processor chapter 11 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Database – Chapter 12

  • Key Issues

    • Create database form

    • Enter records

    • Format Datasheet view

    • Query a table


Relational database techniques chapter 13 l.jpg
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 l.jpg
Relational Database Reports – Chapter 14

  • Key Issues

    • Create relational database reports

    • Use fields

    • Create calculation fields


Database word processor spreadsheet chapter 15 l.jpg
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 l.jpg
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 l.jpg
Web Pages

  • Key Issues



ad