Mass
Student Account Creation
Teachers
shall have the option to create student accounts in bulk,
by clicking the second icon in the top menu of the "Students"
content area of the "Teacher Dashboard," as shown
in the first mockup above. Upon doing so, the panel for
accomplishing this task shall appear in place of the "Student
Accounts" table, consisting of a title "Mass Account
Creation," a subtitle, "Create multiple student
accounts at once." and a paragraph below that describes
the process, as well as contains a hyperlink to facilitate
the downloading of the spreadsheet file necessary for the
actual account creation. The information line at the bottom
of this initial state simply reports that "Spreadsheet
will download as a zip file." There's also an "x"
button in the upper right corner for closing the module,
and then a "Select File" button in the lower right,
that the teacher will use to upload his or her saved spreadsheet,
after populating it with student account data.
"To
create multiple student accounts with one action, instead
of each account individually, you may do so by entering
the required information into this spreadsheet, saving it,
and uploading it, via the button below. Please carefully
read the rules for each section. Any data you enter that
violates the rules identified therein will result in upload
failure."
The
Spreadsheet
The
spreadsheet itself will be a Microsoft Excel file, rather
than a csv file. This is so that formatting can be retained,
and show the requirements for each column in the first row,
as shown in the second mockup, above. It should be possible
to write a script (or build from an existing version) that
can parse the information from this single spreadsheet excel
file, into the student account database table for each teacher.
This spreadsheet will have 7 columns, just as the process
for creating individual student accounts on the platform
itself has 7 steps. Only the first and third columns are
actually required, for student account creation. If the
fourth, sixth, and seventh columns are left blank, Readingful
shall populate these cells in the database for the teacher,
by generating the group, username, and password for the
student. Additionally, if the username provided by the teacher
in this spreadsheet is not unique to Readingful, a username
shall be generated for the student instead.
The
actual spreadsheet, as well as an additional text file of
instructions, can be found in the "assets" folder
as readingful_mass_student_account_creator.zip. This is
the zip file the teacher shall download when the "this
spreadsheet" link is clicked.
Uploading
When
the teacher saves the excel file, and selects it via the
"Select File" button, let's show a processing
animation in place of the button, and an updated information
line to show the file is uploading, as shown in the third
mockup, above. Hold this animation for 3 seconds before
proceeding with showing the result.
Successful
Upload
As
shown in the fourth mockup, above, a successful file upload
should report the total number of new student accounts created,
as well as give the teacher a "close" button in
the lower right, for returning to the "Student Accounts"
view of this content section.
"You
have successfully created a total of X new student accounts.
Simply give each student his or her login credentials, to
have them sign in on Readingful’s homepage, and begin
reading. If you’d like to print a listing of all student
credentials in card form, as a quick and easy way to distribute
them to your students, use that option in the menu above."
Succesful
Upload With Probationary Accounts
We
must consider the possibility that a teacher will sometimes
create multiple student accounts via this process for which
he or she hasn't yet paid. In fact, we want this to be a
possibility. As such, if a teacher's mass student account
creation process results in an excess of student accounts,
we'll need to display the alternate success message, as
shown in the fifth mockup above, that simply notifies the
teacher he or she will need to purchase access for the additional
accounts, in order for them to function. Note: This is only
the case if the teacher has an active Readingful subscription
with a current limited number of teacher accounts.
"You
have successfully created X new student accounts. Yet, your
current Readingful subscription only provides access for
X students. In order for all of these new accounts to function,
please be sure to purchase the additional access required
by using the subscription management section of your account,
in the menu to your right, at your convenience."
Succesful
Upload With An Expired Subscription
If
the teacher has a completely expired Readingful subscription
(in which case no student accounts currently have acces
to the program), the message shown in the sixth mockup,
above, should display to the teacher.
"You
have successfully created X new student accounts. Yet, please
be advised that your current Readingful subscription has
expired. In order for your students to be able to login,
and start reading, please be sure to purchase the access
required by using the subscription management section of
your account, in the menu to your right."
Upload
Failure
If
Readingful is unable to parse the data in the spreadsheet
file uploaded by the teacher, Readingful shall display the
notification panel shown in the seventh mockup, above. I
considered providing an output, here, that would identify
the cell that is causing the error. However, it could be
multiple cells, and listing them all could be a lot to show,
visually. After all, this is a fairly simple spreadsheet
to complete, with only two required columns in the end,
and is an ancillary feature, to boot. So, if the teacher
is messing it up, he or she can simply use the individual
account creation process. I think we'll just leave it up
to the teacher to try to figure out his or her mistake,
when one is made.
When
testing this upload process, you should consider that a
teacher may upload a blank file, or a file that contains
unecesary spaces (should be able to strip them out), or
a file that contains more students than the account max
(240). In general, try to anticipate all the ways a teacher
may mess this up, and try to accommodate as much as possible.
"Readingful
was not able to process the file you uploaded. This is most
likely due to one or more violations of the rules outlined
in the instructions that accompanied your download of the
file. Please review that documentation, edit your file,
and try again. If you are unable to proceed, simply create
student accounts singularly using the option above."
Styling
Checklist:
Images:
1.
Teacher Subsection Close Button: close_button_icon.svg,
24 x 24, #E2E8F7 (DUPLICATE, ORIGINAL
SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
2.
Teacher Subsection Close Button Hover: #E2E8F7BF
(DUPLICATE, ORIGINAL SHOWN IN "STUDENT ACCOUNT CREATION"
SPECS)
3.
Teacher Subsection Close Button OnClick: #E2E8F780
(DUPLICATE, ORIGINAL SHOWN IN "STUDENT ACCOUNT CREATION"
SPECS)
4.
Teacher Subsection Processing Animation Component:
processing_dot.svg, 12 x 12,
#6F8AE2 (DUPLICATE, ORIGINAL SHOWN
IN "STUDENT ACCOUNT CREATION" SPECS)
Text:
MOCKUP
1:
1.
Teacher Account Section Title: 3.8
rem, #FFFFFF (DUPLICATE, ORIGINAL
SHOWN IN "TEACHER DASHBOARD" SPECS)
2.
Teacher Account Section Subtitle: 2.0
rem, #FFFFFFB3 (DUPLICATE,
ORIGINAL SHOWN IN "TEACHER DASHBOARD" SPECS)
3.
Teacher Subsection Title: 2.4
rem, #6F8AE2 (DUPLICATE, ORIGINAL
SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
4.
Teacher Subsection Subtitle: 2.0
rem, #B7C7F7 (DUPLICATE, ORIGINAL
SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
5.
Teacher Subsection Informational Text: 1.6
rem, #576082 (DUPLICATE, ORIGINAL
SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
6.
Teacher Subsection Informational Text Hyperlink:
1.6 rem, #4B70E8
7.
Teacher Subsection Informational Text Hyperlink
Hover: 1.6 rem, #4B70E8BF
8.
Teacher Subsection Informational Text Hyperlink
OnClick: 1.6 rem, #4B70E880
9.
Teacher Subsection Infoline Footer Text: 1.6
rem, #BFC6DD (DUPLICATE, ORIGINAL
SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
10.
Teacher Subsection Submit Button Text: 2.2
rem, #FFFFFF (DUPLICATE, ORIGINAL
SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
11.
Teacher Subsection Submit Button Text Hover: 2.2
rem, #FFFFFFBF (DUPLICATE,
ORIGINAL SHOWN IN "STUDENT ACCOUNT CREATION" SPECS)
12.
Teacher Subsection Submit Button Text OnClick:
2.2 rem, #FFFFFF80
(DUPLICATE, ORIGINAL SHOWN IN "STUDENT ACCOUNT CREATION"
SPECS)
13.
Teacher Subsection Submit Button Text Disabled:
2.2 rem, #FFFFFF80
(DUPLICATE, ORIGINAL SHOWN IN "STUDENT ACCOUNT CREATION"
SPECS)
14.
Teacher Profile Name: 2.4
rem, #FFFFFF (DUPLICATE, ORIGINAL
SHOWN IN "TEACHER DASHBOARD" SPECS)
MOCKUP
4:
1.
Teacher Account Section Subtitle Hyperlink: 2.0
rem, #FFBC36BF (DUPLICATE,
ORIGINAL SHOWN IN "TEACHER DASHBOARD" SPECS)
2.
Teacher Account Section Subtitle Hyperlink Hover:
2.0 rem, #FFBC36
(DUPLICATE, ORIGINAL SHOWN IN "TEACHER DASHBOARD"
SPECS)
3.
Teacher Account Section Subtitle Hyperlink OnClick:
2.0 rem, #FFBC3680
(DUPLICATE, ORIGINAL SHOWN IN "TEACHER DASHBOARD"
SPECS)
4.
Teacher Subsection Infoline Footer Hyperlink: 1.6
rem, #BFC6DD
5.
Teacher Subsection Infoline Footer Hyperlink Hover:
1.6 rem, #6C96FF
6.
Teacher Subsection Infoline Footer Hyperlink OnClick:
1.6 rem, #6C96FF80
Objects:
1.
Teacher Subsection Submit Button Background: Variable
x 50,
#6C96FF (DUPLICATE, ORIGINAL SHOWN
IN "STUDENT ACCOUNT CREATION" SPECS)
2.
Teacher Subsection Submit Button Background Hover:
Variable x 50,
#6C96FFBF (DUPLICATE, ORIGINAL SHOWN
IN "STUDENT ACCOUNT CREATION" SPECS)
3.
Teacher Subsection Submit Button Background OnClick:
Variable x 50,
#6C96FF80 (DUPLICATE, ORIGINAL SHOWN
IN "STUDENT ACCOUNT CREATION" SPECS)
4.
Teacher Subsection Submit Button Background Disabled:
Variable x 50,
#6C96FF80 (DUPLICATE, ORIGINAL SHOWN
IN "STUDENT ACCOUNT CREATION" SPECS)
|
