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

New Year's Resolutions 2017 / Digital Line Art Project

Happy New Year to EVERYONE!  Today you will be easing back into the school-day schedule by discussing exactly what New Year's Resolutions are, and why you should try to set and work toward them.  Please review the following presentation from About.com:

https://docs.google.com/presentation/d/1gcr4XX1B6mnvod8kS7PM-I3waorBSE7AHaHjjQdZqi8/edit?usp=sharing

When you have discussed WHAT a New Year's Resolution is, and been given some suggestions about how to create them, please click the next link to POST at 2-3 Resolutions of your own to our Padlet Board for Class:

https://padlet.com/hscribner/2bg34nu4z8vd

You will need to add your initials, P(?), and MP2 to your heading, and then add 2-3 Resolutions you plan to work toward in the coming year.  This board will be public, and you should follow all school rules for internet safety and security.  When you are done, follow the directions below to create a fun drawing using Microsoft Powerpoint or Google Slides.  This will be an introduction to Digital Animation, and help you to create fun mini-videos and other digital art online.  Make sure you upload and share your drawing for credit for today's assignment.

DIGITAL PICTURE (ANIMATION) CREATION PROJECT DIRECTIONS:

Step 1:  Log into Google or Open Microsoft PowerPoint on your Computer

Step 2:  Create NEW Slides Presentation or NEW Presentation in PowerPoint

Step 3:  Use the Drawing Tools to make a stick figure scene.  Make sure to place specific layers in order and use a variety of colors and styles to make it vibrant.

Step 4:  Export you Presentation/Slide as an Image and Upload to Google Drive

Step 5:  SHARE your Image with Mr. S (hscribner@ccs.us) for credit.

Welcome Back!  Good Luck!

- Mr. S 

Movie Marquis Project (MP2)

Have you ever wanted to make a video to post on YouTube, Twitter, or Facebook? With this tutorial, you will be able to add music, transitions and effects to images and video clips in order to make fun videos to share with your friends. You will need to have a Windows computer, and it will helpful to already have a folder with images or video clips, and at least one music file.

WINDOWS MOVIE MAKER TUTORIAL VIDEO

WINDOWS MOVIE MAKER STEP BY STEP PRESENTATION



MR. SCRIBNER'S EXAMPLE - BIG DADDY PRODUCTIONS 2016 

WINDOWS MOVIE MAKER INTRODUCTION

You will be making a number of movies as you get older and create presentations for class, family and friends.  Movie Maker is a free program that allows you to upload, edit, add titles and effects, and then publish a movie to send to people.  The more organized you are, the easier it will be to follow the steps below and use this software. 

Watch the following clip on your own to get an idea of what a Movie Marquis is.  You will then choose pictures, music, and effects to create a Personal Movie Marquis (PMM).  Your PMM is a short movie clip (10-15 seconds) that you will add to the end of any other movie you create. The Movie Marquis you are creating should be a reflection of your personality, and is intended to let people know who created the movie it is shown with.  A PMM can be used at the end or the beginning of a movie.  You should pretend you are creating a Movie Production Studio, and give some thought to the kind of movies and messages you would like to support.  Be creative and have fun with this project.  It can be serious, funny or anything you want it to be.  Please make sure you use the clip you created in Soundation for this project.  You may find pictures and other video clips online.

Movie Introduction Video Clips Promo (Click Here) 

Please create a Personal Movie Marquis in Windows Movie Maker.  It should be 10 to 15 seconds long, and use audio, pictures/video, titles and effects.  You must create your music for this project with Soundation.  You may not use commercially available music.  When you have edited the movie and created it, please use the SAVE Movie Function to save the file and the video to the desktop.  Upload that file to your Google Drive and share it with me for credit for the project.

STEP BY STEP DIRECTIONS 

Step 1:  Download or Create Music with Soundation (You must EXPORT your Music as a .WAV file and place it on the Desktop of your Computer.

Step 1A:  You may need to use AUDACITY (See Windows Computer) to Load and EXPORT your music file from Soundation.  Here is how:

• Choose Saved File from Soundation on Desktop.


• Open Audacity and DRAG your Music File into the Audacity Workspace


• Click FILE and EXPORT as WAV File.  Choose Desktop to save the new file too.  Use New WAV file

Step 2:  Find and Download 1-3 Pictures or Images you are interested in using.  Place those Images on the Desktop of your Computer.

Step 3:  Open Windows Movie Maker and using the FILE Menu click on NEW PROJECT

Step 4:  Name your Project "(Your Last Name) Marquis P(?)" and SAVE it to Desktop.

Step 5:  Use  the CHOOSE PHOTOS/VIDEO BUTTON to select video/image files to use.

Step 6:  Use the CHOOSE MUSIC BUTTON to select the audio file you will use.

Step 7:  Use the pointer to place images and pictures in the proper order for the video.

Step 8:  Use toolbars to enter TITLES and Text.

Step 9:  Use toolbars to add effects and transitions.

Step 10:  Save the final file to the DESKTOP.

Step 11:  Upload and SHARE your Final Movie Project using Google Drive.

DO NOT EMAIL ME YOUR FILE!

YOU MUST UPLOAD IT AND SHARE IT WITH ME FOR CREDIT!   

MR SCRIBNER'S DROPBOX FILE REQUEST LINK

Grading Rubric:

1. Within Time Limit = 15 points


2. Clear Pictures = 15 points


3. Titles = 15 points


4. Appropriate Music = 15 points


5. Effects / Transitions = 15 points


6. GDrive Shared = 15 points


7. Creative (Subjective - Mr. S) = 10 points

Total Score = x/100 points

Here are links to my BIG DADDY PRODUCTIONS 2016 Movies:   (FEB)      (SEP) 

Enjoy!!

- Mr S. 

You could also use this online site to create movies at home:  http://www.kizoa.com/Video-Editor

This is another music file I created in Garageband:

https://drive.google.com/file/d/0BzY9jTFcLEUWcXdzaWYxbUI2bkE/view?usp=sharing

PMM QUALITY RUBRIC

CATEGORY	4	3	2	1
Concept	Student has a clear picture of the message he/she is trying to convey.	Student has a fairly clear picture of the message he/she is trying to convey.	Student has brainstormed his/her message, but no clear focus has emerged.	Student has spent little effort on brainstorming and refining his/her message.
Originality	Presentation shows considerable originality and inventiveness. The content and ideas are presented in a unique and interesting way.	Presentation shows some originality and inventiveness. The content and ideas are presented in an interesting way.	Presentation shows an attempt at originality and inventiveness.	Presentation is a rehash of other people's ideas and/or graphics and shows very little attempt at original thought.
Use of Graphics and Images	All graphics and images are attractive and support the theme/content.	Most graphics and images are attractive and support the theme/content.	Some graphics are attractive but a few do not seem to support the theme/content.	Several graphics are unattractive AND detract from the content.
Digital Camera Use	Pictures are high quality. The main subject is in focus, centered, and of an appropriate size compared to other objects in the picture.	Pictures are good quality. The main subject is not quite in focus, but is it is clear what the picture is about.	Pictures are of marginal quality.The subject is in focus but it is not clear what the picture is about.	No picture taken OR picture of poor quality.
Overall Effectiveness	Project includes all material needed to gain a comfortable understanding of the topic.	Project includes most material needed to gain a comfortable understanding of the topic, but is lacking one or two key elements.	Project is missing more than two key elements.	Project is lacking several key elements and has inaccuracies.

ACADEMIC/LEARNING OBJECTIVE

Students will be able to use Windows Movie Maker to create a short (10-15 second) Movie Marquis (Logo). Students will be given an introduction to Windows Movie Maker today. Before we start with Movie Maker, you will watch a short video about Movie Studio Logo’s. Please complete the Google Classroom Assignment.

Project: Each Student will create a Movie Marquis using Windows Movie Maker. You must be able to save your work, export your Movie, and upload it to your Google Drive. You will then SHARE your file with me for credit. 

YOU NEED YOUR OWN EARBUDS TO WORK ON THIS!