New ASU ULC: CIS 308: Advanced Excel in Business

[rachel83az]

LibreOffice isn't going to work. At all. Go to XAMK (https://www.xamk.fi/en/openstudies/), pick a course, and sign up. That WILL give you access to Office.

Until that happens, you should be able to access the online version at least: https://www.office.com/

[jch]

CIS308 has THREE exams. I can't tell which are proctored or if they all are.

The syllabus doesn't indicate that there is any proctoring at all that I have seen thus far, but that doesn't mean there isn't. You also have to provide your own Excel license/copy, which may or may not be inconvenient for some.

Many schools provide Office 365 Application licenses to active students, including Strayer and Clackamas. Unfortunately, ASU ULC and TESU seem to have only office online access, not the full computer programs.

[Dodecagram]

CIS308 has THREE exams. I can't tell which are proctored or if they all are.

The syllabus doesn't indicate that there is any proctoring at all that I have seen thus far, but that doesn't mean there isn't. You also have to provide your own Excel license/copy, which may or may not be inconvenient for some.

Many schools provide Office 365 Application licenses to active students, including Strayer and Clackamas. Unfortunately, ASU ULC and TESU seem to have only office online access, not the full computer programs.

I don't think ASU ULC gives free online access either, or at least I don't seem to have it (unless I am missing something unobvious). I will sort something out, but it did seem worthy of pointing out as the course description and instructions direct you to the ASU Office365 to log in to access the program. I suspect they just haven't updated the instructions for the ULC format.

[Dodecagram]

I did find that an older version of Excel (Excel 2016) does work, although there are some differences the course does seem to acknowledge them in the instructions. Luckily my Pierpont student login became active today and it looks as though it comes with Office365 access, so I should be fine for the duration of this class.

Thus far it seems like instructions to create a workbook followed by a quiz on the contents and display of cells in the file you created from the instructions. Multiple attempts allowed on quizzes, and it seems that so far once you complete one section you can move on to the next without having to wait so it seem pretty self paced. I haven't made it to the first exam yet.

[jch]

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.

[Ditto]

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).

[jch]

Yep, I'll be converting this for credit eventually. Any guesses as to the TESU equivalency?

[Ditto]

Yep, I'll be converting this for credit eventually. Any guesses as to the TESU equivalency?

No, sorry, I have no idea about TESU equivalency. I'm local to ASU and for a long time, I've been toying with the idea of getting a degree from ASU. I view the ULC program as a way to fulfill requirements (even if just for residency credit) on an accelerated timeline and in a way that allows me to continue my day job. Maricopa County community college tuition is $85/credit hour (plus $15 semester registration fee), but add in the books and a stricter time requirement--ULC becomes cheaper.

[MNomadic]

Quick question for you "Excellerators," what kinds of grades did you get? Was an "A" achievable with the current state of the course and your pace?

[Ditto]

Quick question for you "Excellerators," what kinds of grades did you get? Was an "A" achievable with the current state of the course and your pace?

Ha, love the word pun.

I believe I got a 98.xx%. As jch writes, "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."


This 85%+ exam score is true for the final exam as well. A student posted in the class discussion of having failed the final and now having a 90, and wanted to know what to do next. The professor instructed the student to re-take the exam until a grade of 85% on the final was achieved. 

I myself re-did all exercises (90%+ is for exercises and quizzes, 85%+ for exams) and quizzes until a grade of 100%. I liked that there was a large bank of questions so that I saw mostly different questions each time. It was more practice and learning for me! For the final exam, I got an 85% (I believe I missed one question that was worth 15 points) and I was very satisfied with my result. 

On an unrelated note, I went back to look at the course description and something has been added and bolded---Microsoft Excel is required for this course and not provided by ASU.