it – Search Results

itstraining.wichita.edu

Excel: Formatting an Entire Row Based on One Value

…so you hand-select an entire row, fill in the desired color, and repeat this process 100 or so times per semester. Never do that again! Let’s check out another versatility of Conditional Formatting: the ability to highlight an entire row based on one value in a specific column. Before we jump in… big thank you to Samantha and Amanda for inspiring this…

https://itstraining.wichita.edu/excel-formatting-an-entire-row-based-on-one-value/

itstraining.wichita.edu

Word: Compare and Combine

In the last Office Byte, we talked about the ability to compare two Excel documents via a special Add In. In the case of Word, we can use a feature already present on the Review tab, and in many ways it is even cooler. We cover this Compare feature in the Word Advanced training… if you would like to learn more about this, I would love to see you at a future …

https://itstraining.wichita.edu/word-compare-and-combine/

itstraining.wichita.edu

Excel: PivotTables and Calculated Fields

Formulas and PivotTables. Many of us have gotten caught up creating formulas outside of a PivotTable by referencing cells within a pivot table, only to be disappointed when we update our PivotTable and cells shift back and forth. There are several ways of dealing with this issue. One way is to create a Calculated Field within your PivotTable. This is…

https://itstraining.wichita.edu/excel-pivottables-and-calculated-fields/

itstraining.wichita.edu

PowerPoint: Creating Master Slide Layouts

…you might want to do what we are about to do today, which is to make a larger layout change for your presentation. Altering the Master Slide might sound intimidating, but it can be a huge time saving step… and can make uniformity of your presentation so much simpler. Let’s check it out. Exercise Files No exercise file today! You can open PowerPoint to…

https://itstraining.wichita.edu/powerpoint-creating-master-slide-layouts/

itstraining.wichita.edu

Word: Linking Text Between Documents

There are several options in Word for referencing a separate Word document. A feature I particularly like is called Insert Object. There is a lot you can do with the Insert Object feature, but one nice aspect is the ability to link (and sync!) text between two documents. Let’s see how this works. Exercise Files There are two files that will work together…

https://itstraining.wichita.edu/word-linking-text-between-documents/

itstraining.wichita.edu

PowerPoint: Slide Layout and Accessibility

PowerPoint has a lot of aesthetic features, so it can be easy to become so focused on the visual aspects of a presentation that we forget about what is happening behind the scenes. A slide deck can appear perfect from a visual perspective, but definitely still have a long way to go internally. Let’s take a look. Exercise File Download today’s exercise file…

https://itstraining.wichita.edu/powerpoint-slide-layout-and-accessibility/

itstraining.wichita.edu

Excel: Organizing Sheets

…would like one to experiment upon, here is the exercise from the Form Entry blog entry: ExcelSampleWorkBook This workbook contains a list of fictional course grades that work with in some of the Excel trainings. Right Click Menu To try out the options below, hover your mouse over the sheet name (Fictional Course Grades) and right click. A menu will appear to…

https://itstraining.wichita.edu/excel-organizing-sheets/

itstraining.wichita.edu

Word: Creating Fillable Forms Without Acrobat

…forms feature. (By the way, if you are interested in learning about Acrobat Fillable forms, please attend one of my training sessions on the subject!) Word also has the ability to create forms fields; this is by no means intended to replace Acrobat in the Fillable Forms sphere, but it does offer some unique abilities… and there may be times you even…

https://itstraining.wichita.edu/word-creating-fillable-forms-without-acrobat/

itstraining.wichita.edu

PowerPoint: Animation Painter

…you can make when selecting an animation. Once you have spent a lot of time making these adjustments, you may want to apply the same effect to another object in your presentation without recreating the wheel every time. Animation Painter is the perfect tool for this! Exercise File If you would like to follow along, download the exercise file here:…

https://itstraining.wichita.edu/powerpoint-animation-painter/

itstraining.wichita.edu

Outlook: Delay Delivery

There are a variety of reasons that you may want to delay delivery of an email in Outlook. Perhaps you are waiting until a specific time to send a reminder, or maybe you need to delay sending emails to specific people until 4:59 pm (or 7:59 am). Outlook’s Delay Delivery feature may be just what you are looking for. Mac Users It looks like this feature will…

https://itstraining.wichita.edu/outlook-delay-delivery/

itstraining.wichita.edu

Outlook Formatting Woes: Replying to Email Sent from a Phone

…you start to compose your reply. Your signature looks different than usual, you can’t format text, or change fonts… even doing something simple, like making a word bold or italic, is impossible as a good portion of the ribbon is greyed out and unselectable. What is going on here? When your coworker emailed you from her phone (or tablet), most likely the…

https://itstraining.wichita.edu/outlook-formatting-woes-replying-to-email-sent-from-a-phone/

kcee.wichita.edu

KS Agencies Partner to Create Financial Literacy Courses for Foster Care Youth

Wichita, KS – Sep. 19th, 2025 The Kansas Council on Developmental Disabilities (KCDD), in partnership with the Kansas Department for Children and Families (DCF), the Office of State Treasurer Steven Johnson, and Kansas Council on Economic Education proudly announces the launch of a new statewide educational campaign designed to increase awareness and…

https://kcee.wichita.edu/2025/09/19/ks-agencies-partner-to-create-financial-literacy-courses-for-foster-care-youth/

ksarn.org

Pace with release conditions

Home / Blackboard guides / Build content Blackboard guide · Build content Pace with release conditions Decide what students can see and when, and guide them through it in order. Start with visibility. New content is hidden from students until you show it, which is useful while you build. One caution: set visibility before you set release conditions, because …

https://ksarn.org/bb-guide-release-conditions/

ksarn.org

Choose your grading scheme

…any grades post. Decide your grade scheme early: straight points, or weighted categories, for example exams 40 percent, projects 40 percent, and participation 20 percent. Set it before the first grades post, because changing it midstream confuses students and shifts totals they have already seen. Confirm that the overall grade students see matches what…

https://ksarn.org/bb-guide-gradebook/

ksarn.org

Your entry point and syllabus

…they can use. Give students a clear front door: a short welcome and a visible “Start here” that says what to do first. Post your syllabus as a Blackboard Document built with real headings, rather than only a PDF attachment, so it reads well on phones and with assistive technology. Many campuses require specific syllabus statements, so add yours now. How…

https://ksarn.org/bb-guide-home-and-syllabus/

ksarn.org

Images, color, and contrast

Home / Blackboard guides / Accessibility Blackboard guide · Accessibility Images, color, and contrast Make images and color choices that work for every student. Every meaningful image needs alt text that conveys its point in a sentence. Purely decorative images can be marked as decorative so screen readers skip them. Never let color carry meaning by itself. …

https://ksarn.org/bb-guide-images-and-color/

ksarn.org

Organize for your modality

Home / Blackboard guides / Build content Blackboard guide · Build content Organize for your modality Choose how to organize your course based on how you teach it. The single biggest structural choice in your Blackboard course is how you organize it. Your teaching modality is the deciding factor. By teaching modality we mean how the course is delivered: in…

https://ksarn.org/bb-guide-organize-for-modality/

ksarn.org

Blackboard guides

…to find exactly what you need. Want the full path and a certificate? Take the course. AllDesign your courseSet up your LMSBuild contentAssess and quizSet up the gradebookAccessibilitySet up communicationMaintain across terms Design your courseStart with backward designPlan your course from outcomes, not from the files you happen to have.Design your…

https://ksarn.org/blackboard-guides/

ksarn.org

Engagement as prevention

…and applying, leaves far less room for problems than a long passive lecture. Engagement is the first and best classroom-management strategy. Break up stretches of delivery with regular active moments, as the teaching foundations and learning theories courses describe. When students are busy with meaningful work, attention stays where you want it and…

https://ksarn.org/cm-guide-engagement-as-prevention/

ksarn.org

Canvas guides

…to find exactly what you need. Want the full path and a certificate? Take the course. AllDesign your courseSet up your LMSBuild contentAssess and quizSet up the gradebookAccessibilitySet up communicationMaintain across terms Design your courseStart with backward designPlan your course from outcomes, not from the files you happen to have.Design your…

https://ksarn.org/canvas-guides/