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.
Material Type: Textbook
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Activity/Lab, Lesson Plan
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
Do you want to learn the basics of how to use Microsoft word? This web site offers easy to understand video lessons. In addition to the audio lessons, the site offers supplement materials.
Material Type: Lecture, Lesson Plan, Student Guide
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
The database management software is the program used to create and mange the database. The database model is the architecture the DBMS used to store objects within that database.
Material Type: Lecture
Our first Mr. Ford's Class Most Excellent PowerPoint Tip. This video shows you how to quickly and easily add YouTube videos to your PowerPoint presentation.
Material Type: Lecture
Acquire essential skills for producing professional work with the Microsoft Office suite including Word, Excel, PowerPoint and more.
Material Type: Diagram/Illustration, Lecture, Reading
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Activity/Lab, Lesson, Lesson Plan
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.
Material Type: Full Course
Chroma key composting, or chroma keying, is a special effects / post-production technique for composting (layering) two images or video streams together based on color hues (chroma range). The technique has been used heavily in many fields to remove a background from the subject of a photo or video – particularly the news casting, motion picture and video game industries. A color range in the top layer is made transparent, revealing another image behind. The chroma keying technique is commonly used in video production and post-production. This technique is also referred to as color keying, color-separation overlay (CSO; primarily by the BBC[2]), or by various terms for specific color-related variants such as green screen, and blue screen – chroma keying can be done with backgrounds of any color that are uniform and distinct, but green and blue backgrounds are more commonly used because they differ most distinctly in hue from most human skin colors. No part of the subject being filmed or photographed may duplicate a color used in the background.[3]
Material Type: Activity/Lab, Interactive, Lecture Notes, Teaching/Learning Strategy
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.
Material Type: Activity/Lab, Homework/Assignment, Lesson, Lesson Plan
The spreadsheet below will help you keep track of all your incorporated content items so that you can build an attribution statement to go alongside or underneath each piece.
Material Type: Teaching/Learning Strategy
Use this checklist to make sure that all the requirements for open licensing are met. Please note that it is very helpful to review this checklist BEFORE you begin development work so that you are designing your resource with open licensing requirements in mind from the beginning.
Material Type: Teaching/Learning Strategy
