01-27-2022, 01:12 AM
(01-26-2022, 09:16 PM)jch Wrote: I just finished CIS308 early this morning. Here's my review:
Unlike earlier ASU EA/ULC offerings, which use edX, this course runs on Canvas. You still log in at welcome.ea.asu.edu just like before. Note that you won't be redirected to the proper ASU login portal if your session expires. Instead, you need to go back to the ULC dashboard. Access to the Canvas student mobile app is enabled; use the QR code generator on the account page to set it up.
This course requires the complete Excel application on a computer. Office Online, Google Sheets, or LibreOffice will not work. This course's videos and main instructions all pertain to Windows PCs, but there are usually also alternate keystrokes for Macs. Many institutions furnish their students with free Office 365 subscriptions, including the full Microsoft Office suite. Go to office.com and log in with your student email address to access this. Then, click the install office button near the upper right of the screen. I successfully used my Clackamas Community College account.
Dual monitors are absolutely imperative for this course. You'll need one screen for Excel itself and one for the exercise instructions and questions. Without multiple displays, you'd likely switch between windows at least 5,000 times and drive yourself crazy trying to remember the input data while correctly following the instructions.
The course structure contains exercises introducing skills and features, quizzes testing your knowledge about excel, and non-proctored exams applying that understanding on your own. The course forces you to attempt everything in order; you cannot skip ahead to view later content.
Each exercise is a PDF document outlining dozens or hundreds of steps illustrating several Excel tasks. Some start from a blank file, while others begin with an example workbook. Most exercises also include short videos demonstrating related concepts. Then, there's a set of ten questions verifying your resulting workbook or asking about the experience. Be sure to save your files, as some of the later exercises will use your previous work as a starting point. You may also want to refer back to prior work from time to time. Unlike the standard version of this course, students do not submit their work for grading. Ignore any stray references to this in the course material. Note that you don't necessarily have to do everything entirely or precisely because you're not uploading or turning in your Excel files. However, this could come back to bite you later. The course automatically drops your worst exercise. I strongly suggest saving this for the final activity, as number 21 is challenging.
Knowledge is validated further in the module quizzes. Then, the exams present a scenario in a downloadable Excel file that you need to complete according to provided guidelines. Like the exercises, students then answer questions from the finished workbook.
All questions throughout the course are multiple-choice or true/false. Students must score at least 90% on the module quizzes and 85% on the exams to proceed in the class. You always see incorrect answers, but only exercises reveal the correct ones. There is a sizeable question pool, and only a few of the same questions will show up again on subsequent attempts.
Unlike the edX ASU ULC courses, the modules and assignments are not time-restricted. You can access and submit anything anytime during the eight-week course period. I did almost the entire course during week two. Despite the syllabus, there are no restrictions or penalties on late work. The due dates are only suggestions to stay on track.
It appears that ASU hastily adapted this course for the ULC program, starting with a copy of their traditional course material. They left many issues in the wake. The course information and syllabus contain incorrect details, referencing file submissions you won't do and due dates that don't apply. Exercises each have a handful of errors, such as leaving out a crucial keystroke or listing the wrong sheet. More broadly, there are significant issues with content coverage and assessment alignment. Exercises typically instruct you to simply click or type something without explaining what, why, or how. Then, later activities and assessments expect a thorough understanding of those topics. Several steps in the learning process were missed; the brief concept exposure fell fall short of actual competency. Also, I found major issues with quiz and exam questions not addressed by the course material. I alerted the course team to some of the most egregious examples, but there were many more things with poor or no coverage. Ultimately, I would recommend staying away from this course until ASU addresses the quality.
Despite this course being new to ULC, the content appears somewhat outdated. The videos and instructions were recorded on an older version of Windows and Microsoft Office, resulting in numerous interface changes. I was often flustered trying to find a menu or option now in a different place or under a changed heading.
As with most ASU ULC courses, the provided time requirements are a gross exaggeration. Students in this course are told to expect 18 hours per week. In fact, I completed the entire course in just over 18 hours! With some of the other ASU courses, I could see how students could take that much time if they wanted to. Thoroughly reviewing the readings, watching all lectures, and maintaining comprehensive notes requires many hours. However, this course has very little substance to it. There isn't nearly enough material to occupy that much time. Even if you wanted to do more learning or reviewing, there isn't any material for that.
Going into this course, I was a bit intimidated by the course description. I've used Excel less than any other office application by far. Before college, I hadn't worked with it much at all. Last year, I gained some experience through the formulas and formatting in CIS105 Computer Apps at ASU and the data structures in CIS111 Intro to Relational Databases at Strayer. Then, I gained more comfort performing mathematical operations with spreadsheet formulas in SES106 Habitable Worlds at ASU. I think students should definitely have some Excel exposure before taking CIS308. ASU's CIS105 may be enough if you follow along with all of the optional challenges. Thanks to my prior orientation, the first few modules of this course felt very basic.
About at the midway point, things take a turn. The course jumps right into complex macro programming. Completing CIS110 Computer Programming Design last year at Strayer was critical to my success. Knowing basic programming concepts is essential to survive the final modules in CIS308. This includes variables, functions, conditionals, and loops. The course does offer some explanations and demos, but students new to programming are likely to find themselves totally lost.
I'll post a version of this over in the review thread eventually.
Even if the CIS308 credits don't apply in my TESU BSBA-CIS, I'm happy to have this done. Excel is a critical skill for business administration, and I lacked proficiency. Now, I am aware of what Excel can do and how to employ it.
Will you be converting this course to credit?
I also powered through the course and I finished last week, because once you finish one exercise...you may as well move on to the next. I used Excel365 on my Windows laptop and accessed the course through my Macbook. If you do not have two monitors or a similar setup, then download the exercises (they're PDFs) and put them on a tablet or print them out. Because yes, flipping back and forth will drive you crazy. I had zero issues with my version of Excel, but a few people on the forum cite difficulties with using a Mac.
I appreciate this course since I feel that it gave a good overview of the features and capabilities of Excel (example, running a regression, using the camera, VBA).