Google Keep Assignment - Tool to get organized for online learning - tasks per subject

Data Analysis Competencies: Google Sheet

Standard: Input Data, use formulas, create chart, analyze results

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Week 1 – Calculate Age in different planets- Students input the rotational period of the planet around the sun in earth years to calculate how old they will be in various planets, chart the results, interpret the results based on how close the planets are from the sun and the size of the orbital path around the sun

Data Analysis Competencies: Google Sheet

Standard: Input Data, use formulas, create chart, analyze results

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Week 1 – Calculate Age in different planets

Complete all pending jobs for 2nd trimester

Input Competencies: Keyboarding Skills

Skill Level –I (Introduction)

Skills: Reaching out in Keyboarding

Activity: Keyboarding 2nd Trimester

Data Analysis Competency: Spreadsheet Skills

Tool: Google Sheets

Standard: Input Data, Insert Formulas

Skill Level: S (Skill Building)

Activity: Garden Project

Presentation Competency: Multimedia Skills

Tool: Google Slides

Standard: Choose Layout, Create and Format Text, Choose New Slide, New Duplicate Slide, Insert Background:Color, Insert and Format WordArt, Prepare Animation, Insert/Create Button, Adds Hyperlinks to the Buttons

Skill Level: S(Skill Building)

Cross-Curricular Activity: Social Studies/Technology

Create a Jeopardy Game - Week 2

Presentation Competency: Multimedia Skills

Tool: Google Slides

Standard: Choose Layout, Create and Format Text, Choose New Slide, New Duplicate Slide, Insert Background:Color, Insert and Format WordArt, Prepare Animation, Insert/Create Button, Adds Hyperlinks to the Buttons

Skill Level: S(Skill Building)

Cross-Curricular Activity: Social Studies/Technology

Create a Jeopardy Game - Week 1- Students will create a non-linear Google Slide presentation. Students will insert buttons for points and topics for the game, insert slides with answers and questions and hyperlink them to the points that are hyperlinked.

Data Analysis Competency: Spreadsheet (Google Sheet)

Standard: Standard: Explore advanced features of cell formats(borders, shading, text wrap) and write functions using the formula bar(Function Menu)

Skill: S (Skill Building)

Activity: Picture Quiz: Week 1 - Students create an interactive quiz that lets students pick an answer from the drop down list options they create and automatically calculates the total score. Students will learn the syntax of the if function.

Data Analysis Competency: Spreadsheet (Microsoft Excel 2013)

Standard: resize rows and columns, fill color and border cells, merge cells, use multiplication formula, use sum function,average, min and max function, insert image and format the cells for currency

Skill: S (Skill Building)

Activity: Sports Day Spreadsheet - Students design the spreadsheet using the specification provided, and find the average score earned on three matches by the teams and use min and max function to find the winner and the team that lost

Data Analysis Competency: Spreadsheet (Microsoft Excel 2013)

Standard: Spreadsheet Vocabulary, Write Formulas (Add, Subtract, Multiply, Divide, min function, max function, sum function and average function

Skill: S (Skill Building)

Activity: Spreadsheet - Week 2- Students will travel in Hogwarts express, learn and complete the spreadsheet vocabulary, formulas and basic functions activity and finally take the house sorting quiz.

Data Analysis Competency: Spreadsheet (Microsoft Excel 2013)

Standard: resize rows and columns, fill color and border cells, merge cells, use multiplication formula, use sum function, insert image and format the cells for currency

Skill: S (Skill Building)

Activity: Spreadsheet - Week 1 - Students are given a list of items to be purchased for school and they need to design a spreadsheet, input the items and calculate the total cost needed to purchase the items using formulas.

If time practice keyboarding

Competency: Immersive Experiences: (STEM)

Standard: Coding, Robotics

Skill Level: S(Skill Building)

Activity 1: Ozo-Claus - Students code the Ozobot (OzoClaus) to stop and deliver presents to all the houses, avoid Grinch, take a quick break for milk and cookies and return to the North Pole along with Santa before Christmas morning

Data Competency: Spreadsheet (Google Sheet)

Skill: S (Skill Building)

Standard: Input data, Calculate price difference and percent increase using formula

Activity: PNC 12 Days of Christmas Price Index – Students hop aboard an Express and go back in time to find out how much the Christmas items cost in the year 2011 and compare it with the year 2017, design a spreadsheet to input data and enter formulas. If time keyboarding or an hour of code

Monkey Go Thanksgiving

Thanksgiving Dinner

Turkey Liberation

Thanksgiving Games

Complete all typing lessons up to Beginner Review 1 for the First Trimester

Communication Competencies: Word Processing (Google Docs) Standard: Create a new document, insert a table, resize columns, rows, merge cells, insert text in a cell, rotate text

Skill Level: R (Reinforcement)

Activity: Table Activity - 4 - Students create a complicated table, merge columns and rows as per directions, change the fill color of the cells, line color of the table, rotate the text within cells, merge cells and split cells

Communication Competencies: Word Processing (Google Docs)

Skills: Merge cells, format width of border, rotate text, resize rows and columns. Standard: Create a new document, insert a table, resize columns, rows, merge cells, insert text in a cell, rotate text

Skill Level: R (Reinforcement)

Activity: Table Lesson 3 - Students design a table according to specifications, determine the full name of each kids who went to the Halloween party and what costume they wore by reading the scenarios and completing the logic puzzle.

Communication Competencies: Word Processing Skills (Google Docs)

Skills:

• Merge cells

• rotate text

• remove borders

Table Activity 2

Communication Competencies: Word Processing Skills (Google Docs)

Skills:

• Create a table,

• Change table spacing

• Format border and shading

Table Activity 1

Information Input Competency: Keyboarding Skills

Standard: Locate keys, correct finger placements on the keys, Strives for Accuracy, Strives for Speed

Skill: S (Skill Building)

Activity - I Tri Keyboarding Lessons 1 and 2: Students join the online keyboarding classroom using the link provided by the teacher. In this lesson students learn proper keyboarding posture, hand placement and complete beginner lessons 1 and 2 (J, F, Space, U, R, and K keys) with an accuracy of 90% and 20-25 wpm

Presentation Competencies: Multimedia (PowerPoint 2013)

Standard: Insert Sound, Prepare Transitions, Apply Timings, Navigate slides during presentation

Skill: R (Reinforcement)

Activity: Pangaea Animation - Week 4 - Students will find a mp3 background music from the website teacher suggested, download and add it throughout the slides to play during the entire slideshow, animate the continents to demonstrate Pangaea,Add Slide Transition, and record slide timings so that it plays like a movie.

Presentation Competencies: Multimedia (PowerPoint 2013)

Research Competencies: WorldBookOnline

Standards: Insert new slide, Slide Layout, Ctrl+F to search for a keyword

Skill: R (Reinforcement)

Activity: Pangaea Animation - Week 3 - Students describe create legend for the climate and fossil clues, include the clues on each continent and group them ready for animating them next week.

Presentation Competencies: Multimedia (Microsoft PowerPoint)

Standard: Choose new slide, layout, slide style, create and format text, insert background

Skill Level: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Pangaea Animation – Week 2

Tasks:

1. Assign computers

2. Lab Rules

3. Fire Drill Procedures

4. Join Google Classroom with the code provided by teacher

5. Activity - Pangaea - Week 1

Presentation Competencies: Google Slide

Standard: Snipping Tool

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Final Week – Students snip the graph and data for their weight and age in planets and add it to the slides, answer the followup questions and turn in their assignment using Google Classroom

Data Analysis Competencies: Google Sheet

Standard: Input Data, use formulas, create chart, analyze results

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Week 2 – Calculate Weight in different planets- Students input the rotational period of the planet around the sun in earth years to calculate how old they will be in various planets, chart the results, interpret the results based on how close the planets are from the sun and the size of the orbital path around the sun

Data Analysis Competencies: Google Sheet

Standard: Input Data, use formulas, create chart, analyze results

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Week 1 – Calculate Age in different planets- Students input the rotational period of the planet around the sun in earth years to calculate how old they will be in various planets, chart the results, interpret the results based on how close the planets are from the sun and the size of the orbital path around the sun

Creative Communicator: Green Screen

Standard: Student can create a simple video and edits the video with editing tools

Skill: S (Skill Building)

Activity: Green Screen - VSDC Video Editor- Week 3 - Students use the videos they made in front of the green screen and review all the skills to edit it and add ChromaKey and replace it with background of their choice

Terra Nova Testing

Creative Communicator: Green Screen

Standard: Student can create a simple video and edits the video with editing tools

Skill: S (Skill Building)

Activity: Green Screen - VSDC Video Editor- Week 2 - Student open the Green Screen Video they created last week and add opening and closing credits, download the video, attach the file to Google Classroom assignment and turn in.

Creative Communicator: Green Screen

Standard: Student can create a simple video and edits the video with editing tools

Skill: S (Skill Building)

Activity: Green Screen - VSDC Video Editor- Week 1 - This week students learn to create a new project in the editor, import images and premade green screen video, use the chromakey to remove the green background from the video

Investigative Competencies: Research Skills

Standard: Understands rudiments of copyright rules, vocabulary (copyright, fair use, creative commons, public domain)

Skill: S (Skill Building)

Activity: Copyrights and wrongs- Students will be able to identify the legal and ethical considerations involved in using the creative work of others. understand an individual’s rights and responsibilities as a creator and consumer of content.

Investigative Competencies: Research Skills

Standard: Understands rudiments of copyright rules, vocabulary (copyright, fair use, creative commons, public domain)

Skill: S (Skill Building)

Activity: Copyrights and wrongs- Students will be able to identify the legal and ethical considerations involved in using the creative work of others. understand an individual’s rights and responsibilities as a creator and consumer of content.

Data Analysis Competency: Spreadsheet (Microsoft Excel 2013)

Standard: resize rows and columns, fill color and border cells, merge cells, use multiplication formula, use sum function,average, min and max function, insert image and format the cells for currency

Skill: S (Skill Building)

Activity: Sports Day Spreadsheet - Students design the spreadsheet using the specification provided, and find the average score earned on three matches by the teams and use min and max function to find the winner and the team that lost.

If time practice keyboarding

Digital Citizenship Competency: Safety and Ethical Behavior

Standard: Digital Footprint and Identity

Skill: S (Skill Building)

Activity: Digital Drama Activity-Students will be able to:

Reflect on how easily drama can escalate online, Identify de-escalation strategies when dealing with digital drama, Reflect on how digital drama can affect not only ourselves but those around us.

Design Competency: Animation Skills

Standard: Create Frames, manipulate stick figure movements

Skill Level: I (Introduction)

Activity: Pivot Stickfigure Animator - Week 2 - This week students complete the lesson from previous week and create their own animation, convert them into a GIF and upload it to their Classroom and turn in their assignment

Design Competency: Animation Skills

Standard: Create Frames, manipulate stick figure movements

Skill Level: I (Introduction)

Activity: Pivot Stickfigure Animator - Week 1

Competency: Immersive Experiences: (STEM)

Standard: Coding, Robotics

Skill Level: S(Skill Building)

Activity: An Hour of Code-Week 1

Activity 1: Dance Party - Students learn coding concepts to choreograph a dance.

Activity 2: Ozobot Introductory Lesson - Students code to change speed of Ozobot, change directions as well as make special moves

Coding: Scratch Program

Standard: Backdrop, sprite with costumes, insert audio files, musical loop with sound and use of looping command (Repeat)

Skill:S(Skill Building)

Activity: Animal Cell Animation - Week 1 -Students animate labelling the animal cell with audio programming in Scratch

STEM ACTIVITY

This activity is for makey makey

Design Competencies: (PowerPoint 2013)

Standard: Design and save as a PNG image, convert text to audio file

Skills: S (Skill Building)

Activity: Animal Cell Organelles - Students design the cell organelles, put together all parts and complete the animal cell, save each organelle as s transparent image. The png images and audio files will be used to create animal cell animation using Scratch programming next week

Presentation Competencies: Multimedia (PowerPoint 2013)

Standard: Insert Sound, Prepare Transitions, Apply Timings, Navigate slides during presentation

Skill: R (Reinforcement)

Activity: Pangaea Animation - Week 3 - Students add a slide and list the evidences for continental drift, record timings, add sound and finally add the presentation to Google Drive.

Panagea - Week 2 Animations

Last week of computer class

1. Upload the following files from class of 2020 to Google Drive

• • Super Hero Database

  • Pangaea Animation

2. Complete the following three interactive lessons on Digital Citizenship (Website Warrior, Challenge, Stand up or Stand by, Choices and Cheaters )

Competency: Digital Citizenship: Safety and Ethical Behavior

Standard: Digital Footprint

Skills: S(Skill Building)

Activity: Webonauts Academy – In the Webonauts Internet Academy, children play through a series of 12 missions adhering to the Webonauts' motto: "Observe, Respect, Contribute." Each mission helps children understand critical online safety issues, such as the importance of protecting passwords and maintaining privacy settings, credibility of websites, cyberbullying

Presentation Competency: GAFE(Google Slides)

Standard: Insert Video, insert hyperlink

Skill: S (Skill Building)

Activity: Virtual Museum – Week 2

Presentation Competency: GAFE(Google Slides)

Standard: Choose layout, slide style, insert background: Color, patterns, picture, import and format graphics.

Skill: S (Skill Building)

Activity: Virtual Museum – Week 1 – This week students create a three dimensional museum, choose a topic of interest, create 5 wall hangings of their choice, format the museum with floor patterns and ceiling style as well as color the walls

Data Competency: Database Skills

Standard: Query and Report

Skill: S (Skill Building)

Activity: Superhero Database – Week 3 – Students learn to create query and wizard. Based on the questions students fill the criteria or conditions and run the query and generate report.

Data Competency: Database Skills

Standard: Data Types (Text, Number, Date)

Skill: S (Skill Building)

Activity: Super Hero Database – Week 2 – Students create a database and save it to their network folder, include a table by adding fields by choosing appropriate data type, create a form and input data

Data Competency: Database Skills

Standard: Database terms (Database, field, record, file), paper based and computerized database, advantages and disadvantages of the paper / computerized databases

Skill: S (Skill Building)

Activity: What is a database –Lesson 1 – Students read the tutorial explaining the database terms, complete their database activity, turn in assignment, visit the website provided to create a super hero and save it in a folder and name the super hero

Terra Nova Testing

Complete the Planet Newsletter and turn in your assignment through Google Classroom

Data Analysis Competencies: Google Sheet

Standard: Input Data, use formulas, create chart, analyze results

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Week 2 – Weight in different planets and gravitational force.

Data Analysis Competencies: Google Sheet

Standard: Input Data, use formulas, create chart, analyze results

Skill: S (Skill Building)

Cross-Curricular: Science / Technology

Activity: Planet Project – Week 1 – Calculate Age in different planets- Students input the rotational period of the planet around the sun in earth years to calculate how old they will be in various planets, chart the results, interpret the results based on how close the planets are from the sun and the size of the orbital path around the sun

Design Competency: Pivot Animator

Standard: Load background, figure type, create figures, change colors, save animation

Skill: I (Introduction)

Activity: Animate Name – Students learn the techiques of animation which is creating many frames through successive positions of figures to create an illusion of movement, create multiple frames to animate the letters in their name, create background using paint files.

Data Analysis Competency: Google Sheet (GAFE)

Standard: Vlookup function and syntax, use simple formula to multiply, if function syntax

Skill: S (Skill Building)

Activity: Café Project – Week 4 – Students use the vlookup formula they learned last week to automatically populate the prices when the item from the menu is chosen, and generate bill by using the formulas for the total price.

Catholic School's Week

Complete all Pending Jobs

Data Analysis Competency: Google Sheet (GAFE)

Standard: Vlookup function and syntax

Skill: S (Skill Building)

Activity: Complete all pending jobs

Vlookup Exercise - This week students will learn a new function vlookup that will automatically update a cell based on the value chosen on another cell.

Data Analysis Competency: Google Sheet (GAFE)

Standard: Create drop down lists, data validation

Skill: S (Skill Building)

Activity: Café’ –Week 2

Data Analysis Competency: Spreadsheet (Microsoft Excel 2013)

Standard: Formats spreadsheet using borders, shading, text wrap; use merge cells;

Skill: S (Skill Building)

Activity: Café’ –Week 1 - This week students design spreadsheet for taking orders

Communication Competencies: Word Processing Skills (Google Docs)

Standard: Create a table, Merge cells, rotate text, remove borders, Create a table, Change spacing, border and shading

Skills: S (Skill Building)

Activity: Table Maze –Week 1- Students will pick a theme and create a complicated maze to solve by removing borders and make it interesting with dead ends and images.

Communication Competency: Word Processing (Google Docs)

• Choose Double Line Spacing

• Insert Page Numbering

• Insert Headers

Skills: S(Skill Building)

Activity: MLA Format Essay – Students learn to type an essay about Charles Babbage who is the father of computers in MLA format by watching the video directions and complete the assignment in Google Docs and turn in the assignment through Google Classroom