€¦ · web viewa major emphasis will be placed on google drive, gmail, docs, sheets and slides....

District Overview:Living in the 21st century, we are immersed in a technology and media-suffused environment, marked by various characteristics, including: 1) access to an abundance of information, 2) rapid changes in technology tools, and 3) the ability to collaborate and make individual contributions on an unprecedented scale. To be effective in the 21st century, citizens and workers must be able to exhibit a range of functional and critical thinking skills related to information, media and technology. The BHASD Business and Technology Department offers students opportunities to think critically, be creative, collaborate with others, communicate ideas, demonstrate adaptability, take on leadership roles, practice social responsibility, and apply informational, media and technology literacy. The use of these skills in combination with curricular goals are intended to enable students to grow with the lightning-pace of today’s ever changing global society.

Course Description:This course will allow students to obtain the skills necessary to obtain a G Suite Certification. Current trends in business technology will be explored as well as various computer software program skills that can be used throughout a student’s high school and post high school career. A major emphasis will be placed on Google Drive, Gmail, Docs, Sheets and Slides.

Students who obtain the Google Cloud certification in G Suite demonstrate to prospective employers and colleges that they have a mastery of G Suite applications and the ability to complete common workplace activities using cloud-based tools to create and share documents, spreadsheets, presentations, and files. They also show prospective employers and colleges that they are fluent in digital collaboration tools.

Units: Unit 1: Google Drive Unit 2: Gmail Unit 3: Google Hangouts Meet Unit 4: Google Docs Unit 5: Google Sheets Unit 6: Google Slides Unit 7: Business Technology Trends

Subject: Technology for Today and Tomorrow Grade: 9-12 Suggested Timeline: 5 days

Unit Title: Google Drive

Unit Overview/Essential Understanding: Students will learn the tools necessary to navigate through Google Drive, which is a cloud-based file storage service that allows students to manage, organize, edit, and share files. Instead of being stored on a computer, Google Drive files are stored in the Cloud which can be easily accessed from any computer, smartphone, or tablet with Internet access.

Students will learn how to utilize Google Drive to organize, share and locate folders, documents and files securely. Students will develop a working understanding of downloading and uploading documents, sharing content and Gmail.

Completing this unit on Google Drive will help prepare students for the G Suite Certification Exam.

Essential Questions: What are the benefits of utilizing Google Drive? How do you manage files so they are easily located in Google Drive? What are the benefits of creating and managing folders in Google Drive? How do you change the display and settings in Google Drive? What are the benefits of sharing files and folders? How do you locate files in Google Drive?

Unit Objectives: Students will be able to:

Manage files Create and manage folders Change display and settings Share files and folders Locate files

Focus Standards Addressed in this Unit: NSBE.VII.L1.A - Identify and use applications appropriate for specific tasks to improve academic achievement across the curriculum NSBE.VII.L1.C - Produce projects that include a variety of media BCIT 15.4.12.A - Apply the creative and productive use of emerging technologies for educational and personal success

Important Standards Addressed in this Unit: NSBE.VII.L2.D - Compare and contrast applications features NSBE.VII.L3.D - Evaluate the effectiveness of applications to solve specific problems NSBE.VII.L3.H - Demonstrate the transferability of skills between applications

Misconceptions: Students accustom to local / network files may struggle with the concept of cloud storage.

Concepts/Content: Manage files Copy and delete files Upload files Download files Create folders Manage folders Move, rename and delete folders Upload folders Change display and settings Adjust item view Access items offline Restore files Access activity updates Share files and folders Adjust permissions Share files with others

Competencies/Skills: Open files from the student’s drive

folder on the desktop or browser Open files created with Google Docs Upload, download and access files

from a desktop, phone or tablet View and update files as well as

restore deleted files Organize, create, move and search

for files and folders Adjust item views, access items

offline, and see activity updates Share and collaborate with other

users Adjust permissions and publish items

to the Web Find files using recent, shared with

Description of Activities:

Teacher guided instruction of Google Drive features such as creating and managing folders, uploading/downloading files, etc.

Exercises and activities from textbooks and online resources that could include file management exercises

Exercises and activities created by the instructor such as organizing, managing and sharing files

Publish items to the Web Locate files Use recent, shared with me and

search to find files

me and search

Assessments: Formative and summative assessments to assess understanding Assessments may include quizzes, practical tests, assignments or projects Culminating G Suite Certification Exam

Interdisciplinary Connections: Cloud based skills that can be used in other classes as well as

outside the classroom

Additional Resources: Google website and account access District approved materials Teacher created resources District approved online resources Google for Education Website

Subject: Technology for Today and Tomorrow Grade: 9-12

Suggested Timeline: 10 days

Unit Title: Gmail

Unit Overview/Essential Understanding: Students will gain an understanding of using Gmail, which is Google’s cloud-based email program that allows the students to send and receive messages. The students will also learn how to personalize settings, chat with contacts, share files and images, and search an inbox.

Completing this unit on Gmail will help prepare students for the G Suite Certification Exam which will demonstrate their ability to work collaboratively and productively in a professional environment.

Essential Questions: What is Gmail and how does it differ from other email programs? How do you personalize Gmail for optimal performance? What is the best way to reply and forward emails? How are you able to use the chat and video features of Gmail to communicate with others?


Manage an inbox and communicate with others in Gmail Personalize Gmail settings Reply and forward emails Use chat and video to talk to contacts Understand terminology associated with Gmail



Misconceptions: Students who are familiar with other email programs may have trouble transferring knowledge.

Concepts/Content: Set languages Display preferences Vacation responders Desktop notifications Compose an email Share email files Share email images Use reply and forward options Add users in cc and bcc Launch text chats Launch video calls Use filters Block Addresses Archive and mute messages Enable multiple inboxes Use search and sort to see

drafted and sent messages Enable offline access

Competencies/Skills: Personalize settings Email contacts Reply to email and email

forwarding Use chat and video options Manage inbox Locate messages Use Gmail offline

Description of Activities: Teacher guided instruction such as launching

text chats and video calls, using filters, etc. Exercises and activities from textbooks and

online resources that could include managing inbox and communicating with others

Exercises and activities created by the instructor such as locating messages and personalizing settings


Interdisciplinary Connections: Cloud based skills that can be used in other classes as well

as outside the classroom



Unit Title: Google Hangouts Meet

Unit Overview/Essential Understanding: Students will learn about Google Hangouts, which is an online meeting tool for voice and video conversations. This app will allow students to keep in touch with friends, family, or coworkers who are far away from them. Hangouts will also allow students to talk with people in different locations at the same time and meet with them virtually. Students will become familiar with scheduling a Hangout Present as well as managing sound, video and bandwidth.

Completing this unit on Google Hangouts Meet will help prepare students for the G Suite Certification Exam, which will demonstrate their ability to work collaboratively and productively in a professional environment.

Essential Questions: What is Google Hangouts? How do you schedule a meeting in Google Hangouts? How do you manage image and voice quality in Google Hangouts? How do you manage meetings in Google Hangout?


Utilize the basic tools and functions in Hangouts Meet Manage and schedule meetings in Google Hangout Change and manage sound and image in Google Hangouts


Important Standards Addressed in this Unit:

NSBE.VII.L2.D - Compare and contrast applications features NSBE.VII.L3.D - Evaluate the effectiveness of applications to solve specific problems NSBE.VII.L3.H - Demonstrate the transferability of skills between applications

Misconceptions: Students will have trouble adjusting to features like sound control, screen share, etc. because it is different from programs they are used

to using like FaceTime and Skype.

Concepts/Content: Open a Hangout Schedule a Hangout from a calendar Launch a Hangout Share a screen Share a single window Manage sound Manage video quality Use dial ins Invite more users Use chat Mute or eject other users

Competencies/Skills: Schedule and open a Hangout Present their screen Manage sound and video Manage meetings in Hangout

Description of Activities: Teacher guided instruction of Google

Hangout features such as launching a hangout, sharing a screen, etc.

Exercises and activities from textbooks and online resources that could include video conferencing and effective communication utilizing Hangouts

Exercises and activities created by the instructor such as collaborating and communicating with Google Hangouts




Additional Resources: Google website and account access District approved materials Teacher created resources District approved online resources

Google for Education Website


Unit Title: Google Docs

Unit Overview/Essential Understanding: Students will learn the features of Google Docs, which is an online word processor that allows students to create and edit documents from any web-enabled device. Whether it’s collaboration, modification, or cross-platform compatibility, Google Docs is a powerful tool that today’s students need to know how to utilize to create documents.

Completing this unit on Google Docs will help prepare students for the G Suite Certification Exam which will demonstrate their ability to work collaboratively and productively in a professional environment.

Essential Questions: How do you create a document in Google Docs? How do you format a documents with varying formatting styles in Google Docs? How do you create and format tables in Google Docs? How do you share and collaborate in Google Docs?


Set up and format a document in Google Docs Format text blocks Set paragraph styles Change fonts and styles Insert images and links Insert and format tables Add elements, format and edit text, and share with others in Google Docs Use tools to edit and review document text Share and collaborate on documents



Misconceptions: Students who are familiar with other word processing programs may have trouble finding certain features and transferring knowledge.

Concepts/Content: Page size and orientation Page color Headers and footers Page Numbers Align text Adjust line spacing Adjust paragraph spacing Use numbered or bulleted lists Table of contents Font – size, color, highlight Bold, Italic, Underline formats Add images and external links In-Doc links Bookmarks Create and delete tables, rows

and columns Manage table properties

Competencies/Skills: Set up a document Choose page size, orientation and

color Format headers, footers and page

numbers Align text, adjust line and

paragraph spacing, and use a numbered or bulleted list

Use headings to create a table of contents

Choose a font, set the size, color, and highlight, and add bold, italic or underline formats

Set paragraph styles Change fonts and styles Collaborate and share documents Add images, external links, in-doc

Description of Activities: Teacher guided instruction such as formatting

documents in Google Docs Exercises and activities from textbooks and

online resources that could include adding elements, formatting and editing text in Google Docs

Exercises and activities created by the instructor such as sharing Google Docs with others, “Creating a Topic” assignment, etc.

Check spelling Add words to a personal

dictionary Comment, edit and suggesting

modes Revision history Download formats Sharing and collaborating on files

links and bookmarks Create and delete tables, rows,

and columns, and manage table properties

Use comment, edit and suggesting modes to collaborate and view revision history

Download files in different formats





Subject: Technology for Today and Tomorrow Grade: 9-12

Suggested Timeline: 20 days

Unit Title: Google Sheets

Unit Overview/Essential Understanding: Students will learn to build, organize, and format spreadsheets. They will also analyze and interpret data with different filters, functions and charts as well as learn to use advanced functions and conditional formatting.

Completing this unit on Google Sheets will help prepare students for the G Suite Certification Exam which will demonstrate their ability to work collaboratively and productively in a professional environment.

Essential Questions: What are the uses of spreadsheets? How can material be organized and presented in a spreadsheet? How does Google Sheets allow you to analyze data? What are functions and how are they used in Google Sheets? How do you format a Google Sheets worksheet?


Duplicate a sheet and add new data Format and organize spreadsheet data Sort data Use filters to count, add, and summarize data in a table Analyze data using filters, functions, and charts Manage and maximize data

Share and collaborate sheets Copy sheets into a spreadsheet Use functions to calculate, summarize and analyze data




Concepts/Content: Duplicate and add sheets Add data Delete data Insert data Format spreadsheet data Organize spreadsheet data Merge cells Set alignment Format dates Freeze cells, columns, and rows Add borders and set fill colors Change fonts and sizes Add data validation Name and sort sheets Name ranges Create filters COUNT and SUM function

Competencies/Skills: Add, delete and insert data Use bold and italics, merge cells, set

alignment, and format dates Freeze cells, columns, and rows, add

borders, set fill color, add borders, and change fonts and sizes

Data validation to limit options Create filters and use filter views Use sheets and COUNT Use the SUM function to analyze data Create, insert, and modify charts, and

protect sheets and ranges Use COUNTIF to generate numeric

data with text values Calculate and emphasize cost,

revenue, and profit for a company Add comments, view revision history,

Description of Activities: Teacher guided instruction such as editing,

organizing and analyzing data in Google Sheets, creating formulas, etc.

Exercises and activities from textbooks and online resources such as creating a study schedule, organizing a club, etc.

Exercises and activities created by the instructor such as using filters, functions and charts in Sheets, managing and maximizing data in Sheets, etc.

Create, insert, and modify charts Protect sheets and ranges COUNTIF Add comments View revision history Download spreadsheets as file

types Copy from .csv and .xls file types Format currency View function list Calculate and summarize data MIN, MAX, and AVERAGE

functions Conditional formatting Insert links, images, forms, and

drawings

and download spreadsheets as file types

Use functions to calculate cost and current sales

Use functions to summarize and analyze data

Use functions to summarize data and calculate profit

Use the MIN, MAX, and AVERAGE functions to analyze sales data

Add conditional formatting to emphasize data

Insert links, images, forms and drawings


Interdisciplinary Connections: Cloud based skills that can be used in other classes as well




Unit Title: Google Slides

Unit Overview/Essential Understanding: In this unit students will create a dynamic presentation with themes, text, and transitions. They will learn how to add photos, images, videos, and shapes to a Google Slides presentation. Students will also grow their presentation skills by adding tables, diagrams, and charts to a presentation as well as know how to share the presentation with others.

Completing this unit on Google Slides will help prepare students for the G Suite Certification Exam which will demonstrate their ability to work collaboratively and productively in a professional environment.

Essential Questions: How do you create a presentation in Google Slides? How do you add media to enhance a presentation in Google Slides? Why types of animation and transitions can be added to create a presentation in Google Slides?


Build a presentation in Slides utilizing basic components Word with text in Slides Add media to a presentation in Slides Work with lines and shapes Add data such as diagrams and charts to slides and share a presentation


Important Standards Addressed in this Unit:

NSBE.VII.L2.D - Compare and contrast applications features NSBE.VII.L3.D - Evaluate the effectiveness of applications to solve specific problems NSBE.VII.L3.H - Demonstrate the transferability of skills between applications


Concepts/Content: Add, copy, paste, and delete

slides Apply themes and layouts Add page numbers Use presenter notes Link slides Copy, past, and link slides Change destination formatting Insert text blocks Change font and font color Change size, style, and format Add highlight color Set capitalization Transitions Animations Preview mode Add images Align using snap-to guides Resize Insert and edit videos Insert, edit, group, and arrange

lines and shapes Insert and edit tables Insert, edit, and align diagrams

Competencies/Skills: Build a presentation by adding,

copying, pasting and deleting slides as well as applying themes and layouts

Work with text by inserting text blocks, changing font and font color, size, style and format

Add transitions and animations and watch in preview

Insert and edit images by adding images, align using snap-to-guides and resizing

Insert and edit videos Insert, edit, group, and arrange

lines and shapes Insert and edit tables Insert, edit, and align diagrams Insert and edit charts from

spreadsheet data Enter presenter view, access print

settings, and publish to the web

Description of Activities: Teacher guided instruction such as basic

components of creating a presentation in Slides Exercises and activities from textbooks and

online resources that could include creating a scrapbook, designing and sharing a digital badge

Exercises and activities created by the instructor such as adding media to presentations, adding data to and sharing a presentation in Slides

Insert and edit charts from spreadsheet data

Presenter view Access print settings Publish to the web






Unit Title: Business Technology Trends

Unit Overview/Essential Understanding: In the last ten years, advancements in technology have disrupted societal norms. Corporations, business models, and markets have had to adjust their ways of operation in order to keep succeeding. From the cloud to augmented reality, these now familiar forces are no longer simply trends in the public’s eye. Finding a way to harness innovation while maintaining security and safety remains a challenge. In this unit, students will explore current trends in business technology. Topics that may be explored could range from how 5G could increase network speeds to cloud capacity and social media influences and trends. Students will be exposed to what is “trending” in technology and will be able to explore and learn about how technology is constantly evolving.

Essential Questions: What are current trends in business technology? How are these current trends influencing business today? How can we sense and act upon the future that remains unclear?


Research and explain current trends in business technology



Concepts/Content: Internet research Website evaluation Credible sources Multimedia presentation Presentation skills Vocabulary

o Artificial Intelligenceo Intelligent interfaceso Experiential marketingo Virtual Realityo Augmented Realityo Internet of Thingso 5G Network

Competencies/Skills: Distinguish between valid

internet sources Determine an application to

compose a presentation Present using a multi-media

application demonstrating skills related to future purpose

Description of Activities: Teacher guided instruction of current trends in

business/technology Students research of current trends in

business/technology

Assessments: Formative and summative assessments to assess understanding Assessments may include quizzes, practical tests, assignments or projects

Interdisciplinary Connections: Knowledge and skills that can be used in other classes as well


Additional Resources: District approved materials Teacher created resources District approved online resources

€¦ · web viewa major emphasis will be placed on google drive, gmail, docs, sheets and slides....

Documents