Duplicating Sheets and Sorting Data in Spreadsheets
Today you will start with a single paged spreadsheet file and sort the data four different ways on four different pages. The video below will show you how to complete these steps.
Open Google Classroom. Look for the "Sorting Data in Spreadsheets" assignment on the stream. Open the file named "Planets."
There will be one spreadsheet with five columns of data related to the eight planets in our solar system (Sorry, Pluto.).
Click the arrow on the sheet tab at the bottom.
Click "Duplicate." A new copy of the sheet will appear.
Click and drag over all the cells in this spreadsheet.
Click the "Data" menu. Click on "Sort Range..." A "Sort range" dialogue box will appear.
Check the box in front of "Data has a header row."
Change "Sort by" to "Diameter."
Click the "Sort" button.
Click the arrow on the sheet tab. Rename the sheet "By Diameter."
Click the arrow on the sheet tab at the bottom.
Click "Duplicate." A new copy of the sheet will appear.
Click and drag over all the cells in this spreadsheet.
Click the "Data" menu. Click on "Sort Range..." A "Sort range" dialogue box will appear.
Check the box in front of "Data has a header row."
Change "Sort by" to "Rotation."
Click the "Sort" button.
Click the arrow on the sheet tab. Rename the sheet "By Rotation."
Click the arrow on the sheet tab at the bottom.
Click "Duplicate." A new copy of the sheet will appear.
Click and drag over all the cells in this spreadsheet.
Click the "Data" menu. Click on "Sort Range..." A "Sort range" dialogue box will appear.
Check the box in front of "Data has a header row."
Change "Sort by" to "Revolution."
Click the "Sort" button.
Click the arrow on the sheet tab. Rename the sheet "By Revolution."
Keyboard Practice Site We are working regular keyboarding practice into our routine for all grade levels. With more technology being used in our classrooms, keyboarding speed is going to be an essential skill for students to complete their homework in a timely manner. Clicking on the logo below will bring you to the tutorial site we are using. Students can log in and practice there.
Second Quarter Keyboarding Second quarter we will have a weekly keyboarding assignment as homework. Each week (Saturday - following Friday) students are expected to practice keyboarding using the Typing.com courses for 20 minutes per week. Minutes above 20 each week will count as extra credit or to make up for weeks you did not complete the full 15-minute requirement. Students will only be able to earn up to 40 extra credit points per quarter, so the second quarter maximum is 160 points. This will need to be completed outside of class unless you are finished with the current in-class project. The weekly schedule will be as follows:
October 24 - 30: 20 minutes
October 31 - November 6: 20 minutes
November 7 - 13: 20 minutes
November 14 - 20: 20 minutes
November 21 - December 4: 20 minutes (two weeks because of Thanksgiving)
December 5 - 11: 20 minutes
December 12 - 18: Extra Credit / Make-up Week
We will also have two speed checks in class throughout the quarter. Speed checks will be on November 13 and December 11. You will be graded on the following 10-point scale based on your personal improvement. Improvement is based on net speed. Net speed is calculated by multiplying your gross speed by your accuracy percentage.
20% Improvement = 10 Points
10% Improvement = 9 Points
1 - 9% improvement = 8 points
No improvement = 7 points
Decrease in speed = 6 points
Spare Time Activities When you are completely finished with an assignment before the end of class, you are allo wed to work on an approved activity will waiting for your classmates. The first choice is always to work on homework from other classes or reading for AR. If you do not have that available, you can use one of the links below.