I have been teaching this Computers course for over 10 years (3-4 classes each year). Each time I teach these lessons, I update and refine them with new videos, screen shots, instructions, student exemplars etc.
This whole computers course is divided into 2 parts. Due to the size of the files I could not upload all of the lessons and actIvities into one product. This is Part 1. There is a link to Part 2 at the bottom of this description. You will want to buy both parts to cover the entire computers course.
Click on the link below for Computers Course - Part 2
Computers Course - Part 2
These lessons and activities can be easily added and used within Google Classroom
In addition to the PDF lessons in this bundle, I am now offering buyers the extra option to email me once they have purchased this bundle to receive editable copies of these lessons/activities through Google Drive.
1. COURSE OUTLINE / TEN AMAZING TECH / KAHOOT / ABOUT ME POSTER
2. SIXTHSENSE TECHNOLOGY
- A computer that mounts to your body!
• The Thrilling Potential of SixthSense Technology
• This technology merges your Real World and your Digital World
• Make an iPad from a piece of paper
• Is this where computers are going in the future?
3. INTRODUCTION TO COMPUTERS
• Functions of Computers (IPSO)
• Operating Systems
• RAM vs. ROM
4. MICROSOFT WORD
• Bulleted and Numbered Lists
• Bold, italics, Underline
• Align and Center Text
• Inserting (Tables, Pictures, Shapes, SmartArt, Charts, Header, Page Numbers, WordArt, Textboxes, Video)
• Page Layout (Page Size, Margins, Orientation, Page Color)
• References (Table of Contents, Bibliography, Endnotes and Footnotes, Citation)
• Mailings (Labels)
• Review (Spelling and Grammar, Thesaurus)
• View (Zoom, Print and Web Layout)
WORD Activities (Instructions, Marking Scheme, Student Exemplars)
• Formatting a Document
• Setting Up a Page
• Creating Images using Shapes
• Using Picture Tools to Add and Move Images
• Creating a Resume
5. MICROSOFT PUBLISHER
• Font (Bold, Underline, italics, Color, Size, Style)
• Shapes (Insert, Re-order, Fill, Outline, Transparency)
• Pictures (Insert Online Pictures, Format Picture Style, Crop, Recolor, Brightness and Contrast)
• Text Box (Insert, Format)
• Borders and Accents
• Calendar and Page Parts
• Table (Rows, Columns, Color Scheme, Line Width and Color)
• Page Design (Background Color, Built-in Color Schemes, Margins, Page Orientation, Page Size)
• Mailings (Mail Merge)
• Review (Check Spelling, Thesaurus)
• View (Zoom into and out of Document)
• Events Poster
• Business Cards
• Cereal Box
6. MICROSOFT EXCEL
• Excel Features and Entering Information
• Rows vs. Columns
• Creating Spreadsheets
• Types of Spreadsheets
• Creating and Formatting Spreadsheets
• Calculating and Analyzing Data
7. MICROSOFT POWERPOINT
• Format Text (font color/style, underline, italics, bold, bulleted lists, align text)
• Changing Slide Layouts
• Creating New Slides
• Inserting Shapes, Text Boxes, Tables, WordArt, Pictures
• Arranging Shapes
• Constructing SmartArt and Charts
• Design (Slide Layout)
• Slide Backgrounds
• Transitions and Custom Animation
• Slide Show (Setting up the show)
• Review and Viewing the Presentation
POWERPOINT Activities (Fun Themes)
• Tech Gadget
• Snack Treat
• Tech Sharing
8. GOOGLE ACTIVITY
• Why is creativity very important to a company like Google?
• Who started Google and how did they do it?
• What is it like to be a Google Intern?
• How did Google win Advertiser of the Year?
• What are Adwords and Analytics?
This lesson contains links to articles, infographics and videos. It has been in development for 6 years and has been used, tested and updated with many classes.
A GOOGLE A DAY ACTIVITY
This activity uses screen shots, instruction bubbles and a video to explain how to play “A Google A Day”, Google’s trivia search game.
• A trivia game using Google “search” to find answers
• Encourages players to engage with the search engine and learn how to use its functions better
• Solve the questions with savvy search skills
• Each day Google creates new questions
• The faster you search the more points you score and the more badges and achievements you get
• Players learn how to adjust their search terms to eliminate unnecessary words, training them to use Google more efficiently
• This game can be used for students that finish their work early or just for some fun at the end of class.
• It is also great to use as a group competition and see who achieves the most points at the end of a set time or at the end of the daily challenge
9. GOOGLE DRIVE
(Documents, Sheets, Slides, Drawings, Forms)
• Create and share your work online and access your documents from anywhere.
• Manage documents, spreadsheets, presentations, surveys, and more all in one location.
• These Google programs are FREE.
• These lessons contains screen shots, activities, marking schemes, tips and instructions for using Documents, Slides, Sheets, Drawings and Forms within Google Drive.
* Documents is similar to Microsoft Word
* Slides is similar to Microsoft PowerPoint
* Sheets is similar to Microsoft Excel
* Drawings is similar to Microsoft Publisher
* Forms is a useful tool to help you plan events, send a survey or give students a quiz
You will receive these lessons in both PowerPoint and PDF formats.
UPDATE: Lessons for the new Google Add-ons and Updates have been added.
1. Edit Files Offline
2. Edit and Share Microsoft Office Files – Without using Microsoft Office
3. New Activity Stream
• EasyBib – Bibliography Creator
• Mindmeister – Visual Mind Map
• WeVideo – Create Videos
• Kaizena – Add Voice and Text Comments to Students Work
• Flippity - Flashcards
• OpenClipArt - 50,000 Copyright Free Images
• Flubaroo – Create a Self-Graded Quiz
• QR Code Generator for Google Sheets
5. New Google Sheets
6. Edit images right in Google Drive or Drawings
1. Google Drive Infographic
2. Google Drive - Files, Folders and Sharing Lesson
3. Google Drive Kahoots
UPDATE Feb 2016: A new lesson/activity has been created for Google Forms (new screen shots and instructions) as Google updated the layout of this program. Also, New Covers have been added to all lessons in this bundle. Instructions are still included for the older version of Forms as some people have not migrated to the new version or prefer to use the older version. You can easily switch back and forth between the newer and older versions of Forms with the press of a button.
• Create and share your work online and access your documents from anywhere
• This lesson contains screen shots, tips, activities and instructions for setting up a free account and creating/editing Documents using Google drive.
• This lesson and activity contains screen shots, tips and instructions for using Presentations within Google Drive. It also includes 2 activities students can do using Google Slides along with Marking Schemes.
• This lesson and activity contains screen shots, tips, activities and instructions for using Spreadsheets within Google Drive.
• Google Forms is a useful tool to help you plan events, send a survey or give students a quiz
This lesson and activity contains screen shots, instructions, an activity and marking scheme to enable teachers and students to use Google Forms.
• Easily create, share, and edit drawings online
• Edit drawings online in real time with anyone you choose
• Insert text, shapes, arrows, scribbles, and images from your computer
• Insert drawings into other Google documents, spreadsheets, or presentations
This lesson and activity includes screen shots and instructions to enable teachers and students to use Google Drawings.
Files, Folders, Sharing and Collaborating
• When you create a Doc, Sheet, Slide, Drawing or Form, it is saved to your My Drive
• You can move these documents into Folders to help organize your files
• Folders help organize files so that they can quickly be retrieved at a later date
• Sharing work and Collaborating on group projects are two helpful features of Google Drive
• Grid View, Sort Options, Hide Details, Settings, Preview
• Creating Folders
• Moving Files to a Folder
• Location of Folders
• Changing Colors of Folders
• Viewing Files in a Folder
Sharing and Collaborating
• Viewing Files “Shared with Me”
• Adding Collaborators
• I have taught computers for over 12 years and I notice that many students do not know how to save documents to folders (even in Microsoft Office)
• Also, how you move/access files and folders in Google Drive is different than Microsoft Office
• Use this lesson to teach students about files, folders and sharing within Google Drive
Google Drive Updates and Add-ons…
QR Code Generator
This guide shows teachers and students how to create QR Codes in Google Drive using an add-on for Google Sheets called QR Code Generator
• A QR code (Quick Response Code) is a type of matrix barcode first designed for the automotive industry in Japan
• When scanned with a smartphone, tablet or laptop they will take you to a website, article, video, social media page and more
• All you need is a camera lens on your device and a free QR code scanning app
• QR Codes can be used for many classroom activities including website and video investigations
• QR Code Generator is an add-on for Google Sheets
• It allows you to generate QR codes directly from Google Spreadsheets
• Make multiple QR codes quickly and easily
• Teachers can create the codes themselves for activities or use this guide to show students how to create and share codes
Flippity Flashcards using Google Sheets
• Flippity.net offers teachers the ability to create online flash cards using information generated in a Google Spreadsheet.
• Flashcards are designed for gaining a rapid response from students when held up briefly by a teacher.
• Use Flippity to assess prior knowledge, for test preparation or to evaluate understanding after a lesson/unit.
This lesson contains step-by-step instructions for designing the cards in Google Sheets and then importing them into Flippity. These cards take minutes to create and this lesson will help guide you or your students through the process with visuals and instruction bubbles.
Activity: Have your students create their own flashcards and then test one another about course information!
• OpenClipArt provides many amazing copyright free images
• There are more than 50,000 images in their library to enhance your document
• OpenClipArt is a new add-on for Google Drive
• Search for images and insert them right into your Google Document
• This guide will show you how to access OpenClipArt from a Google Document and how to insert images
• The people who have contributed images to OpenClipArt have waived all copyright and related or neighboring rights to their contributions
MindMeister Mind Maps
• Create, share and collaboratively edit mind maps
• Add icons, images, notes, links and attachments
• Open, view and edit mind map files from Google Drive
• Export to Word, PowerPoint, PDF, image, MindManager and Freemind
This lesson contains screen shots and instruction bubbles to show teachers and students how to make Mind Maps using MindMeister.
Note: MindMeister is available through Google Drive. Instructions are included for accessing MindMeister in Google Drive.
WeVideo Video Editing
• WeVideo is the leading online video creation platform for video editing, collaboration, and sharing across any device.
• Drag and drop your videos, trim and choose from pre-made themes to set a unique style.
• WeVideo allows you to easily create and share videos and short animations right in Google Drive.
This lesson contains screen shots and instruction bubbles to teach students how to use WeVideo to make amazing videos.
1. Accessing WeVideo
2. Import Images/Video
3. Drag Images/Video into Storyboard
4. Edit Video
5. Change Theme
6. Add Music
7. Apply Graphics
8. Publish Video
9. Video Topic Ideas
Creating a Self-Grading Quiz using Google Forms and Flubaroo
This lesson includes screen shots and step-by-step instruction bubbles to enable you to create a self-grading quiz using Google Forms and Flubaroo.
• Send a Google Form Quiz or Investigation to students to complete and then use Flubaroo to grade the Quiz
• You do not need to grade the Quiz – Flubaroo will do it for you!
• Flubaroo is an add-on for Google Drive.
• Grade online assignments in under a minute!
• Get reporting and analysis on student performance!
• Email students their scores.
• All Electronic Documents– No Paper!
• Creating Quizzes, Tests and Investigations in Google Forms saves lots of time
• Easy to customize – add and delete questions
• It takes seconds to grade all of the assignments!
• Students are exposed to a variety of types of questions including Multiple Choice, which is used on many standardized tests
10. GOOGLE CLASSROOM
Google Classroom is your mission control for class. Create classes, distribute assignments, send feedback, and see everything in one place. Instant. Paperless. Easy. (google.com/edu/products)
1. Create a class with just a few clicks
2. Add your students by sending them a class code or adding them directly
3. Create an assignment. You’ll be able to see who’s completed the assignment and who’s still working on it.
4. Archive and delete a class at the end of the semester or school year.
1. Everything is in one place. Join the class in one click and then have all of the materials at your fingertips.
2. Start a conversation. Communicate privately with your teacher or ask questions to the whole class.
3. Submit assignments. Attach anything to your assignments (Google Docs, links or photos)
• This is a step-by-step guide for teachers and students who are new to using Google Classroom.
• Screen shots and instruction bubbles are used to show how to get started and easily navigate within Classroom.
• The following topics are covered in this teacher and student guide…
1. Create a Class
2. Post to Classroom Stream
3. Stream Options (Create Question, Assignment or Announcement)
4. Share a Class Code
5. Invite Students (Select Students by Directory, Contacts or Groups)
6. Class Overview
7. Add Class Materials (Files, Drive Documents, YouTube Videos, Links)
8. Google Drive Classroom Folders (Moving Files to Classroom Folders)
10. Student Settings
11. Google Classroom from the Student's Perspective (Printed Handout or Electronic Copy for Students)
This guide utilizes screenshots and instruction bubbles to show teachers and students how to use Google Calendar. Use Google Calendar in conjunction with other Google Apps including Google Drive and Google Classroom.
1. Accessing Calendar
2. New Calendar
3. View Options
4. Quick Add
5. Adding an Event
6. Edit Event
7. Delete Event
12. Share Calendar
11. GOOGLE MY MAPS
With My Maps, you can:
• Create a map
• Draw lines, shapes, or placemarks on the map
• Import data including addresses and place names
• Organize your map with layers to hide or show different kinds of content
• Style your content with different colors, placemark icons, and line widths
This lesson includes screen shots and instruction bubbles to show teachers and students how to use Google My Maps.
This resource also contains an activity where students will be able to practice using My Maps to plot locations, measure distances, find driving directions, adding markers and pictures etc. with 2 student exemplars.
12. GOOGLE ONLINE ROADSHOW
Google recently launched their Online Safety Roadshow on YouTube to help protect kids on the web.
This series contains 5 excellent videos with tips for staying safe online…
Tip 1: Think Before You Share
Tip 2: Protect Your Stuff
Tip 3: Know and Use Your Settings
Tip 4: Avoid Scams
Tip 5: Be Positive
This digital citizenship activity includes video links and questions so that students can be safer online . Each of these videos are short and engaging (between 1 and 2 minutes in length).
13. LESSON PLANS USING GOOGLE SHEETS
• This guide shows you how to create your own individualized Lesson Plans using Google Sheets.
• Google Sheets (Part of Google Drive) is a Free alternative to Microsoft Excel that lets you create and format spreadsheets and simultaneously work with other people.
• Create whatever plan suits your needs depending on grade level, subjects taught, school schedule etc. using the instructions contained in this guide.
• Develop other classroom forms in Sheets such as recording student information, classroom supplies etc.
1. Sample Lesson Plans and Lesson Information
2. Font Styles and Sizes
3. Undo a Mistake
4. Color Cells
5. Align and Center Text
6. Insert Rows
7. Insert Columns
8. Resize Columns (Method #1 and #2)
9. Merge Cells
10. Create Borders
11. Copying Lesson Plan Templates
12. Rename Sheets
13. Importing Excel Templates into Google Drive
14. Sharing Plans to Co-Create Lesson Plans
Note: This guide also includes instructions for setting up a Free Google Drive account and accessing Google Sheets.
Sharing Lesson Plan Templates: Your purchase includes the option to email me and I will share lesson plan templates with you through Google Drive.
UPDATE: Another option for creating lesson plans in Google Sheets is to utilize one of the pre-designed Excel 2013 lesson plan templates. Instructions have been added for importing Excel 2013 lesson plan templates into Google Sheets so that you can use these templates or migrate your own existing Excel templates.
Advantages to creating lesson plans in Google Drive…
• Create customized layouts
• Easily duplicate layout for each day/week/month of the school year
• Quickly access each plan from one location
• Efficiently edit and revise plans
• Share through Google Drive to co-create/update lesson plans
14. GOOGLE GLASS
Google stunned the technology industry in 2012 when it revealed its plans to sell Google Glass but why is this device not widely available for purchase today? Google Glass are eyeglass frames that put a small computer display in a person’s field of vision. Vuzix has been selling wearable displays for years to the military. Will these devices end up replacing Smartphones and other handheld devices?
This Google Glass presentation includes links to videos, online articles, infographics and websites so that students can investigate this technology through questions and activities.
15. GOOGLE IMAGE SEARCH
Students will learn how to filter results by…
1. Size (Large, Medium or an Exact Size)
2. Color (Full Color, Black and White, Transparent)
3. Type (Face, Photo, Clip Art, Line Drawing, Animated)
4. Time (Anytime, Past 24 hours, Past Week, Custom Range)
5. Usage Rights (Labeled for Reuse and Noncommercial Use)
This lesson includes screen shots and instructions to enable students to effectively find images using Google’s Search Tools for images
• Kahoot is a game-based classroom response system
• Create and play quizzes, discussions and surveys using any device with a web browser
• Motivate participation through game-based learning and rewards in a social setting
This lesson includes screen shots and instructions for…
1. Setting-up a Free account
2. Creating quizzes, discussions and surveys
3. Searching and using Public Kahoots
4. How to Play Kahoot with your class
Students love Kahoot! I know this from the feedback I receive from other teachers and from my own experience with using Kahoot. Students ask me “Can we please play Kahoot?” For every game there is always lots of laughter and students are very engaged.
At the end of the 2014/15 school year, I gave students a day to complete missing assignments. There were several students who were finished all of their work. These students got together and set-up their own game of Kahoot. I did not suggest it, they just really wanted to play. This was more evidence for me that students love this interactive tool.
There are many uses for Kahoot including…
• Getting to know students at the beginning of a school year/semester
• Assessing student/class understanding of a topic
• Reviewing a unit before a test
• Surveying a class
• Having fun for a few minutes at the end of the day
17. COMPUTER REPAIR INVESTIGATION
• The purpose of this investigation is to see if computer repair companies really know what they are doing and if they are charging the correct prices
• Many people are desperate to get their technology fixed and do not know much about their devices
• Marketplace TV rigged an apartment in Toronto, Canada with hidden cameras
• They created a small problem to a computer and called in 10 repair techies
• Only 30% of the techs were able to diagnose the problem
• In all of their testing, one techie performed poorly in every way – service, diagnosis, price and privacy
• They went to London Ontario to interview one of the founders of the company about this employee
• They interviewed 3 guys that used to work for computer repair companies
Marketplace TV found out…
• Tech Training is inconsistent (Here is a manual you are learning on your feet)
• Employees are encouraged to overcharge
• Techies sometimes copy private information
• Many computer owners don’t know much about their computers which makes it easy to scam people
This activity has a link to the 25 minute video, summary slides and questions.
• Prezi is a presentation tool that helps students organize and share their ideas
• It offers Free cloud-based presentation software
• Present ideas on a virtual canvas using this storytelling tool
• Instead of slides and bullet points (PowerPoint), Prezi offers a zoomable canvas, which makes it fun to explore ideas
This lesson contains instructions, tips, screen shots, student exemplars, 2 activities and a marking scheme.
• This lesson educates students and teachers on how to use the free software offered at Glogster.com
• Glogs are interactive posters loaded with text, graphics, music, and videos
• Glogster’s goal is to provide an outlet for unlimited creative expression online
• Instructions for using this poster program, screen shots with text bubbles, activities, student exemplars and a marking scheme are included in this lesson
• Creative tools for photo editing and graphic design
• Free! No download; easy-to-use interface
• Gorgeous one-click effects and filters
• Add text, effects or overlays
This lesson includes screen shots, instruction bubbles and an activity to teach students how to use the photo editing options within PicMonkey.
Mind Map Tool
• Popplet is a tool to capture and organize your ideas
• Students use Popplet for learning
• Used as a mind-map, Popplet helps students think and learn visually
• Students can capture facts, thoughts, and images and learn to create relationships between them
This lesson includes screen shots, step-by-step instructions and a video to show teachers and students how to get started with using Popplet. It also includes an activity along with several student exemplars.
22. FOR THE LOVE OF TECHNOLOGY
These videos are suitable for most grade levels and are designed to spark curiosity and discussion. One thing I have found in my ten years of teaching is that kids love seeing videos about new gadgets and technology related stuff. Show one of these dynamic videos at the beginning of class to grab student attention and promote discussion. Tie the video topic to your particular course of instruction. For example, many of these videos could be used for writing assignments.
1. Speeding up science
2. Facebook "likes" help you pick out dress
3. Finger-link interaction
4. Oculus Rift / UnderCurrent game
6. Touchscreen Tech in the Future
7. Computer repair investigation
11. Work at facebook
12. iPhone stretch
13. Spot connect
14. APP developer
16. G Form case drop
17. Passwords hiding in your body
18. Invisible bike helmet
19. Future of screen technology
20. Leap motion
21. Classroom of Tomorrow
22. Future of Education
These are editable PowerPoint and Word files. The Microsoft Office lessons explore Microsoft Office 2013
If you need Microsoft Office 2010
,or Microsoft Office 2016
email me at firstname.lastname@example.org once you have purchased this bundle and I will send you the Microsoft Office 2010 or 2016 files. Due to the size of the files, all versions could not be added to this download.
Some of the activities are the same for Microsoft Office and Google Drive. If you decide to teach both Office and Google Drive in the same course, you will just need to adjust some of the activities.
You will save over 40% by purchasing this bundle.
Click on the link below for Computers Course - Part 2
Computers Course - Part 2
Purchase of this product is for single classroom use by the purchaser only. It is a violation for individuals, schools, and districts to redistribute, edit, sell, or post this item on the internet or to other individuals.
Created by Gavin Middleton © TeachwithTech
TeachwithTech is not affiliated with any of the companies explored in this bundle
Product names, logos, brands, and other trademarks featured or referred to within this lesson are the property of their respective trademark holders.
These trademark holders are not affiliated with TeachwithTech. They do not sponsor or endorse the contents, materials or processes discussed within this lesson.
Thanks for visiting my store! If you decide to make a purchase, please do not forget to leave feedback. I am very interested to read your thoughts about my products!
Also, don't forget to "FOLLOW" me for exciting new product announcements, sales, promotions and updates!