James Lyons-Weiler, PhD
368 subscribers
23 photos
422 links
Author, CEO, President, Scientist, Editor-in-Chief and President at Institute for Pure and Applied Knowledge http://ipaknowledge.org

Editor in chief of the Journal Science, Public Health Policy and the Law http://publichealthpolicyjournal.com
Download Telegram
Need more students in Spreadsheets 1 to run the class this term - here's the Syllabus - get some skills!

Lecture 1. Course Overview
Basic Math operations review
Spreadsheet examples
Compound operations

Recommended reading:
https://www.infodocket.com/2020/09/01/new-data-report-on-adult-numeracy-in-the-united-states/

Lecture 2. Importing Data
xls format, text, delimiters, cut-and-paste operations
Formatting Cells
Saving Your File in the Right Format

Lecture 4. Intro to Formulas
Homework Review
Summing a Column or Row
Calculating proportions in a column
Calculating percentages from proportions

Lecture 5. Intro to Graphs
Homework Review
Line Graph
Bar Graph
Spreadsheet Example

Lecture 6. Using Reference cell
Homework Review
Use in a column
Use in a function
Graph

Lecture 7. Calculating and Plotting a Histogram
Method 1
Method 2

Lecture 8. Correlation
Math of Linear Correlations: y = mx+b
Plotting a linear function
Data Analysis Pack 1

Lecture 9. Charts
Charts: Histogram, Bar Chart, Line Chart
Combining Chats

Lecture 10. Pie Diagrams

Lecture 11 Creating a Filter
Graph: Bar Chart or Pie Chart

Lecture 12 Sorting Data
Graphic: Line Charts

Lecture 13. Recursive calculations
Example 1 Compound Interest
Example 2 Cumulative Incidence

Lecture 14 Data Analysis Pack 2
Comparing the averages of samples from two populations (T-Test)
Other statistical operations available

Lecture 15 Recap

https://ipak-edu.org/registration/?store-page=Analysis-100-Introduction-to-Spreadsheets-p234552740
Some good news.  We'll soon have 20 scholarships to courses @ IPAK-EDU based on financial need.

We'll need help getting the word out, so this is just a ping to alert you to watch for the announcement. 

I hope everyone is doing well.
Here's the link to the first video for this semester's course at IPAK EDU, "How to Read and Interpret a Scientific Study" (No password). It's an overview and the first part of the lecture on Type of Studies. If you like it, you can register for the full course here:
https://ipak-edu.org/registration/?store-page=Analytics-100-Anatomy-of-a-Scientific-Study-p277154319
(This is not the Applied Biostats Course, fyi).
We are 1 week into the Spring Semester @ IPAK-EDU. It's not too late to register - you can take Immunology, Biology B, Herbology, Wholistic Approaches to Human Health, Preventing and Reversing Chronic Illness, Applied Biostatistics, and How to Read & Interpret a Scientific Study.
All of these courses are 10-15 week courses and YOU WILL LEARN.

Signing up is easy - and you deserve the fundamentals -
https://ipak-edu.org/registration/
You can now become an IPAK-EDU Environmental Toxicology On Demand Course affiliate by replying with an expression of interest.

Affiliates earn 25% of each registration they inspire. Because the course is not live, it's offered at a discount ($80) so for each person you bring to us, you'll receive $20 - and help educate the world!

To sign up, just send an email to info@ipak-edu.org, subject line Affiliate Program and we'll sign you up. It's that easy. (I think).

You'll get an affiliate link for your website or to post on social media, on your website, in your email signature, yadda, yadda.

Cheers,
Dr. Jack