TF Digital Tech Literacy: Excel Practice Day

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

Monday, April 28, 2014

Excel Practice Day

Practice Creating the following tables in MS Excel today:

The first is a grade log. Make sure you use the AVERAGE function to show the average scores for your grades at the bottom of the spreadsheet. You must also type the instructions in the cells below as pictured:

The next table you will create is the Exercise table. Please fill in all the data exactly as it is pictured:

Format the table just like the picture to the right:

Finally, you must create the table for the products listed here:

Good Luck!

Mr. S

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

Monday, April 28, 2014

Excel Practice Day

No comments:

Post a Comment

Dragons Breathe Fire

Report Abuse