Compléter
Learn the basics of spreadsheets for teachers.
1
Formula Bar
Columns
cell address
Rows
Cells
Spreadsheets
like
Microsoft
Excel
and
Google
Sheets
are
powerful
tools
for
teachers
.
In
this
module
,
you'll
learn
the
basics
of
using
spreadsheet
software
to
organize
and
manage
classroom
information
?
such
as
tracking
attendance
,
recording
grades
,
or
planning
group
activities
.
are
the
individual
boxes
where
data
is
entered
.
run
vertically
and
are
labeled
with
letters
(
A
,
B
,
C
.
.
.
)
.
run
horizontally
and
are
numbered
(
1
,
2
,
3
.
.
.
)
.
The
intersection
of
a
row
and
column
is
a
(
e
.
g
.
,
A1
)
.
The
shows
the
contents
or
formula
of
the
selected
cell
.
2
easy
manage
data
data
gradebook
the
copying
efficient
You
will
learn
how
to
enter
data
into
a
spreadsheet
for
various
classroom
purposes
.
You
can
input
text
for
student
names
or
subjects
,
numbers
for
scores
or
counts
,
and
dates
for
submissions
or
attendance
.
Using
headers
in
the
first
row
helps
organize
the
clearly
.
You
will
also
learn
how
to
edit
cells
by
double
-
clicking
and
delete
content
with
Delete
key
.
Autofill
allows
quickly
,
making
your
and
to
.
3
column width
italic
font style
row height
color
bold
underline
size
A
well
-
organized
spreadsheet
enhances
clarity
and
professionalism
.
To
improve
your
gradebook
,
start
by
selecting
headers
and
using
the
Home
tab
to
change
,
,
and
.
Applying
,
,
or
helps
emphasize
key
data
.
Center
alignment
is
useful
for
titles
or
labels
,
making
the
spreadsheet
easier
to
read
.
Adjusting
or
prevents
text
from
getting
cut
off
or
squished
,
ensuring
all
information
is
visible
and
accessible
.
Small
formatting
changes
can
make
a
big
difference
in
data
presentation
.
4
AVERAGE(B2:D2
SUM(B2:D2
auto-fill
scores
grades
Formulas
are
essential
in
spreadsheets
for
calculating
student
efficiently
.
By
using
=
)
,
you
can
add
from
different
subjects
like
Math
,
English
,
and
Science
to
find
the
total
.
To
determine
the
average
score
,
use
=
)
.
The
feature
allows
you
to
copy
these
formulas
down
the
column
quickly
,
saving
time
and
maintaining
accuracy
.
When
scores
change
,
the
results
update
automatically
,
making
grade
management
simple
and
reliable
.
This
method
helps
teachers
instantly
calculate
total
and
average
grades
,
reducing
errors
and
enabling
quick
performance
analysis
.
5
Bar Chart
colors
Insert tab
label axes
In
Excel
,
creating
a
basic
chart
involves
highlighting
relevant
data
such
as
student
names
and
average
scores
.
Then
,
go
to
the
and
select
a
,
choosing
a
style
that
suits
your
needs
.
Customizing
the
chart
allows
you
to
add
or
edit
the
title
,
change
for
clarity
or
emphasis
,
and
for
better
understanding
.
These
visual
tools
help
educators
analyze
student
performance
quickly
and
effectively
,
making
data
presentation
more
engaging
and
informative
.
6
templates
OneDrive
Desktop
Save As
Opening
Effective
spreadsheet
management
involves
saving
your
work
properly
,
opening
files
efficiently
,
and
reusing
for
future
tasks
.
To
save
your
spreadsheet
,
click
File
>
,
choose
a
location
like
or
,
enter
a
file
name
,
and
click
Save
.
a
file
can
be
done
through
File
>
Open
or
by
double
-
clicking
the
file
in
its
folder
.
Reusing
a
file
is
simple
with
Save
As
,
which
helps
create
a
new
version
.
These
skills
help
keep
your
data
organized
and
secure
.
7
management
data
cells
educational
Excel interface
Congratulations
on
reaching
the
final
module
of
the
Excel
for
Beginners
series
.
This
recap
consolidates
key
skills
such
as
navigating
the
,
entering
and
editing
data
,
formatting
for
clarity
,
using
formulas
and
functions
,
creating
charts
and
graphs
,
and
managing
spreadsheets
.
These
skills
help
educators
organize
student
data
,
visualize
performance
,
and
streamline
classroom
tasks
.
Mastering
these
concepts
boosts
confidence
and
efficiency
in
handling
various
activities
,
making
your
teaching
more
effective
and
organized
.
|
Fill in the blanks to complete the Preamble.
Complete the lyrics of the song with the words that appear on the right side