TCH020: Computer Fundamentals

This list is representative of the materials provided or used in this course. Keep in mind that the actual materials used may vary, depending on the school in which you are enrolled, and whether you are taking the course as Independent Study.

For a complete list of the materials to be used in this course by your enrolled student, please visit MyInfo. All lists are subject to change at any time.

Scope & Sequence : Scope & Sequence documents describe what is covered in a course (the scope) and also the order in which topics are covered (the sequence). These documents list instructional objectives and skills to be mastered. K12 Scope & Sequence documents for each course include:

Course Overview

In this introductory course, students will become familiar with the basic principles of a personal computer, including the internal hardware, the operating system, and software applications. Students will gain practice in using key applications such as word processors, spreadsheets, and presentation software, as well as understanding social and ethical issues around the Internet, information, and security.

This is a two-semester course package. In the first semester, the focus is on the fundamentals, learning and using the applications, and understanding the basic roles and responsibilities of the software, hardware, and operating system. In the second semester, the focus is on gathering and analyzing data and on using the right tools and methods to collect and present data. This course should not be taken if the student has already completed Computer Literacy.

back to top

Course Length

Two Semesters

back to top

Prerequisites

Students who have completed TCH010 should not enroll in this course.

back to top

Course Outline

Unit 1: Inside the PC

Students learn what makes up a computer, how it works, and how technology has improved over the years. They learn the history of computers, including an introduction to Microsoft Windows and other operating systems.

  • Introduction
  • A History of Personal Computing
  • The Key Building Blocks of a Computer
  • What Is an OS?
  • Microsoft Windows
  • Technology and the Future

Unit 2: Data Types

Students learn key types of data and how to gather, evaluate, and present those data. They explore Open Office or Microsoft Office and discover how to use the applications to manage data. They also learn about the Internet.

  • Introduction
  • Key Types of Data and Usage
  • Presenting Data: Case Study
  • Introduction to Microsoft Office 2010 or Open Office 3.4
  • Knowing Your Audience
  • The Internet

Unit 3: Documents

Students learn the basics of word processing. They create a document, format it, and make changes to it. They explore the use of graphics and different fonts that add more to documents.

  • Introduction
  • Uses of Word Processors
  • Creating a Document
  • Formatting Fonts
  • Formatting Paragraphs
  • More Formatting

Unit 4: Spreadsheets

Students learn the basics of spreadsheets and create their own. They explore the tools available in spreadsheets, including formulas and calculations and how to format them. They complete several projects that allow them to utilize what they have learned.

  • Introduction
  • Spreadsheets
  • Anatomy of a Spreadsheet
  • Creating a Spreadsheet
  • Formatting a Spreadsheet
  • Formulas

Unit 5: Presentations

Students learn the basics of presentation software. They create presentations that incorporate graphics and animation. They explore how presentations are used effectively in industry and education.

  • Introduction
  • Presentations
  • Creating and Formatting a Presentation
  • Drawing Diagrams
  • Tables and Charts
  • Slide Show Mode, Speaker Notes, and Outline Mode

Semester 1 Project

Unit 6: When All You Have . . .

Students learn how to do basic troubleshooting, what tool or application works best for the situation, and how to ask for help when they need it.

  • Introduction
  • Analyzing a Problem and Choosing the Right Tool
  • Getting Your Message Across
  • Types of Charts
  • More Charts
  • When to Use a Tool

Unit 7: Documents and Presentations

Students focus on guidelines, tips, and tricks to make presentations and documents more professional. They use practical concepts to ensure that a document or presentation is ready for publication.

  • Introduction
  • Styles and Headers
  • Shading, Patterns, and Colors
  • Spelling and Grammar
  • Slide Transitions and Animations
  • Charting in Impress vs. Calc

Unit 8: Advanced Analysis

Students expand their knowledge of spreadsheets by exploring more advanced features in Calc or Excel, including formulas, sorting, filtering, and conditional format. They also work with multiple spreadsheets.

  • Introduction
  • More Formulas
  • Sorting
  • Filtering
  • Conditional Formatting
  • Multiple Worksheets

Unit 9: Electronic Communication

Students explore other areas of communication, such as e-mail, blogs, Web pages, and instant messaging. In addition, they learn the various guidelines and social issues around this technology.

  • Introduction
  • E-mail Dos and Don’ts
  • Once on the Internet, It’s There Forever
  • File Size Matters
  • Security
  • Privacy

Unit 10: The System

Students conduct a brief comparison of the different operating systems, conduct search queries on the computer and Internet, and explore common problems on Windows-based systems and how to solve them. They learn about social issues in computer science, software piracy, and digital rights.

  • Introduction
  • Key Differences Between Windows, Mac, and Linux
  • The Power of Search
  • Solving Common Problems
  • Ethical Computer Use
  • Finding More Information

Semester 2 Final Project

back to top

Lesson Scheduling

back to top

K12 Scope & Sequence documents for each course include:

  • Course Overview (as seen above)
  • Course Outline
  • Lesson Time and Scheduling