TF Digital Tech Literacy: Spreadsheet Basics: Introduction to Google Sheets/Excel

Introduction

Digital Literacy Class: We are going to learn about so many incredible ways to be creative, collaborative, and to communicate. We will focus on computer skills and applications. Some topics you already know about, and you will know better, and other topics and applications will be new to you! Either way, we will work together to find the ones you are able to use best. This class consists of Project-Based-Learning. You will be given plenty of time to learn the skills and applications that you will use for a lifetime. I hope you enjoy the material we will cover. - Mr. S

Thursday, January 5, 2017

Spreadsheet Basics: Introduction to Google Sheets/Excel

This is your Introduction to Google Sheets (MS Excel). Please pay close attention during the class presentation (Click Here to Download Presentation at Home). You will be creating a number of spreadsheets over the next few days. It is important that you learn to navigate around the spreadsheet as easily as you do in Google Documents (MS Word). You will find that most of the RIBBON items are similar and that you can find out how to do things without my help by using the HELP Button.

SPREADSHEET BASICS WORKSHEET #1

We will be using MS Excel (Google Spreadsheets) to perform Basic Math, create Employee Timecards, Payroll Worksheets, a Family Monthly Budget, and much more!

Use this link for more information and helpful practice templates: MS EXCEL PAGE

Are You Really LOST? Click Here to access GOOGLE SHEETS TRAINING PAGE

ADDITIONAL EXCEL BASICS PRACTICE WORKSHEET

Finally, you will be using templates that are built-in to the Google Slides program. I will add different requirements as we progress. Good Luck!!

- Mr. S

ACADEMIC/LEARNING OBJECTIVE

Students will learn to use electronic spreadsheets for basic calculations, data storage and evaluation, and other tasks. Students will complete basic spreadsheet tasks, simple functions, and basic formatting. Students will be able to create, work with, collaborate on and share spreadsheets for classwork and basic applications

STUDENTS MUST START BY READING ALL DIRECTIONS ON CLASS WEBSITE!

Students will view instructional videos in class, followed by practical lessons. Students will create, work with, store, and collaborate on basic spreadsheets using Google Sheets. Students will be introduced to basic math, functions, formatting and organizational features of the spreadsheets.

READ ALL DIRECTIONS CAREFULLY!

THANK YOU FOR YOUR ATTENTION AND POSITIVE ATTITUDE TODAY!

Standards Covered In This Class

PA 3.7.7 & 11 Section C / ISTE 2011

CSTA Tied With Common Core ELA/Math rev. 2011

No comments:

Overall Academic Class Standards

SELF-ASSESSMENTS

Student Self-Assessments refer to training students to evaluate themselves, and their work, for the purpose of improving outcomes. To become capable evaluators of their work, students must have:

- a clear target (goal)

- the opportunity to help create definitions of the quality of work.

- the opportunity to correct, or self-adjust, their work before turning it in.

Students are also prompted to reflect and evaluate strengths, weaknesses, and areas of improvement. These skills will allow for planning, improvement, goal-setting, and reflection. Emphasis will be placed on integration of previous learning across the school curriculum.

ISTE 2. Communication and Collaboration

Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others:

a. Interact, collaborate, and publish with peers, experts, or others employing a variety of digital environments and media

b. Communicate information and ideas effectively to multiple audiences using a variety of media and formats

3. Research and Information Fluency

Students apply digital tools to gather, evaluate, and use information:

a. Plan strategies to guide inquiry

b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media

General Computer-Based / Project Based Classroom Standards Met:

PA Common Core 8.5.6-8G: Integrate visual information (e.G. charts, graphs, maps, video, etc.) with other information in print or digital format.

ISTE 3.3A: Students plan and employ effective research strategies to locate information, and other resources, for intellectual and other pursuits.

ISTE 3.3D: Students build knowledge by actively exploring real world issues and problems, developing ideas, and pursuing answers and solutions.

CSTA Collaboration 1: Apply productivity/multimedia tools, and peripherals, to a group collaboration and support learning throughout the curriculum.

CSTA CPP1: Use advanced tools to create digital artifacts.

PA CEW Standards Met

PA 13.1.8A Career Awareness and Preparation

Relate careers to individual interest, abilities, and aptitudes.

PA 13.1.8G Create an individualized career plan including, but not limited to Assessments, Career Goals, individual interests and abilities, and Training/Education requirements.

TF Digital Tech Literacy

Introduction

Thursday, January 5, 2017

Spreadsheet Basics: Introduction to Google Sheets/Excel

No comments:

Post a Comment

Dragons Breathe Fire

Report Abuse