This Remote Learning Plan was created by Melissa Dux in collaboration with Andrew Easton as part of the 2020 ESU-NDE Remote Learning Plan Project. Educators worked with coaches to create Remote Learning Plans as a result of the COVID-19 pandemic.The attached Remote Learning Plan is designed for 9-12 CIS Information Technology students. Students will create a spreadsheet with data to calculate total, average, max, and min functions. This Remote Learning Plan addresses the following NDE Standard: CIS.HS.4a.4.b Sort data, manipulate data using formulas and functions.It is expected that this Remote Learning Plan will take students one hour to complete.Here is the direct link to the Google Doc:  https://docs.google.com/presentation/d/1fvmEAdP7Ad8DAe8QM0FzZltSB4VXkUjRbvBOOxrX7K8/edit?usp=sharing

Students will learn how to distinguish different video shots, angles, and movements by watching a professionally created movie trailer. Locate a movie trailer of your choice and convert it into a movie file that can be uploaded into a video editing software, such as iMovie. Students will then detach the audio so it is not a distraction while working during class. The next step will be to locate the different camera uses, angles, and movements as listed in the PowerPoint. Once the shots are located, students will split the video and use a freeze frame with on-screen text to key the name of the shot. An example would be "long shot with bird's eye view." Students should locate at least three examples for each of the camera uses, angles, and movements. Once done, the students will export their movie and submit for grading.

This lesson uses a small snack to review spreadsheet tasks. It is typically enjoyable and memorable because the students get to eat as part of this lesson.

The goal of this lesson is for students to test concepts they have already worked with; creating formulas and functions in a worksheet, and formatting for money. The assessment is a production work where students look at the candy bar sales from each class. It requires them to put in functions like minimum, maximum, totals, and figure revenue.  There is also an additional activity for review of revenue, formatting currency, and totals prior to the production test, if needed. 

The goal of this lesson is for students to work with borders and basic formatting in a spreadsheet program so that it is useful and pleasing to the eye. This lesson encourages creativity with a maze creation and also collaboration in a shared spreadsheet that students then copy and format to make it pleasing to the eye.  It also offers students the chance to look at others’ creations and give feedback.

The goal of this lesson is for students to work with conditional formatting in a spreadsheet program. Conditional formatting is a useful tool in spreadsheets, and this allows students to see three applications of it, including using it on their own grades. It also reviews functions and formatting concepts of spreadsheets.

This resource was created by Janelle Seagren, in collaboration with Dawn DeTurk, Hannah Blomstedt, and Julie Albrecht, as part of ESU2's Integrating the Arts project. This project is a four year initiative focused on integrating arts into the core curriculum through teacher education, practice, and coaching.

Students will correctly key specific documents that have previously been taught by using a simulation provided from a Computer Applications and Keyboarding textbook. This lesson is not specific to a particular textbook, however, the example provided is from the Century 21 Computer Applications and Keyboarding Textbook, 8th edition. Simulations give students a real-world practice and by adding project management techniques, students can practice working together to complete a long assignment. The class should be divided into teams of 3-4 students. They will choose a group leader and then complete the person responsible column on the provided pdf handout. Students should assess the qualities that each bring to the table and use that to their advantage. Once this has been done, they should decide on the due date for each job and list the date in the completed column and, finally, who will be editing/proofreading the document before the group leader submits for grading. Students are allowed to use their notes and the FBLA format guide, which can be found on the FBLA-PBL.org website, for this project.