1 / 34

CSC 100: Introduction to Computers

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

stedman
Download Presentation

CSC 100: Introduction to Computers

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CSC 100: Introduction to Computers Dr. Chuck Lillie

  2. Introduction • Course Outline • Syllabus • Assignments • Web Page • Exams • Grading • Class Makeup

  3. 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

  4. Syllabus • CSC100-01 Syllabus-F02 • CSC100-03Syllabus-F02

  5. 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

  6. 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)

  7. 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

  8. 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

  9. 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

  10. 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

  11. What is a Computer • Software • Word Processors • Spreadsheets • Databases • Desktop Publishing • Presentation Graphics • Web Publishing

  12. 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

  13. 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

  14. 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.

  15. Word Processor- Chapter 4 • Key Issues • Undo • Print preview • Format a document • Create headers & footers • Control pagination

  16. Word Processor- Chapter 4 • Key Issues • Use tabs • Set tab stops

  17. Chapter 5: Word Processor • Key Issues • Copy & Paste Text • Use Windows and Office Clipboards • Find & Replace Text • Use Thesaurus • Format Indents

  18. 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

  19. 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

  20. 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

  21. 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

  22. Spreadsheet – Chapter 10 • Key Issues • Sort • CHOOSE • VLOOKUP • Freeze Cells • PMT • Hyperlinks

  23. 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

  24. Database – Chapter 12 • Key Issues • Understand what a relational database is • Design an Access relational database • Crate an Access relational database

  25. 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

  26. 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

  27. Database – Chapter 12 • Key Issues • Create database form • Enter records • Format Datasheet view • Query a table

  28. 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

  29. Relational Database Reports – Chapter 14 • Key Issues • Create relational database reports • Use fields • Create calculation fields

  30. 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

  31. 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

  32. Word Processor & Database & Spreadsheet & PowerPoint • Key Issues

  33. Web Pages • Key Issues

  34. Web Pages & Word Processor & PowerPoint • Key Issues

More Related