Computer and Information Sciences
- Page ID
- 216857
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\dsum}{\displaystyle\sum\limits} \)
\( \newcommand{\dint}{\displaystyle\int\limits} \)
\( \newcommand{\dlim}{\displaystyle\lim\limits} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\(\newcommand{\longvect}{\overrightarrow}\)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)Computer and Information Science
AutoCAD
I am teaching CAD 153 (Intermediate AutoCAD)
I am looking to find projects whereby I may use our 3D printer in this CAD course.
The highlight of CAD 153 is creating CAD drawings that use GD&T (Geometric Dimensioning and Tolerance). GD&T created prints are used in manufacturing. This ensures that manufactured products adhere to specific dimensions and tolerances.
Since our CNC machine class is not running this semester, I was hoping to use our 3D printer as a substitute.
If you haven't yet done so, you might want to check Skills Commons. Below is one of the resources I found:
CAD 262 3D Printing
Provides the student with the ability to blend the virtual and real design worlds together through the use of 3D Scanning, 3D CAD Modeling, and 3D Printing.
C++
For C++ specifically, there is:
Programming Fundamentals - A Modular Structured Approach using C++
There is now a second edition of that resource that includes matching examples in C++, C#, Java, JavaScript, Python, and Swift. See:
Programming Fundamentals - A Modular Structured Approach, 2nd Edition
There are also plenty of free but not open programming language resources available online. SoloLearn is very good. I also recommend FreeCodeCamp, W3Schools, and TutorialsPoint.
Computer Concepts and Applications
Hi, I am looking for resources for our Computer Concepts / Application course that is a general overview of technology and focus on MS Word, PowerPoint, Excel and Access. What resources are you all using? Our current textbook is over $250 and we NEED to replace it! Thank you!!
I searched MERLOT for free books on Computer Concepts. Here is the hit list you can look at. Obviously, not all are what you are looking for, but you might find something.
https://www.merlot.org/merlot/materials.htm?fromAdvancedSearch=true&keywords=Computer+Concepts&categoryBasic=&partnerId=&_partnerOnly=on&materialType=13&_audience=on&_audience=on&_audience=on&_audience=on&_audience=on&_audience=on&_audience=on&_audience=on&_hasPeerReviews=on&_hasEditorReviews=on&_hasComments=on&_hasRatings=on&_hasAssignments=on&_hasCollections=on&_hasCourses=on&_hasSercActivitySheets=on&_hasAwards=on&_isContentBuilder=on&_hasEtextReviews=on&_hasAccessibilityForm=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_technicalFormat=on&_mobile=on&_mobile=on&_mobile=on&_mobile=on&ccOrZero=&cost=&codeAvailable=&language=&cefr=&dateRange=0&days=7&createdSince=&createdBefore=&sort.property=relevance
Also consider:
https://en.wikibooks.org/wiki/Introduction_to_Computer_Information_Systems
https://en.wikiversity.org/wiki/Information_Systems
https://courses.lumenlearning.com/wmopen-compapp/
https://www.valleycollege.edu/open-education-resources/faculty/cit.php
http://gcflearnfree.org/
https://www.excel-easy.com/
Hi Matt, because this type of course has three different prefixes in Oregon, I'm going to send you three links to see what's being used here.
http://openoregon.org/resources/?keyword=cs%201
http://openoregon.org/resources/?keyword=cis%201
http://openoregon.org/resources/?keyword=cas%201
To add to the already stellar list!
Here is what my IS people sent for consideration
https://open.umn.edu/opentextbooks/BookDetail.aspx?bookId=189
This is the youtube channel for one of the IS instructors.
https://www.youtube.com/channel/UCAs0lGneIASLbfLj6ADzf1A
Also if he wants to chat IS to IS Harry Hammerling one of our IS instructors would be happy to talk.
harry.hammerling@scccd.edu
An instructor teaching the courses below wishes to go OER. If you know any textbooks or other resources that might work, please email me directly at sda...@coastline.edu. I'll compile a list and send it back out to the listserv.
Thank you!
Scott Davis
OER coordinator, Coastline
***
CST 232 Ethical Hacking
This course is a survey of the ethical and legal issues pertaining to security testing. It will demonstrate how to use tools that can be used to gain information about a computer network, how to recognize that the tools are being used, and how to defend a network against those attacks.
CST 245 Computer Forensics
Introduction to Computer Forensics Investigations. The class will cover such topics as how to recognize that a computer crime has occurred and steps follow when acquiring, authenticating, and analyzing data on a compromised system. Hands-on portion will explore the use of several Computer Forensics
tools.
CST 260 CISSP
This course covers the ten domains of information security known as the CISSP Common Body of Knowledge (CBK). Completing this course does not guarantee CISSP certification; however, the course addresses the test objectives defined by (ISC)2 for the CISSP examination.
The only real *free* things I know are videos on http://www.securitytube.net/ and if local libraries (or your college) has a subscription tosafaribooksonline.com (my local library does, and many universities do, I highly recommend it), they have some decent CISSP books too.
My suggestions for OPEN (OER) for computer science and networking is to take a search at the Saylor.org site. All of their materials have a creative commons license so are OPEN. They have at least 20 Computer Science courses from Intro to Computer Science, Programming in C++, Datbases, Networking, Information Security, Cryptography, etc. https://learn.saylor.org/course/index.php?categoryid=9
All of these materials can be re-used freely. Here is more information about their OPEN policy:
http://www.saylor.org/open/
The second suggestion would be to search SKILLS COMMONS. This is the OER Repository for the TAACCCT grants which were all community college grants targeted at career retraining and requiring material developed to be OER. In some quick searching I found this course developed by David Rigor at Moraine Valley Community College. The materials have a Creative Commons License Attribution or the least restrictive license allowing you to reuse, remix, revise, retain, redistribute.
https://www.skillscommons.org/handle/taaccct/5382
Maybe the Cybrary is worth a look. Not textbooks but lots of resources.
Do any of you know any OER or perhaps free resources for learning code and creating apps?
Apple has just released a free, open source coding curriculum for Swift, their IOS programming language. HCC is offering this training now: http://hccs.edu/coders
Here's the link to the Apple "Everyone Can Code" site, https://www.apple.com/everyone-can-code/ , which includes links to learning more about their free "Get Started with Code" curriculum as well as learning more about their "Swift Playgrounds" curriculum and their "Apple Development with Swift" curriculum.
I also came across a "Game Development and Programming for Beginners" course, CC BY SA, in OER Commons, here at https://www.oercommons.org/courses/001-beginner-gamedev-coding (abstract begins: "How to make a game app from scratch?")
I was wondering if anyone has found Creative Commons licensed resources for instruction of Microsoft Office 2013 (or newer). I think GCFLearnFree is a great resource, but it is not technically OER (and won’t work for our Z Degrees) without that CC license. I did find an open textbook for Excel, but that is about it. Lumen’s Information Literacy course does have some Microsoft Office information, but in the form of video tutorials. Is there anything else out there?
Lumen actually has a brand new open course in this area - https://courses.lumenlearning.com/wm-compapp/ . Much of the content is original. All the original content is CC BY. The content is fully attributed.
In addition to the static content available at the link above, there's also a Waymaker version of the course available. (If you don't know what that means, see http://lumenlearning.com/what/waymaker/ .)--
I have an instructor who is hoping to find OER for the course we call Microcomputer Operating Systems. It is a 100-level course. I am finding some okay sources to cover bits and pieces, but keep thinking I must be missing something! If anyone knows of an instructor using OER for a course like this, I’d love to see what they’re using. Thank you!
We used to teach an operating systems course similar to that. We updated it / replaced it with IT Fundamentals, a course that targets the CompTIA entry-level certification of the same name.
For an OER course on IT Fundamentals, see:
https://en.wikiversity.org/wiki/IT_Fundamentals
It typically shows up as #3 on a Google search for that topic, ahead of any other textbook on the subject. CompTIA called me once asking about the course. They recommend it themselves if they have someone who can't afford to buy their materials.
As an adjunct, I teach a course called “Computer Concepts and Applications” that most, if not all programs require (it’s the general tech ed requirement). I am considering the possibility of creating an OER textbook (or at the very least review/study tool) to replace the $200 plus textbook that most instructors (including myself) use.
The outline (and our college’s course requirements) are listed in this Google Doc. Any feedback, suggestions, ideas, etc. would be greatly appreciated. (i.e. should this be a textbook or supplemental guide, would you like to see specific topics I don’t have listed, should I remove topics listed…)
https://docs.google.com/document/d/18JuL8EKIR0iKTVskU6NH293ECJEzU--arDxvaijOzbE/edit?usp=sharing
Should I choose to move forward with this project, and you would like to lend assistance and/or provide feedback at the end of the project, let me know! I’ll compile a list and make notification; should this pan out. Of course, I will provide the final product to this listserv for everyone to use, should they desire. Go ahead and email me individually rather than a reply all/reply to the listserv.
There are a few openly licensed courses already in use in Oregon that you might be able to use as a starting point:
http://elearning.linnbenton.edu/course/view.php?id=3130
https://bluecc.instructure.com/courses/516
https://elearning.linnbenton.edu/course/view.php?id=3979
Related readings that are being used in Oregon:
http://computerscience.chemeketa.edu/cs160Reader/
https://opentextbc.ca/dbdesign01/
A colleague is looking for OERs for two CIS courses:
Introduction to Windows
and
Google Applications
We are currently harvesting a resource in the LibreTexts that can help (from Minnesota) as part of a great CIS OER we are building for Los Rios CC district:
https://workforce.libretexts.org/Under_Construction/Book%3A_Computer_Fundamentals_for_Technical_Students_(Heisserer)
We are still polishing for accessibility, cross referencing to the centralized framework, and adding the dynamic glossary, but it should be good to go.
All the pages are fully remixable as OER should be.
Here are two course shells created in Oregon that are relevant: http://openoregon.org/resources/?keyword=windows
I’m seeking resources for a course called Technical Computer Applications.
Course Description: An introduction to computers, elements of computer hardware and software and how they are used in the workplace, and the social impact of computers.
Hands-on introduction and development of general computer skills for technical programs such as word processing, spreadsheet, presentation applications, and email.
SLOs:
Create and modify files using Microsoft Office programs.
Analyze the formatting needs of a specific Microsoft Office file to improve its appearance.
Identify the appropriate software applicable to their trade industry and explain its use.
Hi Sally, you might check out this open course shell from Oregon: https://bluecc.instructure.com/courses/516
Agreed on GCF Global. For a course designed around GCF Global learning activities, see
https://en.wikiversity.org/wiki/IC3
1. On windows, there’s this one:
https://www.oercommons.org/courses/basic-computing-using-windows/view
2. Computer Applications for Managers:
https://acrobat.adobe.com/link/review?uri=urn:aaid:scds:US:36a3c59a-b352-4e1e-9b47-752b70f7349d#pageNum=1
3. Computer Fundamentals for Technical Students. I believe I sent this one already but … this is for Windows and basic IT stuff:
https://acrobat.adobe.com/link/review?uri=urn:aaid:scds:US:0ce16585-8fd7-46bf-9edf-ff46d1844e3f#pageNum=1
I'm working with a faculty member to determine what would be involved in getting her course to zero-cost and the sticking point
appears to be the need for SAM365.
It is described as follows:
SAM Challenge 365/2019 is an Exam only assessment tool that tests essential Microsoft Office and computer concepts skills
at the pre and/or post-assessment stage to assess your students level of proficiency, prior to enrollment,
on the first day of class or at the end of the course. Students engage in a hands-on environment, then apply their skills to real-world applications.
Auto-graded assignments and flexible reporting tools saves instructors time and energy.
I use GFC Global. It is not the same as SAM365. However, you can have students complete the quizzes at the end of each training through their
GFC Global accounts and submit their final scores. Example: There are 35 tutorials for Microsoft Word and a final tutorial quiz.
I also use it for assignments, but I have to grade those.
If anyone has a better tool or way to implement GFC Global better, I would love to hear your ideas.
Later this year, OpenStax is releasing a new free, online, peer-reviewed, openly licensed textbook named Workplace Software and Skills.
This textbook is designed to support a variety of courses covering computer literacy, Microsoft Office, and Google Suite applications.
It also combines studio learning and guided practice with scaffolded activities to equip students with the technological skills
necessary to succeed in today’s workforce.
A sample of the text is available here:
https://openstax.org/details/books/workplace-software-skills .
As with everything, the textbook publishers are getting more and more outrageous to work with.
I have converted all of my courses to OER with the exception of my Computer Concepts and Applications course, because it centers around Office 365.
My ask - I am looking for OER materials for this course which could include Word Processing examples (and problems), Presentation, and Spreadsheets. I can use any application but the book I have used focus on Microsoft products. I am happy to change if needed.
You may find topics you are interested in Computer Applications sub-bookshelf on the LibreTexts Workforce library:
https://workforce.libretexts.org/Bookshelves/Information_Technology/Computer_Applications
We have been working on ways to expand our ADAPT homework system to address this topic. The immediate extension is using the LibreOffice
technology online that is part of our Forge platform. As you know, it is similar in scope to MS products (and more advanced than Google), but not
identical. We have also just started looking at an extension for excel that will grade uploaded xls files, but we are in the infancy of this effort.
OpenStax's Workplace Software and Skills textbook sounds like it'd be a great fit for your course!
It's a business technologies textbook that includes chapters on both Microsoft 365 (Word, PowerPoint, Excel, Access, Outlook, Calendar, and Teams)
and Google Workspace. This free OER book includes practice exercises, case exercises, and dozens of real-world applications.
Explore the book here: https://openstax.org/
Computer Literacy
Does anybody know of an OER or low-cost alternative to MindTap? We have faculty at my school who are interested in switching to a lower-cost option that includes a simulation environment for computer basics and Microsoft Office (i.e. Word, Excel, Outlook) but we have not been able to find a free or low-cost alternative that provides the same type of interactive modules.
Consider using https://edu.gcfglobal.org/en/subjects/tech/ for free tutorials, step-by-step instructions, practice files, videos, etc. Students can get Microsoft Office for free. See https://www.microsoft.com/en-us/education/products/office . The only thing you wouldn't have is the automated grading.
For Mac or Chromebook users who want access to a Windows environment, Amazon AWS has Workspaces available for around $10 per month if used carefully, and several months available as a free trial. Students can also use AWS EC2 instances and get enough credits to use free for the semester or even a year, but EC2 is a bit more complicated to get started.
We are designing a course for our returning adult learners and need to find so basic materials for digital literacy.
Please consider using GCF Global: https://edu.gcfglobal.org/ . The content is excellent and free.
If you'd like to see it organized as a course or as continuing education resources, please see either:
https://en.wikiversity.org/wiki/Computer_Skills
https://en.wikiversity.org/wiki/IC3
You are welcome to borrow from and/or enhance either wiki if you have additional resources or suggestions.
Just a quick reminder that GCF Global is free but not open. You can NOT copy the resources from GCF Global into your CMS/LMS without permission as they are copyrighted. Dave has done a great job in his courses below linking out to the GCF resources which is allowed.
Terms of use can be read here
I am trying to help a faculty member redesign a course that covers MS Office Word, PPT, and Excel.
Students are required to take this course and hate they have to pay so much money to take this course.
They use Pearson’s website and Pearson’s book and this costs the students around 150 dollars.
I would love to be able to find OER materials, so the students do not have to buy the book and pay for access to the Pearson website.
I also need a resource for basic computer literacy for those adult students returning for a degree or returning to finish a degree.
Hi Susan - as a faculty member teaching computers I often use Goodwill Foundations Learnfree Resources -
they are openly available, but not OER https://edu.gcfglobal.org/en/subjects/tech/
They provide videos, sample start files, and step by step instructions. They are also updated with each new version.
I have seen this website as well, but we do not use it based on what they have stated in their terms of use -
https://edu.gcfglobal.org/en/info/terms-of-use/1/ .
I would recommend reviewing this as the way we interpret it,
we are not able to utilize these resources in our LMS and they are really for personal use only.
Our computer course is where we are struggling to find usable and sustainable OER as well.
I wanted to chime in and say that I contacted GCF a few years back when we were creating a course with their content (links out),
and they were okay with that as well as embedding the practice documents into the course. Their terms of use may have changed since then.
I’d suggest reaching out to them and seeing if you can get permission if it’s needed for the way you intend to use their content in class.
I also teach this course. I use the following resources:
Business Computers 365 by Marcus Lacher is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.
Microsoft Office Training and Tutorials:
https://support.microsoft.com/en-us/training?redirectsourcepath=%252fen-us%252farticle%252foffice-training-and-tutorials-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb
Learnfree.org - which was already mentioned.
They have practice exercises that you can download for free - not open - like others have said, but free to use.
Beginning Excel from Open Oregon:
https://openoregon.pressbooks.pub/beginningexcel/front-matter/introduction/
Computer Applications from Lumen Learning:
https://courses.lumenlearning.com/zeliite115/
Computer Applications for Managers:
https://lumenlearning.com/courses/computer-applications-for-managers/
LibGuide from Tacoma CC with some great resources:
https://tacomacc.libguides.com/oer_computers
Excel for Mac Users
Hi all, has anyone created OER on Excel for Mac users?
Lumen: https://lumenlearning.com/courses/computer-applications-for-managers/
GCF Global (free but not open): https://edu.gcfglobal.org/en/subjects/office/ .
I use Office on a Mac, and, to me, the applications aren't different enough to have a separate course. When I teach the office apps, I try to focus on concepts rather than a specific user interface, so students could use any version of Office, or even Google Apps or LibreOffice, if they prefer.
There is one other really good resource specifically for Excel:
Excel Easy (free but not open): https://www.excel-easy.com/
Graphic Design
I've been searching on the list history and I don't see any options for graphic design OER.
I have a faculty member requesting an OER for GD 90: Designing the User Experience
Description:
This course covers user experience design, following the user-centered design process. It is oriented toward practical methods for approaching a design problem holistically, beyond usability and usefulness. It examines different target platforms such as smartphone, tablets, and desktop systems. A user-centric approach is employed to determine which platform is best for the desired application. In this class, students will demonstrate an understanding of user experience including how to design for it and how to evaluate it. This course teaches a set of techniques to gather information about what the user needs, how to design and model interfaces based on those needs and then how to evaluate the design to ascertain that the user's goals are met.
You may find what you are looking for in the design books hosted in the LibreTexts libraries:
https://commons.libretexts.org/?search=graphic+design
While it's not an OER or even a textbook, a resource that I have long considered as absolutely seminal in the field of human-computer interface design is Brenda Laurel's "Computers as Theater."
https://www.amazon.com/Computers-as-Theatre-Brenda-Laurel/dp/0201550601/
Laurel was one of the designers of the original Macintosh interface. She analyzes interface design through the lens of Aristotle's approach to the theory of drama. It is most enlightening. As the senior interface designer on the project to move the venerable PLATO Learning System from DOS to Windows in the late 1990s, I leaned heavily on her insights.
Information Systems
Can anyone recommend good introductory Information Systems textbooks?
I am looking for alternatives to this one:
Introduction to Information Systems (7th edition) Australia and New Zealand Edition.
R. Kelly Rainer & Brad Prince, Wiley, 2019
Which is used for our INFO101 course here in New Zealand. I have identified these so far:
This is an updated & revised edition of Bourgeois (below)
Bourgeois, D. T., Smith, J. L., Wang, S., & Mortati, J. (2019). Information systems for business and beyond. https://open.umn.edu/opentextbooks/textbooks/information-systems-for-business-and-beyond
15 reviews here https://open.umn.edu/opentextbooks/textbooks/information-systems-for-business-and-beyond#Reviews
(c2015). Information systems: A Manager's guide to harnessing technology. University of Minnesota Libraries Publishing. https://open.lib.umn.edu/informationsystems/
6 reviews here https://open.umn.edu/opentextbooks/textbooks/information-systems-a-manager-s-guide-to-harnessing-technology#Reviews
Felvegi, E. (2019). Foundations of Management Information Systems. https://www.oercommons.org/courses/foundations-of-management-information-systems
Felvegi, E., Lave, B., Shingledecker, D., Romey, J., Brown, N., & Schatz, M. (2019). Business Computer Information Systems. https://www.oercommons.org/courses/business-computer-information-systems/view
Judith Thomas just shared this new text release earlier today that might fit your class.
Introduction to Text Analysis: A Coursebook Authors: Brandon Walsh (University of Virginia) and Sarah Horowitz (Washington and Lee University)
I’ve also found these:
Information Systems: No Boundaries
A Tale of Two Systems
and this book Maritime Management - Micro and Small Business for a Canadian audience. We are building the book in Pressbooks, and are including H5P as well as slides. The book should be available by the end of November. We have added new chapters for Decision Support, Emerging Technology and eBusiness. The structure of the book is:
Ch1: Introduction to Info Systems
Ch2: Business Strategy
Ch3: Hardware
Ch4: Software
Ch5: Data
Ch6: Networks
Ch7: Systems Development
Ch8: Security
Ch9: Issues – Canadian perspective
Chp10:e-business
Chp11: Business Process and Enterprise Solutions
Chp12: Decision Support/Business Intelligence
Chp13: Emerging Technology (A.I.)--
Introduction to Computer Systems
Hello All! Our university offers a general education course called Introduction to Computer Systems. The instructors have developed many materials themselves, but they also relying a commercial text (customized) for part of the course content.
Here at Palo Alto College we use two sources to cover the introductory computer classes.
http://www.gcflearnfree.org/ is used for the Application Software
http://www.saylor.org/site/textbooks/Information%20Systems%20for%20Business%20and%20Beyond.pdf is used for the rest.
gclearnfree.org appears to be a good resource, but keep in mind that while it is free it is not open (i.e., it is not OER). If you find something similar that is open please do share with the group.
Hi Julee, a couple of solutions at Oregon community colleges:
Computer Fundamentals - In this course, students will learn basic Microsoft Windows 10 Operating Systems skills (including Core PC Hardware Components, Graphical User Interface, Local and Cloud File Management, Applications, Internet Browsers, Security, and key System Utilities), Google Email, Contacts, Calendar, and Drive applications, as well as introduction to Word Processing, Spreadsheet and Presentation applications. Additionally, students will learn to create and convert documents between different format (Microsoft and Google apps). Moodle course: http://elearning.linnbenton.edu/course/view.php?id=3130
Computer Literacy complete course is available via Moodle. From the link below, select CS120, then log in as guest to access the course. Course description: Students in this course will study computers and their applications (note: this is not a "first" or "beginning" computer course). Student will develop an understanding of concepts and terminology related to computer systems and develop skills and understanding in the use of software. Concepts include an overview of computer systems, system & applications software, networks, the Internet, and societal & ethical issues. Hands-on experience may include intermediate to advanced word processing, spreadsheets, database, graphics, presentation graphics, and web publishing. http://math.bluecc.edu/moodle/
The CS160 reader is a Creative Commons licensed resource used at Chemeketa Community College in Computer Science 160. It aligns closely to the topics covered in the new AP Computer Science Principles course. http://computerscience.chemeketa.edu/cs160Reader/
Introduction to the Internet
A faculty member is looking to replace the textbook she uses for her Introduction to the Internet class.
In this class they cover topics that include: internet browser basics, email communication, search engines, internet & wireless networking security (basics),
creating HTML documents, internet communication tools, social networking tools, and guidelines for conduct online.
I’ve shared with her the two courses I discovered from OpenOregon’s list of resources.
Please see https://en.wikiversity.org/wiki/Internet_Fundamentals .
The course is based on the CIW Internet Business Associate certification and is used by Google Search as the definition of Internet fundamentals.
We have had multiple instructors using this resource successfully for several years now.
Faculty members are welcome to contact me with any questions or requests for test banks, etc.--
Microsoft Office
Since this post is a few years old, I'm wondering if any OER have since been developed. Looking for interactive simulations for Microsoft Office/computer basics.
There are some course shells and other materials created by Oregon instructors that you can check out here: http://openoregon.org/resources/?keyword=microsoft

