Nebraska Communications & Information Systems

34 affiliated resources

Search Resources

View
Selected filters:
Beginning Excel
Unrestricted Use
CC BY
Rating

This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before.

Subject:
Career and Technical Education
Material Type:
Textbook
Provider:
OpenOregon
Author:
Barbara Lave
Diane Shingledecker
Julie Romey
Mary Schatz
Noreen Brown
Date Added:
01/01/2017
Remix
Communicating in A Big Way - Digital Design Using Wide Format Printing
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Communication is key in our daily lives. We need to have access to what is on our calendar – the school calendar. And yes, it’s great to have it electronically, but when there is a large group of people checking dates for an event it’s nice to have a large format for at-a-glance information. In this lesson, students will learn to create a large format 18” x 24” calendar file that could be printed and posted in a classroom to use for reference to upcoming events for the month. In our small community it has also become a public relations tool for our school and several are posted in businesses throughout our school district. Using the picture file format of the design, the calendar is also shared electronically each month for smaller print format in the community newsletter and online access.

Subject:
Business and Communication
Communication
Graphic Design
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Lisa Fox
Date Added:
08/08/2019
Remix
Computer Applications - Spreadsheets
Conditional Remix & Share Permitted
CC BY-NC
Rating

This template is meant to be a guide for Nebraska Career Education Teachers in the Business, Marketing, and Management Career Field when creating digital online lessons. Headings and/or topics not included in the lesson plan should be marked N/A.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Dorann Avey
Date Added:
08/09/2019
Remix
Computer Applications - Spreadsheets
Conditional Remix & Share Permitted
CC BY-NC
Rating

This template is meant to be a guide for Nebraska Career Education Teachers in the Business, Marketing, and Management Career Field when creating digital online lessons. Headings and/or topics not included in the lesson plan should be marked N/A.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Delayne Havlovic
Date Added:
08/08/2019
Create a Website
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

These days, tools exist so that anybody can build a website, but that doesn't mean anyone will want to visit it. This workshop will get you hands-on experience with the underlying code it takes to develop a website (HTML & CSS) as well as website design considerations. The culmination of this workshop will be the launch of your own website!Learning Objectives:Insert hyperlinks into a web pageEmbed multimedia content into a web pageIdentify & use HTML tags to add content to a web pageIdentify & use CSS tags to change the style and layout of a web pageIdentify & use openly-licensed workIterate on a design after feedback from target audienceIdentify different parts of a web page using industry-recognized termsIdentify & use JavaScript to add interactivity to a web pageThe Web Literacy Map identifies competencies and skills that the Mozilla community believes are important to pay attention to when getting better at reading, writing and participating on the web. This lesson is primarily focused on the Write strand.

Subject:
Computer Science
Material Type:
Lesson Plan
Author:
Kim Wilkens
Date Added:
03/06/2018
Remix
Create a flyer with a table using Microsoft Word
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This template is meant to be a guide for Nebraska Career Education Teachers in the Business, Marketing, and Management Career Field when creating digital online lessons. Headings and/or topics not included in the lesson plan should be marked N/A.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Jodi Dierks
Date Added:
08/08/2019
Remix
Creating a Flyer using Microsoft Word
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This template is meant to be a guide for Nebraska Career Education Teachers in the Business, Marketing, and Management Career Field when creating digital online lessons. Headings and/or topics not included in the lesson plan should be marked N/A.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Jodi Dierks
Date Added:
08/08/2019
Remix
Creating a table using Microsoft Word
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This template is meant to be a guide for Nebraska Career Education Teachers in the Business, Marketing, and Management Career Field when creating digital online lessons. Headings and/or topics not included in the lesson plan should be marked N/A.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Jodi Dierks
Date Added:
08/08/2019
Remix
Digital Media:  Learn to Use Audacity to Create Audio Recordings
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Audio recording is an important component of digital media productions. In this lesson students will make a short recording to learn the basics of Audacity, a free and open-source digital audio editor and recording application software, available for Windows, macOS/OS X and Unix-like operating systems.

Subject:
Communication
Career and Technical Education
Film and Music Production
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Lisa Fox
Date Added:
08/08/2019
Digital photography instructional videos
Unrestricted Use
CC BY
Rating

Playlist of digital photography tutorials on advanced photographic techniques relating but not limited to comprehension and execution of visual communication through photography, camera use techniques, studio and natural lighting techniques, pre-production, post-production and digital editing.

Subject:
Visual Arts
Material Type:
Lesson
Author:
Michelle Marusek
Date Added:
07/09/2019
Remix
Foley Art:  The Art of Making Sounds
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Students will learn how to produce their own sounds to add to their video projects. This technique is called Foley Art. There are several excellent videos that can be shown during class or assigned as a flipped assignment. Either way, these videos should draw great discussion during class on how to capture homemade produced sounds. Some of the videos I use come from YouTube and are titled "The Magic of Making Sound," "This Artist Creates Sounds for Movies," "How the Sound Effects in 'A Quiet Place' Were Made," "Foley Artists: How Movie Sound effects are Made," and "The Hunger Games & Frozen Foley Artists Turn the Sound of Junk into Miracles--Art of Sound Ep. 3." Simply do a search for Foley Art. After the discussion, students will then select a movie trailer, convert the trailer into a file format that works with their video editing software. Once the file is uploaded into their software, students will remove/detach the audio and begin brainstorming appropriate sound effects and how these can be made for the video. Students should compile a list of at least 10 sound effects. After all students have their lists, divided the students into groups. I find that it is necessary to have more than one person in order to effectively produce the sounds. Once students are in their groups, combine their lists, and come up with 10 sounds they think they can personally produce. Students will need to brainstorm props that can be used to produce their sounds. Once the sounds have been created, each student will then add, trim, and edit the sounds and add to the movie trailer.

After the last day of editing, the students will come back together with their group and show their video to the class. Students should explain how sounds were created.

Subject:
Performing Arts
Visual Arts
Film and Music Production
Education
Material Type:
Activity/Lab
Homework/Assignment
Lesson
Lesson Plan
Author:
Dawn Friedrich
Date Added:
08/08/2019
Graphic Arts Technology Model
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

A course in Graphic Arts Technology provides students with an understanding of the processes and systems common to careers in publishing, printing, and other forms of media distribution. Representative topics include graphic design concepts; art and copy preparation; image generation and editing; desktop publishing; on-demand publishing; school yearbook and magazine layout; advertising and promotion; printing technology; binding and finishing; and screen printing.Students will be committed to lifelong learning as they grow individually, participate in groups, think analytically, create artistic products, and contribute to production of a major project. Students will learn illustration design software such as Adobe Illustrator, photo editing software such as Adobe Photoshop, and page layout software such as Adobe InDesign to create projects that will be printed in traditional and digital formats.

Subject:
Arts and Humanities
Graphic Arts
Visual Arts
Graphic Design
Material Type:
Full Course
Lesson Plan
Provider:
Butte County Office of Education
Provider Set:
CTE Online
Date Added:
07/15/2013
How to Use Microsoft Excel: The Careers in Practice Series
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

How to Use Microsoft Excel: The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel. However, the approach is not at the expense of relevance.

Subject:
Business and Communication
Material Type:
Textbook
Provider:
The Saylor Foundation
Provider Set:
Saylor Textbooks
Author:
Joseph Manzo
Date Added:
01/01/2012
Remix
If / Else Conditional Logic Statements for Coding
Conditional Remix & Share Permitted
CC BY-NC
Rating

This lesson focuses on using psuedo code to understand nested conditional statements. It includes two activities that can be used together for a full lesson or separated in to two supplemental activities to lessons you already do in the classroom.

Subject:
Computer Science
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Shannon Quible
Date Added:
08/08/2019
Remix
Information Technology 1 Formulas and Functions
Conditional Remix & Share Permitted
CC BY-NC
Rating

This lesson is to be used when teaching formulas and functions in Excel. Websites are provided for the curriculum and a project is available to use and modify as you choose. The project can be used as a checkpoint or as a final assessment.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Joyce Sadd
Date Added:
08/08/2019
Remix
Information Technology I Create and manage worksheets and workbooks
Conditional Remix & Share Permitted
CC BY-NC
Rating

This lesson is to be used when beginning to teach Excel. Websites are provided for the curriculum and a project is available to use and modify as you choose. The project can be used as a checkpoint or as a final assessment.

Subject:
Education
Material Type:
Activity/Lab
Lesson Plan
Author:
Joyce Sadd
Date Added:
08/08/2019
Remix
Information Technology I Manage Data, Cells, and Ranges
Conditional Remix & Share Permitted
CC BY-NC
Rating

This lesson is to be used when teaching students how to manage data, cells, and ranges Websites are provided for the curriculum and a project is available to use and modify as you choose. The project can be used as a checkpoint or as a final assessment.

Subject:
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Joyce Sadd
Date Added:
08/08/2019
Introduction to Physical Computing (Grade 7)
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Developed by the NYCDOE CS education team, the Introduction to Physical Computing course is a 54-hour long introductory computer science course that guides students to explore fundamental CS concepts through tinkering with the micro:bit, a simple programmable computer device. Each unit of the course guides students through the learning process with three practices: analyzing computer applications around them based on a given issue; prototyping a project that reflects the result of the analysis plus their interest; and communicating about their projects, including the functionality of a project, a project development process, influence from other projects and their contribution to a project when working in a group. The curriculum and support sessions assist educators in discovering the most effective way of facilitating this course for their own classroom, while helping them to become comfortable with the main tool, the micro:bit.

Subject:
Computer Science
Material Type:
Full Course
Provider:
New York City Department of Education
Provider Set:
Computer Science for All
Date Added:
12/17/2018
Introduction to databases
Conditional Remix & Share Permitted
CC BY-SA
Rating

This unit forms gives participants an understanding of the concepts behind database development, a sense of how database work can be applied to information projects and how to start thinking about the database planning process. It is primarily about developing an awareness of databases which can form a basis for future training in more practical aspects of database development work.

Material Type:
Activity/Lab
Full Course
Lecture Notes
Lesson Plan
Provider:
ItrainOnline
Provider Set:
ItrainOnline MMTK
Author:
ItrainOnline MMTK
Date Added:
07/23/2003
Learn 3D Design Using Tinkercad
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This series of lessons will teach all of the key features in Tinkercad, a free, web-based 3D design platform. When you have finished the lessons you will have a comprehensive knowledge of how to design/draw in 3D. After that all you need is practice to improve your skills.

Subject:
Architecture and Design
Computer Science
Graphic Arts
Visual Arts
Electronic Technology
Graphic Design
Educational Technology
Elementary Education
Geometry
Material Type:
Activity/Lab
Diagram/Illustration
Interactive
Lesson
Lesson Plan
Teaching/Learning Strategy
Unit of Study
Author:
Tom Guellich
Date Added:
09/25/2018
Learning How to Use Microsoft Excel 2016.pdf
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Complete introductory text for Excel 2016.This book has been updated and remixed from How to Use Excel by Manzo. The topics covered include: Fundamental Skills, mathematical computations, logical and lookup functions, charts, and tables and PivotTables. Updated and re-mixed by Kaaren McGlynn from the Saylor Academy's "How to Use Microsoft Excel: The Careers in Practice Series"

Subject:
Computer Science
Material Type:
Textbook
Author:
Kaaren McGlynn
Date Added:
09/21/2017
Remix
Mail Merge - Graduation Labels
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

One of the most common things I did during my work experience was making labels for a variety of reasons - mailing labels, shipping labels, name tags/badges, file folder labels, etc. In this lesson, students complete a mail merge with the teacher, then use addresses of family and friends to create labels that they could put on their graduation announcements.

Subject:
Business and Communication
Communication
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Tennille Allison
Date Added:
08/08/2019
Remote Learning Plan: Gmail Lesson 1 of 3 - Grade Levels 6-12
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This Remote Learning Plan was created by Alexandra Bastian 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 Introduction to Business Technology students in Grade Levels 6 through 12. Students will learn the different components (Receiver's email/Cc/Bcc/Subject/Body/etc.) of an email and how to compose a professional email to someone. Students will explore the different Gmail features (Attachments/contrast of background/text colors, text size/font/etc.) used to compose and format a professional email. Students will understand the guidelines for continuing email conversations. Students will learn what information shouldn't be sent via email, how to send an attachment, and the uses of carbon copy (Cc), and blind carbon copy (Bcc).

Subject:
Business and Communication
Communication
Career and Technical Education
Educational Technology
Material Type:
Lesson Plan
Teaching/Learning Strategy
Author:
Alexandra Bastian
Date Added:
08/03/2020
Remote Learning Plan: Gmail Lesson 2 of 3 - Grade Levels 6-12
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This Remote Learning Plan was created by Alexandra Bastian 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 Introduction to Business Technology students in Grade Levels 6 through 12. Students will utilize the different components of an email and practice composing a professional email to someone. Students will apply the different Gmail features to compose and format a professional email. Students will utilize the guidelines for continuing email conversations. Students will apply basic design principles and Gmail features to their practice email (Attachments/Cc, Bcc, contrast of background/text colors, text size/font/etc.).

Subject:
Business and Communication
Communication
Career and Technical Education
Educational Technology
Material Type:
Lesson Plan
Teaching/Learning Strategy
Author:
Alexandra Bastian
Date Added:
08/03/2020
Remote Learning Plan: Gmail Lesson 3 of 3 - Grade Levels 6-12
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

This Remote Learning Plan was created by Alexandra Bastian 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 Introduction to Business Technology students in Grade Levels 6 through 12. Students will utilize the different components of an email and practice composing a professional email to someone. Students will utilize the different components of an email and compose a professional email to someone on their own. Students will apply the different Gmail features to compose and format a professional email. Students will utilize the guidelines for continuing email conversations. Students will apply basic design principles and Gmail features to their own email (Attachments/Cc, Bcc, contrast of background/text colors, text size/font/etc.).

Subject:
Business and Communication
Communication
Career and Technical Education
Educational Technology
Material Type:
Lesson Plan
Teaching/Learning Strategy
Author:
Alexandra Bastian
Date Added:
08/03/2020
Remote Learning Plan: Spreadsheet Functions 9-12
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

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

Subject:
Information Science
Business and Communication
Material Type:
Lesson Plan
Teaching/Learning Strategy
Author:
Melissa Dux
Date Added:
07/28/2020
Remix
Shooting Video--Camera Use,  Angles, and Movement
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

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.

Subject:
Visual Arts
Journalism
Film and Music Production
Education
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Dawn Friedrich
Date Added:
08/08/2019
Web Page Design Model
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Use your computer skills to learn how to develop your own web page sites. This course is designed to provide the necessary skills and training for an entry level position in the field of Web Design. The class will focus on web page planning, basic design, layout, and construction (effective and ineffective), setup and maintenance of a web site, HTML, DHTML, JavaScript, and various web page and image creation tools.You will learn the basics of web design principles, digital media options, web design language (HTML), Internet uses and processes, design considerations, the impact of target market demographics, deliverables, and multiple software packages. Courses such as this can provide the skills and motivation for you to successfully complete college programs in one of several business areas. The primary purpose of this type of multi-media graphics education is to provide instruction for and about e-commerce and Internet communications through the use of Web Page Design. This is a repeatable course with progressive levels through Novice (this first level), Intermediate, and Advanced levels. You can turn this series of courses into a full Career Pathway as first an introductory, then a Concentration, and finally a Capstone course.

Subject:
Arts and Humanities
Material Type:
Full Course
Lesson Plan
Provider:
Butte County Office of Education
Provider Set:
CTE Online
Date Added:
07/15/2013
Remix
Word Processing Simulation Using Project Management
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

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.

Subject:
Communication
Education
Educational Technology
Material Type:
Activity/Lab
Lesson
Lesson Plan
Author:
Dawn Friedrich
Date Added:
08/08/2019