How do I recreate an interactive Excel title?
December 14, 2021 12:00 AM
I cannot find the .awt file for an Excel title. I have the output. It was create before my time. I'm not sure how to recreate it. I have an outline of the tasks that were covered and the active published title.
Solutions (4)
@rcollins96 Is the Excel file a quiz file or an entire course? I also ask like @carlfink ~ is this a Lectora file?
Hello Roberta. From your support ticket, we found the error of why your course is not completing:
We also made some suggestions for the course structure:
Better on Page 3 to have a button that takes you to a Page 4 that says something like "Congratulations! You completed the course!". On this Page 4, have an "On Page Show" action that modifies the completion variable. Have another button to open the attachment. Have a third button to exit the course. That way, regardless of what the user does on this 4th page, they will have their completion status set properly. If they don't open the attachment or close the window, the variable is already set.
If you leave it the way it is, the user won't get proper course completion status if they do not click the current button on Page 3.
The .awt file is necessary to open a project in Lectora. If you have the published project, you will be able to view the course while recreating it. Copy paste for text will work, and any images should be found in the \images folder of the published course. We can suggest our Custom Dev team or we also have a whole series of pre-built courses on using Excel. This may be a great solution as these are quite comprehensive and ready to go.
Tried uploading .awt file but I get file format is not allowed.
In Lectora, you can export the course as a Zip file. This combines all the many files that are part of a project into one, and makes sure that you send the complete course.
Discussion (13)
The .awt file is necessary to open a project in Lectora. If you have the published project, you will be able to view the course while recreating it. Copy paste for text will work, and any images should be found in the \images folder of the published course. We can suggest our Custom Dev team or we also have a whole series of pre-built courses on using Excel. This may be a great solution as these are quite comprehensive and ready to go.
Are you sure the course you are trying to create was made in Lectora originally?
@rcollins96 Is the Excel file a quiz file or an entire course? I also ask like @carlfink ~ is this a Lectora file?
Answer to question is that it is a entire course. However, I have since found a MS Excel resource file that will suffice. It's an Excel spreadsheet with training tabs on multiple tasks. How can I use the Excel file as a course? I created the file, however, it says my A001 is missing a score Test or Modify Variable for either AICC_Lesson or AICC_Score. I do have an action for AICC Lesson.
Tried uploading .awt file but I get file format is not allowed.
Tried uploading .awt file but I get file format is not allowed.
In Lectora, you can export the course as a Zip file. This combines all the many files that are part of a project into one, and makes sure that you send the complete course.
My apologies. I may not have communicated my need. I have an Excel file that I want to have in a course. The course is 4 pages with the Excel file accessible via a link on page three. I'm not sure if this was the best way to create as it really is just a resource but we want to keep track of how many view. Yet, it is not exiting and closing properly. Can I upload my awt file somehow?
Can you look at why it isn't ending correctly?
Depending on your LMS, you can actually turn the Excel file itself into a course. In the Success Factors LMS, which is what my company uses, you could then track who had launched it (but not which tabs they had visited or whether they had completed any particular activity). Note that launching from within a Lectora class would not necessarily be trackable. If you're using Tin Can/xAPI, you could track anything you want, of course.
If you wanted to hack it in SCORM, you could define a quiz in Lectora that is recorded by your SCORM-compliant LMS, and then just set the student's score with an Action when the course starts, say to zero. Put an Action on the button that launches the Excel sheet setting it to 100%. Now you can track whether the student launched the Excel workbook in LMS reports.
I am using AICC.
Same applies. You could fake it by having an (invisible to the student) pseudo-quiz that records a different score when the student launches the Excel sheet.
Hello Roberta. From your support ticket, we found the error of why your course is not completing:
We also made some suggestions for the course structure:
Better on Page 3 to have a button that takes you to a Page 4 that says something like "Congratulations! You completed the course!". On this Page 4, have an "On Page Show" action that modifies the completion variable. Have another button to open the attachment. Have a third button to exit the course. That way, regardless of what the user does on this 4th page, they will have their completion status set properly. If they don't open the attachment or close the window, the variable is already set.
If you leave it the way it is, the user won't get proper course completion status if they do not click the current button on Page 3.