TECHNOLOGY/BUSINESS CLASSROOM
Technology Classes
6TH GRADE TECHNOLOGY
​​
Google Spreadsheet
-
Lesson 1
-
Define spreadsheet and worksheet.
-
Identify the parts of a worksheet.
-
Open an existing workbook.
-
Rename a workbook.
-
Move the active cell in a worksheet.
-
Select cells and enter data in a worksheet.
-
Edit data in cells.
-
Find and replace data.
-
Preview and print a worksheet.
-
Close a workbook.
-
-
Lesson 2
-
Change column widths and row heights.
-
Position data within a cell by aligning or wrapping.
-
Change the appearance of cells using fonts, font sizes, font styles, colors, and borders.
-
Designate the number format used for data stored in a cell.
-
Use the Paint Format to copy formatting from one cell to another.
-
Clear cells.
-
-
Lesson 3
-
Copy and move data to other cells.
-
Use the drag-and-drop method and Auto Fill options to add data to cells.
-
Insert and delete rows and columns.
-
Freeze panes in a worksheet.
-
-
Lesson 4
-
Enter and edit formulas.
-
Distinguish between relative, absolute, and mixed cell references.
-
Use the point-and-click method to enter formulas.
-
Use the Function button to view summary calculations.
-
Preview a calculation.
-
Display formulas instead of results in the worksheet.
-
-
Lesson 5
-
Identify the parts of a function.
-
Enter formulas with functions.
-
Use functions to solve mathematical problems.
-
Use functions to solve statistical problems.
-
Use functions to solve financial problems.
-
Use logical functions to make decisions with worksheet data.
-
Use functions to insert times and dates in a worksheet.
-
Use text functions to format and work with cell contents.
-
-
Lesson 6
-
Sort data in a worksheet.
-
Use AutoFilter to display only specified data in a worksheet.
-
Apply conditional formatting to highlight data.
-
Hide worksheet columns and rows.
-
Insert a shape in a worksheet.
-
Insert a picture in a worksheet.
-
Use a template to create a new workbook.
-
Insert a hyperlink in a worksheet.
-
Download a workbook in a different file format.
-
Insert, edit, and delete comments.
-
-
Lesson 7
-
Move between worksheets in a workbook.
-
Rename worksheets.
-
Change the color of sheet tabs.
-
Reposition worksheets.
-
Hide and unhide worksheets.
-
Insert and delete worksheets.
-
Create cell references to other worksheets.
-
Print all or part of workbooks.
-
-
Lesson 8
-
Identify the purpose of charting worksheet data.
-
Identify the types of charts you can create.
-
Create a chart embedded in a worksheet.
-
Move a chart to a chart sheet.
-
Update a data source.
-
Select chart elements.
-
Choose a chart layout and style.
-
Create a 3-D chart.
-
Display or hide chart elements.
-
Format and modify a chart.
-
Edit and format chart text.
-
Change the chart type.
-
5TH GRADE TECHNOLOGY
​​
Google Drive
-
Lesson 1
-
Navigate to the Google Drive website
-
Setup a Google Drive account
-
-
Lesson 2
-
Understand the different parts of Google Drive
-
Upload a file into your Google Drive
-
-
Lesson 3
-
Understand and identify how files are shared with you and where to find them
-
Understand what starring a file means and why it is helpful
-
-
Lesson 4
-
Determine where to find starred files as well as recently used files
-
-
Lesson 5
-
Find the details and recent activity for a given file
-
-
Lesson 6
-
Identify the purpose of the trash can and how to permanently delete unwanted files and folders.
-
-
Lesson 7
-
Identify the options within the New button
-
Create folders in your Google Drive
-
-
Lesson 8
-
Upload a file to your Google Drive
-
-
Lesson 9
-
Make copies of files
-
Move files into folders
-
-
Lesson 10
-
Use the Preview option to see a file without opening it
-
Rename a file in Google Drive
-
-
Lesson 11
-
Demonstrate how to share a folder with someone else
-
Change the folder privileges for different viewers
-
Google Document
-
Lesson 1
-
Start Google Document and identify the parts of the opening screen.
-
Enter text in a document.
-
Navigate a document.
-
Use the Backspace and Delete keys to correct errors.
-
Rename a document.
-
Create a folder in which to store your document.
-
Locate and open an existing document.
-
Create a new, blank document.
-
Magnify and reduce the document using the Zoom feature.
-
Use Full Screen Reading view and preview a document.
-
Change the page orientation of a document.
-
Print a document.
-
Sharing and exiting Document.
-
-
Lesson 2
-
Select text.
-
Create paragraphs without blank space between them.
-
Undo, redo, and repeat recent actions.
-
Move and copy text using drag-and-drop and the Clipboard.
-
Use the Clipboard.
-
Find and replace text.
-
Identify the number of words in a document or a selection.
-
-
Lesson 3
-
Change the font.
-
Change the size, color, and style of text.
-
Use different underline and font effects.
-
Copy formatting using the Paint Format.
-
Understand styles and apply Quick Styles.
-
Create new Quick Styles.
-
Clear formatting.
-
-
Lesson 4
-
Set the margins of a document.
-
Align text.
-
Adjust paragraph indents.
-
Adjust line and paragraph spacing.
-
Set and modify tab stops.
-
Create and modify bulleted and numbered lists.
-
Create an outline numbered list.
-
-
Lesson 5
-
Understand objects and how to use them in documents.
-
Insert objects and pictures.
-
Insert, resize, and move inline objects.
-
Change an inline object to a floating object.
-
Recolor graphics.
-
Draw and modify shapes.
-
Add text to drawings.
-
Create callouts.
-
Create and modify SmartArt.
-
Create and modify WordArt.
-
-
Lesson 6
-
Insert page breaks.
-
Understand content controls.
-
Insert and modify headers and footers.
-
Insert page numbers.
-
Modify document details.
-
Use the Research tool.
-
Insert, modify, and format tables.
-
Convert text into tables.
-
Sort text.
-