Slides from Lectures

• First Lecture Tuesday, January 11, 2022

  ---

• File Management

  ---

• Spreadsheets I
  • Basic Spreadsheets
  • Animation of a Spreadsheet
  • Animation of Relative and Absolute Addresses

  ---

• History and Basics

  ---

• Hardware and Software
• Animation of Defragmenting a Hard drive
• RAM Explained about the first 3 or 4 minutes apply to this class, he gives a lot more detail!
• Video on how to Defragment a disk
• 32 bit vs. 64 bit
• Animation of LCD display
• Animation of Laser printer

  ---

• Spreadsheets II
  • Advanced Spreadsheets
  • Pivot Tables in Excel
  • Pivot Tables example sheet

  ---

• Operating Systems
• OS for mobile systems

  ---

• Midterm Review Tuesday, March 8
  Answers: 1. A, 2. A, 3. B, 4. D, 5. B, 6. D, 7. C, 8. B, 9. B, 10. D, 11. C, 12. B, 13. B, 14. B, 15. B, 16. A, 17. B, 18. B, 19. D, 20. A, 21. B, 22. C, 23. B

  ---

• Computer Applications

  ---

• Programming
  • Alice programming
  • More Alice slides
  • Programming Basics
  • More slides on Structured Programming
  • Animation of repetition control structure Runs on Windows
  • Animation of selection control structure Runs on Windows
  • Animation of a flowchart Runs on Windows

  ---

• Databases
  • Database Principles
  • Data Validation and Creating tables in Access
  • Database Relationships
  • Database Queries
  • Database Objects and Miscellaneous (Concurrency)
  • More about Databases (Forms, Exporting, Indexes)
  • This is why you want data types!
  • Example Relationship (Customers-Orders) Database file
  • Example Relationship (Students-Classes) Database file

  ---

• HTML
  • HTML/WWW History
  • HTML primer (detailed)

  ---

• The Internet
  • The Internet and Web
  • Privacy and Security
  • Webs / Wireless Apps - Communication on the Net
  • How a DNS Server works Good video, first 2.5 minutes are all the detail we will need
  • Difference between Modem and Router Good video! 7 minutes long
  • 40 Maps that explain the Internet
  • Cloud Computing
  • Radio Show about the Cloud
• Review Final Exam
  ANSWERS: 1.D, 2.B, 3.D, 4.C, 5.B, 6.D, 7.D, 8.D, 9.B, 10.A, 11.A, 12.C, 13.C, 14.D, 15.B, 16.A, 17.A, 18.B, 19.C, 20.B, 21.B, 22.B, 23.A