Recommendation – Learning Microsoft Excel and Website Coding

I am late in getting this new entry posted, but I have been learning new things at a quick pace! I wanted to share two resources for anyone wanting to learn how to work with Excel sheets or how to code for websites. My class work lately has been heavy on website design, and my work as a graduate assistant has required more detailed knowledge of using Excel sheets than I had previously known. Like everyone else, I turned to the web to see what was available (and yes, I am in graduate school, but they expect me to find a lot of this information myself!). After trying several different avenues, I found two resources that I wanted to share. I have found both to be very helpful with learning and practicing new skills, so if you are interested in either, check these out!

The first is learning Excel. If you are like me, you probably have done some basic work with Excel, but never really needed to go very deep into its various uses. There are a lot of people who have to learn Excel for a job, but most people don’t deal with numbers and statistical analysis every day. However, if you want to gain a new skill on your own, I have found a set of YouTube videos that helped me a lot when working with Excel files. The person who presents these videos has a website with other resources as well, so I am going to include links for both his channel and website at the end of this section. The title of the video set is Microsoft Excel Tutorials for Beginners, and there are about 13 total videos. However, you can pick and choose which videos interest you, depending on what you want to learn. The presenter, Jamie Keet, provides a timed overview of each video, most of which are around 20 minutes. The overview allows you to jump to the sections you want to hear, or perhaps re-hear, without going through the entire video. His video is easy to follow, and he doesn’t make assumptions about what you already know. If you already know how to work with certain parts of Excel, you can always jump to the next section. (I recommend listening to the whole thing first, he provides little time saving tricks you might not know.) Mr. Keet also has a website/blog called Teachers’ Tech that has other helpful content for those wanting to learn about digital resources. I highly recommend the videos!

Microsoft Excel For Beginners and

Teachers’ Tech website


My second recommendation is for learning HTML and CSS coding. To be honest, most people probably don’t need to learn coding if they want to create a website or use most modern digital media. However, learning is always fun, and it helps you understand how websites work. If you are using a CMS (Content Management System) like WordPress, Wix, or Weebly, learning how coding works can help you make better decisions when you are creating your digital works. And really, at least you will know why the darn thing won’t do what you want it to! For learning coding, my biggest help has been W3Schools. This website is run out of Norway, and started in 1998. It has all different types of coding lessons, and the tutorials are very simple. Some people might think they are too simple, but I have found them easy to understand and quick to go through. You will need to practice your coding by writing code (I use Atom, a free download coding software, but you can easily just use Notepad if you are on a PC). The main thing about the way this teaches coding is through gradually taking you though each part, and allowing you to open up a practice page. On the practice page you have the code on one side, and the webpage result on the other. This makes it very simple to change something and see the result right beside the code. I wouldn’t try to do much writing on the Example pages, but once you get the idea, you can work on Notepad or any other code software and try out what you are learning. If you just want to dip your toes into coding, W3Schools are really nice to use.

W3Schools


Featured Image by Lawrence Monk from Pixabay

Recommendations – Documentaries

In this post, I am going to recommend a couple of documentaries about two of my favorite subjects, astronomy and language. I have watched both of these videos numerous times, and they always make me happy and tear up at the same time, as well as being just really good documentaries. Both of these videos are available on NCLive through most public and academic libraries. However, if you are not in North Carolina, you can check your own public library video streaming and DVD collection. The astronomy documentary, The Farthest, can also be found on PBS Passport. And currently the language documentary, Breaking the Maya Code, is on Amazon Prime.

I’ll start with The Farthest – Voyager in Space released in 2017, which is a film on the building, launch, and travel to the outer planets by Voyager 1 and Voyager 2. It is one of the best astronomy videos I have ever watched, and I really like documentaries and films on astronomy. The format includes commentary by some of the scientists who worked on the project, together with still photography, contemporary video, and a great music score that weaves into a whole that is both informative and entertaining. The film captures the epic scale of the achievement, but also makes it personal to the people that worked on the project, emphasizing the human aspect of the search for answers through science. While it has a lot of good science information in it, the emotion it conveys about why we reach for the stars, and strive to know what is outside our planet, is a constant theme of the film. If you want to feel optimistic about the human species, this film can give you hope. (2 hour film)


The second film I want to recommend is called Breaking the Maya Code (2008). Like the above documentary, it is one that combines interviews of linguists with a really good narrative and great pacing. The music score can’t compete with The Farthest, but other than that, it is an excellent documentary. The subject of this film is the effort to translate the Maya glyphs found in ancient Central American cities, after almost all books of the writing were destroyed during the Spanish Conquest. As a historian and a new librarian, I find this documentary painful when considering how much was lost when European colonists destroyed so many books of the Mayan people during the 1600s. However, it is also uplifting to see some efforts being made to return the writing to those Mayan descendants now living in southern Mexico, Belize, and Guatemala, especially since their modern language is what gave the clues to translating the ancient writing. The film follows the beginnings of the efforts to translate the carvings of the Mayans by Europeans during the 1800s, then goes back to the reasons for the loss of the language. From there, it picks back up with the efforts in the 20th century to figure out the complex Mayan language and translate it to better understand the Mayan culture. One of the most fascinating parts of the film is how the invention of the fax machine and the photocopier made such a difference in the speed of understanding. Even before the advent of the internet and its coordination of scientific discovery across the world, these two machines helped researchers to collaborate in their efforts. That cooperation and the use of many minds to make progress is inspiring for the future. And the last part of the video, about the schools in Guatemala that are teaching Mayan writing to its children, is a wonderful use of historical knowledge to help a people connect with the past that was taken from them. All in all, a great documentary to watch for anyone. (2 hour film)

Recommendation

Just to provide a little update on a new podcast I am looking forward to from Vox website. This is the one that I recommended from November, that is a science based podcast on unknown questions of science. I really liked their teaser episode that I linked to in that post, so I wanted to pass on that they are starting up the full podcast on March 10. I am going to embed their trailer here, but check them out on the website if you like weird science.

Podcast Recommendation

There are a number of podcasts on Vox that I have listened to, and The Land of the Giants is one of the better ones that I really enjoyed. The second season of 7 podcasts investigates the rise of Netflix and its influence on the movie and TV business. The first episode in the season is about the basics of how Netflix is run, and the next 6 are about the beginning of Netflix, its competition with Blockbuster (and how many people remember all the descriptions about getting videos at Blockbuster!) and then its rise as an independent studio, creating its own media offerings. Each episode is about half an hour, so its less than some other podcasts. I really like how they present the information. I was aware of the basics of the rise of Netflix, but this podcast gave a really good in-depth discussion about what Netflix did and didn’t do to affect that rise. The last episode is about the streaming wars, so it brings it up to the present day. This is the second season in the series, the first was about Amazon. I haven’t listened to that set of episodes, but I will catch up at some point. Overall, a really good podcast to learn about the rise of some of the big companies today. (The embed below is the introduction to the second season about Netflix. The link to Vox is here to listen to the full podcast, it is the second listed. You can listen to them on the Vox website, but realize that at the end of each episode the next one up goes backward, not forward. Not sure why they do that. If you want to listen on Spotify, here is the link.)

I Love Astronomy

When I was in college (the first time) I seriously thought about going into astronomy as a career. My main problem is that math is just not a great subject for me. It is possible that I could have really worked on that weakness, but I decided to go in a different direction. So all my interest in astronomy and space (honestly, I’ll keep up with most of the physical sciences, and half of the social sciences!) goes into reading about the latest discoveries, and occasionally pulling out my 6 inch Dobson telescope. I watch for the newest headlines in Science News magazine, which gives me a good overview of all the main disciplines. The latest updates on the Webb telescope, the planetary discoveries about Jupiter, Saturn, and exoplanets, and the information coming from the New Horizons spacecraft are all fascinating to read about. So I was excited to listen to a new podcast from the Vox website called Unexplainable. This was the intro podcast for a hopefully new series about different science questions. This one is quite good, so I hope they keep doing them. It is on the discovery and on-going questions about dark matter. If you haven’t heard about dark matter, it is one of the really frustrating questions that science is trying to figure out, but just hasn’t had any success answering yet. Apparently, the observations of the visible matter in the universe seems to indicate that we are missing more than we are seeing. This podcast does a good job of getting across the questions that make science both so very interesting, and also something that some people really don’t like or understand about scientific discovery. Most people really want a final answer, they don’t like the idea that there will always be more to learn, and sometimes that knowledge will completely change everything you thought you knew. But that is exactly what science does, it constantly asks questions. This podcast about dark matter really gets at that fundamental property of scientific inquiry, and as a bonus, talks about the woman astronomer who pushed the idea of dark matter to the forefront of astronomy, Vera Rubin. If you are at all interested, have a listen! (And look, I figured out how to embed a podcast, yay me!) If you prefer to read your podcast, here is the link for the Vox website. The text version does have some pretty nifty graphics and pictures.

Back to Top
css.php