K200 - Computer Technology in Public Health
K200 - Computer Technology in Public Health
-
From Margaret Lion
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… -
From Margaret Lion
Introduction to K200 video. Shows setting up Box @ IU, Cloudstorage @ IU, and finding Box in STC lab. NOTE: Yes class Website has changed. -
From Margaret Lion
Video will demonstrate: Inserting slide footer with name, date, and slide number; Add slide transition to all slides -
In Class Saver - Excel 3 - K200
17:12 duration 17 minutes 12 seconds
In Class Saver - Excel 3 - K200
From Margaret Lion
Using Excel 2019, this video demonstrates how to: Use Function Library; Use PMT Function; Copy worksheet; Format titles; Rename worksheets; Color worksheet tabs -
From Margaret Lion
This video demonstrates how to: Insert Table; Table Design Ribbon; Total Row; Total Row: Sum, Min, Max; Copy/Paste variables; Currency & Accounting in Number… -
From Margaret Lion
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… -
From Margaret Lion
This video demonstrates how to: Rename Word file when icon; Margins; Select All; Change Font; Edit Font: Change Type & Color; Format Painter -
From Margaret Lion
Using Excel 2019, this video demonstrates how to: Create clustered column chart; change chart style; change chart color; create percentage formula; and anchor cell. -
From Margaret Lion
This video demonstrates how to: Create an IF function; Use Conditional Formatting -
-
From Margaret Lion
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. -
From Margaret Lion
This video demonstrates how to: Create create queries: selecting fields; using criteria. -
From Margaret Lion
Video Covers: Backing up your work in Box, both the first and second time, so you don't lose it. -
From Margaret Lion
Video demonstrates: Creating database in Access; Making a table; Entering data into table. -
-
-
From Margaret Lion
Video covers: How to download and unzip the student data files for the Canvas textbook "Skills for Success". -
K200 - Excel - In Class Saver 3
10:49 duration 10 minutes 49 seconds
K200 - Excel - In Class Saver 3
-
From Margaret Lion
In this video you will learning: IF Function; Conditional Formatting; Table Creation & Table Uses; Total Row; Label Arrows > View and Filter Data; Copying from… -
From Margaret Lion
Video Demonstrates: Opening PowerPoint; Saving presentation; Insert table; Insert chart; Insert SmartArt; Themes. -
From Margaret Lion
Video will demonstrate: Make a Form; Change Theme; Make a Report; Make Publishing Date query -
From Margaret Lion
Video demonstrates: Download instructions; Design database from queries; Open Access; Name Project; Create table; Make a Form; Change Theme; Make a Report; Make First… -
From Margaret Lion
Video will demonstrate: Inserting slide footer with name, date, and slide number; Add slide transition to all slides -
From Margaret Lion
Video Demonstrates: Opening PowerPoint; Creating new presentation; Saving presentation; Slide layouts; Lists; Themes -
-
From Margaret Lion
Demonstrates needed skills on a PC computer such as viewing folders, showing the Desktop, and parts of the task bar. -
From Margaret Lion
Video demonstrates: 1. Logging into OneDrive; 2. Finding OneDrive; 3. Creating Folders; 4. Locating folders -
From Margaret Lion
Video demonstrates: Download, edit, save, and upload process for podcasting files. NOTE: Recorder went off at beginning so no seeing instructor's face. -
From Margaret Lion
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… -
-
From Margaret Lion
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… -
From Margaret Lion
Video Covers: Internet PPTs; The Internet Map; History of the Internet; How the Internet Work; PILOT Tutorial Set-up & Instructions; Exam 1 Study Guide -
From Margaret Lion
This video covers: Opening Word; Finding Ribbons; Saving Word document; Show/Hide; Word styles; insert images; image styles; Wrap text; Insert table; table styles;… -
From Margaret Lion
Video Covers: Download from Web; Margins; Show/Hide; Select All; Edit Fonts; Format Painter -
-
From Margaret Lion
Video demonstrates: Making queries by filtering fields; Making queries with specific criteria; Making reports from queries. -
From Margaret Lion
Demonstrates: Making a form; Making a report from a table; Changing theme of the database. -
From Margaret Lion
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 -
From Margaret Lion
Video covers: Navigating Canvas: Announcements; Textbook; Assignments; Quizzes; People; Help; Inbox Create - 2018 Aug 26 02:25:49 -
From Margaret Lion
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… -
-
From Margaret Lion
Manipulating Windows; Alt-Tab; Minimize, Maximize, Restore Down, & Close buttons; Moving windows; Views: Icon; List; Details. Created - 2018 Aug 26 04:00:56 -
-
From Margaret Lion
Margaret Lion walks through the basics of creating a mail merge in Word for Windows. -
-
-
From Margaret Lion
K200 Video covers: Navigating Class Website; Calendar; Weekly Projects; Exams, Major, and Final Projects; Class Resources; Side Links to Canvas and Box @ IU. Created -… -
From Margaret Lion
Demonstration of accessing OneDrive at IU. Demonstration of creating K200 folders in OneDrive. -
From Margaret Lion
Demonstrates changing sizes of windows and taking screenshot of file on physical computer and in OneDrive side by side. Demonstrates submitting file for grading. -
From Margaret Lion
Demonstrates downloading, renaming, and opening the project file. Demonstrates taking the first screenshot of the OneDrive K200 folder. -
From Margaret Lion
Demonstrates taking screenshot of file on computer desktop and adding location of physical computer. -
-
-
From Margaret Lion
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… -
From Margaret Lion
Margaret Lion demonstrates how to take a screenshot using a keyboard. Example is shown on a PC running Windows 10. -
From Margaret Lion
Margaret Lion demonstrates taking a screenshot using the built-in command in Microsoft Word 365. Example is shown on a PC running Windows 10. -
From Margaret Lion
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… -
From Margaret Lion
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… -
Using LinkedIn Learning in K200
10:12 duration 10 minutes 12 seconds
Using LinkedIn Learning in K200
From Margaret Lion
Margaret Lion demonstrates how to use the LinkedIn Learning(R) projects for K200 and K506. -
From Margaret Lion
This video demonstrates how to set-up cloud storage in the IU system. Website: cloudstorage.iu.edu -
-
-
From Margaret Lion
Demonstrates editing points in the Sims theme including: Moving through the site in the Weebly editor; Adding image to each page; and Resizing sections. -
-
-
-
-
-
-
-
From Margaret Lion
Hello I'm Ms. Margaret Lion and I welcome my K200 and K506 students to a wonderful summer semester. -
From Margaret Lion
Ms. Lion welcomes you to K200 Computer Technology in Public Health and helps you get ready for the semester of computer knowledge. -
From Margaret Lion
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…