This is the lesson plan for my college level, semester long, computer concepts course. Here's the course description ...
You are about to embark on an exciting journey learning about the information revolution and the incredible world of computers.
This course is very practical and applicable. It focuses on teaching you skills you can use. These skills include not only specific hands-on skills, like "right-clicking" and taking "screenshots," but also skills such as keeping yourself safe online, not texting while you're driving, and what to look for when buying computers (just to mention a very small fraction of the skills this course will teach you).
This is a university level course designed to introduce individuals to the world of computers, so it is rich in its depth and breadth of content. I have taught this course for over a decade and have refined it to be incredibly amazing and awesome. You are going to love this course and it will forever change your life. You will gain skills in this course which you will use for the rest of your life and which will make your life easier. Knowing how to use computers is essential in our day-and-age. This course will give you the skills you need to use computers well.
Presented with high-quality video lectures, this course will visually show you how to easily do everything with computers. This is just some of what you will learn in this course:
Learn the basic principles of hardware including circuits, coding schemes, binary, the five generations of computers, Moore's Law, IPOS, registers, cache, RAM, magnetic storage, optical storage, solid-state storage, ROM, BIOS, the motherboard, buses, and the CPU.
Learn how to operate a computer including a vast array of hands-on skills – just to mention a few for example: managing files, backing –up files, right clicking, taking screenshots, determining your computer’s properties, upgrading your computer, changing settings on your computer.
Learn how to use word processing software including the creation of a title page, document sections, headers and footers, styles, an automatically generated table of contents, the insertion of images, references, and the insertion of an automatically generated citation of works referenced.
Learn how to use spreadsheet software including formulas, functions, relative references, absolute references, mixed references, and the creation of a graph or chart.
Learn how to use video editing software including adding credits and transitions then publishing that video to a video hosting website such as YouTube.
Learn how to use databases including table creation, the setting of a primary key, the establishment of table relationships, the setting of referential integrity, and the creation and execution of a query.
Learn how to use presentation software to more effectively give presentations.
Learn to do some simple programing including designing, coding, testing, debugging, and running a program.
Learn about the world wide web including sending email, conducting searches , having familiarity with online educational resources such as Khan Academy, and having an awareness of online "cloud computing" tools such as Google Word Processing, Google Spreadsheets, and the many other online tools offered by Google.
Learn about application software and system software including operating systems, utilities, and drivers.
Learn about networks including architecture, topology, firewalls, security, wireless networks, and securing wireless networks.
Learn about the Internet, the World Wide Web, censorship, the digital divide, net neutrality, differing legal jurisdictions, website creation, multimedia, social media, and eCommerce.
Learn about information systems, systems development, and the systems development life cycle.
Learn about program development, programming languages, and the program development life cycle.
Learn about databases including table creation, primary keys, relationships, referential integrity, queries, and structured query language.
Learn about privacy and security issues related to computers.
Learn about robots and artificial intelligence including the Turing test.
Learn about intellectual property including patents, trademarks, copyrights, and the creative commons.
Learn about ethics and ethical issues relating to the use of technology.
Learn about health ramifications of using computers including repetitive stress injury, carpal tunnel syndrome, and ergonomics.
Learn about e-Waste and other environmental concerns related to technology.
Lifetime access to this course allows you to easily review material and continue learning new material.
After taking this course, you will have a thorough understanding of how to use computers well.
From beginners, to advanced users, this course is perfect for all ability levels. This course will add value to everyone's skillset.
- Applied Science
- Computer Science
- Material Type:
- Lesson Plan
- Fresno City College
- Provider Set:
- Individual Authors
- Todd McLeod
- Date Added: