Introduction to Computers - Intro to Computer- Semester Course

  • Welcome to Mr. Hunter's Introduction to Computer's Class.

    Course Description:

    This course is designed to give students an understanding of how a computer works, its capabilities, limitations, and applications. It includes system components, societal impact, applications, and the use of the Microsoft Office software package. This course is strongly recommended for all students. This course has no prerequisite. Students will learn basic computer concepts with an emphasis on the personal computer and its practical use, including hardware, mechanics of computer operation, application and system software, the Internet and World Wide Web, communications, and computers in society.  The major emphasis will be on the following applications: Keyboarding (Mavis Beacon Teaches Typing), MS Word, MS Excel, Charting, MS PowerPoint, MS Access and integration of these applications.

    “I do not fear computers. I fear lack of them.”– Isaac Asimov

    "Technological Literacy is a new fundamental for our education system. All of us must develop this literacy if we are to make wise decisions in our roles as citizens and in our personal lives."-- Rod Paige, U.S. Secretary of Education

    Course Outline:    Click here for Adobe Acrobat format 

     

    Course Requirements:

    Digital Curriculum:  "Applied Educational Systems" and "Microsoft Computer Dictionary".

    "Practical Excel 2000" by William B. Bergquist.
     

    Electronic Notebook
    Pen
    USB Drive (backup)

    Computer Workstation (Both in school and at home; I am here most afternoons, please come in to catch up on your work.)
    The above items are to be brought to class every day.

     

    *You will be utilizing  this year to access download data files and upload completed assignments and assessments.

     

    Students will be expected to manage their time and complete required assignments and participate in class discussions. Classroom activities will include group discussions, problem solving, and individualized instruction. Students are encouraged to work independently and assist others when appropriate.

    Grading Scale:

    Tests.......................................................................................................................35%
    Computer Exercises/Projects..........................................................................................35%

    Quizzes....................................................................................................................20%
    Teacher Evaluation......................................................................................................10%

     

    Tests:  Students retention of course content is assessed periodically, usually weekly. If a student plans to be absent, they should contact the teacher and arrange for the test to be taken three-school days from the date of absence.  A Final Exam will be administered.
     

    Computer Exercises/Projects: The entire semester will involve the use of computer applications to establish the relevance of this important tool to respond in your personal and professional lives.  The emphasis on software will be Windows XP/2000 (networking version of ME, 98, 95, etc.) and Microsoft Office applications such as Word, Excel, Graphics & PowerPoint.
     

    Quizzes:  Student’s retention of course content will be assessed periodically and a grade will be given.  If a student plans to be absent, they should contact the teacher and arrange for the quiz to be taken before the date of absence.
     

    Teacher Evaluation:  This subjective grade will include daily attendance, student behavior, classroom preparation, homework, daily work effort, and a notebook that should be updated daily and class participation.  (Preparation includes a student’s ability to bring required materials to class on a daily basis.)

    Computer Printout Heading: 
    (All printouts are to contain the following header, I will not grade an assignment that does not contain a complete heading.)
     

    Unit / Lesson #

    Topics

    Approximate # of
    Class Sessions
     
    Keyboarding Learn proper touch-typing Keyboarding Techniques
    (Keyboard image)
    This will be an introduction for each class for Week 2 -
    Week 10.
    Learning about Computers  Lesson # 1 Computer Literacy Topics
      What is a Computer
    Personal Computer Hardware
    Peripherals (Introduce Scanners)
    Bits & Bytes (Memory)
    Computer Speed & MHz/GHz
    Software
    Computer Types
    Computer Workers
    Societal Impact (How can you protect yourself from electronic concerns?)
    Safety Tips for using Social Networking Web sites
    How does a Computer Work?

    Online - Safety Tips and Advice >>more

    Computer Basics Handout
    Computer Basic Overview
    Vocabulary
    Input/Output
    What’s Inside a Computer?
    Storage
    Programs
    Operating Systems
    The Windows Desktop
    System Requirements
    Hardware Basics
    Organizing files and folders

    Lesson 1 Exam (TBA)

    MS Office 07 Exercise # 1 Terms

     

    "Learning Microsoft Office 2007" Table of Contents Tutorial site

    Exercise # 1

    About Business Technology
    About MS Office 2007
    Use the Mouse
    Use the Keyboard
    Start & Exit MS Office Programs
    Identify Common Screen Elements
    Customize the Start Menu

    pg 2-9
    Exercise 1 - Vocabulary
    Version 1 and Version 2

    Exercise # 2 About Commands
    About the Ribbon
    Use the Ribbon
    Use Access Keys
    Use the Office Button
    Use the Quick Access Toolbar
    Use the Mini-toolbar
    Use shortcut menus
    Use Dialog box options
    Use Task panes
    pg 10-18

    Exercise 2 Vocabulary
    Version 1 and Version 2

    Elements - Office Window
    Version 1 and Version 2

    Quiz V1 and V2

    Exercise # 3 Use Windows Controls
    Zoom options
    Scroll options
    Using Multiple Windows
    pg 19-25

    Exercise 3 Vocabulary
    Version 1 and Version 2

    Exercise # 4 Use the Help Program
    Search for Help
    Use the Help Table of Contents
    Recovering a file
    pg 26-30

    Exam V1 / V2- Sept. 20th
    MS Word 2007    
    Exercise # 1 Start Word
    The Word Window
    Change / personalize the Word Window
    Type in a document
    Correct errors
    Use the Undo, Redo, and Repeat commands
    Save a New Document
    Close a document
    Create various Business Documents
    Exit MS Word
    pg 32-40

    Term Exercise

    Jcloze Exercise
    Exercise # 2 Create a New Document
    Work with Show/Hide Marks
    Move the Insertion Point in a document
    Use Click and Type
    Save Changes
    Print  (PDF Creator)
    Preview a document
    About Press Releases
    pg 41-46
    Exercise # 3 Correct Spelling as You Type
    Correct Grammar as You Type
    Check Spelling and Grammar
    Use the Thesaurus
    pg 47-52

    Term Exercise
    Exercise # 4

    Use AutoCorrect

    Select Text in a Document
    Replace Selected Text

    Align Text Horizontally

    Align a Document Vertically
    Line Spacing
    Paragraph Spacing
    About Memos

    pg 53-60
    Exercise # 5

    Format a Business Letter

    Insert the Date and Time in a Document

    Use Uppercase Mode

    Change Case

    Create an Envelope

    pg 61-66


    Business Letter

    Exercise # 6

    Set Tabs

    Format a Modified-Block Business Letter

    Shrink One Page

    pg 67-71
    Exercise # 7

    Exercise Directions
    (pg 77-80)

    State abbreviations Game

    Format a Personal Business Letter
    (Business Letter Styles)
    (Business Letter Elements)
    Parts of a Business Letter
    Unformatted Letter
     

    About Fonts

    Change the Font

    Change Font Size

    Apply Font Styles

    Apply Underlines

    Create Labels
    Resumes
      How to Write a Resume
      Resume Samples
      Resume Workshop (Purdue University)
      Winning Edge Resume

      Cover Letters

      Sample Cover Letters and Resumes
      Resume_Resource_1
      Purdue - Resumes
    **Resume-Work Skills

    pg 72-80
    Exercise # 8 Critical Thinking
    &
    Exercise 9
    Critical Thinking & Curriculum Integration
    Cover Letter and Resume

    **Exercise # 8 is our Lesson # 1 Exam.

    pg 81-86
    Exercise # 10 Use of Proofreader's Marks
    Open a Saved document
    Insert edit text
    Using Overtype mode
    Save a document with new name & Save Options
    pg 88-92
    Exercise # 11 Using Split Screen view
    Open & work with multiple documents at the same time
    Arrange documents on the screen
    Compare documents side by side
    pg 93-98
    Exercise # 12 Moving text
    Use cut and paste
    Use the Clipboard Task Pane
    Use Drag-and-Drop editing
    Select paste formatting options
    Move a paragraph
    pg 99-103
    Exercise # 13 Use Copy & Paste
    Use Drag-and-Drop Editing to Copy
    pg 104-107
    Exercise # 14 Open a document as Read-Only
    Open a document from Windows
    Use document properties
    About File types
    pg 108-113
    Exercise # 15 Preview a closed document
    Print a closed document
    pg 114-117
    Exercise # 16 - Critical Thinking


    Exercise # 17 - Curriculum Integration
    Critical Thinking
    Preview a closed document
    Print a closed document
    **Exercise # 16 is our Lesson # 2 Exam.
    pg 118-122
    Exercise # 18 Apply Font Effects
    Font color
    Highlight Text
    Format Painter
    pg 124-129
    Exercise # 19 Using symbols pg 130-133
    Exercise # 20 Indenting Text pg 134-137
    Exercise # 21 Bulleted Lists
    Numbered Lists
    Sort
    pg 138-144
    Exercise # 22 About Styles
    Apply Styles
    Create a Style
    Edit a Style
    Reapply a Style
    Reapply direct formatting
    Clear Formatting
    pg 145-150
    Exercise # 23 About Documentation Production
    Set Margins
    Set Page Orientation
    Format a One-Page Report
    pg 151-156
    Exercise # 24 Use Themes
    Use AutoFormat as You Type
    pg 157-161
    Exercise # 25 & 26
    Critical Thinking
    and Curriculum Integration
    Critical Thinking

    **Exercise # 25 is our Lesson # 3 Exam.
    pg 162-166
    Exercise # 33 Create a Table
    Enter data in a Table
    Select in a Table
    Change Table structure
    Format a Table
    pg 192-197
    Exercise # 34 Setting alignments within Table cells
    Set Cell Margins
    Align a Table on a Page
    Column Width and Row Height
    pg 198-202
    Exercise # 35 Draw a Table
    Move and Resize Tables
    Merge and Split Cells
    pg 203-208
    Exercise # 36 Calculations in a Table
    Number Formats
    Sort Rows
    Cell Borders and Shading
    pg 209-214
    Exercise # 37 & 38 Critical Thinking and Curriculum Integration

    **Exercise # 37 is our Lesson # 5 Exam.
    pg 215-218
    MS Excel 2007    
    Exercise # 1 Start Excel
    Understanding the Excel Window
    Excel Interface
    Navigate the Worksheet
    Change between worksheets
    Worksheet Views
    Exit Excel
    pg 358-364
    Exercise # 2 Creating a New (blank) Workbook
    Create a Workbook from a Template or Another Workbook
    Enter Labels
    Make simple corrections
    Undo and Redo
    Delete (Clear) Cell contents
    Save a Workbook
    Close a Workbook
    pg 365-371
    Exercise # 3 Open Workbooks
    Change from Workbook to Workbook
    Compare Workbooks
    AutoComplete
    Pick from List
    AutoCorrect
    Spell Check
    pg 372-378
    Quiz
    Exercise # 4 Enter Numeric Labels and Values
    Enter Dates
    Create a Series
    Change Data Alignment
    Change Column Width
    pg 379-386
    Exercise # 5 Enter Formulas pg 387-392
    Exercise # 6 & 7
    Critical Thinking
    and Curriculum Integration
    Exercise # 6 - Critical Thinking
    Exercise # 7 - Curriculum Integration

    **Exercise # 6 is our Lesson # 1 Exam.
    pg 391-394
    Exercise # 8 Select Ranges
    Range Entry Using Collapse button
    pg 396-399
    Exercise # 9 Choose a Theme
    Apply Cell Styles (Quick Styles)
    Apply Font Formats
    Apply Number Formats
    pg 400-406
    Exercise # 10 Copy and Paste Data
    Copy Formats
    Relative Reference
    Absolute Reference
    Preview and Print a Worksheet
    pg 407-411
    Exercise # 11 Insert and Delete Columns and Rows
    Move Data (Cut/Paste)
    Drop-and-Drag Editing
    pg 412-416
    Exercise # 12 Insert, Delete, Copy, Move, and renaming Worksheets
    Change the Color of a Worksheet Tab
    Hide Sheets
    Group Sheets
    pg 417-421
    Exercise # 13 & 14
    Critical Thinking
    and Curriculum Integration
    Exercise # 13 - Critical Thinking
    Exercise # 14 - Curriculum Integration

    **Exercise # 13 is one of our Lesson # 2 Exams.
    pg 422-426
    Exercise # 15 Use Functions
    Common Functions
    Insert a Function
    AutoCalculate
    pg 428-435
    Exercise # 16 Excel Tables
    Comments
    pg 436-440
    Exercise # 17 Named Ranges pg 441-445
    Exercise # 18 Understand IF Functions
    Nested IF Functions
    =SUMIF() and SUMIFS() Functions
    =COUNTIF() and COUNTIFS() Functions
    pg 446-452
    Exercise # 19 Chart Basics
    Select Chart Data
    Chart Elements
    Create Charts
    Change Chart Types
    Select a Chart
     
    pg 453-459
    Exercise # 20 Change Data Series Orientation
    Format a Chart
    Resize, Move, or Delete a Chart Object
    Change Chart Text
    Enhance Chart Background
    Format Category and Values Axes
    pg 460-468
    Exercise # 21 & 22
    Critical Thinking
    and Curriculum Integration
    Exercise # 21 - Critical Thinking
    Exercise # 22 - Curriculum Integration

    **Exercise # 21 is one of our Lesson # 3 Exams.
    pg 469-472
    Exercise # 38 Use PMT function
    Create What-If data tables
    Solve a Problem with Goal Seek
    Use Solver to Solve problems
    pg 542-548
    Exercise # 39 Extra Credit
    Create LOOKUP functions
    pg 549-553
    Final Examination  Week of January 25th Final Exam

     

     

     

     

     

     

Introduction to Computers - Semester Course - Digital Curriculum

Related Files