K200 - Computer Technology in Public Health
K200 - Computer Technology in Public Health
-
This video demonstrates adding music, adjusting window size and View, and creating three fades in an audio file using Audacity 3.3.3. Video created for SPH K200 Computer…
Audacity Fades Summer 2023
-
Introduction to K200 video. Shows setting up Box @ IU, Cloudstorage @ IU, and finding Box in STC lab. NOTE: Yes class Website has changed.
Box and Cloudstorage at IU
-
Video will demonstrate: Inserting slide footer with name, date, and slide number; Add slide transition to all slides
Clip of K200 - MP #4 - Slider Footer & Slide…
-
Demonstrates setting up cloud storage services at IU Bloomington
Cloud Storage at IU - 2024
-
Using Excel 2019, this video demonstrates how to: Use Function Library; Use PMT Function; Copy worksheet; Format titles; Rename worksheets; Color worksheet tabs
In Class Saver - Excel 3 - K200
-
This video demonstrates how to: Insert Table; Table Design Ribbon; Total Row; Total Row: Sum, Min, Max; Copy/Paste variables; Currency & Accounting in Number…
In Class Saver - Excel 4 - Part 2- K200
-
This video demonstrates how to: Open Microsoft Word; Find Ruler; Save File As; Save File; Word Styles; Insert Picture; Resize Picture; Move Picture; Wrap Text; Insert…
In Class Saver - Word 1 - K200
-
This video demonstrates how to: Rename Word file when icon; Margins; Select All; Change Font; Edit Font: Change Type & Color; Format Painter
In Class Saver - Word 2 - K200
-
In-Class-Saver-Excel-2-K200 10 of 96
17:47duration 17 minutes 47 seconds
In-Class-Saver-Excel-2-K200
Using Excel 2019, this video demonstrates how to: Create clustered column chart; change chart style; change chart color; create percentage formula; and anchor cell.In-Class-Saver-Excel-2-K200
-
This video demonstrates how to: Create an IF function; Use Conditional Formatting
In-Class-Saver-Excel-4-Part-1-K200
-
This video demonstrates how to: Mail merge labels in Microsoft Word 2019
In-Class-Saver-Word-3-K200
-
This video demonstrates how to: Create a database; create a table; enter data, create a form; create a report; save a database for back-up.
In_Class_Saver_Access_1_Part_1_ K200
-
This video demonstrates how to: Create create queries: selecting fields; using criteria.
In_Class_Saver_Access_1_Part_2_K200
-
Demonstrates finding the correct workspace - desktop - for students to use in K200.
IUanyWare - Choose Desktop
-
Demonstrates logging into IUanyWare.
IUanyWare - Log-In
-
Demonstrates saving file, submitting file for grading in Canvas, closing programs, and backing up files for future use in OneDrive.
IUanyWare - Save, Submit, Backup, Close
-
Demonstrates working in the IUanyWare environment including opening Microsoft Word and saving files.
IUanyWare - Working in IUanyWare
-
Demonstrates locating Office 365 for downloading for IU students.
IUware - Getting Office 365
-
Demonstrates accessing IUware and utilizing homepage.
IUware Accessing
-
Video Covers: Backing up your work in Box, both the first and second time, so you don't lose it.
K200 - Back Up Work In Box
-
Demonstrates setting up cloud storage accounts at IU.
K200 - Cloud Storage at IU-Fall 2020
-
Demonstrates setting up Cloudstorage and Box account at IU.
K200 - Cloudstorage and Box Setup
-
Video demonstrates: Creating database in Access; Making a table; Entering data into table.
K200 - Create Database - Table and Data Entry
-
Continues demonstrating creating folders and using Windows on a PC.
K200 - Create K200 Folders on Computer - 2
-
Demonstrates creating folders on a Windows operating system Desktop.
K200 - Create K200 Folders On Desktop
-
Video covers: How to download and unzip the student data files for the Canvas textbook "Skills for Success".
K200 - Download & Unzip Student Data Files
-
Video covers: 1. Renaming file; 2. Chart creation;
K200 - Excel - In Class Saver 2
-
Video covers: 1. PMT function; 2. Creating several PMT functions for comparison
K200 - Excel - In Class Saver 3
-
In this video you will learning: IF Function; Conditional Formatting; Table Creation & Table Uses; Total Row; Label Arrows > View and Filter Data; Copying from…
K200 - Excel - In Class Saver 4
-
Demonstrates creating folders in Google Drive.
K200 - Google Drive and K200 Folders-Fall 2020
-
Video Demonstrates: Opening PowerPoint; Saving presentation; Insert table; Insert chart; Insert SmartArt; Themes.
K200 – In The Game – ICS 3
-
Video will demonstrate: Make a Form; Change Theme; Make a Report; Make Publishing Date query
K200 - MP #3 - Part 2 - Review
-
Video demonstrates: Download instructions; Design database from queries; Open Access; Name Project; Create table; Make a Form; Change Theme; Make a Report; Make First…
K200 - MP #3 - Part 3
-
Video will demonstrate: Inserting slide footer with name, date, and slide number; Add slide transition to all slides
K200 - MP #4 - Slider Footer & Slide…
-
Video Demonstrates: Opening PowerPoint; Creating new presentation; Saving presentation; Slide layouts; Lists; Themes
K200 – My Life In K200 – ICS 2
-
This video continues demonstrating links and resources in Canvas.
K200 - Navigate Canvas 3 - Summer 2021
-
Demonstrates locating IU computing resources.
K200 - Navigate IU Computing Resources
-
Demonstrates finding IUware and downloading Office 365.
K200 - Navigate IUware
-
Demonstrates needed skills on a PC computer such as viewing folders, showing the Desktop, and parts of the task bar.
K200 - Needed Skills
-
Demonstrates creating folders in OneDrive in the IU system.
K200 - OneDrive and K200 Folders-Fall 2020
-
Video demonstrates: 1. Logging into OneDrive; 2. Finding OneDrive; 3. Creating Folders; 4. Locating folders
K200 - OneDrive and K200 Folders-Sum 2022
-
Video demonstrates: Download, edit, save, and upload process for podcasting files. NOTE: Recorder went off at beginning so no seeing instructor's face.
K200 - Podcasting - Audacity -…
-
Video demonstrates: How to do all the fade-ins and fade-outs for the podcasting weekly project. Watch entire video for help in making all of these. ALSO: Final music cut…
K200 - Podcasting - Audacity - Fades & Final…
-
Demonstrates taking screenshots and finishing screenshot project.
K200 - Screenshot, Save, Submit File for Grading
-
Video demonstrates: 1. Loggining into IUanyWare; 2. Choosing STC Desktop; 3. Finding Word; 4. Saving file in IUanyWare desktop; 5. Saving file in OneDrive; 6. Submitting…
K200 - Video - Setup IUanyWare-Sum 2022
-
Demonstrates navigating Canvas in class section.
K200 - Video-Navigate-Canvas-1
-
Demonstrates finding and using eTexts textbook in Canvas.
K200 - Video-Navigate-Canvas-2a-Textbook
-
Demonstrates further navigation in Canvas in class.
K200 - Video-Navigate-Canvas-3
-
Video Covers: Internet PPTs; The Internet Map; History of the Internet; How the Internet Work; PILOT Tutorial Set-up & Instructions; Exam 1 Study Guide
K200 - Week 3 Instructions
-
This video covers: Opening Word; Finding Ribbons; Saving Word document; Show/Hide; Word styles; insert images; image styles; Wrap text; Insert table; table styles;…
K200 - Week 4 - Word In Class Saver 1
-
Video Covers: Download from Web; Margins; Show/Hide; Select All; Edit Fonts; Format Painter
K200 - Week 4 - Word In Class Saver 2
-
Demonstrates downloading and unzipping files; backing up folders to Box.
K200 - Zip Unzip Files and Folders
-
Video demonstrates: Making queries by filtering fields; Making queries with specific criteria; Making reports from queries.
K200 Access - Create Queries
-
Demonstrates: Making a form; Making a report from a table; Changing theme of the database.
K200 Access - Forms and Reports
-
K200 video covers: Image Capture and Crop methods: Print/Screen; Cropping Image in Word; Snipping Tool; Image insert in Word Created - 2018 Aug 26 03:41:35
K200 Image Capture & Crop
-
Video covers: Navigating Canvas: Announcements; Textbook; Assignments; Quizzes; People; Help; Inbox Create - 2018 Aug 26 02:25:49
K200 Navigating Canvas
-
Needed Skills: Getting to Desktop; Finding Downloads and Documents; Right-click on Web link to open in new tab or window; Taskbar and Ungrouping Windows; Insert button…
K200 Needed Skills
-
Demonstrates printing in PowerPoint to save paper, ink, and time.
K200 Printing in PowerPoint - 2018
-
Manipulating Windows; Alt-Tab; Minimize, Maximize, Restore Down, & Close buttons; Moving windows; Views: Icon; List; Details. Created - 2018 Aug 26 04:00:56
K200 Windows 10
-
Video introduces view to Canvas links used during the class.
K200-Canvas-1-Sum-2021
-
Margaret Lion walks through the basics of creating a mail merge in Word for Windows.
Mail Merge Update
-
Part 1 of the video instructions for creating the major project database.
Major Project 3 - Access - Part One
-
Part two of the video instructions for major project database.
Major Project 3 - Access - Part Two
-
K200 Video covers: Navigating Class Website; Calendar; Weekly Projects; Exams, Major, and Final Projects; Class Resources; Side Links to Canvas and Box @ IU. Created -…
Navigating Class Website
-
Demonstration of accessing OneDrive at IU. Demonstration of creating K200 folders in OneDrive.
OneDrive – Find and Access
-
Demonstrates changing sizes of windows and taking screenshot of file on physical computer and in OneDrive side by side. Demonstrates submitting file for grading.
Project Video: Location of Files and Folders - 4
-
Demonstrates downloading, renaming, and opening the project file. Demonstrates taking the first screenshot of the OneDrive K200 folder.
Project Video: Location of Files and Folders -…
-
Demonstrates taking screenshot of file on computer desktop and adding location of physical computer.
Project Video: Location of Files and Folders -…
-
Demonstrates uploading file to OneDrive and opening a file in OneDrive.
Project Video: Location of Files and Folders -…
-
This video will begin the project, demonstrating the first few steps.
Project Video: Screenshot, Save, Submit File for…
-
This video is the second part to creating your first database. This video demonstrates: Checking your data for mistakes; Saving table; Proper column width; Saving…
Save Backup and Submit for Grading
-
Screenshot Video 1: Keyboard 75 of 96
03:07duration 3 minutes 7 seconds
Screenshot Video 1: Keyboard
Margaret Lion demonstrates how to take a screenshot using a keyboard. Example is shown on a PC running Windows 10.Screenshot Video 1: Keyboard
-
Margaret Lion demonstrates taking a screenshot using the built-in command in Microsoft Word 365. Example is shown on a PC running Windows 10.
Screenshot Video 2: Screenshot in Word
-
Margaret Lion demonstrates taking a screenshot with the Snipping Tool and then inserting it into Microsoft Word. This tool is for PCs only. Mac users need to search…
Screenshot Video 3: Snipping Tool (For PC)
-
Video demonstrates the Lion Method for creating fades in Audacity. This is referenced in the textbook Introduction to Podcasting by Margaret Lion. Video Support for…
Steps to Making Fades in Audacity - 2019
-
Margaret Lion demonstrates how to use the LinkedIn Learning(R) projects for K200 and K506.
Using LinkedIn Learning in K200
-
This video demonstrates how to set-up cloud storage in the IU system. Website: cloudstorage.iu.edu
Video 1: Cloud Storage at IU
-
Demonstrates first steps in getting to Weebly.com, the CMS used in K200.
Weebly 1 - Go to Weebly
-
Demonstrates creating and scheduling blog posts in Weebly.
Weebly 10 - Blog
-
Demonstrates how to resize sections in Weebly.
Weebly 11 - Extra-Resize Sections
-
Demonstrates editing points in the Sims theme including: Moving through the site in the Weebly editor; Adding image to each page; and Resizing sections.
Weebly 12 - Extra-Sims Theme Points
-
Demonstrates choosing a theme and creating a site name.
Weebly 2 - Theme and Site Name
-
Demonstrates working in the Pages environment in the Smith theme in Weebly.
Weebly 3 - Pages Smith
-
Demonstrates moving through the Sims theme and the pages set-up.
Weebly 4 - Sims Theme Set-Up
-
Demonstrates how to edit and add text and publish a Website in Weebly.
Weebly 5 -Text and Publish
-
Demonstrates how to make links in Weebly.
Weebly 6-Links
-
Demonstrates how to add images into a Weebly page.
Weebly 7 - Images
-
Demonstrates instructions for Format page and uploading a file in Weebly.
Weebly 8 - Format and Upload
-
Demonstrates copying a text element from one page in Weebly to another.
Weebly 9 - Copy Element
-
Hello I'm Ms. Margaret Lion and I welcome my K200 and K506 students to a wonderful summer semester.
Welcome K200 & K506 Summer 2023 Students -…
-
Ms. Lion welcomes you to K200 Computer Technology in Public Health and helps you get ready for the semester of computer knowledge.
Welcome K200 Summer 2022 Students!
-
Ms. Lion's welcoming message to her online K200 students for Summer 2020. The picture in the background was taken inside the Simon Skjodt Stadium when the IU…
Welcome to K200 Summer 2020
Search for ""